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

1590 Smore Fun Way Sw
Nisswa, MN 56468
Carrie Lee with eXp Realty, original listing - (612) 751-9303

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,195,000
Beds: 5
Baths: Full: 1, ½: 2, ¾: 4
Status: Active
SqFt: 3573 Square Feet
Agency: eXp Realty
Agency Phone: (612) 751-9303

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: This stunning Mountain Modern Lakeside Loft offers 5 bedrooms, 7 bathrooms with three full stories of floor-to-ceiling glass for incredible Gull Lake views. Voted one of the best rental units in Minnesota by its current owner, this 2023 constructed loft sits within Quarterdeck Resort giving you access to all resort amenities, rental income opportunity and a true maintenance free and vacation-like lifestyle.<br /> <br /> Boasting 4000+ sq. ft. this loft features a spacious kitchen and dining area with two refrigerators, large island, and tastefully decorated great room with gas fireplace for family time. Also on the main level is a bedroom with en-suite bathroom. The upper level features an incredible primary bedroom with floor to ceiling monoslope, electric fireplace and a super unique tile shower showcasing the best sunrise lake views with its built-in window. The basement bunk room sleeps 4 with a charging station and reading light in each bunk. There is also a double king bedroom in the basement with en-suite bathroom, washer and dryer and cozy social space offering a card table, pool table, wet bar and electric fireplace. Star of the show is the private ROOFTOP BAR 35 feet up from Gull Lake with a gas fire pit, table with seating for ten, and grilling station. Owners can rent a boat slip while in house and enjoy their very own private lakeside wood-burning firepit.<br /> <br /> Loft #111 is part of the $20M+ resort expansion and renovation with year-round outdoor pool, hot tub, sauna, retro arcade, pickleball and more. This property is in the Quarterdeck Resort rental management program. The resort handles all critical management functions including marketing, reservations, check-in services, housekeeping, maintenance, security and revenue management. Historical and advanced revenue information is available upon request. <br /> <br /> Enjoy whole ownership of this incredible Lakeside Loft on the West side of Gull Lake for 42 days every Summer (May 1st – October 31st) and up to 100 days during the Winter season. Located right next door to Mount Ski Gull and the new Gull Lake trail system, plus other great area attractions just minutes away. Association Dues are as of 2024 and subject to change. Buyer's agent to verify all measurements.
MlsNumber: --
ListingId: 6587693


Listing Provided By: eXp Realty, original listing
Phone: (218) 820-4432
Office Phone: (612) 751-9303
Agent Name: Carrie Lee
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.


Local Real Estate Expert

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 = 1335 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;
Trent Mills
ASCIIWeichert Realtors Tower Properties
Call Today!: (218) 232-8432

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App