Title Page Background
DEBUG FN args: Array ( [0] => 2371 [1] => [2] => [3] => agent ) BEFORE: Site: 2371 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2371 Igate: njhud LocID: 2371 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2371 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2371 [1] => [2] => [3] => lender ) BEFORE: Site: 2371 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2371 Igate: njhud LocID: 2371 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2371 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2371 [1] => [2] => [3] => other ) BEFORE: Site: 2371 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2371 Igate: njhud LocID: 2371 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 2371 AND i.igate IN ('nwhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nwhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

309 High Ave Nw
Wagner, SD 57380
Mitch Breen with Hayden Outdoors Real Estate, original listing - (970) 674-1990

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $179,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1600 Square Feet
Agency: Hayden Outdoors Real Estate
Agency Phone: (970) 674-1990

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1948
Notes: This remodeled, 1,600 square foot home in Wagner, South Dakota, offers a perfect blend of modern conveniences and cozy living. The property features three bedrooms and two updated bathrooms. The semi-open concept allows for natural light, creating a warm and inviting atmosphere throughout the home. A spacious 16x20 shed also sits on the property. It is a perfect spot to store vehicles, boats or use as additional storage. Outside, the property boost a well-maintained yard with mature trees that provide shade over the entire backyard. The front yard overlooks a baseball diamond where you can easily enjoy watching games from your yard on those summer nights. All of the following items have been updated and remodeled in the High Avenue Bungalow in 2024-2025. Electrical Plumbing Exterior (siding, windows, asphalt shingles, decks, soffit and fascia, 6' seamless gutters) Heating System (propane furnace and ductwork) Flooring (refinished oak, carpet in basement and karndean in kitchen) Insulation (Blow In) Appliances (stackable washer/dryer, stainless steel dishwasher, Refrigerator and Stove) Kitchen (cabinets, countertops and sink) Bathrooms (vanities, toilets and showers) Sheetrock Paint Shed (re-tinned) Wagner, South Dakota, is a small town that offers a variety of recreational activities for residents and visitors alike. Fishing and Boating: The nearby Missouri River is a popular spot for fishing and boating. Anglers can try their luck at catching species such as walleye, northern pike, and catfish. The river also offers scenic views and opportunities for leisurely boat rides. Hiking and Biking: The area around Wagner features several trails suitable for hiking and biking. These trails often provide beautiful views of the plains and the river, making them ideal for outdoor adventures. Hunting: The region is known for its abundant wildlife, making it a great destination for hunting enthusiasts. From pheasant hunting in the fall to deer hunting in the winter, there are opportunities for both experienced hunters and beginners. Sports: Wagner has recreational facilities that cater to various sports, including baseball, softball, and basketball. Community events and leagues often take place at local parks ant he town Armoury. Local Events: throughout the year, Wagner hosts various community extents and festivals, which often include recreational activities, games, and outdoor gatherings. Labor Day happens to be a huge event in Wagner! Overall, Wagner's recreational offerings provide a mix of outdoor adventure and community engagement, making it an appealing destination for those who appreciate the beauty of South Dakota landscape. Wagner experiences a humid continental climate characterized by four distinct seasons, Summer. Autumn, Winter, and Spring. The climate supports a variety of seasonal outdoor activities, from summer fishing and hiking to winter sports and autumn harvest festivals, making it a community that celebrates the changing seasons.
MlsNumber: --
ListingId: 11486620


Listing Provided By: Hayden Outdoors Real Estate, original listing
Phone: (970) 674-1990
Office Phone: (970) 674-1990
Agent Name: Mitch Breen
Disclaimer: Copyright © 2025 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App