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 = 1541 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 1541 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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 = 1541 AND i.igate IN ('usahud','wahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'wahud', 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;

21713 Highway Pp
Pierce City, MO 65723
Jackie Nelson with Coldwell Banker Show-Me Properties, original listing - (417) 678-4210

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,750,000
Beds: --
Baths: --
Status: Active
SqFt: 1000 Square Feet
Agency: Coldwell Banker Show-Me Properties
Agency Phone: (417) 678-4210

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 30 acre(s)
Property Type: Farm-Other
Year Built: 2019
Notes: This is an incredible state of the art greenhouse and farm, with multiple opportunities available, and 30 acres to expand. It is located in the heart of the Ozarks, being an hour from Springfield, Northern Arkansas, and 45 minutes to Joplin, all cities with major outlets for agricultural products. Alongside this nearly 8000 sq ft greenhouse are two 40 x 80 outbuildings, and another concrete pad and materials for the construction of another greenhouse. The front building houses a beautifully designed office featuring a stunning glass front with covered wrap around porch, Inside, a brick accent wall adds warmth and character, complemented by a wood ceiling with exposed beams for a sophisticated modern atmosphere. This space is fully equipped with a full kitchen, along with a full bath, perfect for team meetings & client entertaining. If you are looking for a stylish showroom or a functional office area, this building offers versatility to meet your business needs and is also ADA compliant. The near 8000 square foot greenhouse boasts every state-of-the-art amenity available, with a MicroGrow PROCOMII Control panel, computerized monitoring & storing of data. There are 4-250,000 BTU/HR propane heaters. Lighting is Ceramic Metal Halide that can operate on 1 or 2 phase. The ventilation system offers 8 circulation fans and 4 exhaust fans. The alarm system sends both text & email if humidity or temperature fluctuates out of the programmed range. The MicroGrow WATERMAX system can also be automated & includes a gravity operated fertigation system with 2-250 gal tanks in the office building equipped with Big Blue Filter and UV purification. A 50% Shade system, also a fire retardant, can open/close in multiple phases for both heating & cooling retention. Freeze dryers, a dehydrator & a fully equipped & cooled production room for multi purpose production possibilities also enhance the opportunity of this property. The 30 acres provides ample space for continued growth.
MlsNumber: --
ListingId: 60295385


Listing Provided By: Coldwell Banker Show-Me Properties, original listing
Phone: (417) 693-3338
Office Phone: (417) 678-4210
Agent Name: Jackie Nelson
Disclaimer: Copyright © 2025 Southern Missouri Regional MLS, LLC (SOMO). 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