Are you a photographer? We need your help!
Roanoke, Virginia Zip Codes: 24001,24002,24003,24004,24005,24006,24007,24008,24009,24010,24011,24012,24013,24014,24015,24016,24017,24018,24019,24020,24022,24023,24024,24025,24026,24027,24028,24029,24030,24031,24032,24033,24034,24035,24036,24037,24038,24040,24042,24043,24044,24045,24048,24050
select cat from directory where is_archived=0 and site_url != '' and (city='roanoke' OR city='roanoke') and (state='VA' OR state='Virginia')
select cat from directory where is_archived=0 and site_url != '' and (city='roanoke' OR city='roanoke') and (state='VA' OR state='Virginia') union select cat from affiliate_directory where is_archived=0 and site_url != '' and (FIND_IN_SET('roanoke', city) OR city='all' ) and (state='VA' OR state='Virginia' OR state='all')
56,181,119,1,107,227,75,163,168,867,790,66,80,1224,791,197,1255