Here’s another terrific submission from Burbed reader sfbubblebuyer, who takes the front page again today as Guest Blogger.  We’re going back to one of our favorite sources for the quintessential Burbed residence: Redwood City!  Alas, the house has sold since it was submitted, but it’s still worth admiring!

Please give sfbubblebuyer your best, warmest Real Bay Area welcome!

677 HAMPSHIRE Ave, Redwood City, CA 94063
$249,900

BEDS: 3
BATHS: 1.5
SQ. FT.: 1,080
$/SQ. FT.: $231
LOT SIZE: 5,000 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STYLE: Cottage/Bungalow
STORIES: 1
VIEW: Neighborhood
YEAR BUILT: 1940
COMMUNITY: Dumbarton
COUNTY: San Mateo
MLS#: 81058792
SOURCE: MLSListings
STATUS: Sold

Open and bright home with well used space. Formal entry/foyer, living room is spacious, eat-in family kitchen, nicely fenced with a gated long driveway leading to detached garage. Location is convenient and close to school and school grounds. Good opportunity to own a home.

The best thing about this piece of crap is that TWO Redfin agents have toured it. One notes the mold in the bedrooms which is easily visible in the photos, and the other one notes a “shed-like structure in backyard.” Not a shed, a shed-like structure. OoooOOOH! What a mystery!

I must find out more about this shed-like structure! Perhaps it is the entrance to Batman’s west-coast secret base! Maybe it conceals a nuclear missile launch bay! Who knows? Because it’s not a shed, but a SHED-LIKE STRUCTURE!

If we move on to the listing agent, they want to make it absolutely clear that not only is this house close to the a school, it’s also close to the ground on which the school is located!

What a relief! I was afraid this house was in some Esheresque void in Redwood City where you can reach up and touch the school, but to get to the GROUNDS, you needed to climb dozens of space warping staircases to navigate your way there.

Today’s featured listing is from Burbed reader Tuno!  Thanks very much for this this fab find, the kind of listing that this site is famous for!

442 1st Ave, Redwood City, CA 94063
$219,722

BEDS: 2
BATHS: 1.5
SQ. FT.: 810
$/SQ. FT.: $271
LOT SIZE: 6,975 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STORIES: 1
VIEW: Neighborhood
YEAR BUILT: 1952
COMMUNITY: Dumbarton
COUNTY: San Mateo
MLS#: 81054683
SOURCE: MLSListings
STATUS: Pending With Release
ON REDFIN: 170 days

Huge Yard. Smaller home and its rented right now. Great income property they rent out part of the yard for income also. 2 bedroom 1 bath needs some love.

Here’s what tuno had to say about today’s house:

just an amazingly crappy crapshack that sold for 501K (!!!!!) in 2004.  it is so very, very awful.  and I *like* awful little houses.  but *yuck*.  and they claim as a selling point that part of the *yard* is presently being rented out!!!

They rent out… part of the yard… for income also.  And this is a 2/1.5 right?  Well 2/1 of that 2/1.5 needs some love.  That means there’s a perfectly content half bathroom.  And the inside pictures aren’t that bad as crapshacks go.  But the outside!  Ahhhh, and remember, this yard is working for you!

Look how many vehicles are parked here, obviously the property owner is making so much in rent he’s buying extra trucks and boats!  Remember: 1. Buy a house.  2. Rent some or all of it out.  3. Profit!!!!!!

Want to make even more money? TIME-SHARE!  Like fifty bucks to park in your yard during a big event near your house.  Or five hundred dollars to helpfully inform the cops the “bad guy” they’re looking for just headed toward the airport.  Rent your house, and then rent it during your tenants’ vacation or work hours; PROFIT MORE!

$175,000

170 NORTHUMBERLAND Ave Redwood City, CA 94063

Beds:	1
Baths:	1
Sq. Ft.:	630
$/Sq. Ft.:	$278
Lot Size:	2,625 Sq. Ft.
Property Type:	Detached Single Family
Style:	Cottage/Bungalow
Stories:	1
View:	Neighborhood
Year Built:	1905
Community:	Dumbarton
County:	San Mateo
MLS#:	81020028
Source:	MLSListings
Status:	ActiveThis listing is for sale and the sellers are accepting offers.
On Redfin:	204 days

Bank Owned. Small Cottage Style house with loads of potential. Large Living Room. Granite Kitchen Countertops(no oven)Seller will install stove w/ accepted Offer. Good size bedroom overlooks backyard. Inside laundry!Cute front and back yards. 1 Car Carport. Close to Caltrain, shopping and restaurants! $75.00 Doc Fee paid by buyer. All contracts/offers subject to Indymac/OneWest Sr. Management Approval

Black Friday Mania Deals continue! Today, let’s look at the cheapest house in San Mateo County! Go figure, it’s in Redwood City!

I love how this house offers the buyer the chance to pay $75 for the doc fee – don’t you just hate it when the seller insists on doing that? I also love how the seller will install the stove once there’s an accepted offer. Hey, you can’t blame him – there might be sneaky renters posing as buyers who will come in during the open house, rip the stove out, and sell it for scrap so they can buy some more heroin. You know how those renters are, always jonesing for the next hit!

Oh… wait a minute… now I know why this house looks familiar…

http://www.burbed.com/2008/08/07/time-to-do-your-christmas-shopping-in-redwood-city-sales-are-on/

August 7, 2008

Time to do your Christmas Shopping in Redwood City – sales are on!

170 Northumberland Ave, Redwood City, CA 94063 MLS# 80780395 – Property Details
170 Northumberland Ave, Redwood City, CA 94063

Hey, this was a great deal then… it’s an even better deal today! Go for it! What are you waiting for!

87 NORTHUMBERLAND Ave, Redwood City, CA 94063 | MLS# 80945968
$449,000
87 NORTHUMBERLAND Ave Redwood City, CA 94063

Beds: 2
Baths: 1
Sq. Ft.: 840
$/Sq. Ft.: $535
Lot Size: 5,550 Sq. Ft.
Property Type: Detached Single Family
Style: Spanish
Stories: 1
View: Neighborhood
Year Built: 1939
Community: Dumbarton
County: San Mateo
MLS#: 80945968
Source: MLSListings
Status: Active This listing is for sale and the sellers are accepting offers.
On Redfin: 51 days

Thanks to Burbed reader sonarrat for this find.

Have you ever seen something that was so amazing… so beautiful that you were at a lost for words?

Apparently, that’s what happened to this Realtor. He just couldn’t figure out what to say about this $535 per square foot house in Redwood City.

He needs your help. Go for it Burbed readers. How would you caption this house?

Here’s another piece of information… its neighborhood:

Alright Burbed readers… let’ see some of that creativity come through!

1923 Middlefield Rd, Redwood City, CA 94063 Dumbarton MLS# 80843661 – Property Details

$179,000

* Status: Active
* Bedroom: 2
* Bathroom: 1
* Year Built: 1927
* Lot Size: 1824
* Square Footage: 600
* List Date: 11/4/2008
* Garage Spaces: 1
HUGE POTENTIAL IN THIS TWO BEDROOM, ONE BATHROOM HOME. FEATURING WOOD FLOORS, AN ATTACHED CONVERTED GARAGE AND CENTRAL LOCATION. WALK TO DOWNTOWN, COSTCO! HURRY, DON’T MISS OUT ON THIS FANTASTIC OPPORTUNITY!

A few Burbed readers sent this to me. It sure looks familiar though… oh wait!

April 8, 2008
1923 Middlefield Rd in Redwood City revisited (again)

Wait… that seems familiar too…

August 13, 2007
How to lose $240 a day… 1923 Middlefield Road

Wowsers. The reason for this is clear: this property has not been well advertised.

Hello! This house has a Zestimate of $407k! Think of all the instant equity you can earn from this!

Don’t pass up this incredible deal. Buy it today! The bottom has been reached in Redwood City. How could this property possibly go any lower? Seriously!