Provide a name for your search and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Search
Please log in or create an account.
Save Property
Provide a name for your property and specify whether or not you'd prefer to receive email updates.
Get Daily Email Updates
Save Property
Please log in or create an account.
The ULTIMATE Guide To Buying Your Home!
Get Your FREE Copy Share a few contact details and we will send you the guide to your inbox.
THANK YOU!
Check your inbox for the Buyer's Guide.
Get More Info
Please provide the following information and one of our customer service representatives will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.londonproperties.com/property/link/fresno/652061/29531-Morgan-Canyon-Rd/Prather/https://www.londonproperties.com/images/props/fresno/full/652061.jpgLondon Properties Prather Real Estate | 29531 Morgan Canyon Rd
Courtesy of Monica Hansen, eXp Realty of California, Inc. - [email protected]
Welcome to this beautifully remodeled home situated on approximately 3.6 acres, offering the perfect blend of country living and convenience. Built in 1972, this move-in ready property features 4 bedrooms and 2 bathrooms with thoughtful updates throughout.Recent improvements include a new roof, new windows, luxury vinyl plank flooring, new baseboards, new cabinetry, granite countertops, and new appliances, creating a fresh, modern interior that's ready for its next owner.The expansive acreage provides endless possibilities, with plenty of room to plant a garden, raise chickens, keep horses, or simply enjoy wide-open spaces where children can play and explore. There is a small shop with power. Whether you're looking for a full-time residence, a weekend retreat, or an investment property with excellent rental potential, this home offers exceptional versatility.Conveniently located just minutes from town while still enjoying the peaceful beauty of the foothills, this fantastic property combines privacy, space, and accessibility. Don't miss this wonderful opportunitycall today to schedule your private showing!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 407550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 450450 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) >= 1190 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1690 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` = 1726296 OR `props-main`.`id` = 1722004 OR `props-main`.`id` = 1718996 OR `props-main`.`id` = 1719165 OR `props-main`.`id` = 1598453 OR `props-main`.`id` = 1743826 OR `props-main`.`id` = 1738580 OR `props-main`.`id` = 1738231 OR `props-main`.`id` = 1751073 OR `props-main`.`id` = 1703741 OR `props-main`.`id` = 1696683 OR `props-main`.`id` = 1696974 OR `props-main`.`id` = 1723684 OR `props-main`.`id` = 1696975 OR `props-main`.`id` = 1703358 OR `props-main`.`id` = 1746237 OR `props-main`.`id` = 1713593 OR `props-main`.`id` = 1736633 OR `props-main`.`id` = 1689072 OR `props-main`.`id` = 1721410 OR `props-main`.`id` = 1723247)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652061' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-18' 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
Last modified 1 day ago Fresno MLS last checked for updates 58 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.
