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-09-05T19:46:27.383' ,`MLSNumber` = '63318632' ,`ListAgentFullName` = 'My Nguyen' ,`ListOfficeName` = 'BHGRE Gary GreeneLeague City' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543712' ,`Longitude` = '-95.075111' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '13' ,`ListPrice` = '1700000.00' ,`Status` = 'Active' ,`StreetName` = 'Pegasus Ln' ,`StreetNumber` = '747' ,`StreetSuffix` = '' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'EXPERIENCE TRUE ELEGANCE & CRAFTSMANSHIP w/This Luxury Waterfront Home in the Desirable Gated Community of Constellation Pointe. The Elegant Entryway strikes a balance between Sophistication and Comfort. This Beauty Boasts a Luxurious Staircase with an Intricate Wrought Iron Pattern. Soaring Ceilings & Neutral Color Schemes allows the Stunning Architecture to Shine through out. Featuring TWO Primary Suites w/Oversized Bathrooms & Walk-In Closets!Every Bedroom w/its own Balcony Overlooking the Magnificent View of Clear Lake. The Excellence in the Design includes Barrel Roll Ceilings,Breakfast Nook Surrounded by Windows,Family Room, Formal Dining,Chef’s Kitchen w/All Thermador Appliances & Custom Cabinets.Let the Elevator take you to the Next Level where the Media Rm, Study & Work-Out Rm is located. Outdoor Living Space is Great for Entertaining \r\nw/the Spacious Covered Patio & Outdoor Kitchen.Walking distance to the Boat Slip w/Deep Water Access to the Lake. Coastal Living at it Finest!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CONSTELLATION POINTE SEC 2 (2005) ABST 18, BLOCK 1, LOT 28,' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '6992' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FERGUSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'CLEAR CREEK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Constellation Pointe Sec 2' ,`TaxAmount` = '14114' ,`TaxRate` = '2.06' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707175' WHERE `Matrix_Unique_ID` = '208200099'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T19:39:22.397' ,`MLSNumber` = '8977556' ,`ListAgentFullName` = 'Santa Creado' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.706354' ,`Longitude` = '-95.297140' ,`PhotoCount` = '25' ,`PostalCode` = '77087' ,`RoomCount` = '5' ,`ListPrice` = '250000.00' ,`Status` = 'Active' ,`StreetName` = 'Keller' ,`StreetNumber` = '6823' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1020' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Starter Home!! This home has 3 bedrooms, 1 bath and 1 car garage. Throughout the house you will see Hardwood flooring, tile and carpet in the bedrooms. There\'s a shed at the back of the house for extra storage space. Enjoy the convenience of easy access to major freeways and just mins away from Downtown.' ,`Acres` = '0.1263' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 103 PECAN PARK R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SOUTHMAYD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pecan Park R/P' ,`TaxAmount` = '2670' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707175' WHERE `Matrix_Unique_ID` = '210037719'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T18:18:20.210' ,`MLSNumber` = '24763110' ,`ListAgentFullName` = 'Joseph Tran' ,`ListOfficeName` = 'JVT Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926603' ,`Longitude` = '-95.277969' ,`PhotoCount` = '22' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Fosters Run' ,`StreetNumber` = '14358' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2516' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully appointed 1-story w/cul-de-sac location.  This home offers great flow with a 3/2/2 split plan, plus a \'\'flex\'\' room that can be used as a study.  Many energy features throughout!  Grand foyer/hallway, formal dining, open kitchen/family room.  The light & bright kitchen includes granite counters, stainless appliances, nice walk-in pantry.  Engineered hardwood thru the foyer, hallways & living areas.  Low maintenance yard on a very private lot next to peaceful wooded area.' ,`Acres` = '0.172' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 FALL CREEK SEC 27' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Subdivision Lot' ,`LotSize` = '7494' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FALL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Back,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek' ,`TaxAmount` = '7643' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707175' WHERE `Matrix_Unique_ID` = '210050071'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T19:40:52.393' ,`MLSNumber` = '55085263' ,`ListAgentFullName` = 'Santa Creado' ,`ListOfficeName` = 'RE/MAX 5 Star Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.389861' ,`Longitude` = '-94.939798' ,`PhotoCount` = '19' ,`PostalCode` = '77590' ,`RoomCount` = '3' ,`ListPrice` = '199000.00' ,`Status` = 'Active' ,`StreetName` = 'Vance' ,`StreetNumber` = '3018' ,`StreetSuffix` = 'Avenue' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME!  3 beds, 2 baths & 1-car attached garage. Well maintained single story home with nice upgrades. New interior paint, New bathroom, A/C 3 years, COME TAKE A LOOK TODAY!' ,`Acres` = '0.1388' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 142 R LOGAN SUR LOT 13 BLK 4 CLAIREMONT ADDN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6048' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HEIGHTS ELEMENTARY SCHOOL (TEXAS CITY)' ,`SchoolHigh` = 'TEXAS CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BLOCKER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clairmont' ,`TaxAmount` = '3406' ,`TaxRate` = '2.5335' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707175' WHERE `Matrix_Unique_ID` = '210644150'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T19:15:58.710' ,`MLSNumber` = '50000131' ,`ListAgentFullName` = 'Wendy Neumann' ,`ListOfficeName` = 'Keller Williams Advtge Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.173315' ,`Longitude` = '-95.188366' ,`PhotoCount` = '48' ,`PostalCode` = '77357' ,`RoomCount` = '8' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Tall Timbers' ,`StreetNumber` = '251' ,`StreetSuffix` = 'Road' ,`City` = 'Woodbranch' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2567' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If you have been looking for a conveniently located property that has the feel of being in the country, this one is for you! This home features a split floorplan that has one large primary bedroom on one side of the house with en-suite bathroom that includes incredible dual showers. The second primary bedroom is on the other side of the house and has it\'s own private bathroom. This home offers a third bedroom, a third full bathroom and 2 other rooms that could be used in a variety of ways to fit your needs. The inside of the home was beautifully redone in 2021 with new tile floors, cabinets, granite counter tops, kitchen backsplash, stainless steel appliances and so much more. New roof in 2021 too! Home comes with a water softener, reverse osmosis in the kitchen, and an amazing, fully insulated 30x60 shop with an area that has been framed and plumbed for a future living space. There is so much that this property has to offer! Make your appointment to see it today!' ,`Acres` = '0.5424' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WOODBRANCH 04, LOT 251' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '23625' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Woodbranch 04' ,`TaxAmount` = '5614' ,`TaxRate` = '2.4398' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707176' WHERE `Matrix_Unique_ID` = '211239520'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T19:00:36.150' ,`MLSNumber` = '13695023' ,`ListAgentFullName` = 'Jamie McMartin' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = 'Marlyn Mendoza' ,`SellingOfficeName` = 'Keller Williams Woodlands' ,`Latitude` = '30.050618' ,`Longitude` = '-95.381631' ,`PhotoCount` = '17' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '200000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Pebworth' ,`StreetNumber` = '23247' ,`StreetSuffix` = 'Place' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1124' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautiful one story home in the heart of Spring. A great location with easy access to everything Spring has to offer. Beautifully remodeled inside and out. Designer kitchen and bathrooms that you will love. High ceilings combined with a wood burning fireplace creates an inviting home that leaves you feeling warm and welcomed. Truly have to see this beautiful home for yourself. Call to schedule your own private showing today to see just how beautiful this home is.' ,`Acres` = '0.1136' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 25A BLK 6 CYPRESS TRAILS OF TIMBERLANE 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4950' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Cypress Trails Timberlane' ,`TaxAmount` = '3761' ,`TaxRate` = '3.0268' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707176' WHERE `Matrix_Unique_ID` = '211467466'  --> 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','211856711','1663707176','211856711','2022-09-05T19:10:12.830','94106535','Sergio Hidalgo','United Real Estate','','','29.680923','-95.750548','39','77407','11','399990.00','Active','Driscoll Park','6023','Drive','Richmond','2','1','3','2258','Single-Family','6023 Driscoll Park Drive is located in the city of Richmond in the Long Meadow Farms Subdivision. This residence has three bedrooms, two full bathrooms, and a guest restroom. Pergo flooring has been installed throughout all the areas of the house except for the three bedrooms. Pergo floors are pet-friendly and look great. A study/office space is located near the entrance of the residence and distant from the home\'s main areas, making it great if you are working from home. The house offers a formal dining room, breakfast area, and island kitchen for all of your dining pleasures. Great opportunity for an investor or as a primary home.','0.1497','37','Highland Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Fort Bend County North/Richmond','Central Gas','1','LONG MEADOW FARMS SEC 38, BLOCK 2, LOT 6','Subdivision Lot','6520','Appraisal District','','875','0','','2','Electric Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','ADOLPHUS ELEMENTARY SCHOOL','FOSTER HIGH SCHOOL','WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment','Appraisal District','1','Traditional','Long Meadow Farms Sec 38','8842','2.9048','Public Sewer,Public Water,Water District','2016','Appraisal');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T18:21:28.250' ,`MLSNumber` = '32190697' ,`ListAgentFullName` = 'David Leavell' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.944258' ,`Longitude` = '-95.183516' ,`PhotoCount` = '32' ,`PostalCode` = '77044' ,`RoomCount` = '8' ,`ListPrice` = '330000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakheath Colony' ,`StreetNumber` = '15419' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Terrific one story home in Lakewood Pines! Boasting a brick exterior, wood tile flooring, Large open Family Room with high ceiling. Kitchen with Large food preparation area and Breakfast Bar, Walk-in pantry, Gas stove and high end microwave. Large Master Bedroom with huge walk-in closet. Master bath with dual sinks, Garden soaking tub and separate Toilet room. Home includes a nice Gameroom. The tranquil community of Lakewood Pines offers residents access to a pool, recreation center and a park. Commuters enjoy close proximity to the Sam Houston Tollway and easy access to the Houston Ship Channel and Generation Park. Zoned to the highly rated Humble ISD.' ,`Acres` = '0.1416' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 LAKEWOOD PINES SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6166' ,`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` = '29 - Humble' ,`SchoolElementary` = 'CENTENNIAL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakewood Pines' ,`TaxAmount` = '9129' ,`TaxRate` = '3.613' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707176' WHERE `Matrix_Unique_ID` = '211897252'  --> 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','211898521','1663707176','211898521','2022-09-05T18:48:32.817','82866409','Janna Arredondo','C.R.Realty','','','29.571297','-95.781525','21','77469','7','207000.00','Active','Riverwood','5011','Drive','Richmond','2','0','4','1468','Single-Family','Welcome to your beautiful 1 Story Home. You will fall in love with this 4 bedroom 2 bath home. The open floor plan makes this an ideal setting for gathering with family and friends. The charming kitchen has a window sink over looking the living room, pantry, and plenty of counter space. The living room has a beautiful fireplace, a bonus to the breakfast room is the patio door which can extend your entertaining space even further as you step out unto the patio and spacious backyard. 3 bedrooms and a full bathroom are found in their own wing of the home. The secluded primary suite is well kept off of the living space with plenty of natural light. Large backyard for all your entertaining and family gatherings. NEW kitchen appliances, NEW laminate, NEW carpet, Fresh paint, and so much more. Don\'t miss out on this opportunity!','0.1366','30','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Fort Bend South/Richmond','Central Gas','1','RIVERWOOD VILLAGE SEC 1, BLOCK 3, LOT 19','Subdivision Lot','5948','Appraisal District','','351','0','','0','Gas Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','LONG ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Supra Keybox','Seller','1','Traditional','Riverwood Village Sec 1','3078','2.4948','Public Sewer,Public Water,Water District','1983','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T18:00:20.407' ,`MLSNumber` = '31050125' ,`ListAgentFullName` = 'Adnew Tadesse' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.552235' ,`Longitude` = '-95.769159' ,`PhotoCount` = '32' ,`PostalCode` = '77471' ,`RoomCount` = '9' ,`ListPrice` = '304000.00' ,`Status` = 'Active' ,`StreetName` = 'Hemple' ,`StreetNumber` = '1410' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 2 story traditional home features a home study room on the first floor with an upgraded flooring throughout the home with 2x6 tiles on the first floor, remodeled kitchen with black granite countertop and a tile backsplash with inserts, upgraded light fixtures, plumbing and toilets, large pantry space, wood stairs with white risers, laminate flooring throughout second floors with a large primary bedroom featuring a huge walk-in closet, primary bath with a separate shower and whirlpool tub, granite countertops with extra shelves, upgraded light fans, good size secondary bedrooms with closets, great game room for entertainment on the second floor, large covered patio with tiles, recently replaced roof and a great backyard to relax or gather with friends and family.' ,`Acres` = '0.1377' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'VILLAGES OF TOWN CENTER SEC 5, BLOCK 3, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'SMITH ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Of Town Center Sec 5' ,`TaxAmount` = '4665' ,`TaxRate` = '2.4891' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707176' WHERE `Matrix_Unique_ID` = '211967252'  --> Updated record success<br />