
$898,888
2,040
SQ FT
$441
SQ/FT
2165 Railroad Ave
@ SYCAMORE AVE - Promenade, Hercules
- 4 Bed
- 2.5 (2/1) Bath
- 2 Park
- 2,040 sqft
- Hercules
-
-
Sun Sep 28, 12:00 pm - 4:00 pm
Open House!
Introducing the Italianate Model in the coveted Promenade Waterfront community – a home where sophisticated design meets tranquil waterfront living. This 2,040 sq ft, 4-bedroom, 2.5-bath residence features a designer kitchen with stainless-steel appliances, quartz countertops, custom copper sink, breakfast nook with coffee bar, and upgraded cherry wood cabinetry which is carried throughout the entire home. Enjoy a spacious great room, a master bath with oversized jetted tub, high-efficiency dual-zone HVAC with ceiling fans, and owned solar. Outdoors, the drought-tolerant landscape pairs beautifully with serene water views, the community’s newly completed Bayfront trails, and excellent parks within a few minutes walk. With its remarkably low $15/month HOA, built-in security system, and walkable access to local favorites like Powder Keg, Leila by the Bay, and Hizcafe, this home offers the perfect blend of elegance, comfort, and lifestyle topped with undeniable CHARM!
- Current Status
- New
- Original Price
- $898,888
- List Price
- $898,888
- On Market Date
- Sep 23, 2025
- Property Type
- Detached
- D/N/S
- Promenade
- Zip Code
- 94547
- MLS ID
- 41112496
- APN
- 4044900084
- Year Built
- 2003
- 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: 1.1mi
Ohlone Elementary School
Public K-5 Elementary
Students: 450 Distance: 1.2mi
Collins Elementary School
Public K-6 Elementary
Students: 305 Distance: 1.2mi
Rodeo Hills Elementary School
Public K-5 Elementary
Students: 654 Distance: 1.2mi
St. Patrick School
Private PK-8 Elementary, Religious, Coed
Students: 387 Distance: 1.5mi
Voices College-Bound Language Academy At West Contra Costa County
Charter K-8
Students: 133 Distance: 1.7mi
- Bed
- 4
- Bath
- 2.5 (2/1)
- Parking
- 2
- Detached, Garage Door Opener
- SQ FT
- 2,040
- SQ FT Source
- Public Records
- Lot SQ FT
- 2,700.0
- Lot Acres
- 0.06 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, Counter - Solid Surface, Eat-in Kitchen, Disposal, Gas Range/Cooktop, Ice Maker Hookup, Oven Built-in, Range/Oven Built-in, Self-Cleaning Oven, Updated Kitchen
- Cooling
- Ceiling Fan(s), Central Air
- Disclosures
- Disclosure Package Avail
- Entry Level
- Flooring
- Hardwood, Laminate, Tile, Vinyl, Carpet
- Foundation
- Fire Place
- Living Room
- Heating
- Zoned
- Laundry
- 220 Volt Outlet, Dryer, Gas Dryer Hookup, Laundry Room, Washer
- Main Level
- 0.5 Bath, Laundry Facility, Main Entry
- Possession
- Close Of Escrow
- Architectural Style
- Contemporary
- Construction Status
- Existing
- Location
- Premium Lot, Zero Lot Line
- 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.