my $SQL1    = "INSERT INTO property (address_1, address_2, county, city, zip, description, status, bedroom) VALUES ('$address_1', '$address_2', '$county', '$city', '$zip', '$description', '$status', '$bedroom'); INSERT INTO property2 (address_1, address_2, county, city, zip, description, status, bedroom) VALUES ('$address_1', '$address_2', '$county', '$city', '$zip', '$description', '$status', '$bedroom')";

my $sth= $dbh->prepare($SQL1) or die $dbh->errstr;