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-10-21T04:49:30.560' ,`MLSNumber` = '18670529' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.702725' ,`Longitude` = '-95.280155' ,`PhotoCount` = '40' ,`PostalCode` = '77012' ,`RoomCount` = '4' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Sarita' ,`StreetNumber` = '7910' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1452' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In search for a new home? Come embrace this wonderful newly remodeled home just minutes away from I-610 South Loop. This house is accompanied by 1,480 of living space and 6,000 sq ft in total. Surrounded by a charming black fence, you will be getting security and privacy. Come schedule your private tour now!' ,`Acres` = '0.1377' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9 & 10A BLK 2 BROADWAY COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SANCHEZ ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'MILBY HIGH SCHOOL' ,`SchoolMiddle` = 'DEADY MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Broadway Court' ,`TaxAmount` = '2747' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356170' WHERE `Matrix_Unique_ID` = '211095793'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T04:50:21.200' ,`MLSNumber` = '76888908' ,`ListAgentFullName` = 'Sergio De La Llata Jr.' ,`ListOfficeName` = 'Sierra Vista Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.166691' ,`Longitude` = '-95.628221' ,`PhotoCount` = '27' ,`PostalCode` = '77486' ,`RoomCount` = '3' ,`ListPrice` = '270000.00' ,`Status` = 'Active' ,`StreetName` = 'Canterbury' ,`StreetNumber` = '237' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come gather around and step inside this astonishing beauty! With a little TLC, anyone can make this their dream home! The abundance in space inside and out is perfect for anyone looking to live comfortably. The home alone is 2,100 sq ft allowing for commodious living. The home is located inside a private community that offers a community pool and park, perfect for those safe outdoor activities. This one will not last, schedule your private tour now!' ,`Acres` = '0.2152' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 4 (A0133 M VARNER) BLK 43 LOT 27' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '3664' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356170' WHERE `Matrix_Unique_ID` = '211690708'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T05:37:00.463' ,`MLSNumber` = '56310789' ,`ListAgentFullName` = 'Andrew Nguyen' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.926645' ,`Longitude` = '-95.741438' ,`PhotoCount` = '50' ,`PostalCode` = '77433' ,`RoomCount` = '10' ,`ListPrice` = '760000.00' ,`Status` = 'Active' ,`StreetName` = 'River Otter' ,`StreetNumber` = '19018' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3570' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A spectacular 2022 built, never lived-in Coventry home located in heart of the master-planned community of Bridgeland, zoned to the highly sought-after Cypress-Fairbanks ISD. The fantastic floor-plan with lots of upgrades providing 5 bedrooms 2 DOWN, 4 full baths and an oversized epoxy floored 3 car tandem garage. You will be welcomed by a beautiful rotunda and a spiral staircase leading past a formal dinning and a secondary bedroom. A wall of windows allowing the natural light to shine through. A family room awaits with spacious, enhanced with soaring ceilings offers views of a large covered patio, open concept connecting seamlessly with a gourmet kitchen equipped with island, breakfast bar, light colored cabinetry, designer tile backsplash, SS appliances. Primary bedroom suits with a luxurious master bath & spa, Huge his and her closet. Head upstairs to  game room, three additional bedrooms, 2 with a jack & jill bathroom & 1 with an attached full bathroom...\r\nA must see TODAY!!' ,`Acres` = '0.1524' ,`Area` = '25' ,`BuilderName` = 'Coventry' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 2 BRIDGELAND PARKLAND VILLAGE SEC 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6640' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1197' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland Parkland Vlg Sec 22' ,`TaxAmount` = '2684' ,`TaxRate` = '3.541' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1666356170' WHERE `Matrix_Unique_ID` = '211975558'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T05:56:05.240' ,`MLSNumber` = '60515430' ,`ListAgentFullName` = 'Nick Janke' ,`ListOfficeName` = 'Janke and Co Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.518062' ,`Longitude` = '-95.040624' ,`PhotoCount` = '26' ,`PostalCode` = '77573' ,`RoomCount` = '12' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Palm Island' ,`StreetNumber` = '3125' ,`StreetSuffix` = 'Circle' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2537' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW PRICE! Beautiful 4 bedroom 2 1/2 bath WITH SPARKLING POOL located on a quiet cul-de-sac in South Shore Village. Updated kitchen and bathrooms with open floor plan. There are many outstanding amenities to this home including updated flooring, kitchen countertops, double pane Low E vinyl windows. The kitchen is bright & open with quartz counters, tons of cabinet space and breakfast bar. The living area is lined with windows and has a cozy fireplace - just perfect for the entire family. The Primary bedroom is spacious w extra room for sitting area. Enjoy the en-suite w dual vanities, walk in shower and a separate bath. The upstairs game room is large, open & ready for family & friends to gather! Entertaining is a breeze in this backyard private oasis with NO BACK NEIGHBORS with a  pool/spa to enjoy both day & night! A must see, near everything, Kemah Boardwalk, CCISD School District, shopping, grocery stores and restaurants galore! A RARE find in todays market, see this beauty today!' ,`Acres` = '0.1936' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 PAGE 11 & 12 LOT 55 BLK 6 SOUTH SHORE VILLAGE SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8435' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South Shore Village Sec 3 93' ,`TaxAmount` = '6569' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356171' WHERE `Matrix_Unique_ID` = '211977827'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T05:46:29.513' ,`MLSNumber` = '11909819' ,`ListAgentFullName` = 'Jojuana Cleveland' ,`ListOfficeName` = 'Ultima Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.559080' ,`Longitude` = '-95.292688' ,`PhotoCount` = '28' ,`PostalCode` = '77584' ,`RoomCount` = '4' ,`ListPrice` = '327000.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Bend' ,`StreetNumber` = '4706' ,`StreetSuffix` = 'Court' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2252' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pride in ownership is apparent! This beautiful former Ryland model home is an entertainers dream. It now has a brand new roof with 30 year shingles and Wind Storm Certificate. Rich hardwood floors welcome you at the entry, hallways and formal living room. The formal dining area is open making mingling easy. The large family room has a see through fireplace that is wood burning with a gas starter. The open kitchen features a nice sized island, a stove that is electric but has plumbing in place for gas, Corian countertops, breakfast bar and eat-in kitchen. The spacious owners retreat has his and her closets, garden tub with separate shower and a linen closet. The secondary bedrooms are split for privacy and the floor plan is flexible so that the 4th bedroom with French doors can easily be used as an office. The backyard oasis features a lovely water fountain and fire pit perfect for relaxing. There’s a community park with slides and swings right around the corner. Come take a look today!' ,`Acres` = '0.1515' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'PARKS AT WALNUT BEND SEC 1 (A0239 HT&BRR) , BLOCK 1, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6599' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '315' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'C J HARRIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH EAST' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Parks At Walnut Bend Sec 1-2' ,`TaxAmount` = '7651' ,`TaxRate` = '2.8851' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356171' WHERE `Matrix_Unique_ID` = '212808622'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T05:01:27.187' ,`MLSNumber` = '62792246' ,`ListAgentFullName` = 'Angie Collins' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = 'Thao Nguyen' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '30.099745' ,`Longitude` = '-95.362260' ,`PhotoCount` = '50' ,`PostalCode` = '77386' ,`RoomCount` = '12' ,`ListPrice` = '775000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Carrie Cove' ,`StreetNumber` = '3006' ,`StreetSuffix` = 'Court' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3643' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! Beautiful one story home in the very desirable community of Benders Landing.  Original owners and meticulously maintained. Situated on a cul-de-sac and zoned to highly acclaimed CISD schools! Private backyard with lakeview, breathtaking walking path/garden surrounded by beautiful landscaping. Split level floor plan, master bedroom with sitting area and huge master bath with jetted tub and dual vanities.  Sitting room/office with French-doors that lead to the sunroom.  Gorgeous and very large sunroom can be accessed from the sitting room/office, the master bedroom and from the 4th bedroom.  This is the heart of the house and is sure to become your favorite room! Oversized 3 car garage! NO REAR NEIGHBORS! Brand new generator installed in 1/2022, tankless water heater installed 3/2022, new roof in 1/2021. LOW PROPERTY TAX RATE! Easy acess to IAH, Hwy 99, Hardy Toll Rd, I-45, I-59.  Plenty of dining and entertainment options around and a short 15 min. drive to The Woodlands.' ,`Acres` = '1.0008' ,`Area` = '40' ,`BuilderName` = 'David Powers Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S257102 - BENDERS LANDING 02, BLOCK 1, LOT 28' ,`LotDesciption` = 'Cul-De-Sac,Water View' ,`LotSize` = '43597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '920' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'ANN K. SNYDER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Benders Landing 02' ,`TaxAmount` = '11226' ,`TaxRate` = '1.8487' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356171' WHERE `Matrix_Unique_ID` = '213301729'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T04:52:28.460' ,`MLSNumber` = '98565951' ,`ListAgentFullName` = 'Telma Garcia' ,`ListOfficeName` = 'Prime Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968115' ,`Longitude` = '-95.193799' ,`PhotoCount` = '30' ,`PostalCode` = '77346' ,`RoomCount` = '8' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Kobuk Valley' ,`StreetNumber` = '17239' ,`StreetSuffix` = 'Circle' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fantastic one-story home combines desirable location, an open floor plan, and modern updates into one attractive package. Featuring 10-foot ceilings and hardwood or tile floors throughout(no carpet). This home also offers a newly remodeled primary bathroom with an amazing custom closet!  Recent new  A/C and Water heater units. The open living and kitchen area includes energy-efficient s.s. appliances and plenty of room for cooking or entertaining. The large backyard and covered patio make grilling with the family a breeze. Never flooded. Located in the master planned community of Eagle Springs and situated in a family-friendly cul-de-sac, this perfect home is also conveniently close to Atascocita, Humble, Beltway and Hwy 59. Neighborhood amenities include 24-hour fitness center, resort style pools, sports fields, splash pad, several parks, and seasonal events! Schedule your private showing before this home is gone!' ,`Acres` = '0.1515' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 EAGLE SPRINGS SEC 19' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6598' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'ATASCOCITA SPRINGS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ATASCOCITA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Eagle Springs' ,`TaxAmount` = '5905' ,`TaxRate` = '2.913' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356171' WHERE `Matrix_Unique_ID` = '213393823'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T05:24:44.620' ,`MLSNumber` = '75434384' ,`ListAgentFullName` = 'Richard Koob' ,`ListOfficeName` = 'Heinen Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.683338' ,`Longitude` = '-95.930852' ,`PhotoCount` = '29' ,`PostalCode` = '77441' ,`RoomCount` = '10' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'Waterford Crest' ,`StreetNumber` = '32411' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3661' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare waterfront opportunity in the gated enclave of Waterford at Weston Lakes! This beautiful and spacious home overlooks Pecan Lake.  It features 4 bedrooms, 3 full baths, study, media room, screened patio, and a 3-car garage. The grand entrance will lead you into a huge open floor plan with extensive wood flooring, high ceilings, and a wall of windows in the family room that offer gorgeous views of the lake. The kitchen is enormous with island, double ovens, tons of cabinet and drawer storage, and Bosch appliances. The exterior features full gutters and front and rear sprinkler system. NEVER FLOODED!' ,`Acres` = '0.3621' ,`Area` = '30' ,`BuilderName` = 'Keystone Classic' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Fulshear/South Brookshire/Simonton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WESTON LAKES SEC 19, BLOCK 1, LOT 7' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '15772' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'MORGAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Weston Lakes' ,`TaxAmount` = '10512' ,`TaxRate` = '2.1698' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356171' WHERE `Matrix_Unique_ID` = '213747674'  --> 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','213750552','1666356172','213750552','2022-10-21T05:47:33.160','28555884','Blanca Benavidez','The Monarch Team, LLC','','','29.477541','-95.309877','0','77511','9','749900.00','Active','Wink Wynn','1590','Road','Alvin','2','1','4','2244','Single-Family','','2.274','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','','','1','Alvin North','Central Electric','0','A0366 THOS SPRAGGINS TRACT 6 SD TR 27A WINK WYNN ACRES 2.274','Cleared','99055','Appraisal District','','','0','','2','Convection Oven','1','Gunite','','Gas Cooktop','','Other','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','MANVEL HIGH SCHOOL','G W HARBY J H','Accompany,Appointment Required','Appraisal District','1','Mediterranean','Wink-Wynn Estates','10711','2.2174','Septic Tank,Well','2007','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T04:29:58.343' ,`MLSNumber` = '71732593' ,`ListAgentFullName` = 'Jay Clemente' ,`ListOfficeName` = 'Realty World Homes & Estates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804093' ,`Longitude` = '-95.529578' ,`PhotoCount` = '24' ,`PostalCode` = '77080' ,`RoomCount` = '6' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Elmview' ,`StreetNumber` = '9626' ,`StreetSuffix` = 'Place' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS COULD BE YOUR HAPPILY EVER AFTER! Gated community! Prime location located next to green space and extra parking area! Just updated! New carpet, new laminate floors and fresh paint! Granite countertops in kitchen and bathrooms! Great size primary bedroom up with huge closet space! Secondary bedrooms up and nice size closets. Nice open den and cozy dining area. Maintenance includes lawn, trash and gates. Great value close to freeways, shopping, malls, hospitals and about 15 minutes to downtown Houston. Great value and opportunities awaits! Call today!' ,`Acres` = '0.0398' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 VILLAGES OF ELMVIEW' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '1735' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '105' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'PINE SHADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages/Elmview' ,`TaxAmount` = '4068' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356172' WHERE `Matrix_Unique_ID` = '213810612'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-21T04:01:32.097' ,`MLSNumber` = '4565899' ,`ListAgentFullName` = 'Leann Trang' ,`ListOfficeName` = 'Krueger Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.627131' ,`Longitude` = '-95.687779' ,`PhotoCount` = '28' ,`PostalCode` = '77407' ,`RoomCount` = '5' ,`ListPrice` = '545000.00' ,`Status` = 'Active' ,`StreetName` = 'Catalina Grove Lane' ,`StreetNumber` = '13018' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3991' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the 5 bed, 3.5 bath home nestled in the gated community of Old Orchard. This all brick exterior home built by Perry Homes features high ceilings, natural sunlight all throughout, covered patio and detached garage. Open concept split floor plan with study, formal dining, and living room. Primary bedroom has double sinks with double walk-in closets. Roof replaced in 2019. Home has both sprinkler system and water softener. This home is in a prime location with low tax rates and zoned to award-winning FBISD schools. Easy access and minutes away from Grand Parkway, Alt 90, Hwy 59 and Hwy 6. Vacant and easy to show. Schedule your showing today! Agent is daughter of the sellers.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'Perry Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'OLD ORCHARD SEC 3, BLOCK 2, LOT 18' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8436' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1235' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'MALALA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'GARCIA MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'OLD ORCHARD SEC 3' ,`TaxAmount` = '8805' ,`TaxRate` = '2.6329' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666356172' WHERE `Matrix_Unique_ID` = '213819594'  --> Updated record success<br />