Featured Properties

Some or all of the listings below are provided by the Fremont office.
$2,998,000
Active

Canyon Heights Area Single Family Home

Active

190 Pickering Ave Fremont, CA 94536

6 Bed
7 Baths
5608 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. 5600 sq ft boasts 5 or 6 bedrooms, 6.5 bathrooms plus a 2 bedroom 1 bathroom ADU (not included in the square footage). 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
$1,251,000
Active

City Of Concord Area Single Family Home

Active

1841 Gilardy Dr Concord, CA 94518

5 Bed
3 Baths
2102 sqft
MLS# 41096975
Virtual Tour
Welcome to stunning, thoughtfully recently renovated like BRAND NEW HOME*EZ access to 680 and est.3 miles from BART, Walnut Creek border, in the most desirable neighborhood*This gem sits on a generous 12,675 sqft lot*A two-story layout features 5 bedrooms and 3 full bathrooms*2 cozy primary suites-one on each floor-perfect for multi-generational living*3 bedrooms & 2 baths on ground level*Enjoy living-dining combo*Gourmet kitchen is a chef’s dream with abundant cabinetry, quartz countertops, custom backsplash, stainless steel appliances, & a skylight*Inviting family room boasts a fireplace, built-in shelving, breakfast area & wine cellar all overlooking the expansive backyard*Throughout the home dual pane windows, hardwood flooring, recessed lighting, crown molding, and large baseboards, adding to the elegant aesthetic*New roof, lush front lawn & a sprinkler system enhance curb appeal*Step outside into a private, oversized backyard is full of potential: add a pool, ADU, basketball court or create your dream outdoor oasis*Close to John Muir Hospital, Heather Farm Park, Boundary Oak Golf Course, Arbolado Park, Six Flags Hurricane Harbor, Ruth Bancroft Garden & Pixieland Amusement Park*Truly a rare opportunity to own a turnkey home in a prime location! OH 2 to 4 pm on 5/31 & 6/1
Listing Courtesy of bridgeMLS / Coldwell Banker Realty / Charo Bhatt