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/656805/654-Agua-Dulce-Ave/Clovis/https://www.londonproperties.com/images/props/fresno/full/656805.jpgLondon Properties Clovis Real Estate | 654 Agua Dulce Ave
Courtesy of Jessica Templeton, London Properties, Ltd. - [email protected]
Welcome to this beautifully maintained home in the desirable Loma Vista master-planned community of Clovis! Offering 5 bedrooms, 3 bathrooms, and 3,537 sq. ft. of living space, this spacious residence features soaring ceilings, abundant natural light, and a welcoming sense of openness from the moment you enter. The kitchen is a standout, featuring rich finishes, extensive cabinetry, a large island with built-in cooking, a built-in oven and microwave, a walk-in pantry, and a dedicated coffee bar. Two downstairs living areas Offer versatile space for relaxing, entertaining, or everyday living, while a downstairs bedroom adds flexibility to the floor plan. The spacious primary suite offers a generous bedroom and an expansive bathroom retreat. Storage is plentiful throughout the home. Outside, the property features extensive concrete hardscaping for lower-maintenance outdoor areas, fruit trees, a gazebo, decorative wrought-iron side gates, and installed bird netting Additional features include a Tuff Shed offering potential for a personal retreat or hobby space and covered RV parking. The home has been exceptionally well cared for, with a clean, like-new presentation that reflects the owners' pride Of ownership. The home also features 34 leased solar panels, with the lease assumable by the buyer. Located within Loma Vista, a Clovis master-planned community with parks, open spaces, and planned walking and biking connections, nearby. This home offers generous living space and a variety of practical features both inside and out.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2017
Region
Urban
# of Stories
Two
Price Per Square Foot
$216
Price Per Acre
$4,455,446
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
Bullard & DeWolf
Directions
From Bullard Ave, turn south onto Agua Dulce Ave, then turn right onto Morris Ave and left onto Agua Dulce Ave. Property is on the west side of the street.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 726750 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 803250 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '3' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 3287 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 3787 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` = 1770343 OR `props-main`.`id` = 1788770 OR `props-main`.`id` = 1786067 OR `props-main`.`id` = 1788725 OR `props-main`.`id` = 1782348 OR `props-main`.`id` = 1787304 OR `props-main`.`id` = 144625 OR `props-main`.`id` = 1772204 OR `props-main`.`id` = 1748850 OR `props-main`.`id` = 1770835 OR `props-main`.`id` = 1770876 OR `props-main`.`id` = 1755600 OR `props-main`.`id` = 1788302 OR `props-main`.`id` = 1746688 OR `props-main`.`id` = 1715629 OR `props-main`.`id` = 1765146 OR `props-main`.`id` = 1715630 OR `props-main`.`id` = 1784078 OR `props-main`.`id` = 1762755 OR `props-main`.`id` = 1761281 OR `props-main`.`id` = 1761282 OR `props-main`.`id` = 1762766 OR `props-main`.`id` = 1762796 OR `props-main`.`id` = 1787751 OR `props-main`.`id` = 1768982 OR `props-main`.`id` = 1739538 OR `props-main`.`id` = 1718456 OR `props-main`.`id` = 1785619 OR `props-main`.`id` = 1785783 OR `props-main`.`id` = 1784000 OR `props-main`.`id` = 1732406 OR `props-main`.`id` = 1732389 OR `props-main`.`id` = 1764347 OR `props-main`.`id` = 1764368 OR `props-main`.`id` = 1790944 OR `props-main`.`id` = 1790058 OR `props-main`.`id` = 1791609 OR `props-main`.`id` = 1778416 OR `props-main`.`id` = 1785164 OR `props-main`.`id` = 1776705 OR `props-main`.`id` = 1742059 OR `props-main`.`id` = 1770749 OR `props-main`.`id` = 1774616 OR `props-main`.`id` = 1774204 OR `props-main`.`id` = 1774225 OR `props-main`.`id` = 1770908 OR `props-main`.`id` = 1681482 OR `props-main`.`id` = 1762270 OR `props-main`.`id` = 1784044 OR `props-main`.`id` = 1791547 OR `props-main`.`id` = 1700055 OR `props-main`.`id` = 165469 OR `props-main`.`id` = 1781368 OR `props-main`.`id` = 1775757 OR `props-main`.`id` = 1791984 OR `props-main`.`id` = 1774611 OR `props-main`.`id` = 1755156 OR `props-main`.`id` = 1770504 OR `props-main`.`id` = 1760610 OR `props-main`.`id` = 1766614 OR `props-main`.`id` = 1790452 OR `props-main`.`id` = 1727388 OR `props-main`.`id` = 1791373 OR `props-main`.`id` = 1495106 OR `props-main`.`id` = 1495592 OR `props-main`.`id` = 1790415 OR `props-main`.`id` = 1773163)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno656805' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-10-16' 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 14 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.
