My Office's Listings

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

Glenmoor Area Single Family Home

Pending

37826 Glenmoor Dr Fremont, CA 94536

4 Bed
2 Baths
1666 sqft
MLS# 41111898
Virtual Tour
Nestled in the highly desirable Glenmoor neighborhood, this gorgeous single-story home offers an ideal floor plan with stylish upgrades throughout. The beautifully updated kitchen showcases custom cabinets, quartz counters, mosaic tile backsplash, island and stainless steel appliances including a gas stove and dual ovens. Additional highlights include recently installed LVP flooring in the main living areas, dual pane windows, recessed lighting, copper plumbing and upgraded electrical panel with EV charging. A spacious hall bathroom includes a quartz-topped vanity, custom cabinets, stall shower and soaking tub. The primary suite showcases engineered maple floors, a walk-in closet, a private bath with custom vanity and direct access to the serene backyard. Situated on a huge approx. 11,924 sqft lot, the outdoor space is ideal for entertaining with a lush lawn, redwood deck, patio and a saltwater pool powered by its own dedicated solar system. Enjoy fruit trees, vegetables, a storage shed and a finished shed with built-in shelving, wood floors, lighting and A/C—ideal as a hangout or home office. This excellent location is walking distance to schools and parks, quick access to 880, Dumbarton Bridge, BART and Centerville Station. Move-in ready, this Glenmoor gem is not to be missed!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau
$1,748,000 (USD)
Active

Northgate Area Single Family Home

Active

3134 Warwick Rd Fremont, CA 94555

4 Bed
2 Baths
1402 sqft
MLS# 41114402
Virtual Tour
This thoughtfully remodeled open-concept home in the desirable Northgate neighborhood highlights modern design, quality craftsmanship, and attention to detail. Featuring 4 spacious bedrooms, 2 updated bathrooms, and a finished 2-car garage, the residence offers 1,402 sqft of living space on a 7,190 sqft lot. Recent upgrades include fresh interior and exterior paint, luxury vinyl plank flooring throughout, tile flooring in both bathrooms, and 24 new recessed lights. The chef’s kitchen is appointed with quartz countertops, new cabinetry, a full tile backsplash, stainless steel appliances with gas cooktop, and connects seamlessly to the expansive living room and entry hall—ideal for everyday living and entertaining. The landscaped front and rear yards provide inviting outdoor spaces. The large backyard features side access to a concrete parking area and presents excellent potential for an ADU, pool, or private retreat. Located near top-rated schools—Warwick Elementary, Thornton Junior High, and American High—this property also offers easy access to Decoto Road, the Dumbarton Bridge, Union City BART, and I-880 for convenient Bay Area commuting. Combining contemporary upgrades, a functional layout, and a prime location, this home is an exceptional opportunity in Northgate.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song