HUD Home! Adorable and move in ready attached home located in gated community of Greenhills in Chowchilla. Kitchen features granite counters, lots of cabinets and tile flooring. Laminate wood throughout living spaces. Main living room is open with tall ceilings, lots of large windows and built in shelving. Three spacious bedrooms and three full bathrooms. Low maintenance front and back / exterior yards. Property is gated and has a HOA, which includes maintenance of common areas and pool! Come take a look at this beautiful home in Chowchilla, CA to see if its right for you!
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
2006
Year Built Source
Assessor
Special Listing Conditions
HUD Owned
Stories Total
2
Levels
Two
Number Of Units Total
1
Entry Level
1
Entry Location
street
Price Per Square Foot
$192
Days On London
23
Cumulative Days On London
23
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
Yes
Cooling Y/N
Yes
Fence Y/N
Yes
Heating Y/N
Yes
Directions
Avenue 26 to Clubhouse Dr to gated entrance to property
Disclosures
CC And R's, Homeowners Association
Room Type
All Bedrooms Up
Heating
Central
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Inside
Roof
Tile
Construction Materials
Frame, Stucco
Main Level Bedrooms
0
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Main Level Bathrooms
1
Room Kitchen Features
Granite Counters
Eating Area
Dining Room
Appliances Y/N
Yes
Appliances
Dishwasher, Disposal, Gas Range, Microwave
Room Bathroom Features
Shower in Tub
Interior Features
Cathedral Ceiling(s)
Flooring
Carpet, Laminate, Tile
Common Walls
1 Common Wall
Fireplace Y/N
Yes
Fireplace Features
Living Room, Gas
Pool Features
Association, Community
Pool Private Y/N
No
Patio Y/N
Yes
Patio And Porch Features
Rear Porch
Electric
220 Volts in Laundry
Utilities
Electricity Connected, Natural Gas Connected, Sewer Connected, Water Connected
Water Source
Public
Sewer
Public Sewer
Parking Total
2.00
Attached Garage Y/N
Yes
Garage Spaces
2.00
Lot Features
Front Yard
Lot Size Area
3850.0000
Lot Size Units
Square Feet
Road Surface Type
Privately Maintained
View Y/N
No
View
None
Fencing
Stucco Wall
Common Interest
Condominium
Parcel Number
014200010
Additional Parcels Y/N
No
Community Features
Golf, Sidewalks, Street Lights, Suburban
Association Amenities
Pool, Gym/Ex Room, Maintenance Grounds, Management, Controlled Access
Senior Community Y/N
No
Association Y/N
Yes
Association Name
Villa
Association Management Name
Unity Property Management
Association Fee
303.00
Association Fee Frequency
Monthly
High School District
Chowchilla Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
10
Tax Tract Number
03-06
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 354350 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 391650 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1692 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2192 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` = 1702898 OR `props-main`.`id` = 1702827 OR `props-main`.`id` = 1702880 OR `props-main`.`id` = 1704177 OR `props-main`.`id` = 1686267 OR `props-main`.`id` = 1686245 OR `props-main`.`id` = 1706809 OR `props-main`.`id` = 1711273 OR `props-main`.`id` = 1705655 OR `props-main`.`id` = 1705641 OR `props-main`.`id` = 1710975 OR `props-main`.`id` = 1675030 OR `props-main`.`id` = 1661812 OR `props-main`.`id` = 1709896 OR `props-main`.`id` = 1709744 OR `props-main`.`id` = 1687217 OR `props-main`.`id` = 1710205 OR `props-main`.`id` = 1710203 OR `props-main`.`id` = 1687858 OR `props-main`.`id` = 1691708 OR `props-main`.`id` = 1646822 OR `props-main`.`id` = 1646820 OR `props-main`.`id` = 263786 OR `props-main`.`id` = 1662063 OR `props-main`.`id` = 1710478 OR `props-main`.`id` = 1646776 OR `props-main`.`id` = 1710045 OR `props-main`.`id` = 1691873 OR `props-main`.`id` = 1710027 OR `props-main`.`id` = 1709211 OR `props-main`.`id` = 1696088 OR `props-main`.`id` = 1701332 OR `props-main`.`id` = 1701327 OR `props-main`.`id` = 1710843 OR `props-main`.`id` = 1711104 OR `props-main`.`id` = 1711098 OR `props-main`.`id` = 1711099 OR `props-main`.`id` = 1654611 OR `props-main`.`id` = 1666277 OR `props-main`.`id` = 1666536 OR `props-main`.`id` = 1710491 OR `props-main`.`id` = 1678287 OR `props-main`.`id` = 1706732 OR `props-main`.`id` = 1685347 OR `props-main`.`id` = 1706817 OR `props-main`.`id` = 1706981 OR `props-main`.`id` = 1674120 OR `props-main`.`id` = 1700156 OR `props-main`.`id` = 1654660 OR `props-main`.`id` = 1692518 OR `props-main`.`id` = 1701828 OR `props-main`.`id` = 1705326 OR `props-main`.`id` = 1683307 OR `props-main`.`id` = 1682135 OR `props-main`.`id` = 1694405 OR `props-main`.`id` = 1694527 OR `props-main`.`id` = 1707237 OR `props-main`.`id` = 1707242 OR `props-main`.`id` = 1654830 OR `props-main`.`id` = 1655024 OR `props-main`.`id` = 893173 OR `props-main`.`id` = 1683258 OR `props-main`.`id` = 1659633 OR `props-main`.`id` = 1705307 OR `props-main`.`id` = 1702108 OR `props-main`.`id` = 1702253)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26023409' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-02-24' 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.
