Title Page Background
DEBUG FN args: Array ( [0] => 914 [1] => [2] => [3] => agent ) BEFORE: Site: 914 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 914 Igate: njhud LocID: 914 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 914 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 914 [1] => [2] => [3] => lender ) BEFORE: Site: 914 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 914 Igate: njhud LocID: 914 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 914 AND i.igate IN ('usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 914 [1] => [2] => [3] => other ) BEFORE: Site: 914 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 914 Igate: njhud LocID: 914 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 914 AND i.igate IN ('usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1647 Ash Point Rd
Highland, KS 66035

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $849,900
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3254 Square Feet
Agency: Mossy Oak Properties of the Heartland Woods N' Water Land Co.
Agency Phone: (816) 259-5104

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 40 acre(s)
Garage: Garage
Property Type: Residential-Single Family Attached
Year Built: 2018
Notes: Mossy Oak Properties is very excited to showcase this magnificent country home on 40 acres in western Doniphan County and is conveniently located just a half mile north of Highway 36 on a nicely paved road. As you drive up the scenic winding gravel driveway from the road, you'll know your home, and the views of the countryside are spectacular in every direction! Built in 2018, this stunning home has over 3,254 sq/ft of living space on the main floor and upper half story with another 1,663 sq/ft of space in the unfinished basement with lots of potential! As you enter through the front door into the spacious foyer, the first thing you notice is the exquisite hickory hardwood floor that stretches forward into the great room with beautiful tongue and groove wooden cathedral ceilings and a huge stone fireplace with gas insert that tapers up to the peak and immediately catches your eye. Big picture windows align both sides of the fireplace to let a lot of natural light into the room with custom hickory benches at the base on each side of the fireplace nicely accenting the stone. All of the doors and trim in the house are made of solid rustic walnut that really compliments the floors and décor of the house. The great room flows into the kitchen and dining room creating a nice big open look. The kitchen consists of beautiful custom-made Hickory cabinetry with dark granite countertops and a nice size island which houses the gas top range. Included in the spacious kitchen is a built-in oven, microwave, dishwasher, and new undercounter ice maker that makes the popular Sonic-like ice! There is also a very nice size pantry with lots of shelves for storage adjacent to the kitchen. The master bedroom and bath are located just off the living room on the main level. The vanity and cabinetry in the master bathroom and throughout the house are all custom made from hickory with Onyx countertops. There is also a really quaint 10'x13' sunroom located off of the master bedroom to the west with lots of options for use. Along the entire back side of the house is a large partially covered deck accessible from the dining room, sun room, or south side of the house. Upon entering the home from the spacious 2 car attached garage there is a large closet on the right with a half bath on the left flowing into the utility room with a washer and dryer and walk-out door to the driveway. The upstairs level of the home takes you to the ample sized loft which separates the two main large bedrooms with a stellar view to the great room below. Each bedroom has an attached 3/4 bathroom. The north bedroom has an extra small room under the dormer on the back side of the bathroom that is finished and could be used as another small bedroom, playroom, or storage. The main bedroom on the south side has similar space on the back side of the bathroom as well but has its own access door from the loft which could potentially be another bedroom. There is a big 30'x12' finished bonus room attached to this smaller potential bedroom and has its own heating and cooling unit. The house has a full unfinished walk-out basement with 9' walls and 1,663 sq/ft of space. It has a built-in concrete storm cellar and a partially framed in bathroom. The unattached shop is located to the south of the house and measures approximately 30'x46' with a heavy concrete floor and two 12'x12' overhead doors. It is plumbed for a bathroom with water and sewer connected and 200 amp service. The entire property itself consists of +/- 39.31 deeded acres comprised of gently rolling hills with approximately 10 acres of timber at the far west end of the property. The remaining 20-25 acres west of the house is currently being used for hay but could also generate some income through row crops, alfalfa, or grazing. There are a couple spots back near the timber that would make some killer food plots to draw in the turkeys and those massive Kansas whitetails that this area is so well known for!
MlsNumber: --
ListingId: 11292965


Listing Provided By: Mossy Oak Properties of the Heartland Woods N' Water Land Co., original listing
Phone: (816) 259-5104
Office Phone: (816) 259-5104
Agent Name: Jody Franken
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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => doniphan [3] => KS [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: doniphan State: KS Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: doniphan State: KS Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 914 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App