5648 CEDAR CREST Ter, DUBLIN, CA 94568 | MLS# 40431698
5648 CEDAR CREST Ter DUBLIN, CA 94568
Price: $710,000

Beds: 5
Baths: 3
Sq. Ft.: 2,659
$/Sq. Ft.: $267
Lot Size: 4,041 Sq. Ft.
Property Type: Single Family Detached
Style: Custom
Stories: 2
View: Greenbelt
Neighborhood: DUBLIN
Year Built: 2000
Community: DUBLIN
County: Alameda
MLS#: 40431698
Source: EBRD
Status: Active
On Redfin: 12 days
Beautiful home in the Dublin Ranch development, on a cul-de-sac in a child friendly neighborhood 3 blocks from new elementary school. Home backs up to protected green space – privacy and fabulous sunsets.

Thanks to Burbed reader Alex for this find.

Although Burbed doesn’t regularly venture to Dublin, this is a nice relaxing find for a Friday.

Who knew that a house could have multiple sunsets per day! Apparently this house lives in the special Tatooine district on Dublin, and thus you can enjoy sunsets multiple times a day.

For those who value their privacy, this picture is reassuring – your house will blend into the sunset. No one can find you. Your children will be very safe.

So if you don’t mind the short drive to Dublin, this house may be right for you. Just be sure not to stare into the sunsets!

FREMONT, CA 94536 | MLS# 40425478
SYCAMORE St FREMONT, CA 94536
Price: $250,000

Beds: 3
Baths: 1
Sq. Ft.: -
Lot Size: 5,000 Sq. Ft.
Property Type: Single Family Detached
Style: Bungalow
Stories: 1
Neighborhood: NILES
Year Built: 1930
Community: NILES
County: Alameda
MLS#: 40425478
Source: EBRD
Status: Active
On Redfin: 14 days
Contractor Special in Old Niles. Bring your skills and reap the benefits!

Thanks to Burbed reader CB for this find.

Wow. Now you too can live like a pharaoh in Fremont! Frankly, I never knew that there was a community known as Niles there – learn something new every day.

I think most Real Bay Area people can really bring their skills and reap the benefits. Let’s see… bring on some Ruby on Rails, some Objective C, some .NET, some Beans, some SQL – PRESTO! You’ve got a $500k house!

But wait, there’s more! It really is near a river!

Wow… once you hire a team of archaeologists and interior decorators, you’ll be soon living near the banks of a mighty river, and with easy access to Mission Boulevard to boot!

Fit for a king. Fit for you!

1407 23rd Ave, Oakland, CA 94606 – Zillow

For Sale: $780,000

* 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:

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:

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!

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

$480,000

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!

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:

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

35983 CARNATION Way, FREMONT, CA 94536 | MLS# 40379294
35983 CARNATION Way FREMONT, CA 94536
Price: $689,950

Beds: 3
Baths: 2.5
Sq. Ft.: 1,353
$/Sq. Ft.: $510
Lot Size: 9,020 Sq. Ft.
Property Type: Single Family Detached
Style: Ranch
Year Built: 1955
Stories: 1
View: Hills
Neighborhood: Not Listed
Area: Fremont
County: Alameda
MLS#: 40379294
Source: EBRD
Status: Active
On Redfin: 153 days
Unsold in 90 days
Niles home w/ 9-car garage! Completely remodeled, granite, hardwood, tile, recessed lighting, french doors, maple cabinets, AC & many more amenities. Garage: Approx 24×60 and 18×12 Roll-up. 14’7″ Ceiling height 16′ side Roll up w/ access to patio. Air compressor with built in air lines

Thanks to Burbed reader CB for this find.

Wow. Check out that garage. CB thought that this would be great if you worked for NASA and occasionally brought the space shuttle home with you. Personally, I think it’s a bit more modest – this is for all you firefighters who bring the crane home with you sometimes.

What I don’t quite get is the 9-car garage aspect. Is this targetted towards Jay Leno and Jerry Seinfeld?

Let’s take a closer look:

Oh, it’s obvious! It’s for those big rig drivers who want to park at home. Right next to their pinball machine, and their antique phone!

They say in marketing that you should always find a niche.

Consider this niche found!

820 53RD Ave, OAKLAND, CA 94601 | MLS# 40395593
820 53RD Ave OAKLAND, CA 94601
Price: $105,000

Beds: 4
Baths: 2
Sq. Ft.: 603
$/Sq. Ft.: $174
Lot Size: 2,500 Sq. Ft.
Property Type: Single Family Detached
Style: Contemporary
Year Built: 1916
Stories: 2
Neighborhood: OAKLAND
Area: Oakland Zip 94601
County: Alameda
MLS#: 40395593
Source: EBRD
Status: Active
On Redfin: 48 days
Cute Home Must See! There are two additional living space that each have two bedrooms, one bathroom and a small kitchen. There is a Total of 6 bedrooms, 3 bathrooms and 3 kitchens with three seperate entrances. This home is great for a growing family.

Thanks to Burbed reader sonarrat for this find!

Wow… 6 bedrooms, 3 bathrooms, and 3 kitchens. All in 603 square feet? And just for $105,000?

Forget the fact that affordable housing is now clearly available in Oakland – let’s look at the fact that Oakland now has violated time/space!

The catch is that they didn’t list what dimension those entrances are… or what time they are in.

Any Lost fanatics or Star Trek fanatics that want to step up to explain this? Do we need the power of Q?

37521 Church Ave, Fremont, CA 94536 Irvington MLS# 40385985 – Property Details
37521 Church Ave, Fremont, CA
94536
(Irvington)

* Status: Active
* Bedroom: 2
* Bathroom: 1
* Year Built: 1912
* Lot Size: 5750
* Square Footage: 480
* List Date: 12/17/2008
* Garage Spaces: 0
* MLS#: 40385985

One of the lowest priced single family homes in Fremont. Huge lot with tons of potential. Lot goes from one street to the next, drive in from Joseph St. or Church Ave. Dual pane windows. Nice neighborhood.

Here’s what Burbed reader sonarrat had to say:

Look at the map.. isn’t Joseph two blocks from Church? Very strange.

Hey, this is Fremont – things don’t have to make sense. It’s not real Bay Area after all.

Or actually, is it? At $604 per square foot, this house is conveniently located near the Amtrak station, offering ease of access to trains.

Suddenly, I’m not so sure. Hey Fremont, if you keep this up, you might just be in the Real Bay Area soon. And then maybe you can drive a few blocks to go from Mountain View to Fremont using your subspace technology!

36527 NICHOLS Ave, FREMONT, CA 94536 | MLS# 40383110
36527 NICHOLS Ave FREMONT, CA 94536
Price: $680,000

Beds: 4
Baths: 2.5
Sq. Ft.: 1,603
$/Sq. Ft.: $424
Lot Size: 6,040 Sq. Ft.
Property Type: Single Family Detached
Style: Contemporary
Year Built: 1984
Stories: 2

Desirable location in Fremont close to BART. Backyard w/ deck, quiet neighborhood, wide driveway, renovated Kitchen w/ Stainless Steell appliances. Must see to appreciate!THIS IS NOT A SHORT SALE OR REO. .. Original owner.

Burbed reader CB thought this was an important find. Here’s what CB had to say:

It’s listed at 140K above it’s zestimate and and you’ll have to pay about 100 more per sq ft for the 94536 to live in this one.   But who knows.  The house is fit for the Mona Lisa, it may be fit for someone as special as me!

The cat guarding the “original owner’s” valued Betty Boop collection is also a nice touch.  50x scale posters of drinks is always a plus. This listing makes a good argument for keeping the camera on the curb.

Indeed, the ZEstimate is just $524,500. But as we know, ZEstimates tend to undervalue Bay Area (even non-RBA) properties because they don’t have a model to account for specialness.

That said, let’s take a look at the interior!

Yep. That’s the Mona Lisa alright. And check out the Roman-esque bust! And the Christmas tree! Wow. What a cornucopia of Classic Art. Stunning!

And to complete the museum, lots of modern art.

Frankly, if they’re not charging admission to go see this house, they are truly missing out!

2615 Wallace St, Oakland, CA 94606 | MLS# 2935161
2615 Wallace St Oakland, CA 94606
Price: $37,500
Beds: 4
Baths: 2
Sq. Ft.: 1,520
$/Sq. Ft.: $25
Lot Size: 3,454 Sq. Ft.
Property Type: Multi-Family
Year Built: 1912
# of Rooms: 9
County: Alameda
Listing #: 2935161
Source: Bank-Listed Foreclosures
Status: Bank Owned
On Redfin: 82 days

Burbed doesn’t usually venture to Oakland, but Burbed reader Jeff thought this $37,500 house was important to share. Here’s what he had to say:

I know Oakland is somewhat offtopic for Burbed, however, this neighborhood is about as interesting as it gets.

First the house itself (theHouse.jpg) with the Christmas lights and three satellite dishes, its boarded up castle next door (neighbor.jpg), and finally an apartment that screams “Timber!!!” (furtherOver.jpg)

Let’s take a look shall we?

Wowsers!

But guess what? If you buy this, you’re looking at $383,000 in instant equity! Here’s what Zillow has to say:

ZESTIMATE®: $420,500   What’s this?
* Value Range: $302,760 – $449,935
* 30-day change: -$17,500
* Zestimate updated: 01/23/2009

Last sale and tax info

Sold 08/11/2008:
$338,960 *

That’s right! It has a Zestimate of $420,500. Can you say free money?

FARGO Ave (Unable to map) San Leandro, CA 94579
Price: $430,000

Beds:     5
Baths:     2
Sq. Ft.:     1,862
$/Sq. Ft.:     $231
Lot Size:     7,735 Sq. Ft.
Age (Years):    60
Year Built:    1948
Type:    Detached Single Family
Style:    Ranch
Stories:    1 Story
View(s):    Neighborhood
Neighborhood:    Alameda County
County:     Alameda
MLS#:     80813184

Fixer-upper
Needs your TLC. This is your chance to own a PRICED-TO-SELL-FAST home conveniently located near freeways, fire station, schools, restaurants & shops, but bring your toolbox because this house needs some work. This is great for big family having a big backyard, bonus bedroom and bathroom and in a quiet neighbohood. A once in a lifetime opportunity. Desperate owner needs action!

Burbed generally doesn’t venture much into the East Bay, after all it is fly over land. That said, Burbed reader James sent this great find in.

Usually Realtors, professionals at the craft of prose and poetry write in such amazing language that it takes scholars years to decrypt the hidden meaning.

This Realtor is clearly aiming at the common man. He’s helping make housing accessible to everyone. “Located near freeways, fire station” – the honest is refreshing. “Desperate owner needs action!” – wow, now the realtor is headed in the risque direction. Very bold. Very very bold.

Props to you for this literary work. People will be discussing this for years. Thanks James for this find!