Lee Ann Kreps559.664.7100leeannk@londonproperties.comEmail Agent
Property Description
This exceptional property with beautiful, move in ready home, is perfectly set up for horses, 4-H, or FFA projects, offering a turnkey livestock and equestrian environment. Enjoy two covered paddocks. The arena is complete with a covered judging booth ideal for training or showing, or youth project work. The finished drive-through barn provides endless possibilities. Tack room, convenient storage container with an additional pole barn provides even more room for equipment. Adding incredible value, a John Deere Gator and John Deere 790 tractor are included in the sale, making this the ultimate ready-to-go rural lifestyle property.Shown by appointment only to prequalified buyers.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2003
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$409
Price Per Acre
$170,898
Days On Market
0
Cumulative Days On Market
0
County
Madera
Special Features
Security System, Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Hwy 145 & Road 38
Directions
Highway 145, south on Road 38, west on Verde. Property will be on the north side of the road.
Style
Ranch
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Detached Structures
Barn
Kitchen
F/S Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Refrigerator
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Shower
Extra Rooms
Office
Flooring
Carpet, Hardwood
# of Fireplaces
1
Exterior
Wood, Vinyl
Pool
No
Pool
No
Yard
Drip System
Gas & Electric
Propane
Sewer / Water
Private Well
Energy Efficiency
Dual Pane Windows
Solar
No
Parking Features
Carport
Garage Type
Attached
Garage Spaces
2
Carport Spaces
3
APN
051 660 019 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
Seller Will Consider
Government, Conventional, Cash
72875
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 831250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 918750 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) >= 1887 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2387 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` = 1674617 OR `props-main`.`id` = 1695987 OR `props-main`.`id` = 1687374 OR `props-main`.`id` = 1693466 OR `props-main`.`id` = 1687295 OR `props-main`.`id` = 1692551 OR `props-main`.`id` = 1656886 OR `props-main`.`id` = 1696085 OR `props-main`.`id` = 1668912 OR `props-main`.`id` = 1696809 OR `props-main`.`id` = 1650126 OR `props-main`.`id` = 1687691 OR `props-main`.`id` = 1693171 OR `props-main`.`id` = 1683754)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno640729' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-12-15' 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 Lee Ann Kreps, London Properties/Madera - leeannk@londonproperties.com Last modified 1 week ago Fresno MLS last checked for updates 19 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.
