
Fremont, California 94538
This Stunning Farmhouse-Style Rebuild is listed at $2,699,888, representing a premium turnkey asset closely aligned with its $2,639,476 Fair Market Value. Completely reconstructed from the studs, the residence earns a Like-New Condition Rating and features high-end Marvin windows, a Designer Kitchen, and a Spacious Patio. The addition of a private 664-square-foot ADU offers exceptional versatility for rental income or extended family. Located in the desirable Irvington area near top-rated schools, this home provides modern efficiency and luxury. It is the perfect sanctuary for Multi-generational Families or Owner-Occupants.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 4759 Valpey Park Ave Subject | $2,699,888* List Price | 4 | 4 | 2,369 | $1,114 | - |
A 42795 Deauville Park Ct Sold | $2,150,000 | 5 | 3 | 1,916 | $1,122 | 0.1 mi |
B 41882 Gifford St Sold | $2,300,000 | 4 | 3 | 2,272 | $1,012 | 0.5 mi |
C 4423 4423 Bush Cir. Sold | $1,998,000 | 3 | 3 | 1,717 | $1,164 | 0.5 mi |
D 4309 Bora Bora Ave Active | $2,999,998 List Price | 5 | 4 | 2,372 | $1,265 | 0.4 mi |
* Subject property listed price vs sold prices of comps.
Property is new construction or fully renovated.
This property has been completely rebuilt from the studs and includes a brand-new ADU addition. All major systems—including HVAC, plumbing, electrical, and roofing—are new, and the interior features high-end finishes such as Marvin windows, engineered wood flooring, and a designer kitchen and bathrooms with premium fixtures and LED lighting, meeting the criteria for a like-new, turnkey home.
Rebuilt from the studs with all-new major systems including HVAC, plumbing, electrical, and roofing, offering the reliability and energy efficiency of new construction in an established neighborhood.
The property features a private, 664-square-foot ADU with its own entrance and utility meter, providing exceptional versatility for rental income, a home office, or multi-generational living.
The home showcases high-end finishes throughout, including Marvin windows, solid-core wood doors, engineered flooring, and designer kitchen and bath fixtures that elevate the property's aesthetic and value.
Living area discrepancy between mls listing and other public or private record. mls listing living area = 2369, other record living area = 1455. Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 4, other record bedroom count = 3.
Listed at nearly $2.7M, the property sits at a significant price point for the area, which may limit the pool of potential buyers and require a strong appraisal to support the valuation.
The addition of the ADU on a 7,426-square-foot lot significantly reduces the available private outdoor space, which may be a drawback for buyers prioritizing a large traditional backyard.
Stunning single-story Farmhouse-Style Home Completely Rebuilt from the studs out AND NEW ADU Addition. Thoughtfully Re-Imagined for Modern Living. This 3-bedroom, 3-bath Main Residence offers High-Quality Craftsmanship with NEW Plumbing, Electrical, HVAC, Roofing, and Whole-House Insulation. The interior showcases smooth 5/8” drywall, Engineered Wood Flooring, Solid-Core Wood Doors throughout, and High Quality Marvin Windows. The Designer Kitchen and Baths are Complemented by LED Lighting, Backlit and Dimmable Bathroom Mirrors, and a Luxurious 6-foot Kohler Tub in the hallway bath. Comfort and Efficiency are Prioritized with a Tankless water heater and Recirculating pump for the main home. An attached yet Private Top of the Line Quality 664-square-foot ADU adds Exceptional Flexibility and Value. Featuring its own separate entrance, Electrical Meter, Tankless Water Heater, this one-bedroom, one-bath unit is ideal for rental income, extended family, or a private home office. All-new landscaping that Enhances Curb Appeal and completes this turnkey property. With every major system newly replaced and premium finishes throughout, this home offers peace of mind, versatility, and timeless farmhouse style—all in one exceptional package.
No exterior & parking available.
No sensitive facilities data found.
| Feature | Subject | Average Home | Neighborhood Ranking (50 Listings) |
|---|---|---|---|
| Beds | 4.0 | 3.0 | 65% |
| Baths | 4.0 | 2.0 | 98% |
| Square foot | 2,369 | 1,324 | 95% |
| Lot Size | 7,426 | 6,000 | 91% |
| Price | $2.70M | $1.42M | 98% |
| Price per sq ft | $1.1K | $1.1K | 69% |
| Built year | 1964 | 1962 | 76% |
| HOA | $0 | $0 | 50% |
| Days on market | 28 | 106 | 2% |
Mar 25, 2026
$2,699,888
Initial Listing
Mar 17, 2025
$1,575,000
Public Record
Nov 28, 2000
$396,500
Public Record