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-30T07:08:12.960' ,`MLSNumber` = '85780589' ,`ListAgentFullName` = 'Erin Lumpkin' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778647' ,`Longitude` = '-95.572868' ,`PhotoCount` = '35' ,`PostalCode` = '77079' ,`RoomCount` = '13' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Leaning Ash' ,`StreetNumber` = '10934' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '3960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ideal opportunity to transform this spacious 6 bedroom 4.5 bath house into your dream home! It is situated on a half acre, private, quiet cul-de-sac lot zoned to highly sought after Rummel Creek Elementary, Memorial Middle and Stratford High School. Uniquely designed with primary suite downstairs, additional private guest suite downstairs as well, and all other 4 bedrooms and game room upstairs. Guest suite could be used as the perfect place for space for multi-generational living, live-in nanny or housekeeper, media/hobby room or workout space. Each upstairs bedroom has a built-in desk and shared en-suite bathroom. Home features high ceilings, crown molding, built-ins, and ample storage. Air conditioned workspace is off the garage is perfect for any handyman or gardener. Trane A/C units replaced inside and out in 2013. All new duct work in 2018. Large, private backyard is perfect to add your own outdoor pool or kitchen.' ,`Acres` = '0.5' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 ASHWOOD U/R' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '21780' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashwood U/R' ,`TaxAmount` = '21451' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704721' WHERE `Matrix_Unique_ID` = '205762294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T07:38:13.630' ,`MLSNumber` = '75311965' ,`ListAgentFullName` = 'Donn Clark' ,`ListOfficeName` = 'R. Alexa Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.001286' ,`Longitude` = '-95.323176' ,`PhotoCount` = '18' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'DUNCAN' ,`StreetNumber` = '2902' ,`StreetSuffix` = '' ,`City` = 'Oyster Creek' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4/2 on large lot located in a quite subdivision. family room with a space for a large T.V. all rooms are estimated and should be verified by buying agent. Primary bath has his and her sinks plus a big soaker tub plus a shower. Located just a few mile from the ocean, this is a great weekend get away or the perfect forever home. \r\n\r\nPRICE REDUCED.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 35 Section 1 Shady Creek Subdivision' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Shady Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704721' WHERE `Matrix_Unique_ID` = '208751373' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T07:25:59.233' ,`MLSNumber` = '23813402' ,`ListAgentFullName` = 'Colleen Hawkins' ,`ListOfficeName` = 'RE/MAX Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.930614' ,`Longitude` = '-95.669616' ,`PhotoCount` = '49' ,`PostalCode` = '77095' ,`RoomCount` = '11' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Keystone Fairway' ,`StreetNumber` = '10938' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3525' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come visit this beautiful and well maintained spacious home with a pool located in the gated Stone Gate community. Enjoy your views from the spa like backyard that looks out upon Houston National Golf Course. This 5 bedroom 4 bath home is loaded with features including a gourmet island kitchen with granite counter tops, 42\" cabinets, large Primary bedroom suite, primary bath with separate jetted tub and shower, a secondary bedroom located on 1st floor with an attached full bathroom, 3 additional bedrooms located upstairs with 2 full bathrooms, large gameroom, spacious laundry room, oversized garage, sprinkler system, etc. Please schedule your tour soon of this magnificent home. Don\'t miss this one! Recent price reduction is a reflection and acknowledgement of changes in the housing market.' ,`Acres` = '0.2204' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 3 STONE GATE SEC 5' ,`LotDesciption` = 'On Golf Course,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1140' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BIRKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Gate Sec 5' ,`TaxAmount` = '8944' ,`TaxRate` = '2.561' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704721' WHERE `Matrix_Unique_ID` = '209878697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T06:57:46.090' ,`MLSNumber` = '19465972' ,`ListAgentFullName` = 'Lynn Collins' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.887622' ,`Longitude` = '-95.534670' ,`PhotoCount` = '43' ,`PostalCode` = '77040' ,`RoomCount` = '10' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Brahms' ,`StreetNumber` = '9114' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3776' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully Appointed Lakefront 2-Story Executive Home on Peaceful Oversized Cul-De-Sac Lot with Sparkling Pool/Spa, 4 Laminar Jets. Walls of Windows for Spectacular Lake Views. Chef\'s Island Kitchen w/Abundant Cabinet & Counter Space, Stainless Appliances, 5-Burner Gas Cooktop & Sit-up Bar. Light & Bright Breakfast Area with 2 French Doors. Custom Built-ins in Family Rm. Renovated 2ndary Baths. Spacious 2ndary Bedrooms. Renovated Primary Bath has Custom Built-ins, Deep Jetted Soaker Tub, Dual Walk-in Closets & Linen Closet. Enormous Game Rm w/Built-Ins. Large Laundry Rm w/Built-ins. Updated Lighting/Hardware/Fixtures Throughout. Covered Patio Area and Large Deck for Entertaining. Fantastic Curb Appeal. Roof (2021). ACs (2020). Recent Water Heaters. Pool Pump (2022) Heater (2020). NO FLOODING. A Definite Must See! You\'ll Love the Woodwind Lakes Neighborhood with Mature Trees, 3 Peaceful Lakes with Walking Trails, Catch & Release Fishing, 2 Pools, Tennis Courts, Pavilion and Dog Park.' ,`Acres` = '0.2562' ,`Area` = '11' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 3 WOODWIND LAKES SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Waterfront,Wooded' ,`LotSize` = '11162' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '815' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodwind Lakes Sec 01' ,`TaxAmount` = '9793' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704721' WHERE `Matrix_Unique_ID` = '210706687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T07:13:16.620' ,`MLSNumber` = '87667166' ,`ListAgentFullName` = 'Luis Irizarry' ,`ListOfficeName` = 'The Honor Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.970671' ,`Longitude` = '-95.511078' ,`PhotoCount` = '40' ,`PostalCode` = '77066' ,`RoomCount` = '12' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Arbor' ,`StreetNumber` = '5822' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful home that has so much to offer in the quiet Greenwood Forest community! This 4-bedroom, 3-bathroom home has high ceilings, crown and base molding, upgraded tile flooring, wainscoting in the dining room, and a fireplace with a stone surround. It also offers a separate unique suite with a kitchenette, HVAC, personal access, and bathroom (possible Airbnb) with private pool access. The pool is resurfaced and retiled and is surrounded by a beautifully landscaped backyard. Relax in the amazing master suite, featuring French patio doors, pool access, dual vanities, and a tub with a shower. Enjoy a chef\'s dream kitchen complete with granite countertops, a tile backsplash, and a stainless steel gas range. Easy access to Highway 249, Vintage Park, Sam Houston Tollway, and Downtown Houston. Request a showing today!' ,`Acres` = '0.2104' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 28 017*G6652900-004-028-026 GREENWOOD FOREST SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9165' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'GREENWOOD FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'WUNDERLICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenwood Forest' ,`TaxAmount` = '6308' ,`TaxRate` = '2.3715' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704721' WHERE `Matrix_Unique_ID` = '211603662' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T07:54:42.170' ,`MLSNumber` = '35719095' ,`ListAgentFullName` = 'Janet Schmidt' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.679806' ,`Longitude` = '-95.489777' ,`PhotoCount` = '13' ,`PostalCode` = '77096' ,`RoomCount` = '7' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Braesvalley' ,`StreetNumber` = '5719' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1842' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is ready for someone to make their home. Total redo.' ,`Acres` = '0.1901' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 5 MAPLEWOOD NORTH SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8280' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Maplewood North' ,`TaxAmount` = '4451' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704721' WHERE `Matrix_Unique_ID` = '211911178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T07:33:00.187' ,`MLSNumber` = '30149179' ,`ListAgentFullName` = 'Tami Peters' ,`ListOfficeName` = 'Peters Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.831714' ,`Longitude` = '-95.311454' ,`PhotoCount` = '25' ,`PostalCode` = '77016' ,`RoomCount` = '4' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Dandy' ,`StreetNumber` = '7817' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1043' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home that features 4 bedrooms and 1 bath room. The kitchen has completely update with a open area to the family room. This home has a work shop in the back and gazabeo for family fun. Come make this house your new home!' ,`Acres` = '0.1703' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 200 BLK 13 TRIANGLE GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'COOK ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Triangle Gardens Sec 02' ,`TaxAmount` = '1204' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704722' WHERE `Matrix_Unique_ID` = '211921002' --> Updated record success