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/tulare/236829/541-N-De-Wolf-Ave/Fresno/https://www.londonproperties.com/images/props/tulare/full/236829.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 Sub-Type
Single Family Residence
Year Built
1975
Year Built Source
Public Records
Days On Market
153
Cumulative Days On Market
153
County
Fresno
New Construction
No
Stories
2
Current Use
Residential
Directions to Property
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 Avenue.
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` = 1685161 OR `props-main`.`id` = 1691847 OR `props-main`.`id` = 1698193 OR `props-main`.`id` = 1687866 OR `props-main`.`id` = 1701020 OR `props-main`.`id` = 1698186 OR `props-main`.`id` = 839521 OR `props-main`.`id` = 1690773 OR `props-main`.`id` = 1675329 OR `props-main`.`id` = 1678590 OR `props-main`.`id` = 1680124 OR `props-main`.`id` = 1679440 OR `props-main`.`id` = 1697987 OR `props-main`.`id` = 1697992 OR `props-main`.`id` = 1697986 OR `props-main`.`id` = 1697997 OR `props-main`.`id` = 1698951 OR `props-main`.`id` = 1696284 OR `props-main`.`id` = 1692328 OR `props-main`.`id` = 1683995 OR `props-main`.`id` = 1692099 OR `props-main`.`id` = 1696453 OR `props-main`.`id` = 1679220 OR `props-main`.`id` = 1686337 OR `props-main`.`id` = 1696988 OR `props-main`.`id` = 1701700 OR `props-main`.`id` = 1701713 OR `props-main`.`id` = 1701712 OR `props-main`.`id` = 1701701 OR `props-main`.`id` = 1701716 OR `props-main`.`id` = 1701706 OR `props-main`.`id` = 1701704 OR `props-main`.`id` = 1701717 OR `props-main`.`id` = 1701710 OR `props-main`.`id` = 1701718 OR `props-main`.`id` = 1701703 OR `props-main`.`id` = 1701707 OR `props-main`.`id` = 1701711 OR `props-main`.`id` = 1701702 OR `props-main`.`id` = 1701705 OR `props-main`.`id` = 1701715 OR `props-main`.`id` = 1701714 OR `props-main`.`id` = 1690603 OR `props-main`.`id` = 272957 OR `props-main`.`id` = 1697947 OR `props-main`.`id` = 1701411 OR `props-main`.`id` = 1701413 OR `props-main`.`id` = 1691875 OR `props-main`.`id` = 1696055 OR `props-main`.`id` = 1666323 OR `props-main`.`id` = 1692247)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'tulare236829' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-01-08' 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, Johnston Merlo & Newton
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.
