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/647933/2307-N-Hayes-Ave/Fresno/https://www.londonproperties.com/images/props/fresno/full/647933.jpgLondon Properties Fresno Real Estate | 2307 N Hayes Ave
(Seller Financing Available) Discover a rare multi-use property offering the perfect blend of country living, income potential, and agricultural opportunity. Situated on approximately 3+ acres, this versatile estate now operates as a successful U-Pick farm and nursery, creating multiple streams of income with room to expand.The charming ranch-style main home features a wrap-around porch ideal for relaxing and enjoying peaceful surroundings, and has been recently updated with new flooring and fresh interior paint. new kitchen countertops and new appliances. It also includes a water softener, tankless water heater, and owned (paid-off) solar system for long-term energy efficiency and reduced utility costs. A secondary mobile home adds flexibility for extended family, rental income, or on-site staff, featuring a 3-year-old HVAC system, newer appliances, and currently generating $1,500/month in rental income. Zoned A2, the property allows for agricultural use, rental opportunities, or a combination of both.Beyond the residences, the property is fully equipped for both lifestyle and business. Enjoy a private pool area with stamped concrete, plus extensive outbuildings including a large shop, hay barn, and storage areas. The established farm infrastructure includes raised beds, irrigation, greenhouses, and a wide variety of producing crops, making this a true turn-key operation.Whether you're looking to escape city life, invest in income-producing property, or grow an agritourism business, this property offers unmatched flexibility and upside.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1946
Region
Urban
# of Stories
Single Story
Price Per Square Foot
$385
Price Per Acre
$249,967
Days On London
41
Cumulative Days On London
41
County
Fresno
Leased Equipment
Propane
Special Features
Isolated Bedroom, Built In Cabinets, Water Softener, Horses Allowed
REO / Bank Owned
No
Cross Street Address
Clinton Ave
Directions
Just south of Clinton Ave
Style
Ranch
Heating & Cooling
Central Heat & Cool, Window or Wall A/C
Laundry
Inside, Utility Room
Roofing
Composition
Foundation
Wood Subfloor
Detached Structures
Shop, Barn, Green House
Kitchen
Built In Range/Oven, Electric Appliances, Disposal, Dishwasher, Microwave, Breakfast Bar, Pantry
Dining Room Features
Living Room/Area
Primary Bedroom Level
Main
Bath Features
Tub/Shower, Jetted Tub
Flooring
Vinyl, Other
# of Fireplaces
2
Fireplace Type
Gas Insert
Exterior
Wood
Pool
Yes
Pool
Yes
Pool Type
In Ground
Patio Features
Covered, Uncovered, Wood Deck
Yard
Sprinklers Front, Sprinklers Back, Sprinklers Auto
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 712405 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 787395 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1698 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2198 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` = 1724744 OR `props-main`.`id` = 1708001 OR `props-main`.`id` = 187712 OR `props-main`.`id` = 1724037 OR `props-main`.`id` = 1730594 OR `props-main`.`id` = 1697222 OR `props-main`.`id` = 1718147 OR `props-main`.`id` = 1731545 OR `props-main`.`id` = 1716472 OR `props-main`.`id` = 1705341 OR `props-main`.`id` = 1718782 OR `props-main`.`id` = 1725941 OR `props-main`.`id` = 1718790 OR `props-main`.`id` = 1725366 OR `props-main`.`id` = 1703904 OR `props-main`.`id` = 1703868 OR `props-main`.`id` = 1720112 OR `props-main`.`id` = 1726020 OR `props-main`.`id` = 1725984 OR `props-main`.`id` = 1726905 OR `props-main`.`id` = 804394 OR `props-main`.`id` = 1691526 OR `props-main`.`id` = 1691547 OR `props-main`.`id` = 1724623 OR `props-main`.`id` = 187713 OR `props-main`.`id` = 1730654 OR `props-main`.`id` = 1725617 OR `props-main`.`id` = 1722939 OR `props-main`.`id` = 1724013 OR `props-main`.`id` = 1728581 OR `props-main`.`id` = 1725106 OR `props-main`.`id` = 1717665 OR `props-main`.`id` = 160601 OR `props-main`.`id` = 1709206 OR `props-main`.`id` = 1702615 OR `props-main`.`id` = 1734830 OR `props-main`.`id` = 1717390 OR `props-main`.`id` = 1721281 OR `props-main`.`id` = 1718848 OR `props-main`.`id` = 1713605 OR `props-main`.`id` = 1731323 OR `props-main`.`id` = 1665977 OR `props-main`.`id` = 1720499 OR `props-main`.`id` = 1735922 OR `props-main`.`id` = 1726964 OR `props-main`.`id` = 1729519 OR `props-main`.`id` = 1727003 OR `props-main`.`id` = 1726206 OR `props-main`.`id` = 1728053 OR `props-main`.`id` = 1722484 OR `props-main`.`id` = 1731624 OR `props-main`.`id` = 985326 OR `props-main`.`id` = 1724724 OR `props-main`.`id` = 249079 OR `props-main`.`id` = 1711243 OR `props-main`.`id` = 1731478 OR `props-main`.`id` = 1726399 OR `props-main`.`id` = 1726103 OR `props-main`.`id` = 1708197 OR `props-main`.`id` = 1725418 OR `props-main`.`id` = 1722404 OR `props-main`.`id` = 1734760 OR `props-main`.`id` = 1725109 OR `props-main`.`id` = 1726078 OR `props-main`.`id` = 1722721 OR `props-main`.`id` = 1722198 OR `props-main`.`id` = 1728242 OR `props-main`.`id` = 1718964 OR `props-main`.`id` = 1728732 OR `props-main`.`id` = 1710280 OR `props-main`.`id` = 1723430 OR `props-main`.`id` = 1723425 OR `props-main`.`id` = 1716158 OR `props-main`.`id` = 1731522 OR `props-main`.`id` = 1727158 OR `props-main`.`id` = 1731709 OR `props-main`.`id` = 1688794 OR `props-main`.`id` = 1727617 OR `props-main`.`id` = 1725780)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno647933' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-06-10' 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();
1
Similar Properties
$750,000
5
2
2,192
2.42
5792 W Olive Ave
Fresno, CA 93722
Last modified 1 week ago Fresno MLS last checked for updates 20 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.
