
Fremont, California 94538
This Dual-Residence Property represents a High-Potential Investment Opportunity, listed at $1,588,000—positioned slightly above the $1,547,388 Fair Market Value. Featuring a Mint Condition Rating with a brand-new 2024 ADU and an updated main residence, this asset offers immediate rental income potential or flexible multigenerational living. Located in the desirable Irvington neighborhood near Top-Rated Schools like Irvington High, the property provides a rare combination of modern finishes and strategic location. This is an ideal acquisition for Buy-and-Hold Investors or Owner-Occupants seeking a turnkey, income-generating lifestyle.
Comparables within 1 miles sold in recently
| Address | Sold Price | Beds | Baths | Sq Ft | $/Sqft | Distance |
|---|---|---|---|---|---|---|
★ 3876 Almond Avenue Subject 4 bd · 2 ba · 1,503 sqft · $978 | $1,399,000* List Price | 4 | 2 | 1,503 | $978 | - |
A 4117 Hawkins St Sold 3 bd · 2 ba · 1,339 sqft · $952 · 0.6 mi | $1,275,000 | 3 | 2 | 1,339 | $952 | 0.6 mi |
B 3764 Howe Ct Sold 4 bd · 2 ba · 1,616 sqft · $1,046 · 0.7 mi | $1,690,000 | 4 | 2 | 1,616 | $1,046 | 0.7 mi |
C 42655 Charleston Way Sold 3 bd · 2 ba · 1,151 sqft · $1,077 · 0.9 mi | $1,240,000 | 3 | 2 | 1,151 | $1,077 | 0.9 mi |
D 4475 Millard Ave Sold 3 bd · 2 ba · 1,207 sqft · $994 · 0.8 mi | $1,200,000 | 3 | 2 | 1,207 | $994 | 0.8 mi |
E 4731 Hedgewick Avenue Active 4 bd · 2 ba · 1,556 sqft · $964 · 1.0 mi | $1,499,888 List Price | 4 | 2 | 1,556 | $964 | 1.0 mi |
* Subject property listed price vs sold prices of comps.
Property is new construction or fully renovated.
The property features a brand new detached ADU built in 2024 and a completely updated main residence. Both units showcase mint condition finishes, including modern kitchens with quartz countertops, stainless steel appliances, updated flooring, recessed lighting, and new HVAC/mini-split systems, requiring no immediate maintenance.
The property features two distinct residences, including a brand-new 800 sq ft ADU, providing a rare opportunity for rental income or flexible multigenerational living.
The 2024-built detached ADU offers high-end appeal with soaring 14.5-foot ceilings, exceptional natural light, and energy-efficient mini-split systems.
Situated in a highly desirable neighborhood, the home offers proximity to top-rated schools like Irvington High and convenient access to BART and major Silicon Valley commuter routes.
Bedroom count discrepancy between mls listing and other public or private record. mls listing bedroom count = 4, other record bedroom count = 2.
The original 703 sq ft main home is relatively small for a two-bedroom configuration, which may feel restrictive for families accustomed to larger living areas.
With a list price of $1.588M for 1,503 total square feet, the property carries a premium valuation that may be challenging for buyers comparing it to larger single-family residences.
Price Improvement! Rare opportunity in Fremont's Irvington neighborhood featuring two separate residences with approx. 1,503 sq ft of combined living space: a 703 sq ft main residence plus a detached fully permitted 800 sq ft ADU built in 2024. Ideal for multigenerational living, extended family, guests or potential rental income. The 2 bed/1 bath main home features updated flooring, custom cabinetry/storage and an updated kitchen with quartz countertops and stainless steel appliances. Additional features include A/C, washer/dryer and attached garage with LVP flooring. The modern 2 bed/1 bath detached ADU showcases soaring 14.5-ft ceilings and abundant UV-protected windows creating exceptional natural light, spacious kitchen, with stainless steel appliances, W+D, plus a heat-pump mini-split system and large attic storage area. A bonus is a spacious 135 sq ft storage structure with electricity. Around $500k in upgrades(ADU, improvements). Thoughtfully designed to provide privacy and flexibility between the two residences while still offering a spacious backyard for outdoor enjoyment. A unique opportunity to live in one residence while generating potential income from the other. Conveniently located near Irvington restaurants, shopping, parks, BART, I-680 and I-880.
No exterior & parking available.
Grades K-6 • 0.5 mi
Grades K-6 • 0.7 mi
Grades K-6 • 1.1 mi
No sensitive facilities data found.
| Feature | Subject | Average Home |
|---|---|---|
| Beds | 4.0 | 3.5 |
| Baths | 2.0 | 2.2 |
| Square foot | 1,503 | 1,658.648 |
| Lot Size | 6,250 | 6,448.198 |
| Price | $1.40M | $1.66M |
| Price per sq ft | $931 | $1.0K |
| Built year | 1953 | 1968 |
| HOA | $0 | $155 |
| Days on market | 31 | 38 |
Oct 7, 2026
$1,399,000
$1,588,000
-12% Price Drop
Initial Listing
Sep 23, 2026
$1,588,000
Initial Listing
May 28, 2021
$1,035,000
Public Record
Feb 20, 2014
$139,000
Public Record
Apr 24, 2003
$331,000
Public Record
Jun 21, 2000
$260,000
Public Record