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-08T09:15:58.763' ,`MLSNumber` = '30871126' ,`ListAgentFullName` = 'Lisa Mayer' ,`ListOfficeName` = 'Round Top Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.149384' ,`Longitude` = '-96.686086' ,`PhotoCount` = '16' ,`PostalCode` = '78932' ,`RoomCount` = '7' ,`ListPrice` = '495000.00' ,`Status` = 'Active' ,`StreetName` = 'St Spur 458' ,`StreetNumber` = '1731' ,`StreetSuffix` = '' ,`City` = 'Carmine' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1092' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'See this cozy farmhouse just 5 miles from Round Top! The 1930s house is a two-bedroom one-bath with a living-dining room and a country kitchen. The home features original hardwood floors, glass French doors and antique front door. This property has a spacious workshop that provides multiple opportunities including an antique venue, workshop, and party barn. This 3/4 of an acre lot has a very spacious feel as it overlooks scenic countryside. Great location for full time residence, weekend getaway, or rental!' ,`Acres` = '0.75' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A013 BEARDSLEE,.75 ACRES,HSE, FARM BLDGS' ,`LotDesciption` = 'Other' ,`LotSize` = '32670' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '206 - Round Top-Carmine' ,`SchoolElementary` = 'ROUND TOP-CARMINE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ROUND TOP-CARMINE HIGH SCHOOL' ,`SchoolMiddle` = 'ROUND TOP-CARMINE HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'n/a' ,`TaxAmount` = '1578' ,`TaxRate` = '1.4319' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663695851' WHERE `Matrix_Unique_ID` = '206382064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:40:15.947' ,`MLSNumber` = '48068637' ,`ListAgentFullName` = 'Mark Menendez' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.764132' ,`Longitude` = '-95.412599' ,`PhotoCount` = '16' ,`PostalCode` = '77007' ,`RoomCount` = '9' ,`ListPrice` = '2250000.00' ,`Status` = 'Active' ,`StreetName` = 'Roy' ,`StreetNumber` = '103' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4960' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '103 Roy Street, a stunning contemporary three-story work of art with excellent natural light and refreshing modern lines that inspire a finer lifestyle. Floor to ceiling glass throughout offers tranquil views of the courtyard with pools and waterfalls perfect for relaxing staycations or entertaining guests. High ceilings provide gallery-like wall space for art collectors and eloquent details with wood and stone elements throughout. Multiple balconies and patios allow for separate retreating spaces all surrounding the spa like pool deck with fountains and movie set lightscaping. Centrally located in the NW Inner Loop, just north of River Oaks, south of the Heights and connected by both Buffalo Bayou and Memorial Parks. Enjoy the greenbelts of Houston, riding bike or running through the many trails, steps from you home.' ,`Acres` = '' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice Military/Washington Corridor' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TR 6 ABST 1 J AUSTIN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MEMORIAL ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rice Military' ,`TaxAmount` = '' ,`TaxRate` = '2.33' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695851' WHERE `Matrix_Unique_ID` = '206824010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:46:12.227' ,`MLSNumber` = '20950970' ,`ListAgentFullName` = 'Carlos Chavez' ,`ListOfficeName` = 'Chavez & Assoc., Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.931536' ,`Longitude` = '-93.905135' ,`PhotoCount` = '3' ,`PostalCode` = '77619' ,`RoomCount` = '5' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Owens' ,`StreetNumber` = '2138' ,`StreetSuffix` = 'Avenue' ,`City` = 'Groves' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1364' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Not the average neighbor home, Recently updated tile flooring, Plumbing, Electrical wiring and outlets, Insulation, Appliances, Doors, Bathrooms, Windows and many other items, roof was replaced 2 years ago also. Property has a metal carport, Nine corner location.' ,`Acres` = '0.1639' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 4 JACKSON PLACE' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7139' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'ADAMS ELEMENTARY SCHOOL (PORT ARTHUR)' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jackson Place' ,`TaxAmount` = '2670' ,`TaxRate` = '3.1797' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695851' WHERE `Matrix_Unique_ID` = '207568675' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:38:16.143' ,`MLSNumber` = '92009316' ,`ListAgentFullName` = 'Mark Menendez' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.762837' ,`Longitude` = '-95.515590' ,`PhotoCount` = '31' ,`PostalCode` = '77024' ,`RoomCount` = '17' ,`ListPrice` = '5300000.00' ,`Status` = 'Active' ,`StreetName` = 'Greencove' ,`StreetNumber` = '403' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '7' ,`BathsHalf` = '2' ,`BedsTotal` = '7' ,`SqFtTotal` = '10980' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This custom home coalesces classic & contemporary elements to create an impressive residence, on a hidden cul de sac, in exclusive Piney Point, Memorial. Curved archways, two story ceilings & walls of windows provide soft transitions, large open spaces, & endless natural light throughout the almost 11,000sf interior. Flanked by a plethora of French doors and huge windows providing open views of the green foliage and curated grounds. A primary and secondary bedroom located on the first floor are on split sides of the home, offering privacy and leading out to the back yard and pool deck. At the center of the home is a large, open, and bright chefs\' kitchen with floor through windows and an adjacent breakfast room overlooking the pool. A grand two-story wall of windows highlights the living room which looks over the large turquoise pool. The second level offers a theatre, game room with light kitchen open to a large terrace. An additional third floor open flex room with full bath awaits.' ,`Acres` = '' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 GREENCOVE R/P' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '41580' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '5' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Piney Point' ,`TaxAmount` = '79218' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '208611522' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:44:12.203' ,`MLSNumber` = '24411920' ,`ListAgentFullName` = 'Priyan Jacob' ,`ListOfficeName` = 'Stride Real Estate, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.496070' ,`Longitude` = '-95.465776' ,`PhotoCount` = '22' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '312635.00' ,`Status` = 'Active' ,`StreetName` = 'William Lane' ,`StreetNumber` = '311' ,`StreetSuffix` = '' ,`City` = 'Arcola' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'D R HORTONS BEAUTIFUL BELLVUE PLAN (ELEVATION N) FEATURING 3 BEDROOMS AND TWO FULL BATH READY FOR ITS NEW OWNER! WITH 42\" CABINETS,STAINLESS STEEL APPLIANCES,QUARTZ COUNTERTOPS AND INCLUDED REFRIGERATOR,THIS STUNNING KITCHEN HAS AN OPEN CONCEPT.HOME ALSO INCLUDES WASHER,DRYER, BLINDS AND GARAGE DOOR OPENERS.A LANDSCAPE PACKAGE ALONG WITH A FULL IRRIGATION IS OFFERED WITH THIS HOME.LOW UTILITY BILLS AS THIS HOME IS ENERGY RATED ALONG WITH TANKLESS WATER HEATER JUST TO NAME A FEW.AMENITY CENTRE FEATURES INCLUDE COMMUNITY POOL, WATER SLIDES, PLAYGROUND FOR KIDS,SOCCER FIELDS AND MUCH MORE.SCHEDULE YOUR PRIVATE TOUR TODAY AND LETS TALK!' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'D R HORTON' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'NA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'CALDWELL RANCH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '209148255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T08:21:59.567' ,`MLSNumber` = '70490314' ,`ListAgentFullName` = 'Dee Lerma' ,`ListOfficeName` = 'Travis Abel & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776575' ,`Longitude` = '-96.154394' ,`PhotoCount` = '18' ,`PostalCode` = '77474' ,`RoomCount` = '4' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Front' ,`StreetNumber` = '731' ,`StreetSuffix` = 'Street' ,`City` = 'Sealy' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '908' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming home in the center of town that sits on a LARGE .25 ACRE CORNER LOT. Primary bedroom has a large closet, as well as a BONUS ROOM that could be used as a home office, nursery, or storage. The kitchen includes stainless appliances, including a refrigerator. A LARGE back and side yard provides plenty of space for activities, adding a garage or workshop, or for storing your boat or camper. The location is also ideal for a business. Property is being sold as-is.' ,`Acres` = '0.2522' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH END ADDN LOT 60 (PART OF LOT 60)' ,`LotDesciption` = 'Corner' ,`LotSize` = '10986' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'South End Add' ,`TaxAmount` = '1869' ,`TaxRate` = '2.149' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '209948810' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T08:53:40.870' ,`MLSNumber` = '60007785' ,`ListAgentFullName` = 'Dana Johnson' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473009' ,`Longitude` = '-94.593666' ,`PhotoCount` = '39' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Cove' ,`StreetNumber` = '971' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1366' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Get away to Stingaree Cove... this 3 Bedroom, 2 Bath oasis offers convenient Beach access & is being sold completely furnished. You\'ll love the soaring ceilings in the Living Room, and the open floor plan. Dining will be a treat; enjoy the view of your deck, through the wall of windows, complete with reflective solar shades. The fully equipped Kitchen offers granite countertops, stainless appliances ample cabinetry, including convenient pull-out trash can, and pantry. 2 Bedrooms share a well appointed full Bathroom downstairs. The Master Suite is located upstairs, and offers a fabulous Master Bath with pretty tiled shower & large walk-in closet. Beautiful bay window looks out onto your private upstairs deck, perfect for enjoying a cool breeze & a beverage. 1 car garage is a perfect place to store your golf cart & has tons of storage as well. The adjacent Tiki Bar with rollup windows offers tons of potential & can be finished out, to your liking. Convenient outdoor Shower, as well.' ,`Acres` = '0.1033' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 11 LOT 16 BLK 4 STINGAREE COVE ADDN' ,`LotDesciption` = 'Other' ,`LotSize` = '4500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Stingaree Cove' ,`TaxAmount` = '6711' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '210358166' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:46:58.230' ,`MLSNumber` = '77004933' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.434477' ,`Longitude` = '-95.637282' ,`PhotoCount` = '8' ,`PostalCode` = '77356' ,`RoomCount` = '12' ,`ListPrice` = '630000.00' ,`Status` = 'Active' ,`StreetName` = 'Camden Hills' ,`StreetNumber` = '92' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BRAND NEW CONSTRUCTION HOME located in the heart of friendly Bentwater Golf Course gated community on Lake Conroe. The house is beautifully situated with approx. 10 feet elevation above the road grade which features a very nice facade. The home features 4 bedrooms and 3.5 baths with an extra huge room that can be used as an office or a gameroom. The primary bedroom/bath located on the 1st floor has a large walk-in closet, double sink vanity, soaking tub and separate walk in shower also has access to the back porch. Kitchen and living room boast a large open floor plan with state of the art remote controlled fireplace. If you are looking to be a part of this beautiful golf course community, now is the best time to give us a call for a great opportunity to pre-select your color choice of interior paint, flooring & other finishes of your dream home. You surely love this friendly gated community, and a lifestyle of golfing, boating, swimming pools, restaurant, spa, sports facilities, etc.' ,`Acres` = '0.1655' ,`Area` = '39' ,`BuilderName` = 'Dwell Custom Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'S261529 - BENTWATER 29, BLOCK 1, LOT 4' ,`LotDesciption` = 'Cleared,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7211' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LINCOLN ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bentwater' ,`TaxAmount` = '381' ,`TaxRate` = '2.1142' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '210404542' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:30:45.613' ,`MLSNumber` = '90178210' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.437376' ,`Longitude` = '-95.489435' ,`PhotoCount` = '11' ,`PostalCode` = '77378' ,`RoomCount` = '5' ,`ListPrice` = '249990.00' ,`Status` = 'Active' ,`StreetName` = 'Cannon Creek' ,`StreetNumber` = '13414' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1311' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in South Meadows in Willis, TX! Conveniently located less than a mile from I-45, South Meadows enjoys a low property tax rate AND close proximity to Lake Conroe, The Woodlands and Huntsville! The Butler plan is a charming 2-story home with 3 bedrooms, 2.5 bathrooms, and 2-car garage! This home has it all - including vinyl plank flooring throughout the common areas! The first floor offers the perfect entertainment space with a large kitchen overlooking the family room! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops, and stainless steel appliances! Retreat to the Owner\'s Suite featuring a sizable shower and spacious walk-in closet! Enjoy the great outdoors with a covered patio! Don\'t miss your opportunity to call South Meadows home, schedule a visit today!' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Legend Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 86 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.57' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '210683781' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:02:29.367' ,`MLSNumber` = '5708236' ,`ListAgentFullName` = 'Phuc Nguyen' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.959827' ,`Longitude` = '-95.462800' ,`PhotoCount` = '30' ,`PostalCode` = '77067' ,`RoomCount` = '4' ,`ListPrice` = '309900.00' ,`Status` = 'Active' ,`StreetName` = 'Diane' ,`StreetNumber` = '12023' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2628' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful brick front exterior property nested in a quiet neighborhood. Home features 4-Bedrooms, 2 & 1/2 Baths, with Primary Bed down, along with large Living area, Formal Dining, Breakfast area, and a Gameroom. Large-designed tiles layered throughout first floor, and laminated wood-flooring throughout second level. Standing shower in Primary bath with glass door and second level bath includes tub-and-shower combo with glass door add a sense of luxury in home. Home has been with one owner and well-taken care of. Refrigerator and Microwave are included with sales. Come by and check out this beautiful home!' ,`Acres` = '0.122' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 3 HERITAGE VILLAGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5313' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HERITAGE ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Heritage Village Sec 04' ,`TaxAmount` = '6497' ,`TaxRate` = '3.1167' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695852' WHERE `Matrix_Unique_ID` = '211123538' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T09:26:18.690' ,`MLSNumber` = '93940734' ,`ListAgentFullName` = 'Kurt Zimmerman' ,`ListOfficeName` = 'PRG, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.373666' ,`Longitude` = '-95.618264' ,`PhotoCount` = '21' ,`PostalCode` = '77356' ,`RoomCount` = '8' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Harbour Town' ,`StreetNumber` = '104' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'OPPORTUNITY KNOCKS at this beautiful home in a GATED, GOLF-COURSE COMMUNITY! Great OPEN FLOOR PLAN, with ALL LIVING AREAS including HOME OFFICE AND TWO BEDROOMS ON FIRST FLOOR, only the 3rd bedroom/Bonus Room is upstairs, along with a full bath. HIGH CEILINGS throughout this well-maintained home. Arched doorways and details add architectural interest. SPACIOUS KITCHEN with LOTS of STORAGE, SOLID SURFACE COUNTERS, SS APPLIANCES, and WALK-IN PANTRY! 2-sided FIREPLACE between FORMAL DINING room and living room. HOME OFFICE/STUDY with French doors leading out to a lovely, covered patio with views of the rosegarden! Each bedroom has its own bath and is separated from the other bedrooms for privacy. OWNERS RETREAT with jetted tub, separate shower, and dbl sinks. WATER SOFTENER. SPRINKLER SYSTEM. NEW AC & FURNACE in 2021. Come enjoy a \"VACATION LIFESTYLE\" and the MANY AMENITIES (marina, country club dining, tennis/pickle ball and more!) offered in April Sound and around Lake Conroe!' ,`Acres` = '0.1439' ,`Area` = '39' ,`BuilderName` = 'DUNN & STONE' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 07, BLOCK 40, LOT 2-B, 3' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6269' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '219' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound 07' ,`TaxAmount` = '5422' ,`TaxRate` = '2.2625' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695853' WHERE `Matrix_Unique_ID` = '211152653' --> Updated record success