SELECT stStateName,stCityName,stUrlSlug,stStateAbbr FROM tbl_states WHERE stStateName LIKE 'Arizona' AND stCityName LIKE 'Prescott-valley'