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

17126 Wisdom Rd
Green Ridge, MO 65332

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $749,500
Beds: 3
Baths: 2
Status: Active
SqFt: --
Agency: Missouri Land Company

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 21 acre(s)
Property Type: Residential
Year Built: --
Notes: They don\'t make them much nicer than what this place is! There is so many extras here its hard to begin to list them all. The home was built in Sq Ft , 1680 up and 840 finished downstairs. 3 Bedroom 2 1/2 bath with a nice open floor plan. Huge kitchen with custom cabinets and a big island , really nice appliances all stay. The living room is also very big with nice laminate floors. The master bedroom is also very big and has a really nice walk in closet. There is also a bathroom attached to the master bedroom all on the first floor. The downstairs has one bedroom, and a big office or sewing room , which could also be a non conforming bedroom. The other half of the basement is a 2 car garage with lots of storage. Home even has central vac system. Home has a newer roof and new gutters. The back porch is somewhere you would want to sit and sip your morning coffee overlooking the 2 1/2 acre lake, and watching the purple martin birds fly in and out the bird houses the seller is leaving. The lake is stocked with fish and will be a hit for the kids or grandkids when they come to visit. The landscaping around the house is so pretty and is all ready for you to enjoy. The shop is every mans dream, it is over 3000 sq ft under roof . The building is climate controlled with heat and air. Big tall ceilings and has lien to all around the 3 sides of the main building. The seller is leaving the 2 tarter horse stalls. What a place to have horses, there are trails through the timber for riding , also for hunting access. Seller said you can get your deer every year off the back porch. There is crop ground all around this place and with the wooded draw and creek makes enough cover for the wildlife. There are beautiful fruit trees , apple, cherry and pears out by the garden spot. You can pretty much self sustain on this property. With plenty of pasture for your livestock needs and area to cut your own hay. There is also a rv shelter 18 x 40 the seller is leaving and also a 12 x 20 carport to use to clean fish, or just get the sun off you. Out in the country but still not to far you can get to Sedalia in 20 minutes, 20 minutes to Lamont, 20 minutes to Windsor, and around 30 minutes to Truman Lake or Clinton. Its hard to describe all that is here, just contact me and would love to show it to you!
MlsNumber: 11274573


Listing Provided By: Missouri Land Company, original listing
Name: Missouri Land Company
Phone: (660) 668-4868
Office Name: Missouri Land Company
Office Phone: (660) 668-4868
Agent Name: Mike Stoner
Disclaimer: Copyright © 2024 My State MLS. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1566 AND i.igate IN ('usahud','flhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'flhud', 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;
Rhonda Ahern
ASCIIPremier Realty Group
Call Today!: (660) 287-2080

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App