April 23, 2011

What’s Your Home’s Walk Score?

imageZillow has added Walk Scores to homes on their site.  You can look up your house on Zillow or on Walk Score and see how walkable your neighborhood is, according to their formula.  The score is by the maps are on your house’s page.  Do you agree with your home’s walk score?

My neighborhood has a Walk Score of 65, or “moderately walkable.” However, there’s a new beta feature on Walk Score called Street Smart, which adds in number of intersections per square mile and block length in calculating the score, and on that measure my neighborhood goes down to 54, or only “Somewhat Walkable.”  What it doesn’t measure is how pleasant or unpleasant the walk is, based on number of shade trees or how well the sidewalk is maintained.

imageOh, it’s got some bugs, like calling a catering company run out of someone’s house a restaurant, but the idea makes sense.  I just don’t see being within 100 feet of a commercial zone as a good thing.  When I ran the same scores on a house across the street from some commercial zones near Fremont and Mary in Sunnyvale, the scores went up to 80 (Very Walkable, Walk Score) and 65 (Somewhat Walkable, Street Smart).  But another house behind a different big batch of retail centers at the corner of Hollenbeck and Homestead got scores of 66 and 69.

image

Feel free to report your Walk Score, or vehemently disagree with the algorithm, or bring up any topic you wish.  This is an Open Thread.  Remember, tomorrow is Easter, so late start to Spring Bounce this year!

Comments (12) -- Posted by: madhaus @ 5:08 am






April 21, 2011

Party House in Los Gatos

Here’s a find from Burbed reader nomadic, who keeps unearthing all sorts of delights in Los Gatos.  Thanks very much!

15681 KENNEDY Rd, Los Gatos, CA 95032
$7,495,000

image

BEDS: 7
BATHS: 12.5
SQ. FT.: 12,405
$/SQ. FT.: $604
LOT SIZE: 3.58 Acres
PROPERTY TYPE: Detached Single Family
STYLE: French
STORIES: 3
VIEW: Mountains
YEAR BUILT: 1991
COMMUNITY: Los Gatos/Monte Sereno
COUNTY: Santa Clara
MLS#: 81037550
SOURCE: MLSListings
STATUS: Active
ON REDFIN: 263 days

Everything you ever dreamed of is right here in this magnificent French Chateau Estate. Main house 9,000sf, 6 complete suites, gold leafed fireplace, music room, library, wine cellar. Guest house is 3,500sf with guest suite, caterer’s kitchen, ballroom, theater, game room, onyx bar. Infinity pool, impressive portico, band and dance area many more special features. Incredible estate.

Here’s what nomadic had to say about this house:

imageDo you suppose this house comes with the band, and requires you to board all of the guests seated around the table? I guess for $7.5M you should get live-in entertainment included.

We already had a house ready for a party back at the beginning of the year, but this may be the first time the photos featured a party actually in progress.  Do you think the guests will sue or are they Facebooking their friends to say “Did you see I made Redfin?”  Actually from the age of this crowd I should ask if they’re telexing their friends, that is if they can’t get the houseboy to run down to Western Union.

imageimage

Another thing to ask is just what this agent was trying to accomplish with this particular selection of photos.  It’s not so much that they’re bad photo, they aren’t.  But there’s a sameness about them that seems curious in trying to sell a home of this type.

imageimage

Also I refrained from breaking out the little red arrows, but we have some mawbul kawlums going on here, or at least kawnkrete.

imageimage

Okay, I’ll say it.  Seven and a half megageorges for this house, and they can’t be bothered to photograph the inside?  Maybe they’re trying the exclusivity angle by restricting the view to qualified buyers only.  But I’ve seen enough people pretending they have money when the whole financial structure is cantilevered atop playing cards and toothpicks, or in the real estate world, Different Piles of Other Peoples’ Money.  The upside of leverage is the profit when home prices go up, and the downside, well, if you aren’t smart enough to work that out then you get what you deserve.

Maybe they didn’t show the inside because the FBs can’t afford to furnish the place.

Okay, that was a cheap shot, but Redfin didn’t have a link to any other pictures.  I did go over to Zillow, intending to get the missing listing prices, and they had inside pictures plus they link to the virtual tour.  In a way, I’m kind of sorry I found it.  Not only is this place overdecorated like a simulacrum of “rich people’s furnishings,” the audio track is pseudo-wealthy music, too: the goddamned Pachelbel’s Canon in D.

kennedy_rd_liv_rm

I hate Pachelbel’s Canon with a passion.  Maybe that’s why the house hasn’t sold in more than two years. (253 days on Redfin, my sackbutt.)

image

This house may not be on VH1’s I Love the 1680s, but it sure loves 2006.  I say it’s going to party like it’s 1999.

Comments (11) -- Posted by: madhaus @ 5:11 am

April 4, 2011

Make Me Move, Please, Please, Please Make Me Move

Here’s someone who tried setting a Make Me Move price on Zillow and is now chasing the market down.  Or rather, meandering after the market which is chasing after a bunch of expired tax breaks.

765 DEVONSHIRE Way Sunnyvale, CA 94087
$949,888

image

BEDS: 4
BATHS: 3
SQ. FT.: 1,816
$/SQ. FT.: $523
LOT SIZE: 6,976 Sq. Ft.
PROPERTY TYPE: Attached Single Family
STORIES: 1
YEAR BUILT: 1961
COMMUNITY: Sunnyvale
COUNTY: Santa Clara
MLS#: 81110309
SOURCE: MLSListings
STATUS: Active
ON REDFIN: 21 days

Great Location * Excellent Cupertino schools * Energy efficient * Spacious 4bd/3ba contemporarily remodeled * Bright * Low-VOC paints inside out * EnergyStar IB Roof System * Radiant heating * Double pane windows * Well insulated walls * maple cabinets * granite countertop * Stainless steel appliances * Huge beautiful backyard w/ fruit trees * Open house 3/26, 3/27 (1:30 ~ 4:30)

Stop me if I have this wrong, but isn’t this seller asking for almost a million bucks for a glorified box?  Face it, every child’s drawing of a house has something that this house is lacking in.  Maybe you can look at the listing image above and figure it out.

imageHere, I’ll even give you one more chance.  One of these things is not like the other things.

Anyway, I headed over to Zillow to find out the asking price from 2009, and discovered that there was a Make Me Move price on the house.  And it was $970,000. Now, Make Me Move can be complete utter Wishing Price, as there’s no obligation to sell it just because you entered it into Zillow.

image

Only this seller decided that the Make Me Move Wishing Price was a perfectly good place to start as an actual Asking Price.  We can see just how well that worked.

So after such drastic price cuts as 2% followed by 1%, the seller takes the listing off the market completely… and then it’s back two years later.  It’s back at its first price reduction, which shows the seller really hasn’t learned a danged thing in two years.

Somebody buy this and Make Them Move, because they aren’t going to do it on their own.

Comments (8) -- Posted by: madhaus @ 5:01 am

March 21, 2011

Zrent vs. Zbuy

Zillow, the website that brought you the Zestimate, now has a brand-new feature to make fun of.  We’ve all chuckled over how surprisingly off the Zestimate of a home’s value could be.  Well, in the words of Mr. Family Guy, “You think that’s bad?”

Zillow has just introduced the Rent Zestimate.  Yes, now we can compute the Zrent Zratio, using two estimates that may or may not have anything to do with reality!  Let’s try it with a few houses previously featured on Burbed!

image

Here’s Friday’s house, the Tangrams Set with the High-Tech name.  Once more, the Zestimate has no relation to real life, because if it did this place wouldn’t be sitting unclaimed for 113 days at $200K less than Zillow’s amazing valuation model’s prediction.  To compute the Zrent Zratio, divide the Zestimate by the annual Rent Zestimate.  For this house, $762,000 divided by ($3081 * 12) is 20.6, a number that says rent, don’t buy this house.  (A number above 15 says rent, a number below 15 says buy.)

Although I think the answer is really don’t rent or buy this house, so let’s try again with something a little more desirable.  So let’s stop and smell the roses.

image

Well, here’s a Zestimate a little more down to earth, as this Beautiful Specious Home is listed for $239,000.  The Zrent Zratio is $217,500 / (1345 * 12) or 13.5.  Buy!  Buy!  BUY!

And here’s our most recent run-in with MAWBUL CAWLUMS, it’s the Shrek House.

image

Ready?  Oh oh, this place has a Zestimate about 30% of the asking price.  I didn’t say 30% lower, I said it’s 30% of the asking price.  I’m sure the FBs will be happy to set Zillow straight on this.  And the Zrent Zratio is… $1,427,000 / (5587 * 12) = 21.3.  Rent.  Definitely rent.

Okay, now for grins, we’re going to compute the rent ratio using the wishing prices of all three homes, and Zillow’s Rent Zestimate.

  • Poinsettia: $575,000 / (2979 * 12) = 16.1 (weak rent, buy it if you love it)
  • Gibraltar: $217,500 / (1345 * 12) = 14.8 (buy or rent, it’s a wash)
  • Butch: $4,999,000 / (5587 * 12) = 74.6 (rent rent rent rent rent rent are you kidding me?)

So, what do you think of Zillow’s new made up numbers?  Do any of these rents have anything to do with reality?  And if you divide one invented number by another, does the nonsense cancel itself out?

Comments (80) -- Posted by: madhaus @ 5:11 am

January 9, 2011

We Wuz Robbed Again

Zillow Blog recently had a post covering “Some of 2010’s Top Real Estate Sales.”  Yet not one of them was in the Bay Area, let alone the Real Bay Area.  The ten featured home sales were mostly in Southern California, with one at Pebble Beach, one in Manhattan, and three in Florida.

Something has got to be wrong with those statistics.  The most expensive home in the article was a Bel Air beast, and another Bel Air battlement checked in at #5.  There were also two from Malibu, the aforementioned Pebble Beach, plus Santa Barbara.  Florida had disasters in Delray Beach, Naples, and Highland Beach.  (No wonder Florida real estate is hurting even more than California, at least we know how to spell del Rey over here.)

I was able to find several properties that sold in 2010 over $10 million in the Real Bay Area, and we’ll talk about those places another time.  Instead, there’s something more of interest about this Zillow piece:  How bad were the haircuts on each of these houses?  When the seller thought they could get $20 million, how much did they actually get?  Are we talking five percent?  Ten?  Fifteen?  Zillow didn’t feel this information was all that important, but we at Burbed know that watching the sellers chase the market down is the biggest part of the fun.

image

#1. Le Belvedere – Bel Air, CA

Original Price: $85 Million (February 2009)

Reduced Price: $72 Million (November 2009)

Sale Price: $50 Million (June 2010)

Haircut: -43%

This house leads to all kind of speculation since nobody is sure exactly who owns it.  It has since been sold to 2 limited liability corporations.  The 11 BR/14 BA 48,000 sf home (yes, 48,000 square feet) requires a staff of 15 and is on a 2.2 acre lot.  You can pick up this Bel Air listing for $53 million (9 BR/21 BA) if looking at this picture is making you think, “You know what?  I really want an insanely large and expensive home in Southern California.”

Redfin had this listing for a 7 BA/15 BA 35,000 sf house on 2+ acres, which Zillow says is the same one, but key details differ.  A 10/15 did sell for $18 million last January, but it was less than half the size of La Belvedere.

image

#2. Carbon Beach Gem – Malibu, CA

Original Price: $57 Million (March 2010)

Reduced Price: $47 Million (June 2010)

Sale Price: $36,969,000 (October 2010)

Haircut: -35%

This 8 BR/12 BA is 12,785 sf and has a mere 3/4 acre lot.  However, that lot includes 180 feet of Malibu beachfront.  Plenty of instant equity, this place has a Zestimate of $39,733,000!  While the first house write-up above freely speculated over who the owner is, not a peep as to who bought or sold a home on “Billionaire’s Beach,” where “you could run into celebrities such as Jennifer Aniston and David Geffen.” Or in this case, older ladies who go to lots of fundraisers.  Property Shark didn’t indicate who the new owner was.

image#3. Malibu Colony Beach House – Malibu, CA

Original Price: $23,950,000 (April 2010)

Sale Price: $21,475,000 (September 2010)

Haircut: -10.3%

Zillow points out that this house is only 5,000 sf, so we’re talking $4,295 a foot.  A half acre lot but only 60 feet of beachfront, and that’s 60 more feet than any house in Silicon Valley will have until the Pacific and the Bay rise a couple dozen feet.  The property has not one but two guest suites and a gym, separate from the main building.  Given that exterior has all the charm of a Santa Cruz 8-plex motel, that’s an improvement.  Plus, you might run into Tom Hanks, Bill Murray, and other celebrities even older than I am.

Property Shark doesn’t have the most recent sale record, but the seller lived in Tiburon.

image#4. Pebble Beach Jewel – Pebble Beach, CA

Original Price: $25 Million (March 2010)

Sale Price: $18.75 Million (May 2010)

Haircut: -25%

Almost twice as large as the last beach house, this 6 BR/4.5 bath on 1.3 acres has all the charm of a Presidential library, minus the historical documents or the gravitas.  Unlike Malibu Beach, here you have “Out one set of windows is the surf crashing along Pebble Beach’s craggy coast where harbor seals come to visit.”  Evidently out the back windows is some golf club or something.  Guess any celebrities worth running into would be out there clubbing the seals.

Seriously, does Zillow think nothing in the RBA has sold for more than $10 million last year?  Or just that they weren’t trying very hard?  I found this place in San Francisco that went for $15.5 million, and this one in Woodside.  Someday we’ll talk about those…

image#5. Bel Air Mediterranean – Bel Air, CA

Original Price: $24,500,000 (February 2009)

Reduced Price: $19,750,000 (July 2009), $18,950,000 (February 2010)

Sale Price: $16,250,000 (May 2010)

Haircut: -34%

Want it?  It’s for sale again, showing that flipping houses hasn’t gone out of style in some places.  Listed for $19.5M this October, only 5 months after it sold for $16.25M, the price was cut a whopping 3.8% to $18.75M a month later.  This is a 13,000 sf 7 BR/11 BA behemoth on 0.85 acre, plus the listing agent is married to a Real Housewife of Beverly Hills.  I swear I am not making this up.

Given that the listing doesn’t mention a speck of improvement that the new owner put in, anyone want to predict their exit price point?

Bonus feature: The property was foreclosed on during bubblicious 2004 for $700,000, before the current structure was put in.

image#6. Dramatic Delray – Delray Beach, FL

Original Price: $24,900,000 (July 2008)

Reduced Prices: $21,900,000 (November 2008), $18,950,000 (June 2009), $21,500,000 (July 2009), $18,950,000 (September 2009), $18,975,000 (February 2010)

Sale Price: $12,650,000 (April 2010)

Haircut: -49%

Nothing says dramatic real estate crash like Florida real estate, and here’s a spectacular example.  Best of all, it’s up for sale again at $19.5M with the exact same agent, showing some people are very slow learners.  At least they have over 14,500 sf of house to learn slowly in, with 6 bedrooms and a WTF 7.3 bathrooms on 2.13 acres.  Florida real estate is definitely different than anywhere in the US.  Where else would a 16 foot elevation be described as “commanding”?  Features 160 feet of “frontage” but onto what isn’t clear.  Perhaps the 16 foot towering precipice above the Atlantic.

image#7. Upper East Side – New York, NY

Original Price: $17,000,000 (September 2009)

Reduced Price: $15,900,000 (January 2010)

Sale Price: $13,150,000 (September 2010)

Haircut: -23%

Gordon Gekko might have said that “Greed is good,” but in New York City, stock market traders have another slogan about making money: “Bulls make money, bears make money, pigs get slaughtered.”  And this “grand 20-foot wide mansion” sold for $10.5M in March, 2008.  Yes, you too can pay eight digits for a five story house that literally has the breadth of a double garage, and it doesn’t even come with one!  Boasting 6 bedrooms, 6 baths, 8000 square feet and a lot size of (get ready) 2000 sf (0.05 acres), and around the corner from an actual Park Avenue address.

The current owner is now a floplord, looking for a tenant for 109 E 69th St.  The rent?  $48,000 a month.  Hope they don’t expect three months’ security up front.

In case you’re interested, that makes this property have a rent ratio of 22.8.  Typical rent ratio for Manhattan is well over 30, which suggests some pig is about to get slaughtered again.

image#8. Santa Barbara Villa – Santa Barbara, CA

Original Price: $19.5 million (August 2008)

Reduced Price: $16 million (March 2009)

Sale Price: $13 million (September 2010)

Haircut: -33%

Whew!  That was too long outside of California.  Between the old people of Florida and the New York cabbies who enjoy speeding up to love-tap pedestrians in crosswalks, that was a definite dollop of cognitive dissonance.  Face it, high prices should stay in California where they belong.  Why would anyone pay lots of money to live in a city where 16 inches of snow shuts the whole place down?

No doubt the Zillow blogger who put this piece together was so relieved to cover a California property that s/he neglected to notice the original (and much higher) list price for this house.  Maybe this one item was farmed out to Tech Gal, the Peninsula real estate agent notorious for her sales to listing price ratios based on reduced asking prices.

Speaking of the house… This 8592 sf home thinks of itself as a Tuscan villa, but it’s got a modern tax bill to greet you.  A 5 BR/6.5 BA main house plus a 1 BR/1 BA guest home on the 3.4 acre grounds guarantee you’ll keep a gardening staff busy all year.

image#9 Gulf Coast Grace – Naples, FL

Original Price: $16.5 million (May 2009)

Reduced Price: $15.9 million (July 2009)

Sale Price: $13 million (January 2010)

Haircut: -21%

This over 9000 sf house on Naples Bay is situated on 3/4 of an acre but is still in the sinkhole of Florida real estate.  Even Zillow looks at last year�
��s sales figure and comes up with a Zestimate of $11,013,000, suggesting that this palatial estate lost another 15% of its value merely by spending all of 2010 in Florida.  Once more, the Zillow blogger missed the original price, misunderestimating the amount a Florida property can plummet.

image#10. Living the High Life – Highland Beach, FL

Original Price: $18,900,000 (May 2009)

Reduced Price: $15,950,000 (July 2009)

Sale Price: $12,650,000 (January 2010)

Haircut: -33%

If a second marriage is the triumph of hope over experience, then buying a 12,000 sf house on 0.95 acres of Florida real estate for 67% of the original asking price is the knifecatcher’s exhilaration.  This brain-damaged fool has put the place back on the market for $14,950,000, just six months after taking delivery.  Given that Zillow has depreciated the previous property by 15%, I would calculate that this Adventure in Real Estate is going to lead to another 28% trip down Equity Burn Esplanade.

Comments (49) -- Posted by: madhaus @ 5:06 am

December 23, 2010

Cheapest House in Atherton

Black Friday DEALS continue, and thanks to Burbed reader sonarrat for finding today’s budget-blessing beauty.  Here’s what sonarrat had to say about today’s find:  “That’s the one block of Atherton that has all small lots and tract homes like Redwood City.”

208 Selby Ln, Atherton, CA 94027
$1,295,000

image

Beds: 3
Baths: 2
Sq. Ft.: 2,760
$/Sq. Ft.: $469
Lot Size: 6,250 Sq. Ft.
Property Type: Detached Single Family
Style: Traditional
Stories: 2
View: Neighborhood
Year Built: 1965
Community: El Camino to Alameda
County: San Mateo
MLS#: 81053468
Source: MLSListings
Status: Active
On Redfin: 45 days

Amazing value for this 2,700 +/- sq. ft. home. Has never been on the market. Formal entry, elegant living room with formal dining room, large bedroom suites, lovely backyard. Best price in west Atherton. Kitchen opens to spacious family room. Amazing opportunity.

Best price in West Atherton.  And some wags thought I made up West Atherton.  Nuh uh.  A professional Real Estate professional type lady professional said “West Atherton” in the copy above.  So let’s have a good look at what makes West Atherton so Special.

image

See?  It’s in Atherton, but West!  You can live just like the working class in Redwood City, except your postman reminds you every day that you live in Atherton!  And so will your property tax bill.

image

Best of all, this snout house has never been on the market.  That means if you buy it now, it won’t have too many agent cooties.  Now that’s a DEAL.

Comments (7) -- Posted by: madhaus @ 5:05 am

August 29, 2010

Thank you, thank you, thank you!

Thank you to all who voted for Burbed!

San Francisco Real Estate

Now, this is an award winning website!

Comments (13) -- Posted by: burbed @ 5:45 am

April 15, 2010

Make me move price – just $1.1M!

2336 Azevedo Pkwy San Jose CA 95125

3 beds, 2.5 baths, 2,438 sq ft

Make Me Move® Price: $1,100,000

image

Thanks to Burbed reader ES for this find! Here’s what EV had to say:

I’ve noticed delusional prices on zillow’s "make me move" feature before, but this one takes the cake:
http://www.zillow.com/homedetails/2336-Azevedo-Pkwy-San-Jose-CA-95125/64432523_zpid/
If you recall, I had sent you a property on this road in the same development maybe last year… the one across from the graveyard.  well this one’s across from the graveyard too.  The "make me move" price is double the zillow estimate, which is 15% higher than actual comps in the same development. 
How screwed do you think this "owner" is? 
It would be sad if it weren’t absurdly stupid.

Is this owner screwed? Or just waiting for Summer Bounce?

Comments (25) -- Posted by: burbed @ 5:01 am

August 10, 2009

$780,000 for a 2br/1ba in Oakland… free storefront?

1407 23rd Ave, Oakland, CA 94606 – Zillow

For Sale: $780,000

1407

* 2 beds
* 1.0 bath
* Built in 1900

Thanks to Burbed reader Jason for this find. While Jason claims that this is a bargain, I’m a bit perplexed as to what exactly you’re getting. Let’s take a look at some of the other photos:

1407a

I don’t get it. Does this include the store front? If so, that’d be pretty awesome as you could turn that into your living room. You could fill it with LCD TVs that you’re buying with equity that you would otherwise be throwing away by renting. And when people walk by, they’ll be incredibly envious of your pride of ownership!

Hey check out what’s going on in the neighborhood:

1407b

That’s right… new housing. This area is starting to gentrify. Soon there will be a starbucks, a jamba juice, a babies r us, and 24 cupcake and fro-yo stores! And then your 1900 era propery will suddenly be worth $2 million as yuppies all over will be falling over themselves to buy your house.

What are you waiting for? You can’t possibly lose!

Comments (11) -- Posted by: burbed @ 5:16 am

July 6, 2009

A good example of how Zillow is unreliable

290 CHIQUITA Ave, Mountain View, CA 94041 | MLS# 80929905
290 CHIQUITA Ave Mountain View, CA 94041
Price: $1,190,000

290
Beds: 3
Baths: 3
Sq. Ft.: 1,565
$/Sq. Ft.: $760
Lot Size: 4,414 Sq. Ft.
Property Type: Detached Single Family
Stories: 2
Year Built: 2009
Community: Downtown
County: Santa Clara
MLS#: 80929905
Source: MLSListings
Status: Active
On Redfin: 3 days
Brand New Home. Spacious floor plan, open and bright. Elegant Hardwood Entry Door w/ sidelights. Chef’s Kitchen w/ Stainless steel appliances, lots of hand stained cherry cabinets w/ Granite slab countertops. Gorgeous imported Tigerwood floors, Importd Tile and Marble in kitchen ad Baths. Spiral Staircase. Double hung, dual pane windows AND lots more. A MUST SEE TO APPRECIATE. .. Open Sat/Sun 12-5

Thanks to Burbed reader K.M. for sending this in.

Unfortunately, I think K.M. got things mixed up when she wrote this:

Outrageous, asking price on this house is double the Zillow, surrounded by a parking lot in a sketchy neighborhood.

Now while it’s true that Zillow only provides a ZEstimate of $585,000, I think this is more of an indicator of how Zillow can be unreliable.

You see, Zillow still doesn’t have a strong model for the Real Bay Area. They need to improve their algos to account for “special”. It’s hard, but I bet they could do it if they just knew about this deficiency.

Anyone here know any Zillow employees that they can talk to about this?

Comments (183) -- Posted by: burbed @ 5:54 am
 
Page 7 of 8« First...45678