Title Page Background
DEBUG FN args: Array ( [0] => 2399 [1] => [2] => [3] => agent ) BEFORE: Site: 2399 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2399 Igate: njhud LocID: 2399 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 e.expertIdNum = 1842626 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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2399 [1] => [2] => [3] => lender ) BEFORE: Site: 2399 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2399 Igate: njhud LocID: 2399 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 e.expertIdNum = -1 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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2399 [1] => [2] => [3] => other ) BEFORE: Site: 2399 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2399 Igate: njhud LocID: 2399 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 e.expertIdNum = -1 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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

6285 Dakota Ave
Madison, SD 57042

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $894,000
Beds: 4
Baths:
Status: Pending
SqFt: 3418 Square Feet
Agency: Hegg, REALTORS

Map Details Show Map | Show StreetView




House Features

Appliances: Microwave, Range, Refrigerator, Dryer
Architectural Style: Other
Flooring: Tile, Wood, Concrete
Heating: Hot Water, Fireplace
Interior Features: Main Floor Laundry, Lfd_equipment_13, 3+ Bedrooms Same Level, Formal Dining Rm
Rooms: Office, Basement, Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Dining Room, Kitchen, Laundry, Living Room

Window Features

Exterior Features: Landscaping, Gravel Drive, Concrete Drive, Additional Buildings, Shade Trees, Sprinkler Ungrd, 3-season Porch
Patio and Porch Features: Porch
Roof: Metal
View: Lake
Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Madison ES/Norman
Middle/Junior High School/District: /Madison Central 39-2
High School/District: Madison HS/Madison Central 39-2
Subvidision Name: No Subdivision

Description/Comments


Lot Size: 4 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1913
Notes: This beautifully restored 1913 Victoria home sits on nearly 5 acres overlooking Lake Madison. This home features 4 bedrooms, 2 bathrooms, a formal dining room, beautiful kitchen, library, living room with gas fireplace. The sunroom’s 180-degree view and the 3-season porch gives incredible views of the prairie and Lake Madison, never miss a sunrise or sunset. This home has a breezeway to the garage with its own A/C, fireplace and the laundry area. The over 3400 sq ft also features 5 stalls of heated garage/shop & a 30x40 storage shed at the side of the property. A few of the updates include metal shingles, new interior & exterior paint, new attached heated garage, dozens of new evergreen trees and a new lawn sprinkler system. This home has many wonderful old features, pocket doors, a banisters stairs with a two way entrance, a second set of stairs from level 2 to level 3’s finished Attic. This property is a gorgeous, one-of-a-kind home!
MlsNumber: --


Listing Provided By: Hegg, REALTORS, original listing
Phone: (605) 480-3418
Office Phone: (605) 336-2100
Agent Name: Justin Garry
Disclaimer: Copyright © 2024 Realtor Association of the Sioux Empire 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

DEBUG FN args: Array ( [0] => njhud [1] => 0 [2] => lake [3] => SD [4] => agent [5] => 1 ) BEFORE: Site: njhud LocID: 0 Region: lake State: SD Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 IFELSE else AFTER: Site: njhud Igate: njhud LocID: 0 Region: lake State: SD 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 e.expertIdNum = 1842626 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 = 'wihud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;
Real Estate Expert Photo for Virginia Hernandez
Virginia Hernandez
ASCIISelect Realty Group
Call Today!: (575) 888-0470

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App