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` = '2023-01-01T09:37:01.280' ,`MLSNumber` = '40669575' ,`ListAgentFullName` = 'Michael Vazquez' ,`ListOfficeName` = 'Venture Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.873814' ,`Longitude` = '-95.447700' ,`PhotoCount` = '16' ,`PostalCode` = '77088' ,`RoomCount` = '7' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Moon Beam' ,`StreetNumber` = '8021' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1737' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This new construction property is strategically located near major highways including -----. This home features all the sought after finishes today\'s homeowners are demanding. The home\'s front elevation showcases a classic brick veneer. This open floor plan has the kitchen open to the dining and living area. The bedrooms are a split plan with the primary bedroom on one side of the home and the secondary bedrooms on the opposite side. The home will feature granite and/or quartz countertops, tile throughout the living areas, laminate in the bedrooms and much more. No need to worry about restriction or HOA fees here. Call today to schedule your private tour!' ,`Acres` = '0.1676' ,`Area` = '11' ,`BuilderName` = 'Genaro' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 12 BLK 17 HARVEST HEIGHTS ANNEX SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7290' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harvest Heights Annex Sec 02' ,`TaxAmount` = '1455' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098372' WHERE `Matrix_Unique_ID` = '209516948'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:26:39.513' ,`MLSNumber` = '4109866' ,`ListAgentFullName` = 'Pamela DeBlasio' ,`ListOfficeName` = 'Lake Homes Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.704162' ,`Longitude` = '-94.927489' ,`PhotoCount` = '29' ,`PostalCode` = '77351' ,`RoomCount` = '5' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Robert' ,`StreetNumber` = '108' ,`StreetSuffix` = 'Avenue' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1370' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming bungalow located within the Livingston city limits with access to all city utilities.  This cozy home has been meticulously renovated from the roof down to the ground.  Recent updates include:  30yr architectural roof, 26 piers added to foundation, Pex plumbing, vinyl plank flooring throughout, bathroom vanities, walk-in shower & tub, tile surrounds and backsplash, soft close cabinet doors and drawers, S/S appliances, gorgeous granite, recessed lights, fixtures, paint interior/exterior, crown molding and new windows.  Close to downtown shopping and dining, 15 mins to Lake Livingston and vacation rental friendly.  You must see to appreciate.  Call for an appointment today!' ,`Acres` = '0.1245' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HILLSIDE PINES LOT 3' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5422' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric 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` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hillside Pines' ,`TaxAmount` = '2231' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098372' WHERE `Matrix_Unique_ID` = '210050866'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:21:08.897' ,`MLSNumber` = '49879250' ,`ListAgentFullName` = 'Michael Flores' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748299' ,`Longitude` = '-95.322177' ,`PhotoCount` = '15' ,`PostalCode` = '77011' ,`RoomCount` = '7' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Adams' ,`StreetNumber` = '224' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1072' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '224 N Adams, An incredible opportunity for anyone desiring to be in the heart of the Booming East End. Constructed beautifully up on a hill sits the opportunity of a great fixer upper. Roll up your sleeves and remodel this 1920\'s bungalow for yourself, turn into a duplex, or an vacation rental. \r\nBike or walk to local parks, bars and restaurants that are adding to this culturally rich neighborhood.  Imagine hopping on the Harrisburg Hike & Bike Trail or new section Buffalo Bayou Bike trail on Lockwood and be in the Heights in 20 minutes!\r\nWelcome to Segundo Barrio.' ,`Acres` = '0.1148' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 4 ENGEL' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Craftsman,Traditional' ,`Subdivision` = 'Engel' ,`TaxAmount` = '2440' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1926' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098372' WHERE `Matrix_Unique_ID` = '211869407'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:01:30.427' ,`MLSNumber` = '17112571' ,`ListAgentFullName` = 'Vanessa Cochran' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.054802' ,`Longitude` = '-94.809158' ,`PhotoCount` = '7' ,`PostalCode` = '77575' ,`RoomCount` = '4' ,`ListPrice` = '170000.00' ,`Status` = 'Active' ,`StreetName` = 'Washington' ,`StreetNumber` = '910' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The beautiful home has been Remodeling its sits on 1.3177 acres it has enough room to build another home plus a back porch to sit on and relax Concrete slab for a BBQ pit and picnic area Lots of Back yards' ,`Acres` = '1.3177' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LIBERTY OUTER BLOCKS, BLOCK 31, LOT PT 2 TR 11, ACRES 1.3177' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '57399' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Liberty Outer Blocks' ,`TaxAmount` = '3678' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098372' WHERE `Matrix_Unique_ID` = '211912422'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:10:38.737' ,`MLSNumber` = '50164323' ,`ListAgentFullName` = 'Jenifer Somich' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.569214' ,`Longitude` = '-95.042402' ,`PhotoCount` = '33' ,`PostalCode` = '77586' ,`RoomCount` = '10' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Pebblebrook' ,`StreetNumber` = '427' ,`StreetSuffix` = 'Drive' ,`City` = 'El Lago' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to this PRIOR ASTRONAUT OWNED HOME! This beautiful & rare 5 bedroom, 2 bath home is ready for move-in! Open concept with the master suite downstairs, plus formal living and dining! Great UPDATES completed in 2020- New carpet, New windows on front of house, New wood-look tile flooring, New granite countertops in kitchen & bathrooms, New subway tile backsplash in kitchen, New lights/fixtures/fans/faucets, New stainless appliances, Bathrooms completely remodeled with tile tub backsplash surround plus new toilets! New interior paint in 2022, fans in all bedrooms & kitchen features double ovens. You will love the wall of windows in the living room overlooking the huge deck with lush landscaping & the oversized detached garage! Ample driveway space for parking. Family friendly subdivision with scheduled family activities & close to clear lake water! Low taxes!' ,`Acres` = '0.2206' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 6 EL LAGO SEC 3' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9608' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '49' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ED H WHITE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'El Lago' ,`TaxAmount` = '7992' ,`TaxRate` = '2.6666' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098373' WHERE `Matrix_Unique_ID` = '213005059'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:28:15.513' ,`MLSNumber` = '42555453' ,`ListAgentFullName` = 'Lin Hutzenbiler' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.207768' ,`Longitude` = '-96.266470' ,`PhotoCount` = '50' ,`PostalCode` = '77437' ,`RoomCount` = '9' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'Trochta' ,`StreetNumber` = '807' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3107' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HAVEN WILL TEMPT YOU This jewel of a home with 4 bedrooms and 4 baths featuring 2 car attached garage, privacy fenced yard, heated swimming pool, pool house with full bathroom and pavilion. Foyer opens to sunken formal living and dining rooms with beautiful wood floors. Large, updated kitchen with granite counters, abundant cabinets adjoin the huge family room. Master bedroom with spa inspired on suite and walk in closet provides access to the pool area and private patio garden. Outside you will not be disappointed in the well-maintained lawn with irrigation system installed. The pool house covered areas for cookouts and entertaining will give you the feeling of your own personal resort.' ,`Acres` = '0.3776' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TROCHTA 2ND BLOCK 1 LOT 21,22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '16448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Trochta 2nd' ,`TaxAmount` = '7783' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098373' WHERE `Matrix_Unique_ID` = '213599873'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:49:22.570' ,`MLSNumber` = '46845041' ,`ListAgentFullName` = 'Jeannie Burns' ,`ListOfficeName` = 'Navasota Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461628' ,`Longitude` = '-96.018378' ,`PhotoCount` = '50' ,`PostalCode` = '77830' ,`RoomCount` = '5' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley View' ,`StreetNumber` = '1930' ,`StreetSuffix` = 'Drive' ,`City` = 'Anderson' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2371' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new home on 2 full acres located in Anderson ISD. This home overlooks rolling green pastures in Holland Ridge subdivision.  Split floor plan, nicely laid out, 2,371 Sq. Ft. The home has 3 bedrooms 2 baths on the first floor, plus a bonus bedroom and full bath upstairs.  Stained sealed concrete throughout with carpet in bedrooms. A spacious master suite, the master bath has his and her sinks, walk-in closet and separate shower and tub. Midsouth fiber internet, Holland Ridge is a small subdivision with an 11-acre park located just outside of Anderson, TX. Anderson is a charming little town that is highly sought after because of its great schools and friendly neighbors! Concrete streets and walking trails. The park has a pavilion with ½ bath, fishing ponds a cowboy fire pit. Bring the pets and kids, enjoy clean country living in a highly sought after area. With only 26 total lots in the subdivision, you will have neighbors without ever becoming crowded.' ,`Acres` = '2.001' ,`Area` = '60' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S5230 - HOLLAND RIDGE PHASE ONE, LOT 22, ACRES 2.001' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '87164' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '135 - Anderson-Shiro' ,`SchoolElementary` = 'ANDERSON-SHIRO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ANDERSON-SHIRO JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Holland Ridge Ph One' ,`TaxAmount` = '6700' ,`TaxRate` = '1.5426' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098373' WHERE `Matrix_Unique_ID` = '214210141'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-01T09:24:58.413' ,`MLSNumber` = '12808657' ,`ListAgentFullName` = 'Chad Hallmark' ,`ListOfficeName` = 'Seamless Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885632' ,`Longitude` = '-95.531152' ,`PhotoCount` = '36' ,`PostalCode` = '77040' ,`RoomCount` = '11' ,`ListPrice` = '565000.00' ,`Status` = 'Active' ,`StreetName` = 'Allegro' ,`StreetNumber` = '7738' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3593' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated home with 2 BEDROOMS DOWN! This spacious home features both formals with high ceilings, gorgeous kitchen with new Quartz countertops and backsplash (Oct 2022), waterfall island, high-end appliances, and family room with gas fireplace. Primary bedroom features remote controlled electric blinds and a sitting area which includes an updated gas fireplace with a chunky wood mantel! Primary bath features new Delta fixtures, new Quartz countertops and shower walls, and free-standing tub! High end vinyl plank floors throughout the home and stairs, no carpet, designer light fixtures & hardware.  3 bedrooms and game room up. Woodwind Lakes has Adult & Family Pools, Tennis/Pickleball Courts, Pavilion, Dog Park, 2 Playgrounds, 3 Wooded Lakes w/Walking Trails and Catch & Release Fishing. Schedule your showing today!' ,`Acres` = '0.1907' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 3 WOODWIND LAKES SEC 2 AMENDED' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8309' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'GLEASON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodwind Lakes Sec 02 Amd' ,`TaxAmount` = '10847' ,`TaxRate` = '2.591' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098373' WHERE `Matrix_Unique_ID` = '214943581'  --> 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','215411805','1675098374','215411805','2023-01-01T10:47:31.053','11632308','Travis Brown','Texas Patriot Realty, LLC','','','30.428150','-95.498167','23','77318','6','155000.00','Active','Cedar Ridge','9603','Court','Willis','2','0','4','1568','Single-Family','Nice Doublewide 4-Bedroom, 2-Bath home on corner lot in quiet neighborhood just off I-45. Split floor plan with \r\n large kitchen with island. Large shade trees in the front and deck on the back. All electric with city water and sewer.','0.2222','39','','','Electric Dryer Connections,Washer Connections','','Estate','1','','','Lake Conroe Area','Central Electric','1','S785902 - PIN OAK 02, BLOCK 7, LOT 18, SERIAL # 12331750A, L','Cleared,Corner,Subdivision Lot','9681','Appraisal District','','220','0','','0','Electric Oven,Freestanding Oven','0','','','Electric Range,Freestanding Range','','Composition','56 - Willis','C.C. HARDY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','LYNN LUCAS MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Traditional','Pin Oak 02','2725','2.4131','Public Sewer,Public Water','1999','Appraisal District');  --> New record created successfully<br />