SELECT LISTING_ID FROM USERS_CUSTOM_DATABASE LEFT JOIN USERS_CUSTOM_DATABASE_ISLANDS ON USERS_CUSTOM_DATABASE.ISLAND_ID = USERS_CUSTOM_DATABASE_ISLANDS.ISLAND_CODE WHERE USERS_CUSTOM_DATABASE.[USER_NAME] = 'ROMAC' AND USERS_CUSTOM_DATABASE_ISLANDS.ISLAND LIKE 'Antigua' AND PROPERTY_NAME LIKE 'Flint%House%'