Home | Alameda County | Fremont | 94536 | 4904 Brophy Dr
MLS: ML81954514 | Status: Sold | Price: $2,100,000
Beds/Baths: 4 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 4 | 2 | 1,689 | 9,173 | 1966 |
Fabulous move-in ready, single-level home on an oversized lot in the highly desired Upper Glenmoor neighborhood. Spacious four bedrooms, 2.5 baths, expanded kitchen,family room, and living room with large Andersen sliding doors inviting you into the backyard oasis. With an abundance of custom upgrades, youre sure to love the quality details throughout including an open-concept chefs kitchen with granite counters, Wolf cooktop, and a modern new refrigerator. Luxuriously elegant bathrooms including master steam shower, refinished hardwood floors throughout, full interior paint, recessed lighting, and skylight. Complete with a newly installed roof, gutters, water heater, updated electrical, plumbing, A/C, dual paned windows, and so much more! A true focal point of this home is the peaceful, picturesque, expansive backyard with decking, sports court, and lush lawn designed to entertain, play, or simply relax! Enjoy Glenmoor community pools, tennis courts, and green parks to stay active in the town ranked happiest city two years in a row! All this, with room to grow, within walking distance to neighborhood schools, shopping, local eateries, and top-rated healthcare facilities. Easy access to 880 and 680 freeways, near 84, Niles Canyon and BART.
| Field | Value |
|---|---|
| MLS # | ML81954514 |
| MLS Source | MLSListings, Inc. |
| Feature | Details |
|---|---|
| Bedrooms | Ground Floor Bedroom |
| Bathrooms | Shower and Tub, Stall Shower, Steam Shower, Tub, Updated Bath(s) |
| Kitchen | Countertop - Granite, Exhaust Fan, Skylight(s) |
| Appliances | Cooktop - Gas, Dishwasher, Exhaust Fan, Garbage Disposal, Hood Over Range, Oven - Built-In, Refrigerator |
| Dining Room | Breakfast Nook, Dining Area in Living Room |
| Family Room | Separate Family Room |
| Fireplace | Family Room, Wood Burning |
| Laundry | Hookup - Gas Dryer, In Garage |
| Cooling | Central Forced Air |
| Heating | Central Forced Air - Gas |
| Feature | Details |
|---|---|
| Roof | Shingle |
| Foundation | Crawl Space |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage: 2 Car(s) |
| Elementary District | Fremont Unified |
| High School District | Fremont Unified |
| Sewer | Public Sewer |
| Water | Public |
| HOA Fee | $30 |
| HOA Fee Frequency | Monthly |
| Zoning | R-1-6(GG) |
Jenny Deng
Maxreal
License #: 01944686
Phone: (408) 807-7419
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Young Adult Program | public | 9-12 | 0.46 mi | N/A |
| Fremont Adult | public | UG | 0.47 mi | N/A |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 0.49 mi | 7 |
| Glenmoor Elementary School | public | K-6 | 0.53 mi | 8 |
| Joseph Azevada Elementary School | public | TK,KG,1,2,3,4,5 | 0.60 mi | 7 |
| John G. Mattos Elementary School | public | K-5 | 0.69 mi | 8 |
| Glankler Early Learning Center | public | KG | 0.76 mi | N/A |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 0.80 mi | 5 |
| G. M. Walters Middle School | public | 6-8 | 0.86 mi | 8 |
| John F. Kennedy High School | public | 9-12 | 0.96 mi | 7 |
| Washington High School | public | 9-12 | 1.01 mi | 9 |
| Mission Valley Rocp School | public | 9-12 | 1.11 mi | N/A |
| Birch Grove Primary | public | KG,1,2 | 1.14 mi | N/A |
| Newark Memorial High School | public | 9-12 | 1.23 mi | 6 |
| Centerville Middle School | public | 6-8 | 1.24 mi | 8 |
| Birch Grove Intermediate | public | 3,4,5 | 1.28 mi | 7 |
| Thornton Middle School | public | 6-8 | 1.52 mi | 9 |
| John Blacow Elementary School | public | TK,KG,1,2,3,4,5 | 1.53 mi | 7 |
| Cabrillo Elementary School | public | K-5 | 1.58 mi | 4 |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 1.78 mi | 9 |
©2026 MLSListings Inc. 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 MLSListings Inc.
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 February 01, 2026. For the most current information, please contact Jenny Deng, (408) 807-7419.