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 »
Pronghorn Entry (#1/13)
Take a picture with the Bronze Pronghorn
Breakfast Room (#2/13)
Enjoy your free continental breakfast with fruit,cereals,yogut,hard boiled eggs,dainish roll,bagels,
Lobby (#3/13)
Check in with our friendly staff.
Deck on Popo Agie River (#4/13)
This deck will accomodate an outdoor meeting, family picnic, or just to relax and read
Monarch Hall (#5/13)
Have a meeting for 20 or 150, we can accomodate your needs, Meeting, weddings, birthday or any occas
Standard Room (#6/13)
Two queen beds.
Standard room (#7/13)
2 queen beds
Standard Room (#8/13)
2 queen Beds
Honeymoon Suite (#9/13)
1 King Bed, largefront room, large bathroom with jetted tub.
Honeymoon Suite (#10/13)
Relax in the Jetted Tub in the Honeymoon Suite
Oxbow Restaurant Entrance (#11/13)
On site restaurant with all american menu and great steaks and prime Rib, We have The Huntsman room
Bronze Elk (#12/13)
This 1 1/2 Life size Bronze Elk was commissioned by Jim and Wendy Gibson.
Front Entry Gates (#13/13)
arrow_back_ios
Previous
arrow_forward_ios
Next
Rodeway Inn & Suites Pronghorn Lodge
location_on Lander, Wyoming | Hotels & Resorts
Convenient at door parking. 56 rooms,King and Queen beds and suites with 32' flat screen tv's. ,Free continental breakfast,newspaper,and internet. Hot tub,exercise equipment,conference hall, picnic area with outdoor deck on the Popo Agie River.Starting at
USD $79.99 per night
calendar_month Availability & Reservations
Surrounding Areakeyboard_double_arrow_up
One block from Downtown Historic Lander, Nearby 18 Hole Golf Course overlooking the Wind River Mountains. Sinks Canyon State Park, Oregon, Mormon and Pony Express Trails, ATV Trails, horsepacking,Great Fishing, Rock Climbing, Wind River Indian Reservation, Pioneer Musuem, Museum of The American West Village, Snowmobling, Popo Agie Falls. Walking trails, Wyoming Catholic College
Accommodationskeyboard_double_arrow_up
We offer very comfortable clean rooms, with a staff that cares about you. We are rated 2 diamonds with AAA/ We offer an outside BBQ area witha large deck to relax on.. Enjoy the exterior of our log work, and take pictures of our 1 1/2 life size Bronze Elk.
Map & Directionskeyboard_double_arrow_up
150 East Main St, Lander, Wyoming
Located at the Junction of Higway 287 and 789 in downtown Lander Wyoming
Points of Interest
Rodeway Inn & Suites Pronghorn Lodge
150 East Main St, Lander, Wyoming
Rates & Availabilitykeyboard_double_arrow_up
(All rates in USD $) From/To all year Low High Notes 79.99 80 125 $10.00 for each addtional person. children free
$79.99 to $125.00. $10.00 for each addtional person. Children are free.
$79.99 to $125.00. $10.00 for each addtional person. Children are free.
We offer AAA,Government, AARP .Members must present cards for the discounts
*Please
contact advertiser for rates & availability for your travel dates.
Amenitieskeyboard_double_arrow_up
The Oxbow Restaurant sits on the property, 6 other restaruants within walking distance, Exercise room, hot tub, Conference Hall ,computer in Lobby,
Room Amenities check_box Air Conditioningcheck_box Cable/Satellite TVcheck_box Hairdryercheck_box High Speed Internetcheck_box Microwavecheck_box Refrigeratorcheck_box Room Servicecheck_box Telephonecheck_box Telephone - Free Local Callscheck_box Televisioncheck_box Television - Free HBOAvailable check_box Business Centercheck_box Conference Roomscheck_box Fax Machinecheck_box Hot Tubcheck_box Internet Accesscheck_box Breakfastcheck_box Availablecheck_box Freecheck_box Laundry
Rooms/Suiteskeyboard_double_arrow_up
We offer some rooms with 2 queen beds and a seperate sitting area ,Rooms with king beds , Suites and Honeymoon Suite
Services Offeredkeyboard_double_arrow_up
Order from the Oxbow and relax and eat in your room.
Policies & Restrictionskeyboard_double_arrow_up
We offer limited pet rooms,penalty applied if pet is unclaimed and in a non pet room. Limited smoke rooms, mainly our rooms are non smoking.
Other Informationkeyboard_double_arrow_up
Combine your lodging, meeting, wedding, and catering in one perfect location. We work hard to accomodate all your needs, please call and ask for Jeff or Wendy to assist you.
Travel Provider's Infokeyboard_double_arrow_up
Starting at
USD $79.99 per night
Rodeway Inn & Suites Pronghorn Lodge
150 East Main St
person_outline Hotel Owner
credit_card Reservations
Listing # RA-1233604
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.12 | 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`=1233604 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`=730592 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=1233604 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`=730592 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`="Wyoming"
and `REGION`="Lander"
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`="Wyoming"
and `REGION`="Lander"
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`="Wyoming"
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`="Wyoming"
and `REGION`="Lander"
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`="Wyoming"
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`="Wyoming"
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`="Wyoming"
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`="Wyoming"
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`="Wyoming"
and `GROUP_ID`=4
and `TYPE1`="Cruises"
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`="Wyoming"
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`="Wyoming"
and `GROUP_ID`=20
and `TYPE1`="Local Entertainment"
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`="Wyoming"
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`="Wyoming"
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`="Wyoming"
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`="Wyoming"
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`=1233604 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`=1233604 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`=1233604 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`=1233604 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`=1233604 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(42.832428))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-108.725868 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(42.832428))
* 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 42.832428 - (250 / 69)
AND 42.832428 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -108.725868 - (250 / (69 * COS(RADIANS(42.832428))))
AND -108.725868 + (250 / (69 * COS(RADIANS(42.832428)))) and `listings_listings`.`LISTING` not in (1019801, 1233604)
........ 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(42.832428))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-108.725868 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(42.832428))
* 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`="Wyoming"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 42.832428 - (250 / 69)
AND 42.832428 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -108.725868 - (250 / (69 * COS(RADIANS(42.832428))))
AND -108.725868 + (250 / (69 * COS(RADIANS(42.832428)))) and `listings_listings`.`LISTING` not in (1019801, 1233604)
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(42.832428))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-108.725868 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(42.832428))
* 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` > 1561653703
and `listings_listings`.`PARTNER_CODE`=""
and `listings_listings`.`PRIORITY`
and `listings_listings`.`LATITUDE`
BETWEEN 42.832428 - (250 / 69)
AND 42.832428 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -108.725868 - (250 / (69 * COS(RADIANS(42.832428))))
AND -108.725868 + (250 / (69 * COS(RADIANS(42.832428)))) and `listings_listings`.`LISTING` not in (1019801, 1233604)
order by `DISTANCE`
limit 0
, 10 ........ common_miva_database.htm:186 (from: summary_listings_get.htm:25 (from: summary_listings.htm:321)) debug : (0.02) : SELECT * , 69
* DEGREES(ACOS(LEAST(1.0, COS(RADIANS(42.832428))
* COS(RADIANS(`listings_listings`.`LATITUDE`))
* COS(RADIANS(-108.725868 - `listings_listings`.`LONGITUDE`))
+ SIN(RADIANS(42.832428))
* 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 42.832428 - (250 / 69)
AND 42.832428 + (250 / 69)
AND `listings_listings`.`LONGITUDE`
BETWEEN -108.725868 - (250 / (69 * COS(RADIANS(42.832428))))
AND -108.725868 + (250 / (69 * COS(RADIANS(42.832428)))) and `listings_listings`.`LISTING` not in (1019801, 1233604)
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`="Wyoming"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1233604, 1233616, 1233594, 1233668, 1233598, 1233592, 1233661, 1232370, 1216413, 1033772, 1023943)
........ 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`="Wyoming"
and `listings_listings`.`LISTING` not in (1019801, 1233604, 1233616, 1233594, 1233668, 1233598, 1233592, 1233661, 1232370, 1216413, 1033772, 1023943)
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`="Wyoming"
and `listings_listings`.`IMAGES`>0
and `listings_listings`.`LISTING` not in (1019801, 1233604, 1233616, 1233594, 1233668, 1233598, 1233592, 1233661, 1232370, 1216413, 1033772, 1023943, 1277119, 1024583, 1232376, 1233686, 1232430, 1022710, 1233655, 1024219, 1283098, 1283104)
........ 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`="Wyoming"
and `listings_listings`.`LISTING` not in (1019801, 1233604, 1233616, 1233594, 1233668, 1233598, 1233592, 1233661, 1232370, 1216413, 1033772, 1023943, 1277119, 1024583, 1232376, 1233686, 1232430, 1022710, 1233655, 1024219, 1283098, 1283104)
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`=1233604 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`=1233604 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`=1233604 ........ 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`=1233604 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`=1233604 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`=1233604 and `amenities1`.`ACTIVE` and !`amenities1`.`REQUIRED` ORDER BY `amenities1`.`TYPE` DESC, `amenities1`.`GROUP`, `amenities1`.`SUBGROUP`, `amenities1`.`AMENITY`, `amenities1`.`VALUE` Time: 0.12 | Consuming 0.00 kb
Could not connect to the reCAPTCHA service. Please enable Javascript and reload to get a reCAPTCHA challenge.
