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-27T09:38:59.927' ,`MLSNumber` = '40396475' ,`ListAgentFullName` = 'Jewel McElreath' ,`ListOfficeName` = 'Reyes Realty Group, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.512074' ,`Longitude` = '-95.408490' ,`PhotoCount` = '24' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '1300000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 58' ,`StreetNumber` = '2883' ,`StreetSuffix` = '' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS A PRIME PIECE OF COMMERCIAL PROPERTY.....THERE IS NO HOA...OR MUD.....  5.97+/- ACRES, THIS PROPERTY IS IDEALLY SUITED FOR A NEW BUSINESS.  ONE OF THE FASTEST-GROWING AREAS IN MANVEL, HIGH TRAFFIC AREA,  THE PROPERTY IS CLOSE TO NEW HOPE CHURCH AND THE NEW ADDITIONS OF  DEL BELLO LAKES,  BLUEWATER ESTATES, NEWPORT, POMONA, AND RODEO PALMS.  THE AGENT IS RELATED TO THE SELLER.   ROOM MEASUREMENTS ARE APPROX PLEASE VERIFY.' ,`Acres` = '5.97' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0563 H T & B R R TRACT 30A ACRES 5.9701' ,`LotDesciption` = 'Cleared' ,`LotSize` = '260058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHADOW CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '8191' ,`TaxRate` = '2.8848' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703612' WHERE `Matrix_Unique_ID` = '188106051'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T09:17:00.610' ,`MLSNumber` = '95253983' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.561658' ,`Longitude` = '-96.227973' ,`PhotoCount` = '41' ,`PostalCode` = '77845' ,`RoomCount` = '16' ,`ListPrice` = '1114000.00' ,`Status` = 'Active' ,`StreetName` = 'Spanish Bay' ,`StreetNumber` = '5105' ,`StreetSuffix` = 'Court' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4475' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This Mariott home on a quiet, wooded lot in Pebble Creek backs to green space. Elegant foyer w/ crystal chandelier & oak entry doors welcome you in. Open living room w/stone fireplace has entry to the galley kitchen, extended island w/eating bar, granite countertops & workspace, & the walk-in pantry provides extra storage. The formal dining room features bay windows & arched doorways. A stately master suite includes double vanities, jetted garden tub, & walk-in shower. The master closets are immense w/luxury built-ins & a full-size window. An office off the foyer has bay windows & easy access to a half bath. The utility room includes a sink, great storage, & space for extra appliances. Through French doors upstairs is the Media Room w/ wet bar & seating.  Four sizable bedrooms, one being used as an office, allow space for exercise equipment. Outside is an inviting covered patio overlooking the vast lawn & wooded side yard. Entertain at the sparkling pool w/grotto & waterfall.' ,`Acres` = '0.8236' ,`Area` = '61' ,`BuilderName` = 'Marriott Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PEBBLE CREEK PH 7A, BLOCK 43, LOT 36' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '35876' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'PEBBLE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'A & M CONSOLIDATED MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pebble Creek Ph 7a' ,`TaxAmount` = '16579' ,`TaxRate` = '2.2433' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703612' WHERE `Matrix_Unique_ID` = '207951282'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T08:43:41.263' ,`MLSNumber` = '28148663' ,`ListAgentFullName` = 'Salvador Caballero' ,`ListOfficeName` = 'ListWithFreedom.com' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.961079' ,`Longitude` = '-95.256457' ,`PhotoCount` = '6' ,`PostalCode` = '75766' ,`RoomCount` = '5' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Edgewood' ,`StreetNumber` = '1024' ,`StreetSuffix` = 'Drive' ,`City` = 'Jacksonville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has been completely renovated/updated and is move-in ready! \r\nIt has a new roof (2021), paint, landscaping, kitchen, bathrooms, light fixtures, hw heater, flooring/hardwoods refinished.\r\nUpdates have been made to electrical and plumbing; large fenced yard; kitchen appliances stay.\r\nYou must see!' ,`Acres` = '0.31' ,`Area` = '76' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 23 BLK 2 & 24A HILLCREST - CITY OF JACKSONVILLE' ,`LotDesciption` = 'Other' ,`LotSize` = '13499' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '106 - Jacksonville' ,`SchoolElementary` = '' ,`SchoolHigh` = 'JACKSONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'JACKSONVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Hillcrest' ,`TaxAmount` = '2471' ,`TaxRate` = '2.5884' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663703612' WHERE `Matrix_Unique_ID` = '209462500'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T09:00:57.200' ,`MLSNumber` = '89822859' ,`ListAgentFullName` = 'Cierra Manney' ,`ListOfficeName` = 'BuyBroker' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825103' ,`Longitude` = '-95.400367' ,`PhotoCount` = '7' ,`PostalCode` = '77018' ,`RoomCount` = '2' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Allston' ,`StreetNumber` = '4210' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION Location L O C A T I O N !!!\r\nThis is a rare opportunity to get in this super HOT neighborhood. \r\n5,250+ sft lot,  0.8 mi from 610 Loop, Whole Foods Market, surrounded by new high-end construction. Reno or new construction value add.\r\nPresent your offer. This will NOT last long.' ,`Acres` = '0.1205' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 & TR 19B BLUEBERRY TERRACE ABST 94 S W ALLEN' ,`LotDesciption` = 'Other' ,`LotSize` = '5250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Built Up' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KENNEDY ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'WILLIAMS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'BLUEBERRY TERR ABST 94 S W ALLEN' ,`TaxAmount` = '1149' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703612' WHERE `Matrix_Unique_ID` = '210309544'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T09:16:30.067' ,`MLSNumber` = '28564873' ,`ListAgentFullName` = 'Brandon Warren' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751435' ,`Longitude` = '-95.524597' ,`PhotoCount` = '49' ,`PostalCode` = '77024' ,`RoomCount` = '12' ,`ListPrice` = '2000000.00' ,`Status` = 'Active' ,`StreetName` = 'Bylane' ,`StreetNumber` = '201' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4985' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL custom home situated on an expansive corner lot in the heart of Memorial, large motor court with circle drive, electric driveway gate and plenty of privacy. Inviting entry courtyard, lush landscape and custom iron front door. As you enter this impressive property an abundance of natural light and neutral colors surround you. Rich wood floors, an open plan offering a library, both formal living & dining areas (seating for up to 10+),expansive family room with stunning entertainment center,generous gourmet kitchen w/ commercial grade appliances,walk in pantry,island,break bar and breakfast area with gorgeous pool views. Primary suite at 2nd floor w/ fireplace, spa-like primary bath w/ generous closet,dressing area & storage, game room, large guest/secondary bedrooms,BREATHTAKING backyard resort! Custom pool with waterfall, sprawling outdoor covered living space with summer kitchen and fireplace,green space for pets and/or play area, privacy and plenty of guest parking.' ,`Acres` = '0.5651' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BYLANE ESTATES' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '24616' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bylane Estates' ,`TaxAmount` = '42143' ,`TaxRate` = '2.1656' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703612' WHERE `Matrix_Unique_ID` = '210599086'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T09:35:05.043' ,`MLSNumber` = '2396434' ,`ListAgentFullName` = 'Adriana Perez' ,`ListOfficeName` = 'Keller Williams Realty         - Clear Lake/ NASA' ,`SellingAgentFullName` = 'Adriana Perez' ,`SellingOfficeName` = 'Keller Williams Realty         - Clear Lake/ NASA' ,`Latitude` = '29.607354' ,`Longitude` = '-95.357275' ,`PhotoCount` = '31' ,`PostalCode` = '77047' ,`RoomCount` = '4' ,`ListPrice` = '330000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Kelsey Trail' ,`StreetNumber` = '3919' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning 2 story home located in the sought-after Brunswick Lakes near the Medical center and Beltway 8. This 4-bedroom, 2 1/2 - bathroom home with a two car garage boasts an inviting floor plan and spaciousness in all of the living areas, kitchen, bedrooms, and game room. As you walk into the home you will notice the convenient and open floor plan and tile throughout the living areas. The exterior features a beautifully manicured front lawn and backyard. Call today to schedule your viewing appointment!' ,`Acres` = '0.132' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 1 BRUNSWICK LAKES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5751' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LAW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Brunswick Lakes' ,`TaxAmount` = '6017' ,`TaxRate` = '2.6498' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703612' WHERE `Matrix_Unique_ID` = '210657286'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T08:35:35.060' ,`MLSNumber` = '97034404' ,`ListAgentFullName` = 'Ken Lewis' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643270' ,`Longitude` = '-95.357567' ,`PhotoCount` = '18' ,`PostalCode` = '77047' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Duane' ,`StreetNumber` = '10702' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'FOUNDATION REPAIRES FLOORING GOING BACK DOWN BE CAREFUL .HOUSE WAS GUTTED AND REBUILT NEW ELECTRICAL, PLUMBING, FIXTURES, BATHROOMS, NEW KITCHEN WITH NEW APPLIANCES ISLAND  WITH GRANITE COUONTERS 3 FULL BATHS 3 BEDROOM WITH 2 PRIMARY BEDROOMS, NEW A/C, HEAT. JUST MIVE IN. HARDI PLANK SIDING NEW PAINT IN AND OUT.' ,`Acres` = '0.1735' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 25 BLK 5 SOUTH ACRES ESTATES SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7558' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'South Acres Estates Sec 05' ,`TaxAmount` = '2494' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703613' WHERE `Matrix_Unique_ID` = '210811793'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T08:01:36.463' ,`MLSNumber` = '75323954' ,`ListAgentFullName` = 'Diane Elaine Andrews' ,`ListOfficeName` = 'New Vision Realty' ,`SellingAgentFullName` = 'Michael Ellis' ,`SellingOfficeName` = 'Metropolitan Properties, USA' ,`Latitude` = '29.638887' ,`Longitude` = '-95.349238' ,`PhotoCount` = '17' ,`PostalCode` = '77048' ,`RoomCount` = '8' ,`ListPrice` = '195000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Murr Way' ,`StreetNumber` = '11015' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1474' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great One Story 3 Bedroom 1.5 Renovated Home With Covered Front Entry. Beautiful New Designer Gray Interior Paint Throughout Makes For a Light & Bright Decor. New Exterior Paint. Beautiful New Gray Carpet Throughout. White Kitchen Cabinets Making A Light & Bright Kitchen. New Stainless Steel LG Refrigerator Included. New Gas Stove Included. New Ceiling Fans, New Lighting And New Toilet In Primary Bathroom. Primary Bedroom Has A Half Bathroom. Garage Converted To Den Area For Added Living Space. Breakfast Bar Off Kitchen For Extra Dining. Large Utility Room Conveniently Located Off Kitchen. Large Covered Patio In Large Backyard. Extra Concrete Slab In Backyard For A Storage Building or Bar B Q Area.  Easy Access To Fwy 288, 610 Fwy And Sam Houston Tollway. Conveniently Located To Texas Medical Center, Downtown/Midtown And NRG Stadium.' ,`Acres` = '0.1768' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 5 CRESTMONT PLAZA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crestmont Plaza' ,`TaxAmount` = '1904' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703613' WHERE `Matrix_Unique_ID` = '210831515'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T08:21:03.530' ,`MLSNumber` = '23813352' ,`ListAgentFullName` = 'Lindsey Smithson' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.294260' ,`Longitude` = '-95.412915' ,`PhotoCount` = '33' ,`PostalCode` = '77301' ,`RoomCount` = '11' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Tulip Poplar' ,`StreetNumber` = '2907' ,`StreetSuffix` = 'Trail' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Come take a look at the beautiful two-story home that is less than two years old. Featuring FOUR good sized bedrooms, TWO large living spaces(one up and one down), an OFFICE, and THREE full bathrooms(plus a half)! Upon entry, you will find the private office just to the left. If you keep going, the dining room connects into the gorgeous kitchen. It is open to the living area which boasts a gaslog fireplace, vaulted ceilings and several windows keeping the home light and bright. Also downstairs is the primary bedroom. This great sized room has an ensuite with a large standup shower, double sinks, and a walk-in closet. Upstairs, the game room is located at the top of the stairs. In addition, you will find two bedrooms that share a Jack and Jill bathroom and another bedroom and full bathroom! The utility room is conveniently located upstairs. Outside, relax under the covered back patio and enjoy the large corner lot! You are just minutes from I-45 and Carl Barton\'s Park!' ,`Acres` = '0.1897' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S249602 - BARTON CREEK RANCH 02, BLOCK 2, LOT 21' ,`LotDesciption` = 'Corner' ,`LotSize` = '8264' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'RUNYAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barton Creek Ranch 02' ,`TaxAmount` = '7049' ,`TaxRate` = '2.7863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663703613' WHERE `Matrix_Unique_ID` = '211740627'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T09:50:57.580' ,`MLSNumber` = '43853990' ,`ListAgentFullName` = 'Laura Domingue' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.946640' ,`Longitude` = '-95.727461' ,`PhotoCount` = '34' ,`PostalCode` = '77433' ,`RoomCount` = '8' ,`ListPrice` = '520000.00' ,`Status` = 'Active' ,`StreetName` = 'Canosa' ,`StreetNumber` = '17026' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2485' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This pristine Craftsman style David Weekly home in Bridgeland\'s Lakeland Heights has many upgrades for the discerning buyer. Graciously proportioned rooms with an open floor plan, spacious living and dining rooms, high ceilings and plenty of windows for natural light. The kitchen has stainless appliances, lots of cabinets and a large island for entertaining. The first floor Primary Bedroom has an en suite bath featuring an extra-large tiled shower, double sinks, large vanity and walk-in closet. Upstairs has a flex space that can be used as a secondary home office, game room or den. There are two additional bedrooms upstairs with a tub/ shower bath, double sinks and large vanity. Bridgeland has many amenities, parks, lakes and green space, that include resort-style activity centers, pools, splash pads, sports courts and more. Convenient to shopping and restaurants. This is a great place to call home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'David Weekly Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 BRIDGELAND LAKELAND HEIGHTS SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Bridgeland Lakeland Heights' ,`TaxAmount` = '9997' ,`TaxRate` = '3.4329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703613' WHERE `Matrix_Unique_ID` = '211760010'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-27T08:55:32.527' ,`MLSNumber` = '92363898' ,`ListAgentFullName` = 'Jose Portillo' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.700179' ,`Longitude` = '-95.272995' ,`PhotoCount` = '28' ,`PostalCode` = '77017' ,`RoomCount` = '6' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Dalton' ,`StreetNumber` = '2815' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated house!!! Updated kitchen!!! Updated bathrooms!!! Updates include kitchen cabinets, granite counter, appliances, interior and exterior paint, lights, spotlights, luxurious waterproof vinyl laminate flooring, carpet, doors, baseboards, and many more.' ,`Acres` = '0.1561' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 2A BLK 5 PARK PLACE ACRE VILLA' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Park Place Acre Villa' ,`TaxAmount` = '4078' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663703613' WHERE `Matrix_Unique_ID` = '211863377'  --> Updated record success<br />