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/654789/5221-S-Reed-Ave/Reedley/https://www.londonproperties.com/images/props/fresno/full/654789.jpgLondon Properties Reedley Real Estate | 5221 S Reed Ave
Just north of Reedley and only minutes from Highway 180, this 4.43 acre country property combines comfortable living with the space and versatility of a rural setting. With open pasture, peaceful surroundings, and views that come alive at sunset, the property offers plenty of room to enjoy the outdoors, accommodate livestock, or simply appreciate a little more space between you and your neighbors.The 3-bedroom, 2-bath home was remodeled in 2022 and features an open layout with abundant natural light throughout. At the center of the home is an updated kitchen complete with soft-close cabinetry, recessed lighting, GE appliances, a farmhouse sink, and finishes that complement the home's clean, comfortable feel. Large windows bring the surrounding countryside into view, while the spacious back patio provides an ideal place to relax, entertain, or unwind while overlooking the pasture.Beyond the home, the acreage is already equipped for a variety of uses. The pasture is prepared for cattle or horses, with a barn and C-train storage container providing additional utility. A detached two-car garage includes 240V power, and a separate carport provides additional covered parking.Energy features include a 23-panel solar system installed in 2020, with the solar lease prepaid through its term, as well as a Tesla Powerwall backup battery system.Offering usable acreage, updated living space, livestock amenities, and convenient access to Reedley and Highway 180, this property brings together the features of country living without sacrificing accessibility.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 541500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 598500 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) >= 1176 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1676 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` = 1774121)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654789' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-09' 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 3 hours ago Fresno MLS last checked for updates 28 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.
