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

2493 260 Rd.
Webber, KS 66970
Cody VonLintel with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $329,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2350 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 18 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: This listing features a spacious country home located within 1 mile of Lovewell State Park and Lovewell Lake in Jewell County, Kansas. The entire property consists of 18.6 acres, including 10 acres of productive cropland.     The house is estimated to be around 2350 square feet. It includes 5 bedrooms and 3 bathrooms. One of the bedrooms could serve as a studio apartment as it has a separate entrance, kitchenette and its own bathroom. Additional features of the house include the following: 2 living rooms. 2 fireplaces An office. Greenhouse room. 2 sun rooms. Attached 2 car garage. Partial unfinished basement (mechanical room). Metal roof. 2 patios (1 large patio in the front, 1 small patio in the back). Utilities: water well, septic system and propane. High speed internet, fiber optic. The current owners have done several major renovations inside the house including the kitchen and one of the bathrooms. The house is currently being used as an AirBNB. It is rented out on a regular basis and is a popular destination due to its accommodating size and convenient location to Lovewell Lake. The house would make a great hunting lodge for an outfitter/guide service. The acreage is an added bonus as it provides plenty of room for activities such as target practice or training/exercising hunting dogs. This property would also be ideal for a group of hunters or fisherman. It is setup perfectly for hosting and entertaining large groups. Lastly, it would be a wonderful place for a large family looking for a quiet place in the country with plenty of room to roam. This area is very well known for its excellent hunting and recreational activities. Lovewell Lake provides tremendous opportunities year round for avid outdoorsmen and fishermen alike. At capacity, Lovewell Lake encompasses nearly 2,986 water surface acres and 44 miles of shoreline. Fishing at Lovewell is year-round and the species of fish includes: walleye, white bass, wiper, crappie, channel cat and flatheads. The lake has also become an attractive site for many different species of wildlife. It attracts large numbers of migrating waterfowl in spring and fall. Public hunting access for deer, waterfowl and upland game is available. Check KDWP website for details. The property is located 2 miles from Webber, KS, 9 miles from Superior, NE and 30 miles from Belleville, KS. If you have any questions or would like to tour the property please give me a call. Shown by appointment only. Financial verification will be required prior to the showing.
MlsNumber: --
ListingId: 11337082


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (785) 735-4895
Office Phone: (970) 674-1990
Agent Name: Cody VonLintel
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

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 = 937 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