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-11-02T05:40:54.490' ,`MLSNumber` = '62086627' ,`ListAgentFullName` = 'Maria Alas' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.623824' ,`Longitude` = '-95.432412' ,`PhotoCount` = '24' ,`PostalCode` = '77045' ,`RoomCount` = '10' ,`ListPrice` = '252000.00' ,`Status` = 'Active' ,`StreetName` = 'Darlinghurst' ,`StreetNumber` = '3711' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This house features 3 full bedrooms and an office/study room, and 2 updated full bathrooms. Tile flooring through all areas of the house. No carpet! Living and dining area are connected to the kitchen, which is great for entertaining guests. French doors that lead to the back patio. Beautiful fully fenced back yard and a newly built deck with a roof, an ideal place to spend your evenings and weekends with the family and friends.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 50 FT OF LT 14 & W 7 FT OF LT 15 BLK 6 MEREDITH MANOR' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meredith Manor' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1667412057' WHERE `Matrix_Unique_ID` = '210462803'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T04:47:01.610' ,`MLSNumber` = '96285335' ,`ListAgentFullName` = 'Susan Kinder' ,`ListOfficeName` = 'MV Realty Of Texas LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.737059' ,`Longitude` = '-94.901581' ,`PhotoCount` = '18' ,`PostalCode` = '77351' ,`RoomCount` = '8' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Old Israel' ,`StreetNumber` = '4375' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brick home on a large lot! Walk inside to find wood floors and tile throughout. Enjoy a beautiful fireplace surrounded by built-ins. The kitchen has newish stainless steel appliances, access to the utility room, and an open dining area. Plenty of space is found in the newly fenced backyard. Store all of your lawn equipment in the large shed. There is room to grow in this country home.' ,`Acres` = '0.64' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROLLINGWOODS LOT 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '27878' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Colonial,Ranch,Traditional' ,`Subdivision` = 'Rollingwoods' ,`TaxAmount` = '3360' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412058' WHERE `Matrix_Unique_ID` = '211971410'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T05:47:12.873' ,`MLSNumber` = '93096953' ,`ListAgentFullName` = 'Travis Pryor' ,`ListOfficeName` = 'All Day Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703224' ,`Longitude` = '-95.656192' ,`PhotoCount` = '29' ,`PostalCode` = '77083' ,`RoomCount` = '9' ,`ListPrice` = '284300.00' ,`Status` = 'Active' ,`StreetName` = 'La Paloma' ,`StreetNumber` = '15227' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2304' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Motivated Seller.  Enjoy this Newly Renovated and Upgraded Lovely Four Bedroom + Two Bathroom Home. Full of Upgrades & Newly constructed open floor plan. New Doors, Windows, New Ductless Heat Pump, Appliances etc provides a lovely modern touch. The Beautiful Kitchen Is The Heart Of The Home Complete With Large Customized Granite Island & Stainless Steel Appliances. Updated Lighting Throughout The Entire Home with New Security Cameras. Great Neighborhood with Walking Distances to Elementary & Middle Schools. Indulge in Suburban living with the comforts of a 25 Min Drive to Downtown.' ,`Acres` = '0.1928' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 15 MISSION BEND SEC 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'PETROSKY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mission Bend Sec 10' ,`TaxAmount` = '4675' ,`TaxRate` = '2.437' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412058' WHERE `Matrix_Unique_ID` = '212995980'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T05:10:36.173' ,`MLSNumber` = '10219154' ,`ListAgentFullName` = 'Madison Floyd' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = 'Callee Maglothin' ,`SellingOfficeName` = 'Keller Williams Realty - Memorial' ,`Latitude` = '29.835176' ,`Longitude` = '-95.456094' ,`PhotoCount` = '30' ,`PostalCode` = '77092' ,`RoomCount` = '6' ,`ListPrice` = '374900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Viking' ,`StreetNumber` = '4304' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1388' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated one story in Oak Forest is move in ready! This house is full of charm starting with it\'s curb appeal with newly painted exterior and new front door. With an oversized backyard on a corner lot and open concept home, this home is ready for entertaining! The granite counters and light cabinetry will delight any home chef. bathrooms beautifully updated with neutral selections to match any pallet. Wood floors throughout, energy efficient windows, 2016 roof & HVAC, 2021 gutters per seller. NEVER FLOODED! Enjoy the parks and trails of the neighborhood as well as convenient access to Downtown, The Heights, and Galleria' ,`Acres` = '0.267' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Oak Forest West Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 8 OAK FOREST SEC 15' ,`LotDesciption` = 'Corner' ,`LotSize` = '11629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'SCARBOROUGH HIGH SCHOOL' ,`SchoolMiddle` = 'CLIFTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Oak Forest Sec 15' ,`TaxAmount` = '6868' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412058' WHERE `Matrix_Unique_ID` = '213075591'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T05:24:34.040' ,`MLSNumber` = '86149937' ,`ListAgentFullName` = 'Mario Guzman' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.215331' ,`Longitude` = '-95.135733' ,`PhotoCount` = '36' ,`PostalCode` = '77372' ,`RoomCount` = '9' ,`ListPrice` = '474750.00' ,`Status` = 'Active' ,`StreetName` = 'Midlane' ,`StreetNumber` = '27664' ,`StreetSuffix` = 'Street' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4162' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CUSTOM 5 BEDROOM HOME IN SPLENDORA SITS ON ALMOST AN ACRE, NEVER LIVED IN, OPEN FLOOR PLAN, STUNNING KITCHEN WITH A DRY BAR, LIVING AREA HAS A MOCK FIREPLACE, ALL BEDROOMS ARE SPACIOUS, PRIMARY BEDROOM LEADS TO AN 8X22 BALCONY, BACKYARD HAS A 25X40 COVERED PATIO, MANUFACTURED HOME STAYS WITH PROPERTY' ,`Acres` = '0.9343' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S453500 - EASTWOOD 01, LOT 104, ACRES 0.93' ,`LotDesciption` = 'Wooded' ,`LotSize` = '40699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eastwood 01' ,`TaxAmount` = '10416' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412058' WHERE `Matrix_Unique_ID` = '213610978'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T05:18:19.753' ,`MLSNumber` = '64710998' ,`ListAgentFullName` = 'Eduardo Medina' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Caliber Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662461' ,`Longitude` = '-95.103074' ,`PhotoCount` = '33' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Gladwyne' ,`StreetNumber` = '3110' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1781' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Only a few miles away from the beach and right off of Beltway 8 loop and Spencer Highway! This beautiful 2 story home is a must see. Recently completed covered patio to relax on in your back yard (did I mention this property sits on a lot that\'s just under a quarter of an acre?!?!). Make an appointment with your favorite neighborhood REALTOR and see this future home of yours!' ,`Acres` = '0.2328' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BROOKGLEN SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10140' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'COLLEGE PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Brookglen Sec 01' ,`TaxAmount` = '5409' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412058' WHERE `Matrix_Unique_ID` = '213824502'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T05:37:01.373' ,`MLSNumber` = '18488569' ,`ListAgentFullName` = 'Joshua Pedroso' ,`ListOfficeName` = 'Generation Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.701675' ,`Longitude` = '-95.746262' ,`PhotoCount` = '36' ,`PostalCode` = '77407' ,`RoomCount` = '8' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Tallow Knoll' ,`StreetNumber` = '7006' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2411' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this HIDDEN GEM located in Lakemont. HUGE CUL-DE-SAC LOT!! BRAND NEW ROOF (2022) Tile throughout the WHOLE house, beautiful chandeliers in entry and dining, marble countertops with tile backsplash in the kitchen, top-of-the-line stainless Kitchen Aid appliances (with a double oven!), digital thermostat, Gameroom has been utilized as a 4th bedroom, large covered patio with a screened area for storage, sprinkler system and more! HOME HAS NEVER FLOODED!!' ,`Acres` = '0.2674' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LAKEMONT SEC 2, BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '11649' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MCNEILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakemont' ,`TaxAmount` = '6917' ,`TaxRate` = '2.8215' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412059' WHERE `Matrix_Unique_ID` = '213980986'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T05:30:18.477' ,`MLSNumber` = '38902737' ,`ListAgentFullName` = 'Olga Lozano' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.110355' ,`Longitude` = '-95.382794' ,`PhotoCount` = '17' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '319000.00' ,`Status` = 'Active' ,`StreetName` = 'Lockeridge Springs' ,`StreetNumber` = '28538' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located in the quaint subdivision of Lockeridge Farms, this beautiful and well-maintained home offers three bedrooms, two bathrooms, formal dining or living room, family room, and a flex space that is currently being used as a playroom. Open concept layout allows for plenty of natural light throughout the home.   Spacious kitchen allows for easy entertaining, has stainless steel appliances, granite countertops, and a large island for all of your family gatherings.  Primary suite is complete with ensuite bathroom and large walk-in closet.  Home offers two nicely sized secondary bedrooms and plenty of storage. Enjoy your morning coffee on your covered back patio admiring your various fruit trees or go for a morning walk right outside your back fence. Some recent updates include interior/exterior paint and the addition of a new roof.  Lockeridge Farms is a family friendly neighborhood, offers great schools, community playground and pool. Book your showing today!' ,`Acres` = '0.1343' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S692400 - LOCKERIDGE FARMS 01, BLOCK 8, LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5850' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lockeridge Farms 01' ,`TaxAmount` = '6448' ,`TaxRate` = '2.8187' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412059' WHERE `Matrix_Unique_ID` = '214074058'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T04:36:18.603' ,`MLSNumber` = '73870022' ,`ListAgentFullName` = 'David Cole' ,`ListOfficeName` = 'First Class, Realtors®' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742319' ,`Longitude` = '-95.632933' ,`PhotoCount` = '50' ,`PostalCode` = '77077' ,`RoomCount` = '17' ,`ListPrice` = '3000000.00' ,`Status` = 'Active' ,`StreetName` = 'Chatham Creek' ,`StreetNumber` = '2407' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '8404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Truly Custom Mediterranean Home located on one of the best waterfronts in the neighborhood. The property has 180-degree view of the lake, and you can just sit and feel the tranquility on this location. The property features Beautiful double medal doors, a double stairs entry with a gorgeous chandelier. Arch niches throughout the property. Mirrored dance studio/exercise room. 4 car garage with built-ins. Plenty of living and entertaining areas. The primary bedroom and primary bath are must-see along with the custom walk-n closets. The Gourmet kitchen has a Sub-Zero Refrigerator, 5 burner gas range, and Wolf double ovens. All of the marble floors have been imported and the attention to detail is obvious once you drive up the extra-wide driveway. The home is located in a 24-Hour Guard Gated Community. This home shows a pride of ownership, and you feel the positive energy once you enter it. The views of the lake from every room downstairs are priceless. Motivated seller says bring offers.' ,`Acres` = '0.2697' ,`Area` = '31' ,`BuilderName` = 'Kickerillo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 LAKES OF PARKWAY SEC 16 AMEND 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '11749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BUSH ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Split Level,Traditional' ,`Subdivision` = 'Lakes of Parkway' ,`TaxAmount` = '44944' ,`TaxRate` = '2.3907' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412059' WHERE `Matrix_Unique_ID` = '214195709'  --> 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','214249443','1667412059','214249443','2022-11-02T05:19:09.440','28455182','Amy Townsend','Sky Real Estate Professionals','','','28.956312','-95.289259','49','77541','8','449900.00','Active','206 Pompano Lane','206','Lane','Surfside Beach','3','0','3','1008','Single-Family','Fisherman’s paradise! It is located on the largest & deepest canal and equipped with 2 boat slips right at your back door. Excellent opportunity, just minutes from the Surfside Jetties and out into the Gulf, and yet walking distance to the beach. This spectacular home offers spacious private decks with panoramic water views in all directions, while enjoying the Gulf breeze. Walk-in through a sunroom to an open concept living area facing the canal, large kitchen with a 2 bedrooms, 2 baths and an additional bedroom/extra-room with full bathroom on ground level. Downstairs features; Enclosed Grandfathered in 3 car garage for work area, golf carts and beach/fishing gear. Along with spacious deck for relaxing and leisure, this home includes underwater lights for fishing or simply viewing pleasure. THIS WON\'T LAST LONG!','0.1138','5','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','0','','','Surfside','Central Electric','0','SURFSIDE SHORES (A0051 F J CALVIT DIV 2 (B C I C))(SURFSIDE)','Subdivision Lot,Waterfront','4957','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Range','','Other','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Leave Business Card,Supra Keybox','Appraisal District','1','Other Style','Surfside Shores Inc','5755','2.333','Public Sewer,Public Water','1977','Appraisal District');  --> New record created successfully<br />