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-22T19:28:07.613' ,`MLSNumber` = '40975337' ,`ListAgentFullName` = 'Veronica Gallegos' ,`ListOfficeName` = 'Troy Giles Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518472' ,`Longitude` = '-95.447040' ,`PhotoCount` = '21' ,`PostalCode` = '77545' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Dogwood' ,`StreetNumber` = '519' ,`StreetSuffix` = 'Avenue' ,`City` = 'Fresno' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Stucco & Brick Home with country style living has easy access to Downtown Houston.  This stunning and spacious 3 bedroom 2 1/2 bath with office/study/bedroom has amazing travertine floors throughout most of the home while some bedrooms enjoy wood flooring.  The spacious kitchen has granite counter tops, a built in microwave, island kitchen and tiled back splash with a place for informal dining while also including a formal dining area allowing for those special occasions.  Downstairs primary bedroom with attached bathroom has plenty of space for it\'s own vanity and double sinks along with a walk in shower and jacuzzi tub which makes for an unforgettable spa type experience.  Oversized upstairs room is a great family room with it\'s own balcony that allows for memorable family time enjoying the outdoors.' ,`Acres` = '0.2255' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'RIDGEWOOD ESTATES, BLOCK 31, LOT 20' ,`LotDesciption` = 'Other' ,`LotSize` = '9822' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'BAINES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Ridgewood Estates' ,`TaxAmount` = '' ,`TaxRate` = '2.7629' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701821' WHERE `Matrix_Unique_ID` = '205391182'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:03:14.227' ,`MLSNumber` = '36667506' ,`ListAgentFullName` = 'Lisa Baer' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712945' ,`Longitude` = '-95.434931' ,`PhotoCount` = '33' ,`PostalCode` = '77005' ,`RoomCount` = '15' ,`ListPrice` = '2349999.00' ,`Status` = 'Active' ,`StreetName` = 'Ingold' ,`StreetNumber` = '3727' ,`StreetSuffix` = 'Street' ,`City` = 'Southside Place' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this fabulous Southside Place home perfect for family living & entertaining indoors & outdoors with open flowing floor plan, soaring ceilings & sparkling pool. Stately paneled study, gracious formal living &dining rooms and wet bar. Chef\'s kitchen with stainless steel appliances, (Sub Zero refrigerator, Wolf gas range with griddle & double ovens below), breakfast bar, ample countertop and cabinet space opens to pretty breakfast room and spacious family room overlooking the fabulous backyard with pretty pool and covered porch with summer kitchen. Upstairs features lavish primary suite with sitting area, fireplace, and large spa style bath with wonderful vanity area and two huge closets. Three additional en suite bedrooms & large game room upstairs. So many extras including: beautiful hardwood floors, mud room, 3 fireplaces, paver driveway, large utility room & great storage. Near Firetruck Park, Southside Place community garden, West U ball fields, and Milk & Cookies.' ,`Acres` = '0.1607' ,`Area` = '17' ,`BuilderName` = 'Richmark' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'West University/Southside Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 28 BLK 11 SOUTHSIDE PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WEST UNIVERSITY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southside Place' ,`TaxAmount` = '49173' ,`TaxRate` = '2.0986' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2009' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701821' WHERE `Matrix_Unique_ID` = '207021300'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:54:32.187' ,`MLSNumber` = '4851692' ,`ListAgentFullName` = 'Ashiqul Talukder' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.869535' ,`Longitude` = '-95.732338' ,`PhotoCount` = '49' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Founding' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2202' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIUEYS TO VEFRIFY ALL ROOM DIMOANSONS. GORGEOUS 4 BEDROOM, 2.5 BATHROOM, TWO STORY HOME LOCATED IN THE CY-FAIR SCHOOL DISTRICT. SPACIOUS, OPEN FLOOR-PLAN DESIGN WITH INSULATED WINDOWS & AN ABUNDANCE OF NATURAL LIGHT. SELLERS SPENT OVER $20,000 IN RECENT UPGRADES. CARPET WILL BE REPLACED. NEW INTERIOR PAINT. CEILING FANS, A LOVELY BACKYARD. MAKE THIS YOUR \"HOME SWEET HOME!\"' ,`Acres` = '0.1263' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 14 SETTLERS VILLAGE SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '318' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WALKER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'ROWE MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Settlers Village Sec 02' ,`TaxAmount` = '5708' ,`TaxRate` = '2.831' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701821' WHERE `Matrix_Unique_ID` = '209041768'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:41:58.197' ,`MLSNumber` = '71719629' ,`ListAgentFullName` = 'Jenny Ashley' ,`ListOfficeName` = 'White Label Realty' ,`SellingAgentFullName` = 'Crystal Dietert' ,`SellingOfficeName` = 'Coldwell Banker Properties' ,`Latitude` = '29.930813' ,`Longitude` = '-96.645700' ,`PhotoCount` = '38' ,`PostalCode` = '78940' ,`RoomCount` = '5' ,`ListPrice` = '275000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sandy' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Lane' ,`City` = 'Fayetteville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1795' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Conveniently located 13 miles from Fayetteville Lake and 16 miles from Round Top this adorable 1,795 sq ft home sits on .7 low-maintenance acres. Featuring 3BDR - 2 BTH, 2 living rooms, 2 large statement fireplaces, a wet bar, and mature trees throughout the yard! A large amount of natural lighting is provided from the windows throughout the home. With endless interior details from the trim work to accent walls to chandeliers, this is a must-see!' ,`Acres` = '0.7058' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A137 BARRIER J G,0.7058 ACRES,HSE, STG' ,`LotDesciption` = 'Other' ,`LotSize` = '30744' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '204 - Fayetteville' ,`SchoolElementary` = 'FAYETTEVILLE HIGH SCHOOL' ,`SchoolHigh` = 'FAYETTEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'FAYETTEVILLE HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'None' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663701821' WHERE `Matrix_Unique_ID` = '210512786'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:44:20.327' ,`MLSNumber` = '65777217' ,`ListAgentFullName` = 'Ken Luu' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681755' ,`Longitude` = '-95.483872' ,`PhotoCount` = '29' ,`PostalCode` = '77096' ,`RoomCount` = '8' ,`ListPrice` = '369988.00' ,`Status` = 'Active' ,`StreetName` = 'Birdwood' ,`StreetNumber` = '5475' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1710' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TENANT JUST MOVED OUT. WE ARE IN THE PROCESS GETTING THE KEY. PLEASE WAI FOR ANOTHER FEW DAYS TO SHOW. 06/08/2022... WOW, CHARMING 3-4 bedroom 2 full bathroom single family home located in the heart of Meyer land area. Hurry up! This home will not last long; Easy access to Medical Center, Galleria shopping Mall, Meyer land Plaza, Rice University and downtown; GREAT LOCATION, Near to the zoned prestigious Herod Elementary & Bellaire High School! REMODELING THROUGHOUT: gorgeous full new wood floor, doors, texture painting, new trims, kitchen and bathrooms. Double pane Energy Star windows, TRANE Air conditioner, and new insulation LOWER ENERGY BILLS greatly and SAVE YOU MONEY; The pre-wired formal living room or study room has the potential becoming a Media room for HD movie and Karaoke or a game room or , it also could be a guest bedroom or 4th bedroom. The master bedroom has a nice walk-in closet. Its shower stalls with a sitting area.' ,`Acres` = '0.1843' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 12 MAPLEWOOD SEC 13' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8030' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '50' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Maplewood Sec 13' ,`TaxAmount` = '6977' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '210702870'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:57:33.513' ,`MLSNumber` = '71890272' ,`ListAgentFullName` = 'Peggy Caldwell' ,`ListOfficeName` = '2P\'s Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.229970' ,`Longitude` = '-95.719978' ,`PhotoCount` = '18' ,`PostalCode` = '77354' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Ravenswood' ,`StreetNumber` = '16214' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1984' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location.....and.....UNRESTRICTED!! This home is located so close to Magnolia, Montgomery, Conroe, Tomball and more. This is a 4 bedroom house on approximately 3/4 of an acre. We have trees, plenty of parking, oversized steel frame garage, 2 car carport and possibility of access on the back side of lot 74. Septic was pumped in 2020, Vivint equipment stays with the house and seller has HVAC system serviced regularly. Do you want to work from home? This is a great opportunity for you to live and work all in one place. Oversized garage is ready for electric to be connected, has plumbing and is huge! Call me today to arrange a private showing.' ,`Acres` = '0.69' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PINE VISTA MH VILLAGE LT 73 & 74, ACRES 0.69' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30492' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pine Vista Mh Village' ,`TaxAmount` = '2377' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '210825752'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:37:10.840' ,`MLSNumber` = '25321621' ,`ListAgentFullName` = 'Jenny Ashley' ,`ListOfficeName` = 'White Label Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.255087' ,`Longitude` = '-96.975519' ,`PhotoCount` = '30' ,`PostalCode` = '78948' ,`RoomCount` = '7' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 8022' ,`StreetNumber` = '1093' ,`StreetSuffix` = '' ,`City` = 'Lincoln' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2,480 sq ft, custom-built modern farmhouse exudes luxury while providing a sense of comfort that allows you to walk in and feel right at home! Enter through the modern glass front door and be wowed by the 32x32\" tile floors, vaulted ceiling, and the sleek, electric fireplace in the living room. Or, perhaps you\'ll be drawn to the expansive kitchen island with quartz countertops and gas range, custom cabinetry, under-mount sink, or large picture windows that provide a view of the serene, 2.67-acre property. The high-end style is sure to impress family and guests who can enjoy the closeness afforded by the open kitchen, living, and dining space. The spacious owner\'s suite features a palatial walk-in closet with a window, and a modern bathroom with separate tub and sized closet complete the downstairs. A bonus living/play area or secluded office space is upstairs and can be used however best suits your needs.' ,`Acres` = '2.67' ,`Area` = '70' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '2.67 ACRES Part of A016 PRICE, J., TRACT 015, ACRES 7.67' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '189 - Giddings' ,`SchoolElementary` = 'GIDDINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GIDDINGS HIGH SCHOOL' ,`SchoolMiddle` = 'GIDDINGS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '211008902'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:06:49.953' ,`MLSNumber` = '41861839' ,`ListAgentFullName` = 'Karina Franco' ,`ListOfficeName` = 'All City Real Estate, Ltd. Co.' ,`SellingAgentFullName` = 'Kazi Kader' ,`SellingOfficeName` = 'Exceed Realty' ,`Latitude` = '29.819455' ,`Longitude` = '-95.688634' ,`PhotoCount` = '26' ,`PostalCode` = '77084' ,`RoomCount` = '7' ,`ListPrice` = '335000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Barkers Run' ,`StreetNumber` = '3539' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2137' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to 3539 Barkers Run Dr. Nestled in the desirable Barkers Trail community. Beautiful 2-story stone front, 3 BD/2.5 bath home. Plenty of space for your family to enjoy game nights in the spacious game room or cooking dinners in this open concept kitchen which features an upgraded backsplash, granite countertops and 42\" kitchen cabinets w/ stainless steel appliances. Features tile throughout the first floor, carpet on the second where all bedrooms, game room and washer and dryer are located. Beautiful arches featured at entrances throughout the house, gourmet kitchen, granite countertops and metal stair rails are just some of the upgrades. Primary bedroom with ensuite bathroom, his/hers walk-in closets. Backyard upgraded with extended patio and enough room to build a pool. Short walk away from Cullen Park, with 3-miles of walking/biking trails, picnic areas, and baseball/soccer fields. Easy access to I-10, Low HOA fee. Zoned to the highly-acclaimed Katy ISD. Never flooded.' ,`Acres` = '0.1168' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 12 BLK 2 BARKERS TRAIL SEC 4' ,`LotDesciption` = 'Other' ,`LotSize` = '5088' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '385' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Barkers Trail Sec 4' ,`TaxAmount` = '5862' ,`TaxRate` = '2.587' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '211137044'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T19:36:18.483' ,`MLSNumber` = '27890834' ,`ListAgentFullName` = 'Lois De Armas' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.993411' ,`Longitude` = '-95.235442' ,`PhotoCount` = '50' ,`PostalCode` = '77541' ,`RoomCount` = '4' ,`ListPrice` = '430000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Water' ,`StreetNumber` = '4407' ,`StreetSuffix` = 'Highway' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '690' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TRIPLE Investment Opportunity! Well-maintained beach house includes lots on each side! 22,500sf total for all 3 lots. Enjoy panoramic views of ocean & Drum Bay from decked balconies! Decks replaced 2016! Conveniently located between 2 public beach access roads & close to boat pier/ramp on bay side. Plenty of guest parking. Large storage area w/cabinet storage & half bath! Enclosed outdoor shower w/hot & cold water! Exterior freshly stained! Aluminum roof 2010! Stairs replaced 2018! Updated DBL pane windows! 2012-interior gutted & updated w/beadboard + kitchen cabinets & appliances! 2016 water well replaced! Sewage-2019 leech lines expanded!  Vinyl plank flooring thru-out interior! Open living & kitchen area! 2 bedrooms each w/closets & ceiling fans! Bathroom has tiled shower w/built-in shelves. Enjoy beautiful sunsets from the rear balcony across the entire length of the home. The furniture is included. No HOA. Interior of home never flooded per seller. Low taxes! MUST SEE! MUST HAVE!' ,`Acres` = '0.1722' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SAN LUIS BEACH (A0029 S F AUSTIN), BLOCK 2, LOT 17' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '7501' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'San Luis Beach' ,`TaxAmount` = '2276' ,`TaxRate` = '1.9981' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '211332294'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T19:17:32.353' ,`MLSNumber` = '61681970' ,`ListAgentFullName` = 'Freeman Utley' ,`ListOfficeName` = 'World Wide Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.915956' ,`Longitude` = '-95.570648' ,`PhotoCount` = '19' ,`PostalCode` = '77064' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Sand Pass' ,`StreetNumber` = '10142' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning and UPDATED home is situated on a large Cul-De-Sac in a well-established area of Winchester Country subdivision with no neighbors to the right.Quick commute to SH 290, Beltway 8, SH 249, restaurants, Kroger, Sam\'s Club, Willowbrook Mall, Methodist Hospital. In highly rated Cy-Fair ISD.Entering the home, you have your office/den on the left which can be converted to a bedroom that connects to the kitchen by a full bathroom; great flexibility to be defined as you wish. The living room is on the right with a real wood fireplace.The fabulous kitchen with flat cook-tops opens to the breakfast area and the dining room.Primary bedroom with a walk-in closet and an adjacent second closet for storage.Your family and friends will enjoy the large private backyard with a large deck covered by an expansive pergola and lighting. There is even a bonus storage shed for your lawnmower, trashcan and tools so that your garage may hold two vehicles without surrounding clutters. NEVER FLOODED!' ,`Acres` = '0.1166' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 1 WINCHESTER COUNTRY SEC 6' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5080' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Winchester Country Sec 06' ,`TaxAmount` = '4058' ,`TaxRate` = '2.641' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '211535449'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-22T18:38:16.543' ,`MLSNumber` = '72826748' ,`ListAgentFullName` = 'Rick Trevino' ,`ListOfficeName` = 'Loyal Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232961' ,`Longitude` = '-95.156962' ,`PhotoCount` = '7' ,`PostalCode` = '77372' ,`RoomCount` = '1' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2090' ,`StreetNumber` = '26290' ,`StreetSuffix` = 'Road' ,`City` = 'Splendora' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Thank you so much for viewing. Property is 1 acre of land and can be used as commercial or residential. Open up your own business in the busy stretch of FM 2090 with Peachcreek and Splendora Elementary School across the street!! Quick access to Hwy 59 and the Grand Pkway!' ,`Acres` = '1' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'A0082 - BARKER WM, TRACT 4, ACRES 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'William R Barker Surv Tract 4' ,`TaxAmount` = '1053' ,`TaxRate` = '2.4206' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701822' WHERE `Matrix_Unique_ID` = '211706002'  --> Updated record success<br />