$2,389,950
2,006
SQ FT
$1,191
SQ/FT
38048 Palmer Dr
@ Mattos Dr - Glenmoor, Fremont
- 4 Bed
- 2.5 (2/1) Bath
- 2 Park
- 2,006 sqft
- Fremont
-
-
Sat Mar 28, 2:00 pm - 5:00 pm
FROM THE CURB THROUGHOUT! 4 Bedroom, 2.5 Bathroom. An ideal Glenmoor home, touched everywhere. Large, sunny open-concept Kitchen with glowing morning sunlight. Double-Ovens, stone-finish counters, and pantry. Family Room opens to oversized, paver-finished patio, and ideal entertaining area. High-End, beautifully upgraded Bathrooms. Benefits: plantation shutters thru-out, solid surface flooring, central air conditioning, finished Garage, astroturf-type lawn in rear yard, rear access for off-street RV parking. Walking distance to Washington High School and Centerville Middle School. **OPEN HOUSES: Sat. 3/28 (2pm-5pm) and Sun. 3/29 (1pm-4pm).**
-
Sun Mar 29, 1:00 pm - 4:00 pm
FROM THE CURB THROUGHOUT! 4 Bedroom, 2.5 Bathroom. An ideal Glenmoor home, touched everywhere. Large, sunny open-concept Kitchen with glowing morning sunlight. Double-Ovens, stone-finish counters, and pantry. Family Room opens to oversized, paver-finished patio, and ideal entertaining area. High-End, beautifully upgraded Bathrooms. Benefits: plantation shutters thru-out, solid surface flooring, central air conditioning, finished Garage, astroturf-type lawn in rear yard, rear access for off-street RV parking. Walking distance to Washington High School and Centerville Middle School. **OPEN HOUSES: Sat. 3/28 (2pm-5pm) and Sun. 3/29 (1pm-4pm).**
FROM THE CURB THROUGHOUT! 4 Bedroom, 2.5 Bathroom. An ideal Glenmoor home, touched everywhere. Large, sunny open-concept Kitchen with glowing morning sunlight. Double-Ovens, stone-finish counters, and pantry. Family Room opens to oversized, paver-finished patio, and ideal entertaining area. High-End, beautifully upgraded Bathrooms. Benefits: plantation shutters thru-out, solid surface flooring, central air conditioning, finished Garage, astroturf-type lawn in rear yard, rear access for off-street RV parking. Walking distance to Washington High School and Centerville Middle School. **OPEN HOUSES: Sat. 3/28 (2pm-5pm) and Sun. 3/29 (1pm-4pm).**
- Current Status
- New
- Original Price
- $2,389,950
- List Price
- $2,389,950
- On Market Date
- Mar 24, 2026
- Property Type
- Detached
- D/N/S
- Glenmoor
- Zip Code
- 94536
- MLS ID
- 41128365
- APN
- 5017418
- Year Built
- 1955
- Stories in Building
- 1
- Possession
- Close Of Escrow
- Data Source
- MAXEBRDI
- Origin MLS System
- BAY EAST
Centerville Junior High
Public 7-8 Middle
Students: 972 Distance: 0.3mi
Prince Of Peace Lutheran School
Private K-8 Elementary, Religious, Coed
Students: 452 Distance: 0.3mi
Washington High School
Public 9-12 Secondary
Students: 1918 Distance: 0.4mi
Stratford School
Private K
Students: 87 Distance: 0.4mi
Glenmoor Elementary School
Public K-6 Elementary
Students: 663 Distance: 0.4mi
Holy Spirit Elementary School
Private K-8 Elementary, Religious, Coed
Students: 272 Distance: 0.4mi
- Bed
- 4
- Bath
- 2.5 (2/1)
- Parking
- 2
- Attached, Garage, Int Access From Garage, Side Yard Access, Enclosed, Garage Faces Side, Garage Door Opener, RV Access/Parking, RV Storage
- SQ FT
- 2,006
- SQ FT Source
- Public Records
- Lot SQ FT
- 9,929.0
- Lot Acres
- 0.23 Acres
- Pool Info
- Membership (Optional), Community
- Kitchen
- Dishwasher, Double Oven, Electric Range, Oven, Refrigerator, Dryer, Washer, Gas Water Heater, Stone Counters, Eat-in Kitchen, Electric Range/Cooktop, Disposal, Oven Built-in, Pantry, Updated Kitchen, Other
- Cooling
- Central Air
- Disclosures
- Nat Hazard Disclosure, Disclosure Package Avail
- Entry Level
- Exterior Details
- Back Yard, Dog Run, Front Yard, Side Yard, Storage, Entry Gate, Landscape Back, Landscape Front, Storage Area, Yard Space
- Flooring
- Hardwood, Tile, Vinyl
- Foundation
- Fire Place
- Brick, Family Room, Gas, Living Room, Wood Burning
- Heating
- Forced Air, Fireplace(s)
- Laundry
- Dryer, Washer, Inside, See Remarks
- Main Level
- 4 Bedrooms, 2.5 Baths, Primary Bedrm Suite - 1, Laundry Facility, Main Entry
- Possession
- Close Of Escrow
- Basement
- Crawl Space
- Architectural Style
- Ranch
- Non-Master Bathroom Includes
- Solid Surface, Stall Shower, Tile, Updated Baths, Window
- Construction Status
- Existing
- Additional Miscellaneous Features
- Back Yard, Dog Run, Front Yard, Side Yard, Storage, Entry Gate, Landscape Back, Landscape Front, Storage Area, Yard Space
- Location
- Corner Lot, Premium Lot, Back Yard, Front Yard
- Pets
- Yes
- 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.

