Please provide the following information and Tiffinie Jones will assist you.
* indicates required fields.
Sending...
Sent!
Get More Info
Print A Flyer
Get A Home Loan
Share
https://www.tiffiniejones.com/agent/16081/tiffinie-jones/property/link/fresno/637489/1740-S-Cornelia-Ave/Fresno/https://www.tiffiniejones.com/images/props/fresno/full/637489.jpgLondon Properties Fresno Real Estate | 1740 S Cornelia Ave
PlantingsThe property is currently farmed to alfalfa hay, rented to the neighbor.HomeThere is one (1) mobile home on the property, being rented for $500 per month. The rental lease runs until 2027.BarnThere is a barn/shop on the property. The barn has electricity and is set up to accommodate those with automotive hobbies, repairs or restoration projects. WaterThis property is located within the Fresno Irrigation District.One (1) domestic wellGroundwater DisclosureSustainable Groundwater Management Act (SGMA) requires groundwater basins to be sustainable by 2040. SGMA may limit ground water pumping. For more information, please visit the SGMA website athttps://water.ca.gov/programs/groundwater-management/sgma-groundwater-management.The Buyer is responsible for conducting their own research to verify all information related to groundwater and surface water resources, including availability, usage rights, and potential restrictions.RemarksThis property is a great opportunity for those looking to build a homestead in the country, on 5 acres. This homesite is just a few miles from the town of southwest Fresno.
Property Type
Residential
Property Subtype 1
Single Family Residence
Property Subtype 2
Mobile Home
Year Built Exception
Unknown
Region
Rural
# of Stories
Single Story
Price Per Square Foot
$202
Price Per Acre
$80,000
Days On Market
2
Cumulative Days On Market
2
County
Fresno
REO / Bank Owned
No
Cross Street Address
Jensen Avenue
Directions
From CA-99 take Jensen Avenue exit west to S. Cornelia Avenue turn north, proceed 1/4 mile to property on the east side of road.
Heating & Cooling
Window or Wall A/C
Laundry
Utility Room, Electric Hook Up
Roofing
Metal
Foundation
Both
Primary Bedroom Level
Main
Exterior
Metal
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Septic Tank, Private Well
Solar
No
Parking Features
Potential RV Parking, Carport, Uncovered, Work/Shop Area
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 380000 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 420000 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1734 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2234 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` = 1681310 OR `props-main`.`id` = 1666341 OR `props-main`.`id` = 1686726 OR `props-main`.`id` = 1664266 OR `props-main`.`id` = 1664262)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno637489' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2025-09-26' 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 Michael Bliss, Schuil Ag Real Estate Inc. - Michael@schuil.com Last modified 3 days ago Fresno MLS last checked for updates 36 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.
