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-11-22T01:22:00.320' ,`MLSNumber` = '7587305' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.033880' ,`Longitude` = '-95.415491' ,`PhotoCount` = '21' ,`PostalCode` = '77531' ,`RoomCount` = '9' ,`ListPrice` = '536895.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwood' ,`StreetNumber` = '410' ,`StreetSuffix` = 'Way' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! Anglia Homes presents the Chester! This is a beautiful two-story home with two primary bedrooms, one upstairs and one downstairs. This home backs up to the lake, therefor you won\'t have neighbors behind you! The kitchen has quartz counter tops and opens up to the breakfast room and flows into the family room. This home won\'t last long, call today for your private showing!' ,`Acres` = '0.2134' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 4 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 31' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '9296' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '1044' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641060' WHERE `Matrix_Unique_ID` = '206133382' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '73304249' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.032852' ,`Longitude` = '-95.416954' ,`PhotoCount` = '13' ,`PostalCode` = '77531' ,`RoomCount` = '7' ,`ListPrice` = '449495.00' ,`Status` = 'Active' ,`StreetName` = 'Bentwater' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Lane' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2492' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Woodshore! Anglia Homes presents the Gloster! This is a beautiful home with 4 bedrooms, 2 bathrooms and an attached 2 car garage. There is a gameroom upstairs. This home is currently under construction. Call today for your private showing!' ,`Acres` = '0.2188' ,`Area` = '5' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WOODSHORE SEC 4 (A0066 J E GROCE) (CLUTE) BLK 1 LOT 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9531' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'OGG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodshore' ,`TaxAmount` = '842' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641060' WHERE `Matrix_Unique_ID` = '208040215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T02:17:53.053' ,`MLSNumber` = '42828260' ,`ListAgentFullName` = 'Theresa Frazier' ,`ListOfficeName` = 'Heart of Texas Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.860617' ,`Longitude` = '-95.443127' ,`PhotoCount` = '44' ,`PostalCode` = '77320' ,`RoomCount` = '5' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Fishermans' ,`StreetNumber` = '225' ,`StreetSuffix` = 'Trail' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1880' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RIVERFRONT PROPERTY - ENJOY FISHING AT THIS WEEKEND OR PERMANENT HOME RETREAT - Large 3 bedroom, 1 bath with propane Dearborn Heater in the family room, propane wall heater in the extra living room, 5 window units throughout the home, large extra room (would be great for washer/dryer hookup area), 3 breaker boxes in the home; for the 3 sections, freestanding propane cook stove, refrigerator, electric hot water heater. Outside has a side covered porch, 8\'x12\' storage building, 2 car detached carport, large back yard for entertaining and enjoying the river activities. Seller said water came in to the home during Hurricane Harvey in 2017 and hasn\'t since that time.' ,`Acres` = '0.3481' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Riverside (Walker)' ,`HeatSystem` = 'Propane,Space Heater,Wall Heater' ,`HOAMandatory` = '1' ,`Legal` = 'HARMON CREEK RIDGE - SEC 1, LOT 136' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '15164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Harmon Creek Ridge - Sec 1' ,`TaxAmount` = '1074' ,`TaxRate` = '1.7134' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641060' WHERE `Matrix_Unique_ID` = '208111918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '11810619' ,`ListAgentFullName` = 'Meredith Flores' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749284' ,`Longitude` = '-95.452009' ,`PhotoCount` = '32' ,`PostalCode` = '77027' ,`RoomCount` = '8' ,`ListPrice` = '1999999.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`='1669641061' WHERE `Matrix_Unique_ID` = '210179103' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '12326943' ,`ListAgentFullName` = 'Brian Spack' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762939' ,`Longitude` = '-95.476501' ,`PhotoCount` = '49' ,`PostalCode` = '77056' ,`RoomCount` = '19' ,`ListPrice` = '4500000.00' ,`Status` = 'Active' ,`StreetName` = 'Russett' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '9598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Classic elegance designed by Robert Dame, and executed by Goodchild Builders this exquisitely appointed, custom-built Tanglewood home exudes warmth and the sense of gracious living. Reclaimed floors of ancient salvaged oak run through the rooms and corridors that link each room to the next. Wherever the eye falls is a touch of elegance in an artful custom finish—an antique door or transom, a wainscoted arch, or an artisan designed built-in. Rooms are large, while the scale remains intimate making this home perfect for large or cozy gatherings. The Back Yard has a Cloisters-worthy back yard with a sparkling swimming pool and manicured putting green. The luxuries within this home are too numerous to enumerate. A home as grand as this comes once in a lifetime, and it must be seen to be believed.' ,`Acres` = '' ,`Area` = '22' ,`BuilderName` = 'Goodchild' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 15 TANGLEWOOD SEC 10' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '30000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other,Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood' ,`TaxAmount` = '65259' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641061' WHERE `Matrix_Unique_ID` = '210946016' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '43974456' ,`ListAgentFullName` = 'Leigh Marcus' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.050806' ,`Longitude` = '-95.156775' ,`PhotoCount` = '50' ,`PostalCode` = '77345' ,`RoomCount` = '12' ,`ListPrice` = '779900.00' ,`Status` = 'Active' ,`StreetName` = 'Seven Maples' ,`StreetNumber` = '2015' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5345' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXTRAORDINARY CUSTOM 5 BEDROOM HOME BUILT BY MILTON ALLEN! PANORAMIC VIEWS OF THE PRIVATE, LUSH, 16,000 SQ FT YARD WITH POOL/SPA FROM THE ENTIRE BACK OF THE HOME*GREAT FAMILY FRIENDLY FLOOR PLAN WITH GENEROUSLY SIZED SECONDARY BEDROOMS ON THE SECOND FLOOR*IMPRESSIVE ENTRY FLANKED BY THE LARGE DINING ROOM ON ONE SIDE AND THE HOME OFFICE ON THE OTHER. ALL ENERGY EFFICIENT WINDOWS REPLACED*OVERSIZED THREE CAR GARAGE w/EPOXY FLOORING AND BUILT-IN CABINETS FOR STORAGE*3/4\"TIGER OAK HARDWOODS*ROOF, SIX YEARS OLD*VAULTED, BEAMED CEILINGS*HUGE STORAGE AREA (ATTIC SPACE) OFF OF ONE OF THE SECONDARY BEDROOMS*LOVELY LANDSCAPE ON CORNER LOT INCLUDING LANDSCAPE LIGHTING IN THE FRONT AND BACK*IMPRESSIVE CURB APPEAL*ZONED TO EXEMPLARY SCHOOLS*ONE OF MY FAVORITE HOMES IN KINGWOOD. IMPRESSIVE, IMMACULATE, WARM AND FRIENDLY!!' ,`Acres` = '0.3709' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 2 KINGS POINT VLG 1 AMEND R/P' ,`LotDesciption` = 'Corner,In Golf Course Community,Subdivision Lot,Wooded' ,`LotSize` = '16158' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'WILLOW CREEK ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Point Village 01 Amd R/P' ,`TaxAmount` = '16350' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641061' WHERE `Matrix_Unique_ID` = '213177490' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:09:38.657' ,`MLSNumber` = '40677325' ,`ListAgentFullName` = 'Brian Brenner' ,`ListOfficeName` = 'KSP' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.218279' ,`Longitude` = '-95.550237' ,`PhotoCount` = '41' ,`PostalCode` = '77354' ,`RoomCount` = '5' ,`ListPrice` = '379900.00' ,`Status` = 'Active' ,`StreetName` = 'Greenfield Forest' ,`StreetNumber` = '33010' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2636' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home nestled in a lovely neighborhood in Magnolia within 5 minutes of The Woodlands. 5 BEDROOMS! Relax in a primary bedroom suite that includes double sinks, a garden tub, a separate shower, and a walk-in closet. A second room is located on the 1st floor for family members or overnight guests. The 3 additional bedrooms are peacefully located upstairs with a game room. Amazing features throughout. As you enter, the high ceilings compliment an open floor plan. The kitchen with a breakfast bar offers beautiful granite countertops and a tile backsplash. Enjoy a large covered patio overlooking an expansive backyard with a sound reducing multi-use court including basketball, tennis, volleyball and even PICKLEBALL! Perfect for outdoor gatherings! This beautiful home is located just 5 minutes from the Woodlands. Don\'t miss the opportunity to make this house YOUR home!' ,`Acres` = '0.3544' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GREENFIELD FOREST ESTATES, BLOCK 2, LOT 25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15438' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '435' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenfield Forest Estates' ,`TaxAmount` = '5083' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641061' WHERE `Matrix_Unique_ID` = '213407022' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '73699407' ,`ListAgentFullName` = 'Carol Fairchild Steger' ,`ListOfficeName` = 'Houston Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.625523' ,`Longitude` = '-95.010299' ,`PhotoCount` = '50' ,`PostalCode` = '77571' ,`RoomCount` = '5' ,`ListPrice` = '1499900.00' ,`Status` = 'Active' ,`StreetName` = 'Bayshore' ,`StreetNumber` = '3201' ,`StreetSuffix` = 'Drive' ,`City` = 'La Porte' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4188' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury living at it\'s finest! Use it as a home, VRBO or AIRB&B!Just about every major system has been redone/replaced within the last 5 years, such as A/C units, generator, pool, surround sound, water heaters, paint, bulkhead & driveway gate motor w/keypad access & remote system. 30 year roof in 2009, decking is trex lifetime warranty, elevator is maintained annually. It has a remote control mosquito spray system, a sprinkler system, landscape lighting, roomy outdoor kitchen & a temperature controlled wine closet! All windows have hurricane shutters or custom wood coverings. There\'s a separate guest suite w/a bathroom, sitting room & a fabulous view! Bottom floor rooms are connected w/a Hollywood bathroom & have a view w/access to the water. All of the downstairs is \"hurricane clipped\". Listing now includes the 4 lots directly in front - 0 Dwire, 102 Dwire, 106 Dwire and 110 Dwire. MUST SEE PROPERTY! Check out the virtual tours!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 13 & TR 13A BLK 22 BAYSIDE TERRACE BAY OAKS' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '25635' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Bay Oaks' ,`TaxAmount` = '24855' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1669641061' WHERE `Matrix_Unique_ID` = '213522940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '33134191' ,`ListAgentFullName` = 'Matthew Nutt' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005998' ,`Longitude` = '-95.932933' ,`PhotoCount` = '45' ,`PostalCode` = '77484' ,`RoomCount` = '8' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandwedge' ,`StreetNumber` = '32103' ,`StreetSuffix` = 'Drive' ,`City` = 'Waller' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2530' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DON\'T MISS OUT ON THIS ONE-OF-A-KIND HOME! This beautiful 4 bedroom 2.5 bath is just stunning both inside and out. \r\n\r\nLocated on a double lot, off of F.M. 362 in Waller in the Sky Lakes Subdivision, this property truly has it all. From perfectly landscaped flower beds, to a beautifully updated interior, to the gorgeous pool and outdoor kitchen and sitting area, make sure you\'re the one who gets to come home to this fantastic property.' ,`Acres` = '0.5665' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S778200 SKY LAKES 2 BLK 9 LOT 172 & 173' ,`LotDesciption` = 'Corner' ,`LotSize` = '24677' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'H T JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sky Lakes 2' ,`TaxAmount` = '9957' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641062' WHERE `Matrix_Unique_ID` = '213660944' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '17647411' ,`ListAgentFullName` = 'Michelle Feltrop' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.033739' ,`Longitude` = '-95.180985' ,`PhotoCount` = '38' ,`PostalCode` = '77339' ,`RoomCount` = '15' ,`ListPrice` = '1170000.00' ,`Status` = 'Active' ,`StreetName` = 'Club Oak' ,`StreetNumber` = '5' ,`StreetSuffix` = 'Court' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5120' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Indoor-outdoor living & designer interiors in this beautifully updated home. Stunning wide entry double metal doors adds sophistication to the brick facade.This home exudes serenity and peace with beautiful 7\" white oak wood floors, high-end finishes & open floorplan. Downstairs offers high ceilings, open kitchen/living/dining space + primary bedroom with luxurious bathroom including dual sinks, large walk-in shower, freestanding tub & incredible walk-in closet. The chefs kitchen includes DBL ovens, gas cooktop, ice maker, walk-in pantry & storage space/mudroom area. Upstairs brings you to 3 BR,3 BA, game room, reading/computer nook, large flex room or 5th bedroom & 2nd Flr Lndry room. The backyard is finished with a beautiful pool/spa/fountains, large green space & covered patio. 3 car garage. Whole home restoration 2020. New roof 9/22, New generator 9/22, New paint 9/22. New large finished flex room 9/22. Upstairs white oak WD FLRS added to BRs 9/22. Garage floor 9/22. Lndscp 9/22' ,`Acres` = '0.363' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 2 KINGWOOD GREENS' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '15812' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '840' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingwood Greens' ,`TaxAmount` = '17349' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641062' WHERE `Matrix_Unique_ID` = '213911634' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T02:18:53.580' ,`MLSNumber` = '86386643' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771270' ,`Longitude` = '-95.544116' ,`PhotoCount` = '22' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '1068000.00' ,`Status` = 'Active' ,`StreetName` = 'Cobblestone' ,`StreetNumber` = '12227' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2820' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home is in friendly neighborhood of Memorial Forest. Zoned to newly updated Bunker Hill Elementary. 4 bed, 2.5 bath home with Master and 2nd bedroom downstairs. Extra playroom upstairs for children of all ages. Hardwoods, plantation shutters, abundant storage and sprinkler system are just a few of the custom features that make this home special. Remodeled kitchen and baths, new roof (2018) and replaced water supply plumbing (2008). Must see!' ,`Acres` = '0.2294' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 & TR 7 BLK 2 MEMORIAL FOREST SEC 1 R/P' ,`LotDesciption` = 'Corner' ,`LotSize` = '9994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'BUNKER HILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Memorial Forest Sec 01' ,`TaxAmount` = '21093' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641062' WHERE `Matrix_Unique_ID` = '214035095' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '77358807' ,`ListAgentFullName` = 'Konrad Molski' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747864' ,`Longitude` = '-95.435163' ,`PhotoCount` = '50' ,`PostalCode` = '77019' ,`RoomCount` = '11' ,`ListPrice` = '6495000.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia' ,`StreetNumber` = '3637' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '9200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Extraordinary River Oaks Estate positioned on over a 3rd of an acre with a circular brick-paved motor court framed by picturesque oaks leads to magnificent stone facade and regal reception spaces tailored for grand-scale entertaining and fabulous living. ***FIRST TIME Unveiled to market NOV 2022!' ,`Acres` = '0.3415' ,`Area` = '16' ,`BuilderName` = 'Elron Construction' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 74 RIVER OAKS SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Georgian' ,`Subdivision` = 'River Oaks' ,`TaxAmount` = '104076' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669641062' WHERE `Matrix_Unique_ID` = '214575986' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:22:00.320' ,`MLSNumber` = '18551726' ,`ListAgentFullName` = 'Carmen Bezner' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.042213' ,`Longitude` = '-95.202873' ,`PhotoCount` = '26' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Woods' ,`StreetNumber` = '1807' ,`StreetSuffix` = 'Estates' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3307' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful patio home in Kingwood with amazing lake and golf course views. Enjoy sunsets on the wood deck made of Brazilian hardwood. Spacious family room/ dining room offering stunning views. HVAC system replaced after Harvey. Great opportunity to customize your dream home as downstairs needs completion after Harvey in 2017. Flexable layout could be 3 bedrooms with study or 3 with game room. Bathroom upstairs updated, double paned windows and balcony upstairs. Walking distance to KWCC. Please measure rooms for accuracy.' ,`Acres` = '' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 47 BLK 1 KINGWOOD LAKES VILLAGE SEC 5' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,On Golf Course,Water View' ,`LotSize` = '6024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '556' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'KINGWOOD LAKES' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641063' WHERE `Matrix_Unique_ID` = '214660057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-22T01:34:32.780' ,`MLSNumber` = '42147765' ,`ListAgentFullName` = 'Beau Valdez' ,`ListOfficeName` = 'E. Griffin Group LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990261' ,`Longitude` = '-95.588016' ,`PhotoCount` = '50' ,`PostalCode` = '77070' ,`RoomCount` = '7' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Jones' ,`StreetNumber` = '15007' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property in a well established neighborhood close to the Vintage with a large lot with access to a subdivision lake and a water view. Large gameroom upstairs, studio/office outside of main bedroom, entertaining bar in main living area. Main bedroom downstairs and all others up. Newer hard wood floors, and 5o year roof installed recently. In ground swimming pool updated 2 years ago. Magnificent lake view from gameroom upstairs.' ,`Acres` = '0.5234' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball South/Lakewood' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 42 LAKEWOOD FOREST SEC 2' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '22800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'LAKEWOOD ELEMENTARY SCHOOL (TOMBALL)' ,`SchoolHigh` = 'TOMBALL MEMORIAL H S' ,`SchoolMiddle` = 'WILLOW WOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest Sec 02' ,`TaxAmount` = '11905' ,`TaxRate` = '2.4945' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669641063' WHERE `Matrix_Unique_ID` = '214822816' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215020687','1669641063','215020687','2022-11-22T01:01:15.587','68263956','Linh Pham','V-Pro Realtors','','','29.805072','-95.145422','31','77530','6','219500.00','Active','Peachmeadow','15211','Lane','Channelview','2','0','3','1542','Single-Family','Beautiful 1 story house with NEW WATER HEATER, NEW STOVE, NEW FLOOR of TILES and LAMINATE WOODS, NEW PAINT, NEW WINDOW TREATMENT, NEW light fixture in Dining Room, NEW REMODELED OVERSIZED SHOWER in second BATHROOM. A/C UNIT IS ONLY 2 YEARS of age. Stainless Steel microwave. Granite countertops in kitchen and bathrooms. Large living room. Must see.','0.132','2','','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','North Channel','Central Electric','1','E 25 FT OF LT 30 & W 25 FT OF LT 31 BLK 1 STERLING GREEN SEC','Subdivision Lot','5750','Appraisal District','','270','0','','2','Electric Oven','0','','','Electric Range','','Composition','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Sterling Green Sec 09','4264','2.518','Public Sewer,Public Water','1993','Appraisal District'); --> New record created successfully