SELECT LISTING_ID FROM USERS_CUSTOM_DATABASE LEFT JOIN USERS_CUSTOM_DATABASE_PROPERTY_TYPES ON USERS_CUSTOM_DATABASE.PROPERTY_TYPE_CODE = USERS_CUSTOM_DATABASE_PROPERTY_TYPES.PROPERTY_TYPE_CODE WHERE USERS_CUSTOM_DATABASE.[USER_NAME] = 'JHR' AND USERS_CUSTOM_DATABASE_PROPERTY_TYPES.DESCRIPTION LIKE 'Long%Term%Rental' AND PROPERTY_NAME LIKE 'Galley%Bay%House%'