0 W Huntsman Avenue, San Joaquin, CA 93660

Local realty services provided by:CENTURY 21 Jordan-Link
0 W Huntsman Avenue,San Joaquin, CA 93660
$2,511,690
  • - Beds
  • - Baths
  • - sq. ft.
  • Farm
  • Active
Listed by: scott a schuil
Office: schuil ag real estate inc.
MLS#:628820
Source:CA_FMLS

Price summary

  • Price:$2,511,690

About this home

Planted to Kerman pistachios on UCB-1 Rootstock. Trees were planted in 2013 at 19′ x 17′ spacing. Located in the James Irrigation District, receives surface water through a canal adjacent to the property using a 30 HP booster pump. The property has three (3) sand media filters and is irrigated with a double-line drip system. No groundwater well. James Irrigation district is a part of the James Groundwater Sustainability Agency and is in the Kings Sub-basin. Sustainable 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 at https://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. 2025 Pistachio crop is NOT included

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an independent agent affiliated with the CENTURY 21®  brand to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an independent agent affiliated with the CENTURY 21®  brand is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , Coldwell Banker® , Corcoran® , ERA® , Sotheby's International Realty® ).
 I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Listing ID #:628820
  • Added:250 day(s) ago
  • Updated:December 24, 2025 at 03:45 PM

Structure and exterior

  • Lot area:86.61 Acres

Schools

  • High school:San Joaquin
  • Middle school:San Joaquin
  • Elementary school:San Joaquin

Finances and disclosures

  • Price:$2,511,690
MLS LogoBased on information from the Fresno Association of REALTORS® (alternatively, from the Fresno MLS)as of (December 24, 2025). All data, including all measurements and calculations of area, is obtained from various sources and has not been, and will not be, verified by broker or MLS. All information should be independently reviewed and verified for accuracy.Properties may or may not be listed by the office/agent presenting theinformation.