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-26T07:39:42.027' ,`MLSNumber` = '30293527' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Gopi Khande' ,`SellingOfficeName` = '99 Mansions Realty' ,`Latitude` = '29.734194' ,`Longitude` = '-95.865507' ,`PhotoCount` = '50' ,`PostalCode` = '77494' ,`RoomCount` = '10' ,`ListPrice` = '553330.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Ethan Park' ,`StreetNumber` = '3818' ,`StreetSuffix` = 'Court' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3282' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Final Opportunities to purchase in Section 60 zoned to KATY ISD ZONED! D.R. Horton\'s Chloe Floorplan with upgraded 5th Bedroom! ATTACHMENTS SHOW COLOR PACKAGE. \"Smart Home\" all controllable through your Hub or smartphone. Kitchen with Silestone counters, 5 burner range and 42\" Cabinets! A secondary bedroom wing for the kiddos with a study nook. Large covered patio with plumed gas! Included is everything you are looking for in a community- resort pool, splashpad, fitness center, sports fields, lakes & walking trails ready for you! Call today for your own private tour! Please verify with sales agent options and any upgrades. **PHOTOS ARE WHAT YOU CAN EXPECT FROM THE FLOORPLAN! THEY DO NOT SHOW ACTUAL PROPERTY*At this time the builder does not sell to Investors in this neighborhood*' ,`Acres` = '' ,`Area` = '36' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 113; Block 2; Section 60' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CAMPBELL ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'JORDAN HIGH SCHOOL' ,`SchoolMiddle` = 'ADAMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.17' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703165' WHERE `Matrix_Unique_ID` = '208657296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T07:47:21.323' ,`MLSNumber` = '30860020' ,`ListAgentFullName` = 'Ashley Guidry' ,`ListOfficeName` = 'Terra Point Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.144578' ,`Longitude` = '-95.051664' ,`PhotoCount` = '46' ,`PostalCode` = '77554' ,`RoomCount` = '4' ,`ListPrice` = '1020000.00' ,`Status` = 'Active' ,`StreetName` = 'Deaf P Smith' ,`StreetNumber` = '21922' ,`StreetSuffix` = 'Drive' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PARADISE AWAITS YOU!!! Meticulously maintained, fully furnished (w/ few exclusions), original owner home is \'rental ready\' but has not been previously rented w/ amazing bay views in the highly sought after Sea Isle community. This canal front home offers 60’ of water frontage protected by its own vinyl bulkhead (2020) w/ massive outdoor living spaces that extend on both ground patio & main level porch of home w/ an inviting hot tub, bonus bathroom, outdoor enclosed shower & an abundance of entertaining space. This 4 bedroom, 2.5 bath West Bay house boasts impressive upgrades such pine wood flooring & crown molding throughout. Stunning attn to designer details & perfectly decorated offering you a truly-turnkey ready- piece of Texas paradise! 2 RV plugs, 50 & 30 amp. Located in the favorable “AE” flood zone. Sea Isle\'s numerous amenities include public beach, private fishing pier, boat ramp, park, pool, tennis court, Sand Bar restaurant & Marina! Bay & beach living at its finest!' ,`Acres` = '0.1398' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Abst 121 Page 15 Lot 1718 Sea Isle 12th Extension' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '6090' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sea Isle Ext 12' ,`TaxAmount` = '10975' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663703165' WHERE `Matrix_Unique_ID` = '208957782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T07:32:22.633' ,`MLSNumber` = '7988441' ,`ListAgentFullName` = 'Suzanne Heinrich' ,`ListOfficeName` = 'Main Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.775474' ,`Longitude` = '-94.931419' ,`PhotoCount` = '48' ,`PostalCode` = '77521' ,`RoomCount` = '9' ,`ListPrice` = '378000.00' ,`Status` = 'Active' ,`StreetName` = 'Parkwood' ,`StreetNumber` = '2927' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2809' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come take a look at this spacious, beautifully updated home that is move-in ready. The open floor plan is perfect for entertaining. Gorgeous granite countertops in the kitchen, with lots of cabinets for storage. The amazing primary suite is large and full of natural light. The en-suite primary bathroom has been beautifully updated. \r\nThe split floor plan upstairs is a nice set up for or to provide a special place for guests. Upstairs includes a gameroom/office space that could also become a 5th bedroom. The backyard has a lovely patio and plenty of room for new owners to put in a pool. All of this and the convenience of being close to the schools, HWY 146, Interstate 10, and the Grand Parkway! This quiet neighborhood is close to walking and bike trails and a city park. This property is a MUST see!' ,`Acres` = '0.2258' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 PARKWOOD PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9834' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Parkwood Place Sec 01' ,`TaxAmount` = '7441' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703166' WHERE `Matrix_Unique_ID` = '210315654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T06:40:49.013' ,`MLSNumber` = '56561977' ,`ListAgentFullName` = 'Melissa Morales' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.255446' ,`Longitude` = '-94.848415' ,`PhotoCount` = '34' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Rice' ,`StreetNumber` = '3701' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1440' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great beach home just 1 block from the beach that also has a separate apartment! Home is in a peaceful neighborhood with lots of trees. Extras include walk-in shower, large yard with fence, gas heating and range, central cooling, shed, attached 2 car garage. Plenty of storage space underneath the home that is fully covered with bug prevention. No HOA! Grassed in yard. Home would make a great vacation rental! Also has a separate apartment with a full kitchen, bedroom, and bathroom. This would be great for extra income! Home has been completely rebuilt and lifted 14 feet! Don\'t miss your opportunity to live just minutes from shopping, dining, and Pleasure Pier!' ,`Acres` = '0.1576' ,`Area` = '33' ,`BuilderName` = 'Weir Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 121 PAGE 80 LOT 5 BLK 33 JUNEMAN SUB #2' ,`LotDesciption` = 'Other' ,`LotSize` = '6867' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Juneman 2 L 199-214-215' ,`TaxAmount` = '1862' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703166' WHERE `Matrix_Unique_ID` = '210426230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T07:27:50.890' ,`MLSNumber` = '47213919' ,`ListAgentFullName` = 'John Badger' ,`ListOfficeName` = 'Realty Executives' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.087162' ,`Longitude` = '-95.187815' ,`PhotoCount` = '44' ,`PostalCode` = '77365' ,`RoomCount` = '10' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Allendale Park' ,`StreetNumber` = '3302' ,`StreetSuffix` = 'Court' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3321' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful and Immaculate! Primary Suite down. Another bedroom and bath right off the entry. Study with double doors and stylish beams. Spacious formal dining. Stunning kitchen with granite counters beautiful ivory 42 in. cabinets. 5-burner Gas cooktop across from large and stylish island. A delightful gathering hub. Water Softener! Kitchen and Breakfast area flows into the well-lit Family Room with fireplace. The Primary\'s en suite is just what you want: two vanities, garden tub and tiled separate shower. Large walk-in closet that connects with the Laundry and also the main hall. Up, you\'ll spot the spacious Game Room with room for enjoying multiple pursuits. Next to the Game Room is a third Bedroom. Near the top of the stairs you have that fourth bedroom, this one with that third dual-vanity full bath. And too many of the latest Energy, Internet and Sound wiring and features to list!' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 1 Block 2 Royal Brook at Kingwood Sec. 07' ,`LotDesciption` = 'Corner,Subdivision Lot,Wooded' ,`LotSize` = '7168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ELM GROVE ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Brook at Kingwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703166' WHERE `Matrix_Unique_ID` = '210611323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T07:50:45.910' ,`MLSNumber` = '68793803' ,`ListAgentFullName` = 'John Prell' ,`ListOfficeName` = 'Creekview Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.920772' ,`Longitude` = '-95.170929' ,`PhotoCount` = '21' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '454800.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Mountain' ,`StreetNumber` = '13406' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Gorgeous home with tons of upgrades! Move-in Ready! Stone front, Glass door. Double Crown molding, Shutters. Island kit, Granite counters, S.S. appliances - 5 burner gas stove. Tile in extended entry, baths, kitchen, breakfast den, utility, formal dining. Wood and Pergo floors in formal living, study, master bedroom and secondary rooms. Media Rm with surround sound. Walk-in closets. Customized Elsa master closet. Fresh paint throughout with updated light fixtures and appliances. Covered patios with slate tile. Sprinkler sys. Landscape lighting. Porte Cochere garage. Great schools, lots of amenities throughout community including gym, pools, playgrounds, private access park to Lake Houston. ALSO FOR LEASE' ,`Acres` = '0.1991' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 55 BLK 4 SUMMERWOOD SEC 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8674' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '925' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'SUMMERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Summerwood Sec 18' ,`TaxAmount` = '8646' ,`TaxRate` = '2.7932' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703166' WHERE `Matrix_Unique_ID` = '211180160' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-26T07:47:19.857' ,`MLSNumber` = '19877227' ,`ListAgentFullName` = 'Patricia Buchanan' ,`ListOfficeName` = 'Texas Diamond Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.179333' ,`Longitude` = '-95.166892' ,`PhotoCount` = '35' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Silver Oaks' ,`StreetNumber` = '2211' ,`StreetSuffix` = 'Street' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WOW if you\'re looking for space this is it!! This home in the Roman Forest Subdivision. The appraisal district does not reflect the correct square footage. The 21x15 den is not included. 3 bedrooms, 2 bathrooms, one side of the 2-car garage has been converted to an office w AC. Space galore!! \r\n Also, in 2017 owners had a guest house/tiny house built, you must check it out... so awesome. Storage Shed w/AC. Check out the photos. You have to see this one to appreciate.' ,`Acres` = '0.4291' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S839701 - ROMAN FOREST 01, BLOCK 15, LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '4821' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703166' WHERE `Matrix_Unique_ID` = '211807141' --> Updated record success