May 2, 2013

Will not last in Mountain View: this is under valued

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

130501-leghorn-refin1950 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.

130501-leghorn-lot130501-leghorn-floors

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






June 13, 2012

If you like parking you’ll love this Belmont home!

Have you ever realized that you aren’t spending enough of your time parking all of your cars?  Why not buy a house that fixes that terrible lack in your life?  After all, pure parking pleasure requires just the right property, and perhaps this is the perfect palace!  Thanks much to Burbed reader Michael Boltonestater for this beauty of a building in Belmont!

820 EL CAMINO REAL
Belmont, CA 94062
$669,000, reduced from $709,000

120612-elcamino-redfin

BEDS: 5
BATHS: 3
SQ. FT.: 2,200
$/SQ. FT.: $304
LOT SIZE: 3,250 Sq. Ft.
PROPERTY TYPE: Detached Single Family
STYLE: Mediterranean
STORIES: 2
VIEW: City Lights
COMMUNITY: Belmont Country Club
COUNTY: San Mateo
MLS#: 81211546
SOURCE: MLSListings
STATUS: Active
ON REDFIN: 76 days

Single family home locate on commercial zoon, city may allow home office use for light industry. Interest party need to confirm with city ordiance. 3 bedroom 2 bath upstairs (one master), two additioanal bedroom 1 bath downstairs done with permit. Spacious garage park up to 4 cars tandem.

Today’s featured house convenient to, well, everything (how much more central can you get than the Street of Kings?).  Plus, by only including one photo the agent has made it easy for you to review this listing as quickly as possible.  Not only that, this house is even more Special than you think.  It’s been on Burbed before!

120612-elcamino-burbed-090302

120612-elcamino-oldlistingWow, you can buy it for less than its 2009 asking price, despite it being in the middle of a red-hot market.  And that’s an old asking price, because the home was delisted the day before it appeared here back in 2009. 

Also we just had to sneak in this really old listing picture from when it sold in 2000.  For $535,000.  Think of how much this place is really worth now!  And there’s more good news!  The Redfin agent has done the legwork so you don’t have to.

120612-elcamino-redfin-agent

This location is perfect.  If you don’t already have four cars, step next door and buy them.

120612-elcamino-streetview

Don’t like what they’re selling next door?  No problem at all!  Just head across the street to the CalTrain station and check out what’s chillin’.

120612-elcamino-satellite

Look, you’re a busy person.  This house has a four car garage.  That works out to 25 years per covered parking space.  Now that’s a DEAL.

Comments (16) -- Posted by: madhaus @ 5:07 am

May 18, 2012

Be a San Francisco media giant!

Let’s finish out the week with another find in San Francisco. Once those Facebookers get their hands on all that IPO money, lots and land there are going to be made out of unobtainium.  Thanks very much to Burbed reader Petsmart Groomer for this SoMa spot, ready for your serendipity.

1376 Harrison St
San Francisco, CA 94103
$699,000

120517-harrison-redfin

BEDS: –
BATHS: –
SQ. FT.: –
LOT SIZE: 2,374 Sq. Ft.
PROPERTY TYPE: Lots & Acreage
COMMUNITY: South of Market
COUNTY: San Francisco
MLS#: 392692
SOURCE: San Francisco MLS
STATUS: Active
ON REDFIN: 126 days

Billboard on Site

120517-harrison-billboard

This urban homestead, or Garage 4.0, depending on what use you feel is best, ready for you to build upon.  But there’s so much more than a generous half of a tenth of an acre lot.  There’s also a steady stream of hard liquor advertising dollars, too.

Well, the billboard seems attached to the building next door, but we didn’t say the advertising payments would be going to you.  The agent just notes there is a “Billboard on Site”. 

The photo also reveals that you’re close to transit.  Real close.  So let’s get a better picture of the lot, courtesy of Google Streetview.

120517-harrison-streetview

Billboard still on site.  Facebook’s better watch out for you!

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

May 11, 2012

Congratulations to citizens of Mountain View

Housing at Mayfield mall site dumped for offices 

After almost a decade of contentious planning and untold millions to design, the 27-acre housing community planned for the Mayfield Mall site has been ditched for a $90 million deal to re-use the existing buildings as an office campus.

Congratulations to the citizens of Mountain View! You are victorious!

You stood tall and proud in the face of evil developers who threatened to add more housing to the Real Bay Area.

You fought valiantly at efforts to reduce commute times and potentially prevent housing prices from eternally going up.

You held your ground when confronted with the threat of allowing more people to live in your city.

Kudos to you Mountain View citizens. Kudos to you!

 

And kudos to the commenters of the Mountain View Voice website! Like this one!

Bravo to office space vs. housing and all the traffic that would bring. What a lot of wasted time and money over this past decade trying to fight the housing development(s). Went to a lot meetings at City Hall to fight the developments and did not feel our council members did enough for the existing neighborhood. Am very grateful the existing structure will be reused and that our beautiful trees will remain. I hope traffic through our neighborhood will be kept to a minimum. The old Mall/HP campus is lovely when the trash is picked up and and the weeds are kept down.

Because nothing says less traffic like more office space!

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

April 27, 2012

It’s a floor wax! It’s a dessert topping! It’s Mountain View!

Burbed began its life as a housing price and mortgage insanity site back in 2006.  And if home prices keep going up, up, up like they are now in some Very Special Places, we could be back to our glory days soon, when every article had over 100 comments no matter how meh the listing was.

Not only are listing prices up Where It’s Special.  So are lease costs.  Have a look at this well-situated rental, courtesy of Burbed reader Adennris.

229 Polaris Ave
Mountain View, CA 94043
For Rent: $1,195,000/mo

120424-polaris-zillow

Beds: —
Baths: —
Sqft: —
Lot: 15,246 sq ft / 0.35 acres
Type: Single Family
Year built: 1973
Parking: —
Availability: now
Lease term: ContactForDetails
Cooling: —
Heating: —
Fireplace: —
On Zillow: 21 days
MLS #: 81211034
Other facts

This may be a bigger entry error than simply putting in a sales price in the monthly rental field.  Here’s this same property on a realty site (photo right) and here’s the listing copy.  It’s a little different than what Zillow had.

120424-polaris-alanhuweGreat income opportunity for the right buyer. 1031 exchange is possible. 2 buildings on one lot. Many possible uses in the ML disdrict of Mountain View. Near the worlds greatest companies and close to many of Mountain View’s wonderful services and delights. Easy commuting access to El Camino, Central Expressway, 85, and 101.

Last updated on  4/25/2012

More Details for 229 POLARIS AVE

Property Class:Commercial Industrial
Listing Status:Active
City:Mountain View
Area:203 North Shoreline
County:SANTA CLARA COUNTY
State:CA
Lot Size:15164.00 SF
Stories:2
Year Built:1973
MLS#:81211034
List Date:3/24/2012

So it’s not a single-family home, then?  But the upside is you definitely can bring your arc welder.

Trulia calls it an income/investment.  But Zillow wasn’t the only one to assume this place was a residence.  Check it out!

120424-polaris-sfbrealty

This is a 380 square foot, single family home, which can rent for only $608 a month.  No beds or baths, but it has assigned schools, and more importantly, places doing business.

Redfin never heard of this location or either MLS listing number above.  That’s because this site is a 6019 sf office building for sale.  And this description might explain all the confusion.

Check this out!!
Real close to downtown Mountain View.
16 unit office building in ML district of Mountain View.
2 buildings on one lot.
Recent Zoning changes have allowed for additional uses.
ML zoning.
Buyer to check with City of Mountain View for precise zoning uses allowed for this location.

Near down town Mountain View.
Blocks from El Camino.
Easy access to highway 101, Central Expressway and highway 85.

If you read all these conflicting real estate offers for the same location, you will also notice that it’s been described as being in three different neighborhoods.  That’s because Mountain View is so cutting edge, it transcends space, time, and money.  No wonder it’s so hot, hot, hot!

Comments (15) -- Posted by: madhaus @ 5:04 am

April 21, 2012

Pride of Ownership: Los Gatos Edition

Thanks very much to Burbed reader Kir for passing along this nugget from her blog Inside Los Gatos.  While this is a commercial property, there’s no reason why it couldn’t be returned to its original purpose as an ostentatious trophy home.

120420-santacruz-house

Pride of Ownership Retail Investment | Los Gatos

115 N. Santa Cruz Avenue
Los Gatos, CA 95030
$4,900,000

Building Size: 7,300 SF
Price/SF: $671.23
Property Type: Retail
Property Sub-type: Free Standing Bldg
Property Use Type: Net Lease Investment with 10+ years left on lease
Cap Rate: 5.14%
Occupancy: 100%
Tenancy: Single
Lot Size: 17,987 SF

Highlights

  • Iconic Historic Building – One of Los Gatos’ Most Well Known Landmarks
  • Irreplaceable Downtown Los Gatos Location
  • 100% Leased to Experienced Restaurant Operators
  • New 10 year Lease w/Scheduled Increases
  • Minimal Landlord Obligations
  • Recent Extensive Renovations

Here’s what Kir had to say about this place over on Inside LG:

Coggeshall Mansion is For Sale

120420-palacio-dallasOne of our readers sent me a real estate flyer about the Coggeshall Mansion. I was going to post it in my "Where to Build a School" column, but decided it would be just too ridiculous of an idea; however, I want to share the fact that you can own a piece of historic downtown Los Gatos.

The history of the Coggeshall Mansion is interesting, to say the least. The house was originally built for Mary G. Coggeshall, a wealthy widow with two children. According to Alastair Dallas, "Once a grand home, one of many along N. Santa Cruz Ave., the Coggeshall Mansion was built in 1891 and converted into the Place Mortuary in 1917. When it re-opened as the Chart House restaurant in 1976, the bar in the back was called the Embalming Room. After the Chart House closed, the restaurant was known as Trevese from March 2007 to Fall 2009…" Now, Palacio inhabits the mansion.

Hooked on Los Gatos has a 1949 flyer depicting the Place Funeral Home. You can check it out HERE. In fact, many of the locals swear the mansion is haunted.

120420-place-funeralSo not only is the former home being sold at a premium as commercial in-town property, it comes with “bunus” ghosts.  Here’s some more on the hauntings mentioned above.

Unfortunately the link above is to yet another Google product called “knol” that’s being abandoned for insufficient awesomeness. That means the link above may not work after May 1st.  Sorry about that. 

Here are the links given in that article about the ghosts, like the one who runs up huge bar tabs or the little girl who turns wine bottles hiding the label, or the little boy running outside the building.

This house/restaurant/funeral parlor is definitely for someone who had a huge pile of stock option cash dumped in their lap who wants to one-up all those Facebook poseurs househunting in Palo Alto and Hillsborough.

Thanks very much to Kir for allowing us to reprint articles that mention real estate.

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

July 19, 2011

Albion Castle produces 10,000 gallons a day of spring water

Today we have another terrific find from Burbed reader sonarrat!  Unfortunately, it’s been sitting in my inbox so long it’s growing mold, and what’s worse, those fickle sellers have yanked it from Redfin!  So, if you could convince them to sell again, how would you like your own castle?

881 Innes Ave, San Francisco, CA 94124

image

DAMN, missed it!  And look at the location it’s in, too!  Sounds classy! Foxhounds and riders and horns, oh my!  Here’s what sonarrat had to say about the place:

Albion Castle.. produces 10,000 gallons a day of spring water.. sounds great! …it’s WHERE??!

It’s in San Francisco! Let’s see where exactly… after the break, because I’ve got more to show you.

(more…)

Comments (9) -- Posted by: madhaus @ 5:09 am

August 21, 2009

Work/live at home in Moss Beach!

MLS Property Details :: MLS Listings :: Philip Watson
887 Etheldore St, Moss Beach
MLS#: 80937306
Status: Active
Beds: 3
Baths: 3
Sq Ft: 2,300
Lot: 8,000 Sq Ft
Age: 86

List: $799,999

887

Public Remarks: Work/live at home!!! Mixed use buildings. Unit “A” and Unit “B”. Owners have done a beautiful job renovating both structures. Unit “A” has a residential area and a commericial area. Unit “B” is currently used as a residential space. Loaded with old world character and charm. Large sunny lot with flat useable spaces. Nice use of finish work on interior. Many uses for residential/commercial.

It’s Friday, so I figured I’d head over to the beach. Thanks to Burbed reader TK for this find!

Let’s see what TK had to say:

Hello Burbed,

The misspellings, syntax errors, and extreme hyperbole are way too common among our local real estate agents to even register as humorous anymore.  Still, the below listing caught my eye because it lists 3 bedrooms (for an unusual property in Moss Beach) but displays two pictures of the identical bedroom.  We know real estate agents don’t employ editors but why don’t they check their postings for errors?  If I made a 6% comission on sales of million-dollar homes, I would feel a little obligated to get things right.

Clearly TK doesn’t read techcrunch or any other tech blogs! Hyperbole is mandatory! It’s what sells!

But, let’s take a look at those photos:

887a

Sure there’s two pictures of the bedroom – but that’s only because it demonstrates so much of that new world charm!

That’s why this is the greatest property in the entire universe! (Note, there may be some hyperbole.)

Comments (136) -- Posted by: burbed @ 5:53 am

July 28, 2009

You can run your own home-based business in this oakland house

1607 High St, Oakland, CA 94601 MLS# 40409403 – Property Details

$480,000

1607

Status: Active
Bedroom: 4
Bathroom: 2

* Year Built: 1922
* Lot Size: 4869
* Square Footage: 1792
* List Date: 5/9/2009
* Garage Spaces: 0
* MLS#: 40409403
*

See All Homes for Sale in Oakland
Bird’s Eye View Pictures
Description of 1607 High Str, Oakland
Unique property with a detached studio large fenced in area with security gate.Beautiful fireplace, 4 bedrooms, 2 bathrooms. Presently being use as a business also. Plenty of off street parking. Completley painted in and out. Everything new appliances stay.

Thanks to Burbed reader Sonarrat for this find.

Wow… everything is “completley painted in and out”. And it’s currently being used as a business. Let’s take a look at some close ups!

1607b

You’ve gotta admit – it really is painted. Personally, I think there’s something very exquisite about the decor. It’s very much like an old cigar lounge, a back room gentleman’s club kind of ambiance. I wonder if some of the rooms have bear or tiger skins.

One thing that still puzzles me is what kind of business is being run out of this house. Let’s take a closer look outside:

1607a

What are your guesses as to what’s going on here?

Comments (19) -- Posted by: burbed @ 5:08 am