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

500 North 6th Street
Marysville, KS 66508
Jessica Leis with Midwest Land and Home, original listing - (785) 325-2740

« Prev
Next »
Currently Displayed Property Photo


Property Details


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

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1890
Notes: Directions: From the intersection of Highway 36 and North 6th Street, travel North on North 6th Street for 3 Blocks to the intersection of North 6th Street and Calhoun Street, the property is located on the Northeast side of the intersection. Main Level: Entry Foyer, Dining room, Living room, Kitchen, Laundry, Master Bedroom, En Suite with Double Sinks, Enclosed Back Porch (Mudroom) Second Level: 5-Bedrooms, Bathroom, Storeroom with furnace Property Features: # Conforming Bedrooms = 6 Total Bedrooms = 6 # Full Bathrooms = 2 # Half Bathrooms = 0 Fireplace = N/A Flooring = Carpet, Laminate, & Tile Water Treatment Systems = N/A Interior Amenities = Ceiling Fans, Wood Cabinets, Laminate Countertops, Stainless Steel Sink, Tall Ceilings, Jetted Tub, New Plumbing (2016-17/2024) Exterior Amenities = Corner Lot, Covered Front Porch, Enclosed Back Porch, Back Deck Personal Property Included: Electric Oven/Range, Oven Hood, Dishwasher, Washer, & Dryer Property Specifications: Lot Size = 0.27 Acres Built = 1890 Style = Old Style, Two-Story Sq. Ft. = 2,325 Foundation/Basement = Crawl Space Exterior = Vinyl (2020) Roof = Asphalt Shingles (2016, Owens Corning Class 4 Duration Storm) Windows = Double Pane (2017/2019) Water/Sewer Type = City Water/City Sewer Fuel = Natural Gas Heating Type = 2 Central Forced (2016/2024) Cooling Type = 2 Central Forced (2016/2024) Water Heater = Electric Sump Pump = N/A Electrical = Breaker Box Garage Type = N/A # Garage Stalls = N/A Driveway = Off-Street Parking Outbuildings = N/A Fencing = N/A School District = USD 364 County = Marshall 2024 Property Taxes: $2,111.74 CLOSING AND POSSESSION: Possession of the above-described real estate shall be delivered to Buyer(s) on the date of final closing. Closing shall take place at a time and date mutually agreed to by the parties, on or before as soon as the buyer is able from the date of contract execution, unless extended by mutual agreement of the parties.
MlsNumber: --
ListingId: 11390214


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