My Office's Listings

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

Quail Run Area Single Family Home

Active

3356 Winter Wren Pl Fremont, CA 94555

4 Bed
3 Baths
3314 sqft
MLS# 41145019
Virtual Tour
Nestled in the prestigious Quail Run community, this exceptional Shapell-built home offers the perfect blend of luxury, comfort, and convenience. Known for its peaceful setting and resort-style amenities, Quail Run features a community swimming pool, tennis courts, clubhouse, and beautifully maintained common areas. The home is also served by highly acclaimed schools, including American High School, Thornton Middle School, and Warwick Elementary School. Offering approximately 3,314 square feet of living space on a 7,667 square foot lot, this spacious residence features 4 bedrooms, a large entertainment room, and 3 full bathrooms, including a desirable main-level 1 bedroom 1 full bath, ideal for guests, multigenerational living, or a home office. Located on a quiet cul-de-sac just steps from the community amenities, this home enjoys an ideal location within the neighborhood. The thoughtfully designed floor plan welcomes you with elegant formal living and dining rooms, creating a grand first impression. Toward the rear of the home, the beautifully remodeled kitchen opens seamlessly to the breakfast nook and spacious family room, creating the perfect gathering space for everyday living and entertaining. The chef's kitchen is appointed with professional-grade stainless steel appliances, including a gas cooktop, built-in double ovens, powerful range hood, dishwasher, abundant cabinetry, and generous counter space. Upstairs, the luxurious primary suite offers soaring ceilings with recessed lighting and a spa-inspired ensuite bathroom featuring a spacious walk-in closet, dual-sink vanity, freestanding soaking tub, separate stall shower, and a large skylight that fills the space with natural light. Two generously sized secondary bedrooms share a beautifully updated hall bathroom complete with dual vanities and a shower-over-tub, offering both comfort and functionality. A highlight of the upper level is the expansive entertainment room featuring dramatic high ceilings, recessed lighting, a built-in wet bar, and a cozy gas fireplace—an ideal space for family gatherings, movie nights, game room, or recreation. Step outside to the spacious backyard, offering plenty of room for outdoor entertaining, gardening, or simply relaxing in your own private retreat. Conveniently located near shopping, dining, neighborhood parks, Quarry Lakes Regional Recreation Area, Alameda Creek Trail, BART, major commuter routes, and corporate shuttle services, this exceptional home offers.
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, Coldwell Banker Realty
$2,478,000 (USD)
Active

Stonebrae Country Club Area Single Family Home

Active

65 Stonebrae Rd Hayward, CA 94542

4 Bed
5 Baths
3420 sqft
MLS# 41143404
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,448,800 (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,198,000 (USD)
Active

Brentwood Area Single Family Home

Active

6242 Montcalm Ave Newark, CA 94560

5 Bed
4 Baths
2344 sqft
MLS# 41144893
Virtual Tour
Looking for a property with a Main House + ADU + Jr. ADU? This remodeled and updated property offers three separate living spaces, making it ideal for multigenerational living, extended family, guests, or potential rental income. The main residence features 3 bedrooms and 2 bathrooms with updated kitchen and living areas. One bedroom and full bathroom are conveniently located on the main level, along with sliding door access to the backyard. The renovated kitchen features stone countertops, built-in microwave, gas stove, stainless steel appliances, ample cabinet space, and direct backyard access for easy indoor-outdoor living. The Jr. ADU features a kitchen/dinette, bedroom, full bathroom, French doors, private entrance, and interior access to the main house. Its flexible layout can function as a separate living space or be closed off from the main residence for added privacy. The ADU includes an updated kitchen, bedroom, living room, full bathroom with step-in shower and waterfall showerhead, private entrance, separate electric meter, and dedicated mini-split HVAC. The large backyard offers a serene retreat with mature cypress and palm trees, spacious patio, and ample room for entertaining, gardening, outdoor activities, or relaxing. A beautiful pool with cascading waterfall feature and safety fence serves as the centerpiece, while solar heating extends enjoyment year-round. A leased solar system provides power to the main residence and Jr. ADU. The newly built garage features finished walls and a durable epoxy floor. Additional features include central A/C or mini-split HVAC in all spaces, fresh interior paint, dual-pane windows, and updated luxury vinyl plank flooring throughout. Conveniently located near schools, parks, shopping, HWY 84/Dumbarton Bridge, HWY 880, Tesla, Meta, and Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Brooke Crossland, Coldwell Banker Realty
$2,198,000 (USD)
Active

Brentwood Area Multi-Family Home

Active

6242 Montcalm Ave Newark, CA 94560

Bed
0 Baths
2344 sqft
MLS# 41145316
Looking for a property with a Main House + ADU + Jr. ADU? This remodeled and updated property offers three separate living spaces, making it ideal for multigenerational living, extended family, guests, or potential rental income. The main residence features 3 bedrooms and 2 bathrooms with updated kitchen and living areas. One bedroom and full bathroom are conveniently located on the main level, along with sliding door access to the backyard. The renovated kitchen features stone countertops, built-in microwave, gas stove, stainless steel appliances, ample cabinet space, and direct backyard access for easy indoor-outdoor living. The Jr. ADU features a kitchen/dinette, bedroom, full bathroom, French doors, private entrance, and interior access to the main house. Its flexible layout can function as a separate living space or be closed off from the main residence for added privacy. The ADU includes an updated kitchen, bedroom, living room, full bathroom with step-in shower and waterfall showerhead, private entrance, separate electric meter, and dedicated mini-split HVAC. The large backyard offers a serene retreat with mature cypress and palm trees, spacious patio, and ample room for entertaining, gardening, outdoor activities, or relaxing. A beautiful pool with cascading waterfall feature and safety fence serves as the centerpiece, while solar heating extends enjoyment year-round. A leased solar system provides power to the main residence and Jr. ADU. The newly built garage features finished walls and a durable epoxy floor. Additional features include central A/C or mini-split HVAC in all spaces, fresh interior paint, dual-pane windows, and updated luxury vinyl plank flooring throughout. Conveniently located near schools, parks, shopping, HWY 84/Dumbarton Bridge, HWY 880, Tesla, Meta, and Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Brooke Crossland, Coldwell Banker Realty
$1,799,998 (USD)
Active

Sunnyvale Area Townhome

Active

332 Harcot Ter Sunnyvale, CA 94085

4 Bed
4 Baths
1916 sqft
MLS# 41143387
Located in the heart of Silicon Valley within walking distance to major employers, Caltrain, and Downtown Sunnyvale, this luxury three-story home is a former Toll Brothers model home featuring designer finishes throughout. The ground floor offers a private suite with a spacious bedroom and en-suite bathroom showcasing a quartz countertop and stall shower — perfect for multi-generational living, or as a dedicated home office for those who work remotely.The second level showcases a light-filled, open-concept floor plan with expansive windows on three walls, recessed lighting, and abundant natural light throughout. The inviting living room opens to a private balcony — a great space to entertain family and friends. The gourmet kitchen features a large island, quartz countertops, stainless steel appliances, ample cabinetry, and a separate pantry. A convenient half bathroom is tucked at the stair landing. The third floor is home to the primary suite, offering a spacious bedroom with large windows and an en-suite bathroom with double-vanity quartz countertops, a stall shower, and a walk-in closet. Two additional bedrooms are ideal for family or guests, complemented by a hallway bathroom with a quartz countertop and a shower-over-tub. Laundry with washer and dryer is conveniently located on the same level. Notable upgrades include custom Lutron motorized blinds and drapery — turning daylight into a dynamic design element throughout the home — a SkyBell video doorbell for anytime front-door access with an alarm system, an EV charger, and an attached two-car garage to name a few. Close to Downtown Sunnyvale, parks, restaurants, grocery stores, and shopping, with easy access to Caltrain, Highways 101 and 237, and a short commute to major tech companies. Don't miss this rare opportunity!
Listing Courtesy of bridgeMLS / Listed By: Moni Shah, Coldwell Banker Realty
$1,799,000 (USD)
Pending

Glenmoor Area Single Family Home

Pending

5353 Sayre Ave Fremont, CA 94536

4 Bed
2 Baths
1811 sqft
MLS# 41144014
Virtual Tour
Filled with natural light and thoughtfully designed for comfortable everyday living, this beautifully updated single-story home offers generous gathering spaces, quality improvements and all the charm of the Glenmoor neighborhood. The versatile floor plan features a welcoming living room, separate dining area and an expansive family room with soaring vaulted ceilings. Open to the family room, the custom kitchen is designed for both cooking and gathering with rich wood cabinetry, granite countertops, a skylight and stainless steel appliances including a built-in gas cooktop. Beautiful hardwood flooring, recessed lighting and built-in speakers extend throughout the home, creating a polished and cohesive feel from room to room. The private bedroom wing includes four bedrooms and two gorgeously remodeled bathrooms, each featuring a spacious stall shower and striking contemporary finishes. Sun tunnels bring additional natural light into the hallway and bathrooms. Additional highlights include central A/C, dual-pane windows, custom window coverings, smart switches, a whole-house fan, owned solar panels and updated waste lines. Recent improvements include a roof replaced in 2023 and a water heater replaced in 2024. The finished two-car garage offers extensive built-in cabinetry and exceptional storage. Paver hardscaping enhances both the front and backyard, where a covered deck, spacious lawn, storage shed and mature persimmon, orange and lemon trees create an inviting setting to relax or entertain. Ideally situated near Glenmoor’s parks, pools, tennis courts, schools, shopping and convenient commuter routes, this distinctive home brings together flexible living spaces, thoughtful upgrades and an unmistakably Glenmoor setting.
Listing Courtesy of bridgeMLS / Listed By: Lester Belliveau, Coldwell Banker Realty
$1,748,000 (USD)
Active

Brookvale Area Single Family Home

Active

3105 Rowe Pl Fremont, CA 94536

3 Bed
3 Baths
1688 sqft
MLS# 41144469
Virtual Tour
Welcome to this exceptional fully remodeled Brookvale residence, offering 3 beds, 3 baths, 1688 sqft of living space, a 5406 sqft lot. The heart of the home is the stunning chef’s kitchen, featuring custom-designed HB Kitchen cabinetry, a spacious pantry, and luxurious quartz countertops extending across the cabinetry, backsplash, and oversized waterfall island. The expansive island offers a breakfast bar, built-in microwave, and premium 36-inch extra-wide sink. Designed for culinary excellence, the kitchen is equipped with a six-burner freestanding gas range, powerful 36-inch hood, and convenient pot filler. Two skylights with remote-controlled adjustable blinds provide abundant natural light and enhance the elegant open-concept design. The kitchen seamlessly flows into the inviting family room, highlighted by custom cabinetry with sophisticated quartz accents surrounding the electric fireplace and premium porcelain tile flooring. Throughout the home, eco-friendly California bamboo flooring adds warmth and elegance. All three remodeled bathrooms feature designer tile shower surrounds, heavy-duty glass barn-door-style enclosures, modern vanities with ample storage, touch-control illuminated mirrors, water-efficient fixtures, and luxury porcelain tile finishes. Additional upgrades include a custom-crafted entry door, new interior wood doors, recessed lighting throughout, hallway sun tunnels, upgraded high-efficiency insulation, central air conditioning, and a newer roof installed in 2019. The beautifully enhanced garage features integrated attic storage, dedicated lighting, and a Tesla-ready EV charging station. Ideally located in the desirable Brookvale neighborhood, this home offers exceptional convenience with walking distance to Brookvale Elementary School, Thornton Middle School, American High School, and Los Cerritos Park & Community Center. Enjoy easy access to Quarry Lakes Regional Recreation Area, I-880, I-680, the Dumbarton Bridge, and BART. Everyday shopping and dining are just minutes away at Brookvale Shopping Center, featuring Lucky, Planet Fitness, Starbucks, a gas station, UPS, and local eateries. A rare opportunity to own a meticulously upgraded home that seamlessly blends luxury finishes, modern technology, and an unbeatable Fremont location.
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, Coldwell Banker Realty