
$1,750,000
1,927
SQ FT
$908
SQ/FT
37792 Colfax Court
@ Keystone - Glenmoor Gardens, Fremont
- 3 Bed
- 2 Bath
- 2 Park
- 1,927 sqft
- Fremont
-
Take a stroll through this home that offers you so much in the way of comfort, space and modern appeal. The home features a family room with a room set apart that can be a 4th bedroom or an office. A living room. A dining room. 3 bedrooms and 2 updated bathrooms with tile shower enclosures and tile floors and new vanities and lights. A kitchen that boast granite counters, antique white maple cabinets with soft close, tile backsplash, ss appliances, gas range, 2 ovens, built in microwave, under cabinet lights. Laminate and tile floors throughout. Enormous resort style backyard with a large Trex deck, spacious turf play area w/eco-friendly drainage system, hot tub, covered patio, fruit trees and a huge enclosed storage area. Perfect for playing, entertaining or just relaxing. Dual pane windows with a 12’ patio door. Court location. Great schools. Mattos Elem., Walters Middle, Kennedy HS. OH 10/25 and 10/26 1-4.
- Current Status
- Active - Coming Soon
- Original Price
- $1,750,000
- List Price
- $1,750,000
- On Market Date
- Oct 12, 2025
- Property Type
- Detached
- D/N/S
- Glenmoor Gardens
- Zip Code
- 94536
- MLS ID
- 41114554
- APN
- 50181427
- Year Built
- 1954
- Stories in Building
- 1
- Possession
- Close Of Escrow
- Data Source
- MAXEBRDI
- Origin MLS System
- BAY EAST
John G. Mattos Elementary School
Public K-6 Elementary
Students: 607 Distance: 0.2mi
Glenmoor Elementary School
Public K-6 Elementary
Students: 663 Distance: 0.5mi
Family Learning Center
Private 1-12 Coed
Students: NA Distance: 0.6mi
Stellar Academy For Dyslexics
Private 2-8 Special Education, Elementary, Coed
Students: 25 Distance: 0.6mi
Learn and Play Montessori School
Private PK-2 Preschool Early Childhood Center, Montessori, Elementary, Coed
Students: 8 Distance: 0.7mi
Fremont Christian School
Private PK-12 Combined Elementary And Secondary, Religious, Coed
Students: 620 Distance: 0.7mi
- Bed
- 3
- Bath
- 2
- Parking
- 2
- Int Access From Garage, Off Street, Enclosed, Garage Door Opener
- SQ FT
- 1,927
- SQ FT Source
- Public Records
- Lot SQ FT
- 7,200.0
- Lot Acres
- 0.17 Acres
- Pool Info
- Membership (Optional)
- Kitchen
- Dishwasher, Double Oven, Gas Range, Plumbed For Ice Maker, Microwave, Free-Standing Range, Refrigerator, Self Cleaning Oven, Dryer, Washer, Gas Water Heater, 220 Volt Outlet, Stone Counters, Eat-in Kitchen, Disposal, Gas Range/Cooktop, Ice Maker Hookup, Range/Oven Free Standing, Self-Cleaning Oven, Updated Kitchen
- Cooling
- None
- Disclosures
- Nat Hazard Disclosure
- Entry Level
- Exterior Details
- Back Yard, Dog Run, Front Yard, Sprinklers Automatic
- Flooring
- Laminate, Tile
- Foundation
- Fire Place
- Family Room, Wood Burning
- Heating
- Forced Air
- Laundry
- Gas Dryer Hookup, In Garage, Washer
- Main Level
- 3 Bedrooms, 2 Baths, Laundry Facility, Main Entry
- Views
- Hills
- Possession
- Close Of Escrow
- Basement
- Crawl Space
- Architectural Style
- Ranch
- Non-Master Bathroom Includes
- Shower Over Tub, Tile, Updated Baths
- Construction Status
- Existing
- Additional Miscellaneous Features
- Back Yard, Dog Run, Front Yard, Sprinklers Automatic
- Location
- Court, Front Yard
- Roof
- Composition Shingles
- Water and Sewer
- Public
- 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.