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 »
Montana Adventure, Luxury & Relaxation
location_on Polaris, Montana | Hotels & Resorts
We offer fun, affordable, flexible itineraries on all of our Montana vacations. New showcase guest lodge, meals, fishing, horseback riding, big game hunting and winter snowmobile rentals. Established in 1979, experienced guides, friendly staff!Starting at
USD $99 per night
calendar_month Availability & Reservations
Map & Directionskeyboard_double_arrow_up
7501 Pioneer Mountain Scenic Byway, Polaris, Montana 59746
Points of Interest
Montana Adventure, Luxury & Relaxation
7501 Pioneer Mountain Scenic Byway, Polaris, Montana
Nearby Attractions and Serviceskeyboard_double_arrow_up
Distance Description 15 miles Bannack Ghost town 35 miles Chief Joseph Battle Grounds 10 - 60 miles Lewis & Clark sights 75 miles Nevada - Virginia cities 75 miles Lewis & Clark Caverns 130 miles Yellowstone National Park
Rates & Availabilitykeyboard_double_arrow_up
(All rates in USD $) From/To Low High Notes January To December 65 Inquiry
*Please
contact advertiser for rates & availability for your travel dates.
Amenitieskeyboard_double_arrow_up
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $99 per night
Montana Adventure, Luxury & Relaxation
7501 Pioneer Mountain Scenic Byway
person_outline Russ Kipp
Montana High Country Lodge
credit_card Reservations
Listing # RA-1021342
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.13 | 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`=1021342 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`=574887 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=1021342 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`=574887 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`="Montana"
and `REGION`="Polaris"
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`="Montana"
and `REGION`="Polaris"
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`="Montana"
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`="Montana"
and `REGION`="Polaris"
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`="Montana"
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`="Montana"
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`="Montana"
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`="Montana"
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`="Montana"
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`="Montana"
and `GROUP_ID`=12
and `TYPE1`="Nature & Wildlife"
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`="Montana"
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`="Montana"
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`="Montana"
and `GROUP_ID`=8
and `TYPE1`="Travel Services"
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`=1021342 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`=1021342 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`=1021342 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`=1021342 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`=1021342 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.02) : SELECT count(*) as `TOTAL`, 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(45.369648))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-113.119484 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.369648))
* 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 45.369648 - (250 / 69)
AND 45.369648 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -113.119484 - (250 / (69 * COS(RADIANS(45.369648))))
AND -113.119484 + (250 / (69 * COS(RADIANS(45.369648)))) and `listings_listings`.`LISTING` not in (1019801, 1021342)
........ 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(45.369648))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-113.119484 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.369648))
* 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`="Montana"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 45.369648 - (250 / 69)
AND 45.369648 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -113.119484 - (250 / (69 * COS(RADIANS(45.369648))))
AND -113.119484 + (250 / (69 * COS(RADIANS(45.369648)))) and `listings_listings`.`LISTING` not in (1019801, 1021342)
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(45.369648))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-113.119484 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.369648))
* 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` > 1561634510
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 45.369648 - (250 / 69)
AND 45.369648 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -113.119484 - (250 / (69 * COS(RADIANS(45.369648))))
AND -113.119484 + (250 / (69 * COS(RADIANS(45.369648)))) and `listings_listings`.`LISTING` not in (1019801, 1021342)
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(45.369648))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-113.119484 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(45.369648))
* 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 45.369648 - (250 / 69)
AND 45.369648 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -113.119484 - (250 / (69 * COS(RADIANS(45.369648))))
AND -113.119484 + (250 / (69 * COS(RADIANS(45.369648)))) and `listings_listings`.`LISTING` not in (1019801, 1021342)
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`="Montana"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1021342, 1021509, 1036376, 1197919, 1211209, 1282198, 1281647, 1233592, 1233661, 1200846, 1233594)
........ 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`="Montana"
and `listings_listings`.`LISTING` not in (1019801, 1021342, 1021509, 1036376, 1197919, 1211209, 1282198, 1281647, 1233592, 1233661, 1200846, 1233594)
ORDER BY `INDEXKEY`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings.htm:194 (from: listing_nearby_options.htm:84)) 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`="Montana"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1021342, 1021509, 1036376, 1197919, 1211209, 1282198, 1281647, 1233592, 1233661, 1200846, 1233594, 1129628, 1022811, 1155914, 1021242, 1020993, 1283082, 1283083, 1283091, 1283092, 1283073)
........ 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`="Montana"
and `listings_listings`.`LISTING` not in (1019801, 1021342, 1021509, 1036376, 1197919, 1211209, 1282198, 1281647, 1233592, 1233661, 1200846, 1233594, 1129628, 1022811, 1155914, 1021242, 1020993, 1283082, 1283083, 1283091, 1283092, 1283073)
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`=1021342 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`=1021342 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`=1021342 ........ common_miva_database.htm:52 (from: listing_template_full_home.htm:40 (from: listing_template.htm:93)) debug : Opening table listings_ratecard ........ common_miva_database.htm:186 (from: listing_rates.htm:36 (from: listing_template_full_home.htm:40)) debug : (0.00) : SELECT * FROM `listings_ratecard` WHERE `LISTING`=1021342 AND `DELETED`=0 order by `RECNO` ........ 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`=1021342 and `DATE`>="2022-06" ........ common_miva_database.htm:52 (from: listing_template_full_home.htm:45 (from: listing_template.htm:93)) debug : Opening table listings_amenities2 ........ common_miva_database.htm:186 (from: listing_amenities.htm:15 (from: listing_template_full_home.htm:45)) debug : (0.00) : SELECT * FROM `listings_amenities2` left join `amenities1` using (`AMEN_ID`) WHERE `LISTING`=1021342 and `amenities1`.`ACTIVE` and !`amenities1`.`REQUIRED` ORDER BY `amenities1`.`TYPE` DESC, `amenities1`.`GROUP`, `amenities1`.`SUBGROUP`, `amenities1`.`AMENITY`, `amenities1`.`VALUE` Time: 0.13 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.
