Looking for the hottest travel deals? Join the RealAdventures community and get a free travel newsletter full of ideas, hot deals and more.
See latest edition .
Sign-Up Today »
Bearskin Lodge
location_on Grand Marais, Minnesota | Hotels & Resorts
Beautiful Gunflint Trail cabin lodging on the edge of Minnesota's famed BWCAW. Open all year. Top-rated resort offers canoeing,kayaking,fishing,swimming,hiking, relaxing.70K of groomed x-country ski trails through the deep woods. Dog sled trips.Starting at
USD $150 per night
calendar_month Availability & Reservations
Surrounding Areakeyboard_double_arrow_up
Minnesota's historic Gunflint Trail area is located in the far northern tip of the Minnesota "arrowhead" region. We are the gateway to the Eastern section of the Boundary Waters Wilderness Canoe Area (BWCAW), one of the most pristine wilderness areas in the US. Moose, wolves, bears and loons abound.
Accommodationskeyboard_double_arrow_up
Our 11 cabins and 4 lodge townhouses are all different, copvering a wide range of prices from "simple and cozy" to "high end luxury." We offer lodging that lets you be close to the BWCAW experience, without camping on a rock. Our accomodations do not have televisions or phones; internet is available in the Main Lodge for your use, but not in the cabins. All cabins have wood burning stoves or fireplaces; lodges offer gas fireplaces. Every cabin has its own private dock. In winter all the cabins are close to ski trails.
Map & Directionskeyboard_double_arrow_up
124 E. Bearskin Rd., Grand Marais, Minnesota 55604
Points of Interest
Bearskin Lodge
124 E. Bearskin Rd., Grand Marais, Minnesota
Rooms/Suiteskeyboard_double_arrow_up
Please see our website to read more about each cabin.
Amenitieskeyboard_double_arrow_up
Sauna and hot tub house, both available for private use year 'round. Family dining or fine dining available on a schedule, depending on the season. See the website.
Services Offeredkeyboard_double_arrow_up
Massage therapist available several days or week, or by arrangement.
Policies & Restrictionskeyboard_double_arrow_up
All units are non-smoking. No pets, please.
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $150 per night
Bearskin Lodge
124 E. Bearskin Rd.
person_outline Hotels & Resorts Owner
credit_card Reservations
Listing # RA-1225225
Also of Interest Near
Similar Nearby Listings (See All ) keyboard_double_arrow_up
Featured Adventures Nearby (See All ) keyboard_double_arrow_up
Featured Accommodations Nearby (See All ) keyboard_double_arrow_up
Add Your Travel Services and Accommodations
Add a multi-page listing promoting your accommodations, tours or travel services to customers on our network of travel sites. Your listing page includes an interactive map, availability calendar, reviews, photo-gallery and more.
Create Your Listing
Time: 0.15 | Consuming 0.00 kb ........ common_miva_database.htm:52 (from: listing.htm:9 (from: (none):-1)) debug : Opening table common_stats ........ common_miva_database.htm:52 (from: listing.htm:9 (from: (none):-1)) debug : Opening table common_visitor_pages ........ common_miva_database.htm:52 (from: setup.htm:80 (from: listing.htm:9)) debug : Opening table accounts ........ common_miva_database.htm:52 (from: setup.htm:83 (from: listing.htm:9)) debug : Opening table common_visitors ........ common_miva_database.htm:52 (from: listing.htm:18 (from: (none):-1)) debug : Opening table listings_listings ........ common_miva_database.htm:186 (from: listing_setup.htm:30 (from: listing.htm:18)) debug : (0.00) : SELECT * FROM `listings_listings` WHERE `LISTING`=1225225 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:39 (from: listing.htm:18)) debug : Opening table accounts1 ........ common_miva_database.htm:186 (from: common_listing_advertiser_account.htm:23 (from: listing_setup.htm:39)) debug : (0.00) : SELECT * FROM `accounts` WHERE `EMAIL_NO`=707888 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table listings_info ........ common_miva_database.htm:186 (from: common_listing_tables.htm:7 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `listings_info` WHERE LISTING=1225225 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table type ........ common_miva_database.htm:186 (from: common_listing_tables.htm:23 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `type` WHERE `TYPE`="Accommodations: Hotels & Resorts" limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:56 (from: listing.htm:18)) debug : Opening table group ........ common_miva_database.htm:186 (from: common_listing_tables.htm:34 (from: listing_setup.htm:56)) debug : (0.00) : SELECT * FROM `group` WHERE `GROUP_ID`=2 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:57 (from: listing.htm:18)) debug : Opening table accounts1 ........ common_miva_database.htm:186 (from: listing_table_variables.htm:79 (from: listing_setup.htm:57)) debug : (0.00) : SELECT * FROM `accounts1` WHERE `EMAIL_NO`=707888 limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:69 (from: listing.htm:18)) debug : Opening table websites ........ common_miva_database.htm:186 (from: common_urls.htm:272 (from: listing_setup.htm:69)) debug : (0.00) : SELECT * FROM `websites` WHERE `WEBSITE_CODE`="RA" limit 1 ........ common_miva_database.htm:52 (from: listing_setup.htm:74 (from: listing.htm:18)) debug : Opening table geograph ........ common_miva_database.htm:52 (from: navbar.htm:151 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:151)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="H"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `REGION`="Grand Marais"
and `TYPE`="Accommodations: Hotels & Resorts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:154)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="H"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `REGION`="Grand Marais"
and `TYPE`="Accommodations: Hotels & Resorts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:158)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Z"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:161)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Y"
and `TYPE`="Accommodations"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar.htm:165)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="X"
and `TYPE`="Accommodations: Hotels & Resorts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:39)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="Z"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:45)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="X"
and `TYPE`="Accommodations: Hotels & Resorts"
and `GROUP_ID`=2
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:90)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="A"
and `CONTINENT`="North America"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:106)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:121)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="C"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_breadcrumb.htm:138)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="D"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `REGION`="Grand Marais"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:19)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:39)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Canada"
LIMIT 1 ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_north_america.htm:59)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="B"
and `CONTINENT`="North America"
and `COUNTRY`="Mexico"
LIMIT 1 ........ common_miva_database.htm:186 (from: navbar_select_destination_continents.htm:57 (from: navbar_select_destination.htm:17)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="A" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `CONTINENT` ........ common_miva_database.htm:186 (from: navbar_select_destination_states.htm:73 (from: navbar_select_destination.htm:21)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="C" and `CONTINENT`="North America" and `COUNTRY`="United States" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `STATE` ........ common_miva_database.htm:186 (from: common.htm:376 (from: navbar_select_destination_states.htm:119)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="C"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Washington, D.C."
LIMIT 1 ........ common_miva_database.htm:186 (from: navbar_select_destination_countries.htm:86 (from: navbar_select_destination.htm:25)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1 and `INDEX`="B" and `CONTINENT`="North America" and `LISTINGS_SHOW` and `DELETED` = 0 ORDER BY `COUNTRY` ........ common_miva_database.htm:52 (from: navbar.htm:219 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:186 (from: navbar_select_top_destinations.htm:184 (from: navbar.htm:219)) debug : (0.00) : SELECT * FROM `geograph`
WHERE 1=1
and `INDEX`="D"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `REGION`!=""
and `DELETED`=0
and `LISTINGS_SHOW`
ORDER BY `LISTINGS_SHOW` desc
LIMIT 20
........ common_miva_database.htm:52 (from: navbar.htm:222 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:52 (from: navbar.htm:222 (from: listing_setup.htm:74)) debug : Opening table geograph ........ common_miva_database.htm:186 (from: navbar_select_categories.htm:130 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="G"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `LISTINGS_SHOW`
and `DELETED`=0
ORDER BY `TYPE1`, `TYPE2`
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=2
and `TYPE1`="Accommodations"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=3
and `TYPE1`="Adventure Travel"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=7
and `TYPE1`="Fishing & Hunting"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=5
and `TYPE1`="Personal Growth & Educational"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=6
and `TYPE1`="Snow & Ski Vacations"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=10
and `TYPE1`="Tours"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:186 (from: navbar_select_categories.htm:218 (from: navbar.htm:222)) debug : (0.00) : SELECT * FROM `geograph` WHERE 1=1
and `INDEX`="F"
and `CONTINENT`="North America"
and `COUNTRY`="United States"
and `STATE`="Minnesota"
and `GROUP_ID`=21
and `TYPE1`="Travel Guides"
and `LISTINGS_SHOW`
and `DELETED`=0
limit 1
........ common_miva_database.htm:52 (from: listing_setup.htm:82 (from: listing.htm:18)) debug : Opening table listings_images ........ common_miva_database.htm:186 (from: listing_image_url.htm:63 (from: listing_setup.htm:82)) debug : (0.00) : SELECT * FROM `listings_images` WHERE `LISTING`=1225225 and `DELETED`=0 ORDER BY `ORDER_NO`, `IMAGE_NO` LIMIT 999 ........ common_miva_database.htm:52 (from: listing.htm:18 (from: (none):-1)) debug : Opening table listings_availability ........ common_miva_database.htm:186 (from: listing_setup.htm:92 (from: listing.htm:18)) debug : (0.00) : SELECT COUNT(*) as `TOTAL` FROM `listings_availability` WHERE `LISTING`=1225225 and `STATUS`!="available" and `DATE`>= "2022-06-26" ........ common_miva_database.htm:52 (from: listing_setup.htm:124 (from: listing.htm:18)) debug : Opening table listings_map ........ common_miva_database.htm:186 (from: listing_map_json.htm:104 (from: listing_setup.htm:124)) debug : (0.00) : SELECT * FROM `listings_map` WHERE `LISTING`=1225225 and `ADDRESS`!='' order by `MAP_ID` ........ common_miva_database.htm:186 (from: listing_map_pins.htm:17 (from: listing_setup.htm:125)) debug : (0.00) : SELECT * FROM `listings_map` WHERE `LISTING`=1225225 AND `DELETED`=0 ........ common_miva_database.htm:52 (from: listing_setup.htm:127 (from: listing.htm:18)) debug : Opening table listings_deals ........ common_miva_database.htm:186 (from: listing_hot_deals.htm:6 (from: listing_setup.htm:127)) debug : (0.00) : SELECT * FROM `listings_deals` WHERE `LISTING`=1225225 and `SHOWINFO`=1 order by `LAST_PAID_TIME` desc ........ common_miva_database.htm:186 (from: summary_listings.htm:167 (from: listing_nearby_options.htm:49)) debug : (0.03) : SELECT count(*) as `TOTAL`, 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(46.729553))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-94.685898 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.729553))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Hotels & Resorts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LATITUDE`
BETWEEN 46.729553 - (250 / 69)
AND 46.729553 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -94.685898 - (250 / (69 * COS(RADIANS(46.729553))))
AND -94.685898 + (250 / (69 * COS(RADIANS(46.729553)))) and `listings_listings`.`LISTING` not in (1019801, 1225225)
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:268)) debug : (0.00) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(46.729553))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-94.685898 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.729553))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Hotels & Resorts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`PSTATE`="Minnesota"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 46.729553 - (250 / 69)
AND 46.729553 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -94.685898 - (250 / (69 * COS(RADIANS(46.729553))))
AND -94.685898 + (250 / (69 * COS(RADIANS(46.729553)))) and `listings_listings`.`LISTING` not in (1019801, 1225225)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:295)) debug : (0.01) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(46.729553))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-94.685898 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.729553))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Hotels & Resorts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LAST_MGR_TIME` > 1561637735
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 46.729553 - (250 / 69)
AND 46.729553 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -94.685898 - (250 / (69 * COS(RADIANS(46.729553))))
AND -94.685898 + (250 / (69 * COS(RADIANS(46.729553)))) and `listings_listings`.`LISTING` not in (1019801, 1225225)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:321)) debug : (0.03) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(46.729553))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-94.685898 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(46.729553))
* SIN(RADIANS(`listings_listings`.`LATITUDE`))))) AS `DISTANCE` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`TYPE1`="Accommodations"
and `listings_listings`.`TYPE2`="Hotels & Resorts"
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`LATITUDE`
BETWEEN 46.729553 - (250 / 69)
AND 46.729553 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -94.685898 - (250 / (69 * COS(RADIANS(46.729553))))
AND -94.685898 + (250 / (69 * COS(RADIANS(46.729553)))) and `listings_listings`.`LISTING` not in (1019801, 1225225)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings.htm:194 (from: listing_nearby_options.htm:69)) debug : (0.00) : SELECT count(*) as `TOTAL` FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`PSTATE`="Minnesota"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1225225, 1107230, 1128278, 1225187, 1125620, 1206085, 1020435, 1205867, 1021556, 1286009, 1212361)
........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.00) : SELECT * FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`=2
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`PSTATE`="Minnesota"
and `listings_listings`.`LISTING` not in (1019801, 1225225, 1107230, 1128278, 1225187, 1125620, 1206085, 1020435, 1205867, 1021556, 1286009, 1212361)
ORDER BY `INDEXKEY`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:384)) debug : (0.00) : SELECT * FROM `listings_listings`
WHERE 1=1
and `listings_listings`.`SHOWINFO`=1
and `listings_listings`.`GROUP_ID`!=2
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PCONTINENT`="North America"
and `listings_listings`.`PCOUNTRY`="United States"
and `listings_listings`.`PSTATE`="Minnesota"
and `listings_listings`.`LISTING` not in (1019801, 1225225, 1107230, 1128278, 1225187, 1125620, 1206085, 1020435, 1205867, 1021556, 1286009, 1212361, 1225203, 1225204, 1214370, 1225181, 1022562, 1021667, 1021540, 1276257, 1022075, 1286753)
ORDER BY `INDEXKEY`
limit 0
, 10 ........ common_miva_database.htm:52 (from: listing_setup.htm:135 (from: listing.htm:18)) debug : Opening table listings_listings ........ common_miva_database.htm:186 (from: listing_nearby_options.htm:134 (from: listing_setup.htm:135)) debug : (0.00) : SELECT * FROM `listings_listings` WHERE `LISTING`=1225225 limit 1 ........ common_miva_database.htm:52 (from: listing_snippet.htm:75 (from: listing_template_full_home.htm:10)) debug : Opening table listings_amenities2 ........ common_miva_database.htm:186 (from: listing_key_amenities.htm:8 (from: listing_snippet.htm:75)) debug : (0.00) : SELECT * FROM `listings_amenities2` inner join `amenities1` using (`AMEN_ID`) WHERE `LISTING`=1225225 and `REQUIRED` ORDER BY `GROUP`,`AMENITY`,`VALUE` ........ common_miva_database.htm:52 (from: listing_template_full_home.htm:32 (from: listing_template.htm:93)) debug : Opening table listings_nearby ........ common_miva_database.htm:186 (from: listing_nearby.htm:9 (from: listing_template_full_home.htm:32)) debug : (0.00) : SELECT * FROM `listings_nearby` WHERE `LISTING`=1225225 ........ common_miva_database.htm:186 (from: listing_calendar.htm:56 (from: listing_template_full_home.htm:42)) debug : (0.00) : SELECT * FROM `listings_availability` WHERE `LISTING`=1225225 and `DATE`>="2022-06" Time: 0.15 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.
