Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T13:17:54.747' ,`MLSNumber` = '16285325' ,`ListAgentFullName` = 'Dalene Zender' ,`ListOfficeName` = 'Zen Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.698912' ,`Longitude` = '-95.546174' ,`PhotoCount` = '32' ,`PostalCode` = '77340' ,`RoomCount` = '5' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore' ,`StreetNumber` = '2403' ,`StreetSuffix` = 'Avenue' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nicely updated two bedroom, two bathroom home located near Sam Houston State University.  Recent renovations include new flooring and fresh paint throughout.  Open concept living, kitchen and dining area. Split bedroom arrangement.  Wood-burning fireplace. Master bathroom has separate shower and tub and double sinks.  Fenced yard and storage building.' ,`Acres` = '0.2545' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'DAVIDS E SURVEY, 17.01 LT 17, MH LABEL# HWC027742' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'ESTELLA STEWART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675098900' WHERE `Matrix_Unique_ID` = '205414730'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T13:12:41.350' ,`MLSNumber` = '37963558' ,`ListAgentFullName` = 'Ronald Espinoza' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755617' ,`Longitude` = '-95.459158' ,`PhotoCount` = '12' ,`PostalCode` = '77056' ,`RoomCount` = '0' ,`ListPrice` = '10000000.00' ,`Status` = 'Active' ,`StreetName` = 'Wynden' ,`StreetNumber` = '32' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '0' ,`SqFtTotal` = '5696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every story has a beginning. What’s your legacy? Situated in one of the most prestigious neighborhoods in Houston. This 41000+sqft unrestricted corner lot in West Oaks affords one a lasting legacy just minutes away from The Galleria, Uptown Park, Memorial Park, Houston C.C. and River Oaks C.C.' ,`Acres` = '0.9369' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 32 WEST OAKS NO 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '40812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Oaks No 2' ,`TaxAmount` = '51325' ,`TaxRate` = '2.5304' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098900' WHERE `Matrix_Unique_ID` = '206190950'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T13:43:07.840' ,`MLSNumber` = '46666276' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'Highland Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.213174' ,`Longitude` = '-95.346500' ,`PhotoCount` = '27' ,`PostalCode` = '77302' ,`RoomCount` = '8' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lady Guava' ,`StreetNumber` = '17124' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 46666276 - Built by Highland Homes - Ready Now! ~ Popular Newport Plan with brick and stone exterior. This home has a study, and 4 bedrooms, 2 are expanded.  Great island kitchen with lots of cabinets with quartz countertops. Extended outdoor living, primary bedroom bay window, and powder bath option. Nice lot with plenty of space for future pool or play area, and no rear neighbors.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 26, Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8192' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artavia' ,`TaxAmount` = '' ,`TaxRate` = '3.09' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098900' WHERE `Matrix_Unique_ID` = '209642397'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T14:54:01.167' ,`MLSNumber` = '84669233' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.401370' ,`Longitude` = '-95.058316' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '379564.00' ,`Status` = 'Active' ,`StreetName` = 'Dancing Reed' ,`StreetNumber` = '13138' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2275' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIRTUAL TOUR! Welcome home to the beautiful 2 story, Berkeley Floor Plan with 4 bedrooms, 3 baths, with an attached 2 car garage. This floor plan boasts a SPACIOUS OPEN CONCEPT FLOOR PLAN with 9ft ceilings.  The large island kitchen has 2 side by side double door pantries.  This home also offers you 2 bedrooms downstairs and bedrooms upstairs with a loft. You will love entertaining guest on the covered patio.  COST & ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Low E Windows that open to the inside of the home for cleaning.  Home of the largest Crystal Clear Lagoon of Texas at 12-acres along with fitness center, business center, and catering kitchen. Convenient to Galveston Beach.  Dickinson ISD!' ,`Acres` = '0.1135' ,`Area` = '33' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 13 BLK 3 LAGO MAR POD 4 SEC 1 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4944' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1598' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098900' WHERE `Matrix_Unique_ID` = '211478119'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T13:09:41.380' ,`MLSNumber` = '26767526' ,`ListAgentFullName` = 'Alan Sanchez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342133' ,`Longitude` = '-96.605631' ,`PhotoCount` = '30' ,`PostalCode` = '77879' ,`RoomCount` = '6' ,`ListPrice` = '280000.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 home! This single-family house with 3 bedroom and 2 full bathrooms is located minutes away from Big Creek Marina that leads to Lake Somerville. New appliances include an electric range, dishwasher, fridge, washer and driver. The property is equipped with RV services attached to the house. The house is on a corner lot in the intersection of Parallel ST and Bee ST. The 203 BEE ST is on Somerville Place subdivision which offers a nice pavilion and a community pool for an additional fee.' ,`Acres` = '0.1148' ,`Area` = '59' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2502 SOMERVILLE PLACE LOT 797, 0.1178 ACRES' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '10998' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`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` = '54' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675098901' WHERE `Matrix_Unique_ID` = '211506501'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T14:45:51.113' ,`MLSNumber` = '60265706' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403044' ,`Longitude` = '-95.058134' ,`PhotoCount` = '7' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '353632.00' ,`Status` = 'Active' ,`StreetName` = 'Lake Mist' ,`StreetNumber` = '2225' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE 3D VIRTUAL TOUR! Welcome home to your beautiful 2 Story Addington Floor Plan with 4 Bedrooms, 2 1/2 Baths, with a 2 Car Garage. This floor plan boasts a spacious OPEN CONCEPT FLOOR PLAN with Family Room, Kitchen, Primary Bedroom Suite downstairs.  Upstairs you will find a Tech Center, 3 Bedrooms, and another Full Bath.  The bedrooms all have huge walk-in closets. You will love the Kitchen with lots of cabinets, stainless steel appliances, and even a USB outlet. Tile and carpet throughout. COVERED PATIO and Fenced Backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem Gas Tankless Water Heater, and Low E Windows that open to the inside of the home for cleaning. Home of the largest Crystal Clear Lagoon of Texas at 12-acres along with fitness center, business center, and catering kitchen. Convenient to shopping, entertainment, and Galveston beach. Call today for your private tour!' ,`Acres` = '0.1195' ,`Area` = '33' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 28 BLK 1 LAGO MAR POD 4 SEC 1 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5205' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1603' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098901' WHERE `Matrix_Unique_ID` = '211509339'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T14:56:02.717' ,`MLSNumber` = '98063795' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405552' ,`Longitude` = '-95.057603' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '9' ,`ListPrice` = '375675.00' ,`Status` = 'Active' ,`StreetName` = 'Anchor Isle' ,`StreetNumber` = '13210' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIRTUAL TOUR! Beautiful brick 4 Bedroom, 2 Bath, with a 2 Car Garage. This floor plan boast a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with the Family Room, Kitchen, Breakfast Room, Study/Flex Room, and 4 Bedrooms with 2 full Baths. You will love the Kitchen with lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Comes with PATIO and fenced backyard. Recessed lighting throughout the home. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Home of the largest Crystal Clear Lagoon of Texas at 12-acres along with fitness center, business center, and catering kitchen. Convenient to shopping, entertainment and Galveston beach.  Dickinson ISD!' ,`Acres` = '0.1579' ,`Area` = '33' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 33 BLK 1 LAGO MAR POD 4 SEC 3 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6879' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1764' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098901' WHERE `Matrix_Unique_ID` = '211522266'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T14:50:56.547' ,`MLSNumber` = '43631825' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403664' ,`Longitude` = '-95.059492' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '8' ,`ListPrice` = '365504.00' ,`Status` = 'Active' ,`StreetName` = 'Sea Breeze' ,`StreetNumber` = '13306' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1989' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SEE SAMPLE 3D VIRTUAL TOUR! Beautiful 1 Story, The Brighton Floor Plan with 4 Bedrooms, 3 Baths, with an attached 2 Car Garage. This floor plan boasts High Ceilings and a Spacious OPEN CONCEPT FLOOR PLAN with the Family Room, Kitchen, Breakfast Room, and 3 spacious bedrooms with 2 of them sharing an ensuite Bathroom. You will love the Master Suite with its oversized closet. The Kitchen has lots of cabinets and granite countertops with under the cabinet lighting, stainless steel appliances, and even a USB outlet. Covered Patio & Fenced backyard! COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Home of the largest Crystal Clear Lagoon of Texas at 12-acres along with fitness center, business center, and catering kitchen. Convenient to shopping, entertainment and Galveston beach.  Dickinson ISD!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 30 BLK 2 LAGO MAR POD 4 SEC 3 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1764' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098901' WHERE `Matrix_Unique_ID` = '211527853'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T14:49:32.107' ,`MLSNumber` = '248984' ,`ListAgentFullName` = 'Matthew Guzman' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.403895' ,`Longitude` = '-95.059180' ,`PhotoCount` = '6' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '332594.00' ,`Status` = 'Active' ,`StreetName` = 'Suntail' ,`StreetNumber` = '13301' ,`StreetSuffix` = 'Court' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1603' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brick Canterbury floorplan, 1 Story, 3 Bedroom, 2 Bath, with a 2 Car Garage. This floor plan boast a SPACIOUS OPEN CONCEPT FLOOR PLAN and HIGH CEILINGS with the Family Room, Kitchen, Breakfast Room, and 3 Bedrooms with 2 full Baths. You will love the Kitchen with lots of cabinets and granite countertops with  Stainless Steel appliances, and even a USB outlet. Recessed lighting throughout the home. Comes with COVERED Patio and fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, Pex Manabloc Plumbing System, Radiant Barrier, Rheem® Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for cleaning. Home of the largest Crystal Clear Lagoon of Texas at 12-acres along with fitness center, business center, and catering kitchen. Convenient to shopping, entertainment and Galveston beach.  Dickinson ISD!' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 21 BLK 2 LAGO MAR POD 4 SEC 3 (2020) ABST 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1230' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '1764' ,`TaxRate` = '3.79' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098902' WHERE `Matrix_Unique_ID` = '211612164'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T13:01:53.797' ,`MLSNumber` = '25165557' ,`ListAgentFullName` = 'Kathleen Milam' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.757377' ,`Longitude` = '-95.891062' ,`PhotoCount` = '29' ,`PostalCode` = '77423' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Blazing Star' ,`StreetNumber` = '2418' ,`StreetSuffix` = 'Drive' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2507' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why pay more for new construction when you can have this better than new beautiful 2-year-old home built by Lennar Homes, in Jordan Ranch.  PRICE CHANGE! Inviting 2-story home with an open floorplan.  The large island kitchen (chef\'s dream) has granite countertops/breakfast bar and is open to the dining room and family room. The large backyard has a newly installed covered patio, great for barbecuing and entertaining!  Vinyl plank flooring throughout most of the first floor.  The large master suite has an excellent bathroom with double sinks and a great closet! Upstairs game room for movies and fun! The game room also h