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/651416/3401-Alcove-Way/Clovis/https://www.londonproperties.com/images/props/fresno/full/651416.jpgLondon Properties Clovis Real Estate | 3401 Alcove Way
Courtesy of Braithan Stoltenberg, eXp Realty of California, Inc. - [email protected]
Welcome to life in Harlan Ranch, one of Clovis' most sought-after master-planned communities. This beautifully maintained 4-bedroom, 3-bathroom home offers the perfect blend of comfort, style, and neighborhood amenities that make everyday living feel special.Inside, you'll find a spacious and functional floor plan featuring luxury vinyl flooring throughout and a thoughtfully designed kitchen that is sure to impress. The kitchen offers abundant cabinetry and storage, granite countertops, a large center island for gathering and meal prep, and plenty of space for a formal dining table. The inviting living area is anchored by a cozy electric fireplace that can be controlled with the touch of a remote, creating the perfect atmosphere for relaxing evenings at home.A convenient downstairs bedroom and full bathroom provide flexibility for guests, multigenerational living, or a private home office, enhanced by a charming wood barn door for added character.Step outside and enjoy being just moments from one of Harlan Ranch's community pools and parks. Residents enjoy access to 11 neighborhood parks, miles of scenic walking trails, a beautiful clubhouse, and a full calendar of community events coordinated by dedicated onsite staff. Whether you're taking an evening stroll, meeting neighbors at the park, or enjoying one of the many community gatherings, Harlan Ranch offers a lifestyle that is truly hard to match. Come experience the sense of community, convenience, and pride of ownership that make Harlan Ranch such a desirable place to call home.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2014
Region
Urban
# of Stories
Two
Price Per Square Foot
$256
Price Per Acre
$8,816,254
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Harlan Ranch Blvd /De Wolf Ave
Directions
From De Wolf and Harlan Ranch Blvd, head South on De Wolf. Make a Left on Richmond, Left on Encoure, and house is at end of Encoure and Alcove.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 474050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 523950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '4' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1696 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2196 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` = 1739592 OR `props-main`.`id` = 1719775 OR `props-main`.`id` = 1726080 OR `props-main`.`id` = 1726717 OR `props-main`.`id` = 1740193 OR `props-main`.`id` = 1742204 OR `props-main`.`id` = 1743639 OR `props-main`.`id` = 1740181 OR `props-main`.`id` = 1744938 OR `props-main`.`id` = 1706831 OR `props-main`.`id` = 1726822 OR `props-main`.`id` = 1744504 OR `props-main`.`id` = 1716326 OR `props-main`.`id` = 1745339 OR `props-main`.`id` = 1726038 OR `props-main`.`id` = 1689657 OR `props-main`.`id` = 1739362 OR `props-main`.`id` = 439522 OR `props-main`.`id` = 1742689 OR `props-main`.`id` = 1716508 OR `props-main`.`id` = 1716294 OR `props-main`.`id` = 1716286 OR `props-main`.`id` = 1735948 OR `props-main`.`id` = 1742850 OR `props-main`.`id` = 1721608 OR `props-main`.`id` = 1744141 OR `props-main`.`id` = 1743096 OR `props-main`.`id` = 1736378 OR `props-main`.`id` = 1739639 OR `props-main`.`id` = 1729298 OR `props-main`.`id` = 1720435 OR `props-main`.`id` = 1731275 OR `props-main`.`id` = 1726680 OR `props-main`.`id` = 1721325 OR `props-main`.`id` = 1728171 OR `props-main`.`id` = 1739534 OR `props-main`.`id` = 1738449 OR `props-main`.`id` = 1724586 OR `props-main`.`id` = 1725116 OR `props-main`.`id` = 1729321 OR `props-main`.`id` = 1729341 OR `props-main`.`id` = 1730588 OR `props-main`.`id` = 1744840 OR `props-main`.`id` = 1737095 OR `props-main`.`id` = 1732245 OR `props-main`.`id` = 1721973 OR `props-main`.`id` = 1738748 OR `props-main`.`id` = 1736454 OR `props-main`.`id` = 1736478 OR `props-main`.`id` = 1741661)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno651416' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-02' 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 54 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.
