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-08-20T11:30:04.800' ,`MLSNumber` = '94561593' ,`ListAgentFullName` = 'Carrie Farmer' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.786521' ,`Longitude` = '-96.224605' ,`PhotoCount` = '28' ,`PostalCode` = '77808' ,`RoomCount` = '7' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Hearne' ,`StreetNumber` = '5304' ,`StreetSuffix` = 'Lane' ,`City` = 'Bryan' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at it\'s finest. One of a kind three bedroom and two bathroom farm house. Features sun room with views of wide open spaces. Home to be sold with 2.0677 acres.\r\n\r\nNEW SEPTIC SYSTEM TO BE PLACED ON THE PROPERTY. OPTION TO PURCHASE 3 ADDITIONAL ACRES.' ,`Acres` = '2.06' ,`Area` = '61' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'John W. Stewart Tract 6.1, 2.0677' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '148 - Bryan' ,`SchoolElementary` = 'SAM HOUSTON ELEMENTARY SCHOOL (BRYAN)' ,`SchoolHigh` = 'JAMES EARL RUDDER HIGH SCHOOL' ,`SchoolMiddle` = 'ARTHUR L. DAVILA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'NA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700937' WHERE `Matrix_Unique_ID` = '206890790'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T10:53:25.550' ,`MLSNumber` = '28805951' ,`ListAgentFullName` = 'Edward McClintick' ,`ListOfficeName` = 'Joseph Walter Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703205' ,`Longitude` = '-95.626200' ,`PhotoCount` = '26' ,`PostalCode` = '77083' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Matthias' ,`StreetNumber` = '13703' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2151' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction in the heart of the Internation District of Houston.\r\n\r\nThis Open floor plan is a stunning 2-story home with 4 bedrooms, 2.5 bathrooms, a game room, a study or formal living area, AND a 2-car garage! This home includes ALL of the designer finishes you\'ve been looking for including wood-look tiles in the common areas and Master bedroom! The gourmet kitchen is sure to please with a large island, 42\" cabinetry, granite countertops, and stainless steel appliances! Retreat to the Owner\'s Suite downstairs featuring a gorgeous big window, separate tub and shower, and granite countertops. Enjoy the great outdoors with a backyard perfect for entertaining,  a covered porch, and a privacy wood fence!! Don\'t miss your opportunity to call today to schedule a visit today- this one will not last on the market for long!' ,`Acres` = '0.1835' ,`Area` = '28' ,`BuilderName` = 'Harmony Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1 LAKES OF BELLAIRE SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7994' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEARNE ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakes/Bellaire Sec 1' ,`TaxAmount` = '1635' ,`TaxRate` = '2.397' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700938' WHERE `Matrix_Unique_ID` = '209995964'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T11:37:44.007' ,`MLSNumber` = '86278430' ,`ListAgentFullName` = 'Robert Lindemann' ,`ListOfficeName` = 'Hittss Solutions, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.716461' ,`Longitude` = '-97.447791' ,`PhotoCount` = '25' ,`PostalCode` = '76530' ,`RoomCount` = '8' ,`ListPrice` = '267500.00' ,`Status` = 'Active' ,`StreetName` = 'Brazos' ,`StreetNumber` = '206' ,`StreetSuffix` = 'Street' ,`City` = 'Granger' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1186' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great home ready to move-in located in a quiet established neighborhood. This house features a kitchen/dining combo with breakfast island and built-in china cabinet and more custom cabinets. It has a large walk-in pantry and large utility room. The bedrooms are spacious. It has fresh paint and a new roof. Sitting on a .25 acre lot, there is plenty of outdoor space for fun, pets, playscapes, or a pool. There are two outdoor patios. The property is shaded by three mature pecan trees. The property also has a 36\' x 18\' workshop with concrete floor. Centrally located in historic Granger, Texas, this property is approximately 20-25 minutes from Taylor and Georgetown and 25-30 minutes from Temple.' ,`Acres` = '0.25' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'AW0509 PHILLIPS, J. & AW0571 STRATTON, G.S. SURS., ACRES .25' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10890' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '562 - Granger' ,`SchoolElementary` = 'GRANGER SCHOOL' ,`SchoolHigh` = 'GRANGER SCHOOL' ,`SchoolMiddle` = 'GRANGER SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Back,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Phillips and Stratton' ,`TaxAmount` = '4107' ,`TaxRate` = '2.199' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700938' WHERE `Matrix_Unique_ID` = '210121652'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T10:59:14.963' ,`MLSNumber` = '49923899' ,`ListAgentFullName` = 'Ruby Pineda Cervantes' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.696651' ,`Longitude` = '-95.716435' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '3' ,`ListPrice` = '345000.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Stone' ,`StreetNumber` = '19107' ,`StreetSuffix` = 'Court' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don’t miss out on this Gorgeous 3-bedroom, 2 bath home with Beautiful outdoor kitchen. This home features high ceilings with open layout, formal dining, and Breakfast nook.Beautiful granite counters tops  & Tile flooring Throughout kitchen and breakfast nook. Hardwood floors throughout with the exception of tile flooring in kitchen and bathrooms. Primary bedroom  features a large soaking tub, separate shower, double sinks, & walk-in closet. Beautiful landscaping with Sprinkler system for Hassle free lawn care. Newly replaced roof and Freshly painted kitchen cabinets and doors throughout home.This home is just minutes away from Westpark Tollway, 99 & i-10. Come out and take a look!' ,`Acres` = '0.1447' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND MISSION SEC 10, BLOCK 3, LOT 14' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6304' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '965' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SEGUIN ELEMENTARY (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Mission' ,`TaxAmount` = '4825' ,`TaxRate` = '2.5097' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700938' WHERE `Matrix_Unique_ID` = '210287744'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T11:33:34.117' ,`MLSNumber` = '10592344' ,`ListAgentFullName` = 'Lisa Meador' ,`ListOfficeName` = 'Berkshire Hathaway HomeServices Premier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148899' ,`Longitude` = '-95.522740' ,`PhotoCount` = '50' ,`PostalCode` = '77389' ,`RoomCount` = '13' ,`ListPrice` = '1288000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Cottage' ,`StreetNumber` = '19' ,`StreetSuffix` = 'Place' ,`City` = 'Spring' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning estate rests on lush grounds with backyard oasis! 6 bedrooms, 6.5 baths, oversized 3car garage & 2 guest suites. Upon entering beautiful windows, soaring ceilings & rich hard woods welcome you into the light, bright foyer. Find a luxurious executive study on your left & formal dining to the right. Step into this chef\'s dream kitchen with high end appliances, walk in pantry and leather like granite countertops. The large island looks into living area with picture windows showing off magnificent views of pool waterfalls & outdoor kitchen area. Don\'t miss the pool bath. Primary retreat also offers views of backyard paradise. Primary bathroom offers spacious his/her sink & vanity areas and fabulous 180 degree mirrored dressing space. so you will always leave home looking your best. Upstairs boasts 3 bedrooms with walk in closets complete with built ins, 2 bathrooms, study nook & media room. Popular location just steps from the peaceful Lake Paloma.' ,`Acres` = '0.3537' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 26' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt' ,`LotSize` = '15408' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '23923' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700938' WHERE `Matrix_Unique_ID` = '210641659'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T10:42:47.683' ,`MLSNumber` = '57543700' ,`ListAgentFullName` = 'Brian Clark' ,`ListOfficeName` = 'Angel Pro Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.718786' ,`Longitude` = '-95.356470' ,`PhotoCount` = '17' ,`PostalCode` = '77004' ,`RoomCount` = '5' ,`ListPrice` = '359900.00' ,`Status` = 'Active' ,`StreetName` = 'Ruth' ,`StreetNumber` = '3548' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment Opportunity! 5 bedrooms and 2 FULL baths, open concept kitchen.  Lots of natural light, 5th bedroom could be office/flex room. Hardwoods and ceramic.  Large backyard.\r\nLeased until August 2023!\r\nDO NOT DISTURB TENANTS!!' ,`Acres` = '0.14' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 2 CANFIELD OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canfield Oaks' ,`TaxAmount` = '5833' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700938' WHERE `Matrix_Unique_ID` = '211240237'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T11:49:50.647' ,`MLSNumber` = '57045043' ,`ListAgentFullName` = 'Shawn Speer' ,`ListOfficeName` = '7th Generation Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.209379' ,`Longitude` = '-95.750782' ,`PhotoCount` = '5' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '593990.00' ,`Status` = 'Active' ,`StreetName` = 'Kimber Lane' ,`StreetNumber` = '41602' ,`StreetSuffix` = '' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2723' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Our Lantana plan is perfectly designed to meet all your wishes for Your new home. 4 bedrooms or 3 bedrooms with an optional study. with an open floor plan concept. Your new home is accented with lots of selections including granite in all bathrooms. The owner’s retreat is perfect with a garden tub and a large walk in shower, split vanities and 2 large walk in closets with lots of storage. You are greeted by a solid Mahogany front door with high ceilings as you enter your new home. The open concept kitchen features 36\" 5 burner gas cooktop with built in microwave, oven and dishwasher. The large kitchen island is the perfect gathering spot of family time. The covered back porch provides the perfect spot for cooking out and entertaining. Lots of parking in your 1 car and 2 car garages with extra storage areas. Magnolia ISD and NO MUD TAX!' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'Harrisburg Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '4/2/11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA ELEMENTARY SCHOOL (MAGNOLIA)' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mostyn Manor' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700938' WHERE `Matrix_Unique_ID` = '211433128'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T10:30:32.180' ,`MLSNumber` = '37792782' ,`ListAgentFullName` = 'Natalie Nguyen' ,`ListOfficeName` = 'ABSOLUTE Realty Group Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771002' ,`Longitude` = '-95.371005' ,`PhotoCount` = '30' ,`PostalCode` = '77007' ,`RoomCount` = '6' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '1406' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2287' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NO HOA. Built by InTown Homes. Beautiful modern home with smart home features that include Nest Thermostats and August keyless entry. Spacious 3/3.5 free standing home in a Gated Community just minutes from Downtown and Medical Center. Gorgeous interior with bright recessed lightings. Has hardwood floors, tile, and carpet throughout. Soaring 12’ ceilings in living spaces, bright natural light can enter thru many windows. EcoHip energy savings include radiant roof barrier, 2021 Rinnai tankless water heater, and 2x6 exterior framing.' ,`Acres` = '0.0436' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Washington East/Sabine' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 HICKORY EDWARDS COMMONS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Hickory Edwards Commons' ,`TaxAmount` = '8942' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700939' WHERE `Matrix_Unique_ID` = '211643581'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T10:12:33.897' ,`MLSNumber` = '51178731' ,`ListAgentFullName` = 'Usman Toor' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.485734' ,`Longitude` = '-94.916226' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '3' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = '4th' ,`StreetNumber` = '641' ,`StreetSuffix` = 'Street' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom home located near to the bay, with beautiful bay water view from the upper balcony, home is recently upgraded with new paint, new flooring, new appliances, new ceiling fans, new METAL ROOF in year 2018 and much more, call today for more details!!!' ,`Acres` = '0.1469' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOTS 3 & 4 BLK 106 SAN LEON' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '3963' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700939' WHERE `Matrix_Unique_ID` = '211648393'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T10:56:05.833' ,`MLSNumber` = '6724076' ,`ListAgentFullName` = 'Jorge Tenorio' ,`ListOfficeName` = 'Maxima Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.938755' ,`Longitude` = '-95.255612' ,`PhotoCount` = '26' ,`PostalCode` = '77396' ,`RoomCount` = '8' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Tracelawn' ,`StreetNumber` = '9231' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2940' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 4/5 Bedroom, 2.5 bathroom, 2 car garage, 2-story home with master suite on the first floor. Open floor plan that has been freshly painted, with beautiful wood and tile flooring in the great room, kitchen and wet areas. This home has so much to offer! If you are looking for a spacious home with 4 to 5 bedrooms, a formal dining, formal living, a huge game room, with a small office, master suite on the first floor with a master bathroom offering double vanities, and a separate bath tub and shower. Look no further! Book your showing today! Broker does not guarantee the accuracy of room dimensions, home sqft, and condition of the home. Buyer is recommended to do all due diligence to verify any information obtained in the listing and other information given for this home.' ,`Acres` = '0.1264' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 42 BLK 2 CANYON VILLAGE AT PARK LAKES SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Village at Park Lakes' ,`TaxAmount` = '6491' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700939' WHERE `Matrix_Unique_ID` = '211650498'  --> Updated record success<br />