January 18, 2010

What’s going on at this property in Campbell?



Beds: 1
Baths: 1
Sq. Ft.: 724
$/Sq. Ft.: $760
Lot Size: 8,250 Sq. Ft.
Property Type: Detached Single Family
Style: Cottage/Bungalow
Stories: 1
View: Neighborhood
Year Built: 1949
Community: Cambrian
County: Santa Clara
MLS#: 80932038
Source: MLSListings
Status: Active This listing is for sale and the sellers are accepting offers.
On Redfin: 177 days
Perfect Loc’n for a small business owner or contractor in need of a PRIVATE GATED Multi use property. Centrally located and close to Major Commute Arteries in Campbell. The property also has a detached Artist Studio which would be GREAT for extra storage. Wired for 220 Amp. LARGE LOT w/ room for your Trucks, Tools, Toys, ETC. New DBL Pane Wndws, wood paneling, fresh paint. Zoned Multi Use per City.

Mystery properties pop up from time to time in Campbell. This is one of them. What’s going on here?

Here’s some additional photos:


And, of course, the location:


And this picture:


Alright… I’m stumped. What gives with this property? How did this come to be? What can you do with this property?

Comments (15) -- Posted by: burbed @ 5:58 am

October 5, 2009

Handy man’s special in Campbell – needs some TLC!

109 S 4TH St, Campbell, CA 95008 | MLS# 80937293
109 S 4TH St Campbell, CA 95008
Price: $563,000

Beds: 2
Baths: 1
Sq. Ft.: 825
$/Sq. Ft.: $682
Lot Size: 9,233 Sq. Ft.
Property Type: Detached Single Family
Style: Cottage/Bungalow
Stories: 1
View: Neighborhood
Year Built: 1901
Community: Campbell
County: Santa Clara
MLS#: 80937293
Source: MLSListings
Status: Active
On Redfin: 35 days
Value is in the land. Investor Special. Build your dream house in downtown Campbell. You can demolish the front house and move the rear house to the front, or you can demolish both. Property is zoned PD. At least 2 units will fit, maybe more. Check with city. Property to be sold AS IS. Adjacent lot MLS# 80940201 also for sale. Buy one or both and develop. age of house unknown.

Holy moley. What’s going on here?

I know… I bet if we looked at all the photos, we can make sense of this!

Let’s give it a try:


Hm. That wasn’t quite as explanatory as I thought it would be.

Can you come up with a story to explain what happened here in Campbell? Challenge: Alien abduction references not allowed.

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

October 2, 2009

A great real estate subdivision opportunity in Campbell

1411 WESTMONT Ave, Campbell, CA 95008 | MLS# 80916027
1411 WESTMONT Ave Campbell, CA 95008
Price: $1,275,000

Beds: 3
Baths: 2
Sq. Ft.: 1,650
$/Sq. Ft.: $773
Lot Size: 0.82 Acres
Property Type: Detached Single Family
Stories: 1
Year Built: 1958
Community: Campbell
County: Santa Clara
MLS#: 80916027
Source: MLSListings
Status: Active
On Redfin: 160 days
Incredible . 81 acre (35,672 sq ft) prime Campbell lot. Tenant occupied 1600 sq ft home. Real value is in the land. Zoned R16. Possible to sub-divide into 2 or 4 parcels ??? buyer to confirm. Please respect the tenant.

First, let’s not kid ourselves. This is a smokin’ deal. .81 acres (or .82 acres depending on the day.) Wowsers. For just $1.275 million dollars.

Just think, if you scooped this up and divided it into 2 or 4 parcels, you could easily throw some houses on those parcels and sell them at $1 million each! CHA CHING.

But… there’s some strange things going on here.

First, there are people living there? Seriously? Or are they interred there?

But wait, there’s more:


So many questions!

  • Why is the property tax just $3266 if it was sold for $1,350,000 in 2007?
  • Can you really split up a lot that’s .81 or .82 acres length wise?
  • Why does the next door neighbor have a minute man missile silo?

Wow… you’ll need an expert realtor for this one!

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

September 15, 2009

This house is ripped straight from the headlines…

1117 HAZELWOOD Ave, Campbell, CA 95008 | MLS# 80940247
1117 HAZELWOOD Ave Campbell, CA 95008
Price: $419,000

Beds: 2
Baths: 1
Sq. Ft.: 819
$/Sq. Ft.: $512
Lot Size: 0.32 Acres
Property Type: Detached Single Family
Stories: 1
View: Neighborhood
Year Built: 1939
Community: Campbell
County: Santa Clara
MLS#: 80940247
Source: MLSListings
Status: Pending Without Release
On Redfin: 18 days

Thanks to Burbed reader Herve for this find.

This Realtor is clearly tapping the interest and news surrounding recent abduction recovery events, to present to you 1117 Hazelwood Ave in Campbell.

Have you thought about starting your own compound? If so, this house is for you. Just look at how versatile the yard can be! You can have all sorts of shacks, tents, RV’s, vans, trailers in the back. And, with the fence, you can keep those nosey neighbors out!

Privacy, flexibility – this house has it all for you. It’s just waiting for you to bring your imagination. Maybe you could even open a small amusement park!

What will you bring to this great property?

Comments (9) -- Posted by: burbed @ 5:12 am

April 7, 2009

The Bay Area mansion affordability crisis is solved!

Egads… I have so many back-logged mails from Burbed reader Herve, it’s time for another Herve week. Here’s Day 2:

867 BRIARWOOD Way, Campbell, CA 95008 | MLS# 80902984
867 BRIARWOOD Way Campbell, CA 95008
Price: $2,599,000

Beds: 5
Baths: 4
Sq. Ft.: 9,000
$/Sq. Ft.: $289
Lot Size: 0.64 Acres
Property Type: Detached Single Family
Style: Traditional
Year Built: 2008
Stories: 2
View: Neighborhood
Neighborhood: Cambrian
County: Santa Clara
MLS#: 80902984
Source: MLSListings
Status: Pending Without Release
On Redfin: 66 days
Magnificent 9000 sq ft luxury estate features meticulous attention to detail * This 1 year new Executive home is the perfect entertainer???s dream * Exquisite custom-built home features formal foyer * grand great room w/ 2-story dramatic ceiling * gourmet kitchen with 2 islands * full bar * 5 bdrms/4.5 baths * Office * 2-open space Dens/family rooms * Guest wing * separate gym * impressive movie theater and so much more!

Who says that the price per square foot in the Bay Area is astronomical! At $289 per square foot, this is plenty affordable – you just need to buy plenty of it! Buy more and save – you know how it goes!

But all seriousness, one thing I hear all the time is “Gosh, mansions in the Bay Area are so unaffordable! How can I live without a guest wing?” Well… this house solves that problem.

Let’s take a look at your mansion-y neighborhood:


Wow… nothing says champagne wishes and caviar dreams quite like this!

Actually this is a good thing since you’ll have plenty affordable housing for your army of servents. Win win!

Comments (156) -- Posted by: burbed @ 5:51 am

February 27, 2009

149 LLEWELLYN Ave, Campbell, CA 95008 | MLS# 80905491

149 LLEWELLYN Ave, Campbell, CA 95008 | MLS# 80905491
149 LLEWELLYN Ave Campbell, CA 95008
Price: $1,289,000

Beds: 4
Baths: 3
Sq. Ft.: 3,181
$/Sq. Ft.: $405
Lot Size: 9,072 Sq. Ft.
Property Type: Detached Single Family
Style: Ranch
Year Built: 2009
Stories: 1
View: Neighborhood
Neighborhood: Campbell
County: Santa Clara
MLS#: 80905491
Source: MLSListings
Status: Active
On Redfin: 14 days
Open Saturday 2/14 1:30-4:30pm. Brand new custom built home in the heart of Campbell. Constructed with attention paid to detail for the fussiest of buyers who want to move in and put their feet up. High ceilings, custom crown moldings, 2 clean air certified fireplaces, top of the line GE Appliances, built in espresso machine.

People ask me all the time – Burbed, what’s the next hot area to buy into?

My answer? I have no freakin’ clue.

Burbed reader Eric does though – look what he’s found in Campbell! Holy moley! It’s a 3000 square foot house that’s $1.289 million! It’s even got 2 clean air certified fireplaces – for all those times that you need to use a fireplace in the Bay Area!

Wow… even built in espresso machines. This is hot hot hot.

With more houses like this, Campbell might just be entering Real Bay Area territory soon!

Comments (26) -- Posted by: burbed @ 5:34 am

February 6, 2009

Let’s play: What’s wrong with this house in Campbell?

412 N CENTRAL Ave, Campbell, CA 95008 | MLS# 80900054
412 N CENTRAL Ave Campbell, CA 95008
Price: $779,000

Beds: 3
Baths: 2
Sq. Ft.: 1,549
$/Sq. Ft.: $503
Lot Size: 6,098 Sq. Ft.
Property Type: Detached Single Family
Year Built: 1941
Stories: 1
View: Neighborhood
Neighborhood: Campbell
County: Santa Clara
MLS#: 80900054
Source: MLSListings
Status: Active
On Redfin: 23 days
LOCATION! BEAUTIFUL HOME IN EXCELLENT CONDITION! WALKING DISTANCE TO DOWNTOWN CAMPBELL, Remodeled kitchen , recessed lighting, remodeled baths with all new copper plumbing, hardwood floors and new carpet in master bedroom, crown molding, central heating and air conditioning, newer composition roof, indoor laundry area. NOT A SHORT SALE. MOTIVATED SELLER WILL CONSIDER ANY OFFER.

At $503 per square foot, the price for this house in Campbell seems somewhat reasonable.

Yet, there are so many odd things about this house. Aside from the mysterious patch of dead grass, there are other things that I just can’t put my finger on.

What can you find that’s wrong with this house?

Comments (15) -- Posted by: burbed @ 5:41 am

August 19, 2008

“Previous Owner was permitted for 12 Kids earning over $100K/Yr! Day care”

864 Jones Way, Campbell, CA 95008 Campbell MLS# 80821405 – Property Details

* Status: Active
* Bedroom: 4
* Bathroom: 2&1/2
* Year Built: 1961
* Lot Size: 6360
* Square Footage: 1850
* List Date: 7/14/2008
* Garage Spaces: 2
Great opportunity for Day Care/Pre-School, Previous Owner was permitted for 12 Kids earning over $100K/Yr! Day care space at back of prop. clred by fire dept. Charming home, Quiet area, Bright tile Kitchen/Dining w/Garden Windows, nice Hdwd LR/Hall. Dual Paned Windows. Nice yard with automatic sprinklers and drip system. Room for RV. New Exterior and Interior paint * Cul-De-Sac location

This was sent in by Burbed reader Real Estater.

Like a true Silicon Valley entrepreneur, the next owner of this house will have no problems easily pulling in over $100k per year running a day care. Just thing, you can have your cake, eat it too, and then write it off! It’s a Win-Win-Win if you ask me!

At night, I dream not of sugar plum fairies, but opportunities to monetize my residence. Talk about House 3.0!

Better buy this house and get an MBA, because you’ll need another degree to manage this incredible moneymaker.


Comments (21) -- Posted by: burbed @ 5:26 am

June 26, 2008

“REAR UNIT NOT INCLUDED in sqft” – Campbell

207 N Central Ave, Campbell 95008

* Status: Active
* Bedroom: 3
* Bathroom: 2
* Year Built: 1900
* Lot Size: 7880
* Square Footage: 1185
* List Date: 3/26/2008
* Garage Spaces: 2
* MLS#: 786918

Unique! Majestic Beauty! Only one of its kind! Restored & upgraded charm historic Greek Revival home w/huge lot in downtown historic social circle walking distances 2 farmer’s market. REAR UNIT NOT INCLUDED in sqft, NEW cement foundation w/6?H basement/electrical/plumbing/gas line/heating/interior/granite counter/tankless waterheater.All New construction permits w/current building code, MUST SEE!!

This caught my attention in a few ways:

1) It has the lucky price. This means that the house is lucky, and when you buy it, you will be lucky too.

2) It has a basement. That’s pretty unusual, and actually kind of cool IMHO.

3) Something about a rear unit. Let’s take a look at some more photos:

Hm. No. I think that’s the back of the house. (Nice entrance to the basement though!)

Let’s look at another photo:

Wow… really that’s not what I expected. For some reason, I have this urge to say “Rapunzel, Rapunzel, let down your hair!”

Perhaps why this house is majestic – it’s like a fairy tale. Wouldn’t you tell your kids about this?

I can see the Craigslist ad already: “Room for rent in Campbell above garage. Very safe – you can be sure you won’t be burglarized. BYOCMD (Bring your own carbon monoxide detector).”

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

May 15, 2008

Who lives here in Campbell? (When stagers attack!)

630 W Sunnyoaks Ave, Campbell 95008(Campbell)

Status: Active
Bedroom: 3
Bathroom: 2&1/2
Year Built: 2005
Lot Size: 3484
Square Footage: 1630
List Date: 1/20/2008
Garage Spaces: 2

Description of 630 W Sunnyoaks Ave, CampbellNEW PRICE,3 YEARS OLD AND TOP CONDITION, hardwood floor main level, large covered side yard, granite counters,gas range, stainless frig & appliances.Designer carpet, easy rise staircase to stunning upstairs with 3 large bedrooms + laundry room. Skylight, upgraded plumbing,2 car attached garage. Best location for Los Gatos/Campbell shops and restaurants. Convenient to Hwy 85/17

Top condition indeed. Let’s take a look at some photos, and see why long time Burbed reader Brendan
sent this in:

OMG. Who lives in this house? Is it the Pope? (No, he lives in Willow Glen remember?)

Why, of course, Sherlock Holmes lives here! Just think, you come home from a long day of work at eBay as one of their fraud detectives, you take off your hat, put on your robe and puff away at your pipe. You admire the Greek and Roman antiquities you acquired – appreciating how they were all made in places like Shenzen. You sip on your glass of aged port and wonder… what is Moriarty294’s next move? Will he pose as a Nigerian buyer? A high ranking Nigerian military official? Will he collude with others to rig a sale? So many questions – and luckily you have strong deductive reasoning skills. After all, you deduced that this house would be a great buy!

You’ll then think about stagers, and what happens when you give them a bucket of money and say “Make my place look fantastic.”

Frankly, if these photos don’t sell you on buying this house? I don’t know what will.

UPDATE: Fixed a typo. Also, a Burbed reader reports that this actually isn’t staging – that this is how the place actually looks as per the seller. WHOA.

Comments (28) -- Posted by: burbed @ 5:14 am