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-03T20:40:35.610' ,`MLSNumber` = '32376146' ,`ListAgentFullName` = 'Farrah Hashaw' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.238603' ,`Longitude` = '-94.621087' ,`PhotoCount` = '39' ,`PostalCode` = '77519' ,`RoomCount` = '4' ,`ListPrice` = '359000.00' ,`Status` = 'Active' ,`StreetName` = 'Gusher' ,`StreetNumber` = '19358' ,`StreetSuffix` = 'Road' ,`City` = 'Batson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated beneath these two gorgeous oaks, you\'ll find a completely updated, move-in ready home on 2.44+/-  acres with a fenced in pasture. Spray foam insulation, granite throughout, new stainless appliances, etc.  Behind the home, there is an approx. 14\' x28\' wood sided building that has electricity. So many possibilities with this property. Bring your AG project or horses and enjoy the country!  No deed restrictions! \n Owner/Agent' ,`Acres` = '2.442' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 16 W DONAHOE P# 16-357-B-2 I# 2019-97364 08/14/2019' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '106374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '182 - West Hardin County Consolidated' ,`SchoolElementary` = 'WEST HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST HARDIN HIGH SCHOOL' ,`SchoolMiddle` = 'WEST HARDIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'AB 16 W DONAHOE' ,`TaxAmount` = '2299' ,`TaxRate` = '1.7971' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706452' WHERE `Matrix_Unique_ID` = '208356454'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:33:56.803' ,`MLSNumber` = '65510474' ,`ListAgentFullName` = 'Danny Moss' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.651326' ,`Longitude` = '-95.836373' ,`PhotoCount` = '50' ,`PostalCode` = '77406' ,`RoomCount` = '16' ,`ListPrice` = '1025000.00' ,`Status` = 'Active' ,`StreetName` = 'Silent Cedar' ,`StreetNumber` = '8411' ,`StreetSuffix` = 'Circle' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4839' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Positioned on over an acre in quiet cul-de-sac of beautiful  gated community, this timeless transitional custom home  Immaculately maintained, High-end designer finishes throughout exuding quiet elegance. Soaring ceilings  that draw you in upon entrance. Designed & perfected floor plan while maintaining the formality of separate spaces - still delivering the open kitchen living areas we have all come to love. Kitchen designed to be heart of the home equipped w/ all the appliances and space needed to host + large pantry. SS top notch Bosch appliances, custom cabinets, double oven, island gas cooktop, travertine floor, overlooks the den with double sided fireplace. \r\nDesigner touches, crown molding, hardwood floors, elegant custom woodwork throughout. Oversized, walk-in closets with built in cabinets in every room in the home. Primary Bedroom and 2nd Bed/Mother-in-law suite on 1st floor. Spectacular Office  2 stair cases w/ custom ornamental iron railings, wood shutters and wood blinds.' ,`Acres` = '1.0143' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas,Other Heating,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'WHISPERING OAKS, BLOCK 3, LOT 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '44182' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Whispering Oaks' ,`TaxAmount` = '10081' ,`TaxRate` = '1.7948' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663706452' WHERE `Matrix_Unique_ID` = '208911195'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:16:45.640' ,`MLSNumber` = '69530366' ,`ListAgentFullName` = 'Aneline Herrero' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.628982' ,`Longitude` = '-95.427115' ,`PhotoCount` = '13' ,`PostalCode` = '77045' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Boynton Drive' ,`StreetNumber` = '3354' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GREAT START FOR FIRST-TIME HOME BUYERS. ALL BRICK. BUILT-IN 2004.  EASY ACCESS TO BELTWAY 8. JUST A FEW MILES FROM THE MEDICAL CENTER.' ,`Acres` = '' ,`Area` = '18' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 7 Blk 2 Willow Glen Sec 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HOBBY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willow Glen' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706452' WHERE `Matrix_Unique_ID` = '210262200'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:01:14.830' ,`MLSNumber` = '44846170' ,`ListAgentFullName` = 'Michelle Speetzen' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.067993' ,`Longitude` = '-95.487237' ,`PhotoCount` = '17' ,`PostalCode` = '77388' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Piney Creek' ,`StreetNumber` = '4502' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Show Stopper !  Absolutely Beautiful 3 Bedroom, 2 Bath home on a nice Cul-de-sac Lot !  This home has been meticulously maintained.  Upgrades/Updates include:  Exterior Paint 2022, Kitchen Remodel 2017 with all new appliances, HVAC System 2019, Roof 2017, Double Paned Low E Windows throughout 2017. Water Heater 2017.  Nice Storage Shed in backyard.  This home will not last long !!!' ,`Acres` = '0.1663' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 10 017*B6830749-001-010-018 BRIDGESTONE SEC 1 R/P' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7245' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'ROTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgestone Sec 01 R/P' ,`TaxAmount` = '4312' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706452' WHERE `Matrix_Unique_ID` = '210987888'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:12:26.370' ,`MLSNumber` = '52425247' ,`ListAgentFullName` = 'Linh Dang' ,`ListOfficeName` = 'The Nguyens & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598544' ,`Longitude` = '-95.237699' ,`PhotoCount` = '29' ,`PostalCode` = '77089' ,`RoomCount` = '11' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagevale' ,`StreetNumber` = '10323' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for this spacious single family home. Home consists of 4 beds and 3 full baths. Garage was converted into a working room. New Roof in 2022! Good School District. Schedule the appointment today and make it yours!' ,`Acres` = '0.1641' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 6 KIRKMONT SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkmont' ,`TaxAmount` = '3989' ,`TaxRate` = '2.6655' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706452' WHERE `Matrix_Unique_ID` = '211520644'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:29:03.433' ,`MLSNumber` = '65981662' ,`ListAgentFullName` = 'Azalea Marquez' ,`ListOfficeName` = 'Texas Premier Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930347' ,`Longitude` = '-95.493069' ,`PhotoCount` = '26' ,`PostalCode` = '77086' ,`RoomCount` = '7' ,`ListPrice` = '205000.00' ,`Status` = 'Active' ,`StreetName` = 'Heather Hill' ,`StreetNumber` = '10507' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal house for investment or family.  3 bedroom 2 bath with double living areas and formal dining.  Kitchen has breakfast area. Gas is available!  Tiled thru-out.  Roof and all exterior siding, trim and overhand replaced with cement fiber-board in 2020!  Brick 4 sides.  Nice large lot. Must see!' ,`Acres` = '0.1791' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 NORTHWEST PARK SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '398' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CARMICHAEL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'SHOTWELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Northwest Park Sec 01' ,`TaxAmount` = '2811' ,`TaxRate` = '2.4283' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706452' WHERE `Matrix_Unique_ID` = '211641705'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:47:04.737' ,`MLSNumber` = '46625795' ,`ListAgentFullName` = 'Alan Sanchez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342133' ,`Longitude` = '-96.605631' ,`PhotoCount` = '6' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Bee St' ,`StreetNumber` = '203' ,`StreetSuffix` = '' ,`City` = 'Somerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Say hello to your new weekend home! 203 Bee ST is located MINUTES from Lake Somerville. Perfect for fishing and spending a splendid weekend get-away. A beautiful, single-family house with 3 bedroom and 2 full bathrooms, main driveway located in front of the house, and the second just to the left of the house (located on Parallel St). The property is equipped with services for an RV attached to the property. 203 Bee St. is the first house on the left with a red front door on a corner lot.' ,`Acres` = '0.1377' ,`Area` = '59' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2502 SOMERVILLE PLACE LOT 798 0.1377 ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '6000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerville Place' ,`TaxAmount` = '64' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663706453' WHERE `Matrix_Unique_ID` = '211661319'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-03T21:08:12.797' ,`MLSNumber` = '46696607' ,`ListAgentFullName` = 'Kristi Fox-Satsky' ,`ListOfficeName` = 'Century 21 Beal' ,`SellingAgentFullName` = 'Gennifer Murphy' ,`SellingOfficeName` = 'Miles of Grace Realty' ,`Latitude` = '30.699254' ,`Longitude` = '-96.266961' ,`PhotoCount` = '32' ,`PostalCode` = '77808' ,`RoomCount` = '12' ,`ListPrice` = '699900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Juliette' ,`StreetNumber` = '6434' ,`StreetSuffix` = 'Trail' ,`City` = 'Bryan' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You\'ve been looking for a stunning country home with acreage that\'s not too far from town, well here it is! Located in the beautiful Green Branch Ridge subdivision, 10 minutes to Hwy 6, this builders personal custom split floor plan sits on 1.53 acres & was built by 413 Custom Builders in 2019. It features 4 bedrooms plus a bonus room, 3.5 bathrooms, 2,832 sq. ft., an extra long double car driveway, oversized garage & covered back patio with built-in grill. The open concept living & kitchen will wow you with its tall ceilings, custom finishes & floor to ceiling fireplace! The spacious primary bedroom grants access to the primary bathroom which wraps around into your oversized walk-in closet & back into the laundry room! Upstairs you will find the 5th bedroom or bonus room & 3rd bathroom including a large closet. You will love the 20x20 shop out back with roll up door. Find peace in the outdoors while fishing in the stock pond & enjoy ample yard space. Your country living oasis awaits!' ,`Acres` = '1.53' ,`Area` = '61' ,`BuilderName` = '413 Custom Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GREEN BRANCH RIDGE PH 5, LOT 6' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '66647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'BRYAN HIGH SCHOOL' ,`SchoolMiddle` = 'STEPHEN F. AUSTIN MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Branch Ridge Ph 5' ,`TaxAmount` = '7629' ,`TaxRate` = '1.7488' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706453' WHERE `Matrix_Unique_ID` = '211789366'  --> 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','212147933','1663706453','212147933','2022-09-03T20:49:23.120','4224223','Sara Jimenez','RE/MAX Signature','','','30.745570','-95.521415','38','77320','8','349900.00','Active','Highway 30','2026','','Huntsville','2','0','4','1954','Single-Family','RESIDENTIAL or COMMERCIAL!! Located right off of HWY 30, this spacious home sits on 1.5 acres just inside Huntsville City limits. It has been updated with new electrical wiring, all new plumbing/gas lines, new roof, and many more upgrades. Room dimensions are approximate, please independently verify.','1.51','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Huntsville Area','Central Gas','0','BOBO F (A-74), TRACT 13.1, ACRES 1.51','Cleared','65776','Appraisal District','','','0','','3','Electric Oven','0','','','Electric Range','','Composition','64 - Huntsville','SCOTT JOHNSON ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Supra Keybox','Appraisal District','1','Ranch','N/A','2759','1.9609','Public Sewer,Public Water','1940','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','212158461','1663706453','212158461','2022-09-03T20:01:51.500','4509218','Michael Callihan','Riverway Properties','','','29.786115','-95.440195','19','77055','4','799999.00','Active','Dorset cliff','3505','Lane','Houston','3','1','4','2709','Single-Family','FIRST FLOOR LIVING!  Built by Riverway Homes.  Home will be ready in June 2022 This residence offers 2709 sf of living space on 3 floors. Perfect for families with teenagers, live-in help or multi-generational family homes (En Suite 3rd floor Game Room/Optional living area). Patio sized lot offers green space and quaint covered courtyard-like area.','0.0495','9','Riverway Properties','','','','No Disclosures','1','','','Timbergrove/Lazybrook','Central Gas','1','NA','Subdivision Lot','2585','Appraisal District','','2500','1','To Be Built/Under Construction','2','','0','','','','','Composition','27 - Houston','SINCLAIR ELEMENTARY SCHOOL (HOUSTON)','WALTRIP HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Accompany','Builder','3','Other Style','Somerset Green','','2.6161','Other Water/Sewer','2022','Builder');  --> New record created successfully<br />