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

12 & J Rd
Stockton, KS 67669
Stacy Johnson with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $384,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 156 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Located just 1.5 miles from Webster Reservoir, this 156 acres of fertile, tillable farmland offers a rare opportunity for agricultural use with the added benefit of being in close proximity to one of the region's recreational destinations. Whether you are a farmer seeking productive land or an outdoor enthusiast looking for a property near water-based activities, this property delivers both functionality and recreation in one ideal location. This quarter section is currently being farmed using a rotation to produce income annually. Webster Lake, located in Rooks County in Northwest Kansas, is a popular spot for outdoor enthusiasts, offering a variety of recreational activities. The lake and surrounding area provide a great combination of water sports, wildlife, and nature-based activities. Here's a breakdown of the recreational opportunities available at Webster Lake: 1. Fishing Webster Lake is known for excellent fishing opportunities. The lake is stocked with various fish species, making it a great spot for both beginner and experienced anglers. Popular species include: Walleye Crappie Bass Channel Catfish Bluegill Fishing can be done from the shoreline or from a boat, making it a versatile location for anglers. The lake's fishing conditions attract both locals and visitors year-round. 2. Boating The lake is ideal for boating, offering a large area of water for all kinds of boating activities, from leisurely cruises to more active water sports. Webster Lake has a boat ramp and is popular for: Kayaking & Canoeing Water Skiing & Wakeboarding Motorized Boating Whether you're looking to enjoy a peaceful day on the water or engage in more adrenaline-pumping activities, Webster Lake provides ample space and calm waters for it. 3. Waterfowl Hunting Webster Lake is a prime destination for waterfowl hunting, especially during migration seasons. The lake and its surrounding wetlands attract a variety of migratory birds, including: Duc Geese This property consists of fertile, tillable farmland, ideal for agricultural production, featuring high-quality soil suited for a variety of crops. The land is well-maintained and has been consistently productive, supporting crops such as corn, soybeans, wheat, or other region-specific crops. The topography is flat to gently rolling, providing efficient water drainage and ease of cultivation. In addition to its agricultural potential, the property also contains producing oil wells. These wells are strategically located within the boundaries of the property or in close proximity, tapping into underlying petroleum reserves. The presence of producing oil wells provides an added revenue stream, making this a dual-purpose investment opportunity: both for farming and energy production.
MlsNumber: --
ListingId: 11398176


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Stacy Johnson
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 = 974 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