Wayne's Coating--1025 San Antonio, Alameda, CA
This property threatened to come on the market back in March via semi-cryptic craigslist posts. It's finally made it onto craigslist again, with few details. The address isn't given, but my sources tell me it is located at 1025 San Antonio. The listing is still a little coy (see bold passages below; my emphasis):
There's no sale history on Zillow, so one assumes the house has been in the same family for a long time and might even be owned outright. You can't beat the location, and (assuming I have the right house) the following specs make it competitive, at $339 / sqft:

Update 9/23/08: Finally listed on the MLS(r) as #40371147, for $825,000, which interestingly is exactly one agent's commission above the previous "no agents need apply" listing. I guess selling a ~$800K house to someone with the requirement they not be represented isn't as easy as it sounds.
Update 11/28/08: I thought it had sold, but the official Prudential page still has it as active after 66 days on the market.
Update 12/05/08: Sold for $809,000. Good luck to the neighbors.
Announcement: read about EBRD, Inc.'s DMCA content removal complaint against this blog
Aside from spelling his own last name two different ways, Nick is very cagey about this house and not telling you where exactly it is. I think it's the brown Craftsman next to the Greek revival compound extraordinaire (drool) below:$799000 "Gold Coast" Craftsman on the Island of Alameda! (alameda) (map)
Reply to: nick.falconio@prurealty.com [?]
Date: 2008-09-02, 9:53PM PDT
This is a rare opportunity to purchase a beautiful Craftman home in one of the most desirable areas in the East Bay - before it is offered to the general public! This home is on a beautiful tree-lined street and is comprised of four bedrooms, two baths, refinished hardwood floors, original paneling and wainscoating, tiled fireplace, built in buffet and may other original details. There is an attached one car garage w/bonus room above! Outside is a delightful rear garden area with potting shed and patio. If you're looking to own a home on Alameda's Gold Coast, don't miss this opportunity!
I am offering this home first to buyers who ARE NOT being represented by a real estate agent, and who are pre-approved by a lender. Please contact me directly for a private showing before I offer the home to the general public. I can be reached at (510)986-2008
Nick Flaconio,Realtor
Prudential California Realty
nick.falconio@prurealty.com
There's no sale history on Zillow, so one assumes the house has been in the same family for a long time and might even be owned outright. You can't beat the location, and (assuming I have the right house) the following specs make it competitive, at $339 / sqft:3 bedrooms, 2 bathrooms, 2,359 sqft, 6,250-sqft lotOther than perpetual house envy when you look at the 8-bedroom, 4,500-sqft Parthenon extravaganza next door, in this market this house seems like a reasonable deal in the best location in town, especially given its large lot. Of course, $799,000 for almost any house under 3,500 sqft is obscene--note that I said "in this market"...

Update 9/23/08: Finally listed on the MLS(r) as #40371147, for $825,000, which interestingly is exactly one agent's commission above the previous "no agents need apply" listing. I guess selling a ~$800K house to someone with the requirement they not be represented isn't as easy as it sounds.
Update 11/28/08: I thought it had sold, but the official Prudential page still has it as active after 66 days on the market.
Update 12/05/08: Sold for $809,000. Good luck to the neighbors.
Announcement: read about EBRD, Inc.'s DMCA content removal complaint against this blog
I visited this house and was sorely tempted by it - the common areas in the front of the house were just beautiful and classic craftsmen. The kitchen needed a complete overhaul, but was a very doable renovation. The real problem were the bedrooms & bathrooms... very small, lots of work needed. The floorplan for those wasn't really fixable without investing in a complete expansion of the house. The multiple staircases (one of which was just TOO steep for kids) were also an issue. I think it is one of those houses that has just one too many downsides. If just one of the bedrooms had been bigger, or if the house had one staircase instead of three, I would have jumped on it.