Title Page Background
HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 241 AND i.igate IN ('usahud','cahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'cahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

10537 Boone Avenue
Sultana, CA 93666
Jim Merlo with Johnston Merlo & Newton, original listing - (559) 591-3200

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $3,250,000
Beds: --
Baths: --
Status: Active
SqFt: 78000 Square Feet
Agency: Johnston Merlo & Newton
Agency Phone: (559) 591-3200

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 14 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1983
Notes: A modern packing and cold storage facility situated in a prime tree fruit, citrus, and agricultural growing area, designed for the handling and packing of agricultural crops. Over 78,000 +/- square feet under roof. The total facility is constructed on 14.68 acres over 9 parcels, with much potential for growth and expansion. The facility includes ; main packing shed, receiving room, precool rooms, bin rooms, storage, loading area with 6 loading docks, dry storage, restrooms, break areas, and a 2,400 square foot separate complex office with 4 offices and 2 restrooms. Over 21 additional parking spaces. Packing House Area (Approx. 26,500 square feet): Fourteen volume filters with 17 controlled packed drops. Receiving Room Area (Approx. 4,526 square foot): Large area letting fruit flow either directly to the packing line or to bin rooms for precooking. Precool Room Area (Approx 3,780 square feet): Three rooms 20' X 63.' Bin Room Area (Approx 4,725 square feet): Two rooms for holding bins or pressure cooling fruit. Storage Room (Approx 22,000 square feet): Three large rooms totally racked for storage. Six hundred tons ammonia system refrigeration. Office (Approx 2,400 square feet): A 40' X 60' separate complex with 4 offices and 2 bathrooms. Loading Area (Approx. 4,758 square feet): Enclosed area approximately 61' X 78' with 6 loading bays. Dry Storage (Approx. 9,408 square feet): A large dry storage area converted from a cold storage. Please contact listing agent to arrange showing. 24 hours notice appreciated, prequalified buyers only please.
MlsNumber: --
ListingId: 224957


Listing Provided By: Johnston Merlo & Newton, original listing
Phone: (559) 591-3200
Office Phone: (559) 591-3200
Agent Name: Jim Merlo
Disclaimer: Copyright © 2024 Tulare County MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App