The problem is that you only execute the query after the loop has finished, you need to run it on each line...
foreach($obj as $item) {
$query = "INSERT INTO unverified_list (
title,
street_address,
locality
) VALUES (
'".$item['title']."',
'".$item['street_address']."',
'".$item['locality']."'
)"; // Remove } from here to after next bit of code
$result = $link->query($query);
if ($link->query($query) === TRUE) {
echo "Property Added";
} else {
echo "Error: " . $query . "<br>" . $link->error;
}
}
Although this will now give you a message for each row inserted.
You should also look into using prepared statements which will protect you from all sorts of potential issues.