Active Listings

Some or all of the listings below are provided by the Fremont - Intero Franchise office.
$3,999,000
Active

Sycamore Heights Area Single Family Home

Active

1037 Sunset Creek Ln Pleasanton, CA 94566

6 Bed
6 Baths
4974 sqft
MLS# 41088540
Stunning 5-bedroom+bonus room and 5.5 baths in a prime location offering breathtaking million-dollar views! This modern floor plan boasts gleaming hardwood floors, travertine accents, and a gourmet kitchen with granite countertops, a center island, and a professional gas range and ovens. The elegant living room features a cast fireplace, while the spacious dining room, sunlit breakfast nook, and expansive family room with a cozy fireplace create the perfect atmosphere for both relaxation and entertaining. The luxurious master suite includes a private retreat area, a spa-like bath with a soaking tub, a separate shower, dual vanities, and a custom walk-in closet with built-in shelving and organizers. A welcoming guest suite with a full bath is conveniently located downstairs, along with a versatile bonus room with a private bath—ideal as a potential sixth bedroom. Upstairs, two large bedrooms share a Jack & Jill bath with access to a covered balcony, while an additional bedroom and hall bath complete the layout. The expansive backyard is an entertainer’s paradise, featuring a gorgeous pool with a waterfall and spa, a spacious patio, a sports court, a fire pit, a lush lawn, and multiple trees—all set against the stunning backdrop of Pleasanton Ridge and the rolling hills.
Listing Courtesy of bridgeMLS / Intero Real Estate Services / Kaajal Shahani
$3,799,000
Active

Oakland Hills Area Single Family Home

Active

13331 Campus Dr Oakland, CA 94619

5 Bed
5 Baths
6544 sqft
MLS# 41089432
Virtual Tour
Perched in the prestigious Ridgemont enclave, this exquisite estate offers 5 bedroom plus an office and 4.5 elegantly designed bathrooms on a private 0.59-acre lot. Here, breathtaking sunsets and panoramic views of San Francisco, the Golden Gate, and the Bay create an unmatched living experience. Step through a gated courtyard into a home bathed in natural light, where elegance meets effortless living.Designed for both comfort and grandeur, the home features multiple patios and balconies, embracing the Bay Area’s coveted indoor-outdoor lifestyle. A dramatic 20-foot window frames Leona Canyon, seamlessly integrating nature’s tranquility into your living space. The spacious living and dining areas showcase jaw-dropping views, while the gourmet kitchen—with a large island and premium amenities—offers sightlines to serene outdoor scenery. On the lower level, a wine cellar and entertainment space open to a balcony with the estate’s grandest views, complete with a stylish bar for elevated hosting. This coveted location provides effortless access to San Francisco, Silicon Valley, Montclair, Rockridge, Lake Merritt, College Avenue, and Berkeley’s vibrant shopping, dining, and cultural destinations. Definitely a rare offering in one of Oakland Hills’ most sought-after communities.
Listing Courtesy of bridgeMLS / Intero Real Estate Services / Kaajal Shahani