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-07T22:16:00.750' ,`MLSNumber` = '40865768' ,`ListAgentFullName` = 'Zaira Maxwell' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776372' ,`Longitude` = '-94.933173' ,`PhotoCount` = '19' ,`PostalCode` = '77521' ,`RoomCount` = '10' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Park Shadow' ,`StreetNumber` = '4520' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2746' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifull corner lot, open living area with high ceilings that open to breakfast room- formal dining, master down, game room up-Plantation shutters in living room and master. Amazing landscape and best school district in Baytown. Near great shopping and entertainment. \r\nSelling as is.' ,`Acres` = '0.2336' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 2 PARKWOOD PLACE SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '10176' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'STEPHEN F. AUSTIN ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Parkwood Place Sec 02' ,`TaxAmount` = '7757' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708002' WHERE `Matrix_Unique_ID` = '206283755' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T23:48:59.297' ,`MLSNumber` = '96245069' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.660772' ,`Longitude` = '-95.754765' ,`PhotoCount` = '3' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '490350.00' ,`Status` = 'Active' ,`StreetName` = 'Virginia' ,`StreetNumber` = '8026' ,`StreetSuffix` = 'Drive' ,`City` = 'Richmond' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! Skip the theater and enjoy movie night at home from the comfort of the Kessler’s second-story game room. Downstairs, the primary suite boasts dual sinks and a large walk-in closet. A useful kitchen island overlooks the open living and dining rooms. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0187 Plan L454C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708002' WHERE `Matrix_Unique_ID` = '209241006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T23:49:29.123' ,`MLSNumber` = '29384026' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661768' ,`Longitude` = '-95.754956' ,`PhotoCount` = '4' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '515290.00' ,`Status` = 'Active' ,`StreetName` = 'Carbone' ,`StreetNumber` = '21515' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! The Cedar’s curved staircase is the centerpiece of this sprawling open-concept. Cook dinner in the kitchen without missing the conversation in the family room. Upstairs, the game room affords endless possibilities. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0167 Plan L412C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708002' WHERE `Matrix_Unique_ID` = '209241754' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T23:49:14.270' ,`MLSNumber` = '34371136' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.661687' ,`Longitude` = '-95.755208' ,`PhotoCount` = '3' ,`PostalCode` = '77406' ,`RoomCount` = '4' ,`ListPrice` = '388875.00' ,`Status` = 'Active' ,`StreetName` = 'Carbone' ,`StreetNumber` = '21523' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Access to Grand Parkway and the Westpark Tollway make it easy to get to work or play. A low tax rate and zoning to the prestigious Lamar Consolidated ISD bolster Creekside Farms’ appeal. Known for our energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving you thousands of dollars on your utility bills.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0165 Plan L401C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '725' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'ADOLPHUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.5' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663708002' WHERE `Matrix_Unique_ID` = '209241831' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T23:20:52.517' ,`MLSNumber` = '93926215' ,`ListAgentFullName` = 'Vickie Adams' ,`ListOfficeName` = 'TruStar Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.947027' ,`Longitude` = '-95.460913' ,`PhotoCount` = '19' ,`PostalCode` = '77067' ,`RoomCount` = '3' ,`ListPrice` = '229800.00' ,`Status` = 'Active' ,`StreetName` = 'Raven View' ,`StreetNumber` = '11315' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1398' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'First time home buyers here you go!! Must see this beautiful 3 BR/2 BA home. Near a few of the best shopping malls and great restaurants. House features a chefs dream kitchen, over size huge stainless steel gas stove, stainless steel refrigerator, Dishwasher, microwave. Large breakfast bar, granite. Spacious living area with a nice size brick wood burning fireplace. Freshly painted, lots of natural lighting. Split Floorplan. Fenced backyard with covered patio. Custom Rock fire pit, Very large storage shed. Move in ready, Must see. Call for private showing.' ,`Acres` = '0.1519' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 73 BLK 5 LINCOLN GREEN EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6615' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'CONLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DAVIS HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'PLUMMER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln Green East Sec 01' ,`TaxAmount` = '4096' ,`TaxRate` = '2.8128' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708002' WHERE `Matrix_Unique_ID` = '209493236' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T22:06:00.530' ,`MLSNumber` = '51933676' ,`ListAgentFullName` = 'Samantha Sloan' ,`ListOfficeName` = 'The Texas Living Real Estate G' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.167982' ,`Longitude` = '-95.189018' ,`PhotoCount` = '33' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '378000.00' ,`Status` = 'Active' ,`StreetName` = 'Sage Villa' ,`StreetNumber` = '23634' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolute stunner you don\'t want to miss! This gorgeous Perry in the highly desired section of Tavola right by the elementary school! This beauty grabs your heart the moment you enter the door! Beautiful wood tile floors greet you with warmth sophistication and carry you right into the center of the home. The island kitchen offers the most unique and stunning cabinetry you must see. Complimented by classy granite, ample storage, and stainless appliances, this is a chef\'s dream kitchen. Preferences for a home office, media room, or dining room? The huge flex space complete with double french doors can function as any of those things! The secluded Owner\'s Retreat is an absolute dream with a stunning ensuite that offers walk-through glass shower behind the garden tub. Perfectly sized secondary bedrooms, spacious laundry, mud area at garage entrance. Outdoors is a huge covered patio perfect for entertaining and future outdoor kitchen! Great location with quick access to 59/99!' ,`Acres` = '0.1762' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S921115 - TAVOLA 15, BLOCK 2, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7676' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola 15' ,`TaxAmount` = '9633' ,`TaxRate` = '3.3731' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708002' WHERE `Matrix_Unique_ID` = '210439334' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T22:29:21.830' ,`MLSNumber` = '93814554' ,`ListAgentFullName` = 'Debra Rademacher' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.986606' ,`Longitude` = '-95.194270' ,`PhotoCount` = '28' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Glen Crossing' ,`StreetNumber` = '12235' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2074' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this Clayton\'s Corner beauty before it\'s gone! Washer, dryer and refrigerator all stay! Downstairs has tile in kitchen and dining room, and laminate in the remainder of downstairs. Staircase and upstairs has been carpeted, but carpet was installed over the laminate, so you could easily remove the carpet if you wish. Home has a security system through Vivant, including thermostat & doorbell that can be remotely accessed through your phone. Home could use paint & a few minor repairs, but is priced accordingly, so no repairs will be done by seller. Most furnishings are for sale & negotiable. Home has never flooded!' ,`Acres` = '0.1121' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 CLAYTONS CORNER SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4883' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'TIMBERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Claytons Corner Sec 4' ,`TaxAmount` = '5659' ,`TaxRate` = '2.933' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708003' WHERE `Matrix_Unique_ID` = '211007858' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T22:18:57.870' ,`MLSNumber` = '48172324' ,`ListAgentFullName` = 'David Flory' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.744256' ,`Longitude` = '-95.601895' ,`PhotoCount` = '34' ,`PostalCode` = '77077' ,`RoomCount` = '8' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Rocky Knoll' ,`StreetNumber` = '12502' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate ONE-STORY, three bedroom, two bath home on a corner lot in the heart of the Energy Corridor. Spacious open floor plan, beautifully updated kitchen, and gorgeous floor-to-ceiling wall of windows throughout the home. A nature lover\'s dream, this striking home exudes peace and tranquility. Set up the enclosed flex room as a study or gym. The formal living room has a beautiful stone fireplace surrounded by custom built-ins. The primary suite has French doors, windows, a walk-in closet, a dual sink vanity, a jacuzzi tub, and a walk-in shower. This home features walk-in closets, hardwoods, tile, 2018 A/C, 2019 water heater, Low-E windows, insulated doors, and N/S exposure. Two-car garage with built-ins and workbench area. Ashford Hollow offers tennis courts, a swimming pool, and walking distance to Hersey Park. Close to City Centre and I-10 and Westheimer Rd, shopping, eateries, Memorial Tennis and Athletic Club, and much more.' ,`Acres` = '0.1811' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 37 BLK 2 ASHFORD HOLLOW SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '7890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASHFORD/SHADOWBRIAR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ashford Hollow' ,`TaxAmount` = '6840' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708003' WHERE `Matrix_Unique_ID` = '211465694' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-07T22:01:21.713' ,`MLSNumber` = '57756070' ,`ListAgentFullName` = 'Dora Gonzalez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.933133' ,`Longitude` = '-95.548305' ,`PhotoCount` = '42' ,`PostalCode` = '77422' ,`RoomCount` = '1' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy' ,`StreetNumber` = '6107' ,`StreetSuffix` = 'Lane' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '1379' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy living and fishing from the backyard of this recently renovated cottage on the San Bernard River. Great open floor concept with a loft that can be used for a sleeping area or a hang out area. Views of the San Bernard River can be seen from the kitchen, dining room and living room. Enjoy your morning coffee or evening beverage on this newly extended deck with string lighting and outdoor fans to help you keep cool. An 80 foot bulkhead has been installed very recently. The entire roof has also recently been installed. An entire HVAC system has been installed to keep you cool when you are relaxing and enjoying the view from indoors. Home has not flooded. Home comes furnished , all you need is your clothes! Call today to view in person.' ,`Acres` = '0.2863' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAS PLAYAS SEC II (A0002 T & W ALLEY) BLK 4 LOT 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '12471' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '51 - Sweeny' ,`SchoolElementary` = 'SWEENY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SWEENY HIGH SCHOOL' ,`SchoolMiddle` = 'SWEENY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Las Playas Sec II' ,`TaxAmount` = '3378' ,`TaxRate` = '2.0957' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663708003' WHERE `Matrix_Unique_ID` = '211697585' --> 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','212098726','1663708003','212098726','2022-09-07T22:21:41.420','64203523','Debbie McDonald','McDonald Realty','','','30.012962','-95.275669','30','77338','10','289900.00','Active','Upwood','9615','Drive','Humble','2','0','3','2147','Single-Family','Welcome home to a place of peace and comfort, quiet and great neighbors. Lots of space to just read a book or work on your favorite projects. Entertain your friends with a game of pool, in the game room. Owner shows pride, recent exterior paint, interior paint in the entry, family, dining, kitchen and breakfast rooms. Beautiful hardwood floors in entry, family and dining rooms. The garage is now a game room but can be changed back to a garage. Backyard includes covered patios, and lots of decking. Man cave/workshop, she shed, extra storage building plus generator. NEVER FLOODED PER OWNER. Nearby you have shopping, hospitals, restaurants and movie theaters. Bush airport, Hwy 59/69, Hardy toll road and Hwy 45 only minutes away. Elementary school is in walking distance. All I have left to say is Welcome home.','0.1928','12','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Estate,Sellers Disclosure','1','Gaslog Fireplace','1','Humble Area West','Central Gas,Window Unit','1','LT 30 BLK 6 NORTHSHIRE SEC 2','Cleared,Subdivision Lot','8400','Appraisal District','','550','0','','0','Double Oven,Electric Oven','0','','','Electric Cooktop','','Composition','29 - Humble','HUMBLE ELEMENTARY SCHOOL','HUMBLE HIGH SCHOOL','ROSS STERLING MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Seller','1','Traditional','Northshire Sec 02','4251','2.2965','Public Sewer,Public Water','1977','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','212197319','1663708003','212197319','2022-09-07T22:38:00.247','10856309','Aishat Trevino','C.R.Realty','','','30.737511','-95.016926','26','77351','3','199000.00','Active','Del Rio','185','Avenue','Livingston','2','0','3','1392','Single-Family','Beautiful remodeled 3 bedroom 2 bath home located in a quiet neighborhood minutes from lake Livingston. This property also includes a spacious laundry room along with a washer and dryer with lots of storage. Home has brand new luxury vinyl flooring, new interior and exterior paint with brand new fans, fixtures, and faucets. Home also has a detached carport along with a storage shed for fishing poles and water toys. Close to shopping, restaurants, Naskila Casino, Tripple J Bowling, and a nearby hospital.','0.2187','44','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Lake Livingston Area','Central Electric','0','WIGGINS RIDGE LOT 95','Other','9525','Appraisal District','','','0','','','Electric Oven','0','','','Electric Cooktop','','Composition','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Lockbox Front','Appraisal District','1','Other Style','Wiggins Ridge','2263','1.8745','Public Water,Septic Tank','2007','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','212211163','1663708003','212211163','2022-09-07T23:12:01.810','81879737','TJ McGriff','JLA Realty','','','29.905821','-95.313819','1','77039','3','174999.00','Active','Charriton','5210','Drive','Houston','1','1','3','1550','Single-Family','','','34','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Probate,Sellers Disclosure,Tenant Occupied','','','','Aldine Area','Central Electric,Central Gas','0','LT 24 BLK 5 FAIRGREEN SEC 1 R/P','Subdivision Lot','7015','Appraisal District','','','0','','0','','1','In Ground','','Gas Cooktop','','Composition','1 - Aldine','OLESON ELEMENTARY SCHOOL','MACARTHUR HIGH SCHOOL (ALDINE)','MEAD MIDDLE SCHOOL','Appointment Required,Supra Keybox,Temporarily No Showings','Appraisal District','1','Traditional','FAIRGREEN','','','Public Sewer,Public Water','1966','Appraisal District'); --> New record created successfully