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-09-08T00:01:35.483' ,`MLSNumber` = '39532545' ,`ListAgentFullName` = 'Lisa Weatherby' ,`ListOfficeName` = 'LMW Property Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.225339' ,`Longitude` = '-95.314565' ,`PhotoCount` = '24' ,`PostalCode` = '77302' ,`RoomCount` = '4' ,`ListPrice` = '339000.00' ,`Status` = 'Active' ,`StreetName` = 'Deep Woods' ,`StreetNumber` = '16850' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1730' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stop the Car! Awesome country home ! All Brick with Spacious three car garage!This 2 acre lot boasts the best of trees and beautiful green landscape! Comes complete with your own chicken coop/barn ..yard shed! Fully fenced private living! Home has a covered back porch! Large living room..fireplace ! Formal Dining features nice picture windows. Celling fans..Seperate Laundry room..Walk in Pantry ! Home is very nicely laid out inside with plenty of room for your family! The home needs someone new to call it home!!Won\'t last ! Hard to find location!!1 Country living waiting for you !..Convenient to both major freeways ..8mins to 45! Shopping,HEB,! Minutes to The Woodlands Mall!' ,`Acres` = '2.11' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S803500 - PIONEER TRAILS WEST, LOT 33, ACRES 2.11' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '91912' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOPE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pioneer Trails West' ,`TaxAmount` = '1895' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '208342925' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T00:36:44.017' ,`MLSNumber` = '20626342' ,`ListAgentFullName` = 'Stella Chibundu' ,`ListOfficeName` = 'The Wellspring Life Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659308' ,`Longitude` = '-95.614651' ,`PhotoCount` = '6' ,`PostalCode` = '77478' ,`RoomCount` = '10' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'Brookside' ,`StreetNumber` = '13131' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home. Five (5) bedrooms, 3 1/2 bathrooms. 3,154sqft. Home comes with beautiful engineered wood floor, granite countertops, gas stove, tumbled marble backsplash, built-ins, outdoor kitchen, pergola, oil-rubbed bronze doorknobs, upstairs game room, sprinkler system, full gutters and much more.' ,`Acres` = '0.1644' ,`Area` = '29' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ELDRIDGE LAKE SEC 2, BLOCK 1, LOT 31' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'BARRINGTON PLACE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Eldridge Lake Sec 2' ,`TaxAmount` = '6888' ,`TaxRate` = '2.2294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '208678587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T01:59:09.960' ,`MLSNumber` = '98407394' ,`ListAgentFullName` = 'Jaye Wright' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462103' ,`Longitude` = '-94.612964' ,`PhotoCount` = '23' ,`PostalCode` = '77650' ,`RoomCount` = '6' ,`ListPrice` = '749900.00' ,`Status` = 'Active' ,`StreetName` = 'Sandpiper' ,`StreetNumber` = '2420' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1344' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fully furnished 3rd row, 3-bedroom, 2-bath home is located in the quiet, beautiful Driftwood community, directly across from the Big Store. It comfortably sleeps 10 guests with two queens in each guest bedroom, and a queen in the primary. This home is gorgeously decorated and EVERYTHING STAYS, including dishes, pots & pans, refrigerator, washer/dryer, TVs, home decor, bathroom accessories, outdoor furniture, and much more! From the extended deck, enjoy the sounds and views of the ocean while enjoying your morning coffee or evening beverage. Downstairs you\'ll find a built-in charcoal grill, outdoor shower, built-in picnic table, a 1-car garage for storing your golf cart and beach toys, plenty of area for entertaining family and friends, and you are just steps from the neighborhood walkover to the sand and water! If you are looking for move-in ready, look no further because this home is EXACTLY THAT! Perfect for family getaways, full-time residents or as a rental.' ,`Acres` = '0.1768' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 25 DRIFTWOOD ADDN' ,`LotDesciption` = 'Water View' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Driftwood' ,`TaxAmount` = '5028' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '209927298' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T01:22:00.353' ,`MLSNumber` = '11810619' ,`ListAgentFullName` = 'Meredith Flores' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749284' ,`Longitude` = '-95.452009' ,`PhotoCount` = '35' ,`PostalCode` = '77027' ,`RoomCount` = '8' ,`ListPrice` = '2150000.00' ,`Status` = 'Active' ,`StreetName` = 'Eaton' ,`StreetNumber` = '10' ,`StreetSuffix` = 'Square' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This elegant English Regency home is situated in the guarded enclave of Eaton Square. Elevator to all 3 levels, gracious formals, primary bedroom suite with spacious sitting or office area and luxury en-suite bath with two walk-in wardrobes. Two guest bedrooms with en suite baths on second floor, third-floor bedroom with en suite bath. The chef\'s kitchen with breakfast area features marble countertops, center island with cooktop adorned by English pot rack, and is open to the family room. This property boasts designer features throughout including stylish finishes, baccarat light fixtures, a copper backed fireplace, and a Carrerra marble primary bathroom. Additional features include Sonos system throughout, 2 wet bars, a large upstairs laundry room, and state of the art Miele and Sub-zero appliances. Inviting and picturesque landscaped turf backyard with covered loggia. 2-car garage, gated/guarded community. Ample guest parking.' ,`Acres` = '0.1111' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Briar Hollow' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 1 EATON SQUARE AMEND' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '4838' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'English' ,`Subdivision` = 'Eaton Square' ,`TaxAmount` = '' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '210179103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T01:22:00.353' ,`MLSNumber` = '40389583' ,`ListAgentFullName` = 'Robbie Nelson' ,`ListOfficeName` = 'RE/MAX Crossroads Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.298974' ,`Longitude` = '-95.273648' ,`PhotoCount` = '31' ,`PostalCode` = '77577' ,`RoomCount` = '9' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Calhoun' ,`StreetNumber` = '8626' ,`StreetSuffix` = 'Street' ,`City` = 'Liverpool' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Need space? Check out this home on 6 acres! Sit on your front porch and listen to the country life! Split floor plan, carpet installed July 2022, two utility rooms, and open concept.' ,`Acres` = '6' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0006 A H & B TRACT 50 LOT 60A ACRES 6.0 (LIVERPOOL)' ,`LotDesciption` = 'Cleared' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'WALT DISNEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'A H & B' ,`TaxAmount` = '6750' ,`TaxRate` = '2.3984' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '210298878' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T01:22:00.353' ,`MLSNumber` = '55693633' ,`ListAgentFullName` = 'Carolina Pena' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778052' ,`Longitude` = '-95.461118' ,`PhotoCount` = '16' ,`PostalCode` = '77024' ,`RoomCount` = '7' ,`ListPrice` = '1495000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinehaven' ,`StreetNumber` = '615' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3101' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to acquire over 1/3 acre property in the heart of Houston. Upgrade the existing home or build your masterpiece. Zoned to Memorial school system and located in Memorial Close-in. Pinewood Estates is one of the most sought after neighborhoods in Houston. Property includes a majestic live oak in the front yard and six loblolly pines reaching over 80 feet high! Brand new fence installed in March 2022. HOA includes private neighborhood security and trash services. The property was recently renovated and has never flooded.' ,`Acres` = '0.3614' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial Close In' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 PINE WOOD ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15744' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1418' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Pine Wood Estates' ,`TaxAmount` = '24007' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '211137522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T01:22:00.353' ,`MLSNumber` = '34252572' ,`ListAgentFullName` = 'Krista Hughes' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.969182' ,`Longitude` = '-95.449341' ,`PhotoCount` = '33' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'SF Austin' ,`StreetNumber` = '6535' ,`StreetSuffix` = '' ,`City` = 'Jones Creek' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the peaceful community of Jones Creek! Here at 6535 Stephen F Austin you\'ll fall in love with the details, huge yard , TWO garages, and everything that makes this home like none other on the market! This home is equipped with solar panels and a water well making it that much closer to being a self sufficient property! Between the hand crafted custom drawers behind each kitchen cabinet door, under the stairs walk-in pantry, custom made buffet in the dining room, and utilization of storage this house is the perfect place to call your home! Being settled on a corner lot will open you up to tons of space for a beautiful garden! With close proximity to HWY 36 you are not far from any of your destinations. Make your appointment today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ETHEREDGE (A0020 S F AUSTIN DIV 18) BLK 13 LOT 2-3-4 ACRES 0' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '38332' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'J.CREEK' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708034' WHERE `Matrix_Unique_ID` = '211332022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-08T01:22:00.353' ,`MLSNumber` = '87061267' ,`ListAgentFullName` = 'Laura Bolieu' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747428' ,`Longitude` = '-94.834787' ,`PhotoCount` = '40' ,`PostalCode` = '77523' ,`RoomCount` = '6' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Thunder Bay' ,`StreetNumber` = '14610' ,`StreetSuffix` = '' ,`City` = 'Beach City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3207' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home to this Barbers Hill ISD beauty. Stunning custom 4 bedroom,3 bathroom home sits on 3/4 of an acre. The interior features an open floor plan w/the massive primary bedroom tucked away for privacy. The spacious sun soaked dining room, living room, &,open kitchen allows plenty of space for entertaining. The kitchen has plenty of storage including it\'s own walk-in pantry & appliance pantry.Designated office at the front of the home makes it perfect for remote work.One of the secondary bedrooms is oversized for an in-law wing w/its own designated bathroom away from the other living quarters.Upstairs you will enjoy movie nights in the theater room. All theater room furniture included.The backyard Custom pergola, fireplace, swing, BBQ area make the perfect entertainment spot! Lounge furniture included! New roof! 3 car garage has a workshop w/a small sink for all of your projects.Extended driveway for plenty of parking Chambers County low tax rate. Close to all dining and shopping' ,`Acres` = '0.705' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BK 3 LT 13 BARROW RANCH SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '30710' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1.5' ,`Style` = 'Ranch' ,`Subdivision` = 'Barrow Ranch' ,`TaxAmount` = '8084' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663708035' WHERE `Matrix_Unique_ID` = '211924871' --> Updated record success