
$2,222,888
2,287
SQ FT
$972
SQ/FT
37880 Farwell
@ Keystone Dr - Glenmoor, Fremont
- 4 Bed
- 3 Bath
- 2 Park
- 2,287 sqft
- Fremont
-
Welcome to your dream home in the highly sought-after Glenmoor neighborhood! Freshly updated with new paint and stylish new flooring throughout, this spacious residence offers modern comfort and convenience at every turn. The sun-drenched interiors are enhanced by skylights in the hallways, guest bathroom, and primary bath, creating a bright and inviting atmosphere. Entertain with ease in the open-concept kitchen featuring double wall convection ovens, in-wall speakers, and a walk-in pantry, while the living room and primary suite also boast built-in speakers for an immersive audio experience. Two generous bedrooms include own baths, making this home perfect for multi-generational living or hosting guests. Enjoy energy efficiency with owned solar panels, a whole-house fan, and ceiling fans in every bedroom. The extra-deep two-car garage offers possible tandem parking, and the inside laundry room is equipped for both gas and electric dryers, plus a convenient laundry chute from the primary closet. Located just one block from John Matos Science Magnet Elementary, and close to BART and ACE stations, shopping, Silicon Valley, and freeway access, this home truly has it all. Don’t miss your chance to own this exceptional Glenmoor gem!
- Current Status
- New
- Original Price
- $2,222,888
- List Price
- $2,222,888
- On Market Date
- Jun 25, 2025
- Property Type
- Detached
- D/N/S
- Glenmoor
- Zip Code
- 94536
- MLS ID
- 41102660
- APN
- 50181532
- Year Built
- 1958
- Stories in Building
- 1
- Possession
- Immediate
- Data Source
- MAXEBRDI
- Origin MLS System
- CONTRA COSTA
John G. Mattos Elementary School
Public K-6 Elementary
Students: 607 Distance: 0.1mi
Stellar Academy For Dyslexics
Private 2-8 Special Education, Elementary, Coed
Students: 25 Distance: 0.5mi
Birch Grove Intermediate
Public 3-6 Elementary
Students: 475 Distance: 0.6mi
Glenmoor Elementary School
Public K-6 Elementary
Students: 663 Distance: 0.7mi
Birch Grove Primary
Public K-6 Elementary
Students: 400 Distance: 0.7mi
Family Learning Center
Private 1-12 Coed
Students: NA Distance: 0.7mi
- Bed
- 4
- Bath
- 3
- Parking
- 2
- Attached, Garage Door Opener
- SQ FT
- 2,287
- SQ FT Source
- Public Records
- Lot SQ FT
- 8,284.0
- Lot Acres
- 0.19 Acres
- Pool Info
- None
- Kitchen
- Solar Hot Water, Dishwasher, Double Oven, Electric Range, Gas Range, Microwave, Free-Standing Range, Refrigerator, Self Cleaning Oven, Washer, 220 Volt Outlet, Breakfast Bar, Breakfast Nook, Counter - Solid Surface, Electric Range/Cooktop, Disposal, Gas Range/Cooktop, Kitchen Island, Pantry, Range/Oven Free Standing, Self-Cleaning Oven, Skylight(s)
- Cooling
- Ceiling Fan(s), Central Air
- Disclosures
- Disclosure Package Avail
- Entry Level
- Exterior Details
- Back Yard, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic
- Flooring
- Hardwood, Laminate
- Foundation
- Fire Place
- Living Room
- Heating
- Forced Air
- Laundry
- 220 Volt Outlet, Dryer, Gas Dryer Hookup, Laundry Room, Washer, Electric
- Main Level
- Main Entry
- Possession
- Immediate
- Architectural Style
- Ranch
- Construction Status
- Existing
- Additional Miscellaneous Features
- Back Yard, Front Yard, Garden/Play, Side Yard, Sprinklers Automatic
- Location
- Corner Lot
- Roof
- Composition Shingles
- Water and Sewer
- Public, Water District
- Fee
- $432
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.