Surprised it’s still there, what with all that value in the land.  Thanks to Burbed reader LomaLovr for the find.

1950 LEGHORN St
Mountain View, CA 94043
$799,000

3 Beds
1.5 Baths
1,456 Sq. Ft.
$549 / Sq. Ft.
Built: 1966
Lot Size: 0.52 Acres
On Redfin: 7 days
Property Type: Detached Single Family Community: Rengstorff MLS#: 81313653
Stories: 1
County: Santa Clara

Rare opportunity to own this half acre lot with a single family home grandfathered on it. Zoned MM40 for commercial or industrial use. Single family home can be used as an office upon ok by city for business purpose. 200 sq ft basement. Property can not be developed into other residential aspects. Property can not be subdivided. Easy access to 101. Property will not last, this is under valued.

Upcoming Open Houses

Sunday, May 5: 1:00-4:00 pm

Buried in the cached copy are these comments:

Investment Property Possibilities Endless .51 acre lot Can be commercial property. Zoned MM40 Grandfathered Single Family Home on lot.

It’s Day #6 of the Blogging from A to Z Challenge, and these Frackin’ Festivities are a Fantastic Folderol! We’ll leave the weekend open thread until tomorrow, as we have another Fantastic Freehold to Flaunt. But First, a Foreward From our Fabricator.

You’ll be looking Forward to Sunday every day the next 2 Fortnights because that’s the only day off From the A-Z Challenge.  So we’ll Fit the open threads into that Forum.

And now back to our Frequently Fated Flagon of Fail.

5599 Greeley Pl
Fremont, CA 94538
$250,000

3 Beds
2 Baths
— Sq. Ft.
Built: 1965
Lot Size: 5,918 Sq. Ft.
On Redfin: 4 days
Type: Detached
Stories: 1
County: Alameda
Style: Ranch
Community: Fremont
MLS#: 40609034

Great neighborhood, walk to schools. Short Sale Subject to Lender Approval. Open House Sunday April 07, 2:00-4:00 PM. Call (408)977-1700 recorded message for instructions

Forget the Fone For instructions. Just drive along the Freeway until you Find it.

Fine Future. Foreseen For sure.

We love it when listings rise from the dead canceled and return betteh than EVEH.  Today we have a house that already made one appearance on Burbed, so another one makes it so much more full of Win!  Thanks very much to Burbed reader Dibber for unearthing this unabashed ultimate unavailable (yep, PENDING!) um…

11441 Eastbrook Ave
Los Altos, CA 94024
Pending: $2,499,000
Zestimate^®: $2,507,171

Bedrooms: 6 beds
Bathrooms:6 baths
Single Family:9,300 sq ft
Lot:23,086 sq ft
Year Built:1992
Heating Type:Forced air

Description

HUGE CUSTOM CONTEMPORARY HOME W/2100SF ATTACHED GUEST HOUSE**PERFECT FOR LARGE EXTENDED FAMILY OR INVESTMENT RENTAL**EXPANSIVE LIST OF AMENITIES INLC LIMESTONE FLRS, CUSTOM FAUX PAINT, LRG MASTER SUITE W/ SITTING ROOM, GOURMET KITCHEN W/ GRANITE, WINE CELLAR/TASTING ROOM, 5-ZONE HVAC, 4FIREPLACES** TWO (2) CAR GARAGES INCL OVERSIZED HEIGHT FOR R/V/WORKSHOP**FRESH LANDSCAPING,ROOFTOP BALCONY!

We’ll leave it as an exercise to the reader to find out why Zillow led with the cabinet picture instead of the front of the house.  Now let’s check in with Dibber:

Or maybe it never left?  Winchester Mystery House, Los Altos Hills campus.   Check out the listing history.  Who says Silicon Valley is expensive.  I can get you into Los Altos Hills baby!  And only $269 per square foot.  I’m thinking listing mistake…Concord? 

Perfect for the large extended family?  Honey, please show aunt Betty to the 2100 square foot guest house, but this time please keep her out of the wine cellar and off the roof deck.  And honey, the kids really shouldn’t be playing pick-up soccer on the 280.

Yes, ridicuously cheap.  Too bad Foothill College doesn’t have fraternities.  This place would would be perfect… traffic noise would drown out the party noise!

Wonder why this never got snapped up last time we featured it… And here it is all the way from 2010!  Remember this one?

Wow, has the unwitting seller finally dropped the price low enough price to find a buyer?  Or is this just a coincidence that prices are finally going up again?

Burbed just doesn’t give the East Bay enough love, so we’re always delighted when our readers send us something from Alameda or Contra Costa County.  Today’s featured listing is from one of the more rarified regions of CCC, but you’ll see that there’s nothing Real about this Bay Area bonanza.  Thanks very much to Burbed reader Kim in the East Bay for this Danville domicile!

898 La Gonda Way
Danville, CA 94526
$619,500

3 Beds
1 Baths
1,112 Sq. Ft.
$557 / Sq. Ft.
Built: 1953
Lot Size: —
On Redfin: 67 days
Status: Active
Property Type: Single-Family Home
County: Contra Costa
Community: Danville/San Ramon |
MLS#: 403322

Single family home on large level lot with 3 bedrooms, 1 bathroom, living room with fireplace, dining area, large kitchen, huge yard, 2 car garage parking.

 

Are we lost? This looks like something not from Danville, but maybe Connecticut.  Bricks, autumn foliage, and what could pass for aluminum siding; all we need are some shooting ranges in those woods over the back fence.  And that spare prose is pure Yankee, other than the outburst about the huge yard.  So huge the lot size isn’t even provided (9583 sf, even that’s more East Coast than East Bay).

Maybe we’re not lost but this house is. The price has been reduced twice, and the agent couldn’t be bothered to clean up before taking the listing pix.  Even the dog carrier stays.

Did we mention location, location, location?

Let’s finish out our workweek (not that Real Bay Area denizens ever would take a day off) with a place on the way to almost anywhere you’d like to go this weekend.  That is, if you didn’t have a job and were free to go somewhere besides work.  You never know, you might get a Sunday off when you meet your next milestone! (Just kidding!)

785 5TH Ave
San Bruno, CA 94066
$379,000

2 Beds
1 Baths
780 Sq. Ft.
$486 / Sq. Ft.
Built: 1930
Lot Size: 6,633 Sq. Ft.
On Redfin: 1 day
Status: Active
Property Type: Detached Single Family
Community: Belle Air
MLS#: 81302815
Stories: 1
County: San Mateo

Two Bedrooms One bathroom House on a large lot. Currently occupied by Month to month tenants. Need TLC. Close to Freeway and transportation.

Needs Toilet Lid Crushed?  Unfortunately no crapper shots, but we have some winners anyway.  Can’t quite decide if the kitchen merits a Good Housekeeping Tag of Approval or not.

And when this agent said close to freeway, she meant it.  Dang, this place is close to absolutely EVERYTHING.

You could even make extra money taking overflow parking during Thanksgiving!  No wonder the front yard is so durable.

Bunus: Save $10,000 from August, 2011 asking price!

Let’s take a break from our Black Friday DEALS and see what a house can look like if you’re willing to spend more than what you find in your sofa cushions.  Instead of scraping the bottom of the barrel, let’s see what you can get for a million and a half.  Thanks very much to Petsmart Groomer for this magnificent Menlo Park megaplex!

1045 WINDERMERE Ave
Menlo Park, CA 94025
$1,549,000

3 Beds 
3.5 Baths 
2,856 Sq. Ft.
$542 / Sq. Ft.
Built: 2007 
Lot Size: 8,923 Sq. Ft. 
On Redfin: 77 days
Status: Active
Property Type: Detached Single Family
Stories: 1
Community: Flood Park Area
MLS#: 81234064
Style: Traditional, Craftsman
View: Neighborhood
County: San Mateo

Stunning 5-year-old rebuilt home | 3 bedroom suites & 3.5 ba | Kitchen-family great room | Incredible chef’s kitchen w/ custom cabs, center island, walk-in pantry, high-end stainless appliances incl 6′ wide double fridge | Bonus room off FR perfect for office or play | Fine finishes: 9′ ceilings, rich moldings, plantation shutters, hrdwd flrs, recessed lighting, AC | Great yard | Top MP schools

Isn’t it nice to see a place for sale that doesn’t look like a crime scene?  Don’t you just want to move in here?  We just hope that Flood Park Area is just a neighborhood name and not a description, or worse, an order.

And for this price category, you should, and here you do get some decent real estate photography.  (Although we think this house is  slightly radioactive: look at the sky color change near the roof and especially the trees) Think about some of the places on the sale rack that were shot with a disposable.

Remember, you get what you pay for!  And in this case it’s location, location, location!

Or should that be LOLcation?  Guess that explains the chef’s kitchen w/custom cabs.

Today’s featured home is an architectural aristocrat among stupendous school districts.  Translation: wtf?  Thanks very much to Burbed reader wahnny for sending this Cupertino castle in!

7367 RAINBOW Dr
Cupertino, CA 95014
$995,000

3 Beds 
2.5 Baths 
1,523 Sq. Ft.
$653 / Sq. Ft.
Status: Pending Without Release
Built: 1995 
Lot Size: 1,742 Sq. Ft. 
On Redfin: 20 days
HOA Dues: $150/month
Stories: 3
County: Santa Clara
Property Type: Detached Single Family
Community: Cupertino
MLS#: 81234699

This is one of the only two single family homes in this five unit complex. 17 years new. Comtemporary floor plan and bright, sunny natural lighting. New carpets. Newer paint. Crown molding. Hardwood floor in living and family room. Granite kitchen counter top. Private back yard. Award winning Cupertino school Regnart Elementary, Kennedy Middle and Monta Vista High.

Here’s what wahnny had to say about why this building block became Burbed:

Just came across this gem in Cupertino.

Asking price is just under $1million for a “17 year new” 3-story 1500+sqft cube house on 1700+ sqft lot.  Not exactly a “crapshack”, but it does seem pretty cramped (small rooms) and probably noisy too (close to highway, major thoroughfares).  Perhaps a small price to pay for access to the “award winning Cupertino schools”, and/or bee-line to Apple Inc.

It can’t be that bad.  The lot is 200 square feet bigger than the house, and there is some green amid all that low-maintenance cement. Plus, fewer windows means less work cleaning them and less sun damage to your drapes and artwork.  We’d say this detached home features all the benefits of townhouse living, right down to the HOA fees!

And wahnny must have been exaggerating for comic effect about the thoroughfare and highway nearby. 

See?  We know it wasn’t that bad! There’s a handy offramp as a buffer zone!

Welcome back to San Mateo, courtesy of Burbed reader MS.  Today’s terrific title is a top-tier townhouse, and all that townhouse living entails.  Like 20 other units to share the complex with you, and those delightful CC&Rs to make decor decisions dictatorial.

829 S Bayshore Blvd
San Mateo, CA 94401
$690,000, reduced from $711,000

HOA Dues: $250/mo. 
3 Beds 
2.5 Baths 
1,775 Sq. Ft.
$389 / Sq. Ft.
Built: 2008 
Lot Size: — 
On Redfin: 46 days
HOA Dues: $250/month
Style: Contemporary
Community: South Shoreview
MLS#: 81229901
Property Type: Townhouse
Stories: 1-3 (Low Rise)
County: San Mateo

Luxury townhome near downtown San Mateo, designed w/ craftsman details, large windows & abundant light. Less than 5 yrs old (2008 built), 3bd, 2.5 bth, 1,770 sqft unit features high ceilings, recessed lighting, wood cabinets, open kitchen, gas-burning fireplace, & gleaming flooring. Master w/ lrg walk-in closet. granite countertops + marble tiling. Seller may consider Lease w/ Option to Purchase.

Here’s why ms sent in this tip-top tenement!

This is a townhouse in a project where the nearest scenic view is the 3rd Avenue sign on 101.  The HOA is decent at $250, but for $700K+ you should not be paying HOA at all.

It is also priced far more than comps. Check out:

Retirees, note the San Francisco-type stairs to go up and down and up again to get to the bedrooms. Your grandkids would have no common place to play.

711K?  Is the bubble real?  Is the bubble fake?  Only the shadow knows, the shadow man under someone else’s bed.

It’s not lucky $711,000 anymore!  Price reduced to $690,000.  You’ll get even luckier with a price like that.  You know what else is lucky?  Those HOA dues.  Redfin mentioned them twice.

MS’s comment about the 3^rd  Avenue sign was completely on the level.  This is the lovely view you get every time you leave the plex.  Location, location, location!

Let’s continue our trip up and down the housing food chain.  Earlier this week we had a genuine crapbox.  Yesterday we had a mid-priced property in a neighborhood without a name (and it really says something for the Silicon Valley housing market that a million dollar property in an unremarkable part of San Jose is considered mid-priced at a million dollars).

Today we’re back to another Burbed favorite: the non-moving high end.  Thanks very much to Burbed reader Petsmart Groomer for this lovely landscape in Los Altos Hills.

12859 NORMANDY Ln
Los Altos Hills, CA 94022
$6,195,000

BEDS:  6
BATHS:  6.5
SQ. FT.:  7,333
$/SQ. FT.:  $845
HOA DUES:  $300/month
LOT SIZE:  1.21 Acres
PROPERTY TYPE: Detached Single Family
STORIES: 3
VIEW: Neighborhood
YEAR BUILT:  2005
COMMUNITY:  Los Altos Hills
COUNTY:  Santa Clara
MLS#:  81216432
SOURCE:  MLSListings
STATUS: Active
ON REDFIN:  90 days

This stunning custom home is a masterpiece of East Coast-influenced architecture. The main residence features, 5BR/5.5BA + wkout rm (could be 6th BR), private office, a Media rm, large recreation rm & sep wine cell. Darling 1BR/1BA gst hs. Gorgeous landscaped grounds w/ sparkling pool/spa, exceptional terrace w/ fireplace, outdoor kit. & fountain. Detached 3-car gar w/ large workrm. Close in location

Other than the mildly radioactive trees on the grounds, this housing tumor photographed nicely.  There is the matter of the $300 homeowner’s association fees, not something one expects with a six million dollar property. 

Wonder just what the Normandy Lane Association gives you for the privilege?  Maybe they send someone over every month to spray paint the sod this exact shade of green not otherwise found even on a golf course.

And the reason PG sent it in?  Location, location, location!

We’ll finish out our weekend with this find close to everything!  At least close to what matters.  Thanks very much to Burbed reader Petsmart Groomer for today’s listing.

579 MCCARTY Ave
Mountain View, CA  94041
$849,900

 

BEDS:  3
BATHS:  2
SQ. FT.:  1,194
$/SQ. FT.:  $712
LOT SIZE:  5,035 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STYLE: Ranch
STORIES: 1
VIEW: Neighborhood
YEAR BUILT:  1957
COMMUNITY:  Downtown
COUNTY:  Santa Clara
MLS#:  81216279
SOURCE:  MLSListings
STATUS: Active
ON REDFIN:  78 days

Absolutely stunning & charming home adjacent to Old Mountain View. Great curb appeal. Remodeled kitchen with granite slab countertops, stainless appliances & travertine floor. Other features include beautiful hardwood floors, crown mouldings, dual paned windows, remodeled bath with spa tub. Huge rear deck perfect for entertaining. Two finished outbuildings w/ power-perfect home office, studio or playhouse.

It’s always a pleasure when a place we’ve already visited comes back to us, like a disagreeable meal or a reanimated zombie.

Except this time it’s got $30,000 more value than six years ago!  Hurry!  Now here’s why PG sent in this property:

“Absolutely stunning & charming home adjacent to Old Mountain View.” – I can think of a couple of other things it is adjacent to…

Let’s find out!  Burbed Sky 3 crew is on scene!