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

13827 R Road
Osceola, NE 68651
CHRIS NELSON with C.S. NELSON CO., original listing - (402) 562-8244

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $524,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: --
Agency: C.S. NELSON CO.
Agency Phone: (402) 562-8244

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Property Type: Residential-Single Family Residence
Year Built: 1978
Notes: FIRST TIME EVER ON THE MARKET FOR THIS ONE-OWNER ACREAGE! CUSTOM BUILT AND NEATLY UPDATED THROUGHOUT, PRIDE OF OWNERSHIP SHOWS EVERYWHERE IN THIS SPACIOUS 3 BEDROOM, 2 BATH RANCH SITUATED ON A PEACEFUL 4.53 ACRE SITE! KITCHEN FEATURES INCLUDE NEW CABINETRY WITH DISPLAY LIGHTING, QUARTZ COUNTERTOPS, JENN-AIR GRILL/RANGE, UNDERMOUNT SINK, RECESSED LIGHTING, HICKORY FLOORING AND A CONVENIENT DESK AREA. MAIN FLOOR LAUNDRY AND BATHROOM ARE LOCATED JUST OFF THE KITCHEN NEAR THE REAR ENTRANCE. BOTH BATHS ARE NICELY UPDATED AND THE MAIN BATH HAS A HEATED FLOOR, QUARTZ COUNTERTOP AND UNDERMOUNT SINKS. THE LIVING ROOM HAS LARGE WINDOWS FOR MORNING SUN AND A BEAUTIFUL ELECTRIC FIREPLACE. ESTABLISHED TREES PROVIDE MORNING SHADE FOR RELAXATION ON THE SPACIOUS 20 X 20 REDWOOD DECK AND EVENING SUN IS SHIELDED BY THE HOME. THE WELL ILLUMINATED AND INSULATED SHOP BUILDING MEASURES 63' X 60' AND HAS TWO LARGE OVERHEAD DOORS, A CONCRETE FLOOR AND 220 VOLT SERVICE. THE LIVING AREA OF THE HOME HAS 2X6 WALLS AND ANDERSEN ARGON FILLED WINDOWS FOR QUIETNESS AND ENERGY EFFICIENCY. THE ROOMY 24' X 24' ATTACHED GARAGE IS INSULATED AND HAS A 220 VOLT HEATER. THE ELECTRICAL SERVICE TO THE HOME IS CONFIGURED FOR EASY CONNECTION TO A GENERATOR IN CASE OF A POWER OUTAGE. THE 500 GALLON PROPANE TANK IS OWNED AND WILL STAY WITH THE PROPERTY. FREEZER IN BASEMENT WILL ALSO REMAIN WITH THE HOME.
MlsNumber: --
ListingId: 20240307


Listing Provided By: C.S. NELSON CO., original listing
Phone: (402) 562-8244
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 = 1729 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