Home | Alameda County | Fremont | 94536 | 38042 Miller Pl
MLS: BE41136232 | Status: Active | Price: $1,398,000
Beds/Baths: 3 / 2
Property Type: Residential
| Beds | Baths | Sq Ft | Sq Ft Lot | Yr Built |
|---|---|---|---|---|
| 3 | 2 | 1,389 | 4,089 | 1973 |
| Date | Time | Hosted By |
|---|---|---|
| Saturday, June 6 | 1:00 pm - 4:00 pm | Daryll Canlas |
| Sunday, June 7 | 1:00 pm - 4:00 pm | Daryll Canlas |
Welcome to this beautifully renovated Fremont home with completed permits, thoughtfully remodeled and designed for modern California living. Located on a quiet cul-de-sac in one of Fremont’s most desirable neighborhoods, this move-in ready residence offers convenient access to top rated schools, major commuter routes, freeway access, shopping, dining, and outdoor recreation. Extensively upgraded throughout, the home features a brand new roof, brand new HVAC system, updated plumbing and electrical, new windows, fully remodeled kitchen and bathrooms, recessed lighting, smooth wall finishes, new flooring, fresh interior and exterior paint, and beautifully refreshed landscaping. The modern kitchen showcases brand new cabinetry, countertops, backsplash, appliances, and fixtures, while both bathrooms have been tastefully renovated with new vanities, tile work, fixtures, and shower/tub upgrades. The spacious outdoor areas include a newly built courtyard deck, new pavers and much more creating the perfect setting for entertaining or relaxing at home. You will absolutely fall in love with this beautiifully remodeled home!
| Field | Value |
|---|---|
| MLS # | BE41136232 |
| MLS Source | Bay East |
| Days on Site | 5 |
| Feature | Details |
|---|---|
| Kitchen | Updated |
| Appliances | Dishwasher, Garbage Disposal, Microwave, Oven Range, Oven Range - Gas, Refrigerator |
| Dining Room | Dining Area |
| Fireplace | Living Room |
| Flooring | Laminate, Tile |
| Laundry | Hookups Only |
| Cooling | Central -1 Zone |
| Feature | Details |
|---|---|
| Pool | None, Pool - No |
| Style | Contemporary |
| Feature | Details |
|---|---|
| Garage/Parking | Attached Garage, Garage, Garage: 2 Car(s) |
Daryll Canlas
The Canlas Brothers, Inc
License #: 01748689
Phone: (415) 529-8883
School data provided by GreatSchools.org
| School | Type | Grades | Distance | Rating |
|---|---|---|---|---|
| Parkmont Elementary School | public | TK,KG,1,2,3,4,5 | 0.37 mi | 9 |
| Washington High School | public | 9-12 | 0.60 mi | 9 |
| Centerville Middle School | public | 6-8 | 0.60 mi | 8 |
| Tom Maloney Elementary School | public | TK,KG,1,2,3,4,5 | 1.08 mi | 7 |
| Niles Elementary School | public | TK,KG,1,2,3,4,5 | 1.12 mi | 9 |
| Glenmoor Elementary School | public | K-5 | 1.34 mi | 8 |
| California School For The Blind | public | K-12 | 1.40 mi | N/A |
| American High School | public | 9-12 | 1.42 mi | 10 |
| Thornton Middle School | public | 6-8 | 1.44 mi | 9 |
| Brookvale Elementary School | public | TK,KG,1,2,3,4,5 | 1.44 mi | 7 |
| Brier Elementary School | public | TK,KG,1,2,3,4,5 | 1.44 mi | 5 |
| Oliveira Elementary School | public | TK,KG,1,2,3,4,5 | 1.45 mi | 8 |
| Glankler Early Learning Center | public | KG | 1.48 mi | N/A |
| California School For The Deaf-Fremont | public | K-12 | 1.52 mi | N/A |
| Fremont Adult | public | UG | 1.58 mi | N/A |
| Young Adult Program | public | 9-12 | 1.59 mi | N/A |
| G. M. Walters Middle School | public | 6-8 | 1.69 mi | 8 |
| J. Haley Durham Elementary School | public | TK,KG,1,2,3,4,5 | 1.85 mi | 9 |
| John G. Mattos Elementary School | public | K-5 | 1.87 mi | 8 |
| Vallejo Mill Elementary School | public | TK,KG,1,2,3,4,5 | 1.89 mi | 6 |
| Address | Price | Beds | Baths | Sq Ft | Status |
|---|---|---|---|---|---|
| 4252 Argonaut Ct | $1,498,000 | 3 | 2 | 1,370 | PendingDoNotShow |
| 38419 Acacia St | $1,598,000 | 4 | 2/1 | 1,884 | Active |
| 5157 Waller Ave | $1,599,888 | 3 | 2 | 1,384 | Active |
| 40152 Margery Ct | $1,450,000 | 3 | 2 | 1,547 | Active |
©2026 Bay East. 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 Bay East.
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 June 02, 2026. For the most current information, please contact Daryll Canlas, (415) 529-8883.