Listing Agent: Billye Hughes, Land Company Real Estate Listing Co-Agent: Jaymee Chavez, Land Company Real Estate
COUNTRY PROPERTY! THIS IS A WONDERFULLY MAINTAINED HOME CLOSE ENOUGH TO TOWN BUT FAR ENOUGH OUT IN THE COUNTRY!! LARGE 4 BEDROOM 3 BATH 2630 SQ FT HOME ON 7.86 ACRES. THIS GORGEOUS HOME OFFERS THE MOST AMAZING KITCHEN WITH FRAMELESS EURO-STYLE CABINETS, SOLID WOOD COUNTERS, OVERSIZED ISLAND WITH GAS GRILL AND SUBZERO REFRIGERATOR. 4 VERY SPACIOUS BEDROOMS, PRIMARY ENSUITE OFFERS HIS/HER CLOSETS AND HUGE BATHROOM. GUEST BATH HAS BEEN UPDATED WITH SOLID WOOD COUNTER, NEW SINKS WITH FIXTURES AND NEW TILE SHOWER. THERE IS A FAMILY AND LIVING ROOM BOTH WITH FIREPLACES. THERE IS AN OFFICE WITH SEPARATE ENTRANCE WITH BUILT-IN DESKS AND LARGE LAUNDRY ROOM/MUD ROOM. 24X20 BRICK TACK ROOM/STORAGE, STEEL PIPE FENCING WITH COVERED STALLS, RIDING ARENA. NEWER WELL, NEWER HVAC AND 2 TANKLESS WATER HEATERS, OWNED PROPANE TANK AND OWNED SOLAR, 30 PANELS PLUS TWO BATTERIES.
Property Sub Type
Single Family Residence
Structure Type
House
Year Built
1961
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
$340
Days On Market
20
Cumulative Days On Market
20
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
please use gps
Room Type
All Bedrooms Down, Family Room, Formal Entry, Kitchen, Laundry, Living Room, Primary Suite, Office, Separate Family Room
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 850250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 939750 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2380 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2880 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` = 1690698 OR `props-main`.`id` = 1690691 OR `props-main`.`id` = 1680786 OR `props-main`.`id` = 1052956 OR `props-main`.`id` = 1692133 OR `props-main`.`id` = 1689616 OR `props-main`.`id` = 1697845 OR `props-main`.`id` = 1699086 OR `props-main`.`id` = 1685667 OR `props-main`.`id` = 1697932)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'crmlsMC25276040' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-04' 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.
