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

MISHAP! Brewing Company, LLC




(307) 278-0043
48 S Main St
Buffalo, WY 82834

About

We are a small craft brewery located in historic downtown Buffalo, WY at the foot of the Bighorn Mountains. Full liquor license. No Food on the menu, but everyone is welcome to order in from any of the great nearby restaurants.

Map

Contact MISHAP! Brewing Company, 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 'mishap! brewing company, 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` = 225000
3SELECT `Companysociallink`.`id`, `Companysociallink`.`URL`, `Companysociallink`.`SocialNetwork`, `Companysociallink`.`MemberId`, `Companysociallink`.`flag` FROM `bufchamber_live`.`companysociallinks` AS `Companysociallink` WHERE `Companysociallink`.`MemberId` = '225'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 "%mishap! brewing company, llc%"))001
5SELECT `Country`.`iso3`, `Country`.`name` FROM `bufchamber_live`.`countries` AS `Country` WHERE 1 = 12392391