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

3704 Se 4th Street
Columbus, KS 66801

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $519,900
Beds: 4
Baths: 3
Status: Active
SqFt: 1692
Agency: C.S. NELSON CO.

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 3 acre(s)
Property Type: Residential
Year Built: 1982
Notes: LOCATED JUST SOUTHEAST OF COLUMBUS, THIS PROPERTY PROVIDES A BLEND OF HOME, THE GREAT OUTDOORS AND POSSIBLE HOME BASED BUSINESS OPPORTUNITIES, ALL IN ONE UNIQUE PROPERTY WITH 3.2 ACRES OF LAND. THE NEATLY UPDATED HOUSE HAS 4 BEDROOMS AND 3 BATHROOMS AND HAS BEEN METICULOUSLY MAINTAINED. IT OFFERS AN OPEN LIVING ROOM, DINING, AND KITCHEN FLOOR PLAN WITH NEW PLANK FLOORING. THE ROOMY KITCHEN FEATURES INCLUDE A BEAUTIFUL CUSTOM QUARTERSAWN OAK CABINETRY A LARGE CENTER ISLAND AND A WALK-IN PANTRY. THE MAIN FLOOR LAUNDRY + CONVENIENT AND AMPLE STORAGE SPACE ARE ADDED BONUSES. THE MASTER SUITE OFFERS HIS AND HER FULL BATHROOMS OR THEY CAN BE SEPARATED FOR GUESTS AND A SPACIOUS WALK-IN CLOSET. UNWIND AND RELAX IN THE SPACIOUS FENCED BACKYARD ON THE INVITING PAVER PATIO WHERE YOU CAN ENJOY PEACEFUL COUNTRY LIVING AND STILL BE JUST MINUTES FROM COLUMBUS. THE HOME HAS A HUGE 30’ X 28’ ATTACHED GARAGE AND THE PROPERTY INCLUDES FOUR OUTBUILDINGS - A PERFECT FIT FOR THE HOBBYIST / CRAFTSMAN. THE MAIN OUTBUILDING IS 60' X 57' WITH 220-VOLT POWER AND 3 OVERHEAD DOORS. THE SECOND OUTBUILDING IS 40‘ X 32’ AND IS INSULATED, WITH THE INTERIOR FINISHED IN METAL & PEGBOARD AND INCLUDES CABINETRY, LED LIGHTING + 2 OVERHEAD DOORS. THE THIRD OUTBUILDING IS 40' X 20' WITH 3 OVERHEAD DOORS. ALSO INCLUDED IS A 14' X 9' UTILITY BUILDING WITH A ROLL UP DOOR, ALONG WITH A FENCED KENNEL AREA. ALL OUTBUILDINGS HAVE CONCRETE FLOORS. A NICE SHELTERBELT, MANY ESTABLISHED LARGE TREES, PERENNIAL PLANTS AND FRUIT TREES GIVE THIS PROPERTY A PARK-LIKE FEEL.
MlsNumber: 20240061


Listing Provided By: C.S. NELSON CO., original listing
Name: C.S. NELSON CO.
Phone: (402) 562-8244
Office Name: C.S. NELSON CO.
Office Phone: (402) 562-8244
Agent Name: CHRIS NELSON
Disclaimer: Copyright © 2024 Columbus Board of Realtors MLS (NE). 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 = 948 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;
Real Estate Expert Photo for Sarah Smith
Sarah Smith
ASCIIGeneric Real Estate
Cell: (241) 555-1812
Office: (241) 555-1776

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App