My Company's Active Listings

$2,998,000
Pending

Canyon Heights Area Single Family Home

Pending

190 Pickering Ave Fremont, CA 94536

6 Bed
7 Baths
5281 sqft
MLS# 41098613
Virtual Tour
Stunning residence built in 2006 with hundreds of thousands of dollars of custom upgrades! Tucked away in a quiet court with private access, in a peaceful Millwood neighborhood with gorgeous hill views. This magnificent home of approx. 5,281 sq ft boasts 5 or 6 bedrooms, 6.5 bathrooms plus a 2 bedroom 1 bathroom guest house (not included in the sq ft). A beautiful marble flooring entryway opens to the formal living and dining rooms. The gourmet kitchen includes commercial grade Jenair gas stove, double oven, microwave and a double drawer dishwasher, maple wood cabinetry and beautiful custom island. One bedroom and 1 full bathroom conveniently located downstairs. Upstairs, there are 4 bedrooms with 4 elegant bathrooms. Also upstairs, a spacious library and a separate media room or a 6th bedroom. Other fine features include exquisite marble flooring throughout downstairs, marble finishes in all bathrooms, custom crown molding and baseboards, recessed light throughout, elegant dual staircase with Brazilian cherrywood flooring and custom wrought iron railing, dual zone HVAC system and 4-car garage offers 3 EV charger connections. Solar is owned. Conveniently located near BART station, 84/Dumbarton Bridge & 880 (via Niles Canyon) for easy commute to San Francisco and Silicon Valley.
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Joe Schembri
$2,998,000
Active

Redwood City Area Detached Single Family

Active

331 Idyllwild Court Redwood City, CA 94061

5 Bed
3 Baths
2600 sqft
MLS# ML82011890
Virtual Tour
Welcome to Idyllwild Court! Nestled at the end of a peaceful cul-de-sac in Redwood City's coveted Horgan Ranch neighborhood, this beautifully maintained 5-bedroom, 3-bath home blends comfort, space, and natural serenity. Boasting approximately 2,600 sq. ft. of thoughtfully designed living space on a generous approximately 9,175 sq. ft. park-like lot, it offers an ideal setting for both everyday living and effortless entertaining. Inside, gorgeous hardwood floors flow throughout, complementing the flexible layout designed to meet the needs of modern living. Four spacious bedrooms are located upstairs including a grand primary suite with vaulted ceilings while the fifth bedroom and bath on the first floor provide the perfect space for guests or a home office. The main level showcases expansive living and dining areas, highlighted by vaulted ceilings along with a bright open kitchen that flows into the inviting family room and provides easy access to the serene backyard. Exit outside and enjoy your own private oasis: a beautifully landscaped yard with mature trees, lush greenery, open lawn space, and a large deck ideal for relaxing, hosting, or simply soaking in the peaceful surroundings. This Horgan Ranch gem offers the perfect balance of space, style, and tranquil living.
Listing Courtesy of MLSlistings Inc. / Coldwell Banker Realty / Mark Tauber