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-12-20T16:32:34.693' ,`MLSNumber` = '43252084' ,`ListAgentFullName` = 'Jessica Tant' ,`ListOfficeName` = 'Fowler Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.906307' ,`Longitude` = '-94.419756' ,`PhotoCount` = '30' ,`PostalCode` = '75938' ,`RoomCount` = '4' ,`ListPrice` = '90000.00' ,`Status` = 'Active' ,`StreetName` = 'Pitzer' ,`StreetNumber` = '102' ,`StreetSuffix` = '' ,`City` = 'Colmesneil' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s your opportunity to own a piece of Colmesneil history with this home built in 1886. Once you step through the fence onto this property, you\'re surrounded by a vast amount of greenery and landscaping that creates a level of privacy that can certainly be appreciated. Inside you\'re welcomed by the high ceilings and original wood that takes you back in time to the days when the property once served as the town\'s general store. The wrap around porch is perfect for relaxing and enjoying the outdoor scenery, including evergreen wisteria, a star jasmine trellis walkway and a producing peach tree. The home has had electrical upgrades to code, pex pipe plumbing and a metal roof was installed in 2010. Centrally located next to the W.T. Colmesneil House Museum & Library and right down the street from Lake Tejas, the best little swimming hole in East Texas!' ,`Acres` = '0.257' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'S5162 TOWNSHIP OF COLMESNEIL, BLK 3, LOT 8,9, 10 N/2, ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '11195' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Township Of Colmesneil' ,`TaxAmount` = '534' ,`TaxRate` = '2.0383' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1886' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675093588' WHERE `Matrix_Unique_ID` = '209584595' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T15:59:57.730' ,`MLSNumber` = '56385447' ,`ListAgentFullName` = 'Shari McElroy' ,`ListOfficeName` = 'AVOREC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.092250' ,`Longitude` = '-94.105213' ,`PhotoCount` = '6' ,`PostalCode` = '77701' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Miller' ,`StreetNumber` = '1045' ,`StreetSuffix` = 'Street' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1871' ,`Area` = '51' ,`BuilderName` = 'Destin Developments' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 STEPHENSON NO 1 .1871AC' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (BEAUMONT)' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Stephenson Add #1' ,`TaxAmount` = '99' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093588' WHERE `Matrix_Unique_ID` = '210417057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T15:55:39.120' ,`MLSNumber` = '72221540' ,`ListAgentFullName` = 'Priscilla Raji' ,`ListOfficeName` = 'Summit Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.582026' ,`Longitude` = '-95.529453' ,`PhotoCount` = '40' ,`PostalCode` = '77489' ,`RoomCount` = '8' ,`ListPrice` = '368500.00' ,`Status` = 'Active' ,`StreetName` = 'Avocet' ,`StreetNumber` = '1830' ,`StreetSuffix` = 'Way' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2606' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4 bedrooms, 3 full baths, lovely entrance with spacious kitchen with stainless steel appliances, lots of cabinet space 42\", primary bath, with double sinks, separate shower big family room, game room up, walk-in-closet your family will enjoy the backyard out door dinning.' ,`Acres` = '0.1188' ,`Area` = '38' ,`BuilderName` = 'CENTEX HOMES' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MUSTANG TRAILS SEC 1A, BLOCK 1, LOT 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '625' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LANTERN LANE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mustang Trails Sec 1a' ,`TaxAmount` = '7846' ,`TaxRate` = '3.1174' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093588' WHERE `Matrix_Unique_ID` = '214155607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-20T16:04:19.987' ,`MLSNumber` = '44362755' ,`ListAgentFullName` = 'Erica Nava' ,`ListOfficeName` = 'JEA Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.931345' ,`Longitude` = '-95.334152' ,`PhotoCount` = '46' ,`PostalCode` = '75862' ,`RoomCount` = '9' ,`ListPrice` = '432000.00' ,`Status` = 'Active' ,`StreetName` = 'Candlestick' ,`StreetNumber` = '42' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2 story, 3 Bedroom, 3 Bath #LakeLife at its best w/ breathtaking views of the lake. Equipped w/ modern finishes & design, open floor plan, vinyl plank, lots of windows throughout the home bringing in natural light & the most spectacular views & sunsets. An impressive gourmet kitchen adorned w/ double oven, beautiful crafted cabinetry & oversized island w/ breakfast bar, area that flows into the dining area w/ floor to ceiling windows, & into the oversized Great Room that opens out to a beautiful extensive covered outdoor living deck area w/ double sided fireplace. All bedrooms offer substantial space & the Notable primary suite holds breathtaking views and provides a luxurious oversized shower and separate soaking tub. This prestigious gated community checks all the boxes, a beautiful 18-hole golf course, 9 interior lakes for fishing, Country Club w/ pro shop, Bar & Grill, putting greens, wildlife, tennis & pickle ball courts, RV park, marina village resort, & boat storage.' ,`Acres` = '0.1925' ,`Area` = '42' ,`BuilderName` = 'RAA Innovations' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 04, BLOCK 70 LOT 13' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '8385' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2508' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Westwood Shores Sec 4' ,`TaxAmount` = '68' ,`TaxRate` = '2.4708' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675093588' WHERE `Matrix_Unique_ID` = '214840415' --> 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','215012474','1675093588','215012474','2022-12-20T15:06:08.170','55294054','Thomas Mathew','Reliable, REALTORS','','','29.610785','-95.554252','23','77477','6','239000.00','Active','Live Oak','519','Drive','Stafford','2','0','3','1452','Single-Family','excellent home. new vinyl flooring . no carpet in the house.. renovated bath room ni nabors in the back yard . easy access to alt90 59 and hwy 6 with in 20 min from TEXAS MRDICAL CENTER','0.1708','38','','','','','Sellers Disclosure','','','1','Stafford Area','Central Gas','1','R/P DOVE COUNTRY, BLOCK 1, LOT 5','Subdivision Lot','7440','Appraisal District','','156','0','','2','','0','','','','','Composition','50 - Stafford','STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)','STAFFORD HIGH SCHOOL','STAFFORD INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Contemporary/Modern','Dove Country R/P','3880','1.9342','Public Sewer,Public Water,Water District','1981','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','215029984','1675093589','215029984','2022-12-20T15:14:24.453','24282254','Cody Thomas','eXp Realty, LLC','','','29.918257','-93.914846','14','77642','4','164900.00','Active','Green','1933','Avenue','Port Arthur','1','0','3','1344','Single-Family','Welcome to your cozy 3 bed, 1 bath home in the heart of the beloved City of Port Arthur. This home has all new electrical, plumbing and features fresh paint and fixtures throughout. Detached 2 car garage. Beautiful front landscaping. Large backyard for your weekend BBQ get-togethers. Please contact the listing agent for more information and questions.','0.1791','51','','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','','Central Gas','0','RHODES LT 7','Subdivision Lot','7800','Appraisal District','','','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Cooktop','','Composition','236 - Port Arthur','TYRRELL ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (PORT ARTHUR)','JEFFERSON MIDDLE SCHOOL (PORT ARTHUR)','Leave Business Card,Lockbox Front,No Appointment Required,Request Online Appointment,Vacant/Unoccupied','Appraisal District','1','Traditional','Rhodes','2200','3.176','Public Sewer,Public Water','1962','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','215256094','1675093589','215256094','2022-12-20T16:15:42.953','97325630','Sammy Younis','RE/MAX Southwest','','','29.789524','-95.399925','4','77008','7','999800.00','Active','10th 1/2','207','Street','Houston','3','1','3','2674','Single-Family','Sleek, modern, farmhouse-style townhomes in the heart of Houston Heights. Technology meets luxury with high-end features throughout, including \"smart home features\' and an oversized 4th-floor rooftop deck - perfect for entertaining! Modern finishes throughout the home are complimented with beautiful wood floors, matte black accents, and plenty of natural light. Stunning island kitchen with floor-to-ceiling cabinets, quartz countertops, and a walk-in pantry. Large family room with private balcony and electric fireplace. Elegant formal dining space. Luxurious primary suite with spa-like master bath featuring a steam shower and massive walk-in closet! Secondary bedrooms are a generous size with large closets. Elevator ready! Amazing location - located close to everything! The fourth-floor deck is engineered to carry a hot tub. Optional elevator, driveway gates, outside ceiling fans, mosquito system.','','9','Skyline','','','','No Disclosures','1','Gaslog Fireplace','1','Heights/Greater Heights','Central Gas','0','BLK 215 HOUSTON HEIGHTS','Cleared','2139','Other','','0','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Cooktop','','Aluminum,Composition','27 - Houston','HARVARD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','3','Contemporary/Modern','Houston Heights','','2.3307','Public Sewer,Public Water','2023','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','215256312','1675093589','215256312','2022-12-20T16:15:26.353','40562810','Sammy Younis','RE/MAX Southwest','','','29.789524','-95.399925','4','77008','7','999800.00','Active','10th 1/2','209','Street','Houston','3','1','3','2674','Single-Family','Sleek, modern, farmhouse-style townhomes in the heart of Houston Heights. Technology meets luxury with high-end features throughout, including \"smart home features\' and an oversized 4th-floor rooftop deck - perfect for entertaining! Modern finishes throughout the home are complimented with beautiful wood floors, matte black accents, and plenty of natural light. Stunning island kitchen with floor-to-ceiling cabinets, quartz countertops, and a walk-in pantry. Large family room with private balcony and electric fireplace. Elegant formal dining space. Luxurious primary suite with spa-like master bath featuring a steam shower and massive walk-in closet! Secondary bedrooms are a generous size with large closets. Elevator ready! Amazing location! Designed by renowned architects Sullivan, Henry, Oggero & Assoc! The fourth-floor deck is engineered to carry a hot tub. Optional elevator, driveway gates, outside ceiling fans, mosquito system.','','9','Skyline','','','','No Disclosures','1','Gaslog Fireplace','1','Heights/Greater Heights','Central Gas','0','BLK 215 HOUSTON HEIGHTS','Cleared','2139','Other','','','1','To Be Built/Under Construction','2','Convection Oven','0','','','Gas Cooktop','','Aluminum','27 - Houston','HARVARD ELEMENTARY SCHOOL','HEIGHTS HIGH SCHOOL','HOGG MIDDLE SCHOOL (HOUSTON)','Appointment Required','Builder','3','Contemporary/Modern','Houston Heights','','2.3307','Public Sewer,Public Water','2023','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','215289160','1675093589','215289160','2022-12-20T15:47:23.240','33141431','Roman Rodriguez','Green Residential','','','29.809207','-95.136299','29','77049','5','275000.00','Active','Mandate','16506','Drive','Houston','2','1','3','2080','Single-Family','Charming two story, 3 bed, 2 bath home located in Northeast Houston. This home is spacious and has great natural lighting. The living area has wood like ceramic flooring throughout living space. Home features large, open concept living area and kitchen. Wonderful galley kitchen has plenty of cabinet and counter space for your cooking needs. All bedrooms are upstairs and each are well sized. Primary bedroom is very spacious and has en-suite primary bathroom. Primary bathroom has soaking tub, stand in shower, and walk-in closet. As you land on the 2nd floor, there is a well sized game room/loft overlooking the foyer. Fully fenced back yard with patio is perfect for entertaining. Great for primary residence or an investment property. *Home is tenant occupied with a lease until April 30th, 2023. Rent is $1,600. There will be no showings until an executed contract is received. Once there is an executed contract, buyer will be allowed to view and schedule necessary inspections on the home.*','','2','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure,Tenant Occupied','1','','','North Channel','Central Gas','1','LT 68 BLK 1 RANCHO VERDE SEC 5','Subdivision Lot','4400','Appraisal District','','450','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','8 - Channelview','Brown Elementary School (Channelview)','CHANNELVIEW HIGH SCHOOL','AGUIRRE JUNIOR HIGH','Temporarily No Showings','Appraisal District','2','Traditional','Rancho Verde Sec 5','6207','2.618','Water District','2014','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','215736182','1675093589','215736182','2022-12-20T16:24:23.947','94680516','Jared Turner','Turner Mangum,LLC','','','30.055419','-95.352076','9','77373','6','281070.00','Active','Glenbuck','23550','Street','Spring','2','0','3','1501','Single-Family','Available 2/16/2023. Open and spacious the single story Independence at 1501 square feet has great spaces in the right places. The study which is located at the front of the home offers a double door entry with a front facing window to chase the blues away while working. Another popular feature is the rear dining area just beyond the island kitchen. The Master of the home will always enjoy having the choice of a long bath in the garden tub or being able to sing in the stand up shower. The luxury vinyl plank in the common areas,granite countertops in the kitchen and 2inch faux wood blinds make this home both fashionable and easy to sanitize!','','12','Centex Homes','','Electric Dryer Connections,Washer Connections','','No Disclosures','1','','','Spring East','Central Gas','1','37202','Subdivision Lot','4889','Other','','500','1','To Be Built/Under Construction','2','','0','','','','','Composition','48 - Spring','CHET BURCHETT ELEMENTARY SCHOOL','SPRING HIGH SCHOOL','RICKY C BAILEY M S','Appointment Required','Builder','1','Traditional','Pine Grove','','2.99','Water District','2023','Builder'); --> 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','215739710','1675093589','215739710','2022-12-20T16:05:40.933','89211859','Roxana Blanco','Anne Vickery & Associates','','','29.972437','-95.408128','9','77073','7','219000.00','Active','Ashlen','723','Drive','Houston','2','0','4','1815','Single-Family','Great location, located at the heart of Houston. Come see this cozy, one story, 4 bedroom home. Front room could be a Den, Office space, or playroom for the kids. Open concept Kitchen, Dining, and Living area. Large master bedroom, with 3 additional bedrooms. Roof was replaced in 2021, and water heater was replaced in 2020. Home includes water softener system. Less then 2 miles from Interstate 45, less then 3 miles from Hardy Toll Road, 9 miles from IAH airport. Schedule your appointment!','0.1162','12','','','Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections','1','Aldine Area','Central Gas','1','LT 4 BLK 3 REMINGTON RANCH SEC 5','Subdivision Lot','5063','Appraisal District','','570','0','','2','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','MILTON COOPER ELEMENTARY SCHOOL','ANDY DEKANEY H S','DUEITT MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox','Appraisal District','1','Traditional','Remington Ranch Sec 5','4717','2.8804','Public Sewer,Public Water,Water District','2004','Appraisal District'); --> New record created successfully