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

1447 Sunflower Rd
Everest, KS 66424
Mark Uhlik with Midwest Land and Home, original listing - (785) 325-2740

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $225,000
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1560 Square Feet
Agency: Midwest Land and Home
Agency Phone: (785) 325-2740

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1976
Notes: Open House & Inspections: Monday, September 23rd, 4-6 PM Thursday, September 26th, 1-3 PM This property features a beautiful home located off a paved road with an Established Windbreak, 42′ x 48′ Morton Building, and Fiberoptic Cable. Tract 2 Legal Description: (Homesite & Acreage) S10, T04, R18E, ESTIMATED ACRES 4.2+/- in E2/SE4 Directions: (Approximately 8 miles south of Robinson) From Highway 36/Robinson Exit, travel south through Robinson, then .5 miles south of RR tracts to 205 St. Turn east and travel for 1.25 miles to Sumac Rd. Travel south on Su-mac for 2.5 miles to 180th St. Travel east for .5 miles to Sunflower Road. Travel south on Sunflower Rd for 3.5 miles, and the property will be on your right (West). Watch for Signs! Main Level: 3 Bedrooms, Living and Dining room, Kitchen, Laundry, Master Bedroom, Bathroom, and Family room Full Unfinished Basement Property Features: # Conforming Bedrooms = 3 Total Bedrooms = 6 # Full Bathrooms = 2 # Half Bathrooms = 0 Fireplace = N/A Flooring = Carpet and Linoleum Water Source = Rural Interior Amenities = Wood Cabinets, Entry Foyer Exterior Amenities = Driveway, Two car Detached Garage, Shed, Barn, Double Pane Windows Personal Property Included: Refrigerator, Oven, Washer, Dryer, and Deep Freeze Property Specifications: Lot Size = 4.2 Acres Built = 1976 Style = Ranch Sq. Ft. = 1,560 Foundation/Basement = Full, Concrete, Unfinished Exterior = Vinyl Roof = Metal Windows = Double Pane Water/Sewer Type = Rural, Laterals Heating Type = Forced Heat Cooling Type = N/A Water Heater = Electric Sump Pump = N/A Electrical = Breaker Box Garage Type = Detached # Garage Stalls = 2 Driveway = Yes Outbuildings = Shed and Barn Fencing = N/A Survey Details: If Tract 1 and Tract 2 sell to separate buyers, a survey will be ordered and completed prior to the date of closing to determine their legal descriptions. The buyer of Tract 1 and the buyer of Tract 2 will split the survey cost equally. Tanking Survey has agreed to complete the survey, which is estimated to cost $2500 to $3000. ****ONLINE BIDDING REQUIRES PRE-REGISTRATION**** - REGISTRATION MUST BE COMPLETED NO LATER THEN 12:00 P.M. Friday October 4th, 2024. In addition to registering through our APP or on our website you will be required to fill out "Online Bidder Terms" found below in the "Attachments" section. You must return complete the online registration AND have this form back to us by email, mail, or delivered in person by the deadline. Please DO NOT delay in getting registered.
MlsNumber: --
ListingId: 11346633


Listing Provided By: Midwest Land and Home, original listing
Phone: (785) 325-2740
Office Phone: (785) 325-2740
Agent Name: Mark Uhlik
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 = 899 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