Listing Agent: Billye Hughes, Land Company Real Estate
SHOWS EXCEPTIONAL PRIDE OF OWNERSHIP INSIDE AND OUT!! THIS IMPECABBABLY CARED FOR 3 BEDROOM 2 BATH HOME REFLECTS YEARS OF PRICE AND ATTENTION TO DETAIL. Step through the double doors with custom screen security doors into a bright and very spacious living room and a stunning sun-filled kitchen designed for both style and function. The kitchen is bright, open and beautifully updated with quartz counters, stainless steel appliances, with a large island with seating plus dining area surrounded by windows that fill space with natural light. A spacious primary suite with jetted tub and separate shower, two vanities and two walk-in closets. Other highlights include an office/den. Step outside to an amazing landscaped backyard with built-in bbq area, hook-ups for a spa(spa may be included) covered patio and storage.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2003
Year Built Source
Public Records
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
front
Price Per Square Foot
$215
Days On London
148
Cumulative Days On London
148
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
use gps
Room Type
All Bedrooms Down, Living Room, Primary Suite, Den
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Door Features
Double Door Entry
Main Level Bedrooms
3
Bathrooms Full
2
Bathrooms Full And Three Quarter
2
Main Level Bathrooms
2
Interior Features
Pantry, Storage
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Gas
Pool Features
None
Pool Private Y/N
No
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Landscaped, Front Yard, Sprinkler System
Lot Size Area
9148.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Neighborhood
Sprinklers Y/N
Yes
Fencing
Wood, Good Condition
Common Interest
Planned Development
Parcel Number
014090040
Additional Parcels Y/N
No
Community Features
Curbs, Golf, Fishing, Street Lights, Sidewalks
Association Amenities
Pool, Spa/Hot Tub
Senior Community Y/N
No
Association Y/N
Yes
Association Name
Greenhills
Association Management Name
Regency
Association Fee
219.00
Association Fee Frequency
Monthly
High School District
Chowchilla Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
40
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 523950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2068 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2568 AND ((`props-main`.`PropertyType` = 'Residential' AND (
`props-main`.`PropertySubtype1` = '1 House on Lot' OR `props-main`.`PropertySubtype2` = '1 House on Lot' OR `props-main`.`PropertySubtype3` = '1 House on Lot' OR
`props-main`.`PropertySubtype1` = 'Cabin' OR `props-main`.`PropertySubtype2` = 'Cabin' OR `props-main`.`PropertySubtype3` = 'Cabin' OR
`props-main`.`PropertySubtype1` = 'House on Lot' OR `props-main`.`PropertySubtype2` = 'House on Lot' OR `props-main`.`PropertySubtype3` = 'House on Lot' OR
`props-main`.`PropertySubtype1` = 'Own Your Own' OR `props-main`.`PropertySubtype2` = 'Own Your Own' OR `props-main`.`PropertySubtype3` = 'Own Your Own' OR
`props-main`.`PropertySubtype1` = 'Rural Residence' OR `props-main`.`PropertySubtype2` = 'Rural Residence' OR `props-main`.`PropertySubtype3` = 'Rural Residence' OR
`props-main`.`PropertySubtype1` = 'Rural/Residence' OR `props-main`.`PropertySubtype2` = 'Rural/Residence' OR `props-main`.`PropertySubtype3` = 'Rural/Residence' OR
`props-main`.`PropertySubtype1` LIKE '%fam%' OR `props-main`.`PropertySubtype2` LIKE '%fam%' OR `props-main`.`PropertySubtype3` LIKE '%fam%'))) AND ((`props-main`.`id` = 1718739 OR `props-main`.`id` = 1714977 OR `props-main`.`id` = 1714941 OR `props-main`.`id` = 1714947 OR `props-main`.`id` = 1680816 OR `props-main`.`id` = 1716962 OR `props-main`.`id` = 1702898 OR `props-main`.`id` = 1702827 OR `props-main`.`id` = 1702880 OR `props-main`.`id` = 1716236 OR `props-main`.`id` = 1716219 OR `props-main`.`id` = 1716224 OR `props-main`.`id` = 1704177 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1712855 OR `props-main`.`id` = 1712876 OR `props-main`.`id` = 1712879 OR `props-main`.`id` = 1706809 OR `props-main`.`id` = 1718336 OR `props-main`.`id` = 1718428 OR `props-main`.`id` = 1711273 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1714700 OR `props-main`.`id` = 1661812 OR `props-main`.`id` = 1682128 OR `props-main`.`id` = 1682125 OR `props-main`.`id` = 1714339 OR `props-main`.`id` = 1709896 OR `props-main`.`id` = 1700186 OR `props-main`.`id` = 1715459 OR `props-main`.`id` = 1687858 OR `props-main`.`id` = 1646822 OR `props-main`.`id` = 1646820 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1714248 OR `props-main`.`id` = 1646776 OR `props-main`.`id` = 1710045 OR `props-main`.`id` = 1691873 OR `props-main`.`id` = 1710027 OR `props-main`.`id` = 1704531 OR `props-main`.`id` = 1717674 OR `props-main`.`id` = 1687929 OR `props-main`.`id` = 1701332 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1714574 OR `props-main`.`id` = 1711099 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1714260 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706732 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1674120 OR `props-main`.`id` = 1715647 OR `props-main`.`id` = 1715622 OR `props-main`.`id` = 1715633 OR `props-main`.`id` = 1654660 OR `props-main`.`id` = 1692518 OR `props-main`.`id` = 1712555 OR `props-main`.`id` = 1717826 OR `props-main`.`id` = 1717855 OR `props-main`.`id` = 1716710 OR `props-main`.`id` = 1716877 OR `props-main`.`id` = 1683307 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1715744 OR `props-main`.`id` = 1654830 OR `props-main`.`id` = 1655024 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1711514 OR `props-main`.`id` = 1717343 OR `props-main`.`id` = 1718358 OR `props-main`.`id` = 1718314 OR `props-main`.`id` = 1718318 OR `props-main`.`id` = 1718231 OR `props-main`.`id` = 1683258 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1705307 OR `props-main`.`id` = 1716921)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25252565' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-01' OR `props-main`.`ExpiredDate` IS NULL OR TRIM(`props-main`.`ExpiredDate`) = '') AND `props-main`.`Status` != 'Unapproved' AND (`props-main`.`DupeOf` IS NULL OR TRIM(`props-main`.`DupeOf`) = '') AND `props-main`.`Delayed` = 0 GROUP BY `props-main`.`id` ORDER BY RAND();
0
The data relating to real estate for sale on this web site comes in part from the Internet Data eXchange (IDX) of the Multiple Listing Service. Real estate listings are marked with the IDX logo and detailed information about them includes the name of the listing broker and the name of the listing agent. The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Information herein deemed reliable but not guaranteed, representations are approximate, individual verification recommended.
