Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T08:36:45.210' ,`MLSNumber` = '80845402' ,`ListAgentFullName` = 'Gerthie Acklen' ,`ListOfficeName` = 'Real World Realty ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.277695' ,`Longitude` = '-94.834280' ,`PhotoCount` = '20' ,`PostalCode` = '77551' ,`RoomCount` = '4' ,`ListPrice` = '279000.00' ,`Status` = 'Active' ,`StreetName` = 'Grover' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Avenue' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A Fabulous Remodeled 4 Bedroom 2 Bath Home Centrally Located Off of 61st with A Large Lot. New Roof, New Windows Fresh Paint Inside & Out, New Kitchen Cabinets, New Flooring and More. A GREAT LOCATION near Moody Garden, Seawall, Fabulous Restaurants and More.' ,`Acres` = '0.1478' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 4 BLK 8 HOLLYWOOD HEIGHTS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hollywood Heights' ,`TaxAmount` = '4037' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089042' WHERE `Matrix_Unique_ID` = '209343587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T08:00:13.347' ,`MLSNumber` = '83766018' ,`ListAgentFullName` = 'Rebecca May' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Monica Foster' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.104011' ,`Longitude` = '-95.118331' ,`PhotoCount` = '48' ,`PostalCode` = '77336' ,`RoomCount` = '11' ,`ListPrice` = '899999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hargrave' ,`StreetNumber` = '2933' ,`StreetSuffix` = 'Road' ,`City` = 'Huffman' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3878' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Dreaming of living the ranch life but not quite ready to give up the city? This place is your dream come true, and it’s only 45 minutes from downtown Houston; 30 minutes to Bush IAH, and minutes to 99! Yet when you enter that automatic, wrought iron gate at the entrance, follow the meandering drive through a shady tunnel of mature trees, and come upon the clearing revealing your new home, you’ll feel like you’ve entered another world. A world of peaceful solitude. The home is surrounded by a lush grove of trees offering the utmost privacy. This custom-built home was designed for gracious, Texas-style living…all on one level. It boasts everything one would expect: two primary suites, two large secondary bedrooms, a home office, formal dining, family room with stone fireplace, a massive game room, and so much more! Outside you’ll find a fabulous pool replete with waterfall and stone slide; outdoor kitchen, palapa bar, 6-stall barn +++. Seller to contribute $9,000 to buy down rate!' ,`Acres` = '6.354' ,`Area` = '32' ,`BuilderName` = 'Carl Pipes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 PLANTATIONS' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '276781' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Commons of Lake Houston' ,`TaxAmount` = '13180' ,`TaxRate` = '2.0083' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675089043' WHERE `Matrix_Unique_ID` = '210370473' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-09T08:47:41.233' ,`MLSNumber` = '16880760' ,`ListAgentFullName` = 'Robert Griffin' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.636985' ,`Longitude` = '-95.439349' ,`PhotoCount` = '41' ,`PostalCode` = '77045' ,`RoomCount` = '5' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Brookston' ,`StreetNumber` = '4122' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Gem before it\'s gone.. This New Construction home sitting on a corner lot is designed for entertaining and the heart of the home is a large gathering room with the kitchen at the back of the home. This is a 3 bedrooms, 2.5 bathrooms, and a 2-car garage that\'s Conveniently located within minutes of the world renowned Houston Medical Center, Hermann Park, Museum District and more. The kitchen has a large island with granite countertops, custom tile back splash, and ceramic tile flooring. Master Suite complete with double sinks, walk in shower and tons of space. Last but not the least, this home offers a charming covered porch that greets you as you arrive at the front door.' ,`Acres` = '0.1798' ,`Area` = '18' ,`BuilderName` = 'Garcia Builders' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 12 BRENTWOOD SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '7830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Brentwood Sec 02' ,`TaxAmount` = '606' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675089043' WHERE `Matrix_Unique_ID` = '214158213' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215107762','1675089043','215107762','2022-12-09T08:16:19.817','94189254','Rose Yannakis','Energy Realty','','','29.927570','-95.617806','43','77065','9','385000.00','Active','Brayton','13106','Court','Houston','3','1','4','3073','Single-Family','CHARMING 2-story home in Wortham Grove, featuring large, LIGHT-FILLED common-use spaces with GLEAMING luxurious porcelain tile, and a CONVENIENT floor plan.\r\nThis home offers an OVERSIZED DETACHED garage, a LONG driveway, with plenty of room for parking, 4 bedrooms, 3 full baths, 1 half bath, a study, a combination formal living/formal dining area, OPEN CONCEPT LIVING from kitchen to family room and breakfast area. The generously sized back yard is PERFECT for entertaining and can easily accommodate a future pool/spa.\r\nRecent Updates include; NEW FLOORING upstairs, NEW ROOF (Aug 2022), new KITCHENAID cooktop, and toilets.\r\nZoned to EXEMPLARY Cy-fair schools with LOW property taxes and HOA fees, it is also just walking distance to EXCEPTIONAL AMENITIES like a community park, pool and tennis courts.\r\nConveniently located providing EASY ACCESS to multiple shops and restaurants, and main roads like 290, HWY-6, BELTWAY-8, 249 and TX-99. \r\nDon\'t miss out, schedule your showing today!!','0.171','10','','','','','Mud,Sellers Disclosure','','','1','1960/Cypress','Central Gas','1','LT 7 BLK 2 WORTHAM GROVE SEC 4','Cul-De-Sac,Subdivision Lot','7449','Appraisal District','','560','0','','1','','0','','','','','Composition','13 - Cypress-Fairbanks','ADAM ELEMENTARY SCHOOL','CY-FAIR HIGH SCHOOL','ARNOLD MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Traditional','Wortham Grove Sec 04','7991','2.341','Public Water','1998','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215258267','1675089043','215258267','2022-12-09T08:47:55.850','86587105','Marysol Calvillo','Elite Properties','','','21.429440','-102.572120','26','47203','6','225000.00','Active','CALLE CUAUHTEMOC','146','Avenue','Other','3','0','6','','Single-Family','Located in the quaint town/municipality of Teocaltiche, this home has 6 bedrooms, 3 full bathrooms and a two-car garage. The home is 3 stories, 1st floor consists of 2 bedrooms(principal), living room, kitchen and dining. \r\nSecond floor 3 bedrooms and a bathroom and the 3rd floor has another bedroom and laundry room. The home is 10 minutes from downtown Teocaltiche and about one hour from Aguascalientes and three hours from Guadalajara.','','','n/a','','','','No Disclosures','','','','','No Heating','0','C ARROYO DE CUAUHTEMOC 146 TAVARES','Subdivision Lot','','','','','1','Never Lived In','2','','0','','','','','Other','','','','','Accompany','','3','Traditional','TAVARES','','','Public Sewer,Public Water','',''); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215450029','1675089043','215450029','2022-12-09T07:59:18.873','18881850','Bradley Tiffan','Legend Home Corporation','','','30.626178','-96.408403','19','77807','4','254990.00','Active','Milagro','4745','Loop','Bryan','2','0','3','1307','Single-Family','Love where you live in Alamosa Springs in Bryan, Texas! The Charlotte floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, and a 2-car garage! This home has it all including blinds and vinyl plank flooring throughout the common areas! The gourmet kitchen is sure to please with a large bar top overlooking the dining and family rooms, shaker style cabinets, granite countertops, and tile backsplash! Enjoy the great outdoors with a sprinkler system and covered patio! Don\'t miss your opportunity to call Alamosa Springs home, schedule a visit today!','0.11','61','Legend Homes','','Electric Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Electric','1','Lot 5 Blk. 10 Alamosa Springs 3','Subdivision Lot','5587','Survey','','150','1','To Be Built/Under Construction','2','Electric Oven','0','','','Electric Cooktop','','Composition','148 - Bryan','MARY BRANCH ELEMENTARY SCHOOL','BRYAN HIGH SCHOOL','STEPHEN F. AUSTIN MIDDLE SCHOOL','Accompany,Appointment Required,No Supra Keybox','Builder','1','Traditional','Alamosa Springs','','2.3565','Public Sewer,Public Water','2022','Builder'); --> New record created successfully