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-08-31T00:20:39.430' ,`MLSNumber` = '56451551' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787950' ,`Longitude` = '-94.667290' ,`PhotoCount` = '17' ,`PostalCode` = '77514' ,`RoomCount` = '4' ,`ListPrice` = '303990.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeway' ,`StreetNumber` = '343' ,`StreetSuffix` = 'Circle' ,`City` = 'Anahuac' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Lakeway is a beautiful one-story 4 bedrooms, Study, 3 baths and 2 car garage home. Spacious Island Kitchen with Silestone counter Topps, 42” cabinets and Stainless-Steel Appliances overlooking family room, dining area. The Master Suite features large walk-in closet, separate shower, garden tub, and double vanity sinks. Gorgeous wood-like flooring throughout the home with carpet only in the bedrooms. Covered back patio with no back neighbors! Lakeway is only minutes away from major stores and main highways.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'N/A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '4 - Anahuac' ,`SchoolElementary` = 'ANAHUAC ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANAHUAC HIGH SCHOOL' ,`SchoolMiddle` = 'ANAHUAC MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeway' ,`TaxAmount` = '' ,`TaxRate` = '2.6' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705002' WHERE `Matrix_Unique_ID` = '205152196'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T01:22:00.593' ,`MLSNumber` = '11825298' ,`ListAgentFullName` = 'Mark Dimas' ,`ListOfficeName` = 'Mark Dimas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736081' ,`Longitude` = '-95.389485' ,`PhotoCount` = '36' ,`PostalCode` = '77006' ,`RoomCount` = '9' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '815' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1520' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 3 bed, 2 bath single-story craftsman offers 21st century construction in the heart of the First Montrose Commons historic neighborhood! The open floorplan maximizes space and includes a cozy living room, dining area, and an updated kitchen with granite countertops, marble backsplash, stainless steel appliances, and a walk-in pantry. The spacious primary bedroom boasts a huge closet, direct access to the back deck, and a full en-suite bathroom with updated frameless shower. Ten-foot ceilings, large energy efficient windows, a neutral palette, and hardwood floors make the house bright and airy. With a newly constructed Spark Park, and redone infrastructure, including streets and side-walks, First Montrose Commons offers benefits of a modern neighborhood with the charm of a historic one. World class dining, entertainment, museums, universities, and the Texas Medical Center are all within minutes of this home nestled in the cultural hub of Montrose.' ,`Acres` = '0.0735' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'E 32 FT OF LTS 9 & 10 BLK 17 LOCKHART CONNOR & BARZIZA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MACGREGOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lockhart Connor & Barziza' ,`TaxAmount` = '9931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705002' WHERE `Matrix_Unique_ID` = '208964061'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T01:22:00.593' ,`MLSNumber` = '89119441' ,`ListAgentFullName` = 'James Terenzi' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.803127' ,`Longitude` = '-95.377391' ,`PhotoCount` = '38' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '595000.00' ,`Status` = 'Active' ,`StreetName` = 'Tabor' ,`StreetNumber` = '1303' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and meticulously cared for home is a must see!  Located mins from downtown in the Greater Height’s desirable Brooke Smith neighborhood! 6000sq foot lot makes it bigger than most in the neighborhood. You will be impressed by this remarkable Craftsman home with a long driveway leads to a 2 car garage and a nice backyard. The 12 ft ceilings in the living room and primary bedroom makes these rooms feel very grand. The woodwork throughout is stunning. PEX plumbing thoughout the home. Bring your pickiest of buyers to see this charming bungalow, it won\'t disappoint.' ,`Acres` = '0.1377' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 114 & TRS 1A & 2A BLK 6 LIZZIETON TERRACE BROOKE SM' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`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` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '12506' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705002' WHERE `Matrix_Unique_ID` = '209479795'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T00:04:23.530' ,`MLSNumber` = '45054986' ,`ListAgentFullName` = 'Haresh Jethani' ,`ListOfficeName` = 'Cornerstone Prop Mngt, Inc,' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718398' ,`Longitude` = '-95.441042' ,`PhotoCount` = '28' ,`PostalCode` = '77005' ,`RoomCount` = '12' ,`ListPrice` = '2099000.00' ,`Status` = 'Active' ,`StreetName` = 'Coleridge' ,`StreetNumber` = '3938' ,`StreetSuffix` = 'Street' ,`City` = 'West University Place' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new construction on a 6000 Sqft lot (*per HCAD*).. 3938 Coleridge is a unique combination of charm and  modern elegance with a open floor plan featuring 4 bedrooms & 4 FULL+1 half bathrooms, high ceilings, large windows and wide plank Oak hardwood floors. The Chef\'s Kitchen with Miele Appliances, custom cabinetry, beautiful stone countertops, large island, walk-in Pantry & a large mudroom. Large Office/study. The Master bed on 2nd floor will feature a custom fitted closet & a luxurious bathroom! Game-room, additional secondary bedrooms with en-suite baths on the 2nd floor!  Perfectly located in West Universiy Place, short walk to Colonial Park, West U Recreational Center, Shops and Restaurants.' ,`Acres` = '0.1377' ,`Area` = '17' ,`BuilderName` = 'SAI' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Reports Available' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 9 COLLEGEVIEW SEC 3' ,`LotDesciption` = 'Corner' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Collegeview Sec 03' ,`TaxAmount` = '13694' ,`TaxRate` = '2.0584' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705003' WHERE `Matrix_Unique_ID` = '210390991'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T00:03:19.230' ,`MLSNumber` = '15549719' ,`ListAgentFullName` = 'Delfina Delariva' ,`ListOfficeName` = 'The Real Estate People, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690553' ,`Longitude` = '-95.511071' ,`PhotoCount` = '33' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '279500.00' ,`Status` = 'Active' ,`StreetName` = 'Troulon' ,`StreetNumber` = '7123' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1424' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom 3 bath is centrally located in the very desirable Sharpstown subdivision.  It is with in walking distance from Houston Baptist university and Herman Memorial Southwest. This home was completely remodeled in 2015.  It features ceramic tile throughout, granite countertops in the huge kitchen.  All current appliances stay with the home.  Electrical, plumbing, windows, and AC System were all replaced during the remodel.  \r\nThis amazing home will not last, schedule your showing appointment today!' ,`Acres` = '0.1707' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 3 SHARPSTOWN SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7434' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MCNAMARA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR GROVE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharptstown Sec 03' ,`TaxAmount` = '4070' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705003' WHERE `Matrix_Unique_ID` = '210903272'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-31T01:08:28.950' ,`MLSNumber` = '75782907' ,`ListAgentFullName` = 'Nereyda Diaz' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.362464' ,`Longitude` = '-95.620503' ,`PhotoCount` = '7' ,`PostalCode` = '77316' ,`RoomCount` = '4' ,`ListPrice` = '120000.00' ,`Status` = 'Active' ,`StreetName` = 'Ivanhoe' ,`StreetNumber` = '16743' ,`StreetSuffix` = '' ,`City` = 'Montgomery' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come Check Out This Beautiful Clayton 2018 Manufactured Home A 2 Bed 1 Bath. Energy Efficient Home, Home Is Well Maintained. Easy Accces To 105, Only Few Miles From Lake Conroe And Restaurants. HURRY!! And Call Me For A Private Showing. Measurements Are Approx. Please verify on your own' ,`Acres` = '0.0482' ,`Area` = '39' ,`BuilderName` = 'CLAYTON HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE CONROE VILLAGE, BLOCK 20, LOT 2' ,`LotDesciption` = 'Other' ,`LotSize` = '2100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Conroe Village' ,`TaxAmount` = '146' ,`TaxRate` = '1.825' ,`WaterSewer` = 'Other Water/Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705003' WHERE `Matrix_Unique_ID` = '211898233'  --> Updated record success<br />