- 4 beds
- 3 baths
- 3,010 sqft
- 13,068 sqft lot
- $182 per sqft
- 2005 build
- – on site
Welcome to this impeccably maintained 4 bedroom, 3 bathroom home offering 3010 square feet of living space in a quiet gated community. Among the many features, you have one bedroom and one full bathroom on the first level. This one-owner home has been beautifully cared for over the past 20 years and is in pristine, move-in ready condition. The thoughtfully designed floor plan provides plenty of room for everyday living and entertaining. Step outside to a large backyard with lots of possibilities and mature fruit trees. Pride of ownership shines throughout this rare gem--don't miss your chance to call it home.
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Jun 30, 2025
•
MLS# 225081977 —
This home is listed in more than one place. See it here, and here.
Upcoming Open Houses
-
Sunday, 7/6
12pm-2pm
The Building
-
Year Built:2005
-
Year Built Source:Other
-
Remodeled Updated:Unknown
-
Construction Materials:Stucco
-
Construction Materials:#Collection(String)
-
Building Features:#Collection(String)
-
Architectural Style:Contemporary
-
Architectural Style:#Collection(String)
-
Development Status:#Collection(String)
-
Structure Type:#Collection(String)
-
Subtype Description:#Collection(String)
-
Roof:Tile
-
Roof:#Collection(String)
-
Foundation Details:Concrete
-
Foundation Details:#Collection(String)
-
Stories:2
-
Levels:#Collection(String)
-
Upper Level:#Collection(String)
-
Main Level:#Collection(String)
-
Lower Level:#Collection(String)
-
Basement:#Collection(String)
-
Exterior Features:#Collection(String)
-
Window Features:#Collection(String)
-
Patio And Porch Features:#Collection(String)
-
Accessibility Features:#Collection(String)
Interior
-
Interior Features:#Collection(String)
-
Kitchen Features:Granite Counter, Island
-
Flooring:Carpet, Laminate
-
Flooring:#Collection(String)
-
Upper Level:Master Bedroom
-
Main Level:Family Room
-
Dining Room Features:Formal Area
-
Living Room Features:Cathedral/Vaulted
-
Fireplaces Total:1
-
Fireplace Features:Family Room
-
Fireplace Features:#Collection(String)
-
Laundry Features:Inside Room
-
Laundry Features:#Collection(String)
Room Dimensions
-
Living Area:3010.0
-
Living Area Source:Not Verified
Financial & Terms
-
Lease Type:Net
-
Lease Type:#Collection(String)
-
Lease Info:#Collection(String)
-
Lease Includes:#Collection(String)
-
Rent Includes:#Collection(String)
-
Tenant Pays:#Collection(String)
-
Owner Pays:#Collection(String)
-
Pets Allowed:#Collection(String)
Location
-
Directions:From the highway 99S, take the Chowchilla Robertson Blvd exit, turn left, take a right hand turn into the West gate Greenhills Estates. Once inside the gate, turn right, turn right on Hampton St and left on Heatherhearst. Home is ahead on the left.
The Property
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Condition:#Collection(String)
-
Parcel Number:014-150-037
-
Current Use:#Collection(String)
-
Possible Use:#Collection(String)
-
Zoning:Residential
-
Lot Features:Auto Sprinkler Front
-
Lot Features:#Collection(String)
-
Lot Size Acres:0.3
-
Lot Size Square Feet:13068.0
-
Lot Size Units:SqFt
-
Lot Size Source:Not Verified
-
Land Lease:false
-
View:#Collection(String)
-
Vegetation:#Collection(String)
-
Irrigation Source:#Collection(String)
-
Fencing:#Collection(String)
-
Horse:false
-
Horse Amenities:#Collection(String)
-
Crops:#Collection(String)
-
Soil:#Collection(String)
-
Land Use:#Collection(String)
-
Irrigation Source:None
-
Frontage Type:#Collection(String)
-
Road Surface Type:#Collection(String)
-
Road Frontage Type:#Collection(String)
-
Road Responsibility:#Collection(String)
-
Driveway Sidewalks:#Collection(String)
Listing Agent
- Contact info:
- No listing contact info available
Beds
-
Bedrooms Total:4
Baths
-
Total Baths:3
-
Full Baths:3
The Listing
-
Home Warranty:false
Heating & Cooling
-
Heating:Central
-
Heating:#Collection(String)
-
Cooling:Central
-
Cooling:#Collection(String)
Utilities
-
Utilities:Public
-
Utilities:#Collection(String)
-
Electric:220 Volts in Laundry
-
Electric:#Collection(String)
-
Sewer:Public Sewer
-
Sewer:#Collection(String)
-
Water Source:Public
-
Water Source:#Collection(String)
-
Green Energy Efficient:#Collection(String)
Appliances
-
Appliances:#Collection(String)
Schools
-
Elementary School District:Other
-
Middle Or Junior School District:Other
-
High School District:Other
The Community
-
Community Features:#Collection(String)
-
Association:true
-
Association Fee:220
-
Association Fee Frequency:Monthly
-
Association Fee Includes:Pool, Security
-
Association Mandatory:Yes
-
Association Amenities:Pool, Clubhouse, Spa/Hot Tub
-
Association Amenities:#Collection(String)
-
Spa:false
-
Spa Features:#Collection(String)
-
Pool Private:false
-
Pool Features:#Collection(String)
-
Senior Community:false
Parking
-
Garage Spaces:3.0
-
Parking Type:#Collection(String)
-
Parking Access:#Collection(String)
-
Parking Features:Garage Facing Front
-
Parking Features:#Collection(String)
Extra Units
-
Unit 1 Type:#Collection(String)
-
Unit 2 Type:#Collection(String)
-
Unit 3 Type:#Collection(String)
-
Unit 4 Type:#Collection(String)
-
Other Units:#Collection(String)
Monthly cost estimate

Asking price
$548,888
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$2,939
|
Taxes | N/A |
Insurance | $150 |
HOA fees | $220 |
Utilities | $238 See report |
Total | $3,547/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/19/25
Jun 19, 2025
|
Listed / Active | METROLIST | $548,888 |