Featured Properties

$2,488,888 (USD)
Active

San Mateo Area Detached Single Family

Active

2015 Ticonderoga Drive San Mateo, CA 94402

3 Bed
2 Baths
1650 sqft
MLS# ML82065002
Set on a quiet cul-de-sac, this 3 Bedroom 2 Bath home sits on an oversized 12,638 sq. ft. lot, blending iconic mid-century design. One of the largest level lots in the SM Highlands for expansion possibilities. The 1,650 sq foot layout flows effortlessly from living and dining spaces to outdoor entertaining areas, ideal for both everyday living and hosting large events. Floor to ceiling walls of glass w/original Mahogany wood paneling. A permitted free-standing studio adds flexible space for a home office, gym, or artist workshop. Recently epoxied 2-car garage floor. Resealed Foam roof. Sewer lateral replaced in 2025. Successor Trustee sale with limited disclosures. This original owner home has been cared for since 1958. Staged for the fall season with a pumpkin patch to show off the generous sized grounds! Rec center includes community pool, tennis courts, and after school programs. Sawyer Camp Road close by for walking, jogging, plus bike trails along the Crystal Springs reservoir. Close to Highlands Elementary School. In the Aragon High School district. Location! Location! Location!
Listed by MLSlistings Inc. / Listed By: Glenn Sennett, 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
$2,480,000 (USD)
Pending

Mission Area Single Family Home

Pending

42635 Sully St Fremont, CA 94539

4 Bed
2 Baths
1927 sqft
MLS# 41147862
Virtual Tour
Welcome to this beautifully updated East-facing home in the highly desirable Mission San Jose neighborhood of Fremont. Offering excellent curb appeal and an outstanding location, this home is conveniently within walking distance of award-winning Chadbourne Elementary, Hopkins Middle School, and Mission San Jose High School. Thoughtfully remodeled and expanded, this home features 4 bedrooms, 2 full bathrooms, approximately 1,927 sq. ft. of living space, and a spacious 7,992 sq. ft. lot. The comfortable and functional floor plan is designed for both everyday living and entertaining. The inviting entry features elegant travertine tile and a skylight that fills the space with natural light. Formal living and dining rooms with recessed lighting offer welcoming spaces for gatherings. The remodeled kitchen showcases quartz countertops, tile flooring, a gas range, and a convenient breakfast area. The spacious family room features a cozy fireplace and direct access to the private backyard, creating a seamless indoor-outdoor connection. The primary suite offers a walk-in closet and an updated bathroom. Additional highlights include freshly painted interiors, recently refinished hardwood floors, dual-pane windows, recessed lighting, solid-core doors, a sun tunnel, copper plumbing, and Owned Solar System. Enjoy the private backyard with mature fruit trees, offering a peaceful setting for relaxing, gardening, and outdoor entertaining. A wonderful opportunity to own a beautifully updated and expanded East-facing home in one of Fremont’s most sought-after neighborhoods!
Listing Courtesy of bridgeMLS / Listed By: Aimee Ran Song, Coldwell Banker Realty
$2,437,500 (USD)
Active

Diablo Area Single Family Home

Active

2065 Diablo Rd Diablo, CA 94528

4 Bed
2 Baths
2687 sqft
MLS# 41146584
Nestled on a premium, level 0.663-acre lot in coveted Diablo, this exceptional single-story residence offers an ideal blend of comfort, privacy, and endless possibilities. A circular driveway with ample parking space welcomes you to the home, where an open and spacious floor plan is designed for both everyday living and effortless entertaining. The living room is anchored by a beautiful fireplace, overlooking the picturesque backyard. At the heart of the home, the gourmet kitchen is appointed with granite countertops, a center island with bar seating, Viking gas range, microwave, dishwasher, wine/beverage refrigerator, pantry, and abundant cabinetry. The kitchen flows seamlessly into the generous dining area with a walk-in temperature controlled wine cellar. An oversized den provides exceptional flexibility as a media room, game room, or potential guest space. The primary bedroom suite features backyard access with an ensuite bath highlighting a spacious walk-in shower. This home is complete with 3 secondary bedrooms and a hallway bath. Step outside to your own private park-like retreat. The sprawling backyard is highlighted by a sparkling pool, expansive lawn, and mature trees that create incredible privacy. With plenty of level space to expand, add an ADU, sports court, outdoor kitchen, or create the backyard of your dreams, the possibilities are endless. Perfectly positioned near Diablo and Blackhawk Country Clubs, and within the acclaimed San Ramon Valley School District - Green Valley Elementary, Los Cerros Middle School & Monte Vista High School. This home places you at the center of it all. From outdoor recreation to top-tier amenities, don’t miss this opportunity!
Listing Courtesy of bridgeMLS / Listed By: Khrista Jarvis, Coldwell Banker Realty
$2,399,000 (USD)
Pending

Alamo Creek Area Single Family Home

Pending

5194 Bengali St Danville, CA 94506

5 Bed
4 Baths
4668 sqft
MLS# 41149841
Welcome to this exceptional Cypress model offering an ideal blend of elegance, functionality, and endless possibilities. Designed for modern living, the home features inviting formal spaces, a spacious great room, and a desirable main-level bedroom and full bath—perfect for guests or multigenerational living. One of the home's standout features is the oversized bonus room with its own private staircase, presenting a rare opportunity to create a separate living space, home office, media room, or future ADU-style suite. At the heart of the home is a beautifully appointed kitchen showcasing premium Thermador and Bosch appliances, an oversized island, extensive cabinetry, and a dedicated workspace for everyday convenience. Upstairs, the serene primary suite offers a peaceful escape with a private balcony overlooking the surrounding area, while the spa-like bath and custom walk-in closet provide a luxurious finishing touch. Three additional bedrooms and a full bath complete the upper level. Step outside to enjoy a backyard designed for both relaxation and entertaining, featuring multiple patio areas, a fire pit, mini golf, built-in BBQ station, and tranquil open-space views. Perfectly positioned near Creekside Elementary, neighborhood parks, the community clubhouse, pool, gym and Blackhawk Plaza, this residence delivers the lifestyle today's buyers have been waiting for.
Listing Courtesy of bridgeMLS / Listed By: Jing Xue, Coldwell Banker Realty
$2,398,000 (USD)
Pending

San Mateo Area Multi-Family

Pending

1710-1712 Gum Street San Mateo, CA 94402

Bed
0 Baths
2940 sqft
MLS# ML82060063
Virtual Tour
Rare opportunity to own a contemporary duplex offering two executive-style townhouse residences on one lot, built in 2004. Live in one, rent out the other, create an ideal multi-generational setup, or explore the potential for condo conversion. Both residences are exceptionally bright with abundant natural light and quality finishes throughout. 1710 Gum, the owner's residence, offers 2 bedrooms and 2.5 baths, with both bedrooms featuring en-suite baths. Wood flooring, soaring ceilings, recessed lighting, and a gourmet kitchen create an inviting environment. The spacious primary suite features a custom closet, luxurious bath with soaking tub, and private balcony. The backyard is perfect for entertaining, with a built-in BBQ gas line and vegetable garden beds with drip irrigation. One car garage with extra storage, A/C, and in-unit laundry. 1712 Gum offers 2 bedrooms, 2.5 baths, plus a versatile loft that could be a 3rd bedroom. The open floor plan features wood flooring, soaring ceilings, recessed lighting, gourmet kitchen, and a primary suite with gorgeous bath and soaking tub. Private balcony, side patio, attached one car garage, and A/C. A commuters dream! Steps from Hayward Park Caltrain, Starbucks, restaurants, shopping, and easy access to all major freeways. Welcome home!
Listed by MLSlistings Inc. / Listed By: Tami Chiu, Coldwell Banker Realty
$2,398,000 (USD)
Pending

Foster City Area Detached Single Family

Pending

653 Matsonia Drive Foster City, CA 94404

4 Bed
3 Baths
2180 sqft
MLS# ML82063918
Virtual Tour
Enjoy the best of waterfront living in this beautiful 4 bedroom, 3 bath home offering 2,190 square feet of comfortable living space on a generous 7,878 square foot lot. Perfectly positioned along a scenic canal with expansive water views, this home provides a peaceful setting with beautiful natural light and tranquil surroundings. The thoughtfully designed floor plan includes a bedroom and full bathroom on the main level, providing flexibility for guests, extended family, or a private home office. The home has been tastefully refreshed throughout, featuring an updated kitchen, brand new carpet, freshly painted interior, and new light fixtures. Large windows invite natural light and highlight the peaceful waterfront setting. Enjoy the ultimate outdoor lifestyle with a large waterfront backyard featuring a spacious deck designed for entertaining or outdoor dining. Bring your boat and enjoy the freedom of cruising right from your own backyard- creating the perfect setting for unforgettable days on the water or chasing the sunsets. Located in a highly convenient neighborhood, the home is just minutes from restaurants, Starbucks, Brewer Island Elementary School, the PJCC, weekly Farmers Market, and the newly built community center. Welcome Home!
Listed by MLSlistings Inc. / Listed By: Tami Chiu, Coldwell Banker Realty
$2,398,000 (USD)
Pending

Fremont Area Detached Single Family

Pending

236 Ottawa Way Fremont, CA 94539

5 Bed
4 Baths
2219 sqft
MLS# ML82059304
Welcome to this beautifully reimagined 5-bedroom, 4-bath home offering approximately 2,219 sq ft of living space on a generous 6,262 sq ft lot. Step inside to a bright, spacious living room filled with abundant natural light and designed for both comfortable everyday living and effortless entertaining. The home has been thoughtfully updated from top to bottom with fresh interior and exterior paint, new flooring, a fully remodeled kitchen, and four beautifully renovated bathrooms-all brought together with a cohesive, modern aesthetic. The stylish kitchen features new cabinetry, countertops, backsplash, fixtures, and appliances, while multiple living and dining areas provide flexibility for todays lifestyle. Central air conditioning adds year-round comfort. A permitted addition includes one bedroom and one bathroom, creating valuable space for guests, extended family, or a private home office. Conveniently located within the highly sought-after Irvington school district, including 10/10-rated Irvington High School. Move-in ready and waiting for its next owner-come experience the space, style, and warmth of this exceptional Fremont home.
Listed by MLSlistings Inc. / Listed By: Miranda Caley, Coldwell Banker Realty
$2,395,000 (USD)
Active

Santa Rosa Area Residential Home

Active

5755 Futura Way Santa Rosa, CA 95409

3 Bed
3 Baths
2166 sqft
MLS# 326077652
Some homes are designed to impress. Others are created to be remembered. 5755 Futura Way is a rare, storybook Victorian-inspired estate where timeless architecture, bespoke craftsmanship and the relaxed elegance of Sonoma Wine Country come together in a truly distinctive residence. Set on approximately 1.1 acres in northeast Santa Rosa, the home welcomes you with brick and flagstone pathways, beautifully landscaped gardens, roses, fruit and citrus trees, a charming fountain, and inviting front and rear porches that create an immediate sense of warmth and romance. Inside, the craftsmanship tells the story. This owner-built home was created with extraordinary attention to detail, from custom crown molding and Victorian window trim to solid doors, crystal hardware, antique and reproduction lighting, hardwood floors and finely crafted millwork throughout. The kitchen is both elegant and memorable, featuring custom solid-maple cabinetry, crystal hardware, dentil crown molding, granite countertops, Carrera tile, designer window treatments and a striking AGA stove from France. The primary suite offers a serene retreat with hardwood floors, an antique brass chandelier, custom architectural detailing and beautiful valley views. The adjoining bath is richly appointed with Carrera tile and stone, a spacious shower, Victorian-style tub, custom cabinetry, crystal hardware, designer fixtures and wainscoting. Thoughtfully designed secondary spaces continue the same level of finish, including a charming bedroom with custom window seat and cabinetry, a beautifully detailed guest bath, designer laundry room with Carrera countertop and farmhouse sink, custom mudroom, and a living room anchored by a tiled fireplace and built-in cabinetry. Modern comforts include heating and air conditioning on each floor, added insulation and a Kohler whole-house generator. Outside, the property feels like a private garden retreat, with winding pathways, brick garden spaces, mature landscaping, a fountain and a custom Amish-built chicken coop. More than a luxury home, 5755 Futura Way is a property with personality, artistry and soula one-of-a-kind residence created with vision, intention and an enduring appreciation for craftsmanship.
Listing Courtesy of BAREIS / Listed By: Patricia "Trish" McCall, Coldwell Banker Realty
$2,395,000 (USD)
Active

Sleepy Hollow Area Single Family Home

Active

16 Sunnyside Ct Orinda, CA 94563

5 Bed
5 Baths
2741 sqft
MLS# 41148080
Virtual Tour
A fresh opportunity and one of Orinda’s best values in the coveted Sleepy Hollow neighborhood! Set on a peaceful cul-de-sac and surrounded by mature trees and natural beauty, this beautifully remodeled 5-bedroom, 4.5-bath residence offers approximately 2,741± sq. ft. of thoughtfully designed living space on a generous .55-acre lot. Dramatic walls of glass fill the home with natural light, frame the serene surroundings, and create a seamless connection between indoors and out. The open-concept main living spaces feature engineered hardwood floors and an effortless flow ideal for both everyday living and entertaining. Step from the living area onto the expansive terrace—an inviting extension of the home for al fresco dinners, morning coffee, entertaining friends, or simply unwinding while taking in the peaceful setting. The beautifully updated kitchen connects naturally to the surrounding living spaces, creating a warm and welcoming heart of the home. The flexible floor plan provides excellent separation of space. The lower level features three secondary bedrooms along with a spacious second family room—perfect for a media room, playroom, teen retreat, home office, or additional gathering space. With 5 bedrooms and 4.5 baths, there is room to comfortably accommodate family, guests, work-from-home needs, and changing lifestyles. Outdoors, a level yard area near the upper driveway provides space for play, gardening, or creating your own outdoor retreat. The remainder of the property embraces the natural contours of the .55-acre setting, with mature landscaping and trees contributing to the home's wonderful sense of privacy and tranquility. Ample off-street parking complements the attached 2-car garage. Enjoy the sought-after Sleepy Hollow lifestyle with the popular Sleepy Hollow Swim & Tennis Club within walking distance and Sleepy Hollow Elementary nearby. Downtown Orinda’s shopping and dining, BART, freeway access, and the iconic Orinda Theatre are all just minutes away. Beautifully remodeled, move-in ready, and surrounded by nature—an exceptional opportunity to call one of Orinda’s most desirable neighborhoods home.
Listing Courtesy of bridgeMLS / Listed By: Alex Villasenor, Coldwell Banker

Coldwell Banker - Fremont

© 2026 Coldwell Banker Real Estate LLC

Terms Of Use | Privacy Policy

Accessibility Statement | Fair Housing Notice

© Coldwell Banker 2023 – 2025. All Rights Reserved. Coldwell Banker and the Coldwell Banker logo are trademarks of Coldwell Banker Real Estate LLC. The Coldwell Banker® System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices which are independently owned and operated. The Coldwell Banker System fully supports the principles of the Fair Housing Act and the Equal Opportunity Act.