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-12-30T11:56:21.050' ,`MLSNumber` = '13049931' ,`ListAgentFullName` = 'Patricia McCulley' ,`ListOfficeName` = 'Country World Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704474' ,`Longitude` = '-94.853340' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '7' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Berts Farm' ,`StreetNumber` = '139' ,`StreetSuffix` = 'Road' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This property has it all.  Located only minutes from downtown Livingston, this property offers a main dwelling that is 3542 per Polk CAD plus a detached Garage Efficiency Apartment with Bedroom, Kitchen, Living area and 1/2 bath upstairs plus approximately 400 SF bedroom, full bath and utility room downstairs. There is also a one room cabin on the property with bathroom.  This property would lend itself to being an Air B & B or a property for extended family members to reside. Fully fenced  with fruit trees, garden spot and chicken pen, this is country life at it\'s best. There is a detailed sheet that goes into great detail of all the improvements this property has to offer available upon request.' ,`Acres` = '1.55' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '1.55 acres in the Z.H. Price Survey AB-720' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '67518' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Beech Creek Village South' ,`TaxAmount` = '8819' ,`TaxRate` = '1.9558' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097476' WHERE `Matrix_Unique_ID` = '200519340'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:10:54.750' ,`MLSNumber` = '82630231' ,`ListAgentFullName` = 'Daphne Carlsen' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.800055' ,`Longitude` = '-95.638871' ,`PhotoCount` = '18' ,`PostalCode` = '77414' ,`RoomCount` = '2' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 299 Heron' ,`StreetNumber` = '16144' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOOKING FOR A GET-A-WAY WEEKEND HOME? ONLY 75 MILES FROM HOUSTON, NEW TINY HOME ON OFF WATER LOT BUT ONLY MINUTES TO BEACH AND ICW. COMES FURNISHED, 1/1 OPEN KITCHEN, DINING AREA & LIVING AREA. PLENTY OF BUILT IN CABINETS, STACKABLE WASHER & DRYER INCLUDES. SPLIT UNIT HVAC. COVERED FRONT PORCH, ON CONCRETE SLAB WITH 800SQFT RV COVER. READY TO MOVE IN.' ,`Acres` = '0.138' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'DOWNEY CANEY CREEK SEC 16, LOT 144' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6011' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Downey Caney Creek Sec 16' ,`TaxAmount` = '203' ,`TaxRate` = '2.3895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675097476' WHERE `Matrix_Unique_ID` = '207372903'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T11:21:39.307' ,`MLSNumber` = '38463782' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.147839' ,`Longitude` = '-95.416322' ,`PhotoCount` = '36' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Lisa Marie' ,`StreetNumber` = '236' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1395' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy small-town charm in the new community of Gifford Meadows, located in the growing town of Angleton, TX! Our new construction Compass floor plan featuring 1-story, 3 bedrooms,2 baths with 2-car garage. The kitchen is open & bright highlighting matte gray backsplash, brown itabaria granite countertops, 42”graphite cabinets & iron wood flooring. The primary suite features double sinks, walk-in shower & walk-in closet. Home is estimated to be completed in November 2022.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 2 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gifford Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.74' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097476' WHERE `Matrix_Unique_ID` = '210808406'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T11:20:40.870' ,`MLSNumber` = '9729035' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.148603' ,`Longitude` = '-95.416848' ,`PhotoCount` = '3' ,`PostalCode` = '77515' ,`RoomCount` = '5' ,`ListPrice` = '232990.00' ,`Status` = 'Active' ,`StreetName` = 'Laura Leigh' ,`StreetNumber` = '252' ,`StreetSuffix` = 'Lane' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1295' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy small-town charm in the new community of Gifford Meadows, located in the growing town of Angleton, TX! Our new construction Aviator floor plan featuring 1-story, 3 bedrooms,2 baths with 2-car garage. The kitchen is open & bright highlighting biscuit backsplash, gietto granite countertops, 42” hazelnut cabinets & fawn tile flooring. The primary suite features double sinks, walk-in shower & walk-in closet. Home is estimated to be completed in November 2022.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 33 Block 1 Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5175' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gifford Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.74' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097476' WHERE `Matrix_Unique_ID` = '210812465'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T11:05:44.270' ,`MLSNumber` = '72466240' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.736132' ,`Longitude` = '-95.915651' ,`PhotoCount` = '9' ,`PostalCode` = '77494' ,`RoomCount` = '3' ,`ListPrice` = '272990.00' ,`Status` = 'Active' ,`StreetName` = 'Beltingham Bend' ,`StreetNumber` = '3971' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1297' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Abbot flooplan in Tamarron.  3 beds/2bath/2 car garage.  Availalbe to move in - November!  Home features include: Modern Farm House Elevation. Granite counter tops in kitchen and bathrooms.  Sod in front and back yard. Tankless Water Heater.  Smart Home System. Oversized walk in Shower. Stainless Steel Whirlpool appliances (Microwave, Dishwaser and Gas Range).  DuPure drinking water filtration system. Covered Patio!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '18/2/Sec: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097477' WHERE `Matrix_Unique_ID` = '210815988'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T11:07:08.117' ,`MLSNumber` = '70988261' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.735163' ,`Longitude` = '-95.915479' ,`PhotoCount` = '9' ,`PostalCode` = '77494' ,`RoomCount` = '4' ,`ListPrice` = '310990.00' ,`Status` = 'Active' ,`StreetName` = 'Beltingham Bend' ,`StreetNumber` = '3931' ,`StreetSuffix` = 'Way' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1778' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Gaven flooplan in Tamarron.  4 beds/2bath/2 car garage.  Availalbe to move in - September!  Home features include: Modern Farm House Elevation. Granite counter tops in kitchen and bathrooms.  Sod in front and back yard. Tankless Water Heater.  Smart Home System. Oversized walk in Shower. Stainless Steel Whirlpool appliances (Microwave, Dishwaser and Gas Range).  DuPure drinking water filtration system. Covered Patio!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '8/2/Sec: 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron' ,`TaxAmount` = '' ,`TaxRate` = '3.06' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097477' WHERE `Matrix_Unique_ID` = '210843069'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:21:39.400' ,`MLSNumber` = '75178671' ,`ListAgentFullName` = 'Thomas Saunders' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873743' ,`Longitude` = '-95.681109' ,`PhotoCount` = '26' ,`PostalCode` = '77084' ,`RoomCount` = '6' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Fieldglen' ,`StreetNumber` = '17814' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1762' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming, well maintained single story home in the peaceful Northglen subdivision. Spacious living area boasts high ceilings, and bright windows to provide natural light. Formal dining room off of entry opens to the kitchen. Breakfast nook with backyard view open to kitchen. Kitchen features ample cabinet and counter space, and under cabinet lighting. Generous master suite with room for sitting area, and en suite master bath with double sinks. Back Patio and fenced back yard perfect to enjoy the outdoors. 2 car garage with double wide driveway. Convenient access to Highway 99, Highway 6, 290, close to major shopping centers, super markets, dining and zoned to award wining Cypress Fair-bank schools. Schedule your showing today!' ,`Acres` = '0.1515' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 21 BLK 13 NORTHGLEN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'METCALF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Northglen Sec 02' ,`TaxAmount` = '4550' ,`TaxRate` = '2.706' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097477' WHERE `Matrix_Unique_ID` = '211090661'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:12:22.607' ,`MLSNumber` = '24565578' ,`ListAgentFullName` = 'Thomas Saunders' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.136871' ,`Longitude` = '-95.055212' ,`PhotoCount` = '49' ,`PostalCode` = '77554' ,`RoomCount` = '3' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Isla Del Sol' ,`StreetNumber` = '4108' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Custom-Built Designer Home situated on lot that borders a nature preserve. Great space outside for entertaining, garage includes a side roll up door & flat screen TV.  Refreshing outdoor shower & toilet. Enjoy evening sunsets on upper deck. Kitchen features custom-built cabinetry w/glass inlets & tons of storage, unique \"Sand & Shells\" tile backsplash, oversized island w/marble countertops & stainless appliances. Designer touches w/attention to detail throughout.  Open living area w/high cove ceilings, recessed lighting, beautiful vinyl plank flooring & 2” wood shutters. Bedrooms are decked in stylish furniture, Primary Bedroom has a large walk-in closet, spacious shower, exceptional tile work, double vanity, marble countertops, bead board cabinetry & ceramic tile floors.  Isla Del Sol\'s private boat launch & fishing pier are exclusively for property owners. 2 min golf cart ride to beach. House being sold furnished w/exclusions & is ready for living beach life to the fullest.' ,`Acres` = '0.12' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 17 BLK 4 ISLA DEL SOL SUB' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5227' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Left Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Isla Del Sol' ,`TaxAmount` = '8071' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097477' WHERE `Matrix_Unique_ID` = '213275090'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:15:27.990' ,`MLSNumber` = '98552240' ,`ListAgentFullName` = 'Sapana Patel' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.541776' ,`Longitude` = '-95.564899' ,`PhotoCount` = '32' ,`PostalCode` = '77479' ,`RoomCount` = '11' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Point' ,`StreetNumber` = '5614' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4050' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Floor Plan in sought after Riverstone.  Zoned to New Elementary opening Fall 2023. It\'s located in a private cul-de-sac at dead end street with no neighbors on one side. Large 4 Bedrooms and 4 Full Bathrooms ( 3 bed downstairs & 1 upstairs); Bay Window in Primary Bedroom, Sunroom, Updated extended patio with outdoor kitchen and grill, natural gas piped to both outdoor cooktop and grill. Open Kitchen with 2 dishwashers , A/C in Garage, The primary bedroom plus 2 bedrooms, formal dining, sun room,  breakfast and the study are on the first floor; all bedrooms have en suite bathroom. Second floor  game room, a media room and fourth bedroom with a full bath and a walk in closet. Plantation shutters throughout the house. Hard Wood & Tile floors. (Zoned to Anne Sullivan Elementary School) A must see!' ,`Acres` = '0.247' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CREEKSTONE VILLAGE AT RIVERSTONE SEC 6 PHASE II, BLOCK 2, LO' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SULLIVAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'FIRST COLONY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Creekstone Village at Riverstone' ,`TaxAmount` = '11339' ,`TaxRate` = '2.5104' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097478' WHERE `Matrix_Unique_ID` = '213466906'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:24:16.707' ,`MLSNumber` = '22747672' ,`ListAgentFullName` = 'Cynthia Alford' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.018806' ,`Longitude` = '-95.290997' ,`PhotoCount` = '32' ,`PostalCode` = '77338' ,`RoomCount` = '6' ,`ListPrice` = '290000.00' ,`Status` = 'Active' ,`StreetName` = 'Moon Walk' ,`StreetNumber` = '20454' ,`StreetSuffix` = 'Drive' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2131' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Public Remarks:          Location, Location, Location! Beautiful two stories brick home. This beautiful home offers 4 Bedroom, 2.5 Bath, 2 Car Garage on a 6,910 sq ft\' corner lot with Easy access to Hwy 59, minutes away from Deerbrook Mall which has a large variety of shopping and restaurants, approximately 15 minutes from Bush Intercontinental Airport! This beautiful home offers open living room, Kitchen, and dining. Natural lighting throughout the house. Lots of cabinet/pantry space in the kitchen with electric range and Granite countertops. Primary Bedroom large enough to create sitting area with w/ large walk-in closet, spacious bathroom separating vanity, soaking tub, shower and toilet area. Great for that First-Time home buyer or Investor. Spacious secondary bedrooms upstairs w/walk-in closets, large bathroom separating vanity and shower/toilet area. Buyer to verify school information.' ,`Acres` = '0.1586' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 7 DEERBROOK ESTATES SEC 11' ,`LotDesciption` = 'Corner' ,`LotSize` = '6910' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JONES ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'DEERBROOK ESTATES' ,`TaxAmount` = '5919' ,`TaxRate` = '2.7433' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097478' WHERE `Matrix_Unique_ID` = '213744356'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:30:21.143' ,`MLSNumber` = '61795397' ,`ListAgentFullName` = 'Sonya Burnett' ,`ListOfficeName` = 'RE/MAX East' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.643954' ,`Longitude` = '-95.203688' ,`PhotoCount` = '36' ,`PostalCode` = '77504' ,`RoomCount` = '3' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Mize' ,`StreetNumber` = '4334' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2434' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for a lovely home on a huge lot? Look no further! This home sits on 3/4 of an acre (as per HCAD) in Pasadena.  This is an Estate Sale.  Plumbing has been updated.  Wood laminate and tile flooring.  Granite countertops, stainless steel 5-burner gas range, original cabinets in the kitchen.  Home has been well kept and maintained.  Bathrooms recently remodeled.  Primary bathroom has a shower.  Backyard has a concrete-slabbed uncovered patio, partially fenced yard and a detached garage. No HOA!' ,`Acres` = '0.7924' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 133 HIGHLAND ACRES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '34516' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'YOUNG ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'MILLER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Highland Acres' ,`TaxAmount` = '6748' ,`TaxRate` = '3.2023' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097478' WHERE `Matrix_Unique_ID` = '214815181'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T11:09:20.043' ,`MLSNumber` = '12127446' ,`ListAgentFullName` = 'Jon Skeele' ,`ListOfficeName` = 'Bayway Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.456559' ,`Longitude` = '-95.059921' ,`PhotoCount` = '6' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Kristen' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Drive' ,`City` = 'Dickinson' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2009' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful open concept home has 3 bedrooms and 2 full baths. A inviting kitchen that includes a large island. You will have 2009 sq ft of enclosed space under the home for cars and storage. Enjoy your 2 covered patios. Walking distance to great restaurants and parks. Close to schools, trails, places of worship, medical facilities and employment. This home is under construction and should be complete March 2023. Agents please see agent. remarks' ,`Acres` = '0.1761' ,`Area` = '33' ,`BuilderName` = 'Bayway Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Dickinson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 32 BLK 1 PEACOCK ISLES SUB (2021) ABST 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7671' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '980' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'CALDER ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Peacock Isles' ,`TaxAmount` = '723' ,`TaxRate` = '2.5214' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097478' WHERE `Matrix_Unique_ID` = '214947391'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-30T12:11:32.767' ,`MLSNumber` = '27540106' ,`ListAgentFullName` = 'Jane NgaDung Nguyen' ,`ListOfficeName` = 'Alpha, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.659310' ,`Longitude` = '-95.351541' ,`PhotoCount` = '18' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Active' ,`StreetName` = 'Mallow' ,`StreetNumber` = '4822' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 4 bedroom, 1.5 bath home on a large 18,000sqft lot. No restrictions, No HOA. 4 sided bricks. High & dry from Harvey. Minutes from Downtown Houston, NRG Stadium and Medical Center.' ,`Acres` = '0.4132' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 & W 30 FT OF LT 7 BLK 9 SUNNYSIDE GARDENS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WOODSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunnyside Gardens' ,`TaxAmount` = '2793' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097479' WHERE `Matrix_Unique_ID` = '215002239'  --> 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','215657338','1675097479','215657338','2022-12-30T11:08:33.353','59752330','Juan Torres','SIS Group LLC','','','30.136669','-95.131513','20','77357','7','280000.00','Active','Idle Glen','1815','Road','New Caney','2','0','3','1382','Single-Family','Very nice property with over an acre of land. Lots of space to expand or to entertain. Very nice three bedroom house with tile floors. Huge separate 24x24 room for storage, guest room or shop. Very calm area located close to 99 Grand Pkwy.','0.1985','32','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','','0','Porter/New Caney East','Central Electric','0','LT 21 BLK 6 IDLE GLEN U/R','Cleared','52065','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Range','','Composition','29 - Humble','SHADOW FOREST ELEMENTARY SCHOOL','KINGWOOD HIGH SCHOOL','RIVERWOOD MIDDLE SCHOOL','Accompany,Appointment Required,Call Occupant,No Supra Keybox','Appraisal District','1','Traditional','Idle Glen U/R','1774','2.133','Septic Tank,Well','1968','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','215851634','1675097479','215851634','2022-12-30T12:27:44.337','13587489','Pedro Zaldivar Rabago','Keller Williams Professionals','','','30.184303','-95.500428','31','77381','4','520000.00','Active','Cornerbrook','7','Place','The Woodlands','2','2','4','2788','Single-Family','One-story home in the heart of the Woodlands. Zoned to the highly acclaimed Woodlands Schools. Well distributed 4 bedrooms with 2/2 bathrooms. Large kitchen with island and adjacent breakfast room. Large family room with fireplace. Separate formal dining room and formal living room with fireplace and wet bar. Oversized 3 car garage. Large backyard and covered patio area. Cul-de-sac lot with large driveway.','0.2245','15','','','Electric Dryer Connections,Washer Connections','','Mud','1','','2','The Woodlands','Central Electric,Central Gas','0','WDLNDS VIL COCHRANS CR 02, BLOCK 1, LOT 8','Cul-De-Sac,Subdivision Lot','9780','Appraisal District','','','0','','3','Double Oven','0','','','Gas Range','','Composition','11 - Conroe','DAVID ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Wdlnds Village Cochrans Cr 02','9350','2.1811','Water District','1988','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','215939892','1675097479','215939892','2022-12-30T11:18:32.703','89693255','Jane NgaDung Nguyen','Alpha, REALTORS','','','29.571045','-95.210377','28','77089','8','464000.00','Active','Cardinal Crescent','12714','Lane','Houston','3','1','5','2766','Single-Family','Beautiful and well maintained home located in a highly sought-after neighborhood of Ashley Pointe near Friendswood and Pearland ! Home features: 5 Bedrooms and 3.5 Bathrooms w/ primary bedroom down!! New laminate floor/new interior paint. High Ceilings.  Easy access to the freeway and downtown, and minutes from local shops, restaurants, and supermarkets.','0.141','3','','','Washer Connections','','Sellers Disclosure','1','Freestanding','1','Southbelt/Ellington','Central Gas','1','LT 29 BLK 1 ASHLEY POINT SEC 13','Cleared','6142','Appraisal District','','605','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','9 - Clear Creek','WEBER ELEMENTARY','CLEAR BROOK HIGH SCHOOL','WESTBROOK INTERMEDIATE SCHOOL','Leave Business Card,Supra Keybox','Seller','2','Traditional','ASHLEY POINT SEC 13','8227','2.524','Water District','2017','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','215940169','1675097479','215940169','2022-12-30T11:00:41.420','94565285','Scott Miller','RE/MAX Signature Galleria','','','30.161307','-95.151335','8','77357','4','249900.00','Active','Galaxy','19249','Boulevard','New Caney','2','1','4','1820','Single-Family','10\' ceilings in kitchen/Living, open concept. Spacious kitchen with 42\" upper cabinets with large island, granite tops. Bedrooms with huge walk-in closet. Samsung Stainless Steel appliance package including easy clean top range with electric oven, 3 rack dishwasher, and microwave. 1 year warranty on appliances from Samsung. Ask agent about preferred lender benefits.','0.3966','40','Starter Homes of TX','','Electric Dryer Connections','','No Disclosures','1','','','Porter/New Caney East','Central Electric','1','KINGS COLONY 01, BLOCK 2, LOT 28, ACRES 0.380','Subdivision Lot','17277','Appraisal District','','180','1','To Be Built/Under Construction','1','Electric Oven','0','','','Freestanding Range','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required,Leave Business Card','Builder','2','Traditional','Kings Colony 01','640','2.1331','Public Water,Septic Tank','2022','Builder');  --> 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','215942345','1675097479','215942345','2022-12-30T12:41:48.430','5603271','Michael Seder','RE/MAX The Woodlands & Spring','','','30.119679','-95.385746','25','77386','9','325000.00','Active','Legends Line','29422','Drive','Spring','2','1','4','2848','Single-Family','Move-in Ready home in Legends Run! Conveniently located close to Grand Pkwy, this home features a two car attached garage, abundant windows, and neutral carpet and paint for an easy transition. The island kitchen offers tons of cabinet storage and opens to the den; owner\'s suite, three bedrooms and huge game room up; fenced yard with patio has plenty of room to entertain guests and for family to play.','0.1258','15','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Spring Northeast','Central Gas','1','S688207 - LEGENDS RUN 07, BLOCK 3, LOT 10','Subdivision Lot','5480','Appraisal District','','490','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','11 - Conroe','BRADLEY ELEMENTARY SCHOOL (CONROE)','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','2','Traditional','Legends Run 07','9584','2.8187','Water District','2006','Appraisal District');  --> New record created successfully<br />