Featured Properties

Some or all of the listings below are provided by the Fremont office.
$1,999,900 (USD)
Active

Mission Lakes Area Single Family Home

Active

35615 Barnard Dr Fremont, CA 94536

3 Bed
2 Baths
1939 sqft
MLS# 41149851
Virtual Tour
Introducing a charming single-story home in the desirable Mission Lakes neighborhood of Fremont, offering the perfect blend of location, comfort and modern upgrades. Step inside to a bright and open floorplan featuring vaulted ceilings, generous living spaces and plenty of natural light throughout. The kitchen features custom cabinetry, granite countertops and stainless steel appliances including a gas range. Additional features include fresh interior paint, freshly installed carpet, central A/C, copper plumbing and convenient indoor laundry. With approximately 1,939 square feet of living space all on one level, the home offers a functional layout with plenty of room for everyday living and entertaining. The primary suite features a spacious closet and private bathroom with separate dual vanities, generous counter space and a tiled stall shower. The outdoor space is ideal for relaxing or entertaining with a lush lawn, lemon tree and aggregate concrete patio. Just a quick walk from Quarry Lakes Regional Park and Alameda Creek Trail; nearby top-rated schools, shopping, dining and everyday amenities. Ideally located for commuters, with convenient access to 880, 680, BART and the Dumbarton Bridge. With its blend of modern upgrades, spacious single-story floorplan and desirable location, this move-in ready home has it all. Don't miss the opportunity to call this Mission Lakes gem yours!
Listing Courtesy of bridgeMLS / Listed By: Lester Belliveau, 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
$699,000 (USD)
Active

Contempo Townhom Area Townhome

Active

4160 Aquarius Cir Union City, CA 94587

3 Bed
1 Baths
1137 sqft
MLS# 41149252
Virtual Tour
Charming Move-In Ready Townhome in Desirable Union City Location! Welcome to this charming end-unit townhome offering an open and versatile floor plan with newly installed laminate flooring throughout. The updated spacious kitchen features beautiful maple cabinetry, granite countertops, and a dual stainless-steel sink, creating a functional and inviting space for everyday living and entertaining. Upstairs, the spacious primary suite offers a generous closet and an updated bathroom. Two additional well-sized bedrooms provide plenty of flexibility for family, guests, a home office, or other needs. Additional features include central heating, dual-pane windows, indoor laundry, a large private backyard, a newly installed backyard fence, a detached two-car garage, and ample guest parking. The HOA is in the process of painting the exterior of the building. Enjoy a convenient location near Union Landing, shopping, dining, parks, I-880, Highway 92, BART, major Bay Area tech hubs, and the Dumbarton Bridge, making commuting and everyday conveniences easily accessible. An excellent opportunity for first-time home buyers or investors seeking a well-maintained, move-in ready home in a convenient Union City location. Don’t miss the opportunity to make this wonderful townhome your new home! 360VT https://tinyurl.com/2t7zxj9a
Listing Courtesy of bridgeMLS / Listed By: Poyen Gono, 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
$1,598,000 (USD)
Pending

Cherry Guardino Area Single Family Home

Pending

38660 Moore Dr Fremont, CA 94536

3 Bed
2 Baths
1298 sqft
MLS# 41148450
Virtual Tour
Welcome to 38660 Moore Drive, a beautifully updated Fremont home located in an established neighborhood. Thoughtfully refreshed throughout, this three-bedroom residence features bright living spaces, modern finishes, and comfortable indoor-outdoor living. Fresh interior paint, new baseboards, waterproof SPC flooring, dual-pane windows, and updated fixtures and hardware create a clean, cohesive feel throughout the home. The spacious living room features vaulted ceilings, a fireplace with a new mantel, and large dual-pane windows overlooking the backyard, filling the space with natural light. The updated kitchen features quartz countertops, new stainless-steel appliances, ample cabinetry, recessed lighting, and large dual-pane windows overlooking the backyard. An open connection to the dining area and direct access to the backyard provide a seamless flow for everyday living and entertaining. The primary suite offers vaulted ceilings, two closets, and an updated bathroom with a glass-enclosed walk-in shower, rainfall showerhead, recessed lighting, and dedicated vanity area. The fully remodeled hall bathroom features a new vanity, medicine cabinet mirror, lighting, toilet, flooring, shower enclosure and fixtures, dual-pane window, exhaust fan, and two recessed lights. The large backyard provides a peaceful outdoor setting with mature lemon trees, a storage shed, patio area, extending awning, and generous space for gardening, entertaining, play, or relaxing outdoors. The garage includes built-in storage cabinetry, a new Samsung washer and dryer set, automatic garage door opener, and an updated furnace and water heater. Conveniently located near local schools, parks, shopping, dining, and public transportation, with easy access to I-680 and I-880 for commuting throughout the Bay Area and Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Brooke Crossland, Coldwell Banker Realty