Listing Courtesy of: 
bridgeMLS / Coldwell Banker Realty / Nibedita Das
bridgeMLS / Coldwell Banker Realty / Nibedita Das 554 Freitas Rd Danville, CA 94526
Active (2 Days)
$1,999,999 (USD)
OPEN HOUSE TIMES
-
OPENSat, Nov 151:00 pm - 4:00 pm
-
OPENSun, Nov 161:00 pm - 4:00 pm
Description
READY TO RING IN THE HOLIDAYS AND THE NEW YEAR IN A BEAUTIFUL NEW HOME? This RARE SINGLE-STORY GEM in DANVILLE’S SYCAMORE AREA blends timeless design with modern comfort. Featuring 4BD, 3.5BA + DEN across 2,663 SQ FT on an expansive 18,258 SQ FT LEVEL LOT, this home offers effortless living and a serene setting tucked along a PRIVATE ROAD. Over $150K in upgrades - Elegant interiors showcase MARBLE TILE, ACACIA HARDWOOD FLOORS, TRAVERTINE & GRANITE FINISHES, and THOMASVILLE CABINETRY THROUGHOUT. The SKYLIGHT-FILLED LIVING AND DINING AREAS flow into a GOURMET KITCHEN with DACOR APPLIANCES and BOSCH DISHWASHER, perfect for entertaining. Enjoy TWO ELECTRIC FIREPLACES (MONTIGO & MENDOTA), a LARGE LAUNDRY/PANTRY, OFFICE/DEN, WHOLE-HOUSE FAN, BUILT-IN SPEAKERS, and RECESSED LIGHTING. OUTDOOR LIVING shines with a CUSTOM BBQ + TEPPANYAKI GRILL, FRUIT TREES, SOLAR-POWERED SHED, and SIDE ACCESS for RV or BOAT PARKING. The 3-CAR GARAGE includes BUILT-IN STORAGE, MyQ, and 220V EV OUTLET. Near TOP SCHOOLS, IRON HORSE TRAIL & DOWNTOWN shops, restaurants and events. Easy access to I-680 and TECH BUS STOP on Sycamore exit. NO HOA. WARM, STYLISH & MOVE-IN READY — 554 FREITAS RD WELCOMES YOU HOME.
MLS #:
41117246
41117246
Lot Size
0.42 acres
0.42 acres
Type
Single-Family Home
Single-Family Home
Year Built
1979
1979
Style
Ranch
Ranch
County
Contra Costa County
Contra Costa County
Community
Sycamore Homes
Sycamore Homes
Listed By
Nibedita "Nivi" Das, DRE #02070151 CA, Coldwell Banker Realty
Source
bridgeMLS
Last checked Nov 15 2025 at 10:02 AM GMT+0000
bridgeMLS
Last checked Nov 15 2025 at 10:02 AM GMT+0000
Bathroom Details
- Full Bathrooms: 3
- Partial Bathroom: 1
Interior Features
- Dishwasher
- Microwave
- Pantry
- Breakfast Bar
- Refrigerator
- Dryer
- Washer
- Laundry: Laundry Room
- Windows: Double Pane Windows
- Windows: Window Coverings
- Gas Water Heater
- Electric Range
- Storage
- Formal Dining Room
- Den
- Laundry: Washer/Dryer Stacked Incl
Kitchen
- Breakfast Bar
- Dishwasher
- Electric Range/Cooktop
- Microwave
- Pantry
- Refrigerator
- Disposal
- Kitchen Island
Subdivision
- Sycamore Homes
Lot Information
- Level
- Cul-De-Sac
- Private
- Rectangular Lot
- Sprinklers In Rear
Property Features
- Fireplace: Family Room
- Fireplace: Living Room
- Fireplace: 2
- Fireplace: Insert
Heating and Cooling
- Forced Air
- Ceiling Fan(s)
- Whole House Fan
- Central Air
Pool Information
- None
Flooring
- Hardwood
- Carpet
Exterior Features
- Roof: Metal
Utility Information
- Sewer: Public Sewer
Garage
- Garage
Parking
- Attached
- Garage Door Opener
- Parking Lot
- Rv Access/Parking
Stories
- 1
Living Area
- 2,663 sqft
Location
Estimated Monthly Mortgage Payment
*Based on Fixed Interest Rate withe a 30 year term, principal and interest only
Listing price
Down payment
%
Interest rate
%Mortgage calculator estimates are provided by Coldwell Banker Real Estate LLC and are intended for information use only. Your payments may be higher or lower and all loans are subject to credit approval.
Disclaimer: Bay East© 2025. CCAR ©2025. bridgeMLS ©2025. Information Deemed Reliable But Not Guaranteed. This information is being provided by the Bay East MLS, or CCAR MLS, or bridgeMLS. The listings presented here may or may not be listed by the Broker/Agent operating this website. This information is intended for the personal use of consumers and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data last updated at: 11/15/25 02:02
