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

1105 Ne 450
Osceola, MO 64776
Phillip Smith with RE/MAX TRUMAN LAKE, original listing - (660) 885-2201

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $799,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2016 Square Feet
Agency: RE/MAX TRUMAN LAKE
Agency Phone: (660) 885-2201

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 97 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2000
Notes: AMAZING!!! 97 ACRES of PRIME HUNTING GROUND, a STOCKED POND, a BEAUTIFUL HOME, and a LARGE SHOP!!! WHAT A DEAL!!! Plus, there is also additional acreage available (a 18.7 acre parcel and a 20.4 acre parcel). LAND: The 97 acres is mostly timbered, but there is a small section of pasture near the house and the shop. BEAUTIFUL HOME: This one-owner house was built in 2000. It was thoughtfully designed, very well built, and lovingly maintained. From the moment you walk through the front door, you will be captivated by the beautiful hardwood floors and feel the warm embrace of the sunlight pouring in through the stunning arched windows in the open concept main living area. As you tour the home, you will find many other fine details, such as the custom cabinetry, the bullnose corners, and the ample storage space found throughout the home. This home has closets galore. The owner's suite is spacious and luxurious with a double sink vanity, a jetted tub for two, and a massive walk-in closet. There are two additional bedrooms, a laundry room, and another bathroom on the main level. In the partially/mostly finished walk-out basement you will find a third bathroom a kitchenette and room for more bedrooms. There is also more storage and plenty of flex space in the basement. The basement could easily be converted into a 2nd living space such as an apartment or an in-laws living quarters. There is also a 2 car garage in the basement. LARGE SHOP: The 30' x 50' metal building has a concrete floor and electricity. LOCATION: This property is ideally located in a peaceful country setting and is only a short 10 minute drive to town. OH, THE POSSIBILITIES: On this property you can go hunting, fishing, or just go exploring through the woods and take in the captivating natural beauty all around you. The pastured area in front of the shop is ideal for a hobby-farm. You could literally live off the land here. This is a RARE FIND at a GREAT PRICE!!! CALL or TEXT and schedule your showing TODAY!!!
MlsNumber: --
ListingId: 97143


Listing Provided By: RE/MAX TRUMAN LAKE, original listing
Phone: (660) 885-2201
Office Phone: (660) 885-2201
Agent Name: Phillip Smith
Disclaimer: Copyright © 2024 West Central 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App