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

  • Hot Deals

  • Jobs

Experience the New West

Buffalo, Wyoming you’ll find the laid-back charm of a true Western community.

Buffalo is nestled at the base of the Big Horn Mountains.

We sit at the crossroads of I-90 & I-25, and U.S. Hwy 16- the Cloud Peak Scenic Byway- is the preferred route to Yellowstone National Park.
Buffalo is a fantastic place to visit, or to put down roots.

The school system is second to none, there’s always something in town to do- and everywhere you turn, there’s the opportunity for all-season outdoor recreation.

Buffalo – visit for the weekend, or stay for a lifetime!

Explore the Old West

Walk in the paths of pioneers, outlaws, gold miners, soldiers, and cowboys.

Since being founded in 1879, Buffalo has seen its share of historic personalities: Butch Cassidy and The Sundance Kid,
“Buffalo Bill” Cody, Tom Horn, Calamity Jane, Teddy Roosevelt and Owen Wister sought out a cozy bed and a strong drink in town.

Historic sites like Fort Phil Kearney, Hole-In-The-Wall and the TA Ranch, home to the climactic end of
the Johnson County Cattle Wars are all within short driving distance.

That history, mixed with quaint shops, great restaurants and friendly folk, make Buffalo a place to spend some quality time!

photos
pathfinder
wild bunch
Hot Deals
Jobs
Community Calender
Longmire

Facebook

(default) 37 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Event`.`Id`, `Event`.`parent_id`, `Event`.`Name`, `Event`.`Status`, `Event`.`MemberId`, `Event`.`Description`, `Event`.`SponsoredBy`, `Event`.`StartTime`, `Event`.`EndTime`, `Event`.`location`, `Event`.`SearchDescription`, `Event`.`Types`, `Event`.`MainPhotos`, `Event`.`Pending`, `Event`.`Pdh`, `Event`.`Ceu`, `Event`.`Visibility`, `Event`.`ContactInformation`, `Event`.`RegistrationCutoffDate`, `Event`.`IsAllDay`, `Event`.`Admission`, `Event`.`RegistrationCutoff`, `Event`.`Hours`, `Event`.`Slug`, `Event`.`ispending`, `Event`.`flag`, `Event`.`FeaturedExpiration`, `Event`.`is_recurring`, `Event`.`type`, `Event`.`repeat_every`, `Event`.`monday`, `Event`.`tuesday`, `Event`.`wednesday`, `Event`.`thursday`, `Event`.`friday`, `Event`.`saturday`, `Event`.`sunday`, `Event`.`selected_dates` FROM `bufchamber_live`.`events` AS `Event` WHERE `Event`.`is_recurring` = 0 AND `Event`.`StartTime` >='2018-01-16 00:00:00' AND `Event`.`EndTime` <='2018-01-22 23:59:59' AND `Event`.`ispending` = 1 ORDER BY `StartTime` ASC26267
2SELECT `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`, `Job`.`modified` FROM `bufchamber_live`.`jobs` AS `Job` WHERE ((`Job`.`StartDate` <= '2018-01-17') AND (`Job`.`EndDate` >= '2018-01-17')) ORDER BY rand() ASC LIMIT 5001
3SELECT `Hotdeal`.`id`, `Hotdeal`.`company_id`, `Hotdeal`.`quicklink_id`, `Hotdeal`.`deal_title`, `Hotdeal`.`tag_line`, `Hotdeal`.`short_descripton`, `Hotdeal`.`long_description`, `Hotdeal`.`dealstart_datetime`, `Hotdeal`.`dealends_datetime`, `Hotdeal`.`publish_date`, `Hotdeal`.`unpublish_date`, `Hotdeal`.`type`, `Hotdeal`.`deal_image`, `Hotdeal`.`phone`, `Hotdeal`.`email_link_text`, `Hotdeal`.`email_address`, `Hotdeal`.`website_link_text`, `Hotdeal`.`website_address`, `Hotdeal`.`created`, `Hotdeal`.`modified`, `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`, `Company`.`keywords`, `Quicklink`.`Id`, `Quicklink`.`Name`, `Quicklink`.`short_name`, `Quicklink`.`Description`, `Quicklink`.`image`, `Quicklink`.`flag` FROM `bufchamber_live`.`hotdeals` AS `Hotdeal` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`Hotdeal`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`Hotdeal`.`quicklink_id` = `Quicklink`.`Id`) WHERE `Hotdeal`.`publish_date` <= '2018-01-17' AND `Hotdeal`.`unpublish_date` >= '2018-01-17' ORDER BY rand() ASC LIMIT 5441
4SELECT `Quicklink`.`Id`, `Quicklink`.`Name`, `Quicklink`.`short_name`, `Quicklink`.`Description`, `Quicklink`.`image`, `Quicklink`.`flag` FROM `bufchamber_live`.`quicklinks` AS `Quicklink` WHERE 1 = 124240
5SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 1111
6SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 2110
7SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 3110
8SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 4110
9SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 5110
10SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 6110
11SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 7110
12SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 8110
13SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 9110
14SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 10110
15SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 11110
16SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 12110
17SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 13110
18SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 14110
19SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 15110
20SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 16111
21SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 17110
22SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 18111
23SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 19111
24SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 20111
25SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 21111
26SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 22111
27SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 23111
28SELECT COUNT(*) AS `count` FROM `bufchamber_live`.`company_categories` AS `CompanyCategory` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`CompanyCategory`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklinks` AS `Quicklink` ON (`CompanyCategory`.`quicklink_id` = `Quicklink`.`Id`) WHERE `CompanyCategory`.`quicklink_id` = 24110
29SELECT `Htmlblock`.`id`, `Htmlblock`.`logo`, `Htmlblock`.`excerpt`, `Htmlblock`.`title`, `Htmlblock`.`body`, `Htmlblock`.`created`, `Htmlblock`.`modified`, `Htmlblock`.`title_for_layout`, `Htmlblock`.`description_for_layout`, `Htmlblock`.`keywords_for_layout`, `Htmlblock`.`type`, `Htmlblock`.`parent_id`, `Htmlblock`.`status`, `Htmlblock`.`is_deleted` FROM `bufchamber_live`.`htmlblocks` AS `Htmlblock` WHERE `Htmlblock`.`id` = 25 LIMIT 1110
30SELECT `HtmlblockDocument`.`id`, `HtmlblockDocument`.`htmlblock_id`, `HtmlblockDocument`.`filename`, `HtmlblockDocument`.`docfile`, `HtmlblockDocument`.`created` FROM `bufchamber_live`.`htmlblock_documents` AS `HtmlblockDocument` WHERE `HtmlblockDocument`.`htmlblock_id` = (25)000
31SELECT `Htmlblock`.`id`, `Htmlblock`.`logo`, `Htmlblock`.`excerpt`, `Htmlblock`.`title`, `Htmlblock`.`body`, `Htmlblock`.`created`, `Htmlblock`.`modified`, `Htmlblock`.`title_for_layout`, `Htmlblock`.`description_for_layout`, `Htmlblock`.`keywords_for_layout`, `Htmlblock`.`type`, `Htmlblock`.`parent_id`, `Htmlblock`.`status`, `Htmlblock`.`is_deleted` FROM `bufchamber_live`.`htmlblocks` AS `Htmlblock` WHERE `Htmlblock`.`id` = 26 LIMIT 1110
32SELECT `HtmlblockDocument`.`id`, `HtmlblockDocument`.`htmlblock_id`, `HtmlblockDocument`.`filename`, `HtmlblockDocument`.`docfile`, `HtmlblockDocument`.`created` FROM `bufchamber_live`.`htmlblock_documents` AS `HtmlblockDocument` WHERE `HtmlblockDocument`.`htmlblock_id` = (26)000
33SELECT `Htmlblock`.`id`, `Htmlblock`.`logo`, `Htmlblock`.`excerpt`, `Htmlblock`.`title`, `Htmlblock`.`body`, `Htmlblock`.`created`, `Htmlblock`.`modified`, `Htmlblock`.`title_for_layout`, `Htmlblock`.`description_for_layout`, `Htmlblock`.`keywords_for_layout`, `Htmlblock`.`type`, `Htmlblock`.`parent_id`, `Htmlblock`.`status`, `Htmlblock`.`is_deleted` FROM `bufchamber_live`.`htmlblocks` AS `Htmlblock` WHERE `Htmlblock`.`id` = 27 LIMIT 1110
34SELECT `HtmlblockDocument`.`id`, `HtmlblockDocument`.`htmlblock_id`, `HtmlblockDocument`.`filename`, `HtmlblockDocument`.`docfile`, `HtmlblockDocument`.`created` FROM `bufchamber_live`.`htmlblock_documents` AS `HtmlblockDocument` WHERE `HtmlblockDocument`.`htmlblock_id` = (27)000
35SELECT `Htmlblock`.`id`, `Htmlblock`.`logo`, `Htmlblock`.`excerpt`, `Htmlblock`.`title`, `Htmlblock`.`body`, `Htmlblock`.`created`, `Htmlblock`.`modified`, `Htmlblock`.`title_for_layout`, `Htmlblock`.`description_for_layout`, `Htmlblock`.`keywords_for_layout`, `Htmlblock`.`type`, `Htmlblock`.`parent_id`, `Htmlblock`.`status`, `Htmlblock`.`is_deleted` FROM `bufchamber_live`.`htmlblocks` AS `Htmlblock` WHERE `Htmlblock`.`id` = 28 LIMIT 1110
36SELECT `HtmlblockDocument`.`id`, `HtmlblockDocument`.`htmlblock_id`, `HtmlblockDocument`.`filename`, `HtmlblockDocument`.`docfile`, `HtmlblockDocument`.`created` FROM `bufchamber_live`.`htmlblock_documents` AS `HtmlblockDocument` WHERE `HtmlblockDocument`.`htmlblock_id` = (28)000
37SELECT `Slider`.`id`, `Slider`.`name`, `Slider`.`video_link`, `Slider`.`image`, `Slider`.`ordinal`, `Slider`.`active` FROM `bufchamber_live`.`sliders` AS `Slider` WHERE `Slider`.`active` = '1' ORDER BY `Slider`.`ordinal` ASC550