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-04T20:48:05.470' ,`MLSNumber` = '35534240' ,`ListAgentFullName` = 'Joe Forkner' ,`ListOfficeName` = 'Anne Willis Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.452485' ,`Longitude` = '-94.634189' ,`PhotoCount` = '14' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '778750.00' ,`Status` = 'Active' ,`StreetName` = 'Pompano' ,`StreetNumber` = '1823' ,`StreetSuffix` = 'Lane' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1750' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful house located 4th row from the beach in the center of Crystal Beach. Easy beach access. Close proximity to all restaurants and shopping.Double lot. 8,400 sq. ft. House will be sold fully furnished except living room coffee table.' ,`Acres` = '0.1928' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 179 J SHAW SUR LOT 20 & S 100 FT OF LOT 19 BLK 1 BLALOC' ,`LotDesciption` = 'Other' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Blalock' ,`TaxAmount` = '6030' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663694520' WHERE `Matrix_Unique_ID` = '206280729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T21:46:03.853' ,`MLSNumber` = '33542239' ,`ListAgentFullName` = 'Kim Nguyen' ,`ListOfficeName` = 'Lone Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583306' ,`Longitude` = '-95.637281' ,`PhotoCount` = '39' ,`PostalCode` = '77479' ,`RoomCount` = '12' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'MARIGOLD' ,`StreetNumber` = '17427' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Good location recently UPDATED AND REPLACE:ELECTRIAL & PLUMBING FIXTURES, NEW EXTERIOR AND INTERIOR PAINT, TILE FLOOR EXCEPT BEDROOM W/BERBER CARPET, GRANITE KITCHEN COUNTERTOP, MARBLE BATHS. BOTH FORMALS GREAT FOR ENTERTAINING.OPEN KITCHEN CONCEPT INSLAND WITH DOUBLE OVEN. .FAMILY ROOM W/CORNER FIREPLACE OVERLOOKING LARGE BACKYARD.GAMEROOM UP W/HOLLYWOOD BATH AND 3 BEDROOMS. LACATED ON WOODED AND CORNER LOT. GREAT FORT BEND ISD:COLONY MEADOW(ELEM),FORT SETTLEMENT(MIDDLE),CLEMENTS(HIGH) SCHOOL. CLOSE TO POOL,PARKS,SHOPPING, EASY FREEWAY ACCESS.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'New Mark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LEXINGTON MEADOWS SEC 1, BLOCK 1, LOT 7' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '7788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Crescent Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694520' WHERE `Matrix_Unique_ID` = '209913065' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T21:32:50.757' ,`MLSNumber` = '89478349' ,`ListAgentFullName` = 'Zach Richmond' ,`ListOfficeName` = 'RE/MAX The Woodlands & Spring' ,`SellingAgentFullName` = 'Janice Clow' ,`SellingOfficeName` = 'RE/MAX The Woodlands & Spring' ,`Latitude` = '30.180142' ,`Longitude` = '-95.515831' ,`PhotoCount` = '33' ,`PostalCode` = '77381' ,`RoomCount` = '8' ,`ListPrice` = '560000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Copperknoll' ,`StreetNumber` = '156' ,`StreetSuffix` = 'Circle' ,`City` = 'The Woodlands' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2639' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in desirable Copperknoll, this beautiful, light and bright one-story with a gated courtyard features a superb, open floor plan with high ceilings, hardwood and travertine floors, plantation shutters and crown molding throughout. Offering a gas-log fireplace and expansive windows, the lovely family room flows seamlessly to an island kitchen with granite counters, abundant cabinetry and cozy breakfast room. The handsome, executive study with built-in\'s & glass French doors provide an ideal work-from-home space. Oversized owners\' retreat includes a luxurious bath with dual sinks, make-up vanity, soaking tub & separate shower. A tranquil backyard with lush landscaping, covered patio with ceiling fans & pergola is great for relaxing & entertaining. Upscale shopping/dining, parks, country club, golf course, hospitals & entertainment venues are minutes away. WHOLE-HOUSE GENERATOR, LOW TAX RATE, SUPERB NEIGHBORHOOD, EXEMPLARY WOODLANDS SCHOOLS are few extras with well-maintained home!' ,`Acres` = '0.1915' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VILLAGE COCHRANS CROSSING 27, BLOCK 1, LOT 9' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8342' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'DAVID ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS COLLEGE PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KNOX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wdlnds Village Cochrans Cr 27' ,`TaxAmount` = '7963' ,`TaxRate` = '2.1811' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694520' WHERE `Matrix_Unique_ID` = '210192055' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T21:51:40.147' ,`MLSNumber` = '11200979' ,`ListAgentFullName` = 'Steven Johns' ,`ListOfficeName` = 'The Woodlands Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.187739' ,`Longitude` = '-95.525546' ,`PhotoCount` = '47' ,`PostalCode` = '77381' ,`RoomCount` = '12' ,`ListPrice` = '1000000.00' ,`Status` = 'Active' ,`StreetName` = 'Eagle Terrace' ,`StreetNumber` = '38' ,`StreetSuffix` = '' ,`City` = 'The Woodlands' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate Cochrans Crossing custom home walking distance to Galatas Elementary, The Woodlands Palmer Course (General) and Palmer Club House. Beautifully landscaped cul-de-sac homesite with mature trees. Upon entry through the property\'s double doors you\'ll immediately appreciate the custom features including solid hardwood flooring and impressive custom mill-work throughout. Beyond the study and dining room is a very impressive/elegant 2-story formal living area with gaslog fireplace and hardwood staircase. The island kitchen features upgraded KitchenAid appliances,freshly painted cabinets and is open to the large family room. The Master bedroom with high cathedral ceiling is down along with an elegant master bath with his/her closets & BainUltra jetted tub. Game room up along with 4 additional bedrooms.16 SEER HVAC systems.Private backyard oasis w/saltwater, Pebble Tec pool and stamped concrete decking.' ,`Acres` = '0.3418' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'WDLNDS VIL COCHRANS CR 22, BLOCK 4, LOT 6' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '14888' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GALATAS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Village Cochrans Crossing' ,`TaxAmount` = '14408' ,`TaxRate` = '2.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694521' WHERE `Matrix_Unique_ID` = '210194715' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T21:29:34.703' ,`MLSNumber` = '43310961' ,`ListAgentFullName` = 'Vanessa Sun' ,`ListOfficeName` = 'Forever Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675673' ,`Longitude` = '-95.359281' ,`PhotoCount` = '22' ,`PostalCode` = '77051' ,`RoomCount` = '6' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Mclean' ,`StreetNumber` = '7802' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1788' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home located in Sunnyside!\r\nThis lovely spacious 3-2 home has everything you are looking for: a large lot with a big back yard, 42\"cabinets, kitchen island, large pantry, granite countertops, spacious bedrooms, good size closets, ceiling fans in every room, large shower(48\" x 44\") that can freshen you up with maximum comfort; garden tub and his and hers walk in closets..... not to mention the convenient location of this home: only a few minutes away from downtown, medical center and highway 610 and 288.\r\nStop looking and schedule you showing today!' ,`Acres` = '0.1389' ,`Area` = '3' ,`BuilderName` = 'n/a' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 12 BLK 3 EAST SUNNYSIDE COURT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'East Sunnyside Court Sec 01' ,`TaxAmount` = '2529' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694521' WHERE `Matrix_Unique_ID` = '210270816' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-04T20:10:30.180' ,`MLSNumber` = '29393961' ,`ListAgentFullName` = 'Jennifer Stence' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793550' ,`Longitude` = '-95.816793' ,`PhotoCount` = '36' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Drexel' ,`StreetNumber` = '1507' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bedroom, 2 bath traditional home located on large lot in Katy Heights neighborhood in old Katy. Home exterior has been freshly painted and roof was replaced in 2018. Spacious room at front of home could be a formal dining & is currently used as a home office with French doors to close & create a quiet workspace. Kitchen has pantry and plenty of counter/cabinet space with bar separating it from living/family room, double ovens. Washer/Dryer are located in their own closet as you enter home from garage. Entire home has tile or laminate flooring - no carpeting. Back porch has been enclosed to create additional living space/sunroom. There is a storage building in the backyard for tools or yard supplies, freeing up space in the 2-car garage. Double gate at north side of lot can allow for boat or RV storage in backyard. No MUD, no HOA, low tax rate of 2.38%. Easy walk to library, Mary Peckham Park & dog park. Zoned to Katy High School - GO TIGERS!' ,`Acres` = '0.2879' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 6 KATY HEIGHTS SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'HUTSELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Heights Sec 04' ,`TaxAmount` = '4567' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694521' WHERE `Matrix_Unique_ID` = '210964872' --> Updated record success