Featured Properties

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

Stonebrae Country Club Area Single Family Home

Active

65 Stonebrae Rd Hayward, CA 94542

4 Bed
5 Baths
3420 sqft
MLS# 41143404
Virtual Tour
Exquisite and seldom available single-story residence in the prestigious Stonebrae Golf Club community, one of the East Bay's most desirable neighborhoods, offering spectacular panoramic views stretching from San Francisco to the South Bay. This exceptional home showcases extensive high-end upgrades and features 4 bedrooms, 4.5 bathrooms, two luxurious primary suites, and a spacious 3-car garage. The private secondary suite, complete with its own bedroom and separate living area, is ideal for extended family, guests, or multigenerational living. The bright, open floor plan with soaring ceilings welcomes you with an elegant foyer, a formal dining room, and an impressive great room with a fireplace. The gourmet kitchen features premium Viking appliances, a walk-in pantry, an oversized island with breakfast bar, designer lighting, custom cabinetry, granite countertops, a wine cooler, and a generous breakfast area with a fully retractable glass wall opening to the covered California room. Complete with a charming fireplace, this inviting outdoor living space seamlessly extends the home's entertaining areas. The awe-inspiring backyard is thoughtfully designed for year-round enjoyment, offering multiple seating areas, custom granite slab tile, a spa, architectural lighting, water features, and a charming arbor. An exceptional outdoor kitchen elevates the experience with two 40-inch barbecues (one natural gas and one charcoal), a 2-burner stove top, sink, two refrigerators, and two built-in ice bins, creating the perfect setting for memorable gatherings. Additional highlights include hardwood flooring, sound system inside and outside, recessed LED lighting, tankless water heater, a well-appointed laundry room with built-in cabinetry and a utility sink, and a 3-car garage wired for EV. The house is also wired for solar. Residents enjoy the peace of mind of a gated community with 24-hour guarded security, along with optional country club memberships that provide access to championship golf, tennis courts, a fitness center, and a resort-style pool. Ideally located with convenient access to Highways 92, 880, and 580, the home is approximately 30 minutes from all three major Bay Area airports.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$1,799,998 (USD)
Active

Sunnyvale Area Townhome

Active

332 Harcot Ter Sunnyvale, CA 94085

4 Bed
4 Baths
1916 sqft
MLS# 41143387
Located in the heart of Silicon Valley within walking distance to major employers, Caltrain, and Downtown Sunnyvale, this luxury three-story home is a former Toll Brothers model home featuring designer finishes throughout. The ground floor offers a private suite with a spacious bedroom and en-suite bathroom showcasing a quartz countertop and stall shower — perfect for multi-generational living, or as a dedicated home office for those who work remotely.The second level showcases a light-filled, open-concept floor plan with expansive windows on three walls, recessed lighting, and abundant natural light throughout. The inviting living room opens to a private balcony — a great space to entertain family and friends. The gourmet kitchen features a large island, quartz countertops, stainless steel appliances, ample cabinetry, and a separate pantry. A convenient half bathroom is tucked at the stair landing. The third floor is home to the primary suite, offering a spacious bedroom with large windows and an en-suite bathroom with double-vanity quartz countertops, a stall shower, and a walk-in closet. Two additional bedrooms are ideal for family or guests, complemented by a hallway bathroom with a quartz countertop and a shower-over-tub. Laundry with washer and dryer is conveniently located on the same level. Notable upgrades include custom Lutron motorized blinds and drapery — turning daylight into a dynamic design element throughout the home — a SkyBell video doorbell for anytime front-door access with an alarm system, an EV charger, and an attached two-car garage to name a few. Close to Downtown Sunnyvale, parks, restaurants, grocery stores, and shopping, with easy access to Caltrain, Highways 101 and 237, and a short commute to major tech companies. Don't miss this rare opportunity!
Listing Courtesy of bridgeMLS / Listed By: Moni Shah, Coldwell Banker Realty
$1,548,000 (USD)
Pending

Brookvale Area Single Family Home

Pending

35597 Galen Pl Fremont, CA 94536

3 Bed
2 Baths
1523 sqft
MLS# 41142549
Virtual Tour
Nestled on a peaceful street in Fremont's highly desirable Brookvale neighborhood, this beautifully updated North-East facing home offers 3 bedrooms, 2 full bathrooms, and a thoughtfully designed floor plan ideal for comfortable everyday living. The inviting layout features a formal living room and a separate family room with fireplace and sliding glass doors that open to the backyard patio, creating a seamless indoor-outdoor living experience. The updated kitchen is designed for both style and functionality, showcasing custom wood cabinetry, quartz countertops, quality appliances, a breakfast bar, and a casual dining area. Throughout the home, you'll appreciate numerous upgrades, including fresh interior and exterior paint, luxury laminate flooring, Milgard dual-pane windows with plantation shutters, LED recessed lighting, two sun tunnels, updated heating and air conditioning, updated electrical, beautifully remodeled bathrooms, updated copper plumbing, and a convenient indoor laundry room. The professionally landscaped front and back yards feature lush lawns, mature landscaping, and a covered patio, providing the perfect setting for relaxing or entertaining family and friends. Ideally located just minutes from Quarry Lakes Regional Recreation Area, you'll enjoy miles of scenic trails, picnic areas, fishing, and a sandy beach. This exceptional home is also within blocks of highly rated Brookvale Elementary and American High School, neighborhood parks, shopping, and everyday conveniences. Commuters will appreciate easy access to Highways 880 and 84, BART, Silicon Valley, and major employers throughout the Bay Area.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty