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-08-02T16:04:33.320' ,`MLSNumber` = '45570803' ,`ListAgentFullName` = 'Kyle Craycraft' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.328072' ,`Longitude` = '-95.446066' ,`PhotoCount` = '26' ,`PostalCode` = '75835' ,`RoomCount` = '3' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland' ,`StreetNumber` = '233' ,`StreetSuffix` = 'Circle' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL HOME! \r\n This nicely updated three bedroom, two bath brick home sits on a 0.51-acre corner lot inside Loop 304, and has been impeccably kept by its owners. The home has a new roof and new wooden privacy fencing around its large backyard. Once you visit, you’ll notice the double French doors at the rear, freshly painted interior walls, new interior doors, and new durable laminate lock-in plank flooring.  The kitchen has a new matching set of chrome Frigidaire kitchen appliances that are surrounded by new cabinetry and new fixtures throughout. You’ll love the open concept throughout the living and kitchen for easy entertaining. The living area has a fireplace to keep you warm. The master bedroom has a private bath, while two guest bedrooms share a hall bath. Outdoors, you’ll enjoy the pretty shade trees, welcoming front porch, and covered back patio. This is a great home, so give us a call today to schedule a private tour.' ,`Acres` = '0.51' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROLLING ACRES LOT 35 SEC B' ,`LotDesciption` = 'Corner' ,`LotSize` = '22216' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rolling Acres Estates' ,`TaxAmount` = '2420' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '204308210'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T16:58:47.960' ,`MLSNumber` = '95134435' ,`ListAgentFullName` = 'Barbara Kearns' ,`ListOfficeName` = 'Coldwell Banker Southern Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.195527' ,`Longitude` = '-94.193361' ,`PhotoCount` = '24' ,`PostalCode` = '77657' ,`RoomCount` = '8' ,`ListPrice` = '184900.00' ,`Status` = 'Active' ,`StreetName` = 'Edna' ,`StreetNumber` = '230' ,`StreetSuffix` = 'Drive' ,`City` = 'Lumberton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2091' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME! This updated four-bedroom home sits on over half of an acre & is ready for you to call it your own. Open concept makes great for entertaining & precious memories to be made. The kitchen has granite countertops & breakfast bar. Step through your French doors into your backyard oasis! Don\'t wait to call this place home!' ,`Acres` = '0.62' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 9 & 10 UNIT B ROSELAWN PARK P# CL26-B-7 I# 2019-96063 0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rose Hill Acres' ,`TaxAmount` = '4060' ,`TaxRate` = '1.9738' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '206805127'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T17:03:29.400' ,`MLSNumber` = '89386827' ,`ListAgentFullName` = 'Ray Walker' ,`ListOfficeName` = 'RealtyWalk' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.517962' ,`Longitude` = '-95.082839' ,`PhotoCount` = '28' ,`PostalCode` = '77573' ,`RoomCount` = '8' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = '2nd' ,`StreetNumber` = '1519' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautifully remodeled home is currently being used as a Home Office. It is a “residential home” located in a “commercially zoned” area. And, this includes the ADJACENT LOT! The total size of land is approximately 23,915 sq.ft. See attached surveys. The additional LOT currently has been permitted to be an asphalt parking lot. Or, ask City for other possible uses. The home has a large open floor plan (see attached)! The huge kitchen has a 4x8 granite center island; travertine floors; cabinets to the ceiling; double ovens; and gas stove with hood/fan above. Incredibly large closets, the Primary Closet is 20x7! Large front 12x8 porch/deck. Plus two large back wood decks in the back overlooking the backyard. Located in the popular Downtown District of League City just off Main Street. This is an amazing home with so many possibilities. And, it shows beautifully.' ,`Acres` = '0.549' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 7 BLK 1 TIEGS 2ND ADDN' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '23915' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'LEAGUE CITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Tiegs' ,`TaxAmount` = '5694' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '207523224'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T17:01:53.943' ,`MLSNumber` = '24987410' ,`ListAgentFullName` = 'Antonieta Gomez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669128' ,`Longitude` = '-95.626234' ,`PhotoCount` = '25' ,`PostalCode` = '77498' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Clark Towne' ,`StreetNumber` = '13826' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1604' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 1 story home well maintained, features 4 Bedrooms & 2 Baths. Recent updates in 2020 include laminate floors throughout the house, tile floor in both bathrooms, kitchen granite countertops with stainless steel appliances. Freshly painted interior, new tile shower. Easy access to HWY 6, 59, and Westpark Tollway. Excellent school District and minutes away from shopping and dining areas. Schedule your showing today!' ,`Acres` = '0.1433' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TOWNEWEST SEC 1, BLOCK 16, LOT 16, R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '360' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'TOWNEWEST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Townewest Sec 1' ,`TaxAmount` = '4037' ,`TaxRate` = '2.3329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '208697637'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T16:20:06.770' ,`MLSNumber` = '50093731' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.946989' ,`Longitude` = '-95.380391' ,`PhotoCount` = '22' ,`PostalCode` = '75862' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Elizabeth' ,`StreetNumber` = '309' ,`StreetSuffix` = 'Street' ,`City` = 'Trinity' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1522' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Check out this charming 3 bed 1.5 bath 1,522 Sq. Ft. home situated on a 0.35 acre lot! The family room is spacious, and partially open to the kitchen which features an electric cooktop, gas oven, dishwasher, granite countertops, and ample cabinetry. All of the bedrooms are generously sized, and the primary bedroom features a gorgeous farmhouse door and access to the backyard. Step out the backdoor into your own covered porch and private cleared paradise! The backyard has plenty of space for recreation. Oversized lots within city limits are rare, schedule a viewing today!' ,`Acres` = '0.3585' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'WINDY HILL ADDN, LOT 04,05' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Windy Hill Add' ,`TaxAmount` = '2297' ,`TaxRate` = '2.5001' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '210781580'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T17:49:43.410' ,`MLSNumber` = '2732064' ,`ListAgentFullName` = 'Jeannette Cantu' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '38.926610' ,`Longitude` = '1.231215' ,`PhotoCount` = '27' ,`PostalCode` = '07830' ,`RoomCount` = '5' ,`ListPrice` = '2975000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenida de Cala Moli' ,`StreetNumber` = '68' ,`StreetSuffix` = '' ,`City` = 'Ibiza' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4305' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Exclusive luxury 5 bedrooms villa in one of the most privileged and quiet areas of the island. Special spaces designed to include all the lates technology and topped off with the sea views. Open floor plan with fully equipped Kitchen. Infinity pool where you can enjoy the best sunset and the best turquoise water of the Mediterranean.' ,`Acres` = '' ,`Area` = '' ,`BuilderName` = 'Madrid' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '6804946CD4160S0001OS' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '7534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Avenida De Cala Moli 68' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '210922601'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T17:09:38.287' ,`MLSNumber` = '52249814' ,`ListAgentFullName` = 'Lizna Chagani' ,`ListOfficeName` = 'Apex Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599621' ,`Longitude` = '-95.235326' ,`PhotoCount` = '29' ,`PostalCode` = '77089' ,`RoomCount` = '8' ,`ListPrice` = '269786.00' ,`Status` = 'Active' ,`StreetName` = 'Sagestar' ,`StreetNumber` = '10407' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Completely Remodeled Single Family Home. Home Consists of 3 bed and 2 full bath. Very welcoming entrance straight into a spacious living room. Tons of Upgrades, Oversized Lot with mature trees, Cathedral ceiling, New AC, New Roof, New water heater, New Flooring- Tile and Carpet, New Paint, New Cabinets, New Electrical, New Plumbing, New doors. New Fence. Make this your new home today. Virtual tour Available.' ,`Acres` = '0.3221' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 KIRKMONT SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkmont Sec 03' ,`TaxAmount` = '2742' ,`TaxRate` = '2.6655' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663693699' WHERE `Matrix_Unique_ID` = '210966088'  --> Updated record success<br />