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

Get $100 Chamber Bucks at Move-in!

Start Date : 2017-04-11

End Date : 2017-02-14

Phone : 307-684-8570

Email Address :

Web site :

Long Description : Sign a new lease by April 30 to receive $100 Chamber Bucks! Chamber Bucks are redeemable at any business that is a member of the Buffalo Chamber of Commerce

Company  
Deal Tilte Get $100 Chamber Bucks at Move-in!  
Tag Line MOVE IN SPECIAL  
Short Descripton MOVE IN SPECIAL  
Long Description Sign a new lease by April 30 to receive $100 Chamber Bucks! Chamber Bucks are redeemable at any business that is a member of the Buffalo Chamber of Commerce  
Dealstart Datetime 2017-04-11  
Dealends Datetime 2017-02-14  
Type hotdeal  
Deal Image  
Phone 307-684-8570  
Email Link Text  
Email Address  
Website Link Text  
Website Address  

Facebook

(default) 1 query took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Hotdeal`.`id`, `Hotdeal`.`company_id`, `Hotdeal`.`quicklink_type_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`, `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`, `QuicklinkType`.`Id`, `QuicklinkType`.`ParentId`, `QuicklinkType`.`GiftCardCategoryId`, `QuicklinkType`.`GiftCardSubCategoryId`, `QuicklinkType`.`Name`, `QuicklinkType`.`MemberCount`, `QuicklinkType`.`QuickLinkId`, `QuicklinkType`.`HasChildren`, `QuicklinkType`.`flag` FROM `bufchamber_live`.`hotdeals` AS `Hotdeal` LEFT JOIN `bufchamber_live`.`companies` AS `Company` ON (`Hotdeal`.`company_id` = `Company`.`MemId`) LEFT JOIN `bufchamber_live`.`quicklink_types` AS `QuicklinkType` ON (`Hotdeal`.`quicklink_type_id` = `QuicklinkType`.`Id`) WHERE `Hotdeal`.`deal_title` = 'Get $100 Chamber Bucks at Move-in!' LIMIT 1111