This recently renovated house is ready for you! This property offers beautiful views of the Sierra Nevadas along with a spacious 2586 Sq Ft home. The house offers 3 bedrooms, 3 bathrooms, 2 living rooms or potentially a 4th bedroom. The kitchen has been updated, and new flooring. This house also sits on 1.6 acres of land with nearby schools and more.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2001
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$246
Price Per Acre
$396,875
Days On London
0
Cumulative Days On London
0
County
Madera
Leased Equipment
Propane, Solar Panels
Special Features
Security Gate, Built In Cabinets, Central Vac
REO / Bank Owned
No
Cross Street Address
Green Tree
Directions
use google maps. north on lake st or Road 27.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Utility Room
Roofing
Composition
Foundation
Concrete
Kitchen
F/S Range/Oven, Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave
Dining Room Features
Formal
Primary Bedroom Level
Lower
Bath Features
Tub/Shower
Extra Rooms
Family Room, Game Room
Flooring
Carpet, Tile
Exterior
Stucco
Pool
No
Pool
No
Yard
Sprinklers Front
Gas & Electric
Propane
Sewer / Water
Septic Tank, Private Well
Energy Efficiency
Dual Pane Windows, 13+ SEER A/C
Solar
Yes
Solar Type
Power Purchase AGMT
Parking Features
Potential RV Parking, Circular Driveway
Are there garage spaces?
1
Garage Type
Attached
Garage Spaces
3
APN
036 263 010 000
School District
Madera Unified
School Type 1
High School
School Name 1
Matilda
School Type 2
Junior High School
School Name 2
Jack G. Desmond
School Type 3
Grade School
School Name 3
Berenda
Seller Will Consider
Government, Conventional, Cash
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 603250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 666750 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) >= 2336 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2836 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` = 1707164 OR `props-main`.`id` = 1701581 OR `props-main`.`id` = 1704327 OR `props-main`.`id` = 1704123 OR `props-main`.`id` = 1704439 OR `props-main`.`id` = 1695771 OR `props-main`.`id` = 1696064 OR `props-main`.`id` = 1688382 OR `props-main`.`id` = 1679800 OR `props-main`.`id` = 1713224 OR `props-main`.`id` = 1705713 OR `props-main`.`id` = 1705705 OR `props-main`.`id` = 1705806 OR `props-main`.`id` = 1705814 OR `props-main`.`id` = 1702487 OR `props-main`.`id` = 1691000 OR `props-main`.`id` = 1690972 OR `props-main`.`id` = 1710040 OR `props-main`.`id` = 1666451 OR `props-main`.`id` = 1702571 OR `props-main`.`id` = 1709598)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno644740' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-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
Courtesy of Ricardo Hernandez, Pro Mr. Z Realty Madera - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 43 minutes ago
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.
