Property Details
About this Property
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.
Your path to home ownership starts here. Let us help you calculate your monthly costs.
Back to Calculator 
MLS Listing Information
MLS #
BE41098613
MLS Source
Bay East
Interior Features
Bathrooms
Marble, Primary - Shower(s) over Tub(s), Primary - Tub w/ Jets
Kitchen
Countertop - Stone, Eat In Kitchen, Hookups - Ice Maker, Island, Pantry
Appliances
Dishwasher, Garbage Disposal, Microwave, Oven - Built-In, Oven - Double, Oven - Self Cleaning, Oven Range - Built-In, Oven Range - Gas, Refrigerator, Trash Compactor
Dining Room
Dining Area, Formal Dining Room
Family Room
Separate Family Room
Fireplace
Living Room
Flooring
Hardwood, Laminate, Stone
Laundry
220 Volt Outlet, In Laundry Room
Cooling
Central -1 Zone
Heating
Heating - 2+ Zones
Exterior Features
Roof
Tile
Foundation
Crawl Space
Pool
None, Pool - No
Style
Contemporary
Parking, School, and Other Information
Garage/Parking
Access - Side Yard, Attached Garage, Garage, Gate/Door Opener, Garage: 4 Car(s)
Elementary District
Fremont Unified
High School District
Fremont Unified
Sewer
Public Sewer
Water
Public
Contact Information
Listing Agent
Joe Schembri
Coldwell Banker Realty
License #: 00890599
Phone: (510) 608-7667
Co-Listing Agent
Joe Suryan
Coldwell Banker Realty
License #: 01098757
Phone: (510) 750-3447
School Ratings
Nearby Schools
| Schools | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Vallejo Mill Elementary School | public | TK,KG,1,2,3,4,5 | 0.32 mi | |
| California School For The Blind | public | KG,1,2,3,4,5,6,7,8,9,10,11,12,AE | 0.66 mi | N/A |
| California School For The Deaf-Fremont | public | K-12 | 0.74 mi | N/A |
| Niles Elementary School | public | TK,KG,1,2,3,4,5 | 1.19 mi | |
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 1.24 mi | |
| John Gomes Elementary School | public | TK,KG,1,2,3,4,5 | 1.63 mi | |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 2.01 mi | |
| William Hopkins Middle School | public | 6-8 | 2.09 mi | |
| Washington High School | public | 9-12 | 2.11 mi | |
| Centerville Middle School | public | 6-8 | 2.22 mi | |
| Joshua Chadbourne Elementary School | public | TK,KG,1,2,3,4,5 | 2.30 mi | |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 2.42 mi | |
| Glankler Early Learning Center | public | KG | 2.48 mi | N/A |
| Mission San Jose High School | public | 9-12 | 2.50 mi | |
| Mission Valley Elementary School | public | K-5 | 2.58 mi | |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 2.58 mi | |
| G. M. Walters Middle School | public | 6-8 | 2.61 mi | |
| Young Adult Program | public | 9-12 | 2.71 mi | N/A |
| Fremont Adult | public | UG | 2.73 mi | N/A |
| Brookvale Elementary School | public | TK,KG,1,2,3,4,5 | 2.80 mi |
Neighborhood: Around This Home
Neighborhood: Local Demographics
Market Trends Charts
Nearby Homes for Sale
190 Pickering Ave is a Single Family Residence in Fremont, CA 94536. This 5,281 square foot property sits on a 0.43 Acres Lot and features 6 bedrooms & 6 full and 1 partial bathrooms. It is currently priced at $2,998,000 and was built in 2006. This address can also be written as 190 Pickering Ave, Fremont, CA 94536.
©2025 Bay East. All rights reserved. All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Information provided is for personal, non-commercial use by the viewer and may not be redistributed without explicit authorization from Bay East.
Presently MLSListings.com displays Active, Contingent, Pending, and Recently Sold listings. Recently Sold listings are properties which were sold within the last three years. After that period listings are no longer displayed in MLSListings.com. Pending listings are properties under contract and no longer available for sale. Contingent listings are properties where there is an accepted offer, and seller may be seeking back-up offers. Active listings are available for sale.
This listing information is up-to-date as of June 04, 2025. For the most current information, please contact Joe Schembri, (510) 608-7667
