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/650802/2991-E-Cromwell-Ave/Fresno/Woodward-Park/https://www.londonproperties.com/images/props/fresno/full/650802.jpgLondon Properties Fresno Real Estate | 2991 E Cromwell Ave
Courtesy of Mohamad Mansour, Universal Realty Services, Inc. - [email protected]
Move-In Ready Clovis North Beauty with Owned Solar & Resort-Style BackyardWelcome to this beautifully updated 5-bedroom, 3-bathroom home located in a quiet cul-de-sac in one of Northeast Fresno's most desirable neighborhoods. Offering 2,418 sq ft of living space on a huge oversized lot, this two-story home checks every box.Step inside to find brand-new flooring, fresh interior and exterior paint, updated stair rails, new light fixtures, and fully remodeled bathroomsevery detail has been thoughtfully upgraded. The kitchen shines with new countertops, new appliances, and modern finishes, perfect for everyday living and entertaining.Outside is where this home truly stands out. Enjoy a massive custom backyard patio complete with an outdoor kitchen and built-in BBQ, plus a covered front patio for morning coffee. Mature landscaping creates a private, resort-like feel, and there's potential RV parking for added flexibility.Additional highlights include:☀️ Owned solar system (paid off)🚗 Epoxy-coated garage flooring🏡 New exterior & interior paint🛋️ Move-in ready condition🛍️ Close to shopping, dining & freeway access🎓 Top-rated Clovis Unified School District🏫 Clovis North High SchoolThis home offers the perfect blend of style, comfort, and locationideal for families or anyone looking for a turnkey property in a premier school district.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2005
Region
Urban
# of Stories
Two
Price Per Square Foot
$265
Price Per Acre
$2,950,207
Days On London
9
Cumulative Days On London
146
County
Fresno
Leased Equipment
Security System
Special Features
Isolated Bedroom, Isolated Bathroom, Built In Cabinets, Wet/Dry Bar
REO / Bank Owned
No
Cross Street Address
N Willow/Alluvial
Directions
north on Willow and Use GPS
Special Disclosure
Agent/Owner Related
Style
Contemporary
Heating & Cooling
Central Heat & Cool
Laundry
Inside, On Lower Level
Roofing
Composition
Foundation
Concrete
Detached Structures
Shed
Kitchen
Built In Range/Oven, Disposal, Dishwasher, Microwave, Trash Compactor, Eating Area, Breakfast Bar, Pantry
Dining Room Features
Formal, Living Room/Area, Family Room/Area
Primary Bedroom Level
Upper
Bath Features
Tub/Shower, Shower, Tub, Jetted Tub, Oval Tub, Roman Tub
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 607905 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 671895 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.75' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2168 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2668 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` = 1744694 OR `props-main`.`id` = 1742115 OR `props-main`.`id` = 1727136 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` = 1736241 OR `props-main`.`id` = 1727337 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` = 1731792 OR `props-main`.`id` = 1733407 OR `props-main`.`id` = 1747631 OR `props-main`.`id` = 1732361 OR `props-main`.`id` = 1739015 OR `props-main`.`id` = 1745713 OR `props-main`.`id` = 1736074 OR `props-main`.`id` = 1704516 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` = 1748115 OR `props-main`.`id` = 1731908 OR `props-main`.`id` = 1726022 OR `props-main`.`id` = 1744194 OR `props-main`.`id` = 1728630 OR `props-main`.`id` = 471337 OR `props-main`.`id` = 1746302 OR `props-main`.`id` = 1747904 OR `props-main`.`id` = 1747790 OR `props-main`.`id` = 1727446 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` = 1716789 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` = 1729098 OR `props-main`.`id` = 742025 OR `props-main`.`id` = 1716971 OR `props-main`.`id` = 1743640 OR `props-main`.`id` = 1743384 OR `props-main`.`id` = 1727571 OR `props-main`.`id` = 1742778 OR `props-main`.`id` = 1716588 OR `props-main`.`id` = 1744635 OR `props-main`.`id` = 186522 OR `props-main`.`id` = 1747381 OR `props-main`.`id` = 1747406 OR `props-main`.`id` = 1746461 OR `props-main`.`id` = 1739208 OR `props-main`.`id` = 1727721 OR `props-main`.`id` = 1727287 OR `props-main`.`id` = 1748275 OR `props-main`.`id` = 54055 OR `props-main`.`id` = 1722091 OR `props-main`.`id` = 1732265 OR `props-main`.`id` = 1745950 OR `props-main`.`id` = 1729819 OR `props-main`.`id` = 1716850 OR `props-main`.`id` = 1713574 OR `props-main`.`id` = 1724859 OR `props-main`.`id` = 1744195 OR `props-main`.`id` = 1732231 OR `props-main`.`id` = 1725864 OR `props-main`.`id` = 1746746 OR `props-main`.`id` = 1725314 OR `props-main`.`id` = 1734829 OR `props-main`.`id` = 1728572 OR `props-main`.`id` = 1728333 OR `props-main`.`id` = 1745000 OR `props-main`.`id` = 1727634 OR `props-main`.`id` = 1728447 OR `props-main`.`id` = 1745187 OR `props-main`.`id` = 1726694 OR `props-main`.`id` = 1722445 OR `props-main`.`id` = 1741195 OR `props-main`.`id` = 1741329 OR `props-main`.`id` = 1746366 OR `props-main`.`id` = 1737803 OR `props-main`.`id` = 1721190 OR `props-main`.`id` = 1721177 OR `props-main`.`id` = 1721285 OR `props-main`.`id` = 1715704 OR `props-main`.`id` = 1721164 OR `props-main`.`id` = 1713613 OR `props-main`.`id` = 1715710 OR `props-main`.`id` = 1730059 OR `props-main`.`id` = 1747217 OR `props-main`.`id` = 239407 OR `props-main`.`id` = 1739892 OR `props-main`.`id` = 1736392 OR `props-main`.`id` = 1747634 OR `props-main`.`id` = 1743612 OR `props-main`.`id` = 1745038 OR `props-main`.`id` = 1719764 OR `props-main`.`id` = 1745687 OR `props-main`.`id` = 1740726 OR `props-main`.`id` = 1742660 OR `props-main`.`id` = 1723199 OR `props-main`.`id` = 1738963 OR `props-main`.`id` = 1738973 OR `props-main`.`id` = 168075 OR `props-main`.`id` = 225192 OR `props-main`.`id` = 1743745 OR `props-main`.`id` = 1730761 OR `props-main`.`id` = 1718204 OR `props-main`.`id` = 1734579 OR `props-main`.`id` = 1722958 OR `props-main`.`id` = 1731795 OR `props-main`.`id` = 1729238 OR `props-main`.`id` = 1742849 OR `props-main`.`id` = 1727377 OR `props-main`.`id` = 1733058 OR `props-main`.`id` = 1726901 OR `props-main`.`id` = 1735550 OR `props-main`.`id` = 1735502 OR `props-main`.`id` = 226899 OR `props-main`.`id` = 1739157)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno650802' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-07-12' 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 1 week ago Fresno MLS last checked for updates 56 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.
