Featured Properties

Some or all of the listings below are provided by the Fremont office.
$1,398,000 (USD)
Active

Alvarado Dist Area Single Family Home

Active

3312 San Marco Ct Union City, CA 94587

3 Bed
2 Baths
1349 sqft
MLS# 41117797
Virtual Tour
No Steps to Entry: EZ access to BART, I-880, & 84/the Dumbarton Bridge*Conveniently located close proximity to parks, sports facilities, the ecological reserve along the eastern shore of San Francisco Bay, historical museum, farmers’ market, shopping centers, & a vibrant selection of restaurants*Inside, the home features a spacious living room with a fireplace and an inviting modern great room combining living and dining areas, overlooking a park-like backyard*Newly renovated kitchen showcases quartz countertops and backsplash, brand-new high-end stainless steel appliances, and ample storage space-perfect for both everyday living and entertaining*Entire home is enhanced with easy-to-maintain wood flooring & updated bathrooms, offering comfort*Outdoors, expansive private yard offers a peaceful sanctuary-perfect for gatherings under the open sky, alfresco dining, morning coffee or quiet moments surrounded by natureconvenience with easy access to BART, I-880, and 84/the Dumbarton Bridge. Enjoy no steps to entry and close proximity to parks, sports facilities, the ecological reserve along the eastern shore of San Francisco Bay, historical museum, farmers’ market, shopping centers, and a vibrant selection of restaurants. Inside, the home features a spacious living room with a fireplace and an inviting modern great room combining living and dining areas, overlooking a park-like backyard. The newly renovated kitchen showcases quartz countertops and backsplash, brand-new high-end stainless steel appliances, and ample storage space—perfect for both everyday living and entertaining. The entire home is enhanced with easy-to-maintain wood flooring and updated bathrooms, offering comfort and style throughout. Step outside to your private, expansive yard, a tranquil retreat ideal for entertaining, outdoor dining, quiet meditation, or simply enjoying nature. A rare opportunity to own a move-in-ready home in a prime Union City location
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Charo Bhatt
$3,999,999 (USD)
Pending

Mission Area Single Family Home

Pending

41473 Pelham Ct Fremont, CA 94539

5 Bed
4 Baths
3876 sqft
MLS# 41130705
Virtual Tour
Experience unparalleled privacy and modern luxury in this one-of-a-kind, 3,876 sq. ft. custom residence. Situated on a massive 15,985 sq. ft. premium court lot, this NE-facing home has been meticulously transformed with over $130,000 in recent designer upgrades. The seamless, no-step interior features a light-filled open layout with soaring picture windows offering a large formal front living room with picture windows and a signature floor-to-ceiling Carmel stone fireplace, a formal dining room, and a generous family room. The heart of the home is the chef’s kitchen, boasting newly installed quartz countertops, a full backsplash, a wine cooler, and high-end stainless appliances. Key Highlights: • Modern Interiors: Newly installed luxury flooring, fresh interior/exterior paint, and matte black hardware throughout. • Spa-Like Baths: All 3.5 bathrooms are newly updated with designer vanities, mirrors, and LED lighting. • Outdoor Oasis: A private retreat featuring a custom pool with red brick coping, aggregate decking, and professionally landscaped grounds. • Rare Perks: Oversized garage with new epoxy floors, a gated long driveway (parking for 8+ vehicles), and significant space for a potential ADU. • Location: Ideally located within the Golden Triangle, just one mile from top-rated Mission San Jose schools.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri