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-29T19:20:10.870' ,`MLSNumber` = '93577876' ,`ListAgentFullName` = 'Rhonda Evans' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.319231' ,`Longitude` = '-94.990684' ,`PhotoCount` = '32' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2250' ,`StreetNumber` = '594' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this beautiful home in Tarkington prairie. This home boasts 4 bedrooms and 2 baths. Living room has french doors that open to a beautiful backyard. 3 car garage shop with office/rooms with unlimited possibilities. Potential for home business or apartment. Enjoy the scenic backyard with almost 3 acres and a pond located at the back of the property. Great home with country living.' ,`Acres` = '2.879' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PINE SHADOW VILLAGE, LOT 38, ACRES 2.58' ,`LotDesciption` = 'Cleared' ,`LotSize` = '125409' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '102 - Tarkington' ,`SchoolElementary` = 'TARKINGTON PRIMARY SCHOOL' ,`SchoolHigh` = 'TARKINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'TARKINGTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Shadow Village' ,`TaxAmount` = '4120' ,`TaxRate` = '1.5226' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097163' WHERE `Matrix_Unique_ID` = '207367214'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T20:16:15.370' ,`MLSNumber` = '28255585' ,`ListAgentFullName` = 'Elsa Kelleher' ,`ListOfficeName` = 'Gold Quest Realty- Galleria' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748641' ,`Longitude` = '-95.329364' ,`PhotoCount` = '11' ,`PostalCode` = '77011' ,`RoomCount` = '4' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Canal' ,`StreetNumber` = '4426' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMIN DUPLEX WITH LOTS OF POTENCIAL, NEAR DOWNTON AND MINUTE MAID PARK. THIS IS AN UPCOMING, POPULAR, AND GREAT LOCATION IN THE EAST END REVITALIZED AREA. THIS FLEXIBLE BUNGALOW COULD BECOME A CASH FLOW INCOME INVESMENT, AS A RESIDENTIAL OR COMERCIAL RENTAL. GREAT OPORTUNITY TO START A HOME OFFICE OR SMALL BUSINESS.  EXTERIOR PAINTING IN PROGRESS.\r\n(THIS PROPERTY WAS A SINGLE FAMILIY \"3 OR 4 BEDROOM,2BATH . REHABBED FROM TOP TO BOTTOM\" ON 2016) CONVERTED TO A DUPLEX ON 2017. PLEASE DO NOT DISTURB TENANTS.' ,`Acres` = '0.1475' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 & W 27 FEET LT 4 BLK 49 OAK LAWN' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '6425' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LANTRIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Oak Lawn' ,`TaxAmount` = '' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1932' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097163' WHERE `Matrix_Unique_ID` = '209413143'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T19:35:47.217' ,`MLSNumber` = '10911383' ,`ListAgentFullName` = 'Ted Simon' ,`ListOfficeName` = 'Ted Simon Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.487553' ,`Longitude` = '-94.916581' ,`PhotoCount` = '16' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = 'Broadway' ,`StreetNumber` = '418' ,`StreetSuffix` = '' ,`City` = 'San Leon' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super home for the person who want to take a two to three-block walk to the Gulf Coast shoreline.  Tiny home which has just had repairs completed and repainted.  No flooding of record.  Close to popular restaurants, public boat ramps and parks.  Come see the sunny San Leon area.  Ameneties nearby include the seaside Sunset Bar with nearby fishing including a lengthy fishing pier.  Close by restaurants with a variety of tasty seafood include Pier 6, Gilhooleys and Top Water Grill.' ,`Acres` = '0.0775' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOT 2 BLK 102 SAN LEON' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '1378' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097164' WHERE `Matrix_Unique_ID` = '211765820'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T19:14:37.803' ,`MLSNumber` = '92499270' ,`ListAgentFullName` = 'Lori Gunnels' ,`ListOfficeName` = 'United Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.982114' ,`Longitude` = '-95.454582' ,`PhotoCount` = '29' ,`PostalCode` = '77014' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Winter' ,`StreetNumber` = '12638' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2810' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming property seeks new owners to make it their forever home!  With over 2800 sq ft, this home boasts plenty of space to host a large gathering!  4 bedrooms, 2 1/2 baths, and a game room upstairs.  The primary bedroom is downstairs with a huge walk-in closet.  Storage space under the stairs too!  Covered back patio and no neighbors behind you!  Make your appointment today!' ,`Acres` = '0.124' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 2 SILVERGLEN NORTH SEC 11' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverglen North Sec 14' ,`TaxAmount` = '7385' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097164' WHERE `Matrix_Unique_ID` = '211998230'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T20:05:36.770' ,`MLSNumber` = '45919481' ,`ListAgentFullName` = 'Johnny Tran' ,`ListOfficeName` = 'Texas Ally Real Estate Group,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735150' ,`Longitude` = '-95.363404' ,`PhotoCount` = '31' ,`PostalCode` = '77004' ,`RoomCount` = '5' ,`ListPrice` = '449900.00' ,`Status` = 'Active' ,`StreetName` = 'Anita' ,`StreetNumber` = '2510' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1898' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Modern freestanding homes in the highly sought after Emancipation Park neighborhood. Contemporary design with many upgraded features including luxury vinyl plank floors, quartz countertops, stainless steel appliances, shaker style cabinets, modern backsplash, and much more. The neutral colors make the home feel very warm and inviting. Enjoy entertaining your guests with the open living/kitchen area leading to a large private balcony. Convenient location to downtown, freeways, and the newly renovated Emancipation Park. No HOA so short term rentals allowed. Expected home completion in mid Jan 2023' ,`Acres` = '' ,`Area` = '4' ,`BuilderName` = 'Andares' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 2 Block 1 Anita Landing' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Anita Landing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097164' WHERE `Matrix_Unique_ID` = '212202700'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T19:52:12.083' ,`MLSNumber` = '51510732' ,`ListAgentFullName` = 'Colt Haack' ,`ListOfficeName` = 'Coldwell Banker Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.086157' ,`Longitude` = '-96.080375' ,`PhotoCount` = '33' ,`PostalCode` = '77445' ,`RoomCount` = '5' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = '11th' ,`StreetNumber` = '2006' ,`StreetSuffix` = 'Street' ,`City` = 'Hempstead' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This alluring three-bedroom home is ready to captivate your attention! Situated on a desirable corner lot, this home brims with natural light and elegant interior finishes that set the tone for contemporary living. All of this is perched on a large 0.39-acre parcel of land with plenty of room for everyone to live, relax, and play.\r\n\r\nFeel at home from the moment you step inside and be greeted by polished hardwood floors that line the entire floor plan. The kitchen is the heart of the home, featuring modern stainless steel appliances, beautiful white cabinetry, and a large center island with pendant lights shining overhead.\r\n\r\nThe kitchen seamlessly opens to the light-filled lounge, allowing you to contribute to living room conversations while you prepare a nice meal. \r\n\r\nEnjoy plenty of parking space, including a detached carport and an outbuilding that combines the garage and laundry. Welcome home to a life of comfort!' ,`Acres` = '0.287' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S519000 HEMPSTEAD BLK 505 LOT 1 & 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '12502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hempstead' ,`TaxAmount` = '3446' ,`TaxRate` = '2.4184' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675097164' WHERE `Matrix_Unique_ID` = '212692048'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-29T19:04:54.800' ,`MLSNumber` = '69916420' ,`ListAgentFullName` = 'Pamela McVaugh' ,`ListOfficeName` = 'McVaugh Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731416' ,`Longitude` = '-95.583386' ,`PhotoCount` = '10' ,`PostalCode` = '77082' ,`RoomCount` = '7' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Royal Plain Avenue' ,`StreetNumber` = '11602' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2326' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 Bedroom 3.5 baths under construction.Houston\'s Residential Community of the Year. Adjacent to Royal Oaks Country Club & only 6.5 miles from The Galleria! Luxury living at its finest with German cabinetry and appliances. Prefect for intergenerational family. Enjoy the privacy of a Gated Community, clubhouse & fitness room. Incredible lock & leave home minutes from Houston\'s Energy Corridor. Save thousands per year with NO MUD TAX and construction to LEED standards! HOA fee includes clubhouse, gym, landscape maintenance, trash collection, and exterior maintenance. Under construction.' ,`Acres` = '0.0918' ,`Area` = '31' ,`BuilderName` = 'McVaugh Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Westchase Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 ROYAL OAKS COURTYARD VILLAS AMEND' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '6930' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'OUTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Controlled Access,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Royal Oaks Courtyard Villas' ,`TaxAmount` = '18942' ,`TaxRate` = '2.529' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097165' WHERE `Matrix_Unique_ID` = '214065849'  --> 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','215251147','1675097165','215251147','2022-12-29T20:49:42.533','45950284','Maria Molina-Alban','eXp Realty, LLC','','','29.683865','-95.343318','15','77033','3','188000.00','Active','Malmedy','5110','Road','Houston','1','0','3','1333','Single-Family','Nice remodeled home 3 bed/ 2 full baths with spacious master bedroom. Property features a den/office area. No Carpet at all! Property gated for your security. Relax on this cozy home! Make your appointment today! It has easy access to the 610 loop and Highways 288. The property isconveniently located near downtown Houston, the Medical Center, and the Hobby Airport.','0.1391','3','','','Electric Dryer Connections,Washer Connections','','Owner/Agent','','','','Medical Center South','Central Electric','0','LT 3 BLK 11 SOUTH PARK SEC 2','Cleared','6058','Appraisal District','','','0','','0','','0','','','Electric Range','','Composition','27 - Houston','KELSO ELEMENTARY SCHOOL','WORTHING HIGH SCHOOL','ATTUCKS MIDDLE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','South Park Sec 02','2230','2.3307','Public Water','1955','Appraisal District');  --> New record created successfully<br />