Featured Properties

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

Warm Springs Area Single Family Home

Pending

48074 Chann Ct Fremont, CA 94539

5 Bed
3 Baths
1821 sqft
MLS# 41136475
Virtual Tour
Location, location, location! Welcome to this beautifully updated Warm Springs home tucked away on a quiet court and backing to Booster Park with lovely views of the Mission Hills. This spacious residence offers two master suites, one upstairs and one downstairs. The main level offers 3 bedrooms and 2 full bathrooms, including the second primary suite upstairs, with a full bathroom and sitting room, offering flexibility for families, guests, or a home office. The versatile floor plan is designed for comfortable living and entertaining. The inviting living room flows into the dining area featuring a cozy fireplace and sliding glass door opening to the backyard patio. The updated kitchen boasts granite countertops, custom wood cabinetry, and a sunny breakfast nook. Additional upgrades include refinished hardwood flooring throughout, fresh interior and exterior paint, newly installed LED recessed lighting, dual pane windows, new interior doors with modern black hardware, updated switches, outlet covers, and GFCI outlets, updated bathrooms, central air conditioning, freshly painted garage walls and floor, and a brand-new composition shingle roof for peace of mind. Step outside to enjoy the spacious backyard featuring a large custom paver patio, generous play area, and an adorable custom playhouse, perfect for making lasting memories. Located in a highly sought-after neighborhood served by top-rated public schools, this home also offers beautiful hill views, proximity to shopping and dining, and easy access to BART, Highways 880 and 680, and major Silicon Valley companies.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$3,988,000 (USD)
Pending

Vineyards Area Single Family Home

Pending

925 Curtner Rd Fremont, CA 94539

5 Bed
5 Baths
4037 sqft
MLS# 41135552
Welcome to an estate of undeniable prestige in one of Fremont's most coveted Weibel neighborhoods. This masterfully designed Mediterranean style residence was built by John Clawson, a custom home builder known for construction of high-end custom homes & estates. Perched on a premium 20,070 sq ft lot with beautiful hill views this property offers the privacy of a true sanctuary. The double entry door opens to a grand foyer with chandelier and an elegant staircase. The grand living room with soaring ceilings and an elegant fireplace flows into a formal dining room with recessed ceiling and chandelier. A generous family room with fireplace offers direct access to the spacious backyard and large patio. A private mother-in-law suite with private entrance and en-suite full bathroom adds rare flexibility for multigenerational living or guest accommodations. A versatile downstairs den offers the perfect bonus space to work from home. At the heart of the home, the chef's kitchen boasts custom Maple wood cabinetry, granite slab countertops, a center island, breakfast room with Bay window, and a walk-in pantry. The upper floor features 4 bedrooms, 3 of which have en-suite bathrooms. The serene primary suite features a private view balcony, a fireplace and a large walk-in closet. The en-suite bathroom boasts marble shower, counters and flooring. Thoughtful details elevate every corner: rich hardwood flooring throughout, oversized dual-pane picture windows that flood the home with natural light, 3 elegant fireplaces, 2 internal staircases, all bathrooms with marble flooring and showers, dual-zone HVAC, a large laundry room, fresh exterior paint, tile roof, and a 3-car finished garage. Step outside to a private oasis: a generous backyard with a large patio and a diverse collection of fruit trees, offering a tranquil escape just steps from your door and plenty of space for an ADU with views. The property is secured by an artisan stacked-stone wall for privacy. Located within the highly sought-after Weibel top-tier schools attendance boundary and minutes from I-680/880, this exceptional residence delivers both top-tier schooling and effortless access to Silicon Valley.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty