Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T21:17:42.240' ,`MLSNumber` = '66362487' ,`ListAgentFullName` = 'Angelica Davis' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.708233' ,`Longitude` = '-95.083753' ,`PhotoCount` = '10' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '119000.00' ,`Status` = 'Active' ,`StreetName` = 'Harmon' ,`StreetNumber` = '317' ,`StreetSuffix` = 'Street' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1135' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTORS SPECIAL~ HOME SITS ON 4 LOTS~ CLOSE TO LAKE LIVINGSTON~ 2 BEDROOM 2 BATH HOME WITH 2 CAR ATTACHED GARAGE ~ Needs work~ ON LEFT OF HOUSE Electrical box & Septic for RV hookup ~Lots of great potential ~' ,`Acres` = '0.1722' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NUGENT\'S COVE SECTION 1 BLK 2 LOT11,12, 13,14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nugents Cove Sec 1' ,`TaxAmount` = '1870' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702605' WHERE `Matrix_Unique_ID` = '206376747' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T20:48:33.640' ,`MLSNumber` = '16167987' ,`ListAgentFullName` = 'Latisha Yates' ,`ListOfficeName` = 'Latisha Yates Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.511565' ,`Longitude` = '-95.457197' ,`PhotoCount` = '23' ,`PostalCode` = '75844' ,`RoomCount` = '5' ,`ListPrice` = '248600.00' ,`Status` = 'Active' ,`StreetName` = 'County Rd 1855' ,`StreetNumber` = '630' ,`StreetSuffix` = '' ,`City` = 'Grapeland' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1104' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy country home with pipe entrance and large shade trees on approx 6.2 +/-acres, 3 bedrooms/1 bath with spacious rooms, master has his & her closets, metal roof, 1 car garage with storage room attached, 2 car carport attached and large back deck. Home offers fenced pasture ready for horses/livestock with small stall and separate pole barn with stall and enclosed tack room. Property is 2 tracts of land approx 3.1acr (per county tax records)each both totaling approx 6.2 +/- acres per tax records. Additional homesite is available With electric and water meters in place and in service, where Barn is located a mobile home existed prior to removal, can be used For RV or mobile home. Enclosed tack room offers concrete slab, w/d hookups and toilet. Many possibilities for this property. Home feels larger than actual Sq ft. Vacant and ready for a new family!!! Seller is licensed real estate broker, seller never lived in home. Family owned since home was built. Photos taken prior to vacancy.' ,`Acres` = '6.2' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Grapeland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'B DAVIS AB 323 3.10 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '270072' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '58 - Grapeland' ,`SchoolElementary` = 'GRAPELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAPELAND HIGH SCHOOL' ,`SchoolMiddle` = 'GRAPELAND JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2064' ,`TaxRate` = '1.6377' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702605' WHERE `Matrix_Unique_ID` = '209237271' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T21:50:36.877' ,`MLSNumber` = '19521808' ,`ListAgentFullName` = 'Osneyda Canales' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.110257' ,`Longitude` = '-95.433179' ,`PhotoCount` = '24' ,`PostalCode` = '77373' ,`RoomCount` = '7' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Hyland Greens' ,`StreetNumber` = '24327' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1615' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home, in a corner lot, in the quiet comminuty of Northwood Pines. Formal living room and dining room. Wood and tile flooring. Spacious kitchen with granite counter tops. The front porch is inviting for relaxation or for family gatherings. The home sits in a large corner lot with a big back yard ready for summer bbq. Whithin walking distance to the park and splash pad to enjoy with the family.' ,`Acres` = '0.134' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 3 NORTHWOOD PINES SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '5839' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '525' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'NORTHGATE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'SPRINGWOODS VILLAGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northwood Pines Sec 01' ,`TaxAmount` = '5643' ,`TaxRate` = '3.2157' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702605' WHERE `Matrix_Unique_ID` = '210587713' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T21:07:28.617' ,`MLSNumber` = '35961197' ,`ListAgentFullName` = 'Alexis Chaudron' ,`ListOfficeName` = 'Styled Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.282296' ,`Longitude` = '-96.570592' ,`PhotoCount` = '7' ,`PostalCode` = '77835' ,`RoomCount` = '5' ,`ListPrice` = '150950.00' ,`Status` = 'Active' ,`StreetName` = 'Dorothy' ,`StreetNumber` = '4476' ,`StreetSuffix` = 'Lane' ,`City` = 'Burton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1670' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a great investment property, rather you plan to call this place home or a weekend getaway! This unique home sits on a generously sized lot only minutes from Lake Somerville and Rocky Creek Park, and zoned Burton ISD. Rocky Creek Estates has no HOA making the opportunities endless. Come check out this slice of Heaven today.' ,`Acres` = '0.1318' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ROCKY CREEK ESTATES SEC I , LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5740' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '128 - Burton' ,`SchoolElementary` = 'BURTON ELEMENTARY SCHOOL (BURTON)' ,`SchoolHigh` = 'BURTON HIGH SCHOOL' ,`SchoolMiddle` = 'BURTON HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style,Split Level' ,`Subdivision` = 'Rocky Creek Estates Sec I' ,`TaxAmount` = '2009' ,`TaxRate` = '1.5327' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663702605' WHERE `Matrix_Unique_ID` = '210747937' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T21:44:17.683' ,`MLSNumber` = '84746471' ,`ListAgentFullName` = 'Erete Ebong' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.575645' ,`Longitude` = '-95.686447' ,`PhotoCount` = '7' ,`PostalCode` = '77479' ,`RoomCount` = '6' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Sparrow Branch' ,`StreetNumber` = '2402' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2724' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS FOUR BEDROOM, TWO AND HALF BATHROOM HAS IT ALL. HUGE BEDROOMS, AND BACK YARD.' ,`Acres` = '0.1759' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'RIVERPARK SEC 6, BLOCK 1, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7664' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUTCHISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Riverpark Sec 6' ,`TaxAmount` = '6785' ,`TaxRate` = '2.6977' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702605' WHERE `Matrix_Unique_ID` = '210974780' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T20:09:01.950' ,`MLSNumber` = '81938929' ,`ListAgentFullName` = 'Gilbert McNeil' ,`ListOfficeName` = 'McNeil Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.642451' ,`Longitude` = '-95.339376' ,`PhotoCount` = '20' ,`PostalCode` = '77048' ,`RoomCount` = '5' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'South Acres Drive' ,`StreetNumber` = '5423' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large master bed room 14 x 27 large kitchen family room combo. 22 x29 .\r\nHard wired generator comes on when lights go off.\r\n\r\nLarge covered Patio car port combination. Large walk in closet. A Jacuzzi bath tub.' ,`Acres` = '' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 & W 10 FT OF LT 25 BLK 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CODWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'CRESTMONT PARK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702606' WHERE `Matrix_Unique_ID` = '211074655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T20:39:56.173' ,`MLSNumber` = '58024007' ,`ListAgentFullName` = 'Ronnie Olson' ,`ListOfficeName` = 'Impact Realty Group L.L.C.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.477199' ,`Longitude` = '-95.037378' ,`PhotoCount` = '27' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Abbie' ,`StreetNumber` = '5001' ,`StreetSuffix` = 'Lane' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1130' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 2 Bedroom 2 Bath in Green Caye! Recently updated with a new roof and exterior/interior paint. This home sits on a corner lot and is within walking distance of Dickinson High School. Great backyard with a view of the water!' ,`Acres` = '0.1171' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GREEN CAYE VILLAGE SUB PHASE III (2006) ABST 78, BLOCK 1, LO' ,`LotDesciption` = 'Corner' ,`LotSize` = '5101' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'DUNBAR MIDDLE SCHOOL (DICKINSON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Green Caye Village Sub Ph I' ,`TaxAmount` = '3653' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663702606' WHERE `Matrix_Unique_ID` = '211429047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T21:38:26.380' ,`MLSNumber` = '14967732' ,`ListAgentFullName` = 'Shirley Whalen' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765634' ,`Longitude` = '-95.340971' ,`PhotoCount` = '27' ,`PostalCode` = '77020' ,`RoomCount` = '7' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'Eado Park' ,`StreetNumber` = '349' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2218' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stylish freestanding home w/over 2000+ sq. ft of living space. 3 bedrooms, 3.5 baths with private rooftop terrace with stunning views of Houston’s downtown skyline. The 1st floor bedroom has an appointed en-suite full bathroom, and can flex as an office. Seamless open concept on the 2nd floor which adjoins the living, dining, and sleek, gourmet kitchen. Also features high ceiling, modern accents, designer touches, beautiful hardwoods, and outdoor balcony. Upstairs on the 3rd floor includes a spacious guest bedroom with a full bath, walk-in closet and laundry area with washer/dryer combo included. The primary suite is also located on the 3rd floor featuring high ceilings with spacious walk-in closet. En-suite bathroom includes dual sink vanity, freestanding shower, soaking tub & fine finishes. Minutes from downtown, guest parking available, and restaurants. Luxurious and turn-key!' ,`Acres` = '0.0334' ,`Area` = '2' ,`BuilderName` = 'Cityside Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 1 NOBILITY PARK R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '1453' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1195' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRUCE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Nobility Park Sub' ,`TaxAmount` = '9377' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702606' WHERE `Matrix_Unique_ID` = '211780316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T20:01:58.550' ,`MLSNumber` = '73443971' ,`ListAgentFullName` = 'Abigail Steinhagen' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.904260' ,`Longitude` = '-95.734118' ,`PhotoCount` = '8' ,`PostalCode` = '77433' ,`RoomCount` = '3' ,`ListPrice` = '325990.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Lake Dr' ,`StreetNumber` = '7618' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Built by Tricoast Homes, this Malaga floor plan is a gorgeous home located in the Marvida community. This home welcomes you with trend-conscious flooring that leads you to an updated kitchen complete with granite countertops and stainless steel appliances. Relax in the master bathroom , featuring luxurious designs with modern finishes. Unwind outside on the texas-sized patio. Within each Tricoast home you will find high vaulted ceilings in the living room. Living here you can enjoy a community recreation center with community lakes and water features, a 3,000 square foot clubhouse, pool, playground, dog park, and tennis and sand volleyball courts. Contact us today for more information!**FRONT AND BACKYARD IRRIGATION!!**' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Tricoast Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6, Block 1, Section 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663702606' WHERE `Matrix_Unique_ID` = '211787790' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-24T21:55:32.160' ,`MLSNumber` = '38676516' ,`ListAgentFullName` = 'Fafu Zeng' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.662441' ,`Longitude` = '-95.081629' ,`PhotoCount` = '29' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Catlett' ,`StreetNumber` = '9911' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1457' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom, 2 baths and 2 garage all brick home located in a sought after Fairmont Park neighborhood! Huge family room with high vaulted ceiling. Granite counter-top kitchen. Luxury vinyl plank flooring throughout except 2 bedrooms with carpet. Formal dining room or study room at front. New double panel windows throughout. Newer roof and updated electric panel. New AC! Updated kitchen and bathrooms. Huge fully fenced backyard for any activities. This home won\'t last!' ,`Acres` = '0.1661' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 FAIRMONT PARK WEST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7236' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'JENNIE REID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fairmotn Park West Sec 01' ,`TaxAmount` = '4877' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663702606' WHERE `Matrix_Unique_ID` = '211794955' --> Updated record success