Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>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)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T05:22:29.117' ,`MLSNumber` = '68801834' ,`ListAgentFullName` = 'Christopher Trousdale' ,`ListOfficeName` = 'Ward Arnold Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700710' ,`Longitude` = '-95.124949' ,`PhotoCount` = '22' ,`PostalCode` = '77536' ,`RoomCount` = '4' ,`ListPrice` = '195000.00' ,`Status` = 'Active' ,`StreetName` = 'Elm' ,`StreetNumber` = '1222' ,`StreetSuffix` = 'Street' ,`City` = 'Deer Park' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 2D DEER PARK' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'POYE G D OL 154 DEER PARK' ,`TaxAmount` = '4501' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344497' WHERE `Matrix_Unique_ID` = '208787665'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T05:16:29.040' ,`MLSNumber` = '52515654' ,`ListAgentFullName` = 'Racquel Reyna' ,`ListOfficeName` = 'Luxe Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.570386' ,`Longitude` = '-95.403719' ,`PhotoCount` = '50' ,`PostalCode` = '77584' ,`RoomCount` = '6' ,`ListPrice` = '450900.00' ,`Status` = 'Active' ,`StreetName` = 'Shore Creek' ,`StreetNumber` = '2216' ,`StreetSuffix` = 'Drive' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3396' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 2216 SHORE CREEK DR.  This Stunning 4 bed 3.5 bath home sits in a cul-de-sac and is Ready to Move in! You\'re greeted with a Long Driveway entry that leads you to the Detach Garage and a covered walkway to the back door into the Kitchen. This Home has been completely  Renovated with All new Paint, Vinyl flooring in the common areas, electrical fixtures, brushed nickel hardware,  and all New Carpet throughout. This home offers a Living area, formal dining, breakfast nook, bar top, Office with Hall half bathroom for guests, and a Primary bedroom downstairs. Enjoy the Massive walk-in closet, double vanity, and separate shower/tub.  Take a tour upstairs as you are immediately greeted with a large game room, desk station, and 2 bedrooms with a passthrough bathroom and separate vanity 1 hall bath with 1 room with a secret bonus room! Enjoy all the conveniences of the community, such as parks, trails, and pools. Easy Acces to commutes, shopping, and dining. schedule a tour today!' ,`Acres` = '0.2037' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SHADOW CREEK RANCH SF-4 (PEARLAND), BLOCK 1, LOT 18' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8873' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MAREK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'NOLAN RYAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shadow Creek Ranch Sf1-Sf2-Sf3' ,`TaxAmount` = '9138' ,`TaxRate` = '2.9209' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344497' WHERE `Matrix_Unique_ID` = '211159501'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T05:07:00.770' ,`MLSNumber` = '52144935' ,`ListAgentFullName` = 'Hilda Castillo' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.834633' ,`Longitude` = '-95.452105' ,`PhotoCount` = '20' ,`PostalCode` = '77018' ,`RoomCount` = '6' ,`ListPrice` = '479000.00' ,`Status` = 'Active' ,`StreetName` = 'De Milo' ,`StreetNumber` = '2218' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1994' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great location. Appealing home in Oak Forest. Hardwoods, tile & terrazzo throughout a unique floor plan.  Oversized two car garage integrated with a workshop in addition to a carport. Great home for indoor and outdoor spaces ideal for entertaining. Clean and well kept, ready for move in. Very Spacious. Never Flooded!' ,`Acres` = '0.2183' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 8 OAK FOREST SEC 18' ,`LotDesciption` = 'Corner' ,`LotSize` = '9509' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Forest Sec 18' ,`TaxAmount` = '7618' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344497' WHERE `Matrix_Unique_ID` = '212764214'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T04:27:00.127' ,`MLSNumber` = '43269613' ,`ListAgentFullName` = 'Gwendolyn Burwell' ,`ListOfficeName` = 'UTR TEXAS, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577878' ,`Longitude` = '-95.378599' ,`PhotoCount` = '37' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Forest Oaks' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1803' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME TO YOUR NEW LIFESTYLE IN THIS SPACIOUS 3 BEDROOM 2 BATH HOME IN DESIRABLE ACTIVE 55+ SENIOR COMMUNITY OF COUNTRYPLACE! Open concept home has High Ceilings & Large Island Kitchen has 5-burner Gas Range (2020) & Breakfast Area w Bay Window. Expansive Living room has Formal Dining. Large Primary Bedroom has 2 Walk-in Closets. Primary Bath has Garden Tub & Separate Shower. Front Bedroom has Bay Window. Sun Room is Air-Conditioned & opens up to partially covered back patio. Beautiful tile floor layout & slate on front porch! This active 55+ community has Olympic size Pool, Hot Tub, lighted Tennis Courts, Golf Course, & multitude of Activities at the Clubhouse: Travel Club, Friday Happy Hours at the Grill, Exercise rooms, Library, Game room, Auditorium, & more. Note the 24/7 Manned Security. Ideally located near Hwy 288 & Beltway 8, there\'s easy access to Pearland shopping, restaurants, medical facilities, & only a short drive to downtown Houston, sports arenas, & theater district.' ,`Acres` = '0.1458' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 5 LOT 13' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '6351' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '180' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'CHALLENGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Countryplace Sec 1' ,`TaxAmount` = '5478' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665344497' WHERE `Matrix_Unique_ID` = '212766242'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-09T05:13:18.037' ,`MLSNumber` = '76593576' ,`ListAgentFullName` = 'Linda Hulsey' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780964' ,`Longitude` = '-95.386613' ,`PhotoCount` = '36' ,`PostalCode` = '77009' ,`RoomCount` = '12' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Usener' ,`StreetNumber` = '1113' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2478' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This classically styled brick facade with charming front porch~and a 2nd story balcony with views of Downtown is nestled in Houston Heights with an elegant presence on Usener St. It\'s walking distance to local restaurants and the White Oak Hike and Bike trail. Being centrally located, one has easy access to Downtown, the Medical Center,Museum District and the Energy Corridor! Graciously proportioned rooms with the large Primary Suite downstairs, open concept and clerestory windows create a graceful, practical, modern design. Family room opens to the breakfast bar and adjoining kitchen. Two large bedrooms up and a common area upstairs could be another bedroom, game room, office or Den. This distinguished home also includes a large deck for entertaining plus yard.The Garage apartment adds a large living space one more bedroom and full bath.There is 2 car parking spots in front garage also additional parking out front.' ,`Acres` = '0.1331' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 25 NORHILL' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Norhill' ,`TaxAmount` = '22684' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665344498' WHERE `Matrix_Unique_ID` = '212949439'  --> Updated record success<br />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','213427220','1665344498','213427220','2022-10-09T04:25:04.970','40164868','Gwendolyn Burwell','UTR TEXAS, REALTORS','','','29.577441','-95.379911','40','77584','6','270000.00','Active','Breezy Pines','2707','Lane','Pearland','2','0','2','1445','Single-Family','WELCOME TO YOUR NEW LIFESTYLE IN DESIRABLE ACTIVE 55+ SENIOR COMMUNITY OF COUNTRYPLACE! With stunning views from Living, Breakfast/Kitchen, & Primary Bedroom, this cul-de-sac lot on golf course is one of the best locations in Countryplace. This light & bright home has fresh paint, High Ceilings, Kitchen Breakfast Area, Dining Room w Bay Window. Large Primary Bedroom has Walk-in Closet, Primary Bath w Garden Tub, Separate Shower, Double Sinks. Enjoy peaceful hours on your back deck in the shade of a grove of mature trees. This active 55+ community has Olympic size Pool, Hot Tub, lighted Tennis Courts, Golf Course, & multitude of Activities at the Clubhouse: Travel Club, Friday Happy Hours at the Grill, Exercise rooms, Library, Game room, Auditorium, & more. Note the 24/7 Manned Security. Ideally located near Hwy 288 & Beltway 8, there\'s easy access to Pearland shopping, restaurants, medical facilities, & only a short drive to downtown Houston, sports arenas, & theater district.','0.1522','5','','','','','Approved Seniors Project,Estate','1','','','Pearland','Central Gas','1','COUNTRYPLACE SEC 1 (A0510 F B DRAKE) BLK 5 LOT 26','Cul-De-Sac,In Golf Course Community,On Golf Course','6630','Appraisal District','','180','0','','2','','0','','','Electric Range,Freestanding Range','','Composition','42 - Pearland','CHALLENGER ELEMENTARY SCHOOL','GLENDA DAWSON HIGH SCHOOL','BERRY MILLER JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Lockbox Front','Appraisal District','1','Traditional','Countryplace Sec 1','4939','2.5552','Public Sewer,Public Water','1987','Appraisal District');  --> New record created successfully<br />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','213469743','1665344498','213469743','2022-10-09T05:46:00.400','89518206','Karol Deem','Deem Realty','','','29.244480','-94.902283','33','77554','6','590000.00','Active','Zingelmann','11631','Road','Galveston','2','0','3','1419','Single-Family','Two Acres on dead end country road with horses & cows for neighbors. Three bedrooms, two baths, 1419 square feet split level with concrete below.  Home renovated with recent roof, HVAC, vinyl wood look flooring, paint inside and out, vinyl insulated windows, lights, ceiling fans, plugs, switches, electric hot water heater, exterior electric meter disconnect switch, bathroom fixtures, water line from street, closed cell insulation on ceiling below and soffit below. Includes all new appliances.  Owner/agent.  Ready to move in.  Enter by dirt driveway and park in rear of home.','2','33','','','Electric Dryer Connections,Washer Connections','','Owner/Agent','1','Wood Burning Fireplace','1','West End','Central Electric','0','ABST 121 PAGE 58 PT OF LOT 161 (161-13) TRIMBLE & LINDSEY SE','Cleared,Water View','87120','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Lockbox Back,Lockbox Left Side,No Supra Keybox,Request Online Appointment','Appraisal District','1.5','Contemporary/Modern','Trimble & Lindsey Sec 2','3642','2.0324','Public Water,Septic Tank','1995','Appraisal District');  --> New record created successfully<br />