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

300 Praire Avenue
Sharon Springs, KS 67758
Ernesto Knelsen with Farm & Ranch Realty, Inc., original listing - (785) 462-3904

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $495,000
Beds: 3
Baths: Full: 3, ½: 1
Status: Active
SqFt: 4219 Square Feet
Agency: Farm & Ranch Realty, Inc.
Agency Phone: (785) 462-3904

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential-Single Family Residence
Year Built: --
Notes: Experience the charm of this stunning stucco and stone property, offering a blend of modern amenities and country living. This spacious home boasts 3 bedrooms, 2 bonus rooms that can serve as additional bedrooms, 3 full bathrooms, and 1 half bath. Perfectly designed for comfort and convenience, the property includes two kitchens, heated floors, a sprinkler system, instant hot water, and two water softeners. The main level features a large kitchen equipped with a glass cooktop, double ovens, granite countertops, and abundant cabinet space. Adjacent to the kitchen, you'll find a dining room, a family room with a wood burning fireplace, a half bathroom, and a second kitchen complete with a 6-burner gas range, double sinks, refrigerator, and granite countertops. The master bedroom is also conveniently located on the main floor. Upstairs, there are 2 bedrooms, 2 bonus rooms (used as bedrooms), a full bathroom, and a laundry room, offering ample space for family or guests. The walkout basement provides even more functionality, with a large family room, kitchenette, full bathroom, a storage room, and direct access to the backyard. Outside, you'll find a covered patio, an open patio, and two firepitsone gas and one wood-burning perfect for entertaining or relaxing in the serene surroundings. This property also includes a 3-car attached garage with a wash bay and washer & dryer hookup and a separate 40'x54' three-door Vap building w/concrete floor, and ample space for vehicles & storage. Additionally, there is small acreage suitable for farm animals. Located on the southwest edge of Sharon Springs, KS, in a quiet neighborhood, the home is within walking distance of the local swimming pool and city park. While situated within city limits, the property offers the feel of country living.Please call Erny Knelson at 620-927-0043 to schedule a showing.
MlsNumber: --
ListingId: 85141


Listing Provided By: Farm & Ranch Realty, Inc., original listing
Phone: (785) 462-3904
Office Phone: (785) 462-3904
Agent Name: Ernesto Knelsen
Disclaimer: Copyright © 2024 Kansas Property Ads. 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 = 992 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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
Cell: (241) 555-1812

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App