try this for the query:
SELECT listings.*, states_provinces.*, states_provinces_0.* FROM
listings
LEFT JOIN states_provinces ON states_provinces.StateID=listings.location1provstate
LEFT JOIN states_provinces AS states_provinces_0 ON states_provinces_0.StateID=listings.location2provstate
then you should be able to get the first state name:
<?php echo $row_Recordset1['states_provinces.StateName']; ?>
and the second as
<?php echo $row_Recordset1['states_provinces_0.StateName']; ?>