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/645333/77-W-Lester-Ave/Clovis/https://www.londonproperties.com/images/props/fresno/full/645333.jpgLondon Properties Clovis Real Estate | 77 W Lester Ave
Welcome to this beautiful Wilson home located in the highly desirable gated community of Kings Crossing. This immaculate home offers three bedrooms two bath and two spacious living areas. The kitchen has granite countertops and plenty of space for storage, meal preparations, and entertaining. You will love the big backyard that has been completely redone from fencing to gates, pergola and gazebos, not to mention loads of new concrete and hardscape and an amazing jacuzzi to relax and enjoy under the star filled sky. There is a permitted gas line that goes all the way out to the barbecue and fire pit and electric that goes to the spa. The exterior and interior of this home have been completely repainted and there to many upgrades to list inside. This community offers easy access to parks, schools and walking trails. Don't miss out! Schedule your showing today.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2004
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$294
Price Per Acre
$3,727,977
Days On London
0
Cumulative Days On London
0
County
Fresno
Reports Available
Roof
Special Features
Security System
REO / Bank Owned
No
Cross Street Address
Shepherd/Minnewawa
Directions
From Shepherd go N on Minnewawa, to Powers, turn west into the community.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Tile
Foundation
Concrete
Kitchen
Built In Range/Oven, Gas Appliances, Disposal, Dishwasher, Microwave, Eating Area, Breakfast Bar
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 502550 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 555450 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) >= 1550 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2050 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` = 1704516 OR `props-main`.`id` = 1709425 OR `props-main`.`id` = 1711434 OR `props-main`.`id` = 1711436 OR `props-main`.`id` = 1697265 OR `props-main`.`id` = 1713872 OR `props-main`.`id` = 1701527 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1702842 OR `props-main`.`id` = 1702857 OR `props-main`.`id` = 1707877 OR `props-main`.`id` = 1674613 OR `props-main`.`id` = 1713568 OR `props-main`.`id` = 241157 OR `props-main`.`id` = 1705398 OR `props-main`.`id` = 1709945 OR `props-main`.`id` = 1700108 OR `props-main`.`id` = 1713632 OR `props-main`.`id` = 1706699 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1711281 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1715859 OR `props-main`.`id` = 1704908 OR `props-main`.`id` = 1701984 OR `props-main`.`id` = 1694367 OR `props-main`.`id` = 1711429 OR `props-main`.`id` = 1715457 OR `props-main`.`id` = 1715452 OR `props-main`.`id` = 1705649 OR `props-main`.`id` = 1712608 OR `props-main`.`id` = 1710075 OR `props-main`.`id` = 1709455 OR `props-main`.`id` = 1716215 OR `props-main`.`id` = 1705857 OR `props-main`.`id` = 1704380 OR `props-main`.`id` = 1705848 OR `props-main`.`id` = 1715704 OR `props-main`.`id` = 1712605 OR `props-main`.`id` = 1713613 OR `props-main`.`id` = 1715710 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1713829 OR `props-main`.`id` = 1711283 OR `props-main`.`id` = 1713049 OR `props-main`.`id` = 1703454 OR `props-main`.`id` = 1704410 OR `props-main`.`id` = 1715897 OR `props-main`.`id` = 1711143 OR `props-main`.`id` = 1716264 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 1705042 OR `props-main`.`id` = 1679313 OR `props-main`.`id` = 1712328 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1716028 OR `props-main`.`id` = 1712606 OR `props-main`.`id` = 1696685 OR `props-main`.`id` = 1701434 OR `props-main`.`id` = 1708303 OR `props-main`.`id` = 1701436 OR `props-main`.`id` = 1701538 OR `props-main`.`id` = 1703808 OR `props-main`.`id` = 1701430 OR `props-main`.`id` = 1711092 OR `props-main`.`id` = 1715868 OR `props-main`.`id` = 1708299 OR `props-main`.`id` = 1708304 OR `props-main`.`id` = 1708298 OR `props-main`.`id` = 1708310 OR `props-main`.`id` = 1708311 OR `props-main`.`id` = 1708300 OR `props-main`.`id` = 1708301 OR `props-main`.`id` = 1708309 OR `props-main`.`id` = 1708297 OR `props-main`.`id` = 1708296 OR `props-main`.`id` = 1708306 OR `props-main`.`id` = 1708307 OR `props-main`.`id` = 1708308 OR `props-main`.`id` = 1703614 OR `props-main`.`id` = 1703671 OR `props-main`.`id` = 1699091 OR `props-main`.`id` = 1701632 OR `props-main`.`id` = 1696246 OR `props-main`.`id` = 1715853 OR `props-main`.`id` = 1715851 OR `props-main`.`id` = 1706911 OR `props-main`.`id` = 1709276 OR `props-main`.`id` = 1708154 OR `props-main`.`id` = 1711375 OR `props-main`.`id` = 1708322 OR `props-main`.`id` = 1698148 OR `props-main`.`id` = 1709697 OR `props-main`.`id` = 1712521 OR `props-main`.`id` = 1698439 OR `props-main`.`id` = 1705807 OR `props-main`.`id` = 1705157 OR `props-main`.`id` = 1701465 OR `props-main`.`id` = 1705163 OR `props-main`.`id` = 1705164 OR `props-main`.`id` = 1705159 OR `props-main`.`id` = 1705160 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1692341 OR `props-main`.`id` = 1709645 OR `props-main`.`id` = 1709662 OR `props-main`.`id` = 1701884 OR `props-main`.`id` = 1709663 OR `props-main`.`id` = 1709664 OR `props-main`.`id` = 1709644 OR `props-main`.`id` = 1705219 OR `props-main`.`id` = 1709643 OR `props-main`.`id` = 1709665 OR `props-main`.`id` = 1701893 OR `props-main`.`id` = 1709661 OR `props-main`.`id` = 1709649 OR `props-main`.`id` = 1715965 OR `props-main`.`id` = 1709660 OR `props-main`.`id` = 1701898 OR `props-main`.`id` = 1709646 OR `props-main`.`id` = 1709642 OR `props-main`.`id` = 1702838 OR `props-main`.`id` = 1701878 OR `props-main`.`id` = 1701894 OR `props-main`.`id` = 1701881 OR `props-main`.`id` = 1706045 OR `props-main`.`id` = 1704905 OR `props-main`.`id` = 1716040 OR `props-main`.`id` = 1708512 OR `props-main`.`id` = 1709953 OR `props-main`.`id` = 1715747 OR `props-main`.`id` = 1715721 OR `props-main`.`id` = 1715638 OR `props-main`.`id` = 1715479 OR `props-main`.`id` = 1715523)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno645333' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-03-13' 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();
7
Similar Properties
$554,990
3
2
1,887
0.11
855 Solar Ln
Clovis, CA 93619
$549,900
3
2
1,989
0.19
8540 N Talladega Way
Fresno, CA 93720
$549,000
4
2
2,045
0.17
8450 N Saffron Ct
Fresno, CA 93720
$539,000
4
2
1,840
0.14
2230 E Ryan Ave
Fresno, CA 93720
Courtesy of Cheryl Oliver, Central Valley Real Estate - [email protected] Last modified 3 hours ago Fresno MLS last checked for updates 13 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.
