My Office's Listings

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

Quail Run Area Single Family Home

Pending

3356 Winter Wren Pl Fremont, CA 94555

4 Bed
3 Baths
3314 sqft
MLS# 41145019
Virtual Tour
Nestled in the prestigious Quail Run community, this exceptional Shapell-built home offers the perfect blend of luxury, comfort, and convenience. Known for its peaceful setting and resort-style amenities, Quail Run features a community swimming pool, tennis courts, clubhouse, and beautifully maintained common areas. The home is also served by highly acclaimed schools, including American High School, Thornton Middle School, and Warwick Elementary School. Offering approximately 3,314 square feet of living space on a 7,667 square foot lot, this spacious residence features 4 bedrooms, a large entertainment room, and 3 full bathrooms, including a desirable main-level 1 bedroom 1 full bath, ideal for guests, multigenerational living, or a home office. Located on a quiet cul-de-sac just steps from the community amenities, this home enjoys an ideal location within the neighborhood. The thoughtfully designed floor plan welcomes you with elegant formal living and dining rooms, creating a grand first impression. Toward the rear of the home, the beautifully remodeled kitchen opens seamlessly to the breakfast nook and spacious family room, creating the perfect gathering space for everyday living and entertaining. The chef's kitchen is appointed with professional-grade stainless steel appliances, including a gas cooktop, built-in double ovens, powerful range hood, dishwasher, abundant cabinetry, and generous counter space. Upstairs, the luxurious primary suite offers soaring ceilings with recessed lighting and a spa-inspired ensuite bathroom featuring a spacious walk-in closet, dual-sink vanity, freestanding soaking tub, separate stall shower, and a large skylight that fills the space with natural light. Two generously sized secondary bedrooms share a beautifully updated hall bathroom complete with dual vanities and a shower-over-tub, offering both comfort and functionality. A highlight of the upper level is the expansive entertainment room featuring dramatic high ceilings, recessed lighting, a built-in wet bar, and a cozy gas fireplace—an ideal space for family gatherings, movie nights, game room, or recreation. Step outside to the spacious backyard, offering plenty of room for outdoor entertaining, gardening, or simply relaxing in your own private retreat. Conveniently located near shopping, dining, neighborhood parks, Quarry Lakes Regional Recreation Area, Alameda Creek Trail, BART, major commuter routes, and corporate shuttle services, this exceptional home offers.
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, Coldwell Banker Realty
$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 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,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