$1,999,900
2,130
SQ FT
$939
SQ/FT
5238 Brophy Dr
@ Farwell Dr - Glenmoor, Fremont
- 3 Bed
- 2 Bath
- 2 Park
- 2,130 sqft
- Fremont
-
Nestled in the highly desirable Glenmoor neighborhood, this gorgeous single-story home offers an ideal floor plan with premium upgrades inside and out. The beautifully updated kitchen showcases custom cabinets, granite counter tops, large skylight, dining area with bar seating and stainless steel appliances including a gas stove. Just off the kitchen, the extended living space features a formal dining area and a spacious family room that features a cozy gas fireplace - creating an ideal setting for large gatherings. You’re sure to love the thoughtful upgrades throughout including tastefully updated bathrooms, dual pane windows, recessed lighting, quality laminate flooring and copper plumbing. The luxurious primary suite showcases a private bath with a dual sink cultured marble vanity and cultured marble shower, walk-in closet and direct access to the serene backyard. The outdoor space is ideal for relaxing or hosting with a lush lawn and covered stamped concrete patio. This home is in an excellent location walking distance to great schools, parks, shopping & local eateries. Perfect for commuters, nearby 880, 680, Dumbarton Bridge, BART & Centerville Station Move-in ready, this Glenmoor gem is not to be missed!
- Current Status
- New
- Original Price
- $1,999,900
- List Price
- $1,999,900
- On Market Date
- Apr 9, 2026
- Property Type
- Detached
- D/N/S
- Glenmoor
- Zip Code
- 94536
- MLS ID
- 41130375
- APN
- 531557
- Year Built
- 1964
- Stories in Building
- 1
- Possession
- Close Of Escrow
- Data Source
- MAXEBRDI
- Origin MLS System
- BAY EAST
Stellar Academy For Dyslexics
Private 2-8 Special Education, Elementary, Coed
Students: 25 Distance: 0.5mi
John G. Mattos Elementary School
Public K-6 Elementary
Students: 607 Distance: 0.5mi
Joseph Azevada Elementary School
Public K-6 Elementary
Students: 650 Distance: 0.5mi
Circle of Independent Learning School
Charter K-12 Combined Elementary And Secondary, Home School Program
Students: 368 Distance: 0.6mi
Young Adult Program
Public 9-12
Students: 41 Distance: 0.6mi
Fremont Adult
Public n/a Adult Education
Students: NA Distance: 0.7mi
- Bed
- 3
- Bath
- 2
- Parking
- 2
- Attached
- SQ FT
- 2,130
- SQ FT Source
- Appraisal
- Lot SQ FT
- 7,280.0
- Lot Acres
- 0.17 Acres
- Pool Info
- None
- Kitchen
- Gas Range, Microwave, Oven, Refrigerator, Gas Water Heater, Breakfast Bar, Gas Range/Cooktop, Oven Built-in
- Cooling
- Ceiling Fan(s)
- Disclosures
- None
- Entry Level
- Exterior Details
- Back Yard, Front Yard
- Flooring
- Laminate, Tile
- Foundation
- Fire Place
- Family Room
- Heating
- Forced Air
- Laundry
- In Garage
- Main Level
- 3 Bedrooms, 2 Baths, Primary Bedrm Suite - 1, Main Entry
- Possession
- Close Of Escrow
- Architectural Style
- Ranch
- Non-Master Bathroom Includes
- Shower Over Tub
- Construction Status
- Existing
- Additional Miscellaneous Features
- Back Yard, Front Yard
- Location
- Rectangular Lot
- Roof
- Tile
- Water and Sewer
- Public
- Fee
- $44
MLS and other Information regarding properties for sale as shown in Theo have been obtained from various sources such as sellers, public records, agents and other third parties. This information may relate to the condition of the property, permitted or unpermitted uses, zoning, square footage, lot size/acreage or other matters affecting value or desirability. Unless otherwise indicated in writing, neither brokers, agents nor Theo have verified, or will verify, such information. If any such information is important to buyer in determining whether to buy, the price to pay or intended use of the property, buyer is urged to conduct their own investigation with qualified professionals, satisfy themselves with respect to that information, and to rely solely on the results of that investigation.
School data provided by GreatSchools. School service boundaries are intended to be used as reference only. To verify enrollment eligibility for a property, contact the school directly.

