SELECT stStateName,stCityName,stUrlSlug,stStateAbbr FROM tbl_states WHERE stStateName LIKE 'Alabama' AND stCityName LIKE 'Albertville'