My Office's Listings

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

Glenmoor Gardens Area Single Family Home

Active

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,488,000 (USD)
Pending

Quail Run Area Single Family Home

Pending

3355 Winter Wren Pl Fremont, CA 94555

4 Bed
3 Baths
2598 sqft
MLS# 41111456
Virtual Tour
Welcome to this East-Facing Shapell Home in the Coveted Quail Run Community!This prestigious neighborhood is celebrated for its peaceful setting and resort-style amenities with a swimming pool, tennis courts, clubhouse, playground-perfect for relaxation and recreation. Top-rated schools: American High School, Thornton Middle, Warwick Elementary. It offers 4 beds and 3 baths (1 bed 1 bath downstairs) 2598 sqft of living space on a spacious 7641 sqft lot, situated in a quiet cul-de-sac, it is just steps to community amenities. The well-designed floor plan places the formal living room and dining room at the front, creating an elegant first impression. Toward the back, the modern kitchen, breakfast nook, and family room flow seamlessly together, with direct access to the downstairs bedroom and full bath. Upstairs the spacious primary suite includes a retreat area with a cozy fireplace, soaring ceilings, and a private balcony. The luxurious primary bath offers dual sink vanities, dual closets, and a shower over a high-end soaking tub. The home boasts a sizeable backyard perfect for entertaining and gardening, featuring a gazebo, paver patio, fruit-bearing trees. Conveniently located near dining, shopping options, local parks, BART, major freeways, corporate shuttle, esteemed schools.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song
$2,388,000 (USD)
Active

Mission San Jose Area Single Family Home

Active

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
$2,388,000 (USD)
Pending

Mission Area Single Family Home

Pending

41519 Apricot Ln Fremont, CA 94539

3 Bed
2 Baths
2018 sqft
MLS# 41111867
Virtual Tour
Location, location, location! Highly desirable single-story home in one of Fremont’s most sought-after neighborhoods. Situated on a tree-lined street close to Mission Valley Elementary, this North-facing home was recently updated throughout. Main house approx. 1,758 sqft + permitted sunroom approx. 260 sqft = approx 2,018 sqft of living space. The open floor plan offers a formal front living room, a dining room and a separate family room. A permitted sunroom opens up to the private backyard pool with 100% owned solar heating. The remodeled kitchen offers oak wood cabinetry, granite slab counters and full backsplash, and updated appliances. Additional features include remodeled bathrooms, hardwood flooring, new interior paint, recessed lighting, updated dual paned white vinyl windows & sun tunnels. Enjoy modern comfort with upgraded AC & furnace system, central vacuum and copper plumbing. Beautifully landscaped low-maintenance front & back yards. Front yard with slate stone walkways, custom retaining walls and artificial low maintenance lawn. Large backyard patio surrounding the pool & detached office. Close to Lake Elizabeth Central Park. Close to tech company shuttle bus stops. Top-ranked public schools include Mission Valley Elem, Hopkins Jr High and Mission San Jose High.
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