Courtesy of Selena Avalos Aguilar, HomeSmart PV and Associates - [email protected]
Beautifully renovated and move-in ready in one of Northeast Fresno's most desirable locations! Tucked away in an established neighborhood near Herndon & Willow, this home offers the perfect balance of privacy, convenience, and access to the highly sought-after Clovis Unified School District. Inside, you'll find a bright, open layout featuring brand-new flooring, fresh interior paint, a new roof, an updated kitchen with modern finishes, and beautifully renovated bathrooms. The spacious living area with vaulted ceilings and a charming brick fireplace creates a warm, inviting atmosphere that's perfect for everyday living or entertaining. Conveniently located just minutes from premier shopping, restaurants, parks, and everyday amenities, this home offers the comfort of a quiet neighborhood while keeping everything you need close by. A rare opportunity to own a beautifully updated home in an exceptional location! Saturday Open House: 12-4pm
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1977
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$287
Price Per Acre
$2,822,398
Days On London
0
Cumulative Days On London
0
County
Fresno
Special Features
Built In Cabinets
REO / Bank Owned
No
Cross Street Address
Herndon
Directions
From CA-168, take the Herndon Ave exit, head east on Herndon Ave, turn right on Willow Ave, left on Palo Alto Ave. Property will be on the right.
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)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1489 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1989 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` = 1739159 OR `props-main`.`id` = 1730273 OR `props-main`.`id` = 1740177 OR `props-main`.`id` = 1719823 OR `props-main`.`id` = 1746104 OR `props-main`.`id` = 1749659 OR `props-main`.`id` = 1745583 OR `props-main`.`id` = 1742346 OR `props-main`.`id` = 1716430 OR `props-main`.`id` = 1739201 OR `props-main`.`id` = 1739239 OR `props-main`.`id` = 1751555 OR `props-main`.`id` = 1721650 OR `props-main`.`id` = 1729026 OR `props-main`.`id` = 1724369 OR `props-main`.`id` = 1731277 OR `props-main`.`id` = 1725231 OR `props-main`.`id` = 1750696 OR `props-main`.`id` = 1750688 OR `props-main`.`id` = 1690978 OR `props-main`.`id` = 1747908 OR `props-main`.`id` = 1721206 OR `props-main`.`id` = 1745208 OR `props-main`.`id` = 1749898 OR `props-main`.`id` = 1752657 OR `props-main`.`id` = 235292 OR `props-main`.`id` = 1752473 OR `props-main`.`id` = 1744694 OR `props-main`.`id` = 1742115 OR `props-main`.`id` = 1727136 OR `props-main`.`id` = 1732623 OR `props-main`.`id` = 971585 OR `props-main`.`id` = 1744870 OR `props-main`.`id` = 1746510 OR `props-main`.`id` = 1665941 OR `props-main`.`id` = 1748180 OR `props-main`.`id` = 1673041 OR `props-main`.`id` = 1709968 OR `props-main`.`id` = 1672985 OR `props-main`.`id` = 1673039 OR `props-main`.`id` = 217900 OR `props-main`.`id` = 1726716 OR `props-main`.`id` = 1721163 OR `props-main`.`id` = 1753278 OR `props-main`.`id` = 1736241 OR `props-main`.`id` = 1727337 OR `props-main`.`id` = 1749889 OR `props-main`.`id` = 1752576 OR `props-main`.`id` = 217381 OR `props-main`.`id` = 1731169 OR `props-main`.`id` = 1734770 OR `props-main`.`id` = 1747219 OR `props-main`.`id` = 1740902 OR `props-main`.`id` = 1740595 OR `props-main`.`id` = 1740602 OR `props-main`.`id` = 1731164 OR `props-main`.`id` = 188254 OR `props-main`.`id` = 1737070 OR `props-main`.`id` = 1748965 OR `props-main`.`id` = 1731792 OR `props-main`.`id` = 1747107 OR `props-main`.`id` = 1733407 OR `props-main`.`id` = 1749899 OR `props-main`.`id` = 1749929 OR `props-main`.`id` = 1747631 OR `props-main`.`id` = 1753338 OR `props-main`.`id` = 1732361 OR `props-main`.`id` = 1745713 OR `props-main`.`id` = 1725528 OR `props-main`.`id` = 1716523 OR `props-main`.`id` = 1739837 OR `props-main`.`id` = 1738209 OR `props-main`.`id` = 1723437 OR `props-main`.`id` = 1738602 OR `props-main`.`id` = 1728098 OR `props-main`.`id` = 1747767 OR `props-main`.`id` = 1749154 OR `props-main`.`id` = 1748115 OR `props-main`.`id` = 1726022 OR `props-main`.`id` = 1752147 OR `props-main`.`id` = 1749881 OR `props-main`.`id` = 1752999 OR `props-main`.`id` = 1728630 OR `props-main`.`id` = 1746302 OR `props-main`.`id` = 1747904 OR `props-main`.`id` = 1749723 OR `props-main`.`id` = 1747790 OR `props-main`.`id` = 1719804 OR `props-main`.`id` = 1740573 OR `props-main`.`id` = 1719325 OR `props-main`.`id` = 1723859 OR `props-main`.`id` = 1723849 OR `props-main`.`id` = 1752466 OR `props-main`.`id` = 1736611 OR `props-main`.`id` = 1736390 OR `props-main`.`id` = 1727159 OR `props-main`.`id` = 1724603 OR `props-main`.`id` = 1725587 OR `props-main`.`id` = 1741271 OR `props-main`.`id` = 1739555 OR `props-main`.`id` = 269824 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1716971 OR `props-main`.`id` = 1749697 OR `props-main`.`id` = 1743640 OR `props-main`.`id` = 1743384 OR `props-main`.`id` = 1752888 OR `props-main`.`id` = 1752898 OR `props-main`.`id` = 1744635 OR `props-main`.`id` = 1748966 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1747381 OR `props-main`.`id` = 1747406 OR `props-main`.`id` = 1746461 OR `props-main`.`id` = 1749927 OR `props-main`.`id` = 1739208 OR `props-main`.`id` = 1727287 OR `props-main`.`id` = 1747943 OR `props-main`.`id` = 1748275 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1750117 OR `props-main`.`id` = 1722091 OR `props-main`.`id` = 1729819 OR `props-main`.`id` = 1713574 OR `props-main`.`id` = 1749962 OR `props-main`.`id` = 1744195 OR `props-main`.`id` = 1732231 OR `props-main`.`id` = 1725864 OR `props-main`.`id` = 1734829 OR `props-main`.`id` = 1728572 OR `props-main`.`id` = 1728333 OR `props-main`.`id` = 1727634 OR `props-main`.`id` = 1728447 OR `props-main`.`id` = 1745187 OR `props-main`.`id` = 1746366 OR `props-main`.`id` = 1721190 OR `props-main`.`id` = 1715704 OR `props-main`.`id` = 1713613 OR `props-main`.`id` = 1715710 OR `props-main`.`id` = 1730059 OR `props-main`.`id` = 1747217 OR `props-main`.`id` = 1752417 OR `props-main`.`id` = 1752409 OR `props-main`.`id` = 1747634)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno652554' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-24' 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();
4
Similar Properties
$521,526
4
2.5
1,933
0.09
454 W Windsor
Clovis, CA 93612
$488,829
4
2
1,507
0.10
474 W Windsor Ave
Clovis, CA 93612
$485,000
4
2
1,894
0.19
6228 N Millbrook Ave
Fresno, CA 93710
$485,000
4
3
1,861
0.10
2202 E Chennault Ave
Fresno, CA 93720
Last modified 2 hours ago Fresno MLS last checked for updates 34 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.
