Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T08:05:03.363' ,`MLSNumber` = '70276553' ,`ListAgentFullName` = 'Rosa Martinez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.684567' ,`Longitude` = '-95.287429' ,`PhotoCount` = '17' ,`PostalCode` = '77087' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Edna' ,`StreetNumber` = '7653' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '906' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.18' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 2 SANTA ROSA SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7842' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CORNELIUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Rosa Sec 01' ,`TaxAmount` = '3074' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1944' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094967' WHERE `Matrix_Unique_ID` = '211392718'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T07:28:21.113' ,`MLSNumber` = '33960457' ,`ListAgentFullName` = 'Austin Shaw' ,`ListOfficeName` = 'The Daily Agent' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811728' ,`Longitude` = '-95.351576' ,`PhotoCount` = '13' ,`PostalCode` = '77009' ,`RoomCount` = '3' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Elysian' ,`StreetNumber` = '5704' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1419' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pre-Construction Sale - Ask about our single close product to secure your rate today.  NO HOA and modern finishes that include solid wood cabinets, quartz countertops, engineered flooring, brand name fixtures, stainless appliances and other energy efficient amenities. Fully fenced front and rear yards. Located less than 5 miles from Downtown, the Heights and East River Development. Easy access to all major freeways (610, I45, 59 & I10).' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'SFT Construction' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 3 BLOCK 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elysian Enclave' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094967' WHERE `Matrix_Unique_ID` = '212782369'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T07:25:56.957' ,`MLSNumber` = '80615209' ,`ListAgentFullName` = 'Bekhal Saeed' ,`ListOfficeName` = 'M&M Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731494' ,`Longitude` = '-95.522748' ,`PhotoCount` = '22' ,`PostalCode` = '77063' ,`RoomCount` = '3' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Gabriel St' ,`StreetNumber` = '9002' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy two bed, one bath home. Great for a first time buyer or investor. Ready to move-in. Recently remodeled with new flooring, new appliances, new roof, and a new water heater.\r\nAll room dimensions are approximate, buyer agent to verify for accurate dimensions.' ,`Acres` = '0.124' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 9 CARVER CREST R/P & EXTN' ,`LotDesciption` = 'Corner' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'EMERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Carver Crest R/P & Ext' ,`TaxAmount` = '3091' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094967' WHERE `Matrix_Unique_ID` = '213196135'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T07:09:24.030' ,`MLSNumber` = '61810860' ,`ListAgentFullName` = 'Erica Morhet' ,`ListOfficeName` = 'Riverbend Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.554394' ,`Longitude` = '-95.272676' ,`PhotoCount` = '31' ,`PostalCode` = '77581' ,`RoomCount` = '3' ,`ListPrice` = '349100.00' ,`Status` = 'Active' ,`StreetName` = 'Westminister' ,`StreetNumber` = '3206' ,`StreetSuffix` = 'Street' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 3 bedroom 2 bath home has a nice open floorplan located in Pearland right off Hw 35. Kitchen has beautiful granite countertops with plenty of cabinet space for all your needs with a dining area overlooking the spacious living room which is great for entertainment. There is a spacious area perfect for a pool table located right off the kitchen area. Each bedroom closet is designed with custom shelving as well as carpet in each bedroom. A beautiful soaking tub is found in the hall bath which is great for a relaxing evening. This home has a spacious backyard for many activities as well with a rod iron gate enclosing the drive and back yard. The front porch is secured with a rod iron fence and gate to the front door for a little extra security.' ,`Acres` = '0.3253' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WESTMINISTER (PEARLAND) LOT 26-27A (W/934 SQ FT)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '14170' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Westminister Pearland' ,`TaxAmount` = '5976' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094967' WHERE `Matrix_Unique_ID` = '213287145'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T07:21:37.817' ,`MLSNumber` = '45916380' ,`ListAgentFullName` = 'Erika Hernandez' ,`ListOfficeName` = 'HOUSTON TOP REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.460293' ,`Longitude` = '-95.466191' ,`PhotoCount` = '29' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '279999.00' ,`Status` = 'Active' ,`StreetName` = 'Autumn Flats' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Way' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1685' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This 3 bed 2 bath home features a beautiful stone decorative wall & mock fireplace in living room, extended patio slab, huge primary bath & walk in closets, open concept perfect for entertaining. This resale feels like new ! Immaculately maintained interior & exterior. CALL FOR YOUR appointment today. Hablamos espanol.' ,`Acres` = '0.132' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 3B, BLOCK 2, LOT 17' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 3b' ,`TaxAmount` = '6020' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094968' WHERE `Matrix_Unique_ID` = '214620838'  --> Updated record success<br />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','215143103','1675094968','215143103','2022-12-24T08:51:00.850','24889665','Chancey Hurt','JPAR - The Sears Group','','','29.709550','-95.406477','46','77030','22','2950000.00','Active','Southgate','2050','Boulevard','Houston','6','1','6','7675','Single-Family','Gorgeous Modern Mediterranean Design(6 Bd-6.5 Ba) 100% Steel Framed home & Reinforced Hebel Concrete! Located in the prime \"Southgate Subdivision\" of the historical Rice Village!  An area known for its iconic landscape,shopping,dining & discovery for generations! This unique beauty is consistent with artistic angles that of which flow throughout this amazing home! Enjoy the views from the panoramic glass door \"ActivWall Sliding System\". This incredible feature allows \"Full Access\" to your backyard,outdoor grill,resort-style pool & your marble patio with cozy fire-pit for entertaining! There are endless features to this home and even options for accommodating a \"Multi-Family\" layout: Granite Kitchen,Carrara Marble Bathrooms,Primary Soaking Tub,Executive Style Closet,Media Room,Butler Pantry,Wet Bar,Wine Cellar,Thermador Appliances & 50 Year Warranty TPO Roofing! Hebel Constructed homes are also resistant to fire,extreme weather,level F5 hurricane strength winds,tornados & even pests!','','17','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Rice/Museum District','Central Electric','0','LT 27 & TR 28A BLK 21 SOUTHGATE','Subdivision Lot','11875','Appraisal District','','','0','','2','Double Oven,Electric Oven,Freestanding Oven','1','Gunite,In Ground','','Gas Cooktop,Gas Range,Grill','','Other','27 - Houston','ROBERTS ELEMENTARY SCHOOL (HOUSTON)','LAMAR HIGH SCHOOL (HOUSTON)','PERSHING MIDDLE SCHOOL','Accompany,Appointment Required,Controlled Access,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern,Mediterranean,Other Style','Southgate Subdivision','','','Public Sewer,Public Water,Water District','2016','Appraisal District');  --> New record created successfully<br />