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-14T14:34:51.680' ,`MLSNumber` = '32313939' ,`ListAgentFullName` = 'Cynthia Stasny' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.076697' ,`Longitude` = '-96.211261' ,`PhotoCount` = '23' ,`PostalCode` = '77871' ,`RoomCount` = '3' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'New Mexico' ,`StreetNumber` = '51' ,`StreetSuffix` = 'Parkway' ,`City` = 'Hilltop Lakes' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If a quiet, peaceful retreat like setting is what your looking for, then you\'ve found it! This 3 bed 2 bath home is tucked in the woods for ultimate privacy. Walking inside you\'ll notice the spacious living room with the beautiful wood burning stove. The kitchen boasts tons of cabinets for storage, ample counter space, gas range, & separate dining area. Check out the added bonus room off the living room. Master bedroom is spacious with its own private bathroom. With more than 25,000 square feet of property there\'s endless possibilities from gardens, to chickens! You could even add to your land and purchase additional lots in the area. If amenities are what you\'re after, then Hilltop Lakes has it! From golfing, tennis, swimming pools, miniature golf course, disc golf, stables, lakes, fitness center, and community clubs, there\'s something for everyone! There\'s even a hotel and, RV park, campgrounds, airport, library, churches, and restaurants.' ,`Acres` = '0.5742' ,`Area` = '63' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Normangee/Marquez Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HILLTOP LAKES SEC 47B BLK 7 LT 11-12' ,`LotDesciption` = 'In Golf Course Community,Wooded' ,`LotSize` = '25013' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '131 - Normangee' ,`SchoolElementary` = 'NORMANGEE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORMANGEE HIGH SCHOOL' ,`SchoolMiddle` = 'NORMANGEE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hilltop Lakes Sec 47-B' ,`TaxAmount` = '1816' ,`TaxRate` = '1.8895' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '205869223' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T15:44:19.673' ,`MLSNumber` = '10905020' ,`ListAgentFullName` = 'Booker Terrell' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Christian Luis' ,`SellingOfficeName` = 'Krueger Real Estate' ,`Latitude` = '29.814806' ,`Longitude` = '-95.322704' ,`PhotoCount` = '22' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '230000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wipprecht' ,`StreetNumber` = '6103' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2056' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two properties for the price of one. Looking for home ownership with an opportunity to generate passive income? Just inside 610 loop, minutes from downtown Houston. Home is being sold as is, along with an adjoining vacant lot. Go to MLS # 79149425 for details about the lot! That\'s right, two properties for one price. The home is liveable and could be updated at leisure. Roof is 5 years old. AC unit is being serviced. Homes boasts over 1835 square feet, large kitchen, family and den. The vacant lot once had a garage/apartment which has now been demolished, creating the opportunity to build a new home. \r\n\r\n\r\nNo HOA Dues, No Mud Taxes. Opportunity and options are present for home ownership or investment opportunity. This community is up and coming whereby gentrification is underway. Many homes have been rennovated and there are more than several new builds. Book your showing, bring your offers and make your investment in this opportunity go to work for you.' ,`Acres` = '0.2066' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 1411A BLK 58 KASHMERE GARDENS EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KASHMERE GARDENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KASHMERE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Kashmere Gardens' ,`TaxAmount` = '4178' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '209521851' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T14:56:49.110' ,`MLSNumber` = '53781099' ,`ListAgentFullName` = 'Brenda Richardson' ,`ListOfficeName` = 'U.S.A. Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712738' ,`Longitude` = '-95.353331' ,`PhotoCount` = '11' ,`PostalCode` = '77004' ,`RoomCount` = '9' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm' ,`StreetNumber` = '3837' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1833' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently remodeled 3 bedroom 2 bathroom home near the Medical Center and Downtown Houston. Easy access to the freeway.' ,`Acres` = '0.1598' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 24 BLK 4 UNIVERSITY WOODS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Universtiy Woods' ,`TaxAmount` = '6130' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '209785675' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T14:18:44.980' ,`MLSNumber` = '80334767' ,`ListAgentFullName` = 'Rebecca Morris' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.152586' ,`Longitude` = '-95.527074' ,`PhotoCount` = '47' ,`PostalCode` = '77389' ,`RoomCount` = '11' ,`ListPrice` = '749000.00' ,`Status` = 'Active' ,`StreetName` = 'Langstone' ,`StreetNumber` = '38' ,`StreetSuffix` = 'Place' ,`City` = 'The Woodlands' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home is in the sought after Village of Creekside Park. Very near to hike & bike trails, parks and schools. Easy walk to Rob Fleming Park and Aquatic Center and Woodlands Recreation Center. Home is close to the Creekside Village Center with shopping, restaurants, movie theater and HEB Grocery Store. \r\nThe property backs up to a greenbelt for privacy - beautiful backyard with lots of space and trees. Inside is immaculate with two bedrooms down. Second bedroom down could also be a second office for working from home or an exercise room. Wonderful chefs kitchen and large walk in pantry. Upstairs are 3 more bedrooms and a large game room leading to the media room. True 3 car garage with lots of space. Perfect for a family.' ,`Acres` = '0.2605' ,`Area` = '14' ,`BuilderName` = 'Village Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 9' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '11347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park 09' ,`TaxAmount` = '14100' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '209827471' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T14:57:43.690' ,`MLSNumber` = '95491157' ,`ListAgentFullName` = 'Brenda Richardson' ,`ListOfficeName` = 'U.S.A. Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.082141' ,`Longitude` = '-95.384852' ,`PhotoCount` = '10' ,`PostalCode` = '77373' ,`RoomCount` = '9' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Cross Green' ,`StreetNumber` = '3615' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely 1-Story 3 bedroom 2 bath home is waiting on the right owner. Located in an established friendly neighborhood. Home is convenient to Hardy, 99 toll road and I-45. See this beautiful home and fall in love at first sight.' ,`Acres` = '0.1518' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 3 LEXINGTON WOODS SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6612' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOHN WINSHIP ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'TWIN CREEKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lexington Woods' ,`TaxAmount` = '4043' ,`TaxRate` = '2.2769' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '209920516' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T15:42:41.460' ,`MLSNumber` = '87629130' ,`ListAgentFullName` = 'Christopher Davidson' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.793667' ,`Longitude` = '-95.375555' ,`PhotoCount` = '33' ,`PostalCode` = '77009' ,`RoomCount` = '8' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Enid' ,`StreetNumber` = '307' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This gorgeous Bungalow is truly one of a kind. Nestled in the heart of Brookesmith, this home was completely remodeled with a 1,300sqft New Addition. 10ft ceilings all throughout, Lusso Silestone Quartz Countertops, a large Kitchen that opens to the Living and Dining area! Kitchen has a 8ft Island and a 6ft Peninsula for additional seating. Dining Room can fit a +10 person dining table. All new PEX Plumbing and Sewer Line, new Electrical, new HVAC & Furnace, Tankless Water Heater, all new Stainless Steel Appliances, Wainscoting & Shiplap throughout, oversized bedrooms with walk-in closets in each room. Master Bedroom features a walk-in closet with His & Hers shelving to the ceiling. Rainfall shower head in the Master Shower. Both the front gate and alleyway come with automatic gate openers for additional parking. 1 minute from downtown and 2 city blocks away from Hwy 45!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 17 BROOKE SMITH' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '14503' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '209996800' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T14:48:54.743' ,`MLSNumber` = '79966405' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875809' ,`Longitude` = '-95.794249' ,`PhotoCount` = '24' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '366440.00' ,`Status` = 'Active' ,`StreetName` = 'Tallgrass Meadow' ,`StreetNumber` = '24311' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large scrumptious Chef\'s kitchen with eat at island!! Lots of natural light in the family room and dining space filled with windows with views of the the back porch and backyard with sod and sprinklers. This popular 3 bedroom two bath home has wood tile flooring in the living spaces and carpet in all the bedrooms. Light gray cabinets with luxurious white quartz kitchen counters. Main bath has a tub, shower and two sinks.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot:35 Block:4 Section:35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.495' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698545' WHERE `Matrix_Unique_ID` = '211167899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-14T15:26:24.850' ,`MLSNumber` = '74572350' ,`ListAgentFullName` = 'Dakar Gibbs' ,`ListOfficeName` = 'Century 21 ExclusiveProperties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.849981' ,`Longitude` = '-95.418344' ,`PhotoCount` = '23' ,`PostalCode` = '77091' ,`RoomCount` = '7' ,`ListPrice` = '532944.00' ,`Status` = 'Active' ,`StreetName` = 'Paul Quinn' ,`StreetNumber` = '809' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2264' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Paul Quinn Place features 4 individually gated single family contemporary homes with remote gate access and guest parking. 809 Paul Quinn features the 2,264SF Oleander floor plan with 3 BR, 3.5 BTH, game room and massive 3rd floor patio/outdoor kitchen. Front elevation features 21” of beautiful stone and 4x8 hardie! Porcelain, quartz and glass in bathrooms! Soft close cabinets! 10’ ceilings on 1st and 2nd floors! 9’ ceiling on 3rd floor! Large bedrooms/closets! Tall ceilings! Custom doors! Plenty of natural light! Custom glass balcony rails! Smart wired including garage! Lots of storage space! Great finishes! Plenty of amenities within 3 miles or less (Memorial Hermann Greater Heights, Starbucks, BofA, Chase, BBVA, Home Depot, Lowe’s, HEB, Kroger, Berryhill, Five Guys, Walking Stick, Oak Forest Public Library, I-45, and 610) No HOA dues! Centrally located 8 miles from downtown! Ask about appliance package if you close by September 2nd! Custom Urban Living! Schedule showing today!' ,`Acres` = '0' ,`Area` = '9' ,`BuilderName` = '44 Builders LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 PAUL QUINN PLACE' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '1946' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HIGHLAND HEIGHTS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'HIGHLAND HEIGHTS ANNEX' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663698546' WHERE `Matrix_Unique_ID` = '211412509' --> Updated record success