Opening page…
Opening page…
Opening home details…
Exceptional 5-bedroom, 4.5-bath residence offering 3,642 sq. ft. of extensively redesigned luxury living at the Union City–Fremont–Newark crossroads, just moments from the Fremont city line. A dramatic Emperador marble foyer, soaring ceilings, floor-to-ceiling windows and statement lighting create an impressive sense of arrival. Expansive living and dining spaces flow into a beautifully appointed chef’s kitchen with oversized island and breakfast nook opening to the family room, creating an ideal setting for both everyday living and entertaining. The reimagined primary retreat features a spa-inspired bath with dramatic natural stone, glass-enclosed shower, freestanding soaking tub, custom fluted double vanity and designer fixtures. Throughout the home, extensive enhancements include new hardwood flooring, beautifully reimagined baths, custom vanities, statement lighting, marble, natural stone and thoughtfully curated designer finishes. A main-level bedroom and bath, expansive upstairs loft, 3-car garage and private outdoor entertaining space provide exceptional flexibility and scale. Beyond the home itself, the location is a standout—positioned at the gateway to Fremont and the Peninsula with exceptional access to Meta’s Fremont campus, Lucid’s Newark headquarters, Highway 84 and the Dumbarton Bridge, providing convenient connectivity to major Silicon Valley employment centers and the Peninsula. A rare combination of space, sophisticated design and exceptional connectivity in one of the Tri-City area’s most strategically positioned neighborhoods.
Listing agent: Nida Adil DRE #02025192 nidaadilrealtor@gmail.com, Listing office: Intero Real Estate Services
MLS data updated 11/1/2026, 4:01:15 PM PT
Source: CRMLS, MLS #: 41147344
Choose a destination and your usual departure time. Travel times vary by route and day.
Plan a route on Google MapsCheck the exact property address with the district. A city or ZIP code alone does not establish school eligibility.
LA County district lookupCheck access, facilities and current hours before visiting. Explore the area around the home, not just the city center.
Explore nearby parks on Google MapsOfficial district, city and transit resources checked September 22, 2026. External map results are provided by Google.
Read Belmont’s local buyer guidesEnter your own resale and cost assumptions. This tool does not estimate market value or confirm that an addition is permitted. Asking price: $2,899,999.
Complete every cost field, entering 0 where appropriate, to calculate a scenario.
Include permits, design, contingencies, taxes and transaction costs in your budgets. Validate the resale assumption with recent comparable sales. Results are hypothetical, before income taxes, and are not a profit forecast.
Belmont insights
Compare recorded home prices, same-type ZIP sales and mortgage rates.
Sep 9, 2026
Prices use the left axis; mortgage rates use the right. Hover, tap, or focus the chart and use the arrow keys. Red SOLD badges mark recorded sales.
This home · nearest recorded event
$2,899,999Original asking price · Sep 9, 2026ZIP 94587 · Sep 2026
No monthly averageAt least 3 eligible sales in this month are required.30-year fixed mortgage benchmark
No weekly rateNo published rate within 7 days of this date.No recorded sales in this range. Select All available for older records; missing records do not mean the home never sold.
ZIP averages use publicly displayable closed sales from our licensed MLS feed, matched to the same ZIP and exact property type. Months with fewer than 3 sales are omitted; the current month is incomplete. Lines connect available monthly observations across gaps and do not represent measured prices in missing months. These averages are not adjusted for size, condition, or location within the ZIP, and are not an appraisal. Feed coverage may not include every sale. All available shows the available home and ZIP history, with mortgage rates over the same dates.
Mortgage benchmark: Freddie Mac Primary Mortgage Market Survey®. © Freddie Mac. Weekly national 30-year fixed rates, not APRs or a loan quote. Actual terms vary. Methodology changed in November 2022. The chart does not establish that interest-rate changes caused a home’s price changes.
Lines connect recorded asking and sale prices. They are visual guides, not estimates of the home’s value between those dates.
No earlier records were returned by our current sources. This does not mean the home has never sold.
MLS records may be incomplete. Earlier asking prices are not sale prices.