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` = '2023-01-06T10:37:43.353' ,`MLSNumber` = '31505637' ,`ListAgentFullName` = 'Teresa Galvan Lanado' ,`ListOfficeName` = 'Central Metro Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765561' ,`Longitude` = '-95.403394' ,`PhotoCount` = '24' ,`PostalCode` = '77007' ,`RoomCount` = '2' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Dickson' ,`StreetNumber` = '4302' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1204' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated bungalow in a trendy West End Terrace neighborhood, close to entertainment, memorial park, dining spots, etc. The home has brand-new granite countertops and appliances in an open kitchen that connects with the dining space. Recently updated front windows, refinished natural wood floors, and updated bathrooms. Up front, there is a brand new bungalow deck to enjoy relaxing afternoons. The home has extra parking space at the back plus the garage is finished with a storage area, a separate laundry room, and a new extra bathroom.' ,`Acres` = '0.0918' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 3 WEST END TERRACE' ,`LotDesciption` = 'Other' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Mediterranean,Other Style,Ranch,Spanish,Traditional' ,`Subdivision` = 'West End Terrace' ,`TaxAmount` = '9108' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115700' WHERE `Matrix_Unique_ID` = '214891475'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-21T13:26:35.363' ,`MLSNumber` = '75767449' ,`ListAgentFullName` = 'Patricia Erwin' ,`ListOfficeName` = 'Patricia Erwin Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421535' ,`Longitude` = '-95.260305' ,`PhotoCount` = '45' ,`PostalCode` = '77511' ,`RoomCount` = '9' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Blum' ,`StreetNumber` = '1611' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Home located in Alvin, Texas * 4 Bedrooms * 3 Full Baths * 2 Car Garage * Game Room * Formal Dining * Kitchen Open to Family Room * Split Floor Plan * Primary Bedroom & 2 Bedrooms downstairs * 1 Large Bedroom & Game Room (could be another Bedroom) upstairs * Primary Bath features Double Sinks, Jacuzzi Tub, Separate Shower and Walk-In Closet * Recessed Lighting & Ceiling Fans through-out * Covered Patio * Garage insulated and finished out with Sheetrock, Paint and Recessed Lighting * Double Wide Driveway * Garage Door Opener * Easy Access to Highway 35 & Highway 6!!' ,`Acres` = '0.1434' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'EASTON (ALVIN) BLK 39 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MELBA PASSMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Easton Alvin' ,`TaxAmount` = '9069' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115700' WHERE `Matrix_Unique_ID` = '214892262'  --> 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','214892439','1676115700','214892439','2023-02-05T15:54:04.577','62957344','Lorannette Lewis','In Town Properties','','','29.821370','-95.422431','20','77018','7','564900.00','Active','Wakefield','945','','Houston','2','1','3','2422','Single-Family','The Athens, built by Sandcastle Homes, is a 2-story, freestanding home in Garden Oaks! The property\'s standard features include wood flooring in the living and dining area and stairs. Enjoy a spacious kitchen equipped with stainless-steel appliances, custom cabinets, and quartz countertops! Head upstairs to the game room, complete with built-in shelves. \r\n\r\nAll of the bedrooms, including the utility room, can be found on the second floor. The Primary Bedroom is extremely spacious, allowing the buyer to get creative! Its spa-like bath is a dream with its two separate vanities, soaking tub, and shower. Move-In-Ready in January 2023!','','9','Sandcastle Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','No Disclosures','1','','','Oak Forest East Area','Central Gas','0','Lot 1, Block 1','Subdivision Lot','2500','Survey','','','1','To Be Built/Under Construction','2','','0','','','Gas Range','','Composition','27 - Houston','GARDEN OAKS ELEMENTARY SCHOOL','WALTRIP HIGH SCHOOL','BLACK MIDDLE SCHOOL','Appointment Required,Supra Keybox,Vacant/Unoccupied','Builder','2','Traditional','Patio Homes at Wakefield','','','Public Water','2023','Builder');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-29T01:22:37.240' ,`MLSNumber` = '80312368' ,`ListAgentFullName` = 'Elise Byrd' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.016643' ,`Longitude` = '-95.804886' ,`PhotoCount` = '28' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Falcons Nest Landing' ,`StreetNumber` = '17230' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Very cute and charming starter home. LENNAR HOME  3/2.5/2. SMARTPOWER/ENERGYSTAR Home with energy efficient package includes 16 SEER A/C, programmable thermostat & radiant barrier. Lots of upgrades: 36\'\'kitchen cabinets, microwave, gas range; granite countertops; Family, Kitchen, Breakfast Room, Primary Bedroom with 2 Additional bedrooms, 2 Bathrooms  Ceramic tile floors in all wet areas; Rounded corners; 2 Car garage with door opener, Raised panel interior doors. Great back yard.  New roof installed in 2021.' ,`Acres` = '0.101' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 4 CYPRESSWOOD TRAILS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cypresswood Trls Sec 02' ,`TaxAmount` = '4111' ,`TaxRate` = '2.7956' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115700' WHERE `Matrix_Unique_ID` = '214892509'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-08T12:33:40.550' ,`MLSNumber` = '60313407' ,`ListAgentFullName` = 'Sammy Younis' ,`ListOfficeName` = 'RE/MAX Southwest' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.555358' ,`Longitude` = '-95.635783' ,`PhotoCount` = '35' ,`PostalCode` = '77479' ,`RoomCount` = '8' ,`ListPrice` = '658888.00' ,`Status` = 'Active' ,`StreetName` = 'Emerald Pointe' ,`StreetNumber` = '5519' ,`StreetSuffix` = 'Lane' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3901' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SIMPLY GORGEOUS! IMPECCABLY MAINTAINED AND BEAUTIFULLY UPDATED HOME IN THE HEART OF AVALON! THIS SINGLE-OWNER HOME IS WITHIN WALKING DISTANCE OF SOME OF FORT BEND ISD\'S TOP-RATED SCHOOLS! LOCATED ON A QUIET STREET, AND WITH NO BACKYARD NEIGHBORS, THIS HOME IS SURE TO IMPRESS! DRAMATIC ENTRY WITH SOARING CEILINGS, CURVED IRON STAIRCASE, AND GORGEOUS CRYSTAL CHANDELIER. ELEGANT FORMAL DINING, STUDY COULD ALSO BE A FORMAL LIVING.  THE FAMILY ROOM IS LARGE BUT STILL FEELS COZY AND OPENS UP TO A LARGE ISLAND KITCHEN WITH WHITE CABINETS AND BLACK ACCENTS THROUGHOUT. OVERSIZED MASTER BEDROOM HAS A LARGE SITTING ROOM W/ROMANTIC FIREPLACE, A SPA-LIKE MASTER BATH, & LARGE WALK-IN CLOSET. UPSTAIRS FEATURES 3 GENEROUS BEDROOMS,  GAMEROOM, STUDY NOOK, AND SECRET ROOM. OUTSIDE FEATURES A GORGEOUS COVERED PATIO WITH BEAUTIFUL WOOD CEILING WORK. BACKYARD IS LARGE ENOUGH TO ADD A POOL IF DESIRED.  MINUTES TO 59, LOW TAX RATE AND SO MUCH MORE! MAKE THIS YOUR FUTURE HOME- CALL THE AIDA YOUNIS TEAM TODAY!' ,`Acres` = '0.2016' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'AVALON - VILLAGES OF AVALON SEC 5, BLOCK 1, LOT 58' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8783' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COMMONWEALTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Avalon' ,`TaxAmount` = '10315' ,`TaxRate` = '2.1244' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115700' WHERE `Matrix_Unique_ID` = '214892731'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-19T10:12:49.990' ,`MLSNumber` = '60015595' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.854961' ,`Longitude` = '-95.290960' ,`PhotoCount` = '14' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '149900.00' ,`Status` = 'Active' ,`StreetName` = 'Cabot' ,`StreetNumber` = '7611' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CAN\'T BEAT THE PRICE on this all brick super solid 3 bedroom 2 bath home in popular Scenic Woods...The home needs finishing touches but WHAT A DEAL...Perfect for buyers that want to make it their own and want to get huge discount upfront...Large yard located on a very quiet street...HURRY this is possibly the BEST DEAL in Scenic woods!!!' ,`Acres` = '0.1708' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 3 SCENIC WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7440' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Scenic Woods' ,`TaxAmount` = '1888' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115701' WHERE `Matrix_Unique_ID` = '214893020'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-17T10:07:43.937' ,`MLSNumber` = '19756125' ,`ListAgentFullName` = 'Dayna Simmons' ,`ListOfficeName` = 'Dayna Simmons Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.234199' ,`Longitude` = '-94.202290' ,`PhotoCount` = '6' ,`PostalCode` = '77657' ,`RoomCount` = '6' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Cody Ln' ,`StreetNumber` = '230' ,`StreetSuffix` = '' ,`City` = 'Lumberton' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning IH Homes new construction home is nestled in the Woosley Palms subdivision in the Lumberton school district. Wood-look tile flooring, an open-concept floor plan, and spacious rooms will leave you excited to host your next gathering. The master bathroom is a dream, offering a vanity, double sinks for plenty of space, a free-standing tub to soak away the stress of a long day, and a walk-in shower. Spend time on the covered patio on a warm day and relax with a good book. This home is waiting for you to make it your own! Estimated completion February 2023.' ,`Acres` = '' ,`Area` = '49' ,`BuilderName` = 'IH Homes Inc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 9 BLOCK 7 WOOSLEY PALMS PHASE 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`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` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Woosley Palms' ,`TaxAmount` = '11000' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1676115701' WHERE `Matrix_Unique_ID` = '214893632'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-04T22:13:16.037' ,`MLSNumber` = '34582912' ,`ListAgentFullName` = 'Brandon Brewer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.843320' ,`Longitude` = '-95.171766' ,`PhotoCount` = '6' ,`PostalCode` = '77360' ,`RoomCount` = '0' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 356' ,`StreetNumber` = '4678' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '0' ,`BathsHalf` = '1' ,`BedsTotal` = '0' ,`SqFtTotal` = '600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great commercial property or would make a great home site with a little work. The property was previously used as a church but can be used for anything your heart desires. The +/- .55 acre property includes the 600 square foot building with wheelchair access! Located in Onalaska near the Trinity County line and minutes away from Lake Livingston. Priced to move!!' ,`Acres` = '0.5551' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GARDEN VILLAS LOT 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '24175' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Garden Villas' ,`TaxAmount` = '18' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115701' WHERE `Matrix_Unique_ID` = '214894538'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T11:14:40.340' ,`MLSNumber` = '5874384' ,`ListAgentFullName` = 'Diana Rodriguez' ,`ListOfficeName` = 'Ruth Longoria, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.676326' ,`Longitude` = '-95.301775' ,`PhotoCount` = '21' ,`PostalCode` = '77087' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Landfall' ,`StreetNumber` = '6027' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1605' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1734' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 & E3 FT OF LT 6 BLK 3 TROPICANA VILLAGE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7552' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SEGUIN ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HARTMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tropicana Village' ,`TaxAmount` = '4474' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115701' WHERE `Matrix_Unique_ID` = '214894793'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-30T10:44:59.917' ,`MLSNumber` = '60175533' ,`ListAgentFullName` = 'Lisa Clary' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795404' ,`Longitude` = '-95.042529' ,`PhotoCount` = '36' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Scarlet' ,`StreetNumber` = '6910' ,`StreetSuffix` = 'Circle' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Super hard to find 5 bedroom with a HUGE backyard ready for your family. Primary bedroom is downstairs and all other bedrooms and game room are located upstairs.  Cul-de-sac lot. Kitchen has black appliances and built-in microwave, granite countertops, and is open to dining area and living. Downstairs has all tile. Primary bedroom is spacious and has private bathroom, with dual sinks, corner tub, and separate shower. Upstairs you will find a space for everyone including 4 more bedrooms, a full bathroom, a game room, and utility room! Call today!' ,`Acres` = '0.2588' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 48 BLK 4 WEST MEADOWS SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11275' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '265' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'HOPPER/HIGHLANDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'West Mdws' ,`TaxAmount` = '6087' ,`TaxRate` = '2.755' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1676115702' WHERE `Matrix_Unique_ID` = '214895092'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-02-11T01:22:30.270' ,`MLSNumber` = '25402750' ,`ListAgentFullName` = 'Alex Berry' ,`ListOfficeName` = 'Nan & Company Properties Christie\'s International ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.810778' ,`Longitude` = '-95.408624' ,`PhotoCount` = '26' ,`PostalCode` = '77008' ,`RoomCount` = '12' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = '27th' ,`StreetNumber` = '608' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsT