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

20354 Ann River Drive
Arthur Twp, MN 55051

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $499,900
Beds: 3
Baths:
Status: Active
SqFt: 1425 Square Feet
Agency: National Realty Guild

Map Details Show Map | Show StreetView




House Features

Appliances: Cooktop, Dishwasher, Washer, Microwave, Refrigerator, Garbage Disposer, Dryer, Water - Softener
Architectural Style: Other
Heating: Forced Air
Rooms: Bathroom 1, Bathroom 2, Bedroom 1, Bedroom 2, Bedroom 3

Window Features

Exterior Features: VINYL, Brick/Stone
Parking Features: Garage, Driveway, Garage - Attached
Roof: Shingle, Asphalt
Waterfront Features: Waterfront

Neighborhood/Schools

Elementary School/District: Canyon
Middle/Junior High School/District: Canyon
High School/District: Canyon
Subvidision Name: Strandlunds Ann River Estate

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1988
Notes: Welcome home to an amazing lakefront property on Fish Lake in in Mora, just 90 minutes from the Twin Cities! Enjoy the lake year-round! Multi-level 3BR/2BA home situated along 200 feet of lakeshore with an amazing walkway down to the dock (included!). Home boasts 2 living rooms, lg bedrooms, Owners suite w/ huge walk-in closet! En-suite bathroom has been updated with new separate ceramic tiled shower. A lg. jacuzzi whirlpool bath for those cold winter nights! Walk out from your family room into the 4 season porch, then straight out to the deck with panoramic views of the lake. Beautiful mature trees surround the property. The backyard is fenced in for the kids and/or pets and provides plenty of privacy, while maintaining your lakeview. Fish Lake is connected to the Ann River system so there are plenty of fish for all. New roof and siding and front pillars installed in 2018. Add Pontoon for 14K!
MlsNumber: --


Listing Provided By: National Realty Guild, original listing
Phone: (651) 330-8001
Office Phone: (651) 330-8001
Agent Name: Tammy Montray
Disclaimer: Copyright © 2024 Regional Multiple Listing Service of Minnesota [NorthStarMLS]. 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