$1,710,000
3,685
SQ FT
$464
SQ/FT
1018 PROMENADE ST
@ RAILROAD - Promenade, Hercules
- 6 Bed
- 5.5 (5/1) Bath
- 2 Park
- 3,685 sqft
- Hercules
-
**EXCEEDINGLY RARE, DRAMATIC, PRIME CORNER LOT BAYSIDE PROPERTY WITH LEGAL A.D.U. OFFERS UNEQUALLED VERSATILITY NOT TYPICALLY FOUND WITHIN THE IMMEDIATE S.F. BAY AREA - ESPECIALLY AT THIS PRICE POINT!** Just what the market demands today - a SPACIOUS 5-BEDROOM/4.5-BATH Grand residence offering 3,236 SQFT living space featuring FULL BED/BATH Private Junior Suite on 1st Floor….PLUS….a spacious detached, original-builder A.D.U. Apartment with Kitchen, Full Bath and dedicated Washer/Dryer hook-ups. Such unique and striking combination of features is IDEAL for MULTI-GENERATIONAL families, WORK-FROM-HOME/HYBRID work, or an excellent source of rental income! Thoughtfully re-constructed with a LONG LIST of EXPENSIVE CUSTOM UPGRADES (e.g not found in the neighboring houses) the home also offers SOLAR ELECTRICITY (Owned) hedging energy costs in your favor! ***Located approximately 24-MILES FROM DOWNTOWN SAN FRANCISCO*** the wonderful Promenade bayside community is one of SF Bay's best-kept secrets! Join us for a Soft-Launch Open House SUNDAY 10/26 FROM 2:00 - 5:00 PM…..A SPECIAL PROPERTY LIKE THIS IS TRULY A “MUST SEE” IN-PERSON TO FULLY GRASP AND APPRECIATE ALL THE ONE-OF-KIND FEATURES AND MARVELOUS SETTING/LOCATION. Act quickly - enjoy the 2025 Holidays in a new home!
- Current Status
- Active - Coming Soon
- Original Price
- $1,710,000
- List Price
- $1,710,000
- On Market Date
- Oct 24, 2025
- Property Type
- Detached
- D/N/S
- Promenade
- Zip Code
- 94547
- MLS ID
- 41115772
- APN
- 4044800458
- Year Built
- 2002
- Stories in Building
- 2
- Possession
- Close Of Escrow
- Data Source
- MAXEBRDI
- Origin MLS System
- CONTRA COSTA
St. Joseph Elementary School
Private K-8 Elementary, Religious, Coed
Students: 270 Distance: 0.9mi
Collins Elementary School
Public K-6 Elementary
Students: 305 Distance: 1.0mi
Ohlone Elementary School
Public K-5 Elementary
Students: 450 Distance: 1.2mi
Rodeo Hills Elementary School
Public K-5 Elementary
Students: 654 Distance: 1.4mi
Voices College-Bound Language Academy At West Contra Costa County
Charter K-8
Students: 133 Distance: 1.5mi
Pinole Middle School
Public 7-8 Middle
Students: 529 Distance: 1.5mi
- Bed
- 6
- Bath
- 5.5 (5/1)
- Parking
- 2
- Detached, Off Street, Parking Spaces, Alley Access, Garage Faces Side, Private, Garage Door Opener, Uncovered Park Spaces 2+
- SQ FT
- 3,685
- SQ FT Source
- Other
- Lot SQ FT
- 6,625.0
- Lot Acres
- 0.15 Acres
- Pool Info
- None
- Kitchen
- Dishwasher, Gas Range, Plumbed For Ice Maker, Microwave, Oven, Range, Refrigerator, Self Cleaning Oven, Trash Compactor, Dryer, Washer, Gas Water Heater, Breakfast Bar, Breakfast Nook, Counter - Solid Surface, Stone Counters, Eat-in Kitchen, Disposal, Gas Range/Cooktop, Ice Maker Hookup, Oven Built-in, Pantry, Range/Oven Built-in, Self-Cleaning Oven, Updated Kitchen, Other
- Cooling
- Ceiling Fan(s), Central Air, Multi Units
- Disclosures
- Architectural Apprl Req, Building Restrictions, Easements, Nat Hazard Disclosure, Other - Call/See Agent, Restaurant Nearby, Disclosure Package Avail
- Entry Level
- Exterior Details
- Lighting, Back Yard, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic, Sprinklers Front, Sprinklers Side, Terraced Back, Landscape Back, Landscape Front, Yard Space
- Flooring
- Hardwood, Laminate, Tile, Carpet, Other, Engineered Wood
- Foundation
- Fire Place
- Family Room
- Heating
- Zoned, Radiant, Fireplace(s)
- Laundry
- Dryer, Hookups Only, In Garage, Washer, Other
- Upper Level
- 4 Bedrooms, 3 Baths, Primary Bedrm Suite - 1, Laundry Facility
- Main Level
- 1 Bedroom, 0.5 Bath, 1 Bath, 1.5 Baths, Primary Bedrm Suites - 2, Other, Main Entry
- Possession
- Close Of Escrow
- Architectural Style
- Mediterranean, Other, See Remarks
- Non-Master Bathroom Includes
- Shower Over Tub, Solid Surface, Updated Baths, Granite
- Construction Status
- Existing
- Additional Miscellaneous Features
- Lighting, Back Yard, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic, Sprinklers Front, Sprinklers Side, Terraced Back, Landscape Back, Landscape Front, Yard Space
- Location
- 2 Houses / 1 Lot, Corner Lot, Premium Lot, Rectangular Lot, Back Yard, Front Yard, Sprinklers In Rear, Landscaped
- Roof
- Composition Shingles
- Water and Sewer
- Public
- Fee
- $15
MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.
School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

