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 = 1334 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1334 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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 = 1334 AND i.igate IN ('usahud','mnhud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'mnhud', 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;

54832 County Road 3
Mountain Lake, MN 56159
Brad Hanson with Hanson Agency, original listing - (507) 427-3500

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $565,000
Beds: 5
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3312 Square Feet
Agency: Hanson Agency
Agency Phone: (507) 427-3500

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 4 acre(s)
Garage: Garage
Property Type: Farm-Farm
Year Built: --
Notes: Very nice and unique acreage located north of Mountain Lake on a tar road. Acreage is approx. 4.5 acres and offers a tar driveway up to the home. Home has 5 bedrooms, 4 bathrooms, and offers Scandinavian styling throughout. Hard wood floors, redwood vaulted ceilings, balcony overlooking the foyer, and a beautiful kitchen with custom cabinets, peninsula, and storage galore. Formal Dining has glass doors, and additional storge with built in drawers and cabinets. Master bedroom in on the main floor, has sky lights, vaulted ceilings, and 2 large double closets and a walk-out to a private deck. Off the master bedroom is the master bathroom with 2 large vanities, bath-tub and a separate shower. The main floor and basement each have their own living rooms with gas fireplace inserts in brick settings with built in shelving. The upper level has a balcony area overlooking the foyer, 2 bedrooms and a remodeled bathroom with a custom tile and teak wood vanity. Basement is mostly finished with garden view windows, 2 bedrooms, bathroom, summer kitchen, and areas of additional storage. Outside the home are large covered decks offering shaded areas for patio furniture. Outbuildings include 2 pole barns; 48x78 has 14' sidewalls with dirt floor, electricity and water; 60x60x16 with partial cement floor, electricity and water and a 22x42 storage shed. Property is hooked up to rural water and has a compliant septic. A true must see property with so much to offer.
MlsNumber: --
ListingId: 11346652


Listing Provided By: Hanson Agency, original listing
Phone: (507) 427-3500
Office Phone: (507) 427-3500
Agent Name: Brad Hanson
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App