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` = '2023-01-14T18:53:10.847' ,`MLSNumber` = '23925956' ,`ListAgentFullName` = 'Virginia Henderson' ,`ListOfficeName` = 'Valhil Realty Co., LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.769363' ,`Longitude` = '-95.497105' ,`PhotoCount` = '47' ,`PostalCode` = '77024' ,`RoomCount` = '16' ,`ListPrice` = '5185000.00' ,`Status` = 'Active' ,`StreetName` = 'Memorial' ,`StreetNumber` = '10658' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '2' ,`BedsTotal` = '6' ,`SqFtTotal` = '8296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Winner 2018 Houston\'s Best Prism Award for Custom Home Elevation. 6 Bedrooms, 6 full and 2 half baths. Spectacular scale w/ sophisticated designer selections to create extraordinary living spaces. Situated on Prime lot in prestigious Hunters Creek Village. Grand entry w/ sweeping staircase & views of amazing backyard & sparkling pool. 12 ft ceilings, formals, study, spacious mudroom, climate controlled wine cellar, 1st floor primary retreat, 2 staircases, elevator. Impressive gourmet kitchen open to family room w/2 dishwashers, dual Sub-Zero Refrigerators, Miele coffee maker, Wolf appliances, large marble island, Dramatically beamed ceilings in family room. Primary w/ luxurious marble bath, custom designed closets, Outdoor oasis w/ kitchen, fireplace, oversized pool. Shaded pergola off primary suite w/ private garden constructed by Rooted Garden- featured in Houston Chronicle & Hunters Creek Village magazine. All info per Seller.' ,`Acres` = '0.5778' ,`Area` = '23' ,`BuilderName` = 'REALEX HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 WELLESLEY 3RD PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '25168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HUNTERS CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Wellesley Add Pt Rep 3' ,`TaxAmount` = '65149' ,`TaxRate` = '2.1111' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675136490' WHERE `Matrix_Unique_ID` = '209034933' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T17:34:21.267' ,`MLSNumber` = '77532373' ,`ListAgentFullName` = 'Dee Lerma' ,`ListOfficeName` = 'Travis Abel & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.961882' ,`Longitude` = '-96.277383' ,`PhotoCount` = '32' ,`PostalCode` = '77418' ,`RoomCount` = '7' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Ridge' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Drive' ,`City` = 'Bellville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Custom Home situated on a .42 acre lot, located across the street from the subdivision park, with access to the community pool. Spacious family room with tall ceilings, built-ins and a gas log fireplace. A breakfast bar separates the living room and kitchen. Open concept with a split floor plan to provide privacy to the primary suite, the ensuite includes a jetted garden tub, separate shower, double sinks on an extended vanity, and a large walk-in closet. The home office/study/library is conveniently located off the main entrance with beautiful French doors. The backyard is spacious and filled with greenery, including landscaping and a garden. The side yard includes trees and a swing to enjoy those relaxing morning and evenings. Zoned to O’Bryant, not West End Elementary.' ,`Acres` = '0.4207' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRIARWOOD SUB SEC VI BLOCK RESERVE B LOT 1 ACRES .4207' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '18326' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'O\'BRYANT PRIMARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarwood Sub' ,`TaxAmount` = '5415' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675136490' WHERE `Matrix_Unique_ID` = '209472329' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T17:03:05.123' ,`MLSNumber` = '72378811' ,`ListAgentFullName` = 'Marisela Rodriguez' ,`ListOfficeName` = 'Exceed Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.034848' ,`Longitude` = '-95.460911' ,`PhotoCount` = '16' ,`PostalCode` = '77566' ,`RoomCount` = '5' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Almond' ,`StreetNumber` = '248' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1655' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, open concept one story 3 bedroom 2 bath with 1 garage converted into an additional room. High ceilings in the living area, ceramic tile. Spacious kitchen with breakfast area. Master bath includes a tub/shower with a double sink. Interior fresh paint will be applied and new carpet will be installed in the master bedroom once the property is vacant. Seller is working on small repairs. Don\'t miss this precious home, call to schedule a showing today!' ,`Acres` = '0.1188' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION VILLAGE SEC 3 (LAKE JACKSON), BLOCK 5, LOT 10 REP' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5175' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Village Sec 1-27 L' ,`TaxAmount` = '5258' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675136490' WHERE `Matrix_Unique_ID` = '212584909' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-14T17:02:43.130' ,`MLSNumber` = '60330538' ,`ListAgentFullName` = 'Gayla Gayden' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.014765' ,`Longitude` = '-95.536090' ,`PhotoCount` = '40' ,`PostalCode` = '77379' ,`RoomCount` = '14' ,`ListPrice` = '424000.00' ,`Status` = 'Active' ,`StreetName` = 'Bent Oak' ,`StreetNumber` = '8107' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing Updated Home Nestled in the beautiful Memorial Northwest for today lifestyle! Huge Lot! 2 1/2 Detached Garage! Energy Saving Home w/ Updated Roof, Radiant Attic Barrier, High-Efficiency HVAC, Insulated Doors, Insulated/Low-E Windows, Energy Saving H2O Heater & More! Owner\'s Suite & Guest Bedroom Down! Elegant Formal Living & Dining! Dramatic Family Area W/High Ceilings, Amazing Wall of Windows, Stunning Corner Fireplace, Wood Like Tile Floors lead into the Magnificent Gourmet Kitchen W/Tall White Shaker Cabinets, Soft Close Drawers & Cabinets, Gorgeous Quartz Counters, Subway Glass Backsplash, Deep Farmer Sink, 5 Burner, Double Oven Range, Huge Wrap Around Breakfast Bar & More! Owner\'s Suite W/Luxurious Spa Bathroom W/Massive Body Shower, Free Standing Soaking Tub, His & Her Private Undermount Sinks, Quartz Counters, Make Up Area & More! Upstairs Huge Game Rm, 3 Large Bedrooms, & Hollywood Bathroom W/Shaker Cabinets & Quartz Counters! No Flooding! Outstanding Amenities!' ,`Acres` = '0.2686' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 6 017*M1876900-002-006-035 MEMORIAL NORTHWEST SEC' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'THEISS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'DOERRE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Memorial Northwest' ,`TaxAmount` = '5281' ,`TaxRate` = '2.3213' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675136490' WHERE `Matrix_Unique_ID` = '214372890' --> 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','215593623','1675136490','215593623','2023-01-14T17:20:52.230','64397189','Tonya Pressley','Prime Realty Group','','','29.674565','-95.063562','23','77571','3','574999.00','Active','H','10956','Street','La Porte','2','0','3','1798','Single-Family','Country Living in the City...This home is located on 2 acres land, with an oversized 2 car detached garage that also has a game room/pool room or even a guest house above it along with covered parking off the garage...there is also Covered RV/Boat parking on the side of the garage along with a barn in the back... you can also relax in the\r\nin-ground beach front style pool....','2','7','','','Gas Dryer Connections','','Sellers Disclosure','1','Gas Connections','1','La Porte/Shoreacres','Central Gas','0','TR 475B & 475B-1 LA PORTE OUTLOTS','Cleared','87120','Appraisal District','','','0','','2','Gas Oven','1','In Ground','','Gas Range','','Composition','35 - La Porte','LOMAX ELEMENTARY SCHOOL','LA PORTE HIGH SCHOOL','LOMAX JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Back','Appraisal District','1','Other Style','La Porte Outlots','4164','2.7208','Public Sewer,Public Water','1975','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','216368184','1675136491','216368184','2023-01-14T17:04:15.917','43320414','Nasser Maaz','Realty Associates','','','29.706333','-95.180822','20','77506','11','269995.00','Active','Alastair','403','Drive','Pasadena','2','0','5','1389','Single-Family','This beautiful 5 bedroom 2 bath-house has been remolded all the way to the studs. Total electric, AC, plumbing and siding was completely redone. All work passed the city of Pasadena inspections. It\'s truly a brand-new house.','0.1515','6','','','','','No Disclosures','','','','Pasadena','Central Gas','0','LT 2 BLK 9 RED BLUFF TERRACE SEC 1','Cleared','6600','Appraisal District','','','0','','0','','0','','','','','Composition','41 - Pasadena','RED BLUFF ELEMENTARY SCHOOL','PASADENA HIGH SCHOOL','SANJACINTO INTERMEDIATE SCHOOL','Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Red Bluff Terrace Sec 01','3417','2.6514','Public Sewer,Public Water','1950','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','216403696','1675136491','216403696','2023-01-14T17:22:39.710','9748826','Casey Waters','Coldwell Banker Apex, REALTORS LLC','','','31.531792','-96.417586','30','76642','5','264900.00','Active','FM 1953','952','','Groesbeck','2','0','3','1100','Single-Family','This gorgeous 3.091+/- acre home sits off a nice smooth blacktop county road with black asphalt driveway entry as there is no muddy driveways on rainy days!\r\n\r\nThe property has an Oasis feel with a Ranch appeal with private fishing as there’s a large pond outback that is stocked with catfish. The property also provides a private 200ft deep water well, a roof installed in January of 2023, and aerobic septic system installed in October 2022! \r\n\r\nAs you enter the driveway you are greeted by a beautiful black automatic sliding gate with keypad, branded with a Texas star!\r\n\r\nBehind the gates awaits a beautiful manufactured home built in 2001 with a large cedar deck. Inside the unit are 3 bedrooms and 2 full bathrooms. You will love this comfy home as there’s also a fireplace with central AC and heating.\r\n\r\nThe backyard offers plenty of space with a 200 foot long wooden privacy fence that stretches along the frontage on FM 937!\r\n\r\nGroesbeck is central between Houston, Austin, and DFW.','3.091','73','','','','','Other Disclosures,Sellers Disclosure','','','','','Central Electric','0','A001E J N ACOSTA-EAST, ACRES 3.091','Other','134644','Appraisal District','','','0','','0','','0','','','','','Composition','222 - Groesbeck','GROESBECK ELEMENTARY SCHOOL','GROESBECK HIGH SCHOOL','GROESBECK MIDDLE SCHOOL','Accompany,Appointment Required,No Photos/No Videos','Seller','1','Other Style','Jn Acosta East','842','2.2021','Aerobic','2001','Seller'); --> New record created successfully