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

25846 Ne 228 Rd
Hanston, KS 67849
Lisa Schartz with Picket Fence Real Estate LLC, original listing - (620) 285-2951

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $410,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: --
Agency: Picket Fence Real Estate LLC
Agency Phone: (620) 285-2951

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 12 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2008
Notes: 5 bed 3 bath Stunning property spans approx. 12.5 acres +\~ approx. 1 mile north of Hanston Kansas offering breathtaking views of the Kansas countryside and wildlife. Immaculate ranch home, built in 2008, is nestled into the amazing landscape on the 12.5 acres, offering fantastic outdoor living spaces, wrap around porch, back deck and patio, above ground pool surrounded by wonderful established tree row offering a variety of species of trees and shrubberies. The home offers approx 2,970 sq ft of living area. The beautiful wrap around porch invites you to the property from the secluded drive with the home set back off the road allowing for amazing views of KS sunrises and sunsets!! The home welcomes you with foyer with amazing high ceiling and open to a lovely living area and kitchen that compliment the uniqueness of this custom~built home. The open concept with dining area, living area, kitchen are magnificent in this home, the beautiful chef’s kitchen offers stainless appliances, gas range, and large center island, fantastic for family living and entertainment The living area offers access to north deck and patio, again fantastic for entertaining and outdoor living The main floor offers a primary bedroom suite with, 4~piece primary bath, soaker bathtub, double vanity, water closet, and a large walk in closet. Also on the main floor you will find a bonus room giving an opportunity for a den, office, or bedroom. The large mudroom\laundry room completes the main floor, and is conveniently located off the kitchen leading to the garage, complete with laundry sink and great cabinetry. The basement provides an expensive family room, 3 additional bedrooms with egress windows, a full bath and mechanical storage room with an abundance of storage . The property also offers an amazing 40x60 pole shed with dirt flooring, 2 overhead doors, 2 walk in doors, 2 stall doors and 10 ft south facing overhang complete with fenced area, fantastic animals and livestock. The approx. 12.5 acres, outdoor space further offers apprx 8x16 garden shed with attached chicken coop. The four outside water hydrants and automatic lawn sprinklers enhance the lush lawn and gardens on the property. Additional amenities include central heat and air, water softener and R\O water filter, on demand water heater, a septic system and water well, Great access to recreational areas with Horse Thief Reservoir a quick 30 minute drive. This property is a wonderful private oasis in the Midwest, with the convenience of proximity to the community of Jetmore and an easy commute to surrounding communities including Dodge City, Garden City, Hays, Kinsley, and Larned Kansas..
MlsNumber: --
ListingId: 204419


Listing Provided By: Picket Fence Real Estate LLC, original listing
Phone: (620) 285-5887
Office Phone: (620) 285-2951
Agent Name: Lisa Schartz
Disclaimer: Copyright © 2025 Hays Multiple Listing Service. 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 = 934 AND i.igate IN ('usahud','mihud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mihud', 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;
Sarah Smith (Fabian Test Account)
ASCIIBetter Homes and Gardens Real Estate - Nicholson Group
Mobile: (241) 555-1812
Beware of the Bear - Look I am a Hooman

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App