Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:53:50.900' ,`MLSNumber` = '79434619' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.990520' ,`Longitude` = '-95.443695' ,`PhotoCount` = '28' ,`PostalCode` = '77090' ,`RoomCount` = '7' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Old Dock' ,`StreetNumber` = '14310' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2371' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1515' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 3 EAGLE LANDING SEC 3' ,`LotDesciption` = 'Other' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (SPRING)' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'BAMMEL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Lndg Sec 03' ,`TaxAmount` = '5561' ,`TaxRate` = '2.9767' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707017' WHERE `Matrix_Unique_ID` = '205726533'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:54:44.253' ,`MLSNumber` = '5087532' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.545664' ,`Longitude` = '-95.347287' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '7' ,`ListPrice` = '374900.00' ,`Status` = 'Active' ,`StreetName` = 'Hampton' ,`StreetNumber` = '3511' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2550' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1969' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHDOWN S/D, BLOCK 5, LOT 14 SEC 3, A0310 H T & B' ,`LotDesciption` = 'Other' ,`LotSize` = '8577' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'SILVERLAKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GLENDA DAWSON HIGH SCHOOL' ,`SchoolMiddle` = 'BERRY MILLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southdown Sub' ,`TaxAmount` = '6311' ,`TaxRate` = '2.5552' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707017' WHERE `Matrix_Unique_ID` = '205728026'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:55:44.063' ,`MLSNumber` = '39866142' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.036329' ,`Longitude` = '-95.581940' ,`PhotoCount` = '28' ,`PostalCode` = '77375' ,`RoomCount` = '7' ,`ListPrice` = '419900.00' ,`Status` = 'Active' ,`StreetName` = 'Lantern Cove' ,`StreetNumber` = '18854' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3460' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1309' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein/Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 2 MEMORIAL SPRINGS SEC 12' ,`LotDesciption` = 'Other' ,`LotSize` = '5700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '430' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (KLEIN)' ,`SchoolHigh` = 'KLEIN CAIN HIGH SCHOOL' ,`SchoolMiddle` = 'ULRICH INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Memorial Spgs Sec 12' ,`TaxAmount` = '6216' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707017' WHERE `Matrix_Unique_ID` = '205937950'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:08:18.670' ,`MLSNumber` = '37986401' ,`ListAgentFullName` = 'Eric Malak' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692583' ,`Longitude` = '-95.134088' ,`PhotoCount` = '34' ,`PostalCode` = '77536' ,`RoomCount` = '11' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Wildwood' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Drive' ,`City` = 'Deer Park' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully remodeled house with modern finishes in the highly desirable Erin Glen subdivision! Large 3 bedroom, 2.5 bathroom house plus a study or extra room and a game room! This house is move-in ready and includes the following upgrades: brand new roof, 2 brand new 3.5 ton HVAC condensers, fresh paint in the interior and exterior, new luxury vinyl plank flooring, all new light fixtures, all new hardware, brand new stainless steel appliances, new backyard fence (65\'), upgraded Sparkling White Quartz countertops in kitchen and bathrooms, new backsplash, new shower pan, new bathtub, and new soaking tub! Also equipped with an upstairs laundry chute!' ,`Acres` = '0.1746' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Deer Park' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 ERIN GLEN SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7605' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'SAN JACINTO ELEMENTARY SCHOOL (DEER PARK)' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'DEER PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Erin Glen Sec 08' ,`TaxAmount` = '6586' ,`TaxRate` = '2.8239' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707017' WHERE `Matrix_Unique_ID` = '207502410'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:40:32.220' ,`MLSNumber` = '22174146' ,`ListAgentFullName` = 'Bao Tran' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.363954' ,`Longitude` = '-95.608898' ,`PhotoCount` = '50' ,`PostalCode` = '77356' ,`RoomCount` = '7' ,`ListPrice` = '285000.00' ,`Status` = 'Active' ,`StreetName` = 'Springs Edge' ,`StreetNumber` = '113' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2365' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4/2.5 home with a large yard in resort community of April Sound.  This community has 24/7 security, 27 holes golf course (membership needed), country club, fitness center, swimming pools, boat launches and some more good stuff. All new fresh paint inside out. Kitchen has SS appliances with double oven and granite countertops. Roof and HVAC system were replaced in 2017.  Home has tons of natural lights. Tile in wet areas and wood laminate throughout. Ready to MOVE IN. \r\nCOME SEE IT TODAY!' ,`Acres` = '0.3029' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'APRIL SOUND 01, BLOCK 3, LOT 9, 8B, ACRES 0.316' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '13193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '219' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'April Sound' ,`TaxAmount` = '4462' ,`TaxRate` = '2.2525' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707017' WHERE `Matrix_Unique_ID` = '209508828'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T08:11:45.270' ,`MLSNumber` = '13158097' ,`ListAgentFullName` = 'Brian Collette' ,`ListOfficeName` = 'Ross & Marshall Realty' ,`SellingAgentFullName` = 'Ibrahim Zakhary' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.941600' ,`Longitude` = '-95.674511' ,`PhotoCount` = '35' ,`PostalCode` = '77095' ,`RoomCount` = '9' ,`ListPrice` = '395000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Buffalo Pass' ,`StreetNumber` = '17219' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2546' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 1 STORY, 4 BDRM, 2.5 BATH, FORMAL LIVING/DINING, 2 CAR GARAGE AND COVERED PATIO. SPACIOUS KITCHEN W/GRANITE COUNTERTOPS & 42\' MAPLE CABINETS, ALSO INCLUDES CERAMIC TILE BACKSPLASH W/ROMANGA-ARENA CUSTOM DESIGN LINER TRIM. TILE FLOORS EXTENDED ENTRY, KITCHEN & BREAKFAST. ENGINEERED WOOD FLOORING IN FAMILY ROOM. MAHOGANY FRONT DOOR W/LEADED GLASS, ON BEAUTIFUL LOT.GORGEOUS PLANTATION SHUTTERS THROUGHOUT HOME. SPRINKLER SYSTEM FRONT AND BACK.  HIGH CEILINGS AND ARCHED ENTRYWAY, COVERED PATIO WITH NO NEIGHBORS BEHIND. RIATA RANCH OFFERS PARKS, GOLF COURSE, COMMUNITY POOL AND IS CLOSE TO SCHOOLS IN THE CY-FAIR ISD. YOU WILL LOVE THIS HOME, COME SEE IT QUICK BEFORE IT\'S GONE. LISTING AGENT IS RELATED TO SELLERS.' ,`Acres` = '0.1612' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 54 BLK 1 RIATA RANCH SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7021' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '844' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Riata Ranch Sec 11' ,`TaxAmount` = '7383' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707017' WHERE `Matrix_Unique_ID` = '210448780'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T08:53:53.767' ,`MLSNumber` = '22418992' ,`ListAgentFullName` = 'Kendra Dempsey' ,`ListOfficeName` = 'Willow Haven Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.196848' ,`Longitude` = '-95.127062' ,`PhotoCount` = '50' ,`PostalCode` = '77372' ,`RoomCount` = '10' ,`ListPrice` = '539900.00' ,`Status` = 'Active' ,`StreetName` = 'Salado' ,`StreetNumber` = '27630' ,`StreetSuffix` = 'Court' ,`City` = 'Splendora' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2956' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Immaculate & traditional farm house located in the highly sought after acreage neighborhood of Rio Vista! This stunning home sits on 1 acre and features: large porch & covered back patio w/exposed wood slat ceiling; 4/5 bedrooms & 2 1/2 baths; country island kitchen w/granite counters, pot filler, SS appliances including the refrigerator, pantry & plenty of counter space; the primary retreat has an en-suite bath w/soaking tub, walk in shower, large closet w/built-ins & dual sinks; massive game room upstairs could be easily turned into a media room; hidden storage closet; wood look tile throughout the home except for the bedrooms; study could also be a 5th bedroom or workout room; utility room is spacious & has under stairs storage; backyard is fenced; the back covered patio is spacious enough to do an outdoor kitchen in the future; storage building has a roll up door and a side entry door w/electric run to it. Close to Hwy 59 & Hwy 99, Valley Ranch Town Center & Big Rivers Waterpark!' ,`Acres` = '1.02' ,`Area` = '40' ,`BuilderName` = 'Rebecca Soriano' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 1, LOT 67, ACRES 1.02' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Wooded' ,`LotSize` = '44431' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '7093' ,`TaxRate` = '1.9783' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707018' WHERE `Matrix_Unique_ID` = '210545613'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:29:10.023' ,`MLSNumber` = '31086739' ,`ListAgentFullName` = 'Robin Winans' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.430130' ,`Longitude` = '-95.496366' ,`PhotoCount` = '35' ,`PostalCode` = '77318' ,`RoomCount` = '6' ,`ListPrice` = '124950.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Manor' ,`StreetNumber` = '13070' ,`StreetSuffix` = 'Court' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is an amazing opportunity to own the largest lot in Pin Oak for a incredible price.  Needs some TLC but mostly cosmetic.  Great Location, minutes to Conroe and The Woodlands, and you can even walk to a major shopping center with restaurants and Kroeger Grocery Store. Only 20 minutes to Huntsville.  Has a 20x20 Metal Carport, almost 1/2 acre fenced back yard.  Great layout with Master Bedroom and Bathroom on opposite side of house. Master Bathroom is huge with separate vanityies, two walk in closets and the biggest garden bathtub! Master also has a separate shower area.  Great Investment to fix and hold or fix and sell.' ,`Acres` = '0.4615' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S785900 - PIN OAK 01, BLOCK 2, LOT 8, SERIAL # SHA02793AB, T' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '20104' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '220' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Pin Oak 01' ,`TaxAmount` = '3082' ,`TaxRate` = '2.4131' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707018' WHERE `Matrix_Unique_ID` = '211509521'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-05T09:09:09.150' ,`MLSNumber` = '23211618' ,`ListAgentFullName` = 'Jovany Trujillo' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.192388' ,`Longitude` = '-95.295949' ,`PhotoCount` = '27' ,`PostalCode` = '77534' ,`RoomCount` = '5' ,`ListPrice` = '175000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 208' ,`StreetNumber` = '5906' ,`StreetSuffix` = '' ,`City` = 'Danbury' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '840' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy home on almost 1/2 acres of land ready for you to call it home!!! This 2 bedroom 1 bath home will make your feel right at home, don\'t wait any longer and schedule your private tour today !!!' ,`Acres` = '0.474' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Danbury' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PORT AUSTIN (A0102 E P MYRICK) BLK 26 LOT 3-4-5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20647' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '15 - Danbury' ,`SchoolElementary` = 'DANBURY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DANBURY HIGH SCHOOL' ,`SchoolMiddle` = 'DANBURY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Austin' ,`TaxAmount` = '1051' ,`TaxRate` = '2.2192' ,`WaterSewer` = 'Aerobic,Septic Tank,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663707018' WHERE `Matrix_Unique_ID` = '211927560'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212147224','1663707018','212147224','2022-09-05T08:38:52.580','57687201','Soniya Raju','eXp Realty, LLC','','','29.728705','-95.473448','31','77056','4','535000.00','Active','Schumacher','5441','Lane','Houston','2','0','3','1362','Single-Family','TENANT OCCUPIED PROPERTY THROUGH JUNE 2024. Generate income for two years while you design and get your plans ready for a new build. Updated, mid-century home on a corner lot in the Galleria area surrounded by mature Oak trees! Home features plank tile flooring, carpet in bedrooms, updated kitchen w/ granite countertops, crown molding throughout, and large windows bringing in tons of natural lighting. Home is on a premium corner lot in the coveted Larchmont subdivision. Easy access to 59, minutes from the Galleria restaurants, bars, and retail! DO NOT DISTURB TENANTS. No showings w/o an executed contract.','0.1929','22','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Galleria','Central Gas','0','LT 11 BLK 7 LARCHMONT SEC 1','Corner','8402','Appraisal District','','','0','','2','Electric Oven','0','','','Gas Range','','Composition','27 - Houston','SCHOOL AT ST GEORGE PLACE','WISDOM HIGH SCHOOL','TANGLEWOOD MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Other Style,Traditional','Larchmont','','','Public Sewer','1957','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','212147562','1663707018','212147562','2022-09-05T09:52:08.037','47221594','Jonathan Currey','Truth & Grace Real Estate','','','30.482260','-95.542866','21','77318','5','325000.00','Active','Green Meadow','16575','Loop','Willis','2','0','2','1170','Single-Family','Great 2 bedroom 2 bath home situated on a spacious 1.57 Acre lot. Fresh paint, built in 2016. Located in a quiet neighborhood close to Lake Conroe and minutes from The City of Willis and Shopping. Come take a look today!','1.57','39','','','','','Other Disclosures','','','','Lake Conroe Area','Central Electric','0','GREEN MEADOW, LOT 12, ACRES 1.570','Cleared','68389','Appraisal District','','','0','','2','','0','','','','','Composition','56 - Willis','PARMLEY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Green Meadow','3346','1.8448','Aerobic','2016','Appraisal District');  --> New record created successfully<br />