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 stylish room- 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 nature convenience, historical museum, farmers’ market, shopping centers, and a vibrant selection of restaurants. 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
$2,788,000 (USD)
Active

Stonebrae Country Club Area Single Family Home

Active

128 Dunfirth Ct Hayward, CA 94542

5 Bed
5 Baths
4678 sqft
MLS# 41129475
Virtual Tour
Exquisite home in prestigious Stonebrae Golf Club community, one of the most idyllic East Bay locations with spectacular views from San Francisco to South Bay. This luxury residence offers 5 bedrooms plus office, bonus room and 4.5 bathrooms, including a primary suite downstairs. The home boasts coffered ceilings, crown molding, and wainscoting. The formal dining room provides the ideal space for memorable dinners, while the open-concept kitchen and family room are ideal for gatherings. The gourmet kitchen is equipped with high-end appliances, a walk-in pantry, and a center island. A fully collapsible sliding door connects the kitchen to the outdoor California room with fireplace and STUNNING BAY VIEWS. Upstairs, the expansive master suite offers a private balcony that provides breathtaking vistas and features an expansive walk-in closet, dual vanities, oversized tub, and a sit-down vanity area. Additional highlights include hardwood flooring, upgraded sound system in the great room, and laundry room with cabinets and a sink. The private backyard offers a covered patio with built-in BBQ, stamped concrete walkway, a putting green & a bocce court. The guarded community has 24-hour security and optional country club memberships with access to a gym, golf, tennis courts and pool.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri