My Office's Listings

Some or all of the listings below are provided by the Fremont office.
$2,788,000 (USD)
Active

Stonebrae Country Club Area Single Family Home

Active

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 / Coldwell Banker Realty / Joe Schembri
$2,488,000 (USD)
Active

Quail Run Area Single Family Home

Active

33646 Whimbrel Rd Fremont, CA 94555

4 Bed
3 Baths
2598 sqft
MLS# 41129714
Virtual Tour
Welcome to this beautiful Shapell home in the sought-after Quail Run Community! This prestigious neighborhood is known for its peaceful setting and resort-style amenities - a swimming pool, tennis courts, clubhouse, and playground. Located within top-rated school districts—American High School, Thornton Middle, Warwick Elementary. It offers 4 beds and 3 baths, including a convenient downstairs bedroom and full bath. With 2598 sq ft of living space, 8250 sq ft lot, sits on a quiet street. The thoughtfully designed floor plan features formal living and dining rooms at the front. Toward the back, the modern kitchen, breakfast nook, and family room flow seamlessly together, providing an ideal space for everyday living and entertaining, with access to the backyard. Upstairs, the spacious primary suite offers a retreat area with a cozy fireplace, soaring ceilings, and a private balcony. The luxurious primary bathroom includes dual vanities, dual closets, and a separate shower. Step outside to a generous backyard complete with a patio deck—perfect for entertaining, gardening, and enjoying fruit-bearing trees. Conveniently located near dining, shopping, local parks, BART, major freeways, and corporate shuttles, this home truly offers comfort, convenience, and an exceptional lifestyle.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Aimee Ran Song
$1,975,900 (USD)
Active

Twin Creek Views Area Single Family Home

Active

2481 Palmira Pl San Ramon, CA 94583

4 Bed
3 Baths
2760 sqft
MLS# 41130264
Welcome to 2481 Palmira Place in the exclusive Twin Creek View neighborhood. This beautifully maintained and updated home offers over 2760 ft of livable space on a 14,500+ foot lot. The owner spared no expense on the upgrades. The home features Brazilian hardwood floors throughout the first floor and the stair case, Milgard windows and an Andersen sliding door The formal living room and dining room are perfect for the holiday gatherings, the dining room has a lit coffered ceiling. The kitchen is all set for the chef to create masterful meals, featuring a Wolfe range, cherry cabinets, granite counters, a Fisher/Paykel dishwasher, and a wine refrigerator. The family room offers a gas fireplace and a Minka fan. There is a bonus room downstairs that could possibly be converted to a game room, office, craft room or a 5th bedroom! Head upstairs to the primary suite and 3 bedrooms. The primary bedroom has loads of closet space. The primary bath has been updated with dual sinks and a jetted shower. The front yard is neatly manicured. The backyard, which has many fruit trees, side access for a boat or RV, a storage shed and still space for an ADU, is awaiting your finishing touches. Oversized 3 car garage with a back storage room. Open house Sat 4/11 and Sun 4/12 from 1-4pm.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Anthony Bruno