Lots of potential for this 4 bedrooms 2 bath home on 2.27 Acres of flat land with newer well and huge water storage tank. Fruit trees galore and lots of beautiful mature trees. Different variety of fragrance roses. Open elegant living with separate cozy family room next to a good size dining area and functional kitchen with a 5 burner stainless steel range. Designer's rolling wrought iron gate, opens to a long driveway, and, there is extra parking for guest. Desirable everlasting tile roof. Energy efficient dual pane windows. Custom made BBQ grill in the patio area. Lots of vegetables and herbs including Bay leaves, Rosemarie, Aloe Vera and Cactus. Easy maintenance laminated flooring. Large covered patio. Extra structures for chickens and goats. Easy FW 41 and 99 Access. In an area with some nice custom homes. Only 30 minutes drive to Fresno. Must see!
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1999
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$291
Price Per Acre
$237,392
Days On London
0
Cumulative Days On London
0
County
Madera
Special Features
Water Softener
REO / Bank Owned
No
Cross Street Address
Rd 37/Ave 17
Directions
Hwy 41N to Ave 15. Left on Ave 15. Right on Road 37. Left on Ave 16 1/2. Right on Karen.
Heating & Cooling
Central Heating, Central Cooling
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Eating Area, Pantry
Primary Bedroom Level
Main
Bath Features
Tub/Shower
Extra Rooms
Great Room
Flooring
Laminate, Tile
Exterior
Stucco
Pool
No
Pool
No
Spa
No
Patio Features
Covered, Concrete
Yard
Fruit/Nut Trees
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
No
Are there garage spaces?
Yes
Garage Type
Attached
Garage Spaces
2
Site Amenities
Pasture
APN
051 282 005 000
School District
Golden Valley
School Type 1
High School
School Name 1
Liberty
School Type 2
Junior High School
School Name 2
Ranchos
School Type 3
Grade School
School Name 3
Sierra View
1st Loan Type
Free & Clear
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 511936 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 565824 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1600 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2100 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` = 1696184 OR `props-main`.`id` = 1696187 OR `props-main`.`id` = 1717866 OR `props-main`.`id` = 1702214 OR `props-main`.`id` = 1702048 OR `props-main`.`id` = 1721592 OR `props-main`.`id` = 1713815 OR `props-main`.`id` = 1723502 OR `props-main`.`id` = 1719674 OR `props-main`.`id` = 1723659 OR `props-main`.`id` = 1702433 OR `props-main`.`id` = 1720821 OR `props-main`.`id` = 1696085 OR `props-main`.`id` = 1714344 OR `props-main`.`id` = 1709952 OR `props-main`.`id` = 1668912 OR `props-main`.`id` = 1719407 OR `props-main`.`id` = 1719420 OR `props-main`.`id` = 1696809 OR `props-main`.`id` = 1719145 OR `props-main`.`id` = 1714985 OR `props-main`.`id` = 1687691 OR `props-main`.`id` = 1683754)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647683' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-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
Courtesy of Joanne Oh, Century 21 Jordan-Link & Company - [email protected] Last modified 1 hour ago Fresno MLS last checked for updates 15 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.
