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 = 1529 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 = 1529 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 = 1529 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;

26377 State Hwy Ra
Pittsburg, MO 65724
Marilyn Gowin with Century 21Peterson Real Estate, original listing - (417) 745-6798

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $204,900
Beds: 2
Baths: Full: 3, ½: 2
Status: Active
SqFt: 2448 Square Feet
Agency: Century 21Peterson Real Estate
Agency Phone: (417) 745-6798

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1967
Notes: ''ON THE LAKE'' 3.8 ML Acres, Secluded, Bordering 2 sides Corps/Lake. This Large Hunting and Fishing LODGE has approx. 2450 Sq, Open dining / kitchen area is roomy enough for 2 stoves, long spacious eating bar and dining tables. 2 fireplaces. Sleeping Dorms set up to sleep 20 campers or more. 3 full and 2 half baths, 2 Water Heaters and New Well Pump and piping. Metal Roof. The Outside Dining area is huge, with a dining under covered patio. Plus, outside pergola for more shaded dining. Concrete HANDICAP Sidewalk to lower-level dining, Campfires and Playground. Brick BBQ. Cleared, lighted areas for tents and campers. Easy trail to the lake and Bank Your Boat in Your Back Yard. Courtesy Dock and concrete boat ramp less than 1 mile away. Fishing, water sports, and loaded with deer and wildlife. FEEL THE LAKE'S BREEZE. Set up for Large family gatherings or Church Camp events. At roads end, Seasonal Lake View on paved road. 20 mins north of Bolivar. TURNKEY LAKE LODGE. MOST LODGE FURNISHINGS WILL STAY!!
MlsNumber: --
ListingId: 60270943


Listing Provided By: Century 21Peterson Real Estate, original listing
Phone: (417) 399-1760
Office Phone: (417) 745-6798
Agent Name: Marilyn Gowin
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