Featured Properties

Some or all of the listings below are provided by the Fremont office.
$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
$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
$2,488,000 (USD)
Pending

Quail Run Area Single Family Home

Pending

33646 Whimbrel Rd Fremont, CA 94555

4 Bed
3 Baths
2598 sqft
MLS# 41129714
Virtual Tour
Welcome to this beautiful Shapell home in the sought-after Quail Run Community! This prestigious neighborhood is known for its peaceful setting and resort-style amenities - a swimming pool, tennis courts, clubhouse, and playground. Located within top-rated school districts—American High School, Thornton Middle, Warwick Elementary. It offers 4 beds and 3 baths, including a convenient downstairs bedroom and full bath. With 2598 sq ft of living space, 8250 sq ft lot, sits on a quiet street. The thoughtfully designed floor plan features formal living and dining rooms at the front. Toward the back, the modern kitchen, breakfast nook, and family room flow seamlessly together, providing an ideal space for everyday living and entertaining, with access to the backyard. Upstairs, the spacious primary suite offers a retreat area with a cozy fireplace, soaring ceilings, and a private balcony. The luxurious primary bathroom includes dual vanities, dual closets, and a separate shower. Step outside to a generous backyard complete with a patio deck—perfect for entertaining, gardening, and enjoying fruit-bearing trees. Conveniently located near dining, shopping, local parks, BART, major freeways, and corporate shuttles, this home truly offers comfort, convenience, and an exceptional lifestyle.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song
$2,468,000 (USD)
Active

Mission Lakes Area Single Family Home

Active

35621 Beeching Ln Fremont, CA 94536

5 Bed
3 Baths
2675 sqft
MLS# 41132559
Virtual Tour
Presenting this beautifully appointed two-story home with lovely views of the hills in the sought-after Mission Lake community. This stunning residence offers 4 bedrooms, 1 bonus room/5th bedroom and 3 full bathrooms. A full bedroom and bathroom are conveniently located on the main level. The spacious open floor plan features a light-filled formal living room with vaulted ceilings. The generous family room with fireplace opens seamlessly to the remodeled kitchen and dining area, creating an ideal space for everyday living and entertaining. The custom remodeled kitchen offers granite countertops with full backsplash, abundant cabinetry, a center island, and top-of-the-line stainless steel appliances. The upper-level features 3 more large bedrooms, a bonus room with closet that can serve as a 5th bedroom, and 2 full bathrooms. Upstairs, the elegant primary suite with vaulted ceiling and walk-in closet includes a beautifully updated en-suite bathroom with dual-sink vanity, large soaking tub and a separate shower with clear glass enclosure. All bathrooms are beautifully updated. Additional highlights include refinished Brazilian Cherry hardwood flooring downstairs and upstairs hallway, quality carpeting in the bedrooms, new interior paint, updated windows with plantation shutters, beautiful double entry door with glass inserts, new LED lighting, tankless water heater, central vacuum system, and laundry room. Enjoy professionally landscaped front and backyards with paver decking, built-in BBQ, fire pit, and shade. Top-ranked schools include Brookvale Elementary School and American High School. Close to restaurants, shopping, Alameda Creek Trail, Quarry Lakes, BART, and easy access to 880 and 84. No HOA dues.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri