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

1xx N. Hickory St. & N Linden Street
Royalton, MN 56373
Rob A Just with Legends Group Realty, Inc, original listing - (612) 703-3814

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $549,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: Legends Group Realty, Inc
Agency Phone: (612) 703-3814

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 26 acre(s)
Property Type: Land-Other
Year Built: --
Notes: Welcome to The Park on Platte River! Privacy, beauty, and rare natural surroundings encompass the 26.47 acres and over 2,200 feet of shoreline along the Platte River, all only blocks away from downtown Royalton. 5th Wheel Camper on-site is included in the price. This property is untouched, never developed, and only 20 minutes from St. Cloud and 15 minutes from Little Falls. With the 4 different zoning classifications, within the 26.47 acres, the possibilities are endless. Please view the Autocad screen shot images for zoning classifications. (The zoning boundaries are for visual description, and do not reflect current divisions of the 2 parcels. Two parcels are for sale within the 26.47 acres.) Enjoy your tour, it is a beautiful piece of virgin land. We have started some bug control, however as you can imagine, there are quite a few mosquitos right now. Zoning Descriptions: “Zone 1” = R-3, Multifamily Residential. “Zone 2” = R-1-A, Townhouse District - (Both “Zone 1 and 2” have utilities at the street.) “Zone 3” = R-2, Single and Two Family Res. - (this “Zone” has utility access near northeast corner of “Zone 1”.) “Zone 4” = A, Agricultural / Rural - (see attached FEMA Revision to see portion that is classified above the 500 yr flood zone within this “Zone”.) Information is reliable, but not guaranteed. Please do not walk the property without an appointment with ShowingTime. Use caution walking the property, and please close the gates after your tour. Owner is a Real Estate Broker in MN. A bordering single family home just sold for $572,000!
MlsNumber: --
ListingId: 6600021


Listing Provided By: Legends Group Realty, Inc, original listing
Phone: (612) 703-3814
Office Phone: (612) 703-3814
Agent Name: Rob A Just
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