Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:52:56.100' ,`MLSNumber` = '67327799' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.029809' ,`Longitude` = '-95.377385' ,`PhotoCount` = '26' ,`PostalCode` = '77338' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Donata' ,`StreetNumber` = '21511' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1064' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 87 BLK 3 WERRINGTON SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4636' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'OGDEN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'TEAGUE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Werrington Sec 01' ,`TaxAmount` = '5859' ,`TaxRate` = '2.9808' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708506' WHERE `Matrix_Unique_ID` = '206390029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:13:27.330' ,`MLSNumber` = '79126007' ,`ListAgentFullName` = 'Veronica Sanchez' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.341320' ,`Longitude` = '-95.085489' ,`PhotoCount` = '15' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '173777.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5701' ,`StreetNumber` = '1175' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1248' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICE REDUCTION! Beautiful, cozy spacious home with wide plank wood laminate floors on a 1/4 acre corner lot ready for your imagination and creative designs. Community has splash pad & community center, new elementary opened in 2020 & middle school under construction. Police substation & direct access to 99. Growing area - Come see! Great starter home with country living! SELLER IS MOTIVATED!!!!!' ,`Acres` = '0.41' ,`Area` = '52' ,`BuilderName` = 'Clayton Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 7, BLOCK 102, LOT 5547, ACRES .41' ,`LotDesciption` = 'Other' ,`LotSize` = '17860' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Santa Fe Sec 7' ,`TaxAmount` = '1065' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663708506' WHERE `Matrix_Unique_ID` = '207387395' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:52:25.120' ,`MLSNumber` = '6372686' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990258' ,`Longitude` = '-95.436217' ,`PhotoCount` = '28' ,`PostalCode` = '77090' ,`RoomCount` = '5' ,`ListPrice` = '244900.00' ,`Status` = 'Active' ,`StreetName` = 'Sun Prairie' ,`StreetNumber` = '810' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1483' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1157' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 41 BLK 2 DARBYDALE CROSSING SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Darbydale Xing Sec 1' ,`TaxAmount` = '4182' ,`TaxRate` = '2.5867' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708506' WHERE `Matrix_Unique_ID` = '208855209' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:54:30.277' ,`MLSNumber` = '64919377' ,`ListAgentFullName` = 'Tracie Opryshek-Fortenberry' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = 'Brock Sanchez' ,`SellingOfficeName` = 'Realty Associates' ,`Latitude` = '29.500114' ,`Longitude` = '-94.943477' ,`PhotoCount` = '29' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '189900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rue De Lafitte' ,`StreetNumber` = '2440' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax and enjoy the sea breezes off of your front porch/deck in this beautiful home a few blocks from the bay. The home boasts three bedrooms, two baths, an open floor plan with lots of updates--carpet, vinyl plank flooring, double pane windows, blinds, gutters, concrete deck around house, siding and insulation on bottom of home, wood fencing and automatic gate, gas generator hardwired to electric with 50 gallon gas storage, garbage disposal, painted outside of home, ceiling fan in in kitchen and much more. Entertain in the spacious kitchen with a huge island and lots of cabinets. The large master bedroom has a master bath with double sinks and a separate shower and tub. The living room has a wood burning fireplace and opens to the dining room.' ,`Acres` = '0.225' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR LOT 17 CAPTAINS RETREAT SEC 3 UNRECORD' ,`LotDesciption` = 'Other' ,`LotSize` = '9800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Captains Retreat Sec 3 Unrec' ,`TaxAmount` = '2515' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708506' WHERE `Matrix_Unique_ID` = '209550654' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:14:41.460' ,`MLSNumber` = '38823708' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886021' ,`Longitude` = '-95.054589' ,`PhotoCount` = '5' ,`PostalCode` = '77532' ,`RoomCount` = '9' ,`ListPrice` = '282990.00' ,`Status` = 'Active' ,`StreetName` = 'Giant Panda Bear' ,`StreetNumber` = '13707' ,`StreetSuffix` = 'Avenue' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank in Wet Areas and Extended Entry, Quartz Kitchen Countertops with Island, Patterned Tile Backsplash, Stainless Steel Appliances, 42” Birch Upper Kitchen Cabinets, Recessed Can Lights, Covered Patio, Front Yard Irrigation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE OCTOBER/NOVEMBER.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 6 BLK 4 SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5864' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '403' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708506' WHERE `Matrix_Unique_ID` = '209661338' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:15:56.057' ,`MLSNumber` = '60352987' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886379' ,`Longitude` = '-95.055287' ,`PhotoCount` = '5' ,`PostalCode` = '77532' ,`RoomCount` = '11' ,`ListPrice` = '307990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaskan Brown Bear' ,`StreetNumber` = '13622' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1975' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Formal Dining Room, Study with French Doors, Game Room, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank Flooring in all Rooms but Bedrooms, Granite Countertops in Kitchen with Island, Mosaic Backsplash, 42\" White Kitchen Cabinets, Stainless Steel Appliances, Upgraded Lighting Package, Ceiling Fans, Covered Patio, Upgraded Front Door, Sprinklers in Front Yard, Full Gutters, Stone Accented Elevation, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE NOVEMBER.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 21 BLK 4 SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '403' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708506' WHERE `Matrix_Unique_ID` = '209661702' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T06:28:45.267' ,`MLSNumber` = '81716467' ,`ListAgentFullName` = 'Charles Whittle' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.334451' ,`Longitude` = '-95.469692' ,`PhotoCount` = '17' ,`PostalCode` = '77301' ,`RoomCount` = '10' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Windswept' ,`StreetNumber` = '908' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1826' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly remodeled 4 bedroom 2 bath home centrally located inside Loop 336. House has been remodeled and updated. The kitchen has been completely redone with new cabinets and new stainless steel appliances. The kitchen also features a quarts counter top with lots of room to pull up stools. Corner lot with a very spacious back yard with mature trees for shade and an irrigation system to water it all.' ,`Acres` = '0.2257' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S864000 - SHADOW HILLS, LOT 9' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9830' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'REAVES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Hills' ,`TaxAmount` = '3323' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '210062274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T06:46:38.660' ,`MLSNumber` = '10271657' ,`ListAgentFullName` = 'Victor Chelf' ,`ListOfficeName` = 'Coldwell Banker Realty, Cy-Fair Office' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.866811' ,`Longitude` = '-95.642252' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '13' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Baxter' ,`StreetNumber` = '15426' ,`StreetSuffix` = 'Avenue' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2481' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Smart home, minutes from exemplary Cy-Fair ISD schools, fully renovated in 2021-2022 from the roof to fence and everything in between including: new premium a/c unit and ducts, texture/paint (inside and out), granite countertops, custom built ins with accent lighting, seamless gutters, custom solar screens and blinds, breathtaking tile work with herringbone subway tile backsplash and limestone fireplace surround, Luxurious bathrooms with waterfall faucets, quiet water saver/multifunction toilets, spa shower heads, and large soaking tub. This smart home boasts an owned security system, led lighting throughout, premium stainless steel/ Energy Star appliances such as chef basin sink and a stove featuring griddle burner and oven that doubles as an air fryer! This home misses no details in modernization and convenience and has too many upgrades and items renovated to list!' ,`Acres` = '0.1435' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Eldridge North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 18 BLK 1 LANGHAM CREEK COLONY 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HORNE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'TRUITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Langham Creek Colony 02 Prcl R' ,`TaxAmount` = '5682' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '210065690' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T06:41:23.790' ,`MLSNumber` = '90361947' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669025' ,`Longitude` = '-95.339334' ,`PhotoCount` = '14' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '209000.00' ,`Status` = 'Active' ,`StreetName` = 'Northridge' ,`StreetNumber` = '5607' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1334' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPdated house!! Updated kitchen!! Updated bathrooms!!!\r\nUpdates include kitchen cabinets, granite counter, laminate vinyl planks, carpet, interior and exterior paint, lights, spotlights, baseboards, doors, and many more. AC AND HEATING WAS UPDATED!!!!!!!!\r\nSeller shall install oven and dishwasher.' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 20 BLK 6 EDGEWOOD SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALCOTT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Edgewood' ,`TaxAmount` = '1240' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '210209237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:15:21.893' ,`MLSNumber` = '57430376' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885830' ,`Longitude` = '-95.055110' ,`PhotoCount` = '6' ,`PostalCode` = '77532' ,`RoomCount` = '10' ,`ListPrice` = '303990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaskan Brown Bear' ,`StreetNumber` = '13719' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1873' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1 Story, 3 Bedroom, 2 Bath, Study, Separate Garden Tub and Shower in Primary Bath, Luxury Vinyl Plank Flooring in Living Areas, Granite Kitchen Countertops with Island, Mosaic Backsplash, 42\" Upper Kitchen Cabinets, Stainless Steel Appliances, Recessed Can Lights, Upgraded Lighting Package, Ceiling Fans, Covered Patio, Stone Accented Elevation, Upgraded Front Door, Sprinkler System, Full Sod, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE DECEMBER/JANUARY.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 12 BLK 3 SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '403' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '211081839' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:17:04.307' ,`MLSNumber` = '76808865' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.886159' ,`Longitude` = '-95.055196' ,`PhotoCount` = '5' ,`PostalCode` = '77532' ,`RoomCount` = '14' ,`ListPrice` = '350990.00' ,`Status` = 'Active' ,`StreetName` = 'Alaskan Brown Bear' ,`StreetNumber` = '13603' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Corner Homesite! 2 Story, 5 Bedroom, 2 1/2 Bath, Formal Dining, Bonus Room Up, Game Room Up, Primary Suite Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank Flooring in Wet Areas and Dining, Granite Kitchen Countertops with Island, Tile Backsplash, 42\" Upper Kitchen Cabinets, Recessed Can Lights, Staircase with Wrought Iron Spindles, Upgraded Stainless Steel Appliances, Covered Patio, Stone Accented Elevation, Full Front Gutters, Dual Zone A/C, Tech Shield Radiant Barrier, Environments for Living Home, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 3 SEC 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6720' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '403' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '211082019' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:16:33.357' ,`MLSNumber` = '87719205' ,`ListAgentFullName` = 'Joe Rothchild' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.884873' ,`Longitude` = '-95.059322' ,`PhotoCount` = '5' ,`PostalCode` = '77532' ,`RoomCount` = '12' ,`ListPrice` = '340990.00' ,`Status` = 'Active' ,`StreetName` = 'Polar Bear' ,`StreetNumber` = '434' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2453' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Story, 4 Bedroom, 3 1/2 Bath, Dining Room, Game Room Up, Primary Suite Down, Dual Vanities in Primary Bath, Separate Garden Tub and Shower, Luxury Vinyl Plank Flooring Downstairs, Granite Kitchen Countertops with Island, Mosaic Accented Tile Backsplash, 42\" Kitchen Cabinets, Stainless Steel Appliances, Upgraded Lighting Package, Wrought Iron Spindles, Ceiling Fans, Covered Patio, Sprinkler System, Tech Shield Radiant Barrier, Dual Zone A/C, Environments for Living Home, No Back Neighbors, plus more…AVAILABLE JANUARY/FEBRUARY.' ,`Acres` = '' ,`Area` = '1' ,`BuilderName` = 'Devon Street Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 30 BLK 2 SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5771' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '403' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'DREW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kodiak Crossing' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '211082201' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:47:33.403' ,`MLSNumber` = '23759696' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.638436' ,`Longitude` = '-95.517060' ,`PhotoCount` = '6' ,`PostalCode` = '77071' ,`RoomCount` = '6' ,`ListPrice` = '180000.00' ,`Status` = 'Active' ,`StreetName` = 'Antone' ,`StreetNumber` = '15311' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The home needs finishing touches but it has \"good bones\". There is a lot of potential and upside with this property. This property is getting sold as-is. Close access to shopping and freeways.' ,`Acres` = '0.2534' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 128 BLK 9 FONDREN PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11036' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GROSS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'WELCH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Fondren Park Sec 05' ,`TaxAmount` = '4234' ,`TaxRate` = '2.7379' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708507' WHERE `Matrix_Unique_ID` = '211299029' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:40:44.173' ,`MLSNumber` = '21520182' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Matthew Freeman' ,`SellingOfficeName` = 'CENTURY 21 Western Realty' ,`Latitude` = '29.901596' ,`Longitude` = '-95.735085' ,`PhotoCount` = '14' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '549999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Melshell Drive' ,`StreetNumber` = '21139' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3179' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'AVAILABLE TO CONTRACT ON TODAY!! Modern Finishes and Open Concept Living in this 3179 sq.ft. 2 story home! Huge 2 story windows flank the wrap around staircase 2 story foyer will WOW you. 1st floor offers Guest Suite Down + Study w/closet, Dining, 2 Story Family, Kitchen, Bkfst, and the Primary Retreat! Upstairs you will find 2 Beds, Full Bath w/ 2 sinks, and Gameroom overlooking the family below! Modern features include 42\" Shaker Cabinets,Quartz Countertops, Decorative Tile Backsplash to Ceiling , 5 Burner Gas Cook-top w/ SS Built-In Oven, 7\" Vinyl Wood Plank, Modern Horizontal Iron Railing, 4x12 Subway Tile Surrounds to Ceiling in Bathrooms, Framelss Shower w/ tile floor,Smart Home, Deako Smart Switches, 1st Floor 8\' Doors w/ 5\" Baseboards, Full Sprinkler, GDO, Tankless Water Heater, LED Lighting, Covered Patio! \r\nMARVIDA will offer over 6.3 acres of FUN IN THE SUN! Cypress,Tx Newest Master Planned Community!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 2 MARVIDA SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '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` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marvida' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708508' WHERE `Matrix_Unique_ID` = '211625078' --> 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','211963938','1663708508','211963938','2022-09-09T07:53:27.753','33871908','Roxanna Gross','RE/MAX Signature','','','30.408998','-95.571350','25','77318','12','385000.00','Active','Edgewater','7174','Drive','Willis','3','0','4','3342','Single-Family','Rare find! HUGE LOT! Two large fenced lots (over 1/2 acre) with oversized 4 car garage w/workshop area and parking area for your recreational toys or additional vehicles. This home offers a 908 square foot guest quarters w/living room, bedroom & full bath! The main home offers 3 bedrooms, 2 full baths, game room, formal dining, breakfast area & large family room with fireplace. The kitchen has stainless appliances and tile flooring. The downstairs primary bedroom offers laminate flooring and ensuite bath with a dual vanity, jetted tub, separate walk-in shower and his/her closets. There is a great storage area between the large downstairs game room and garage. There is an office inside the garage with entry into the guest quarters. This property has so much potential and even has room for a pool. The waterfront community offers marina, pool, basketball and tennis courts, fishing pier, club house and boat launch.','0.5439','39','','','','','Owner/Agent','1','','','Lake Conroe Area','Central Gas','1','SEVEN COVES 01, BLOCK 5, LOT 45,46','Subdivision Lot','23691','Appraisal District','','1000','0','','4','','0','','','','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Lockbox Front,Supra Keybox','Appraisal District','2','Ranch,Traditional','Seven Coves 01','8088','2.3198','Public Sewer,Public Water','1990','Appraisal District'); --> New record created successfully
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-09T07:32:07.130' ,`MLSNumber` = '19394971' ,`ListAgentFullName` = 'Jovany Trujillo' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.818918' ,`Longitude` = '-95.437552' ,`PhotoCount` = '36' ,`PostalCode` = '77018' ,`RoomCount` = '11' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Bidwell' ,`StreetNumber` = '2123' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2112' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location Location !!!! easy access to 610, I45 and I10. Fully updated home featuring 3 bedrooms with 3 Private Bathrooms and a additional 1/2 bathroom. Home also features a open floor plan in the living, kitchen and dinning area!!! Hurry!! Hurry!!! before this home is gone!!!!' ,`Acres` = '0.0375' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 FISHER ESTATES AT OAK FOREST' ,`LotDesciption` = 'Other,Patio Lot' ,`LotSize` = '1632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'OAK FOREST ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Fisher Ests/Oak Forest' ,`TaxAmount` = '5244' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708508' WHERE `Matrix_Unique_ID` = '211980479' --> 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','212131401','1663708508','212131401','2022-09-09T07:55:11.070','82125834','Kathryn Anderson','BHGRE Gary Greene','','','29.571406','-95.543295','32','77459','9','397000.00','Active','Robinson','3223','Road','Missouri City','2','1','4','3022','Single-Family','Have you always wanted to live on \"Candy Cane Lane\" aka Robinson Road in Quail Valley? Original owner is downsizing, so come with all of your decorating ideas to customize to your taste. Located on Hole #3 of the La Quinta Golf Course, wake up to this view everyday. Kitchen has stainless steel appliances and solid surface counters. The laundry room was expanded to make it a home office and includes a built in desk overlooking backyard and golf course. Large Primary bedroom is downstairs with en suite bathroom with double closet and 2 separate vanities. \r\nUpstairs are 3 more really good size bedrooms with XL Jack and Jill bathroom. Other features include insulated windows, HVAC approx 3 years old, roof approx 10 years (per seller). Gorgeous cultivated Pecan Tree in backyard produces huge pecans (see evidence at the photos) Close to shopping and major thoroughfares including HW 90A for easy commute into Medical Center. Come see why we all love living in Quail Valley.','0.2856','38','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Missouri City Area','Central Gas','1','QUAIL VALLEY THUNDERBIRD SEC 1, BLOCK 23, LOT 37','In Golf Course Community,On Golf Course','12441','Appraisal District','','439','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','19 - Fort Bend','QUAIL VALLEY ELEMENTARY SCHOOL','ELKINS HIGH SCHOOL','QUAIL VALLEY MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Quail Valley Thunderbird Sec 1','7114','2.34','Public Sewer,Public Water,Water District','1976','Appraisal District'); --> New record created successfully
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','212225258','1663708508','212225258','2022-09-09T07:16:02.687','46943486','Brianne Clark','HomeSmart','','','29.383811','-94.948240','19','77590','3','165000.00','Active','Texas','3434','Avenue','Texas City','1','0','3','838','Single-Family','For Sell or Rent! Fully Renovated adorable home. This plan features an open floor plan with three bedrooms and one full bath. Very large partially fenced yard, and easy access to hwy 146. Only a 20 minute drive to the heart of Galveston.','0.1481','33','','','','','No Disclosures,Sellers Disclosure','1','','','Texas City','Wall Heater','0','ABST 63 PAGE 5 LOT 16 BLK 148 KOHFELDT 2ND ADDN','Other','6450','Appraisal District','','','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Cooktop,Electric Range,Freestanding Range','','Composition','52 - Texas City','HAYLEY ELEMENTARY SCHOOL','LA MARQUE HIGH SCHOOL (TEXAS CITY)','LA MARQUE MIDDLE SCHOOL (TEXAS CITY)','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Craftsman,Traditional','Kohfeldt 2nd','3117','2.5335','Public Sewer,Public Water','1967','Appraisal District'); --> New record created successfully
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','212330361','1663708508','212330361','2022-09-09T07:51:44.483','61026683','Charles Schrader','Coldwell Banker Realty','','','29.807455','-95.047289','21','77562','9','468000.00','Active','Jones','716','Road','Highlands','2','0','4','1884','Single-Family','Beautifully remodeled 4 bedroom ,2 Bathroom, and 2 Living Room home located in Highlands. Recent updates include a Roof in 2018, new carpet, new laminate flooring, whole kitchen remodel, custom trim, updated electrical, new appliances, and much more. Also a huge 40x40 shop was built in 2021. In the amazing pasture you will find a barn equipped to hold 4H / FFA Animals complete with concrete pads, wash bins, custom pens, and it is covered. This charming property is un restricted and has endless possibilities to suit your needs. Sit back and enjoy the sunsets while watching either the kids play, your family gatherings, or the chickens run.','2.5','2','','','','','Mud,Sellers Disclosure','1','','','Baytown/Harris County','Window Unit','0','E 1/2 OF LT 19 BLK 9 HIGHLAND FARMS','Cleared','108900','Appraisal District','','','0','','8','Freestanding Oven,Gas Oven','0','','','','','Composition','23 - Goose Creek Consolidated','HOPPER/HIGHLANDS ELEMENTARY SCHOOL','GOOSE CREEK MEMORIAL','HIGHLANDS JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','1','Traditional','Highland Farms','4427','2.235','Public Sewer,Public Water,Water District','1938','Appraisal District'); --> New record created successfully