My Company's Active Listings

$2,999,000 (USD)
Active

Niles Area Single Family Home

Active

375 Hillview Dr Fremont, CA 94536

5 Bed
5 Baths
3609 sqft
MLS# 41112302
Nestled in the historic Niles District of Fremont, 375 Hillview Drive is a custom-built masterpiece that effortlessly blends modern elegance with functionality. Built in 2019, this high-end residence showcases superior craftsmanship and sophisticated design. Spanning multiple levels, this home features two luxurious master suites, including one on the main level. A contemporary aesthetic is highlighted throughout with custom cabinetry, high-end appliances, premium finishes, stylish chandeliers, and an abundance of natural light. At the heart of the home, the open-concept living spaces are designed for both comfort and entertaining, seamlessly flowing to a private backyard. Families can appreciate the Jack and Jill bathrooms connecting additional bedrooms, and ample space for a play area in the loft. A detached ADU provides versatility for guests, executive use, or rental income. Sustainable living is a priority, with solar panels supporting energy efficiency and eco-friendly landscaping throughout. Located in a community known for it's charm, top-rated schools, and tree-covered streets this home offers a rare blend of luxury, location, and lifestyle. Just a quick walk from boutique shops, cafes, parks, and scenic trails, 375 Hillview Dr is your gateway to the best of Fremont.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Mitchell Youhanna
$2,995,000 (USD)
Active

Roundhill Area Single Family Home

Active

27 Squire Ct Alamo, CA 94507

4 Bed
4 Baths
3114 sqft
MLS# 41111012
Thoughtfully updated throughout, this exceptional single-level home enjoys a premier setting on the 12th hole of Roundhill Country Club, surrounded by mature trees w/ direct golf course access. This remarkable residence features 4 bedrooms, 3.5 bathrooms, formal living & dining rooms + an open-concept kitchen & inviting family room w/ a wet bar. The gourmet kitchen is a chef’s dream, showcasing a spacious center island, 6-burner gas range w/ hood, abundant cabinetry, a wine fridge, and a skylight that floods the space with natural light. French doors extend the living space outdoors, creating a seamless indoor-outdoor flow. The luxurious primary suite offers a spa-like retreat with Calacatta marble bath, heated floors, dual vanities, a soaking tub, a walk-in closet, & designer lighting. Additional property highlights include a welcoming front porch, 2 fireplaces, rich hardwood floors, crown moldings, a 3-car garage with ample storage, and a thoughtfully updated common bath w/ direct outdoor access. This private gated property is complete with a resort style backyard, private irrigation well for landscaping and a brand new pool built in 2021 complete w/ a spa & waterfall. All set in a coveted Roundhill location near parks, Mt. Diablo, freeway access & award-winning SRV schools.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Khrista Jarvis