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/635138/541-N-De-Wolf-Ave/Fresno/https://www.londonproperties.com/images/props/fresno/full/635138.jpgLondon Properties Fresno Real Estate | 541 N De Wolf Ave
Beautiful country living opportunity in the desirable Belmont Country Club area. This charming 5 bedroom/ 5 bathroom home across the street from the 4th hole fairway, on 1.71 acres has so much to offer. Come in the gates and step through the front door of this 4,374 sq ft home, into a spacious and inviting open area surrounded by multiple dining rooms. As you continue down the main hallway you will find 4 bedrooms which are conveniently connected with Jack and Jill style bathrooms. As you continue the floorplan the roomy living room has a classic wet bar which seamlessly flows into the well appointed kitchen and pantry area. The primary bedroom and loft/game room each have their own staircases to gain access to these second floor rooms. The primary bedroom and second floor patio are the best spots to take in views of the pool area and other vocal points of the property, including the many flower beds and garden areas of the backyard. The property is truly a perfect place for family and friends to gather and to entertain. Plenty of extra storage space and closets throughout the home. Additionally there is a detached shop, 3 car garage, and the majority balance of the acreage is open; leaving so much potential to build an additional home on the property, mother in law suite, or ADU. A buyer's personal touches are endless. Property resides in the Clovis Unified School District. Schedule your private showing today to view this property.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1975
Region
Urban
# of Stories
Two
Price Per Square Foot
$297
Price Per Acre
$759,649
Days On London
264
Cumulative Days On London
264
County
Fresno
Reports Available
Pest, Appraisal
Special Features
Security Gate, Built In Cabinets, Central Vac, Wet/Dry Bar, Intercom
REO / Bank Owned
No
Cross Street Address
Tulare Street
Directions
From the Highway 180 and De Wolf Avenue, head North on De Wolf Avenue. The property is on the West side of De Wolf Avenue just North of Tulare.
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Composition
Foundation
Concrete
Detached Structures
Shop
Kitchen
Electric Appliances, Disposal, Dishwasher, Eating Area, Pantry
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 1234050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 1363950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '5' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 4124 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 4624 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` = 1713351 OR `props-main`.`id` = 1708358 OR `props-main`.`id` = 1722101 OR `props-main`.`id` = 1716182 OR `props-main`.`id` = 1710115 OR `props-main`.`id` = 1719658 OR `props-main`.`id` = 1723527 OR `props-main`.`id` = 1718830 OR `props-main`.`id` = 1717710 OR `props-main`.`id` = 1718652 OR `props-main`.`id` = 1716178 OR `props-main`.`id` = 839521 OR `props-main`.`id` = 1708165 OR `props-main`.`id` = 1717782 OR `props-main`.`id` = 1678590 OR `props-main`.`id` = 1680124 OR `props-main`.`id` = 1679440 OR `props-main`.`id` = 1723736 OR `props-main`.`id` = 1704514 OR `props-main`.`id` = 1709931 OR `props-main`.`id` = 1703929 OR `props-main`.`id` = 1703763 OR `props-main`.`id` = 1721878 OR `props-main`.`id` = 1696453 OR `props-main`.`id` = 1701952 OR `props-main`.`id` = 1705930 OR `props-main`.`id` = 1702954 OR `props-main`.`id` = 1702982 OR `props-main`.`id` = 1679220 OR `props-main`.`id` = 1705881 OR `props-main`.`id` = 1703885 OR `props-main`.`id` = 1715687 OR `props-main`.`id` = 1713987 OR `props-main`.`id` = 1722444 OR `props-main`.`id` = 1712505 OR `props-main`.`id` = 1712452 OR `props-main`.`id` = 1718037 OR `props-main`.`id` = 1713602 OR `props-main`.`id` = 1724109 OR `props-main`.`id` = 1715473 OR `props-main`.`id` = 1724126 OR `props-main`.`id` = 1724108 OR `props-main`.`id` = 1715471 OR `props-main`.`id` = 1715470 OR `props-main`.`id` = 1724127 OR `props-main`.`id` = 1724118 OR `props-main`.`id` = 1724101 OR `props-main`.`id` = 1724119 OR `props-main`.`id` = 1724104 OR `props-main`.`id` = 1724103 OR `props-main`.`id` = 1724107 OR `props-main`.`id` = 1724121 OR `props-main`.`id` = 1724122 OR `props-main`.`id` = 1724125 OR `props-main`.`id` = 1724124 OR `props-main`.`id` = 1724123 OR `props-main`.`id` = 1724105 OR `props-main`.`id` = 1724128 OR `props-main`.`id` = 1724106 OR `props-main`.`id` = 1724102 OR `props-main`.`id` = 1724120 OR `props-main`.`id` = 1724117 OR `props-main`.`id` = 1724115 OR `props-main`.`id` = 1724116 OR `props-main`.`id` = 1690603 OR `props-main`.`id` = 272957 OR `props-main`.`id` = 1713805 OR `props-main`.`id` = 1723125 OR `props-main`.`id` = 1723126 OR `props-main`.`id` = 1723127 OR `props-main`.`id` = 1666323 OR `props-main`.`id` = 1692247 OR `props-main`.`id` = 1718982)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno635138' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-04-29' 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
Courtesy of Jace Merlo, James Merlo, Broker - [email protected] 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.
