ALTER TABLE `rooms101_rtsdev`.`property`
    ADD COLUMN `city` varchar(50) NULL AFTER `address2`,
    ADD COLUMN `state` varchar(2) NULL AFTER `city`,
    ADD COLUMN `lat` decimal(10, 8) NULL AFTER `country`,
    ADD COLUMN `lon` decimal(11, 8) NULL AFTER `lat`;
