Sign In

Close

x
Showing 1 of 0
X
Save
0 Huntsman Avenue W San Joaquin CA 93660US628820
0 Huntsman Avenue W San JoaquinCA93660
2684910.0000 1/1/1900 12:00:00 AM
Schuil Ag Real Estate Inc.
1 /

Courtesy of: Scott Schuil, Schuil Ag Real Estate Inc., scott@schuil.com

0 Huntsman Avenue W
San Joaquin CA 93660 US

Save
1 /

Courtesy of: Scott Schuil, Schuil Ag Real Estate Inc., scott@schuil.com

Get more info about this property

0 Huntsman Avenue W
San Joaquin CA 93660 US

$2,684,910

Active Listing ID 628820
lot icon
Lot: 86.61 Acres
home icon
Other

$2,684,910

Active Listing ID 628820
Save
3d icon
Maps

0 Huntsman Avenue W 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

Collapse all

Property Features

  • Facts
  • Lot Size: 86.61 Acres
  • Property Type: Farm
  • Property Sub-type: Other

School Information

  • School
  • San Joaquin(Elementary)
  • San Joaquin(MiddleSchool)
  • San Joaquin(HighSchool)

Property

  • propertytype: Farm
  • propertysubtype: Other
  • listprice: 2684910
  • unparsedaddress: 0 Huntsman Avenue W
  • postalcity: San Joaquin
  • stateorprovince: CA
  • country: US
  • postalcode: 93660
  • bathroomsfull: 0
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 86.61
  • lotsizeunits: Acres
  • lotsizearea: 86.61
  • livingarea: 0
  • livingareaunits: Square Feet
  • latitude: 0
  • longitude: 0
  • listagentfullname: Scott Schuil
  • listagentemail: scott@schuil.com
  • listagentkey: 3yd-FARCA-18858
  • listagentmlsid: 18858
  • listagentpreferredphone: 7341700
  • listagentofficephone: 5597341700
  • listofficekey: 3yd-FARCA-618
  • listofficemlsid: 618
  • disclaimer: Copyright © 2025 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: FARCA
  • listingcontractdate: 2025-04-16
  • listagenturl: http://www.schuil.com
  • countyorparish: Fresno
  • parcelnumber: 03007030S
  • elementaryschool: San Joaquin
  • highschool: San Joaquin
  • elementaryschooldistrict: San Joaquin
  • middleorjuniorschooldistrict: San Joaquin
  • highschooldistrict: San Joaquin
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 0
  • parkingtotal: 0
  • waterfrontyn: False
  • architecturalstyle: Other
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: 0, 0
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Schuil & Associates Diversified Real Estate, Inc.", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"scott@schuil.com", "ListBrokerageCity":"Visalia", "ListBrokerageCountry":"US", "ListBrokerageEmail":"mike@schuil.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/FARCA/5b43f711734611dfa22d00219b994c72/20100616045308838.png", "ListBrokerageName":"Schuil & Associates Diversified Real Estate, Inc.", "ListBrokeragePhone":"(559) 734-1700", "ListBrokeragePostalCode":"93291", "ListBrokerageStateOrProvince":"CA", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"5020 W. Mineral King Avenue", "ListBrokerageWebsiteUrl":"http://www.schuil.com", "ListOfficeAddress1":"5020 W Mineral King Ave", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"Visalia", "ListOfficeCountry":"US", "ListOfficeEmail":"mike@schuil.com", "ListOfficePostalCode":"93291", "ListOfficeStateOrProvince":"CA", "ListPriceCurrencyType":"USD", "ListingTitle":"Nut Crops - San Joaquin, CA", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/SW-C-S-Colorado-Ave_San-Joaquin_CA_93660_M92221-18191?f=listhub&s=FARCA&m=628820&c=rexren", "MLSModificationTimestamp":"2025-07-16T12:22:07Z", "Neighborhoods":[], "PostalCode":null, "RawPropertySubType":"Nut Crops", "RawPropertyType":"Farm", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/16/2025 11:01:32 PM GMT
Source Updated Date: 12/5/2025 6:42:08 PM GMT

Courtesy of: Scott Schuil, Schuil Ag Real Estate Inc., scott@schuil.com

Copyright © 2025 Fresno Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact