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-21T12:11:14.670' ,`MLSNumber` = '47950239' ,`ListAgentFullName` = 'Edita Herrera' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.627823' ,`Longitude` = '-95.490410' ,`PhotoCount` = '11' ,`PostalCode` = '77085' ,`RoomCount` = '5' ,`ListPrice` = '264900.00' ,`Status` = 'Active' ,`StreetName` = 'Oakmantle' ,`StreetNumber` = '7007' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3/2/2 home in Southwest Crossing Subdivision. Spacious home with High ceilings, and fire place in living area. Large backyard with shed. Schedule your showing today!!! All Measurements are approximate, please measure for accuracy.' ,`Acres` = '0.1326' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 2 SOUTHWEST CROSSING SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'FONDREN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISON HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwest Crossing Sec 03' ,`TaxAmount` = '3639' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701345' WHERE `Matrix_Unique_ID` = '207924642' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T12:15:51.640' ,`MLSNumber` = '6420110' ,`ListAgentFullName` = 'Frank Neal' ,`ListOfficeName` = 'Southbelt Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714334' ,`Longitude` = '-95.366550' ,`PhotoCount` = '6' ,`PostalCode` = '77004' ,`RoomCount` = '3' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Prospect' ,`StreetNumber` = '3229' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '3' ,`SqFtTotal` = '1856' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TENANT OCCUPIED - DO NOT DISTURB. RECENT Remodel. \r\nNew pipes, AC, remodeled kitchen and baths, central air/heat completed 2016. No sellers disclosure, owner has not occupied the proprerty.' ,`Acres` = '0.1339' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures,Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Riverside' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 2 SOUTHWOOD OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5832' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwood Oaks' ,`TaxAmount` = '10088' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701346' WHERE `Matrix_Unique_ID` = '208712190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T13:32:58.680' ,`MLSNumber` = '15310225' ,`ListAgentFullName` = 'Natasha Carroll' ,`ListOfficeName` = 'Natasha Carroll Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.979480' ,`Longitude` = '-95.179444' ,`PhotoCount` = '49' ,`PostalCode` = '77346' ,`RoomCount` = '6' ,`ListPrice` = '325000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Pass Falls' ,`StreetNumber` = '17922' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tenant-occupied through June 2023. Welcome Home!!!!!! This property provides a great investment opportunity for a buyer looking to move in or a buyer looking for a fantastic rental property in a highly desirable location. This beautiful 4 bedroom home has a spacious floor plan with a formal dining room as you enter the home. Located in the award-winning Master community of Eagle Springs. The home features an excellent open floor plan with a split bedroom layout, high ceilings, dining room, and a sizable primary bedroom with in-suite bathroom and walk-in closet. Kitchen is open to the spacious family room with wall to wall windows which bring in natural light and a gas fireplace. Head out to the large extended covered patio with a vaulted ceiling, 2 ceiling fans and sprinkler system to enjoy a wonderful Texas evening. You will enjoy lakes & parks, clubhouses, fitness center, tennis courts, volleyball, pools and a splash pad. Make an Appointment today' ,`Acres` = '0.1552' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 2 EAGLE SPRINGS SEC 14 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6762' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'EAGLE SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '7205' ,`TaxRate` = '2.9726' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701346' WHERE `Matrix_Unique_ID` = '210473027' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T13:15:39.503' ,`MLSNumber` = '10809755' ,`ListAgentFullName` = 'Toni Hite' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.788097' ,`Longitude` = '-95.104967' ,`PhotoCount` = '27' ,`PostalCode` = '77530' ,`RoomCount` = '8' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayou' ,`StreetNumber` = '315' ,`StreetSuffix` = 'Drive' ,`City` = 'Channelview' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BAYOU/WATER FRONT. NEVER FLOODED!! Cozy 3 bedroom 1 bath home on approximately 1.3 acres with NO RESTRICTIONS and NO HOA fees! The home features a living room with wood burning or gas fireplace. True farmhouse is written all over this! The kitchen is huge with eat in dining or breakfast area. There are 2 good sized bedrooms PLUS a smaller bedroom with a closet that could be used for a study. Outside the kitchen area there is a huge covered porch with a beautiful view. This is a great property for FFA projects. One block from Interstate 10, just a few minutes to Baytown and downtown Houston.' ,`Acres` = '1.32' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 BLK 2 OLD RIVER TERRACE SEC 1' ,`LotDesciption` = 'Cleared,Water View,Waterfront' ,`LotSize` = '57499' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '8 - Channelview' ,`SchoolElementary` = 'CRENSHAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHANNELVIEW HIGH SCHOOL' ,`SchoolMiddle` = 'AGUIRRE JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Old River Terrace Sec 01' ,`TaxAmount` = '3763' ,`TaxRate` = '2.423' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701346' WHERE `Matrix_Unique_ID` = '210715184' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T13:06:14.003' ,`MLSNumber` = '6900621' ,`ListAgentFullName` = 'Michelle Doss' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.196192' ,`Longitude` = '-95.412883' ,`PhotoCount` = '34' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Bonnet' ,`StreetNumber` = '1544' ,`StreetSuffix` = 'Lane' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2227' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4 bedroom, 2 bath home is located in the heart of Heritage Park. The ranch style home has a modern farmhouse kitchen that is open to the living and dining rooms with updated features. Host all your family gatherings in the huge backyard that comes with a nicely covered patio. \r\nThere would also be no need to worry about parking space because this home has an extra long driveway and two car attached garage! \r\nCome check it out yourself and feel right at HOME!' ,`Acres` = '0.2641' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HERITAGE PARK SEC 2 (A0318 T S LEE) (ANGLETON) BLK 1 LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'RANCHO ISABELLA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Heritage Park Sec 2 A0318 T S' ,`TaxAmount` = '7808' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701346' WHERE `Matrix_Unique_ID` = '211414750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-21T12:44:51.093' ,`MLSNumber` = '62230021' ,`ListAgentFullName` = 'Omar Sanchez' ,`ListOfficeName` = 'SIS Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.649949' ,`Longitude` = '-95.519805' ,`PhotoCount` = '35' ,`PostalCode` = '77071' ,`RoomCount` = '7' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Circle' ,`StreetNumber` = '8002' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4220' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 8002 N Circle! This luxurious Custom Built home has all the modern finishes and space you have been looking for.Beyond its perfectly manicured lot is your Grand Entryway with dramatic ceilings & open concept layout. Formal dinning and\r\nliving featuring crisp white custom cabinetry and built-ins throughout. Your dream kitchen boasts a gorgeous oversized granite\r\nwaterfall edge island, endless countertop space, commercial grade appliances, custom cabinets. The kitchen opens up\r\nsundreinched family\r\nroom with a beautiful stone fireplace\r\nand great room with french doors that lead to your outside living\r\nspace. Your tranquil first floor Primary Suite w/ Spa-like Ensuite bathroom with separate shower & soaking tub also sleek double\r\nvanity. Huge gameroom with connecting balcony, 3 spacious secondary bedrooms & 2 full bathrooms upstairs. Oversized\r\ndriveway leads you into your\r\n2 car garage. No Flooding! No MUD! Easy living at its best. Call to book your private showing today!' ,`Acres` = '0.2078' ,`Area` = '20' ,`BuilderName` = 'JS CONSTRUCTION' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 29 BLK 1 LAKES OF FONDREN SW' ,`LotDesciption` = 'Cleared,Corner,Cul-De-Sac' ,`LotSize` = '9050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Left Side,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lakes Fondren Sw' ,`TaxAmount` = '1159' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701346' WHERE `Matrix_Unique_ID` = '211627712' --> Updated record success