Listing Agent: Stacy Tennesen, Century 21 Select Real Estate
OWNED SOLAR! Beautifully maintained custom home on over 5 private acres! Approximately 3,000 sq ft featuring 4 bedrooms, 3.5 baths, updated flooring, and spacious living areas. Enjoy peacful country living with a 4-car garage and plenty of room for animals, hobbies, or entertaining.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1991
Year Built Source
Seller
Special Listing Conditions
Standard
Stories Total
1
Levels
One
Number Of Units Total
1
Entry Level
1
Entry Location
front
Price Per Square Foot
$260
Days On London
115
Cumulative Days On London
115
County Or Parish
Madera
New Construction Y/N
No
Property Attached Y/N
No
Cooling Y/N
Yes
Directions
from the highway 99 South, take the Chowchilla Robt Blvd exit. Turn right and go through town. turn left on Ave 23 1/2 the home will be on the right hand side right after the dip in the road.
Room Type
All Bedrooms Down
Cooling
Central Air
Laundry Y/N
Yes
Laundry Features
Individual Room
Main Level Bedrooms
4
Bathrooms Full
3
Bathrooms Full And Three Quarter
3
Bathrooms Half
1
Main Level Bathrooms
3
Common Walls
No Common Walls
Fireplace Y/N
Yes
Fireplace Features
Family Room
Pool Features
None
Pool Private Y/N
No
Water Source
Well
Sewer
Private Sewer
Parking Total
4.00
Attached Garage Y/N
Yes
Garage Spaces
4.00
Lot Features
2-5 Units/Acre
Lot Size Area
234788.0000
Lot Size Units
Square Feet
View Y/N
Yes
View
Orchard
Common Interest
None
Parcel Number
026280069
Additional Parcels Y/N
No
Community Features
Rural
Senior Community Y/N
No
Association Y/N
No
High School District
Chowchilla Union
Lease Considered Y/N
No
Land Lease Y/N
No
Assessments
Unknown
Tax Lot
13
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 740999.05 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 818998.95 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '4' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2750 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3250 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` = 1747713 OR `props-main`.`id` = 1747731 OR `props-main`.`id` = 1747742 OR `props-main`.`id` = 1758798 OR `props-main`.`id` = 1758771 OR `props-main`.`id` = 1758774 OR `props-main`.`id` = 1767778 OR `props-main`.`id` = 1767780 OR `props-main`.`id` = 1767764 OR `props-main`.`id` = 1758886 OR `props-main`.`id` = 1759040 OR `props-main`.`id` = 1758868 OR `props-main`.`id` = 1754757 OR `props-main`.`id` = 1726956 OR `props-main`.`id` = 1726992 OR `props-main`.`id` = 1730887 OR `props-main`.`id` = 1730994 OR `props-main`.`id` = 1755307 OR `props-main`.`id` = 1755801 OR `props-main`.`id` = 1716355 OR `props-main`.`id` = 1757466 OR `props-main`.`id` = 1757638 OR `props-main`.`id` = 1755263 OR `props-main`.`id` = 1755706 OR `props-main`.`id` = 1755763 OR `props-main`.`id` = 1755770 OR `props-main`.`id` = 1755798 OR `props-main`.`id` = 1755802 OR `props-main`.`id` = 1052956 OR `props-main`.`id` = 1765379 OR `props-main`.`id` = 1765377 OR `props-main`.`id` = 1768975 OR `props-main`.`id` = 1764278 OR `props-main`.`id` = 1746003)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC26091808' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-31' 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.
