Zoinks! Today’s the very last day of the Blogging from A to Z Challenge, and it’s also the last of the Triple Threat of Cityless Letters! There are no cities or towns in the Bay Area that start with Z. There aren’t even any neighborhoods in our two largest cities willing to cooperate. What to do, what to do?

We could discuss the complete fail that is the Zero lot line home. (How can you water your own lawn when there’s a house in the way?)  We could really Zone you out by digging deep into tl;dr territory with some Zoning violations! Or how about our favorite series on this site, ever? Yes, Zillions of Zip Codes!

Fortunately, we’re not going there. Instead, let’s drop by one of our favorite real estate sites.

5866 Zileman Ct
San Jose, CA 95123
Pending: $650,000

Est. Mortgage: $2,274/mo
Bedrooms:4 beds
Bathrooms:2 baths
Single Family:1,846 sq ft
Lot:6,534 sq ft
Year Built:1968
Last Sold:Dec 2012 for $565,000
View virtual tour

Construction Quality 6.0
Garage Size 439
Last Remodel Year 1969
Lot Depth 113
Lot Width 58
MLS #81309066
Parcel #69215003
Roof TypeAsphalt
Room Count 8
# Stories 1.0
Structure Type Contemporary
Unit Count 1
View Mountain
Zillow Home ID 19828550

Description

Modern beautiful sparkling remodeled home,spacious and bright, freshly painted inter and exter. approx 1846 Sf of living space,6554 sq.ft.lot , warm and cozy 4 largebedrooms and 2 new baths, dual pane windows,recessed lighting,central air,indoor laundry, living room with fireplace, finished 2 car garage,updated kitchen w breakfast nook. Nice curbappeal

Zestimates

Value: $570,609
Range: $428K – $605K
30-day change: +$25,268
$/sqft: $309
Last updated: 04/28/2013

Rent Zestimate $2,591/mo
Range: $1.1K – $3.4K/mo
30-day change: -$8
$/sqft: $1.40
Last updated: 04/29/2013

Market Guide

Zillow predicts Santa Teresa home values will rise 5.8% next year, compared to a 5.9% rise for San Jose as a whole. Among Santa Teresa homes, this home is 21.1% more expensive than the mid-point(median) home, and is priced 9.3% more per square foot.

Zounds! That stormy sky is no Zephyr! More like dialing the HDR up to 11 when Zero would have been more appropriate. Yeah, photographer was too Zealous. And when we Zip inside, best bring your Geiger counter, because there’s particle decay in them thar bedspreads. Watch out for Zeta rays (there’s no such thing, but it sounds all science-y and danger Zone if you get Zapped by them).

Most of all, Z is for Zestimate, Zillow’s best known feature. This home’s Zestimate is $570K, when it was listed for $650K and went pending in 3 days. What do you predict this house will end up selling for?  Don’t forget the curbappeal.

Just because we’re doing the Blogging from A to Z Challenge doesn’t mean we Have to Hold off our Hallowed Habits. One of them is that we welcome contributions from our readers. Heck, we Harangue our readers if they don’t play along. So, today we are Heaving up another letter of the alphabet, and Having a different poster Handle it.

We Hope you enjoy today’s Happening post from Burbed reader bublidoo!  Please give bublidoo a Healthy, Hot Real Bay Area Homecoming with today’s Holy $#*@! House.

1161 Highland Ter
Fremont, CA 94539
$5,493,000

6 Beds
9.5 Baths
9,967 Sq. Ft.
$551 / Sq. Ft.
Built: 2009
Lot Size: 1.64 Acres
On Redfin: 79 days
Type: Detached
Stories 2
Community: Mission
MLS#: 40601026
Style: Custom
View: Bay, City Lights, Hills, Panoramic, Pasture, Ridge, San Francisco, Water
County: Alameda

Panoramic View, Custom Home, Like Living in Taj Mahal, Elevator, 6 Bedrooms-9.5 Bathrooms, Banquet Hall w/ Stage-Seat over 100, All Bedrooms have Full Bathrooms, $150,000 /Crystal Lights and Chandeliers, Stainless Steel Garage & Exterior Doors, Credit Available for Personalizing Your Finishing Touch.

Let’s Hear from bublidoo Her/Himself!

Figured eventually you’ll get to H.

This has got to be the butt-ugliest way to spend nearly 5.5 Million bucks. HDR [check] Cawlumns [check]. Granite on the wall [check]. More bathrooms than bedrooms [check] "Living like in Taj Mahal" [check]. Yeah, that’s right … sooooo much bling it makes a baroque castle look sparse.

But the HDR … OMG, the HDR! The first pic … OMG, seriously, I thought it’s so synthetic looking it must be from a first person shooter or something. This has gotta be the highest DR evar.

More pictures Here, because you gotta Have some kawlums!

How would you like to live in Los Gatos and not spend a million dollars?  Wish granted!  Thanks very much to Burbed reader wahnny for this, um, residence.

16005 SHANNON Rd
Los Gatos, CA 95032
$788,000

1 Beds
1 Baths
668 Sq. Ft.
$1,180 / Sq. Ft.
Built: 1940
Lot Size: 10,800 Sq. Ft.
On Redfin: 4 days
Property Type: Detached Single Family
Stories: 1
Community: Los Gatos/Monte Sereno
MLS#: 81307108
Style: Cottage/Bungalow
View: Neighborhood
County: Santa Clara

Los Gatos Schools. Unique property on desired street. Upscale neighborhood surrounded by multimillion dollar properties. House has beautiful country setting with beautiful redwoods. It’s tranquil and private. One of a kind with creek and stone bridge that adds to its charm. Close to town, restaurants, Whole Food Market, etc. Additional storage or workshop inside of garage. Lots of potential.

You know this is going to be a good one when they don’t’ show the house until picture #5.  Now let’s check in with wahnny.

Some additional data points that further support the Bubble 4.0 hypothesis.

A cobbled-together 1940s cottage in (possibly RBA) Los Gatos.

The photos don’t do it justice.

Visited during open house (along with several other groups), and although nicely staged, the place is tiny (or, as the Redfin video understates, "compact")! 

It was amusing to listen to the realtor speak of all the positive possibilities (e.g., the house could be torn down or rebuilt (e.g., adding 2nd level)) while minimizing the downsides (creekside property is literally in a flood zone, and would require special build permits/fun with the county).  Yes, yes, value is in the land, but is it really worth more than the Bubble 3.0 sold price?

We also love how the video states that the house is “on the water” and that the 1-car garage means “you’ll always have a place to park your car!”  Also the view of the back patio reminded us of a famous house.

See some resemblance?

If you don’t recognize this house, click here.

We’ve been calling Bubble on the Real Bay Area for several months.  For the next few days we’ll continue to make the case that the housing bubble in the Bay Area is absolutely unmistakable.  Yesterday, we had a 35% overbid in Prime Palo Alto for a tear-down bungalow on a lot too small for subdivision.  Today, we have an even smaller lot with a return of what we called a “wishing price” when the Bubble was about to pop.  But before it did, we had another name for a WTF asking price.  Let’s see what one would look like in Millbrae.

140 MAGNOLIA Ave
Millbrae, CA 94030
$1,100,000

2 Beds
1 Baths
990 Sq. Ft.
$1,111 / Sq. Ft.
Built: 1927
Lot Size: 6,000 Sq. Ft.
On Redfin: 3 days
Property Type: Detached Single Family
Stories: 1
County: San Mateo
Style: Cottage/Bungalow
Community: Highlands
MLS#: 81306376

Charming Two Bedroom and One Bathroom Single Family Home situated on a Lot that is Zoned R-2 (Residential Duplex). This home is located conveniently around the corner from Downtown Millbrae’s Finest Restaurants and Shopping. Great Development Potential, come see this home!

A thousand a foot is a fair price for convenient access to SFO plus two freeways! Plus this is primo real estate photography. At least the agent isn’t snapping pictures in corners like yesterday.

Plus this home is located conveniently around the corner from Downtown Millbrae’s Finest Restaurants and Shopping.  According to Yelp, the Best Restaurant in Millbrae is the Millbrae Pancake House, so we’re talking haute cuisine.  Or at least hot cuisine. 

Now, this lovely home last changed hands in September 2010, for $675,000.  Aren’t you sorry you didn’t snag it then?  Look at all the instant equity you missed out on!  As you can see from the old listing photo (right), the only improvement done to the home since then was to Photoshop in a better sky.  Also back then the place was “Close to BART, Airport, Freeways and schools.”

Not any longer!  Now it’s just one big Great Development Potential opportunity for you! With a price like this, this is now a Real Bay Area house, therefore the train tracks, airport and freeways must have been relocated.

We hope you realize this is THE SECRET of how to make money in Bay Area real estate:

1. Buy house not in the Real Bay Area due to its location fail
2. Eliminate location fail so house moves to RBA
3. ???
4. PROFIT!

Remember, a WTF asking price isn’t a Wishing Price unless there’s no chance of getting it. This is a Bubble Price.  This seller is saying, “You want this house? You’re going to have to pay me enough to Make Me Move.”

Today’s delicious domicile comes to you from Alameda, the island garden of the Bay.  Or should we say Oakland Afloat? Estuary Estates? Maybe you have an even better name for Alameda than those! Thanks very much to Burbed reader JL for finding a house with a creative command to the buyer.

492 MCDONNEL Rd
Alameda, CA 94502
$599,000

3 Beds
2.5 Baths
1,625 Sq. Ft.
$369 / Sq. Ft.
Built: 1992
Lot Size: 3,895 Sq. Ft.
On Redfin: 19 days
Status: Pending
HOA Dues: $365/month
Style: Contemporary
Community: Bay Colony
MLS#: 40601391
Type: Duet
Stories: 2
County: Alameda

Very sunny duet home W/ big lot, great size open backyd, spacious driveway, cul-de-sac. Extra high ceiling grand entrance. Gorgeous new kitchen. double pane window. HOA cover exterior, roof, front yd & insurance. close to ferry terminal. One of a kind. Must see. Nobody pass away inside the house.

Here’s what JL had to say about the house:

Burbed is the best! I had to pass along an Alameda listing that has generous and inexplicable amounts of fail.

First, there’s only outside pictures. Never a good sign. But the best thing is the description. Granted, I think we may have a non-native speaker as the writer, but the last line is hilarious no matter what.

The strange thing is, this looks like a nice house. The redfin Streetview link takes you to a street over a block, but if you go to Google street view directly, it shows a decent-looking place. So the Redfin listing could have been nice, but instead was awesomely bad.

Awesomely bad? It’s not every house that’s not just part of a cookie-cutter tract but a gol-durn “duet home” in a cookie cutter tract that can call itself “one of a kind”! Now that’s awesomely something!  Plus there’s insurance in the front yard! The $365 a month HOA fees are just the cherry on this Win Sundae!

We tried to find the collection of “only outside pictures” without success.  Other listing sites either had the photos removed (with the listing marked as off market) or a slightly different set of photos, inside as well as out.  Here are a couple more, just in case Redfin yanks these bright and early Monday morning. 

And we mean it about the bright, as the Cherenkov radiation is strong in this one.  Just for grins, check out the outdoor pix on Zillow!  Must see.

Serious WHOA.  Of course if we had a yard like that, we wouldn’t pass away inside the house either.

Yesterday we had a brief summary of snapshots showing that we are indeed entering the early stages of a new real estate bubble.  Far-flung areas are still far below their ridiculous 2005-6 peak pricing, and nearby but unloved neighborhoods are being scraped up by investors rather than the outbid mortgage mooches.

But core Real Bay Area listings near high-paying tech jobs are at or even above their insane 2008 peak pricing.  Yes, 2008.  Crap areas hit their high-water marks much earlier than premium places, and it’s the high end that has come back first and letting us know it.  We promised we had a doozy for you today, and we weren’t kidding.  Thanks very much to Burbed reader Wendie for bringing by the bubbly by the carboy.

Location, Location, Location! Teardown: $6.5 Million

Need proof that the Palo Alto housing market has heated up?

By Beatrice Karnes; February 8, 2013

It’s not enough to live in Palo Alto—homebuyers want to live in specific neighborhoods. A home in Old Palo Alto has gone on the market and it’s being advertised as a tear-down or a remodel. Asking price: $6.5 million.

It’s a simple, middle class home built in the mid-1930s and boasts four bedrooms, 3.5 bathrooms, hardwood floors, some linoleum or vinyl floors, and a one car garage.

Let’s have a look.

1935 WEBSTER ST
Palo Alto, CA 94301
$6,500,000

Active
Type: Single Family Home
MLS #: ML81303410
SqFt: 3,009
Beds: 4
Lot Size: 16,610 SqFt
Baths: 3 Full / 1 Partial
Year / Age: 1937 / 76

Virtual Tour

Prestigious Old Palo Alto location. Rare opportunity to remodel or build new on a large lot. Possible subdivision, Buyer to verify with City of Palo Alto. Built in 1935 by William Wurster. Detached recreation room with workshop, dark room and half bath.

Let us count the ways that this is Dutch Tulip Fever all over again:

• A teardown, for Six. Point. Five. Million. Dollars.
• A teardown, but you could remodel. After spending Six. Point. Five. Million. Dollars.
• A teardown, 78 years old (2 years too young for the “old house” tag)
• A teardown, with a named architect.
• A teardown, sold for its potential to build two houses. But why stop there, bribe the appropriate agencies and cram in four!  Heck, how about a 20 story condo tower? Buyer to verify with City of Palo Alto.
• A teardown, with 22, yes twenty-two mostly similar photos in full HDR.  Have you ever seen HDR photos of a workshop, a basement, or a garden hose left on the ground?  You’re about to.

Do not miss this Rare opportunity to be able to Walk To Steve Jobs’ House.

Like photos? So do we!  And this pimped-out property has powerful pix!  Thanks very much to Burbed reader Tracy Tea House for finding us this Cambrian casa. It may not have “Honey, stop the car!” curb appeal or “Can I hire your decorator” staging, but for all we know this listing was photographed by Herb Ritts.

5639 Park Manor Dr
San Jose, CA 95118
$645,000

• MLS/Source ID: 81301959
• 4 Bedrooms
• 2 Bathrooms
• 1,486 sqft
• Single-Family Home
• Lot Size: 6,098 sqft
• Neighborhood: Cambrian
• 14 Days on Trulia
• 289 views

5639 Park Manor Dr ADORABLE 4BEDROOM/2BATH HOME WITH GUADALUPE ELEMENTARY SCHOOL! Refinished hardwood floors* all new interior paint including the kitchen cabinets & hall vanity* new faucets, mirrors, light bars, vinyl floor & baseboards in master & hall bath* new vanity in master bath* new family room carpet* all new satin nickel interior doorknobs* new dishwasher & faucet* nice play structure* & NEW ROOF.

Tracy says this listing is OMG.  If a picture is worth a thousand words, then it’s definitely tl;dr. 

Bunus: Super-ultra-extra redundant power lines!  Lots of them, so convenient!

We love flips.  Take your vintage crapbox that hasn’t been updated since the original owners signed the restrictive covenant, let it marinate for 57 years and mix thoroughly with a cash sale.  Wait 3–6 months and then garnish with new appliances, new paint, new countertops. Of course it’s the same old house under the makeup.

Today’s Los Gatos lovely was sent in by Burbed reader nomadic.  See how long it takes you to figure out what’s wrong with this picture.

135 ANNE Way
Los Gatos, CA 95032
$1,100,000

4 Beds 
2.5 Baths 
2,299 Sq. Ft.
$478 / Sq. Ft.
Built: 1964 
Lot Size: 8,050 Sq. Ft. 
On Redfin: 26 days
Status: Pending Without Release
Property Type: Detached Single Family
View: Neighborhood
County: Santa Clara
Stories: 2
Community: Los Gatos/Monte Sereno
MLS#: 81243731

Huge lot. Incredible Gorgeous tree-lined street in highly desirable Los Gatos neighborhood! This home is another SVHOME renovation that includes stunning remodeled kitchen featuring granite counters, new appliances, new lighting and laminate flooring; baths feature extensive use of travertine stonework. New plumbing fixtures, vanities and lighting; plush new carpeting in all bedrooms, fresh paint

Let’s check in with nomadic on why this house deserves your attention:

Bought November 16, pergranisteel kitchen, new baths and some paint by December 26, when it was re-listed.  Instantly pending!  $284k price delta.

The flippers’ site: http://www.svhome.com/

Yes, the flipper’s have a site, including a ginormous animated photo-graphic that literally flips in segments while you watch.  They also have a page of all their pending properties, including this one.  Most of the others have a virtual tour.  This one does not.

This one also does not have any photos of that stunning remodeled kitchen featuring granite counters, new appliances, new lighting and laminate flooring. The flippers are asking us to take their word for it about the extensive use of travertine stonework.  They wouldn’t even give us a peek at the plush new carpeting, fresh paint.

Although we are giving you a really good ogle at those sturdy power transmission lines running through the back yard.  Now, check out this unbelievable listing history, courtesy of Zillow:

Are you sure there was a flip here?  Really super sure?  Because if there was, it’s still selling for less than they tried to get for it five years ago. (And according to Redfin, they were trying to sell it in 2006 as well.) The November sale price is an eye-opener.  Looks like after five or six years of chasing the market down, the owners finally bailed.  Just a month later it’s back in seven digit range.  All it took was a little pergranisteel and traverstone.

Decor is an important part of getting a house ready for sale.  Decor isn’t just furnishings, but wall treatments, art, floor materials, paint, and of course, tchotchkes.  Today’s featured find is furnished fully with an eye for consistency.  Thanks very much to Burbed reader wahnny for this crib in Campbell!

1105 AUDREY Ave
Campbell, CA 95008
$1,699,000

4 Beds 
3.5 Baths 
4,137 Sq. Ft.
$411 / Sq. Ft.
Built: 2005 
Lot Size: 0.25 Acres 
On Redfin: 7 days
Status: Active
Property Type: Detached Single Family
Stories: 2
County: Santa Clara
Style: Mediterranean
Community: Campbell
MLS#: 81300771

Regular Sale! An entertainer’s Spanish style dream home! This house has it all and you must see to appreciate the attention to detail in this custom beauty by Jay Andre Construction. This home has been totally rebuilt in 2005 with countless amenities. 2 spa/saunas, luxurious office, a gourmet kitchen w/ granite counter tops, tile, and hardwood floors. Too many to list! Open House 1/12 & 1/13 1-3PM

Over 4,000 square feet and the photographer remembered to water the driveway before taking pictures!  Either that or that moody sky had plenty of rain.  Now let’s hear from wahnny on why this house is so Special.

Recently came across this lavishly adorned villa in the middla Campbell.

Almost every photo shows the house in various shades of brown (in keeping with the spanish colonial/western/desert theme, no doubt).  And talk about sophistication … in addition to the obligatory “kawlumns”, a variety of plumbing fixtures are included (see tour website for photos)!  Very elegans/earthy!

Location/neighbors aside, it’s probably worth at least the asking price!

At least worth the asking price?  Oh no, in the time since wahnny sent this listing in, we are sure that this property has probably increased at least 15% over the asking price.

After all, this is a Regular Sale!  And nothing says “dream home” like having to reassure buyers that the house isn’t an REO or short sale!

But what about the location and the neighbors?  With a quarter acre lot, why would you worry about neighbors?  You’ve got enough room to dig a moat and put in Rottweilers.

Although the next-door neighbor does seem to have more cars than driveway.  For $1.7 million one would expect the neighbors to collect something less intrusive yet more expensive, such as Facebook put options.

Must see to appreciate!

Let’s finish up our week in The City with some, um, Extreme Real Estate photography.  Thanks very much to Burbed reader Michael Boltonestater for finding this superb San Francisco studio.

1950 Gough St #203
San Francisco, CA 94109 (Pacific Heights)
$495,000

1 bath 600 sqft Condo
Open House:
Saturday Dec 15th, 2pm to 4pm
For Sale / Resale
Listing Details
7 Days on Trulia
397 views

Stunning Pacific Heights Jewel Box. This Lafayette Park view pied-a-terre in a desirable 1920′s steel frame building on top of the hill is sure to charm you with its attitude. Perhaps the most beautiful studio in San Francisco. Impressive chef’s kitchen. Formal dining area with built-ins. Hardwood floors and high ceilings. Handsome black and white tile bath. Inviting sleeping alcove. Good closets. Laundry, strg and small car deeded parking in bldg. Stunning lobby and facade. Elevator. A+ reserves. Professionally managed. Newly renovated Lafayette and tennis courts, Fillmore, Union, Polk, cultural meccas, downtown, Muni and Whole Foods.… Small pets ok.

Sorry, pending, and Redfin’s already yanked the pictures down but you can see the old listing copy, and better yet, the old (2003) price of $335K.  Also the old number of bedrooms (1) and the old HOA dues of $263. What the dues are now is a mystery. Perhaps this is a case of if you have to ask…

The missing photos are really a shame, as this curated photography gallery will really give your eyeballs a great workout.  We’ve included some of the better examples in case Trulia also goes dark on us.

Let’s begin with something you don’t often get to see in real estate photography: an actual action shot.  As you can see, not only is the building painted white, but vehicles can drive right by the front door.  Time-lapse photography illustrates how this could work in real life.

Also, in case the top photo made you wonder about the interior decorating scheme, we have plenty more that should assure you the current owner really did go all in on the burnt pumpkin and expired cream palette. 

Click on through to see those and more!

(more…)