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/654430/4489-S-Indianola-Ave/Del-Rey/https://www.londonproperties.com/images/props/fresno/full/654430.jpgLondon Properties Del Rey Real Estate | 4489 S Indianola Ave
Excellent opportunity to own a highly desirable 19 acre almond orchard featuring approximately 9-year-old Nonpareil and Monterey almond trees. This established producing orchard is served by irrigation district water and features its own agricultural solar system, providing valuable infrastructure for continued farming operations.The property also includes an approximately 1,424 sq. ft., 3-bedroom, 1-bath residence, which is currently tenant occupied, providing an additional income-producing component to the property.The agricultural acreage is currently subject to an existing farm lease. With mature almond trees, desirable varieties, district water, solar, and an existing residence, this property offers an attractive combination of productive farmland, established infrastructure, and income potential.Buyer to verify all acreage, production, water availability, lease terms, and property information to their satisfaction.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
1925
Region
Rural
Unique Conditions
1031 Exchange
# of Stories
Two
Price Per Square Foot
$631
Price Per Acre
$45,635
Days On London
0
Cumulative Days On London
0
County
Fresno
REO / Bank Owned
No
Cross Street Address
American/ Indianola
Directions
From American and Indianola. North on Indianola.Home is on the left.
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 854050 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 943950 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '3' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '1' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 1174 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 1674 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` = 1741763 OR `props-main`.`id` = 1746841 OR `props-main`.`id` = 1736636 OR `props-main`.`id` = 1749954 OR `props-main`.`id` = 1768822 OR `props-main`.`id` = 1747724 OR `props-main`.`id` = 1684982 OR `props-main`.`id` = 1694468 OR `props-main`.`id` = 1684978 OR `props-main`.`id` = 1763022 OR `props-main`.`id` = 1761873 OR `props-main`.`id` = 1761875 OR `props-main`.`id` = 1761893 OR `props-main`.`id` = 63187 OR `props-main`.`id` = 224353 OR `props-main`.`id` = 1720651 OR `props-main`.`id` = 1726910)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno654430' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-08-27' 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 2 hours ago Fresno MLS last checked for updates 1 hour 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.
