My Office's Listings

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,480,000 (USD)
Active

Mission Area Single Family Home

Active

42635 Sully St Fremont, CA 94539

4 Bed
2 Baths
1927 sqft
MLS# 41147862
Virtual Tour
Welcome to this beautifully updated East-facing home in the highly desirable Mission San Jose neighborhood of Fremont. Offering excellent curb appeal and an outstanding location, this home is conveniently within walking distance of award-winning Chadbourne Elementary, Hopkins Middle School, and Mission San Jose High School. Thoughtfully remodeled and expanded, this home features 4 bedrooms, 2 full bathrooms, approximately 1,927 sq. ft. of living space, and a spacious 7,992 sq. ft. lot. The comfortable and functional floor plan is designed for both everyday living and entertaining. The inviting entry features elegant travertine tile and a skylight that fills the space with natural light. Formal living and dining rooms with recessed lighting offer welcoming spaces for gatherings. The remodeled kitchen showcases quartz countertops, tile flooring, a gas range, and a convenient breakfast area. The spacious family room features a cozy fireplace and direct access to the private backyard, creating a seamless indoor-outdoor connection. The primary suite offers a walk-in closet and an updated bathroom. Additional highlights include freshly painted interiors, recently refinished hardwood floors, dual-pane windows, recessed lighting, solid-core doors, a sun tunnel, copper plumbing, and Owned Solar System. Enjoy the private backyard with mature fruit trees, offering a peaceful setting for relaxing, gardening, and outdoor entertaining. A wonderful opportunity to own a beautifully updated and expanded East-facing home in one of Fremont’s most sought-after neighborhoods!
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, 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
$2,288,000 (USD)
Pending

Mission Area Single Family Home

Pending

1061 Whitmer Ct Fremont, CA 94539

3 Bed
3 Baths
1596 sqft
MLS# 41149200
Introducing this beautiful single-story 3-bedroom, 2.5-bath home in the sought-after Mission Ranch development! Situated on a quiet court, this home sits on a premium park-like lot of approx. 11,040 sq ft in the Golden Triangle of Mission San Jose schools: Chadbourne Elementary, Hopkins Jr. High & Mission San Jose High. A granite tile entry leads to the formal living room and separate family room featuring beautiful 3/4-inch solid oak hardwood flooring and a sliding glass door to the beautiful back yard. The kitchen offers solid oak cabinetry and a separate breakfast area. The large primary suite is complemented by an updated bathroom with newer showers, vanities and toilet. Additional features include a custom front door, updated dual-pane windows and sliding glass door, custom wood trim around interior windows and doors, upgraded baseboards, crown molding, raised-panel interior doors, updated bathrooms, and an updated central A/C system. The spacious garage includes a half bathroom and updated roll-up door. The home also features an updated composition shingle roof and gutters. Beautifully landscaped grounds include a large front lawn and driveway, covered front porch, and an inviting backyard with a custom granite slate patio accented with red brick, lush lawn with automatic sprinklers, and numerous mature fruit trees and flowering plants. Excellent location near the library, restaurants, shopping, sports courts and Lake Elizabeth/Central Park. Easy access to 680, 880 and BART, with a convenient commute to major Silicon Valley employers.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty