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/656103/956-Church-Ave/Sanger/https://www.londonproperties.com/images/props/fresno/full/656103.jpgLondon Properties Sanger Real Estate | 956 Church Ave
Courtesy of Adrian Cuellar, eXp Realty of Northern California, Inc. - [email protected]
Your first home, your next chapter, or simply a place to put down roots, this Sanger property offers the space and potential to make it happen. Featuring 4 bedrooms, 2 bathrooms, and 1,309 sq. ft. of living space on a 7,373 sq. ft. lot, the home provides a functional layout and a spacious backyard ready for your personal touch. Whether you're stepping into homeownership or looking for room to grow, this is an opportunity to create a home that reflects your lifestyle and build equity along the way. Come see the potential for yourself and imagine what you could make of it!
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 280250 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 309750 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) >= 1059 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1559 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` = 1776301 OR `props-main`.`id` = 1763022 OR `props-main`.`id` = 1761875 OR `props-main`.`id` = 63187 OR `props-main`.`id` = 224353 OR `props-main`.`id` = 1720651 OR `props-main`.`id` = 1778310 OR `props-main`.`id` = 1695260 OR `props-main`.`id` = 1777163 OR `props-main`.`id` = 1771102 OR `props-main`.`id` = 1775476 OR `props-main`.`id` = 1747599 OR `props-main`.`id` = 1745947 OR `props-main`.`id` = 1752544 OR `props-main`.`id` = 1766450 OR `props-main`.`id` = 1749763 OR `props-main`.`id` = 1767726 OR `props-main`.`id` = 1762039 OR `props-main`.`id` = 1763311 OR `props-main`.`id` = 1752722 OR `props-main`.`id` = 1769037 OR `props-main`.`id` = 1775931 OR `props-main`.`id` = 1701454 OR `props-main`.`id` = 1722165 OR `props-main`.`id` = 1770906 OR `props-main`.`id` = 1760208 OR `props-main`.`id` = 1782611 OR `props-main`.`id` = 1742093 OR `props-main`.`id` = 1726629 OR `props-main`.`id` = 994639 OR `props-main`.`id` = 1759725 OR `props-main`.`id` = 1730797 OR `props-main`.`id` = 1772610 OR `props-main`.`id` = 1772094 OR `props-main`.`id` = 1776214 OR `props-main`.`id` = 1784217 OR `props-main`.`id` = 1784986 OR `props-main`.`id` = 1743823 OR `props-main`.`id` = 1755924 OR `props-main`.`id` = 1771289 OR `props-main`.`id` = 1767647 OR `props-main`.`id` = 1758406)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656103' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-01' 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 2 hours ago Fresno MLS last checked for updates 32 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.
