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

5499 Nw Crabill Road
Maysville, MO 64469
Dylan Heitz with United Country Nelson Real Estate, original listing - (660) 425-2288

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,049,900
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2880 Square Feet
Agency: United Country Nelson Real Estate
Agency Phone: (660) 425-2288

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 77 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 2024
Notes: Listing # 7749 Take a look at this new construction home on 77.78 acres! This 2,880 sq. ft. home is intricately designed and has a lot to offer. As you walk in you are immediately met with stunning trim, cabinetry, and ceilings. The living area and kitchen are completely open and offer a massive nearly 1,000 sq. ft. area. The custom-made Knotty Alder kitchen cabinets have stunning Granite countertops and a large kitchen island. This is truly a high-end kitchen! The living area boasts a tray ceiling that makes the area feel bigger than it already is. There is a wood burning fireplace and plenty of natural light paired with custom built-ins. The office is truly a showstopper! Made from solid Walnut, this office is stylish and functional. The master suite boasts a 16'x16' bedroom, a custom bathroom, and a 12'x22' walk-in closet from your dreams. The closet is completely decked out with built-ins and is large enough for any wardrobe! This setup has an additional 7 acres m/l. On this 7 acres m/l is a wonderful 30'x50' outbuilding that is currently being used as a house. It is comprised of 2 bedrooms and 1 bathroom. It has a comfortable feel and a great open concept kitchen and living area. It could easily be converted to a shop or left a house. Also includes a 50'x120' shop that is currently a cabinetry shop. It offers so much potential with spray foam insulation, heated concrete floors, wood burning boiler, office, and 3 large garage doors. This could be an incredible opportunity to own all this additional square footage at an affordable price! The property has 50 acres m/l of open grass meadows, nearly 23 acres of timber and timbered draws, and a couple of ponds. It is a perfect set up for a cattle or horse ranch, however the grass meadows could easily be put into row crop production, and this would make a fantastic hunting property as well. Features Include: - 2,880 sq. ft. - House on 77.78 acres - 3-bedroom, 3-bathroom - Could easily have 4th bedroom - Custom cabinetry - Granite countertops - 8'x7' pantry - Huge walkout patio - Stunning views - 3 car attached garage - Buried freight cargo can for storm shelter - All new appliances - Incredible master suite - 30'x50' Outbuilding - 50'x120' Insulated & Heated Shop - 50 ac. grass meadows - 23 ac. timber/draws - Hunting opportunities
MlsNumber: --
ListingId: 11317658


Listing Provided By: United Country Nelson Real Estate, original listing
Phone: (660) 425-2288
Office Phone: (660) 425-2288
Agent Name: Dylan Heitz
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App