Available for sale is an opportunity to acquire a citrus estate in the highly regarded Lemon Cove agricultural region of Tulare County. Set among the foothills of the Sierra Nevada Mountains, this property offers approximately 51 acres of mature citrus varieties, Lemon Cove DitchStock, scenic hillside views, and a private residential setting.Located at 33204 Road 248 in Lemon Cove, California, this 2,528SF home is located on the property. Construction originally began in 2010, with periodic updates made over the years. The home still requires additional finishing work, offering the opportunity for a new owner tocomplete it to their specifications. An additional home pad and well are located on the hillside, with elevated views overlooking the property and valley. The residence is being sold in its as-is condition.
Property Type
Residential
Property Subtype 1
Single Family Residence
Year Built
2010
Region
Rural
# of Stories
Two
Price Per Square Foot
$1,088
Price Per Acre
$44,262
Days On London
19
Cumulative Days On London
19
County
Tulare
REO / Bank Owned
No
Cross Street Address
Avenue 334
Directions
33204 Road 248, Lemon Cove, CA
Heating & Cooling
Central Heat & Cool
Laundry
Inside
Roofing
Other
Foundation
Concrete
Primary Bedroom Level
Upper
Exterior
Stucco
Pool
No
Pool
No
Gas & Electric
Public Utilities
Sewer / Water
Private Well
Solar
No
Are there garage spaces?
No
APN
113 150 004
School District
Woodlake Schools
School Type 1
High School
School Name 1
Woodlake Union
School Type 2
Junior High School
School Name 2
Sequoia Union
School Type 3
Grade School
School Name 3
Sequoia Union
71109
A: SELECT * FROM `lpdotcom`.`props-main` WHERE CAST(`props-main`.`ListingPrice` AS DECIMAL) >= 2612500 AND CAST(`props-main`.`ListingPrice` AS DECIMAL) <= 2887500 AND CAST(`props-main`.`Bedrooms` AS DECIMAL) >= '2' AND CAST(`props-main`.`Bathrooms` AS DECIMAL(10,5)) >= '2.5' AND CAST(`props-main`.`SquareFootage` AS DECIMAL) >= 2278 AND CAST(`props-main`.`SquareFootage` AS DECIMAL) <= 2778 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` = 1692034 OR `props-main`.`id` = 1761634 OR `props-main`.`id` = 1776897 OR `props-main`.`id` = 1745049)) AND CONCAT(`MLSFeed`,`MLNumber`) != 'fresno655310' AND `props-main`.`PictureCount` > 0 AND (`props-main`.`ExpiredDate` >= '2026-09-16' 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 26 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.
