190 Pickering Ave, Fremont, CA 94536

← Back to search

Pending

$2,998,000

bedrooms

bathrooms

square feet

Acreage

0.43

Open Houses

year built

2006

Full Baths

Half Baths

Find out more

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.

Location
Subdivision	-
County	Alameda County
Elementary School	-
Middle School	-
High School	-

Driving directions

Open houses

None scheduled.

Find out more

Tell us who you are, and we will have someone reach out to you.

Name*

Email*

Phone*

Message

I have a house to sell

By proceeding, you consent to receive calls, texts and voicemails at the number you provided (may be recorded and may be autodialed and use pre-recorded and artificial voices), and email, from Kotohomes, Mercury News, Joseph Schembri, and their network of service providers about your inquiry and other home-related matters.

Msg/data rates may apply. This consent applies even if you are on a do not call list and is not a condition of any purchase.

MLS number: 41098613

Listing agent: Joseph Schembri

Listing broker: Coldwell Banker Realty (510) 608-7600

Last update: Saturday, June 7 2025 at 12:46 a.m. EDT

realogy mercurynews