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

N10149 Solberg Lake Road East
Phillips, WI 54555
Travis Ploman with NextHome Leading Edge, original listing - (715) 355-5577

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,950,000
Beds: --
Baths: --
Status: Active
SqFt: --
Agency: NextHome Leading Edge
Agency Phone: (715) 355-5577

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 11 acre(s)
Property Type: Commercial Sale-Other
Year Built: 1940
Notes: **Welcome to Comfort Cove Resort – A Premier Waterfront Retreat on Solberg Lake** Nestled on the serene shores of Solberg Lake in Phillips, WI, Comfort Cove Resort is a unique opportunity for those seeking a blend of natural beauty and business potential. This exceptional property features well over 2,000 feet of pristine lake frontage, providing breathtaking views and direct access to the tranquil waters of Solberg Lake. It is also located directly on the snowmobile trail making this a year-round resort for all outdoor enthusiasts. The resort is equipped with a pontoon and fishing boat rentals, including docks and a boat landing. Fishing aficionados will appreciate the well-appointed fish cleaning house, designed for ease and efficiency. There is an onsite bar and restaurant ready to be re-opened where guests can enjoy delightful meals and refreshing drinks, creating a perfect spot to relax and socialize. The kitchen has been recently updated with all new equipment! Comfort Cove Resort also offers a diverse range of accommodations, with 48 permanent campsites and a selection of six cabin rentals that cater to various needs and preferences. There’s even a well-appointed single-family home for owners to occupy or be<br /> used as another rental. There is a new 50x80 shop with in-floor heat, 12-foot overhead doors, office space and plumbing including two shower rooms for guest use. Additional outbuildings provide plenty of storage for the rental boats, resort supplies and equipment. The property provides ample space for gatherings and events. With the opportunity to increase revenue through<br /> extended operating hours and full utilization of all amenities, Comfort Cove Resort presents a promising venture for investors or those seeking a rewarding lifestyle change. Don’t miss the chance to own this exceptional resort, where stunning lakefront views and extensive facilities combine to offer a truly unique and lucrative opportunity. This information is compiled from miscellaneous sources and is believed accurate but not warranted. Neither the listing broker nor it's agents, sub-agents or property owner are responsible for the accuracy of the information. Buyers are advised to verify all information. Electronic earnest money through TrustFunds is now available. TrustFunds will charge a $5 convenience fee to the buyer for the use of this service.
MlsNumber: --
ListingId: 22403950


Listing Provided By: NextHome Leading Edge, original listing
Phone: (715) 573-0337
Office Phone: (715) 355-5577
Agent Name: Travis Ploman
Disclaimer: Copyright © 2024 NextHome, Inc. 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