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-18T19:07:14.187' ,`MLSNumber` = '36091302' ,`ListAgentFullName` = 'Katie Gaffigan' ,`ListOfficeName` = 'Segue Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080187' ,`Longitude` = '-95.712629' ,`PhotoCount` = '30' ,`PostalCode` = '77377' ,`RoomCount` = '3' ,`ListPrice` = '819900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2920' ,`StreetNumber` = '18702' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home with details throughout. Crown molding, coffered ceilings, custom cabinetry, bright sunroom, water softner, finised garage, mosquito misting system, this home has it all. The property is setup for wheelchair access including, wide doorways, ramps, and a wheelchair friendly shower. Excellent location with great visibility & 111 feet of frontage on FM 2920 in high density residential & commercial populated area in rapidly expanding Tomball, TX. Property includes a 3,462 SF custom home/office with gourmet kitchen, high-end finishes & immense attention to detail. Tract are less than 2 miles from the Grand Parkway (99) & only 5 miles from SH-249. Adjoining 1 & 1.02 acres with 1,539 SF & 1,036 SF offices also available for sale with +/- 340 combined feet of frontage along FM 2920 for all 3 tracts' ,`Acres` = '1' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 23D-1 ABST 7 S BROWN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'unrestricted' ,`TaxAmount` = '10888' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '203578573' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:27:52.837' ,`MLSNumber` = '39863095' ,`ListAgentFullName` = 'Lou Rosas' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.694647' ,`Longitude` = '-95.284446' ,`PhotoCount` = '22' ,`PostalCode` = '77017' ,`RoomCount` = '9' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Detroit' ,`StreetNumber` = '7824' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1576' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1435' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 204 PARK PLACE CIRCLE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '0' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place Circle' ,`TaxAmount` = '3318' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '205590750' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:40:04.360' ,`MLSNumber` = '34004149' ,`ListAgentFullName` = 'Jose Barbosa' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938498' ,`Longitude` = '-95.254021' ,`PhotoCount` = '16' ,`PostalCode` = '77396' ,`RoomCount` = '6' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Fawn Park' ,`StreetNumber` = '9402' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2731' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step inside this stunning 4 bedroom 2.5 bath 2-story home located in the family-friendly community of Canyon Village at Park Lakes on quiet cul-de-sac. Enjoy cooking in the gourmet kitchen which features 42\" cabinets, tons of space for storage all open to a cozy living area adorned with lots of windows allowing tons of natural light. Huge back yard with a covered back patio perfect for hosting outdoor events or simply relax while you watch the sunset.' ,`Acres` = '0.1911' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 2 CANYON VILLAGE AT PARK LAKES SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8323' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Village At Park Lakes Sec 6' ,`TaxAmount` = '6896' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '206718783' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:06:35.140' ,`MLSNumber` = '81141795' ,`ListAgentFullName` = 'Lillie Boson' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.592606' ,`Longitude` = '-95.129318' ,`PhotoCount` = '32' ,`PostalCode` = '77331' ,`RoomCount` = '5' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Kelly' ,`StreetNumber` = '60' ,`StreetSuffix` = 'Circle' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL, QUIET, SECLUDED COUNTRY PARADISE WITH ROLLING HILLS located less than 5 minutes from Lake Livingston, and Trinity River....GREAT FISHING. Homeowners have access to the Community Boat Ramp, and Trinity River. This property consist of 6 LOTS all to be sold together which equals a total of 2.51 Acres. A well maintained Country home sits on one lot. Pavilion with kitchen, and Dining Area with wood burning heater. Outside is an Aerated Bowl to keep live fish, and a fish cleaning station. In Ground Pool for Kids play. Perfect place for entertaining or family that loves to play outside.\r\nNEVER FLOODED!!\r\n THE CAMPER OUT FRONT IS FOR SALE, BUT NOT WITH THE PROPERTY.\r\nEVERYTHING SELLING AS IS.... Furniture and Appliances do not go with the sale of the house.' ,`Acres` = '0.2514' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'CEDAR VALLEY #2, BLOCK 1, LOT 22, ACRES .2514' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10951' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '128' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Fiberglass' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cedar Valley #2' ,`TaxAmount` = '2230' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '207517010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:17:34.130' ,`MLSNumber` = '23108950' ,`ListAgentFullName` = 'Raevonne Walker' ,`ListOfficeName` = 'CR Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.581597' ,`Longitude` = '-95.125042' ,`PhotoCount` = '19' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 150' ,`StreetNumber` = '801' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1590' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '1.96' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A042 ROBERT RANKIN, TRACT 169, ACRES 1.96' ,`LotDesciption` = 'Cleared' ,`LotSize` = '85378' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Robert Rankin League Or Surv A' ,`TaxAmount` = '1987' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '208276161' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T19:30:35.647' ,`MLSNumber` = '78597464' ,`ListAgentFullName` = 'Curtis Miller' ,`ListOfficeName` = 'BHGRE Gary GreeneGalveston In Town' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.733504' ,`Longitude` = '-95.506924' ,`PhotoCount` = '15' ,`PostalCode` = '77063' ,`RoomCount` = '18' ,`ListPrice` = '930000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowbriar' ,`StreetNumber` = '7819' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '6100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come experience this estate size home. Excellent floor plan for the whole family featuring 2 stair cases and a separate back entrance to the adjoining guest quarters with its own bathroom and kitchen. The upstairs living/game room lets the kids be kids. Oversized bedrooms allow individuality for every family member. Need a putting green and pool? There is more than enough room for outdoor activities. the developer of the neighborhood built this home as his personal home and included solid wood interior doors and nice woodwork throughout the home.' ,`Acres` = '0.4107' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briarmeadow/Tanglewilde' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 & TRS 12B & 14A BLK 10 BRIARMEADOW SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17892' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '762' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PINEY POINT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarmeadow Sec 01' ,`TaxAmount` = '16223' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '209172193' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:55:51.957' ,`MLSNumber` = '11010242' ,`ListAgentFullName` = 'Christopher Hardee Jr.' ,`ListOfficeName` = 'Hardee & Company Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.062926' ,`Longitude` = '-95.237493' ,`PhotoCount` = '29' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '357500.00' ,`Status` = 'Active' ,`StreetName` = 'Bishops Mill' ,`StreetNumber` = '21314' ,`StreetSuffix` = 'Court' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2904' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 21314 Bishops Mill Court .This beautiful home features 4/5 bedrooms, 2.5 baths on 2,904 square feet. Sitting on a beautiful 6,070 square foot lot. Located in the Kings Mill subdivision in beautiful Kingwood, Texas. With community parks, pool and Clubhouse. Call to schedule a private showing today!' ,`Acres` = '0.1393' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S642406 - KINGS MILL 06, BLOCK 2, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'KINGS MANOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORTER HIGH SCHOOL (NEW CANEY)' ,`SchoolMiddle` = 'WOODRIDGE FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Mill 06' ,`TaxAmount` = '8125' ,`TaxRate` = '3.1831' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700301' WHERE `Matrix_Unique_ID` = '210097537' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:28:33.727' ,`MLSNumber` = '45490053' ,`ListAgentFullName` = 'Bob Azzarello' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = 'Bob Azzarello' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.984495' ,`Longitude` = '-95.610153' ,`PhotoCount` = '33' ,`PostalCode` = '77070' ,`RoomCount` = '6' ,`ListPrice` = '474900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Laneview' ,`StreetNumber` = '12414' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning corner lot on a semi-secluded street in Lakewood Forest. Freshly landscaped and meticulously cared for, this home is ready for large gatherings. Generous primary bedroom down features an equally generous ensuite bath. Warm up and enjoy time in the family room near the gas fireplace, french doors lead out to the patio. Formal dining space with large wet bar is fantastic for hosting events. Kitchen boasts beautiful custom granite, tons of storage, 2 cooktops, and breakfast nook, and also features access to the covered patio and air-conditioned/ heated 3-car garage. Upstairs you will find 3 additional bedrooms, a game room with wet bar, and a theatre room ready to entertain.The backyard oasis has several gardening beds, a green house, and finally a beautifully maintained heated pool with water feature and spa. Pool is screened in to enjoy year-round. Area behind garage can be green space. Tankless water heater, newer roof. This was the owners\' dream home, now it can be yours.' ,`Acres` = '0.2204' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 24 LAKEWOOD FOREST SEC 11' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Forest' ,`TaxAmount` = '6726' ,`TaxRate` = '2.3988' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '210442629' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:01:36.723' ,`MLSNumber` = '73797896' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.840533' ,`Longitude` = '-95.861432' ,`PhotoCount` = '5' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '422990.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado Terrace' ,`StreetNumber` = '864' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1936' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Savannah plan. Ready this Fall! One-story cul-de-sac lot. Your Energy Star Qualified Home is cozy, yet functional offering four bedrooms, three baths, two-car garage and upgraded, extended covered patio. The island kitchen is complete with stainless steel appliances, granite countertops and 42-inch cabinets. Enjoy entertaining in the family room which opens to the dining area. The primary bedroom offers a luxurious bathroom with a garden tub and walk-in shower. The great room lets plenty of natural light shine through. Three secondary bedrooms and two baths complete your home. Fully sodded front and back yard. Sunterra is Katy, Texas’ newest community where “every day is a vacation!” Situated minutes from Interstate 10 & the Grand Parkway, Sunterra’s residents enjoy its many amenities such as the legendary Crystal Clear Lagoon & the Amenity Village. Schedule your appointment today to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Hamilton Thomas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S800008 SUNTERRA SECTION 8 BLK 1 LOT 70' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5839' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.62' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '211165465' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:01:09.487' ,`MLSNumber` = '78749689' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.840596' ,`Longitude` = '-95.861308' ,`PhotoCount` = '29' ,`PostalCode` = '77493' ,`RoomCount` = '13' ,`ListPrice` = '515990.00' ,`Status` = 'Active' ,`StreetName` = 'Coronado Terrace' ,`StreetNumber` = '868' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2797' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Daniella Rae plan. Fall completion date! Your Energy Star Qualified Home is situated on a large, cul-de-sac lot. It offers 4 bedrooms, 3 baths, 2-car garage & upgraded, extended covered patio. The island kitchen is complete with stainless steel appliances including a double oven & granite countertops. Enjoy entertaining in the family room which opens to the dining area. The primary bedroom offers a luxurious bathroom with a garden tub & walk-in shower. Create a room of your own with the first-floor flex room with a pocket office around the corner. Upstairs you’ll find two additional bedrooms, a full bathroom & spacious game room. Fully sodded front & back yard. Sunterra is Katy, Texas’ newest community where “every day is a vacation!” Situated minutes from Interstate 10 & the Grand Parkway, Sunterra’s residents enjoy its many amenities such as the legendary Crystal Clear Lagoon & the Amenity Village. Schedule your appointment today to learn more about Sunterra!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Hamilton Thomas' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNTERRA SECTION 8 BLK 1 LOT 70' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9325' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '1648' ,`TaxRate` = '3.5573' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '211168273' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:20:55.113' ,`MLSNumber` = '85075857' ,`ListAgentFullName` = 'Paige Houston' ,`ListOfficeName` = 'Texas Real Estate Pro' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.237875' ,`Longitude` = '-95.147620' ,`PhotoCount` = '30' ,`PostalCode` = '77372' ,`RoomCount` = '6' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Diamond T' ,`StreetNumber` = '26788' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1320' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedroom, 2 bath home located in the Holiday Oaks Community located on an oversized lot. Open concept living, dining, kitchen. Granite countertops in the kitchen. HUGE COVERED BACK PATIO and STOAGE SHED!' ,`Acres` = '0.303' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HOLIDAY OAKS 04, BLOCK 11, LOT 16, ACRES 0.300' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Holiday Oaks' ,`TaxAmount` = '3526' ,`TaxRate` = '2.0783' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '211262131' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T19:05:20.997' ,`MLSNumber` = '98136535' ,`ListAgentFullName` = 'Slava Say' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.102076' ,`Longitude` = '-94.143499' ,`PhotoCount` = '22' ,`PostalCode` = '77706' ,`RoomCount` = '5' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = '23rd' ,`StreetNumber` = '2225' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1618' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ready to show ... renovated house in sought after area of Beaumont without history of flooding looking for new owners to become their home. New floors, roof, bathrooms, light fixtures, fireplace and extra room which can be turned into a movie theatre, man cave or anything you desire. Brand new stainless steel appliances stay.' ,`Acres` = '0.2479' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK CLIFF 2 L10 S1/2 L9 B4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'REGINAL-HOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Cliff 2' ,`TaxAmount` = '2799' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '211531632' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T18:00:18.117' ,`MLSNumber` = '85474630' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Fruge Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.903637' ,`Longitude` = '-95.734044' ,`PhotoCount` = '6' ,`PostalCode` = '77433' ,`RoomCount` = '15' ,`ListPrice` = '616990.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Terrace' ,`StreetNumber` = '21115' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3062' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Hamilton Thomas Homes Harper plan. Fall completion! One-story situated on oversized lot in the exclusive gated section of Marvida. Home offers 4 bedrooms, 3 & 1/2 baths, 2-car garage & upgraded, extended covered patio. The island kitchen is complete w/stainless steel appliances, double ovens & granite countertops. Entertain in the family room which opens to the kitchen. 2nd patio off dining & private study located off family room. Primary bedroom offers a luxurious bathroom w/a garden tub & walk-in shower. Front & backyard sod included! Energy Star Qualified Home. Marvida is Cypress’ newest community where residents can have it all. As a sister community to Miramesa, Canyon Lakes West & Stone Gate, residents have access to their incredible amenities including Marvida’s own amenity village w/a lazy river pool. Marvida’s premier location will have you to major roadways quickly & is part of award-winning Cypress-Fairbanks ISD. Schedule your appointment today to learn more about Marvida!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Hamilton Thomas Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18, Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12370' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'ANDRE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '211531655' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T19:22:18.210' ,`MLSNumber` = '56124659' ,`ListAgentFullName` = 'Beverly Bradley' ,`ListOfficeName` = 'Weekley Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.447500' ,`Longitude` = '-95.396640' ,`PhotoCount` = '32' ,`PostalCode` = '77578' ,`RoomCount` = '7' ,`ListPrice` = '403323.00' ,`Status` = 'Active' ,`StreetName` = 'Morrison' ,`StreetNumber` = '5011' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1870' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Gladesdale lifestyle home plan strikes a pristine balance between innovative convenience and classic luxury. Craft your perfect home office, library, or family entertainment lounge in the cheerful study. The Epicurean kitchen features a presentation island and ample room for food storage and meal prep. Your open floor plan provides a sunlit expanse of enhanced livability and decorative possibilities. Each spare bedroom offers plenty of space for growing minds to shine. Your Owner’s Retreat presents a serene retreat from the world that includes a deluxe en suite bathroom and walk-in closet. Experience the benefits of our Brand Promise in this remarkable new home plan.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'David Weekley Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 23 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7975' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700302' WHERE `Matrix_Unique_ID` = '211571927' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T19:17:11.600' ,`MLSNumber` = '65506252' ,`ListAgentFullName` = 'Robert Moore' ,`ListOfficeName` = 'Perry Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444766' ,`Longitude` = '-95.398864' ,`PhotoCount` = '13' ,`PostalCode` = '77583' ,`RoomCount` = '9' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor Park' ,`StreetNumber` = '4614' ,`StreetSuffix` = 'Drive' ,`City` = 'Iowa Colony' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PERRY HOMES NEW CONSTRUCTION! Home office with French doors set at entry. Extended entry leads past formal dining room to open family room with corner wood mantel fireplace. Open kitchen features center island, 5-burner gas cooktop, two wall ovens and walk-in pantry. Guest suite with private bath off morning area. Primary suite includes bedroom with wall of windows. Dual vanities, corner garden tub, separate glass-enclosed shower and two walk-in closets in primary bath. High ceilings and walls of large windows add to this spacious four-bedroom design. Extended covered backyard patio. Mud room off three-car garage.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Meridiana Lot 19, Blk 1, Section 49' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14907' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '' ,`TaxRate` = '3.66' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700303' WHERE `Matrix_Unique_ID` = '211590520' --> Updated record success