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-09-03T06:55:47.127' ,`MLSNumber` = '31484586' ,`ListAgentFullName` = 'Dena Trice' ,`ListOfficeName` = 'Mary Dunn Real Estate, Inc.   ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730320' ,`Longitude` = '-94.689901' ,`PhotoCount` = '8' ,`PostalCode` = '77514' ,`RoomCount` = '3' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Main St' ,`StreetNumber` = '4162' ,`StreetSuffix` = '' ,`City` = 'Anahuac' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2218' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sunset, unrestricted, bay front, AMAZING +/-11 Acres. Waterfront approx 464 sqft. Property is high and has never flooded. This is an estate. Home needs major repairs including slab, walls, plumbing, AC, or seller will demolish home at buyers request.' ,`Acres` = '11' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '241 3A-1 A TAYLOR SUR' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '479160' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Taylor' ,`TaxAmount` = '2810' ,`TaxRate` = '2.8113' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663706232' WHERE `Matrix_Unique_ID` = '200592901'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T06:22:15.263' ,`MLSNumber` = '69982428' ,`ListAgentFullName` = 'Rosemary Choi' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = 'Marla Reade' ,`SellingOfficeName` = 'Compass RE Texas, LLC' ,`Latitude` = '29.757480' ,`Longitude` = '-95.469372' ,`PhotoCount` = '27' ,`PostalCode` = '77056' ,`RoomCount` = '14' ,`ListPrice` = '3295000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Tilbury' ,`StreetNumber` = '5358' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '7183' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mediterranean Masterpiece! Incredible original builder\'s personal home with every bell & whistle! Exceptional finishes with imported custom carved doors, walnut floors, travertine, quartz, 1-piece stone sinks, 2 dual sided fireplace, formals, Billard/Game Room with bar, Media room, 2-story Library PLUS Home Office, Mud Room, Kitchen with large island, Breakfast, Family rooms & 4 bedrooms w/ensuite baths! Entry with terracotta ceiling, elevator capable, pool plus covered veranda with summer kitchen, circular & gated drive to 3-car garage & guest suite! A MUST SEE!' ,`Acres` = '0.3218' ,`Area` = '22' ,`BuilderName` = 'Black Stone' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 8 TANGLEWOOD SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14016' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Tanglewood' ,`TaxAmount` = '68046' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706232' WHERE `Matrix_Unique_ID` = '202586451'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T07:56:19.837' ,`MLSNumber` = '55035614' ,`ListAgentFullName` = 'Rita Chanchlani' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661142' ,`Longitude` = '-95.688906' ,`PhotoCount` = '32' ,`PostalCode` = '77407' ,`RoomCount` = '12' ,`ListPrice` = '715000.00' ,`Status` = 'Active' ,`StreetName` = 'Viscount' ,`StreetNumber` = '10410' ,`StreetSuffix` = 'Landing' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4458' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nestled in the master-planned Aliana community, this beautiful 4-bedroom, 4.5-bathroom home features high ceilings, tile flooring, ample natural light, a formal entry, 3-car garage, formal living and dining room, all bedrooms with ensuite baths, gameroom and a library, complete with an extended covered patio, and outdoor kitchen. The gourmet kitchen is a chef’s dream, boasting granite countertops, a tile backsplash, gas cooktop, pantry and a butlers pantry. The oversized primary suite includes a walk-in california closet, dual vanities, soaking tub, and oversized shower. Too many upgrades to mention. Come see for yourself. Enjoy resort-style amenities at Aliana’s clubs, tennis courts, fitness centers, parks, nature trails, and swimming pools. Located off the Westpark Tollway & Grand Parkway, close proximity to Katy and Sugar Land’s best dining, shopping & entertainment. Zoned to most acclaimed Fort Bend school district!' ,`Acres` = '0.2569' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ALIANA SEC 10, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11190' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MADDEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRAVIS HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Aliana Sec 10' ,`TaxAmount` = '13664' ,`TaxRate` = '2.9329' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706233' WHERE `Matrix_Unique_ID` = '208215608'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T07:44:23.383' ,`MLSNumber` = '46309587' ,`ListAgentFullName` = 'Eric Wolter' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.216266' ,`Longitude` = '-95.427429' ,`PhotoCount` = '39' ,`PostalCode` = '77385' ,`RoomCount` = '4' ,`ListPrice` = '299500.00' ,`Status` = 'Active' ,`StreetName` = 'Accolade' ,`StreetNumber` = '16807' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2231' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to beautiful Montgomery Creek Ranch - Just minus off interstate 45. Enjoy spacious living room with corner fireplace (visible from formal dining and kitchen). First flood office or possible 4th bedroom. Game room (up) for kids place space. Community park/pool/ splash pad just a block away. Buyer move in ready or great investment property!' ,`Acres` = '0.1227' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S720806 - MONTGOMERY CREEK RANCH 06, BLOCK 6, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5346' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SUCHMA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Creek Ranch 06' ,`TaxAmount` = '5608' ,`TaxRate` = '2.6088' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706233' WHERE `Matrix_Unique_ID` = '209214625'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T07:31:32.747' ,`MLSNumber` = '12637293' ,`ListAgentFullName` = 'Karla Jimenez' ,`ListOfficeName` = 'Bayou Vista Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.417044' ,`Longitude` = '-95.817384' ,`PhotoCount` = '21' ,`PostalCode` = '77461' ,`RoomCount` = '8' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Seguin Trail' ,`StreetNumber` = '11202' ,`StreetSuffix` = 'Court' ,`City` = 'Needville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2903' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Needville! This beautiful four bedroom, three bath house has high ceilings and spectacular details. With a formal dinning room, a breakfast nook and dry bar, it is the perfect place to host gatherings and spend quality time at home. Not to mention the enormous lot space. Located at the end of the cul-de-sac with no neighbors behind the property, it is the perfect, tranquil oasis. With easy access to US 59 and Grand Parkway 99, shopping and retail centers are around the corner. Let\'s make this house your home. Schedule your showing today!' ,`Acres` = '0.7209' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TEJAS TRAILS SUBDIVISION, BLOCK 1, LOT 46' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '31402' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tejas Trails Sub' ,`TaxAmount` = '402' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706233' WHERE `Matrix_Unique_ID` = '209549673'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T06:31:51.133' ,`MLSNumber` = '10756530' ,`ListAgentFullName` = 'Amy Phuong Huynh' ,`ListOfficeName` = 'B & W Realty Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.708661' ,`Longitude` = '-95.747642' ,`PhotoCount` = '32' ,`PostalCode` = '77450' ,`RoomCount` = '9' ,`ListPrice` = '419999.00' ,`Status` = 'Active' ,`StreetName` = 'Cottage Cove' ,`StreetNumber` = '20850' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this gorgeous one-story home in Grand Lakes! Great floor plan, high ceiling, and fresh paint entire of the whole house. New wood floor in all bedrooms. Family room opens to the kitchen and breakfast area. Spacious formal dining room and living room right as the main entrance. Minutes aways to trails/park, playground, pool, and tennis courts. Excellent Katy ISD schools. This beautiful 4 bedrooms, 2 bathrooms home is waiting on you. It\'s vacant and ready to move-in!' ,`Acres` = '0.166' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND LAKES PHASE THREE SEC 9, BLOCK 3, LOT 10' ,`LotDesciption` = 'Corner' ,`LotSize` = '7231' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ALEXANDER ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'SEVEN LAKES HIGH SCHOOL' ,`SchoolMiddle` = 'BECKENDORFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Lakes Ph Three Sec 9' ,`TaxAmount` = '3534' ,`TaxRate` = '2.5063' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706233' WHERE `Matrix_Unique_ID` = '211595158'  --> 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','211601648','1663706233','211601648','2022-09-03T06:18:19.910','39149972','Andrea Keiller','RE/MAX The Woodlands & Spring','','','30.166685','-95.628003','50','77354','16','1450000.00','Active','Riata','23','Drive','Magnolia','4','2','4','7706','Single-Family','Located in the desirable gated neighborhood of the Ranches of Pinehurst this outstanding home offers privacy, enormous entertaining space with convenient access to The Woodlands. Dramatic entry with sweeping iron staircase, wall of windows overlooking the fabulous backyard, both formals with wood flooring, huge master retreat with sitting room, exercise room & fireplace, powder with travertine sink, study with extensive built-ins and shelving, gourmet kitchen with butlers pantry, wine fridge, two warming drawers, double oven, vegetable sink, compactor, 6 ring gas range & large breakfast bar. Upstairs an incredible game room, outside patio with spiral iron staircase to below, extra room with full bar, fridge and media room with 110\" TV screen. 3 large secondary bedrooms with walk in closets. Tropical backyard with summer kitchen, fridge, 3 burners, griddle, grill & pool bath with shower. Sparkling pool with water features. 4 car garage with epoxy coating. The perfect entertaining home!','5','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','2','Magnolia/1488 East','Central Gas,Zoned','1','A0205 FOSTER JOHN, TRACT 1E-3, ACRES 5.000','Wooded','217800','Appraisal District','','804','0','','4','Double Oven,Electric Oven','1','Gunite,In Ground','','Gas Cooktop','','Composition','36 - Magnolia','CEDRIC C. SMITH ELEMENTARY SCHOOL','MAGNOLIA HIGH SCHOOL','BEAR BRANCH JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Ranches of Pinehurst','22324','1.8587','Septic Tank,Well','2005','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T07:05:48.657' ,`MLSNumber` = '96594147' ,`ListAgentFullName` = 'Crystal Gallegos' ,`ListOfficeName` = 'Scarlet Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936639' ,`Longitude` = '-95.228916' ,`PhotoCount` = '24' ,`PostalCode` = '77396' ,`RoomCount` = '7' ,`ListPrice` = '259900.00' ,`Status` = 'Active' ,`StreetName` = 'Harbor Canyon' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, well maintained, one story home in a great location! New carpet, freshly painted and a new garage door installed. Great layout with high ceilings, open concept with split bedrooms, and two living room spaces. Home is move in ready!' ,`Acres` = '0.1102' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 46 BLK 4 SUNSET RIDGE WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4801' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunset Rdg West Sec 03' ,`TaxAmount` = '5152' ,`TaxRate` = '3.0673' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706233' WHERE `Matrix_Unique_ID` = '211673244'  --> 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','212064432','1663706233','212064432','2022-09-03T07:56:11.150','33392308','Nick Janke','Janke and Co Properties','','','29.918235','-95.192450','36','77044','10','759000.00','Active','Cascade Caverns','16347','Lane','Houston','4','1','4','4800','Single-Family','WOW! This is an amazing 4 bedroom, 4 1/2 bath with media room, builder upgrades, large lot size and no back neighbors. Located in Summerwood only a short distance from Lake Houston.','0.3644','1','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','1','Summerwood/Lakeshore','Central Gas','1','LT 4 BLK 3 SUMMERWOOD SEC 30','Greenbelt','15874','Appraisal District','','795','0','','2','Single Oven','0','','','Gas Cooktop','','Composition','29 - Humble','SUMMERWOOD ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','WOODCREEK MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Split Level','Summerwood Sec 30','12689','2.7932','Public Sewer,Public Water','2010','Appraisal District');  --> New record created successfully<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','212156151','1663706233','212156151','2022-09-03T07:31:06.010','21653269','Jennifer Ciulla','RE/MAX Fine Properties','','','30.489748','-98.074859','49','78654','8','1750000.00','Active','Lookout Ridge','5300','Drive','Marble Falls','3','1','3','2250','Single-Family','Nestled in a private cove on the north side of Lake Travis offering a tranquil escape and sprawling views just a short drive from Austin, Texas. Featuring a stunning hill country inspired residence, large barn, private boat ramp & private cove. Enjoy the open floorplan living spaces. The primary retreat provides scenic nature views, double vanity sinks, and 2 walk-in closets. Seamless spaces flow outdoors to 2 open-air terraces showcasing picturesque unobstructed views of Lake Travis & Muleshoe Bend. Horses allowed.','7.5405','83','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','','Central Gas','1','LOT 12 LOOKOUT RIDGE','Cleared,Corner,Waterfront','328464','Appraisal District','','300','0','','4','Convection Oven,Electric Oven','0','','','Gas Cooktop','','Aluminum','124 - Marble Falls','COLT ELEMENTARY SCHOOL','MARBLE FALLS HIGH SCHOOL','MARBLE FALLS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Right Side','Builder','2','Other Style','Lookout Ridge','','','Aerobic,Septic Tank,Well','2007','Appraisal District');  --> New record created successfully<br />