And let’s wrap another exciting week of real estate win with this Burlingame bonanza!  We’ll show you the house, you find as many intriguing pieces of flair as possible.

1515 CAROL Ave
Burlingame, CA 94010
$965,000

2 Beds 
1.5 Baths 
1,570 Sq. Ft.
$615 / Sq. Ft.
Built: 1920 
Lot Size: 5,250 Sq. Ft. 
On Redfin: 4 days
Property Type: Detached Single Family
Stories: 1
Community: Burlingame Park
MLS#: 81230242
Style: Traditional
View: Neighborhood
County: San Mateo

cute & cozy home near schools, Safeway, restaurant, transportation & Burlingame shpping area. Livin rm w/ woodburing frplc, spacious formal dining, updated kit w/ eating area, 2 bedrm both are master suite, plus a den( Can be used as a play rm or office ) separate parking garage. Crown molding, hardwd flr throughout, recess lighting in the den, separate laundry rm w/ 0.5 bath. Needs TLC. Great flr plan.

The dining room has a cooler on wheels with a coffee pot atop, but the kitchen features a recumbant pineapple.  Keep looking through the photos, because there’s lots more to find in this Burlingame bungalow!  Does this property merit a Good Housekeeping tag of approval, or does the owner merely have a whimsical way with staging?

Bunus: DHO (Dog Hanging Out) in photo #7!  Any idea what’s in that shopping bag?  It must be important!

No, there are no chickens to see at this Mountain View marvel, but the street name lives up to the title billing above.  It sure puts us in mind of one of our favorite Warner Brothers characters.  I say, I say, I say, son, that is QUITE a price.  Thanks very much to Burbed reader mabel du for taking on this turkey.

2012 LEGHORN St
Mountain View, CA 94043
$749,000

2 Beds 
1 Baths 
914 Sq. Ft.
$819 / Sq. Ft.
Built: 1948 
Lot Size: 6,800 Sq. Ft. 
On Redfin: 9 days
Property Type: Detached Single Family
Stories: 2
Community: Rengstorff
MLS#: 81229400
Style: Cabin
View: Neighborhood
County: Santa Clara

Currently used a residential rental. Great opportunity to build prime location office space or light industrial, storage/warehouse, or wholesale business. Take advantage of this unique opportunity in the heart of Mountain View!

Why the possibilities for this property are truly endless.  Let’s hear from mabel du as to why:

uh…  i’m sorta speechless on this one.  what a crazy shite-load of weird pictures.  and who’s the mystery woman who pops up randomly, waldo’s mom? 

$819/sq ft for this?  really???  interesting satellite shot from zillow  (i.e.  yikes!)  nothing too helpful on propertyshark.  looks like it’s been held in the family for years – would love to know what they paid for it back in the dark ages.

We assure you the pictures inside are just as Special as the yard views.

But why check Property Shark?  Both Redfin and Zillow clearly state this amazing place last sold in the dark ages of 2007 for $600,000.  And worth every bit of that chicken feed.

898 TULLY Rd
San Jose, CA 95111
$1,300,000

Do you love Instagram pictures? Do they help you make an emotional connection to the subject?

Guess what – now we can combine all the things you love! Realtor photos, soft focus, distortions, and other filters!

Just look at this photo above. What emotions does this evoke for you? Does it make you feel better about spending $765 per square foot for this house?

And we’re done with another exciting week of properties, finishing off in the “Capital of Silicon Valley”!  Today’s featured home was sent in by Burbed reader Tracy Tea House.  Sit back and relax as we bring you yet another San Jose Special, after we let Zillow and Redfin duke it out over what neighborhood it’s in.  Is it in West San Jose?  Is it in the Campbell area?  You decide!

456 Ardis Ave
San Jose, CA 95117
Sold for $1,285,000 on 7/27/2012
Sold for $437,000 on 2/3/2012

Beds: 4
Baths: 4.5
Sqft: 3,700
Lot: 9,300 sq ft / 0.21 acres
Type: Single Family
Year built: 2012
Last sold: Jul 2012 for $1,285,000

Public Facts:
Beds: 3
Baths: 1
Sqft: 1,032
Lot: 9.300 sq ft / 0.21 acres
Type: Single Family
Year built: 1951

BRAND NEW CONSTRUCTION, this “Estate Quality” home features a wonderful open floorplan and so many designer features that include a “Chef’s Kitchen w/all stainless appl incl. refrigerator, wine chiller, wet bar, walk-in pantry and more! Fully landscaped! 10′-11′ coffered ceilings, crown/baseboards, 1,200+/- sft attic w/engineered flooring and so much more! A must see! Open Sa/Su 1-4!

Here’s why Tracy sent us this house:

Look quick cause this one shows the pictures from pre-flip. They bought the house in Feb. I think tore it down, built a new house  in six months and are trying to sell it for double the purchase.

Guess we didn’t have to look that quick, because Tracy sent this in 3 weeks ago, the day after it was listed.  The house went pending 2 days later.  It must have been a cash deal, because the sale was recorded just one week after that.

Now we could be party-poopers and show you the fancy pictures on Redfin, or we could be Burbed and revel in the cognitive dissonance between the listing copy above and these lovely photos still available on Zillow from the February listing.  We are talking “Estate Quality” in every room.

Also fortunately for us, Redfin saved the pre-flip listing so we can share that description with you too!

New listing! Large 9,300 +/- SF lot. Perfect starter home or for investment! Attached 1-car garage with washer/dryer hookups. Close to Santana Row, Westfield Shopping Center, and entertainment. Close to highways 280 and 880.

Yeah.  Definitely close to 280.

Bunus: Even closer to Winchester Ranch Mobile Home Park.

We haven’t had any Willow Glen properties in a while, or even not-really-in-Willow Glen-but-claiming-to-be listings.  Today’s featured home was sent to us by bmwman91.  Thanks very much for this #winning not-Willow Glen wonder.

2143 GLENKIRK Dr
San Jose, CA 95124
$975,000

BEDS:  4
BATHS:  2.5
SQ. FT.:  2,344
$/SQ. FT.:  $416
LOT SIZE:  8,288 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STYLE: Ranch
STORIES: 1
VIEW: Neighborhood
YEAR BUILT:  1964
COMMUNITY:  Willow Glen
COUNTY:  Santa Clara
MLS#:  81224337
SOURCE:  MLSListings
STATUS: Active
ON REDFIN:  33 days

REG Sale. LOCATION LOCATION! Needs some cosmetic updates , JUST A BIKE RIDE TO DOWNTOWN WILLOW GLEN. Upgrades Include: CUSTOM CROWN MOLDING, NEW PAINT, REFNSHD WOOD FLRS, 6 BURNER GAS RANGE STNLSS STEEL DSHWSHR, TRSH COMPCTR, TILED FLR. BATH W/ TILE FLOORS & JETTED TUB. FURNACE & CENT AIR apprx 12 YRS OLD. , COMP ROOF apprx 14 YRS. , AUTO SPRINKLERS.

Here’s why bmwman91 shared this house with us:

[The owners] are clearly savvy about cashing in on some of the instant equity that the last seller left hidden in the medicine cabinet in 2005, by listing it for $145k more than was paid for it at the peak. Maybe they need the extra cash to buy some furniture.

Since when was 2005 the peak?  This place might have topped out in 2006, easy!  But we agree about the furniture.  That table sure gets around!

One thing we aren’t sure about is what neighborhood this house is in, but it sure is not Willow Glen.  Google maps isn’t really helping, as it seems to have this house in a neighborhood dead zone.

There’s a few more names that pop up as you zoom in, but nothing for the area bounded by Hamilton, Leigh, Curtner, and Meridian.  We’re going to go with Cambrian with Campbell-San Jose as a second choice.  Maybe even Dry Creek.  But Willow Glen?  We don’t think so, unless it’s this not-Willow Glen neighborhood called “Willow Glen South Lincoln Glen.”  You know, where they have to point out it’s a REG Sale.

So readers, your job is to explain why this not-in-Willow Glen house is worth $145K more than it was in 2005.  Be sure to support your answer by referring to this fine example of a listing photo.

It’s been so long since we’ve featured a house like today’s property, and this site used to run almost nothing else.  Blame it on all the flippers out there trying to install granite in absolutely every building.

Today’s home hails from amazing Alum Rock, and was discovered by Burbed reader Tracy Tea House, who is our guest blogger this fine day.  We’re headed for Zillow, (Redfin link here) so hold on!  And before we go, be sure to give Tracy a big, warm Real Bay Area welcome for this guest post!

1761 E San Antonio St
San Jose, CA 95116
For Sale: $285,000

Zestimate®: $271,085
Est. Mortgage: $1,020/mo
See current rates on Zillow
Beds: 2
Baths: 1
Sqft: 937
Lot: 9,583 sq ft / 0.22 acres
Type: Single Family
Year built: 1920
Parking: –
Cooling: –
Heating: –
Fireplace: –
On Zillow: 30 days
MLS #: 81224183

Brokered And Advertised By: Altas Realty Listing Agent: Clem Garcia

There’s something about a North  East San José crap shack from 1920 that just gets my juices flowing. I start imagining the history, who lived there, what this part of California was like back then, so much closer to the time of  original settlement.

Then, I start thinking of the toxics, asbestos, old leaky containers and old buried tanks in the 9000 sf yard. Suddenly, the idea of tearing it down and building a flip doesn’t sound too bad… But, people are living there, in all  937 sf of it and they want almost 300K for it????

Still the pictures are intriguing. There is dirt, trash, chain link, Plywood fences, artful shadows, and so much more  in the mystery RV.  Then there are the “normal” houses nearby… How has this one remained all these years, and who will come on the scene to change it. Ok, I’m hooked I’ll add it to my many saved shacks, and send it to madhaus and burbed who I know will appreciate the art of this sale.

One thing we all love on Burbed is real estate photography.  We’ve had photos of just the floor, photos of messy rooms, photos of questionable decor, and photos of more toilets than you could shake a scrub brush at.  But today’s featured property looks at those fine examples of photo fail and says, “Oh yeah?  I can beat THAT.”

Thanks very much to Burbed reader DavidDavidDavid for today’s spectacular colorburst in San Carlos!

2388 BRITTAN Ave
San Carlos, CA 94070
$759,000

BEDS:  3
BATHS:  2
SQ. FT.:  1,370
$/SQ. FT.:  $554
LOT SIZE:  7,500 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STYLE: Ranch
STORIES: 1
VIEW: Neighborhood
YEAR BUILT:  1953
COMMUNITY:  Howard Park
COUNTY:  San Mateo
MLS#:  81226555
SOURCE:  MLSListings
STATUS: Active
ON REDFIN:  4 days

Lovely ranch-style home on a large corner lot. Formal LR/DR combo with H/W floors, wood-burning fireplace, french doors lead to patio and secluded back yard. Updated kitchen with dark granite counter tops, stainless appliances & tile floor. Remodeled bathrooms. Recessed lights, New drive way, 2-car attached garage w/ extra storage. Fully lndscp front & back yard. Great schools/nbrhd. Ez fwy accs.

Here’s why DavidDavidDavid (I hope I can call him D3 for short) nominated this home for some Burbed loving:

Yet a new achievement in HDR real estate photography! Scroll over to the third and subsequent photos; check out the blazing magenta colorization!

What are you talking about?  We don’t see anything amiss with these photos.

But we’ll keep looking in case our readers might notice any problems.

Listed 7 days and pending already, no doubt because of the easy access to better towns.  Did we mention that Mountain View is hot, hot, hot?  If you don’t believe us look at the trees in these photos.

2546 DELL Ave
Mountain View, CA 94043
$699,000

BEDS:  3
BATHS:  2
SQ. FT.:  1,216
$/SQ. FT.:  $575
LOT SIZE:  5,000 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STORIES: 1
VIEW: Neighborhood
YEAR BUILT:  1959
COMMUNITY:  Thompson
COUNTY:  Santa Clara
MLS#:  81226069
SOURCE:  MLSListings
STATUS: Pending Without Release
ON REDFIN:  7 days

Great location in Monta Loma Neighborhood! Incredible opportunity to remodel and make your own! Blocks from Monta Loma Elementary School. 4 bedrooms & 2 bathrooms with over 1200 sq. ft living space. Open living room and dining room, bonus room and large backyard. Attached 2 car garage. Just minutes from the New Village at San Antonio Center with easy access to Los Altos & Palo Alto!

Please pardon us while we try to reboot our eyeballs after yet another HDR attack.  We may also need some potassium iodade pills to mitigate any exposure to the radioactive foliage.

Now, can anyone explain why the realtard chose the “additional” pictures provided?  In addition to all three school facades and the Mountain View Performing Arts Center, there’s a photo of a US Bank with a Starbucks across the street.  Is this a subliminal suggestion that you’ll be rolling in dough from all the new homeowner tax savings?  Or is this photo merely there to show how awesome Downtown Mountain View is, a US Bank and a Starbucks, both! 

Because this is Downtown Los Altos.

The photo on the left is #24 from the listing. The photo on the right came straight from teh Googly Mapz, for 300 Main Street.  Obviously this view is far more classy than one of the Starbucks closer to this house.  Wouldn’t you rather sip your lattes at a more prestigious Starbucks in a mawbul kawlums zip code?  Heck, why didn’t the agent include a picture of Stanford?

This site has made a number of jokes about homes that could have been meth labs but probably weren’t.  But what if you could buy a real one?  Thanks very much to Burbed reader Cam for following up on our recent guide to NOT buying a meth lab.

5674 S SAN FELIPE Rd
San Jose, CA 95135
$1,199,950

BEDS:  4
BATHS:  3
SQ. FT.:  3,200
$/SQ. FT.:  $375
LOT SIZE:  1.72 Acres
PROPERTY TYPE: Detached Single Family
STYLE: Contemporary
STORIES: 1
VIEW: Mountains, Neighborhood
YEAR BUILT:  1915
COMMUNITY:  Evergreen
COUNTY:  Santa Clara
MLS#:  81205455
SOURCE:  MLSListings
STATUS: Active
ON REDFIN:  155 days

Now is the time to buy this small ranch in the prestigious Evergreen Hills area. New entrance bridge makes a statement. Perfect for the horse-lover (tack room, barn and fencing) or person interested in exploring the possibility of subdivision. Lots of extras including BBQ area, dog run/kennel, covered patio and a hot tub.

Here’s what Cam had to say about this um, very unique (snort) property:

Found this just after the meth lab post.

Pending soon? Agent even included photos of the chemical stains!

The link is to a Redfin forums discussion which links to this property, and also points out the same address is on the DEA seizure list.  The home was seized in August, 2010.  So it’s a pretty safe bet that this house is the real thing.  Except this is interesting as it went into foreclosure the previous February.

Yup, it’s an REO.  And you know what that means, right?  It means the seller (also known as the bank) doesn’t know squat about anything that happened in this house.

Check out the fireplace! More importantly, check out the chemical stains next to the fireplace! No wonder they didn’t dare show us what was cooking in the kitchen.

This reminds us of that huge meth lab bust in March (not this one, in an apartment, like for RENTERS).  We don’t know if this house was seized because the police were tracking down a stolen iPad and hit the jackpot, or if the bank deliberately planted some “bath salts” in the hot tub because they really wanted SOMEONE to take it off their hands.

Here’s another San Jose Special from one of our frequent correspondents, Burbed reader Tracy Tea House!  Thanks very much for this Berryessa beauty, which has been snapped up by some lucky buyer. 

11260 CANYON Dr
San Jose, CA 95127
Listed for $699,000; Sold for $640,000 on 6/16/2012

BEDS:  3
BATHS:  3
SQ. FT.:  2,952
$/SQ. FT.:  $217
LOT SIZE:  0.48 Acres
PROPERTY TYPE: Detached Single Family
STYLE: Ranch
STORIES: 1
VIEW: Neighborhood
YEAR BUILT:  1964
COMMUNITY:  Berryessa
COUNTY:  Santa Clara
MLS#:  81213632
SOURCE:  MLSListings
STATUS: Sold

WOW!WHAT A GREAT VALUE * GORGEOUS SWEEPING VIEW OF THE GOLF COURSE AND CITY LIGHT * ENJOY IT ON THE LARGE DECK * PRIVATE POOL AREA * IN DOOR SAUNA ROOM * HUGE BED ROOMS * HUGE LIBRIRY AND OFFICE * SUPER PRIVATE AND SERENE LOCATION * SURROUNDED BY MULTI MILLION DOLLAR HOMES * 3 MUNITES DRIVING TO 680

Here’s what Tracy had to say when submitting this property to our attention:

Something is probably truly wrong with this house! But what? We fell in love with the massive decks, tiki torches, groovy pool, amazingly large rooms, with indoor sauna and all over swag. The tee is directly out the back door and people are literally hitting golf balls feet from the deck. I think my dogs would have gone crazy!

Now the down sides. Shorty short sale, the price is very, very low, considering, and there are water problems. Some obvious, but I suppose, some hidden much deeper, with the big hill above. The house was pending shortly after we looked at it, and fell out, so its back on the market. A true treasure? Or a California size boondoggle?

All this, and only 3 MUNITES DRIVING TO SAN JOSE.  Are MUNITES more or less time than MINTUES?  We know, the unit of time used on the WORLD RENOWN SAN FRANCISCO PENINSULA are MINTUES.  But if you know the way to San Jose, you can conquer both time and space.

Don’t believe us?  Look at all 25 pictures of this listing and figure out what’s missing.  Go ahead, we’ll wait.

Did you figure it out?  Here’s a hint, courtesy of teh Google.

Yes, 25 pictures (several of the same exact tree), and not one of what the house itself looks like.  No wonder you have to ENJOY IT ON THE DECK instead.  At least you would be SURROUNDED BY MULTI MILLION DOLLAR HOMES.

Um.  Thank you, Zillow.  Opportunities to play with the Red Arrows are always appreciated.

Too bad the realtard didn’t find a dictionary in the HUGE LIBRIRY.