map
 
307-684-5544 , 55 N. Main Street , Buffalo, WY 82834 , 1-800-227-5122
 

Lake Stop, LLC




(307) 684-8700
9 Lake Desmet Road
Buffalo, WY 82834

About

A piece of history; the beautiful Lake Stop Resort, where there is always something going on! Hotel, Bar & Lounge, Convenience Store, Event Facility

Map

Contact Lake Stop, LLC

* Required field



Facebook

(default) 5 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Company`.`OrganizationName`, `Company`.`company_logo`, `Company`.`MembershipEstablished`, `Company`.`MembershipTypeId`, `Company`.`MembershipType`, `Company`.`PrimaryRepFirstName`, `Company`.`PrimaryRepLastName`, `Company`.`PrimaryRepMiddleName`, `Company`.`PrimaryRepId`, `Company`.`ChamberRepId`, `Company`.`ChamberRepFirstName`, `Company`.`ChamberRepLastName`, `Company`.`ChamberRepMiddleName`, `Company`.`SalesStageId`, `Company`.`SalesStage`, `Company`.`BillingRepId`, `Company`.`BillingRepFirstName`, `Company`.`BillingRepLastName`, `Company`.`BillingRepMiddleName`, `Company`.`RenewalMonth`, `Company`.`MemId`, `Company`.`Directions`, `Company`.`Description`, `Company`.`Line1`, `Company`.`City`, `Company`.`State`, `Company`.`Region`, `Company`.`PostalCode`, `Company`.`Line2`, `Company`.`Country`, `Company`.`Line3`, `Company`.`Line4`, `Company`.`DispPhone1`, `Company`.`DispFax`, `Company`.`DispPhone2`, `Company`.`MarketplaceCount`, `Company`.`Email`, `Company`.`Website`, `Company`.`Latitude`, `Company`.`Longitude`, `Company`.`HoursOfOperation`, `Company`.`FullTimeEmployeeCount`, `Company`.`PartTimeEmployeeCount`, `Company`.`FileByName`, `Company`.`DisplayFlags`, `Company`.`MemberPageVideoUrl`, `Company`.`DisplayName`, `Company`.`DropDate`, `Company`.`StatusType`, `Company`.`Level`, `Company`.`WebParticipationLevel`, `Company`.`QBBalance`, `Company`.`ContactPrimaryPhone`, `Company`.`ContactAlternatePhone`, `Company`.`ContactCellPhone`, `Company`.`ContactTollFreePhone`, `Company`.`ContactEmail`, `Company`.`Comment`, `Company`.`SearchDescription`, `Company`.`LogoUrl`, `Company`.`SearchLogoUrl`, `Company`.`Slug`, `Company`.`ShowOnMap`, `Company`.`flag`, `Company`.`created`, `Company`.`modified`, `Company`.`is_active`, `Company`.`inactive_date`, `Company`.`inactive_reason`, `Company`.`is_deleted`, `Company`.`membership_terminated` FROM `bufchamber_live`.`companies` AS `Company` WHERE `Company`.`OrganizationName` Like 'lake stop, llc%' AND `Company`.`is_active` = '1' AND `Company`.`is_deleted` = 0 LIMIT 1111
2SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`year`, `GalleryImage`.`created`, `GalleryImage`.`modified`, `GalleryImage`.`company_id` FROM `bufchamber_live`.`gallery_images` AS `GalleryImage` WHERE `company_id` = 457000
3SELECT `Companysociallink`.`id`, `Companysociallink`.`URL`, `Companysociallink`.`SocialNetwork`, `Companysociallink`.`MemberId`, `Companysociallink`.`flag` FROM `bufchamber_live`.`companysociallinks` AS `Companysociallink` WHERE `Companysociallink`.`MemberId` = '457'000
4SELECT `Job`.`Id`, `Job`.`JobCategoryId`, `Job`.`Title`, `Job`.`Description`, `Job`.`BusinessName`, `Job`.`ContactRepName`, `Job`.`Street`, `Job`.`City`, `Job`.`State`, `Job`.`Zip`, `Job`.`LocalPhone`, `Job`.`Email`, `Job`.`WebsiteAddress`, `Job`.`ActiveDates`, `Job`.`StartDate`, `Job`.`EndDate`, `Job`.`FullWeek`, `Job`.`MemberId`, `Job`.`Status`, `Job`.`Purchased`, `Job`.`Images`, `Job`.`Fax`, `Job`.`Slug`, `Job`.`flag`, `Job`.`created`, `JobCategory`.`Id`, `JobCategory`.`Name`, `JobCategory`.`Description`, `JobCategory`.`flag` FROM `bufchamber_live`.`jobs` AS `Job` LEFT JOIN `bufchamber_live`.`job_categories` AS `JobCategory` ON (`Job`.`JobCategoryId` = `JobCategory`.`Id`) WHERE ((`Job`.`StartDate` <= '2017-07-24') AND (`Job`.`EndDate` >= '2017-07-24') AND (`Job`.`BusinessName` Like "%lake stop, llc%"))001
5SELECT `Country`.`iso3`, `Country`.`name` FROM `bufchamber_live`.`countries` AS `Country` WHERE 1 = 12392391