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

1015 Ne 301st
Leeton, MO 64761
Emily Burke with Golden Valley Realty Group, original listing - (660) 885-7653

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $795,000
Beds: 4
Baths: Full: 4
Status: Active
SqFt: 4700 Square Feet
Agency: Golden Valley Realty Group
Agency Phone: (660) 885-7653

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 43 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2002
Notes: Let me begin by saying there are not enough characters allowed in this property description to even begin to tell you all about this property. Therefore, you are going to have to believe me when I say you must see it to truly appreciate it! I know this is a phrase that is often overused but this is definitely true for this one! Before you ever even pull in the driveway you will be wowed by the grandeur of this property. With it’s 100% custom floor plan this home boasts a curb appeal like none other. From the covered porches to the beautiful landscaping and being perfectly positioned on nearly 40 acres, this property will be easy to call home. On the main level you will find the most spectacular kitchen, a living room with vaulted ceilings and stone fireplace, a formal dining area, the main master suite and one additional bedroom as well as your laundry and mudroom area. While I may have to skip over some specific details in this write up, we do not want to overlook the kitchen. This is a kitchen built for a true chef featuring granite countertops, mini wet bar, an island, dual fuel Wolf range with double ovens, griddle and grill, a pot filler, Bosch dishwasher, and Sub Zero refrigerator and freezer; with all this, you could not even ask for more! The master bedroom is to die for with its large double vanity area, jetted tub, large shower, and not one but two walk-in closets. On the second level you will find the two additional bedrooms, one of which serves as a second master suite and a bonus area which has many possibilities that might include an office, a studio area, or even a kids play area. Something else that is worth mentioning is the fact that this home is built to last and was over engineered which is what makes it so unique and a solid investment. A lot of value is added to this home from the 2x6 construction, engineered lumber floor joists, multiple zone heating and cooling systems, not to mention the attention to detail alone. I am running out of room in this description, but I want to briefly list some of the exterior features of this property as well. You can't have a home with acreage without a nice outbuilding and this outbuilding features 220 amp service, a lean to on the back for storage of equipment or hay, a wood stove, and nine foot ceilings just to name a few. The current owners have also made the property perfect for horse owners with a carport that serves as covered protection for the animals and an area that would make a wonderful space for a riding arena. Onto the acreage itself, you will find a creek running through the property, lovely custom bridges for convenience of crossing, 2 ponds, and a hunting tower. As you are walking around the outside you may also notice a variety of trees including red buds, colorful maples and pin oaks. You will also find an orchard with apple trees and peach trees. Provided with this listing is a FULL list of features you DON’T want to overlook so be sure to request this list for your review. Do not miss out on the opportunity to own such a beautiful home! Schedule your showing today!
MlsNumber: --
ListingId: 98690


Listing Provided By: Golden Valley Realty Group, original listing
Phone: (660) 351-2382
Office Phone: (660) 885-7653
Agent Name: Emily Burke
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.


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 = 1537 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;
Real Estate Expert Photo for Cheryl Miller
Cheryl Miller
ASCIIReeceNichols Shewmaker
Call Today!: (816) 682-2382

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App