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-06T07:54:07.980' ,`MLSNumber` = '95390177' ,`ListAgentFullName` = 'Keith Kyser' ,`ListOfficeName` = 'AVOREC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751383' ,`Longitude` = '-95.390976' ,`PhotoCount` = '21' ,`PostalCode` = '77006' ,`RoomCount` = '3' ,`ListPrice` = '678000.00' ,`Status` = 'Active' ,`StreetName` = 'Bomar' ,`StreetNumber` = '911' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1742' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In the heart of Montrose within walking distance to numerous bars, restaurants, and a coffee shop just a block away, is this custom renovated home with abundant light and unique touches throughout.  Wow your guests with the upstairs loft area or the beautiful kitchen with built in appliances that accentuate the reconditioned Chambers stove.  \r\n\r\nYour own yard and garage allow you to entertain in the backyard or let the dogs stretch their legs.  If you want something a little larger, Buffalo Bayou is just down the street with all it\'s outdoor amenities and large dog park.  Midtown just 5 minutes away allowing you to have the peace and quiet of a neighborhood but still being close to the main entertainment areas of Houston.\r\n\r\nThe house sits on a corner lot giving you a large front yard and two runs on each side of the house.' ,`Acres` = '0.0895' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 7 CAVE E W' ,`LotDesciption` = 'Corner' ,`LotSize` = '3900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Cave E W' ,`TaxAmount` = '13496' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707366' WHERE `Matrix_Unique_ID` = '205129975'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:47:52.040' ,`MLSNumber` = '20930459' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.881805' ,`Longitude` = '-95.795506' ,`PhotoCount` = '42' ,`PostalCode` = '77493' ,`RoomCount` = '10' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Finch' ,`StreetNumber` = '7410' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3551' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 20930459 - Built by Highland Homes - October completion! ~ With its amazing and impactful elevation and a curved staircase, this home provides both high end style and undeniable elegance.  There are two bedrooms downstairs and two bedrooms upstairs.  You can enjoy the entertainment room downstairs or the game room upstairs.  Relax on the covered patio.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 5 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8904' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson 65s' ,`TaxAmount` = '' ,`TaxRate` = '3.49' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707366' WHERE `Matrix_Unique_ID` = '206831941'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:46:59.233' ,`MLSNumber` = '35954371' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834556' ,`Longitude` = '-95.857972' ,`PhotoCount` = '15' ,`PostalCode` = '77493' ,`RoomCount` = '7' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Malibu Shore' ,`StreetNumber` = '904' ,`StreetSuffix` = '' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 35954371 - Built by Highland Homes - September completion! ~ Built by Highland Homes - Walking distance to the famous 3.5 acre Crystal Lagoon in a community that\'s just 15 minutes from both I-10 and 99! The Bristol floor plan features 11ft. ceilings, 8ft doors, and a spacious open layout. The island kitchen has a large single basin sink, quartz counters, Painted classic island, pendant lights, 5pc stainless steel appliances, and painted cabinets offering plenty of storage space! Wood look high end vinyl floors included in all main areas. Primary suite sits in the back of the home with a large bay window, FREESTANDING TUB and shower, dual sinks and a spacious walk-in closet! SMART HOME PACKAGE, tankless water heater, full sprinkler system are all included!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '70/1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707366' WHERE `Matrix_Unique_ID` = '207641126'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:45:43.217' ,`MLSNumber` = '23849353' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834360' ,`Longitude` = '-95.857152' ,`PhotoCount` = '50' ,`PostalCode` = '77493' ,`RoomCount` = '3' ,`ListPrice` = '360000.00' ,`Status` = 'Active' ,`StreetName` = 'Crystal Bend' ,`StreetNumber` = '904' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1582' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 23849353 - Built by Highland Homes - September completion! ~ Built by Highland Homes - Walking distance to the famous 3.5 acre Crystal Lagoon in a community that\'s just 15 minutes from both I-10 and 99! The spacious floorplan offers tile floors, soaring ceilings and huge family room. The light & bright kitchen is open to the family room and boasts stainless steel appliances, large island, pantry and so much more! The open floorplan is a true entertainer\'s delight. The primary bedroom is a dream retreat while the primary bath offers dual sinks, separate shower & tub along with a large closet. SMART HOME PACKAGE, tankless water heater, full sprinkler system are all included!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '35/1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '208842484'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:52:48.843' ,`MLSNumber` = '38687461' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.134874' ,`Longitude` = '-95.319537' ,`PhotoCount` = '37' ,`PostalCode` = '77365' ,`RoomCount` = '7' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21594' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 38687461 - Built by Highland Homes - October completion! ~ Our Windermere is a versatile 2-story home that features an open floorplan with vaulted ceilings in the entry, dining and family room.  A secondary bedroom & bath is located on the first floor.  The enhanced outdoor living is the perfect spot to relax with family and friends.  Details such as walk-in closets in all bedrooms, 8\' doors on the first floor, tankless water heater & full sprinkler system are just some of the desirable features that sets this Highland Home apart from other builders. This home is located on an oversized lot.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 6  Block: 1' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '209270308'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:46:02.263' ,`MLSNumber` = '14104205' ,`ListAgentFullName` = 'Cyndi Kornegay' ,`ListOfficeName` = 'Gatehouse Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683634' ,`Longitude` = '-95.834772' ,`PhotoCount` = '6' ,`PostalCode` = '77406' ,`RoomCount` = '7' ,`ListPrice` = '412830.00' ,`Status` = 'Active' ,`StreetName` = 'Lacaille' ,`StreetNumber` = '10707' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2019' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous home is located on a spacious oversize home site that is everything you have been dreaming of and more. As you enter through the grand 8-foot front door, you will be welcomed into the grand foyer with 10\' ceilings. A study is located midway, complemented with beautiful double glass doors. Advancing into the home, you will be led into the heart of the house, complete with an abundance of space to entertain family and friends. The chef of the family will adore the gourmet kitchen equipped with a spacious granite island overlooking the family room and dining area. After a long day, retreat to the primary suite featuring stunning bow windows, a soaker tub, a separate shower, and dual vanities. Take entertaining outdoors on the covered patio to host BBQs or relax at the end of the day. This lovely home boasts something for everyone. Come and visit today!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 4 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6726' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '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` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Candela' ,`TaxAmount` = '' ,`TaxRate` = '3.14' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '210226779'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:58:29.277' ,`MLSNumber` = '87271371' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.135143' ,`Longitude` = '-95.319098' ,`PhotoCount` = '22' ,`PostalCode` = '77365' ,`RoomCount` = '9' ,`ListPrice` = '449589.00' ,`Status` = 'Active' ,`StreetName` = 'Jordan Pond' ,`StreetNumber` = '21582' ,`StreetSuffix` = 'Ridge' ,`City` = 'Porter' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1939' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 87271371 - Built by Highland Homes - December completion! ~ Cozy feelings with this stunning one-story plan with 11ft. ceilings and abundant windows giving this home lots of natural light.  The primary suite includes a bay window, large walk-in closet and drop-in tub.  The extended outdoor living makes this home great for relaxing after a long day or entertaining on weekends' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S582903 - The Highlands 03, BLOCK 1, Lot 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1420' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'ROBERT CRIPPEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WHITE OAK MIDDLE SCHOOL (NEW CANEY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'The Highlands' ,`TaxAmount` = '' ,`TaxRate` = '3.38' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '210328392'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:23:57.213' ,`MLSNumber` = '12044765' ,`ListAgentFullName` = 'Renee Fussell' ,`ListOfficeName` = 'Signature Services Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403228' ,`Longitude` = '-94.711942' ,`PhotoCount` = '42' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Marble' ,`StreetNumber` = '3833' ,`StreetSuffix` = 'Street' ,`City` = 'Port Bolivar' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION! LOCATION! LOCATION! Amazing Views in All Directions in the Prestigious Gated Community of The Biscayne on The Bolivar Peninsula. Tranquil, Private Wildlife Sanctuary Welcomes You To The Community!  Gorgeous, Light & Bright, Fully Furnished Builders Former Model Backs to Wildlife Preserve Features Wrap Around Deck with Porch Swing, Expansive Family Room, Gourmet, Eat In, Island Kitchen with Custom Cabinets, Cabinet Lighting, Stainless Steel Appliances and Granite Counters! Wood Floors! Private, Top Level Master Retreat with Double Sinks, Large Travertine Shower and Covered Deck. Large Secondary Bedrooms! Laundry Room; Ceiling Fans, Recessed Lighting! Outdoor Shower! Over Sized Garage with Automatic Opener! Just a Short Walk or Golf Cart Ride to The Beach!  The Biscayne is Minutes from Fine and Causal Dining, Shopping, Water Parks and More!  If you are Beach Combing, This Fabulous Home is Located Near Beach Marker 11.  Come Discover Beach Life on The Bolivar Peninsula.' ,`Acres` = '0.1777' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Port Bolivar' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot  135, Block 01, ABST 203, Section 03 (2006),' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '7740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Biscayne' ,`TaxAmount` = '5807' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '210395615'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:30:04.810' ,`MLSNumber` = '87312415' ,`ListAgentFullName` = 'Loren Miner' ,`ListOfficeName` = 'Eastwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.799415' ,`Longitude` = '-95.429321' ,`PhotoCount` = '32' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Tannehill Drive' ,`StreetNumber` = '1615' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2180' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Living in Lazybrook makes you feel at home: a house where families can grow and memories can be created; this house boasts a dynamic floor plan which is perfect for keeping family close while giving pause and solitude when needed. Natural light pours into every room, playing off the engineered wood floors and beautiful private views of greenery. Highlighted by clean lines, ample storage, and a sunken living room, you can\'t help but feel relaxed. A private office and closet space accompany the grand suite and a massive ensuite bathroom with enough storage to fulfill every amazon purchase in your cart. With a two-car garage & room for three cars in the driveway, a fully fenced lush backyard, you can consider every box checked. So move in today and make it your own tomorrow.' ,`Acres` = '0.1768' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 31 BLK 4 LAZYBROOK SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side,Request Online Appointment' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Lazybrook Sec 02' ,`TaxAmount` = '8812' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '211238324'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-06T07:33:03.800' ,`MLSNumber` = '49461684' ,`ListAgentFullName` = 'Noelle Ward' ,`ListOfficeName` = 'Realty One Group Prosper' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.475941' ,`Longitude` = '-94.583871' ,`PhotoCount` = '30' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Castle' ,`StreetNumber` = '3240' ,`StreetSuffix` = 'Drive' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO THE BEACH! \r\nStep inside this beautiful 4th row, 4/2.5 home that sits within walking distance to the beach! This home has plenty of room for entertaining both inside and out, including a second living area upstairs that can be conformed to a game room for added fun! Come home from a day at the beach and rinse off in the outdoor shower located next to the outdoor kitchen area, or climb the spiral staircase located on the top deck to your very own look out point. The views are wonderful this home will not disappoint! PERFECT VACATION RENTAL!!!!' ,`Acres` = '0.409' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 14 BLK 3 SAND CASTLE BEACH SEC 2' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '17816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sand Castle Beach 2' ,`TaxAmount` = '6297' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707367' WHERE `Matrix_Unique_ID` = '211522228'  --> 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','211811125','1663707368','211811125','2022-09-06T06:48:46.603','13488027','Garrett Mohnke','Complete Property Services','','','30.041548','-95.363887','14','77373','3','220000.00','Active','Reynaldo','4415','Drive','Spring','2','0','3','1291','Single-Family','3 bedroom 2 bath home in established Fairfax.  Wood look flooring in the living area, tile in the kitchen, dinning and bath with carpeted bedrooms.','0.154','12','','','','','Sellers Disclosure','','','1','Spring East','Central Gas','1','LT 4 BLK 8 FAIRFAX SEC 1','Subdivision Lot','6710','Appraisal District','','370','0','','2','Electric Oven','0','','','','','Composition','48 - Spring','MILDRED JENKINS ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','DUEITT MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Fairfax','3832','2.9367','Public Water','1974','Appraisal District');  --> New record created successfully<br />