My Company's Active Listings

$2,788,000 (USD)
Pending

Stonebrae Country Club Area Single Family Home

Pending

128 Dunfirth Ct Hayward, CA 94542

5 Bed
5 Baths
4678 sqft
MLS# 41129475
Virtual Tour
Exquisite home in prestigious Stonebrae Golf Club community, one of the most idyllic East Bay locations with spectacular views from San Francisco to South Bay. This luxury residence offers 5 bedrooms plus office, bonus room and 4.5 bathrooms, including a primary suite downstairs. The home boasts coffered ceilings, crown molding, and wainscoting. The formal dining room provides the ideal space for memorable dinners, while the open-concept kitchen and family room are ideal for gatherings. The gourmet kitchen is equipped with high-end appliances, a walk-in pantry, and a center island. A fully collapsible sliding door connects the kitchen to the outdoor California room with fireplace and STUNNING BAY VIEWS. Upstairs, the expansive master suite offers a private balcony that provides breathtaking vistas and features an expansive walk-in closet, dual vanities, oversized tub, and a sit-down vanity area. Additional highlights include hardwood flooring, upgraded sound system in the great room, and laundry room with cabinets and a sink. The private backyard offers a covered patio with built-in BBQ, stamped concrete walkway, a putting green & a bocce court. The guarded community has 24-hour security and optional country club memberships with access to a gym, golf, tennis courts and pool.
Listing Courtesy of bridgeMLS / Listed By: Joe Schembri, Coldwell Banker Realty
$2,788,000 (USD)
Active

San Jose Area Detached Single Family

Active

1424 Rosecrest Terrace San Jose, CA 95126

4 Bed
4 Baths
2636 sqft
MLS# ML82046962
Welcome to 1424 Rosecrest Terrace in the coveted Rose Garden - Built meticulously by Summerhill home. Enter through the custom stain glass door to the impressive formal entryway with a stunning staircase and soaring ceilings. An abundance of sunlit windows provides morning sun in the kitchen/family room and afternoon sun in the front rooms of the house. Light hardwood floors in the downstairs with parquet accents and recently installed carpets upstairs. Downstairs bedroom with one full bath plus a powder room. Kitchen refresh with recently installed quartz counters, a garden window, freshly painted cabinets, and a gas stove top. Open layout connects the kitchen and breakfast nook to the family room. Sizable primary suite with a retreat area,, gas fireplace, walk-in closet, and a spa-like bathroom . Backyard with a paver patio and an expansive grass area.. Immerse yourself in the coveted neighborhood, with amenities within blocks, including Rose Garden Park, the library, Zanottos, schools, Bills Caf, and more. Conveniently located for commuters, enjoy easy access to Highways 880, 280, and 87, as well as proximity to Cupertino, Santa Clara, downtown, trains/light rail transit, and the airport. Additionally, indulge in premier shopping/dining at Valley Fair and Santana Row,
Listed by MLSlistings Inc. / Listed By: Derrick Oh, Coldwell Banker Realty
$2,788,000 (USD)
Active

San Mateo Area Detached Single Family

Active

510 Aragon Boulevard San Mateo, CA 94402

4 Bed
3 Baths
2410 sqft
MLS# ML82047327
Virtual Tour
First time on the market in over 60 years! With its timeless curb appeal and lush fern canopy at the inviting gate entry, this 2410 SF sunlit home offers buyers an amazing opportunity. Formal entry welcomes one into a dramatic living room with warm hardwood floors, a striking picture window & a wood-burning fireplace. The home features a spacious kitchen with stainless-steel appliances, a cozy breakfast nook with access to the rear yard, and a lovely formal dining room. Upstairs, there are four generous bedrooms, two full baths, a flexible work-or-play area, and a convenient laundry chute. The lower level includes an ideal private home office, a bath, and a laundry area, with additional access to the rear yard. It also features a two-car attached garage and a large 6,599 SF lot with a fenced backyard. Charming 1940s details include crown molding, high ceilings, beautifully refinished hardwood floors, plus a 200-AMP electrical panel (2024), modern light fixtures & fresh paint throughout. (May/26) This wonderful home offers an excellent opportunity to renovate, expand, or keep the footprint as is. Situated in the highly sought-after Aragon community near award-winning schools, shopping, major commute corridors, and local parks, 510 Aragon will be a special place to call home.
Listed by MLSlistings Inc. / Listed By: Miriam Chirko, Coldwell Banker Realty