My Office's Listings

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

Glenmoor Gardens Area Single Family Home

Pending

4328 Cognina Ct Fremont, CA 94536

4 Bed
4 Baths
2904 sqft
MLS# 41115539
Virtual Tour
Tucked into a charming cul-de-sac in the sought-after Glenmoor neighborhood, this stunning home offers a rare combination of a sprawling lot, expansive floor plan and unbeatable location! Filled with natural light, this thoughtfully designed single-story home has picturesque yard views around every corner. The beautifully remodeled kitchen features granite counters, custom cabinetry & stainless steel appliances including a gas stove. Quality details throughout: central AC, updated bathrooms, recessed lighting & dual-pane windows. One of the home’s most versatile features is a spacious attached suite with its own private entrance, kitchen, bedroom, bathroom & backyard access—ideal for multi-generational living, guests or a potential JADU. Situated on an approx 13,391 sqft lot, the yard is built for entertaining with a swimming pool, lush lawn and an outdoor kitchen equipped with a grill, fridge, large TV & fire pit bar. This sizable lot also has a playhouse, 2 large storage sheds, RV access & space for a potential ADU or expansion. This one-of-a-kind home is ideally located near great schools, parks, shopping & local eateries. Perfect for commuters, nearby 880, Dumbarton Bridge, BART & Centerville Station. Don’t miss your chance to call this rare Glenmoor home yours!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau
$2,645,000 (USD)
Pending

Newark Area Single Family Home

Pending

6773 Brush Rabbit Ave Newark, CA 94560

5 Bed
6 Baths
3535 sqft
MLS# 41113379
Virtual Tour
Welcome to this exquisite 5-bed, 5.5-bath home located in the desirable Sanctuary Village community in Newark. Spanning 3535 sqft. it offers a blend of comfort, modern style and smart living. Enjoy the open feel created by the soaring 10-foot ceilings at the main level and 9-foot ceilings upstairs complemented by durable porcelain tile flooring, plush carpeting, recessed lighting and custom chandeliers. The gourmet kitchen is equipped with high-end appliances, premium quartz countertops and a waterfall island—perfect for everyday living and entertaining. A convenient bedroom with en-suite bath on the main floor is ideal for guests or multigenerational families. Upstairs, the oversized primary suite offers a spa-like retreat with a freestanding tub, dual vanities, and a spacious walk-in closet with direct access to the laundry room. Step outside to a custom Moroccan-inspired backyard, featuring a stone fireplace and a decorative water fountain, creating a serene atmosphere for relaxing or hosting. Smart and energy-efficient features include: Smart Hub, 2-Zone central heating/AC, EV prewired, Tankless water heater, Owned Tesla Solar system. 2-car attached garage with additional storage space. The home is minutes from major employers, commuter routes, shopping and dining.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song
$2,498,800 (USD)
Pending

Glenmoor Gardens Area Single Family Home

Pending

4715 Eggers Dr Fremont, CA 94536

4 Bed
4 Baths
2731 sqft
MLS# 41114818
Virtual Tour
Introducing a rare Glenmoor gem! With 2,715 sq ft of living space on a sprawling 10k+ sq ft lot, this home offers privacy, modern upgrades and the timeless charm you’ve been looking for. You’ll find thoughtful updates throughout including, upgraded bathrooms, hardwood flooring, new carpeting, a dedicated work area and so much more! The gorgeously remodeled kitchen features elegant quartz counters, custom cabinetry, center island and updated appliances including a gas stove & double ovens. The expanded primary suite features a spa-style bathroom with a soaking tub & a walk-in closet, while a junior suite with its own full bath provides privacy for guests or multigenerational living. A detached private office structure with heating/AC and wired internet provides a quiet, professional space with excellent connectivity. The private backyard is a resort-style retreat, featuring a fire pit, outdoor TV, built-in speakers and a large deck for outdoor entertaining. You’ll also find a tree house, 2 large storage structures and a Tesla car charger plug. The home includes solar panels and a Tesla Powerwall battery backup system. Located near excellent schools, parks, shopping and major commuter routes- this home is your gateway to Silicon Valley. This move-in ready dream home is a must-see!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau
$2,388,000 (USD)
Pending

Mission San Jose Area Single Family Home

Pending

124 Linmore Dr Fremont, CA 94539

5 Bed
2 Baths
1604 sqft
MLS# 41114084
Virtual Tour
Location, location, location! Welcome to this beautifully updated single-level North-West facing home nestled in one of Fremont’s most desirable neighborhoods, within the acclaimed Mission San Jose schools attendance area. Totally modernized & no longer a 1954 home. This custom & expanded residence offers a modern floor plan w/ no steps inside the home including 5 bedrooms & 2 full bathrooms, or 4 bedrooms w/ a large family room or formal dining room. The custom double-door entry way opens to a welcoming foyer & a bright formal living room w/ recessed lighting & custom skylight. Updated kitchen features custom cabinetry, quartz counters, high-end appliances & an eating area w/ access to the backyard patio. Both bathrooms have been updated. Other fine features include premium luxury flooring, recessed LED lighting, dual-pane windows, upgraded central AC & heating system, copper plumbing, & finished garage w/ new epoxy flooring. The front, side, & back yards are professionally landscaped w/ custom cement aggregate driveway & walkways, lush green areas, & beautifully designed details. Conveniently located near Ohlone College, historic Mission San Jose, restaurants, shopping, & Lake Elizabeth Central Park. Quick access to 680, 880, BART station & major Silicon Valley companies shuttl
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$1,950,000 (USD)
Active

Northgate Area Single Family Home

Active

34233 Atteridge Pl Fremont, CA 94555

3 Bed
2 Baths
1854 sqft
MLS# 41115650
Virtual Tour
Tucked into a charming cul-de-sac in the sought-after Northgate neighborhood, this beautiful single-story home offers the ideal blend of comfort, privacy, and modern upgrades. The thoughtfully customized floor plan features open living areas and a seamless flow between rooms, creating a welcoming and functional space for everyday living. The expanded living room showcases luxurious cathedral ceilings with skylights, a built-in office nook, and a custom wet bar. Notable upgrades include owned solar panels (under Net Energy Metering 2.0), stylish herringbone LVP flooring, new carpeting, freshly painted interiors and energy-efficient dual-pane windows. The kitchen features granite countertops, custom oak cabinetry, new fridge and tile flooring. Step into the spacious backyard with a wood lattice pergola, sprawling lawn area, storage shed and RV side access—perfect for entertaining, gardening or extra parking. This generous lot also has potential for future expansion or ADU. Ideally located near excellent schools and within walking distance to parks, shopping centers, and Alameda Creek Trail. A commuter’s dream with easy access to 880, Dumbarton Bridge, BART, and Centerville Train Station. Don’t miss this rare opportunity in the Northgate neighborhood—this home is a must-see!
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Lester Belliveau
$1,748,000 (USD)
Pending

Northgate Area Single Family Home

Pending

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