Featured Properties

Some or all of the listings below are provided by the Fremont office.
$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
$1,899,900 (USD)
Pending

Twin Creek Views Area Single Family Home

Pending

2481 Palmira Pl San Ramon, CA 94583

4 Bed
3 Baths
2760 sqft
MLS# 41135248
Nestled in the exclusive Twin Creek View community, this beautiful home blends timeless elegance with modern comfort. Rich Brazilian hardwood floors flow throughout the first floor and continue up the staircase, complemented by Milgard windows that fill the home with natural light. Designed for both entertaining and everyday living, the home features a formal living room and a separate dining room perfect for holiday gatherings and special occasions. The gourmet kitchen is a chef’s dream, showcasing a Wolf range, cherry cabinetry, granite countertops, a Fisher & Paykel dishwasher, and a wine refrigerator. Adjacent to the kitchen, the inviting family room offers a cozy gas fireplace and a stylish Minka ceiling fan. A versatile downstairs bonus room provides endless possibilities — ideal as a home office, game room, craft room, or even a fifth bedroom. Upstairs, the spacious primary suite features abundant closet space, while the luxurious primary bath includes dual sinks and a jetted shower for a spa-like retreat. Step outside to a backyard filled with opportunity. This expansive blank slate includes multiple fruit trees, side access for a boat or RV, a storage shed, and ample room to add an ADU. Completing the property is an oversized three-car garage with an additional rear storage room, offering exceptional space for hobbies, storage, or workshop needs.
Listing Courtesy of bridgeMLS / Listed By: Anthony Bruno, Coldwell Banker Realty