$2,684,910

0 W Huntsman Ave San Joaquin, CA 93660

Estimated payment $17,201/month

Total Views 16,765
-- Bed
-- Bath
3,772,732 Sq Ft
$1 Price per Sq Ft

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 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

Listing Agent

Scott Schuil

Schuil Ag Real Estate Inc. License #01877812 Listed on: 04/16/2025

Property Details

Property Type

  • Other

Home Design

  • Farm

Additional Features

  • 86.61 Acre Lot
  • Property is located within a water district

Property Details

Property Type

Other

Lot Details

0

Listing Details

  • Type: Farm
  • Property Sub Type: Nut Crops
  • Year Built Exception: Unknown
  • Special Features: None

Utilities

  • Sewer Septic: None
  • Utilities: Electricity Avail
  • Water Source: District Water Avail

Condo/Co-op/Association

  • Association: Fresno MLS

Lot Info

  • Topography: Level
  • Acres: 86.6100
  • Lot Measurement: Acres
  • Lot Size Sq Ft: 3772732.00
  • Price Per Acre: 31000.00
  • Domestic Wells: None
  • Irrigation Wells: None
  • Major Crop Type: Pistachios

MLS Schools

  • School District 2: San Joaquin
  • School Type: High School
  • School Name: San Joaquin
  • School Type: Junior High School
  • School Name: San Joaquin
  • School Type: Grade School
  • School Name: San Joaquin

Map

Range of Values:

Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area

Source: Public Records

Property History

Date Event Price Change Sq Ft Price
07/16/2025 07/16/25 Price Changed $2,684,910 -4.6% $1 / Sq Ft
06/05/2025 06/05/25 Price Changed $2,814,825 -4.4% $1 / Sq Ft
05/05/2025 05/05/25 Price Changed $2,944,740 -99.0% $1 / Sq Ft
04/16/2025 04/16/25 For Sale $299,999,740 -- $80 / Sq Ft
Source: Fresno MLS

Source: Fresno MLS

MLS Number: 628820

Fresno MLS
California Fresno County San Joaquin 93660

0 W Huntsman Ave, San Joaquin, CA

This home is located at 0 W Huntsman Ave, San Joaquin, CA 93660 and is currently priced at $2,684,910, approximately $0 per square foot. 0 W Huntsman Ave is a home located in Fresno County with nearby schools including Tranquillity High School.

Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.

Fresno MLS IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.

Nearby Homes
Scott Schuil
Listing Agent
Scott Schuil
Section Image
Schuil Ag Real Estate Inc.
(559) 336-0361