Featured Properties

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

Talavera Area Single Family Home

Pending

4568 Martin St Union City, CA 94587

5 Bed
4 Baths
3854 sqft
MLS# 41145236
Welcome to the beautiful North West Facing 4568 Martin St, an exceptional home in the highly sought-after **Talavera by SummerHill** community. Known for quality construction, beautiful streetscapes, and thoughtfully designed residences, Talavera is one of Union City’s most desirable neighborhoods. This impressive and most favorable floor plan 3,854± sq. ft. home offers 5 bedrooms, 4 bathrooms (Full Bed and Bath Downstairs), open loft, and 3-car garage. Soaring ceilings and expansive living spaces create a dramatic sense of scale, complemented by high-end finishes and thoughtful details throughout. Fresh interior paint, including trim and ceilings, brings a light, bright, contemporary feel, while new upstairs carpeting adds a fresh, comfortable touch. The gourmet kitchen is the centerpiece of the home, featuring an oversized island, granite countertops, stainless-steel Thermador stainless steel appliances, walk-in pantry, and butler’s pantry. The spacious family room, formal living room, and dining room provide an ideal setting for both everyday living and grand entertaining. The generous primary suite offers a private retreat with a beautifully appointed bath and walk-in closets. Additional bedrooms, a versatile loft, and private office provide exceptional flexibility for family, guests, and working from home. A beautifully landscaped backyard creates a private outdoor retreat, while the 3-car garage and dual-zone air conditioning add everyday convenience. Enjoy easy access to shopping, dining, parks, trails, major commute routes, and the Dumbarton Bridge. **A rare opportunity to own a highly upgraded SummerHill home in coveted Talavera—fresh, bright, sophisticated, and ready to enjoy.**
Listing Courtesy of bridgeMLS / Listed By: Ryan D. Elson, Coldwell Banker Realty
$2,488,000 (USD)
Active

Weibel Area Single Family Home

Active

45399 Little Foot Pl Fremont, CA 94539

4 Bed
3 Baths
2140 sqft
MLS# 41149201
Virtual Tour
Introducing this rarely available NE-facing Weibel home in one of Fremont’s most sought-after neighborhoods. This property is situated in a serene and private court location with beautiful views of the Mission Hills. The desirable 4-bedroom, 2.5-bathroom home boasts extensive upgrades and a modern floor plan. The custom double-door entry with soaring ceilings opens to a very bright formal living room and a large formal dining room. You will love the gourmet kitchen featuring custom cabinetry, granite slab countertops and backsplash, a breakfast bar center island, and quality stainless-steel appliances. The generous family room with a beautifully updated gas fireplace opens to the professionally landscaped backyard. Relax in the spacious primary suite featuring a completely remodeled bathroom with new tile, dual-sink vanity, and a walk-in shower with dual shower heads and body sprays. The remodeled hall bathroom offers new tile, dual-sink vanity, and a deep cast-iron soaking tub. Additional highlights include engineered hardwood flooring throughout, beautiful custom front door, updated solid wood interior doors, plantation shutters downstairs, LED recessed lighting, updated crown molding, updated chandeliers in the entryway and dining room, commercial-grade updated central air conditioning and furnace, attic and underfloor insulation, indoor laundry room with new washer and dryer, solar panels, an EV charger and finished and insulated garage. The exterior has been extensively upgraded with an updated red tile roof with radiant barrier sheathing, remodeled stucco façade, exterior paint, custom colored front concrete driveway, flagstone front porch, custom stamped concrete backyard patio, beautiful backyard lawn, play area, and updated fence. The property also offers additional parking space including side RV/boat parking. Enjoy the beautifully landscaped grounds, privacy, and peaceful setting while remaining close to top-rated Weibel schools, parks, hiking trails, shopping, dining, BART, and major commuter routes including I-680 and I-880, providing convenient access to Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$2,398,000 (USD)
Pending

Stonebrae Country Club Area Single Family Home

Pending

65 Stonebrae Rd Hayward, CA 94542

4 Bed
5 Baths
3420 sqft
MLS# 41147035
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 features approx. $350,000 in extensive high-end upgrades and includes 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
$2,299,900 (USD)
Active

Mission Area Multi-Family Home

Active

43677 Ellsworth St Fremont, CA 94539

Bed
0 Baths
3746 sqft
MLS# 41146445
Virtual Tour
Rare opportunity to own a fourplex in Fremont’s highly sought-after Mission San Jose neighborhood, one of the Bay Area’s most desirable communities known for its top-rated schools, strong rental demand and exceptional long-term investment potential. Situated on a 7,500± SF lot, this approximately 3,746± SF multifamily property consists of four spacious 2-bedroom, 1.5-bath units with functional two-story floor plans. Each residence features a comfortable living area, kitchen, half bath, and convenient in-unit laundry on the main level, with two bedrooms and a full bath upstairs. Units 1 and 2 showcase tasteful updates including durable laminate flooring, remodeled kitchens with custom shaker-style cabinetry, subway tile backsplash, stainless steel appliances, updated bathrooms and fresh interior paint in Unit 1. The property also offers four covered carport parking spaces plus additional uncovered parking spaces, providing ample off-street parking for residents. Perfectly positioned near award-winning Mission San Jose schools, Ohlone College, Mission Peak Regional Preserve, shopping, dining and everyday conveniences, this location also provides easy access to BART, I-680, I-880, and major Silicon Valley employers. Whether you’re looking to expand your investment portfolio or secure a well-located multifamily asset in one of Fremont’s premier neighborhoods, this is an exceptional opportunity with lasting upside.
Listing Courtesy of bridgeMLS / Listed By: Lester Belliveau, Coldwell Banker Realty
$1,988,000 (USD)
Active

Brentwood Area Single Family Home

Active

6242 Montcalm Ave Newark, CA 94560

5 Bed
4 Baths
2344 sqft
MLS# 41144893
Virtual Tour
Looking for a property with a Main House + ADU + Jr. ADU? This remodeled and updated property offers three separate living spaces, making it ideal for multigenerational living, extended family, guests, or potential rental income. The main residence features 3 bedrooms and 2 bathrooms with updated kitchen and living areas. One bedroom and full bathroom are conveniently located on the main level, along with sliding door access to the backyard. The renovated kitchen features stone countertops, built-in microwave, gas stove, stainless steel appliances, ample cabinet space, and direct backyard access for easy indoor-outdoor living. The Jr. ADU features a kitchen/dinette, bedroom, full bathroom, French doors, private entrance, and interior access to the main house. Its flexible layout can function as a separate living space or be closed off from the main residence for added privacy. The ADU includes an updated kitchen, bedroom, living room, full bathroom with step-in shower and waterfall showerhead, private entrance, separate electric meter, and dedicated mini-split HVAC. The large backyard offers a serene retreat with mature cypress and palm trees, spacious patio, and ample room for entertaining, gardening, outdoor activities, or relaxing. A beautiful pool with cascading waterfall feature and safety fence serves as the centerpiece, while solar heating extends enjoyment year-round. A leased solar system provides power to the main residence and Jr. ADU. The newly built garage features finished walls and a durable epoxy floor. Additional features include central A/C or mini-split HVAC in all spaces, fresh interior paint, dual-pane windows, and updated luxury vinyl plank flooring throughout. Conveniently located near schools, parks, shopping, HWY 84/Dumbarton Bridge, HWY 880, Tesla, Meta, and Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Brooke Crossland, Coldwell Banker Realty
$1,988,000 (USD)
Active

Brentwood Area Multi-Family Home

Active

6242 Montcalm Ave Newark, CA 94560

Bed
0 Baths
2344 sqft
MLS# 41145316
Live in one, rent the others! What if the potential rental income from a main home + Jr. ADU + ADU could help you qualify for this single-family home in a desirable residential community? Explore the possibilities of multi-generational living, rental income, and long-term investment potential—all in one property. This remodeled and updated property offers three separate living spaces, making it ideal for multigenerational living, extended family, guests, or potential rental income. The main residence features 3 bedrooms and 2 bathrooms with updated kitchen and living areas. One bedroom and full bathroom are conveniently located on the main level, along with sliding door access to the backyard. The renovated kitchen features stone countertops, built-in microwave, gas stove, stainless steel appliances, ample cabinet space, and direct backyard access for easy indoor-outdoor living. The Jr. ADU features a kitchen/dinette, bedroom, full bathroom, French doors, private entrance, and interior access to the main house. Its flexible layout can function as a separate living space or be closed off from the main residence for added privacy. The ADU includes an updated kitchen, bedroom, living room, full bathroom with step-in shower and waterfall showerhead, private entrance, separate electric meter, and dedicated mini-split HVAC. The large backyard offers a serene retreat with mature cypress and palm trees, spacious patio, and ample room for entertaining, gardening, outdoor activities, or relaxing. A beautiful pool with cascading waterfall feature and safety fence serves as the centerpiece, while solar heating extends enjoyment year-round. A leased solar system provides power to the main residence and Jr. ADU. The newly built garage features finished walls and a durable epoxy floor. Additional features include central A/C or mini-split HVAC in all spaces, fresh interior paint, dual-pane windows, and updated luxury vinyl plank flooring throughout. Conveniently located near schools, parks, shopping, HWY 84/Dumbarton Bridge, HWY 880, Tesla, Meta, and Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Brooke Crossland, Coldwell Banker Realty
$1,898,888 (USD)
Active

Heritage Area Single Family Home

Active

392 E McKinley Ave Sunnyvale, CA 94086

3 Bed
2 Baths
1313 sqft
MLS# 41149426
Located in Sunnyvale’s Heritage District, this beautifully renovated (WITH PERMITS), Craftsman-style bungalow offers 3 bedrooms, 2 bathrooms, 1,313 sq ft of living space on a spacious nearly 7,000 sq ft lot. Filled with natural light, the single-level floor plan showcases LVP flooring, recessed lighting, new windows, and stylish finishes throughout. The remodeled kitchen features modern quartz countertops, new cabinetry, stainless steel appliances, a gas range, and ample counter and storage space. Both bathrooms have been completely remodeled with tile flooring, custom tilework, new vanities, and contemporary fixtures, including a walk-in shower in one bath and a shower/tub combination in the other. Other notable improvements include a new HVAC system, 200-amp electrical panel, and indoor laundry with gas dryer hookup. Outside, the large backyard offers a newer deck, updated fencing, low-maintenance landscaping, and plenty of room for entertaining, relaxing, or play. The extended driveway provides ample off-street parking for multiple vehicles, with potential space for an RV, while the generous under-home storage area provides added functionality. Ideally located just steps away from Downtown Sunnyvale and Cityline, with Whole Foods, Target, AMC Theatres, Historic Murphy Avenue, the Saturday Farmers Market, restaurants, shopping, and Sunnyvale Caltrain all nearby. Convenient access to Central Expressway, Lawrence Expressway, and major Silicon Valley employment centers makes this an exceptional place to call home.
Listing Courtesy of bridgeMLS / Listed By: Karen Ostil, Coldwell Banker Realty