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/654432/1763-N-Leonard-Ave/Clovis/https://www.londonproperties.com/images/props/fresno/full/654432.jpgLondon Properties Clovis Real Estate | 1763 N Leonard Ave
Welcome home to this beautiful 3 bedroom, 2.75 bath home at the stunning community of Harlan Ranch in Clovis. Conveniently located across from Bud Rank Elementary School. This home is unusual for the area as it has ample street parking and a spacious driveway. Inside this beautiful home you will find a nice sized living room with a perfectly situated kitchen, and an office/bedroom and bathroom on the main floor. Upstairs you will be delighted by the large owner's suite and another bedroom which also has its own ensuite full bathroom. The indoor laundry room is also located upstairs for ease and convenience. A new AC was installed in 2023. As you step out into the beautiful back patio you will be able to enjoy meals, coffee or playtime. Within Harlan Ranch you are treated to a wonderful pool area, club house, walking trails and green spaces as well as many community events that happen throughout the year. Located close to the 168 that takes you into Fresno or up the hill to the foothills and Shaver, you will love living here. Easy to show. Make your appointment today for a personal showing.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 403750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 446250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1111 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1611 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` = 1761754 OR `props-main`.`id` = 1740193 OR `props-main`.`id` = 1758747 OR `props-main`.`id` = 1740181 OR `props-main`.`id` = 1750648 OR `props-main`.`id` = 1750780 OR `props-main`.`id` = 1754527 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1752922 OR `props-main`.`id` = 1745339 OR `props-main`.`id` = 1761574 OR `props-main`.`id` = 1749539 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1762835 OR `props-main`.`id` = 1761872 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1749995 OR `props-main`.`id` = 1739362 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1742689 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1758862 OR `props-main`.`id` = 1751380 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1735948 OR `props-main`.`id` = 1752236 OR `props-main`.`id` = 1769169 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1746896 OR `props-main`.`id` = 1726680 OR `props-main`.`id` = 1721325 OR `props-main`.`id` = 1768309 OR `props-main`.`id` = 1768496 OR `props-main`.`id` = 1768421 OR `props-main`.`id` = 1728171 OR `props-main`.`id` = 1724586 OR `props-main`.`id` = 1764254 OR `props-main`.`id` = 1765890 OR `props-main`.`id` = 1745941 OR `props-main`.`id` = 1749960 OR `props-main`.`id` = 1755055 OR `props-main`.`id` = 1737095 OR `props-main`.`id` = 1732245)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654432' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-28' 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();
1
Similar Properties
$420,000
3
2.75
1,372
0.06
4001 Harlan Ranch Blvd
Clovis, CA 93619
Last modified 2 hours ago Fresno MLS last checked for updates 43 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.
