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'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','215148691','1675099082','215148691','2023-01-02T23:13:42.630','69323705','Justin Dickey','Keller Williams Professionals','','','29.857525','-95.192800','29','77044','7','279500.00','Active','Lanrin Park','13207','','Houston','2','0','3','1615','Single-Family','COMPLETION JANUARY/FEBRUARY 2023 Brand new CORNER LOT 1 story 3-bedroom 2 bath 2 car garage. LARGE CORNER LOT OVERSIZED MASTER BEDROOM AND FAMILY ROOM LOADED WITH UPGRADES. Colina Home features Fantasy Blue granite countertops, White 42” cabinets, 9” farmhouse sink ,stainless steel range, microwave, and dishwasher to include our premium 5 burner range , subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE','','2','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','North Channel','Central Gas','1','Lot 5 Block 5 Section 6','Corner,Subdivision Lot','5500','Survey','','300','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Tidwell Lakes','','3','Public Sewer,Public Water','2023','Builder'); --> 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','215148708','1675099082','215148708','2023-01-02T23:11:06.247','76451383','Justin Dickey','Keller Williams Professionals','','','29.857525','-95.192800','29','77044','7','279300.00','Active','Cardin','9511','Lane','Houston','2','0','3','1615','Single-Family','COMPLETION JANUARY/FEBRUARY 2023 Brand new 1 story 3-bedroom 2 bath 2 car garage. LARGE CORNER LOT OVERSIZED MASTER BEDROOM AND FAMILY ROOM LOADED WITH UPGRADES. Colina Home features Fantasy Blue granite countertops, White 42” cabinets, 9” farmhouse sink, stainless steel range, microwave, and dishwasher to include our premium 5 burner range, subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE','','2','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','North Channel','Central Gas','1','Lot 2 Block 2 Section 6','Corner,Subdivision Lot','5500','Survey','','300','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Tidwell Lakes','','3','Public Sewer,Public Water','2023','Builder'); --> 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','215830642','1675099082','215830642','2023-01-02T23:34:13.797','95675389','Justin Dickey','Keller Williams Professionals','','','29.854374','-95.190525','35','77044','7','297214.00','Active','Lanrin Park','13222','Lane','Houston','3','0','4','1816','Single-Family','COMPLETION April 2023 To be built Colina Home 1816 Plan. View Homesite. TIDWELL LAKES BRAND NEW one story 4/3/2 energy efficient home. The interior selections to include 42\" Legacy Pewter Gray upgrade cabinets, huge kitchen island with New Caledonia granite 3x6 Desert Gray subway tile backsplash. Luxury vinyl planking in all we areas, entry and living room, stainless steel appliances to include our premium 5 burner range, 9\" farm sink, 2\" blinds, garden tub plus separate showing, Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control and an oversized covered back patio this is 22X8. All this included for you. The 1816 one story floor plan is unique because it has three full bathrooms including an en-suite. Don\'t miss out. 365-day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE.','','2','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','North Channel','Central Gas','1','Lot 12 Block 4 Section 6','Subdivision Lot','5500','Survey','','300','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Tidwell Lakes','','3','Public Sewer,Public Water','2023','Builder'); --> 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','215830691','1675099082','215830691','2023-01-02T23:15:11.597','97989551','Justin Dickey','Keller Williams Professionals','','','29.857525','-95.192800','29','77044','7','284620.00','Active','Lanrin Park','13218','Lane','Houston','2','0','3','1615','Single-Family','COMPLETION JANUARY/FEBRUARY 2023 Brand new CORNER LOT 1 story 3-bedroom 2 bath 2 car garage. LARGE CORNER LOT OVERSIZED MASTER BEDROOM AND FAMILY ROOM LOADED WITH UPGRADES. Colina Home features Fantasy Blue granite countertops, White 42” cabinets, 9” farmhouse sink ,stainless steel range, microwave, and dishwasher to include our premium 5 burner range , subway kitchen tile backsplash. 9’ ceilings, 2” blinds throughout, large garden tub with separate shower, marble vanity, large walk-in closet, covered back patio, carpet only in bedrooms, luxury vinyl wood plank throughout. Raised panel doors, rounded sheetrock corners and archways. Pex Plumbing, Lennox 16 seer A/C. Taexx Pest Control. All this included for you. Don\'t miss out on 365 day rate lock or $0 down no PMI. PHOTOS ARE REPRESENTATIVE','','2','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','North Channel','Central Gas','1','Lot 11 Block 4 Section 6','Corner,Subdivision Lot','5795','Survey','','300','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Composition','46 - Sheldon','SHELDON LAKEE ELEMENTARY SCHOOL','CE KING HIGH SCHOOL','C.E. KING MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','1','Traditional','Tidwell Lakes','','3','Public Sewer,Public Water','2023','Builder'); --> 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','216005266','1675099082','216005266','2023-01-02T23:25:19.340','69522282','Cynthia Chang','R.E.D (Real Estate Driven)','','','29.336260','-94.942676','28','77568','3','875000.00','Active','Flamingo','4','Street','La Marque','2','1','3','2828','Single-Family','Welcome to 4 North Flamingo located in the Omega Bay Subdivision where each home is located on the Canal. This stunning 3 - story home is just 2 years NEW and it combines function and style with unobstructed 360 views of the Canal and Highland Bayou Bay. This immaculate and custom designed home is the tallest in the subdivision and offers plenty of space and entertainment for family and friends to enjoy.','0.1033','33','','','Gas Dryer Connections,Washer Connections','','Other Disclosures,Sellers Disclosure','1','Freestanding,Gas Connections','1','Omega Bay','Central Gas,Zoned','1','ABST 7 S C BUNDICK SUR LOT 4 OMEGA BAY SEC 2','Cleared,Waterfront','4500','Appraisal District','','300','0','','2','Gas Oven','0','','','Gas Cooktop,Gas Range','','Other','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Appointment Required,Lockbox Front','Appraisal District','2.5','Contemporary/Modern','Omega Bay Numbered Sections','13161','2.8033','Public Sewer,Public Water,Water District','2020','Appraisal District'); --> New record created successfully