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-11-02T03:04:06.713' ,`MLSNumber` = '48288550' ,`ListAgentFullName` = 'Brenda Quiroga' ,`ListOfficeName` = 'CORCORAN FERESTER REALTY' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.296250' ,`Longitude` = '-95.495834' ,`PhotoCount` = '42' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '674000.00' ,`Status` = 'Active' ,`StreetName` = 'Silveridge' ,`StreetNumber` = '1112' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3585' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home situated on one of the best lots in the gated community of Silverstone. Greeted with a winding wrought iron staircase upon entry, formal dining and private study. Spacious family room has floor to ceiling windows and plantation shutters, wood floors and gas log fireplace. Kitchen includes large walk in pantry, granite, island, stainless appliances w/double ovens. Breakfast room overlooks kitchen & family room. Primary suite downstairs includes a sitting area. Primary bath has a double vanity, jetted tub and separate shower & 2 walk in closets. Game room upstairs leads to second floor balcony. Three bedrooms up have walk in closets, plus 2 additional bathrooms up. ROOF is 4 years OLD,  2 new water heaters in 2022. Large fenced back yard includes covered patio with outdoor kitchen, a storage shed that backs to a wooded area with NO BACK NEIGHBORS. Porte cochere 3 car garage offers plenty of parking space. Shopping and dining nearby and easy access to freeway.' ,`Acres` = '1' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SILVERSTONE 01, BLOCK 2, LOT 12' ,`LotDesciption` = 'Greenbelt' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '900' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RICE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverstone' ,`TaxAmount` = '9494' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412017' WHERE `Matrix_Unique_ID` = '208299382'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T03:07:33.910' ,`MLSNumber` = '24018572' ,`ListAgentFullName` = 'Delia Barajas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = 'Morgan West' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.338996' ,`Longitude` = '-95.488068' ,`PhotoCount` = '32' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Hill Manor' ,`StreetNumber` = '1913' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Graystone Hills  a Master-Planned Community ! This is your chance to live at Graystone Hills, THIS HOME DID NOT FLOOD DURING HURRICANE HARVEY. It\'e in Excellent Condition! What a Spacious Home with 5 Bedrooms 3.5 Baths, Master Down. No Carpet, Wood Laminated Floors All Throughout. There\'e Tile in all Wet Areas, Granite Counter Tops in Kitchen, Ceramic Log Fireplace,  Formal Dining Room is Big and great for entertaining or it can be used as a Study.  The Breakfast Nook, Family, two bedrooms upstairs, and Master Bedroom have a view of the backyard. Extended Garage is Great for Bikes and Work Bench. Huge Cover Patio! No Survey.  Graystone Hills also offers scenic surrounds and amenities: Minutes from Lake Conroe, Walking Trails, Parks, Recreation Center, Pool, and a Nature Preserve. This beautiful property is Located minutes from hospitals,  golf courses, restaurants, and retail centers. Home Has Never Flooded. Check Out the Virtual Tour and Schedule your Private Showing Today!' ,`Acres` = '0.269' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S539306 - GRAYSTONE HILLS 06, BLOCK 2, LOT 14' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '765' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Graystone Hills 06' ,`TaxAmount` = '7791' ,`TaxRate` = '3.0284' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412018' WHERE `Matrix_Unique_ID` = '210326094'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T02:31:25.677' ,`MLSNumber` = '51887920' ,`ListAgentFullName` = 'Lonnie Wade' ,`ListOfficeName` = 'Invest Houston Realty' ,`SellingAgentFullName` = 'Joan Zaldivar' ,`SellingOfficeName` = 'HoustonDesignHomes.com' ,`Latitude` = '29.838888' ,`Longitude` = '-95.633285' ,`PhotoCount` = '22' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '295000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Pine Mountain' ,`StreetNumber` = '15515' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS A SINGLE FAMILY HOME. 4 BEDROOM, 2 1/2 BATHS. DO NOT WALK PROPERTY OR KNOCK ON DOOR WITHOUT APPOINTMENT. TENANT IS ON MONTH TO MONTH LEASE BUT HAS BEEN IN UNIT 5+ YEARS. RENTS ARE UP & SEC-8 IS PAYING UP TO $2300 FOR THIS AREA PER HOUSING PAYMENT STANDARDS.' ,`Acres` = '0.201' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 9 BLK 9 BEAR CREEK VILLAGE SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8756' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BEAR CREEK ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CARDIFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Bear Creek Village Sec 06' ,`TaxAmount` = '4599' ,`TaxRate` = '2.1736' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412018' WHERE `Matrix_Unique_ID` = '210488400'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T02:58:40.973' ,`MLSNumber` = '26767526' ,`ListAgentFullName` = 'Alan Sanchez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342133' ,`Longitude` = '-96.605631' ,`PhotoCount` = '31' ,`PostalCode` = '77897' ,`RoomCount` = '6' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Bee St' ,`StreetNumber` = '203' ,`StreetSuffix` = '' ,`City` = 'Somerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Say hello to your new home! 203 Bee ST is located MINUTES from Lake Somerville. Perfect for fishing and spending a splendid weekend get-away. A beautiful, single-family house with 3 bedroom and 2 full bathrooms, main driveway located in front of the house, and the second just to the left of the house (located on Parallel St). The property is equipped with services for an RV attached to the property. 203 Bee St. is the first house on the left with a red front door on a corner lot.' ,`Acres` = '0.1148' ,`Area` = '59' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2502 SOMERVILLE PLACE LOT 797, 0.1377 ACRES' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '10998' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerville Place' ,`TaxAmount` = '54' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1667412018' WHERE `Matrix_Unique_ID` = '211506501'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T02:59:16.807' ,`MLSNumber` = '46625795' ,`ListAgentFullName` = 'Alan Sanchez' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.342133' ,`Longitude` = '-96.605631' ,`PhotoCount` = '7' ,`PostalCode` = '77879' ,`RoomCount` = '3' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Bee St' ,`StreetNumber` = '203' ,`StreetSuffix` = '' ,`City` = 'Somerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Say hello to your new weekend home! 203 Bee ST is located MINUTES from Lake Somerville. Perfect for fishing and spending a splendid weekend get-away. A beautiful, single-family house with 3 bedroom and 2 full bathrooms, main driveway located in front of the house, and the second just to the left of the house (located on Parallel St). The property is equipped with services for an RV attached to the property. 203 Bee St. is the first house on the left with a red front door on a corner lot.' ,`Acres` = '0.1377' ,`Area` = '59' ,`BuilderName` = 'Seller' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S2502 SOMERVILLE PLACE LOT 798 0.1377 ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '6000' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '65' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Somerville Place' ,`TaxAmount` = '64' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1667412018' WHERE `Matrix_Unique_ID` = '211661319'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T02:11:22.413' ,`MLSNumber` = '84580767' ,`ListAgentFullName` = 'Agha Abbas' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621296' ,`Longitude` = '-95.392339' ,`PhotoCount` = '22' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '220000.00' ,`Status` = 'Active' ,`StreetName` = 'Nichole Woods' ,`StreetNumber` = '1513' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming three-bedroom, two-bathroom, one-story home featuring a two-car detached garage! This home offers a warm living room/dining room, and an adjacent kitchen with tile floors throughout, a bright breakfast area, and laminate countertops! The master bedroom is completed by an en-suite bath and the second full bath offers a well-maintained shower/tub combo. The back door will give you access to the detached garage and usable private backyard space that is fully fenced! This home is located with easy access to the neighborhood\'s central park, Hwy 288, and Beltway 8! Just minutes from the Texas Medical Center, this master planned community offers a short commute for medical center employees. Schedule a private showing today!' ,`Acres` = '0.1073' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 34 BLK 1 CITY PARK SEC 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4674' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'City Park' ,`TaxAmount` = '4885' ,`TaxRate` = '3.0307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412018' WHERE `Matrix_Unique_ID` = '212988048'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T02:39:22.860' ,`MLSNumber` = '29550688' ,`ListAgentFullName` = 'Anna Truong' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.690526' ,`Longitude` = '-95.577143' ,`PhotoCount` = '15' ,`PostalCode` = '77072' ,`RoomCount` = '8' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Concho' ,`StreetNumber` = '11226' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2314' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FRESH PAINT, TILE AND LAMINATE FLOORING THROUGH OUT THE HOUSE, GRANITE FOR THE WHOLE HOUSE COUNTER TOP. A great location with easy access to Beltway 8, Westpark Tollway, and conveniently located between I-10 and 59.' ,`Acres` = '0.1566' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 12 BELLAIRE WEST SEC 8' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bellaire West Sec 08' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412019' WHERE `Matrix_Unique_ID` = '213495297'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-02T02:01:57.903' ,`MLSNumber` = '46498438' ,`ListAgentFullName` = 'Iliana Carvajal' ,`ListOfficeName` = 'Loya Soliz Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.874813' ,`Longitude` = '-95.137758' ,`PhotoCount` = '9' ,`PostalCode` = '77044' ,`RoomCount` = '4' ,`ListPrice` = '274969.00' ,`Status` = 'Active' ,`StreetName` = 'Fall Fern' ,`StreetNumber` = '15627' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2379' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful spacious 4 Bedroom, 2.5 Bath and 2 Car Garage. Kitchen with granite counter tops and plenty of space. Pantry, surrounded with lots of storage space. Well lit breakfast nook and a spacious Game room upstairs. Separate Shower and soothing Garden Tub. Carpet installed October 10th and the home is freshly painted throughout. Rain gutters, nice sized yard with a covered patio. Conveniently located. Ready to Move in!! Call today to schedule your appointment.' ,`Acres` = '0.1085' ,`Area` = '2' ,`BuilderName` = 'Long Lake' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 2 SHELDON RIDGE SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4725' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'SHELDON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sheldon Rdg' ,`TaxAmount` = '7574' ,`TaxRate` = '3.6393' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1667412019' WHERE `Matrix_Unique_ID` = '213810882'  --> 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','214209371','1667412019','214209371','2022-11-02T02:48:53.860','66572093','Rosalva Alvarado','Excelencia-Excellence  RE, LLC','','','29.668387','-95.829429','49','77406','8','367369.00','Active','Slumbering Willow','9714','Lane','Richmond','2','0','3','2000','Single-Family','WELCOME HOME JUST IN TIME FOR THE HOLIDAYS! Like new Lennar Home Fairway Collection, \'\'Blackstone\" Plan with an all Brick Elevation \"E\" in Creekside Ranch! Beautiful 1 Story, 3 Bedroom, 2 Bath + 2 Car Garage, features an Open Dining Room, Spacious Family Room, an Island Kitchen with Designer Cabinets, Granite Countertops! Breakfast Room & Walk-in Pantry. Luxurious with tons of upgrades, Primary Suite with a Large Shower, Dual Sinks & Walk-in Closet. 6\"x 24\" Upgraded Tile Plank Flooring, 2\'\' Faux Wood Blinds & Ceiling Fans; 16 SEER HVAC System. Programable Thermostat & Radiant Barrier Roof Decking; High ceilings, with covered back Patio, yards front and back feature seven zone automatic sprinklers! Yard is big enough to fit a swimming pool, This Home is also Wi-Fi and energy efficient CERTIFIED Smart Home.','0.1779','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Fort Bend County North/Richmond','Central Gas','1','CREEKSIDE RANCH SEC 9, BLOCK 2, LOT 28','Subdivision Lot','7750','Appraisal District','','815','0','','2','Convection Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','33 - Lamar Consolidated','BENTLEY ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Creekside Ranch Sec 9','6533','2.5248','Public Sewer,Public Water,Water District','2020','Appraisal District');  --> New record created successfully<br />