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

137 S 5th Avenue
Burwell, NE 68823
Ashley PIttman with Stracke Land & Realty, original listing - (402) 340-2990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $245,000
Beds: 2
Baths: Full: 1
Status: Active
SqFt: 768 Square Feet
Agency: Stracke Land & Realty
Agency Phone: (402) 340-2990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 sqft
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1930
Notes: 2 Bed | 1 Bath | 768 sq.ft. (768 sq.ft. basement) & 1 Bed | 1 Bath Mother-in Law House 396 sq.ft Nestled just 7 miles from the tranquil beauty of Calamus Reservoir State Park and within walking distance of the bustling town square, this beautifully renovated property offers the perfect blend of modern amenities and classic charm. The main house features 768 sq ft of living space on the main floor, with a half-finished basement providing additional room for customization. Recent renovations include a newer roof, windows, siding, screened front porch with composite floor, central heating and air conditioning, fresh drywall, refinished original hardwood floors, and a fully updated kitchen and bathroom. Adding to the property's appeal is a newly constructed 16' x 36' garage with a 12-foot door, along with a cozy screened-in porch-ideal for enjoying quiet evenings. Storage is plentiful throughout the property, ensuring ample space for all your belongings. The separate 396 sq ft Mother-In-Law house offers a comfortable living area with one bedroom, a living room, bathroom, and a small kitchen area, perfect for hosting guests, accommodating extended family, or generating rental income. Both homes come fully furnished, making them move-in ready and saving you the hassle of furnishing them yourself. Security and convenience are paramount in this home, featuring alley access, keyless entry on multiple doors, and a fenced yard that provides privacy and safety for both children and pets. Tech-savvy buyers will appreciate the direct fiber connection for high-speed internet and Wi-Fi throughout the house, complemented by a Wi-Fi thermostat for effortless climate control. Additionally, the property is equipped with a Bluetooth watering system for the lawn, making yard maintenance simple and convenient. This property isn't just a house; it's a welcoming sanctuary that effortlessly combines convenience, comfort, and charm. From its lush lawn to the thoughtfully integrated amenities, every aspect of this home whispers "Welcome Home." Don't miss the opportunity to experience all that this exceptional property has to offer. Be sure to reach out for more information or to schedule a showing. ***Mother-in Law House is labeled as 137 Half S 5th Ave., Burwell for disclosures. Taxes 2023: $2,151.38 Average Utilities: Water/Sewer/Trash/Electricity Main House - $134.62 Electricity/Trash Mother in Law House - $78.19 Approximate Dimensions: Main House Front Porch (screened in, composite flooring) 6' x 23'4" Main Bedroom 9'11" x 9' 7" Living/Dining Room 13' x 22'9" Storage Area 2'5" x 2'9" Bathroom 5'9" x 6'7" Second Bedroom 9' 10" x 8'11" Basement Area One 9'10" x 18'11" Basement Area Two 7'9" x 10'5" Basement Storage/Utility Room 13' x 25' Mother-in Law House Kitchen 8'1" x 9'9" Living Room 7'4" x 21'1" Bedroom 9'5" x 8'6" Bathroom 5'7" x 4' Garage 16' x 36' with 12' Tall door Garden Shed
MlsNumber: --
ListingId: 11339161


Listing Provided By: Stracke Land & Realty, original listing
Phone: (308) 730-4430
Office Phone: (402) 340-2990
Agent Name: Ashley PIttman
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 = 1693 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