You can renovate a house. You cannot renovate a location. No other property in Fremont offers this level of access at this price. Nestled in the heart of the Parkmont neighborhood, walking distance from Mowry Ave and Paseo Padre, this 4-bedroom, 2-bathroom, 1,647 sq ft home is a commuter's dream. BART nearby, 9 minutes by car to I-880, with Hwy 84 and 238 at your doorstep every corner of the Bay Area within easy reach. Daily essentials are effortless. Whole Foods is a 2-minute drive. Costco and Safeway under 10 minutes. Washington Hospital just 5 minutes away. Lake Elizabeth is an 8-minute drive. Explore a thriving local restaurant scene down the street. Exceptional school access. Parkmont Elementary is steps away, Washington High School just a 3-minute drive, in a district built on academic excellence. The interior is a blank canvas ready for your personal vision and the location is irreplaceable. Priced for motivated buyers and lowest among other listings. Opportunities like this don't come twice.
Pending
$1,399,000
38154 Miller Pl, Fremont, CA 94536
4beds
1,647sqft
Single Family Residence, Residential
Built in 1973
5,329 Square Feet Lot
$1,403,800 Zestimate®
$849/sqft
$-- HOA
What's special
- 39 days |
- 544 |
- 6 |
Zillow last checked:
Listing updated:
Listed by:
Matthew Dapolito 02015668 408-202-9202,
Intero Real Estate Services 510-651-6500
Source: MLSListings Inc,MLS#: ML82048826
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 2
- Full bathrooms: 2
Dining room
- Features: DiningArea
Family room
- Features: SeparateFamilyRoom
Heating
- Central Forced Air
Cooling
- Central Air
Features
- Fireplace features: Gas, Living Room
Interior area
- Total structure area: 1,647
- Total interior livable area: 1,647 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached, Off Street, On Street
- Attached garage spaces: 2
Features
- Stories: 1
- Pool features: Above Ground
Lot
- Size: 5,329 Square Feet
Details
- Parcel number: 5011535081
- Zoning: R-1-X-38.4
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Property subtype: Single Family Residence, Residential
Materials
- Foundation: Crawl Space
- Roof: Composition, Shingle
Condition
- New construction: No
- Year built: 1973
Utilities & green energy
- Gas: PublicUtilities
- Sewer: Public Sewer
- Water: Public
- Utilities for property: Public Utilities, Water Public
Community & HOA
Location
- Region: Fremont
Financial & listing details
- Price per square foot: $849/sqft
- Tax assessed value: $99,052
- Date on market: 5/28/2026
- Listing agreement: ExclusiveRightToSell
Estimated market value
$1,403,800
$1.33M - $1.47M
$4,660/mo
Price history
| Date | Event | Price |
|---|---|---|
| 6/15/2026 | Pending sale | $1,399,000$849/sqft |
Source:  MLSListings Inc #ML82048826 Report a problem | ||
| 5/28/2026 | Listed for sale | $1,399,000$849/sqft |
Source: MLSListings Inc #ML82048826 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $99,052 +2% |
| 2024 | $1,922 +3.8% | $97,109 +2% |
| 2023 | $1,851 +2.9% | $95,206 +2% |
| 2022 | $1,799 +2% | $93,339 +2% |
| 2021 | $1,763 +5.2% | $91,508 +1% |
| 2020 | $1,675 +0.8% | $90,571 +2% |
| 2019 | $1,662 +4.7% | $88,795 +2% |
| 2018 | $1,587 | $87,054 +2% |
| 2017 | $1,587 +2.7% | $85,347 +2% |
| 2016 | $1,546 +4.7% | $83,673 +1.5% |
| 2015 | $1,476 | $82,417 +2% |
| 2014 | $1,476 | $80,803 +0.5% |
| 2013 | -- | $80,438 +2% |
| 2012 | -- | $78,861 +2% |
| 2011 | -- | $77,315 +0.8% |
| 2010 | -- | $76,736 -0.2% |
| 2009 | -- | $76,920 +2% |
| 2008 | -- | $75,411 +2% |
| 2007 | -- | $73,933 +2% |
| 2006 | -- | $72,483 +2% |
| 2005 | -- | $71,062 +2% |
| 2004 | -- | $69,670 +1.9% |
| 2003 | -- | $68,393 +2% |
| 2002 | -- | $67,052 +2% |
| 2001 | $952 | $65,737 |
Find assessor info on the county website
Monthly payment
Est. payment$--/mo
Payment breakdown
Explore the cost of this home by adjusting the details. Changes won't be saved.All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Climate risks
Neighborhood: Parkmont
Nearby schools
GreatSchools rating
- 9/10Parkmont Elementary SchoolGrades: K-5Distance: 0.4 mi
- 8/10Centerville Middle SchoolGrades: 6-8Distance: 0.6 mi
- 9/10Washington High SchoolGrades: 9-12Distance: 0.5 mi
Schools provided by the listing agent
- District: FremontUnified
Source: MLSListings Inc. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
A local agent can set up tours, give advice and negotiate with sellers.
Local buyer's agents are ready to help
- California
- Alameda County
- Fremont
- 94536
- Parkmont
- 38154 Miller Pl
Nearby cities
Nearby neighborhoods
Nearby zip codes
Other Fremont Topics
