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

20006 600th Rd
Neodesha, KS 66757
Andrew Kattenberg with L2 Realty, Inc, original listing - (620) 577-4487

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $150,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: 2250 Square Feet
Agency: L2 Realty, Inc
Agency Phone: (620) 577-4487

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 1 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1900
Notes: This farmhouse is being sold "as-is," and the seller will NOT be making any repairs. Discover the endless potential of this charming farmhouse, offered "as-is" and awaiting your creative touch to restore it to its former glory. Imagine the possibilities with this property as your blank canvas, whether you dream of a cozy family homestead, a serene weekend getaway, or a charming bed and breakfast. This is your opportunity to bring your vision to life and create something truly special. This place just needs its finishing touches put on it to be perfect. The buyer could live in it while they finished up. Nestled on a generous 1.7-acre lot in the tranquil countryside, this home offers the perfect blend of peaceful rural living and convenient access to modern amenities. Located just a short drive from Neodesha, KS, you can enjoy the best of both worlds. The property's location within the Neodesha school district adds tremendous value, providing eligibility for the Promise Program, which offers significant educational benefits for your children. This spacious farmhouse boasts over 2,200 sq ft of living space, featuring 4 bedrooms and 2.5 baths. The thoughtful layout includes an upstairs bathroom, ensuring convenience and privacy for guests or children. With ample room for the whole family and even space for the in-laws to visit, this home is designed to accommodate all your needs. Imagine waking up to the serene sounds of nature, sipping your morning coffee on the porch, and watching your children play in the expansive yard. Envision hosting family gatherings and creating cherished memories in a home that you have lovingly restored. The farmhouse's potential is limited only by your imagination. Don't miss this rare opportunity to own a piece of the countryside, where you can create a legacy and enjoy a lifestyle that combines the charm of rural living with the benefits of modern convenience. Seize the chance to transform this property into your dream home and experience the joy of bringing it back to its glory days. Act now and make this farmhouse your own, where the possibilities are truly endless! As-Is" Sale- The seller will not make any repairs. Potential for Restoration- Ideal for those looking to restore and rejuvenate. Versatile Uses Perfect for a family homestead, weekend getaway, or charming bed and breakfast. Spacious Living- Over 2,200 sq ft with 4 bedrooms and 2.5 baths. Generous Lot- Situated on 1.7 peaceful acres in the countryside. Close to Neodesha, KS Educational Benefit- Located within the Neodesha school district, eligible for the Promise Program. Create Lasting Memories- Opportunity to host family gatherings and make cherished memories. Endless Potential- A blank canvas limited only by your imagination. Rare Opportunity- A chance to own a piece of the countryside and create a lasting legacy.
MlsNumber: --
ListingId: 11345044


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