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

0000 Rt 1
Welda, KS 66091
Preston Frazell with L2 Realty, Inc, original listing - (620) 577-4487

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $975,198
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: L2 Realty, Inc
Agency Phone: (620) 577-4487

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 232 acre(s)
Garage: Garage
Property Type: Land-Other
Year Built: --
Notes: Welcome to Bucks and Bushels. This farm, located in Anderson County in Southeast Kansas, gives one the unique opportunity to own a stunning 232-acre parcel that combines lucrative farmland and exceptional recreational features. This property has 160+/- acres of great income producing tillable. From boone & crockett deer, large strutting toms, and ducks and geese bombing the tillable acreage you will see why this property is a rare gem, offering a perfect blend of productivity and natural beauty. Normally I would begin with highlighting the farmland and return on investment, but recent trail cameras have shown a Boone and Crocket whitetail living on this property. As you will see in the videos and pictures, this whitetail will be one to impress even the most seasoned outdoorsman. After taking one look at the diverse landscape that this farm offers you will see why it will provide excellent deer and turkey hunting year after year making this property a sportsman's paradise. Aside the amazing hunting opportunities, the 160 t/- acres of tillable farmland is producing a great return for upland tillable. The current tenant has done a great job taking care of the land and would love the opportunity to continue to do so in the future. The high yielding crops and layout make it an excellent investment for any agricultural enthusiast or investor looking to capitalize on good returns. Moving back to the recreational side of things, close your eyes and invision this. You have just purchased the farm of your dreams and have placed your stands strategically on the various pinch points on this farm. You are sitting on the edge of Cedar Creek which runs through the middle of the property in a large hardwood 20 ft up. The morning starts off with a flock of turkeys coming off the roost and large group of ducks circling the field. As you are taking all of this in you suddenly hear a deep grunt and your heart about stops. You slowly turn your head looking down the mature hardwood corridor lining Cedar Creek to see the Booner that you have hundreds of pictures of headed directly to you. Now open your eyes and ask yourself this: Why wouldn't you want to make this a reality? The productive farmland and recreational amenities this property offers provides significant potential for both short-term income and long-term appreciation. The combination of agricultural productivity and natural features makes this farm a versatile investment opportunity. Don't miss out on this chance to own the farm of your dreams. Property highlights 160 t/- acres of the 232 farm currently in tillable acres Boone & Crockett whitetail documented living on this property currently (see pictures) Cedar Creek running through the heart of the property creating live water all year and great fishing opportunities Mature hardwoods along the creek Farm located just west of Welda, KS 4 miles 1 hour from KC, 2 hours 20 minutes from Wichita, 2 hours 39 minutes from Tulsa
MlsNumber: --
ListingId: 11351968


Listing Provided By: L2 Realty, Inc, original listing
Phone: (620) 577-4487
Office Phone: (620) 577-4487
Agent Name: Preston Frazell
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 = 894 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