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-11-24T16:43:24.660' ,`MLSNumber` = '84351034' ,`ListAgentFullName` = 'Kate Myhan' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '6.100832' ,`Longitude` = '-75.418329' ,`PhotoCount` = '6' ,`PostalCode` = '00000' ,`RoomCount` = '4' ,`ListPrice` = '4000000.00' ,`Status` = 'Active' ,`StreetName` = 'El Callejon' ,`StreetNumber` = '0' ,`StreetSuffix` = '' ,`City` = 'Other' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfectly located land or site for 62  condominium development project. Located close to Medellin in Columbia in vicinity of the airport. Used to be use used as cow ranch. Right now can be used to grow cannabis or development .\r\n15 minutes from the airport , 40 minutes from center of Medellin.' ,`Acres` = '' ,`Area` = '' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'M.I. 001-70598,M.I. 001-70599,M.I. 001-70600,M.I001-26302' ,`LotDesciption` = 'Other,Wooded' ,`LotSize` = '2281949' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '' ,`SchoolElementary` = '' ,`SchoolHigh` = '' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Tierra Alta' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1669642091' WHERE `Matrix_Unique_ID` = '206222112'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T16:28:29.853' ,`MLSNumber` = '11901612' ,`ListAgentFullName` = 'Jennifer Zweiacker' ,`ListOfficeName` = 'Zweiacker & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.556987' ,`Longitude` = '-96.374178' ,`PhotoCount` = '45' ,`PostalCode` = '77845' ,`RoomCount` = '14' ,`ListPrice` = '1100000.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Horse' ,`StreetNumber` = '5903' ,`StreetSuffix` = 'Run' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3646' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Opulent 2-story home on 3+ idyllic acres. A lighted stone path leads to the rustic front entrance opening to a vaulted foyer & winding staircase to upstairs entertainment area. Beyond the foyer your eyes are drawn to the vaulted ceiling & natural lighting of the enormous great room w/ stone fireplace flanked by built-ins, picture windows w/ storage seats, & transomed doors leading to the covered patio. Seat 8-10 guests in the open formal dining area adjacent to the enormous European inspired kitchen w/ wood plank barrel ceiling, granite counters, limestone columns, eating bar, & immense island. The bright primary sanctuary has vaulted ceiling & patio access. Primary en suite bathroom w/ rotunda ceiling, Roman tub, walk-through shower, granite vanities, & windows galore. 3 oversized guest bedrooms share 2 full baths. This home\'s grandeur extends outside to many gathering areas and gorgeous landscaping.' ,`Acres` = '3.353' ,`Area` = '61' ,`BuilderName` = 'Quinn William Custom' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Propane,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ESTATES AT RIVER RUN PH 2, BLOCK 4, LOT 16, ACRES 3.353' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Wooded' ,`LotSize` = '146056' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'RIVER BEND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates At River Run Ph 02' ,`TaxAmount` = '11962' ,`TaxRate` = '1.73437' ,`WaterSewer` = 'Aerobic,Other Water/Sewer' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642092' WHERE `Matrix_Unique_ID` = '209735570'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T15:27:46.453' ,`MLSNumber` = '39000458' ,`ListAgentFullName` = 'Misti Hebert' ,`ListOfficeName` = 'Maddie Lowe Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151206' ,`Longitude` = '-95.680352' ,`PhotoCount` = '49' ,`PostalCode` = '77362' ,`RoomCount` = '11' ,`ListPrice` = '735000.00' ,`Status` = 'Active' ,`StreetName` = 'Green Terrace' ,`StreetNumber` = '2045' ,`StreetSuffix` = 'Lane' ,`City` = 'Pinehurst' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4446' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Loaded w/UPGRADES & ZONED to Tomball ISD! 4 bedrooms, 4.5 baths, OVERSIZED 3 car tandem garage on a PREMIUM LOT backing up to Woodtrace Central Park w/picnic areas, walking trails & playground. Woodtrace is gated, has a 23 acre spring fed lake, club house & pool. This home has 1 immediate neighbor & NO REAR NEIGHBORS! Featuring modern farmhouse shiplap accents, memoir tile, open concept for entertaining & slider patio doors. Upon entering the front door you\'ll be graced by tall ceilings & lots of natural light. The kitchen features a 6 burner gas cooktop, double ovens, massive island w/Feiss pendant lights, extended upper cabinets, quartz countertops & more. All bedrooms have their own bathroom attached. Guest bed/bath downstairs. Primary bedroom features a study/flex space w/wood floors, wall of windows overlooks the backyard, private bath w/soaking tub, separate shower w/seat, 2 large closets & a laundry access door. Upstairs features 2 bedrooms, 2 baths, a game room & a media room.' ,`Acres` = '0.2585' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S959491 - WOODTRACE 08-B, BLOCK 1, LOT 6' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '11261' ,`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` = '53 - Tomball' ,`SchoolElementary` = 'DECKER PRAIRIE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodtrace 08' ,`TaxAmount` = '17163' ,`TaxRate` = '3.2015' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642092' WHERE `Matrix_Unique_ID` = '210384994'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T15:00:56.893' ,`MLSNumber` = '90146519' ,`ListAgentFullName` = 'Johnathen Reyes' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734108' ,`Longitude` = '-95.609689' ,`PhotoCount` = '27' ,`PostalCode` = '77082' ,`RoomCount` = '6' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Ashford Creek' ,`StreetNumber` = '12707' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1784' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated house!!!! Updated kitchen!! updated bathrooms!!!!\r\nUpdates include kitchen cabinets, granite countertops, appliances, lights, spotlights, most doors, interior paint, baseboards, carpet,\r\nluxurious waterproof vinyl laminate planks, and many more!!!\r\nThe following items were replaced in 2022: roof, a/c and heating,  water heater.' ,`Acres` = '0.1253' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 3 ASHFORD PARK SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '280' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HEFLIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'O\'DONNELL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ashford Park Sec 06' ,`TaxAmount` = '4999' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642092' WHERE `Matrix_Unique_ID` = '210483262'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T16:51:09.277' ,`MLSNumber` = '27014560' ,`ListAgentFullName` = 'Manuel Becerra' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.336129' ,`Longitude` = '-95.311453' ,`PhotoCount` = '42' ,`PostalCode` = '77303' ,`RoomCount` = '7' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Crockett Bend' ,`StreetNumber` = '16377' ,`StreetSuffix` = 'Drive' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS HOME IS MOVE-IN READY! Welcome to your fully renovated home on a little over 1 acre. This home offers 4 bedrooms and 2 baths with plenty of outdoor space for the family to enjoy. All new appliances/cabinets can be found in the kitchen. Don\'t delay and make your appointment today; you will not be disappointed.' ,`Acres` = '1.0118' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S356100 - CROCKETT TRACE 01, BLOCK 3, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '44074' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '260' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Crockett Trace 01' ,`TaxAmount` = '2243' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642092' WHERE `Matrix_Unique_ID` = '210864311'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T15:27:26.380' ,`MLSNumber` = '94605437' ,`ListAgentFullName` = 'Irene Pavig' ,`ListOfficeName` = 'Irene Pavig, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.677455' ,`Longitude` = '-95.053217' ,`PhotoCount` = '43' ,`PostalCode` = '77571' ,`RoomCount` = '4' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Shirley' ,`StreetNumber` = '2101' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2025' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'THIS IS A RARE FIND.  DON\'T WAIT!!!  FRONT AND BACK COVERED PORCHES. CUSTOM HOME ON CULDESAC. \r\nENTER FAMILY LIVING AREA, KITCHEN AND DINING. KITCHEN HAS ISLAND WITH 5 BURNER GAS RANGE. FRIG ,DISHWASHER & DISPOSAL NEW IN APRIL, 2021. BREAKFAST COUNTER, GRANITE COUNTERTOP AND BACKSPLASH FROM ITALY.  LOW MAINTENANCE MEXICAN TILE FLOORING, RIVER ROCK WOOD BURNING FIREPLACE, MASTER BEDROOM HAS 10X10 CLOSET, BAY WIDOWS HAS STORAGE GALORE.   ROOM FOR BOAT AND RV PARKING,  CHICKEN OR SMALL ANIMALS WELCOME . ONE 12X20 STORAGE SHED PLUS, STORAGE BARN HAS ELECTRIC & WATER PLUS LOFT. HURRY, THIS HOME WILL NOT STAY ON THE MARKET VERY LONG. WAIT UNTIL YOU SEE THE PRIVACY THAT COMES WITH THIS HOME. ONLY 10 MINUTES TO SYLVAN BEACH.' ,`Acres` = '0.8118' ,`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` = 'Lomax Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 8 LA PORTE OUTLOTS R/P' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '35362' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LOMAX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LOMAX JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'La Porte Outlots R/P' ,`TaxAmount` = '6289' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642092' WHERE `Matrix_Unique_ID` = '211957798'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T16:58:41.867' ,`MLSNumber` = '4850239' ,`ListAgentFullName` = 'Jimmy Zarate' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755757' ,`Longitude` = '-94.957062' ,`PhotoCount` = '15' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadowglen' ,`StreetNumber` = '605' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1736' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in Baytown. Home already appraised with FHA for $225K. Garage was converted to an extra bedroom or living room. Tile throughout with with dark wood laminate in primary bedroom with new carpet in secondary bedrooms. New roof complete last month. New fixtures. New electrical outlets and switches. New paint and updated shower tile and kitchen backsplash.' ,`Acres` = '0.168' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 80 GLEN MEADOW SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7320' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'JAMES BOWIE ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Meadow Sec 02 R/P' ,`TaxAmount` = '4232' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642093' WHERE `Matrix_Unique_ID` = '212121982'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T16:51:23.457' ,`MLSNumber` = '91479264' ,`ListAgentFullName` = 'Shirley Kopecky' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.956358' ,`Longitude` = '-97.522947' ,`PhotoCount` = '35' ,`PostalCode` = '76571' ,`RoomCount` = '7' ,`ListPrice` = '409500.00' ,`Status` = 'Active' ,`StreetName` = 'Ridge' ,`StreetNumber` = '851' ,`StreetSuffix` = 'Road' ,`City` = 'Salado' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2415' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s an incredible opportunity to live in an OFF GRID capable home on 1 of the larger & most picturesque lots - a Million $ view, in beautiful Mill Creek (golf course + golf cart community), with 2 gated entrances & a seasonal stream, far below house. The heavily wooded lot is sloped & has a unique partially submerged earth-type home with concrete walls + large attached workshop/extended garage. Home is unique, yet comfortable inside.  Property  has a water-well with 2 storage tanks (+ city water), 3 buried propane tanks, solar panels (w/o batteries), 2 rain water storage tanks, a tank-less water heater, & a generator. Roof damaged by April hailstorm; awaiting confirmation that insurance co. will pay to replace top rigid foam layer (usually in commercial-type buildings; an EXPENSIVE repair {likely $90k+ adding value to home}). Lot value + off grid capable features exceed listing price; home structure is a bonus. Accompanied showings only; don\'t walk property without an appointment!' ,`Acres` = '0.939' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MILL CREEK SECTION 2, BLOCK 007, LOT 0002 & more' ,`LotDesciption` = 'In Golf Course Community,Ravine,Water View,Wooded' ,`LotSize` = '40902' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '220 - Salado' ,`SchoolElementary` = '' ,`SchoolHigh` = 'SALADO HIGH SCHOOL' ,`SchoolMiddle` = 'SALADO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Mill Creek Sec 2' ,`TaxAmount` = '8924' ,`TaxRate` = '2.3547' ,`WaterSewer` = 'Public Water,Septic Tank,Well' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642093' WHERE `Matrix_Unique_ID` = '212751342'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T15:14:24.717' ,`MLSNumber` = '41279857' ,`ListAgentFullName` = 'Rebecca Vera' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = 'Kendra Dempsey' ,`SellingOfficeName` = 'Willow Haven Realty' ,`Latitude` = '30.175120' ,`Longitude` = '-95.157885' ,`PhotoCount` = '21' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '349000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Fountain View' ,`StreetNumber` = '2658' ,`StreetSuffix` = 'Street' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1835' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Amazing drive through this beautiful and peaceful neighborhood surrounded by amazing trees and lush greenery. Walk into a bright, well maintained, one-story home. The gorgeous entry leads you into the heart of the home.  You will find 2 bedrooms , laundry room and bathroom on your right as you walk on the beautiful wood like flooring into the open concept entertainment area. Striking large kitchen with a big island and plenty of custom white cabinets. Stainless steel appliance and lots of counter space are ideal for the chef in the family.  You can escape to primary bedroom to retire for the evening.  Plenty of space to have a sitting area as well as an area for respite.  Primary bathroom features a spa-like feeling with it\'s double vanities, large soaking tub, and standing shower. If you are a lover of nature this home provides you a beautiful and big backyard surrounded by trees .' ,`Acres` = '0.4893' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01, BLOCK 18, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '21312' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest' ,`TaxAmount` = '3052' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642093' WHERE `Matrix_Unique_ID` = '213311277'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T16:06:56.370' ,`MLSNumber` = '61995835' ,`ListAgentFullName` = 'Kylee Borden' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = 'Jennifer Hurst' ,`SellingOfficeName` = 'KJ Platinum Properties LLC' ,`Latitude` = '30.069304' ,`Longitude` = '-94.802421' ,`PhotoCount` = '42' ,`PostalCode` = '77575' ,`RoomCount` = '9' ,`ListPrice` = '335000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Bowie' ,`StreetNumber` = '1414' ,`StreetSuffix` = 'Street' ,`City` = 'Liberty' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3459' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come to the heart of Liberty, Texas, to see this 3 bedroom and 2 bathroom one-story home on beautiful tree filled .72 acre lot. \r\n\r\nThis home offers charm and functionality with a split bedroom plan, 3 living areas (including one with a wood burning fireplace), breakfast room, formal dining room, oversized utility, circular drive, a side courtyard perfect for morning coffee, and so much more!  \r\n\r\nNumerous updates have been made in the recent years, including, new carpet, new paint throughout, all new lighting and switches, new door hardware, and new ridge cap on roof.' ,`Acres` = '0.6171' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LIBERTY OUTER BLOCKS, BLOCK 9, LOT TRACT 43, ACRES .6171' ,`LotDesciption` = 'Other' ,`LotSize` = '26881' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Lockbox Right Side,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Liberty Outer Blocks' ,`TaxAmount` = '8638' ,`TaxRate` = '2.6826' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642093' WHERE `Matrix_Unique_ID` = '213424829'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T15:17:28.027' ,`MLSNumber` = '42185953' ,`ListAgentFullName` = 'Isaiah Hinojosa' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.157736' ,`Longitude` = '-94.737247' ,`PhotoCount` = '31' ,`PostalCode` = '77575' ,`RoomCount` = '3' ,`ListPrice` = '179000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 2356' ,`StreetNumber` = '175' ,`StreetSuffix` = '' ,`City` = 'Hardin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home has many updates already but still needs some work. Foundation, Plumbing, Electrical all have been redone, Entire ac and heating is brand new. New recess lighting throughout. With the right touch this beautiful house will come to life.A little shy of an acre you will have plenty of room.The 70x50 shop with new plumbing and electric is also a big bonus. Schedule your private showing today.' ,`Acres` = '0.9125' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Liberty County East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LEXIE-5.89 AC, LOT 5 6, PT 7, ACRES 0.9125' ,`LotDesciption` = 'Cleared' ,`LotSize` = '39749' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '107 - Hardin' ,`SchoolElementary` = 'HARDIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARDIN HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Lexie-589 Ac' ,`TaxAmount` = '3769' ,`TaxRate` = '2.1438' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642094' WHERE `Matrix_Unique_ID` = '213646977'  --> 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','214602475','1669642094','214602475','2022-11-24T15:07:12.920','91940996','Yvette Reyes-Hall','Reyes Realty Group, LLC','','','29.379879','-95.233539','26','77511','7','238000.00','Active','Morgans Landing','5276','Lane','Alvin','2','0','3','1442','Single-Family','MAKE YOUR MOVE TO MORGANS LANDING! THIS WELL KEPT SUPER CUTE HOME IS READY FOR A FIRST TIME HOMEBUYER, OR ANYONE ELSE THAT WOULD LIKE TO CALL THIS CUTIE \"HOME\"!  HAVE KIDS? SCHOOLS ARE RIGHT AROUND THE CORNER! THIS 3 BEDROOM, 2 BATH HOME OFFERS A SPLIT FLOOR PLAN! THE FAMILY ROOM (WITH HIGH CEILING) PROVIDES A NICE FLOW INTO THE NICE-SIZED KITCHEN! KITCHEN OFFERS PLENTY OF CABINET AND COUNTER SPACE ALONG WITH A PANTRY! NICE BIG BREAKFAST AREA FOR A NICE BIG TABLE! YOU\'LL LOVE THE MASTER BEDROOM WITH PLENTY OF ROOM FOR YOUR FURNITURE ALONG WITH A STAND-UP SHOWER & GARDEN TUB IN THE MASTER BATH! BACKYARD IS FULLY FENCED WITH ROOM FOR AN IN-GROUND POOL, SWING SET, OR WHATEVER YOUR HEART\'S DESIRE! DON\'T DELAY, THIS IS A POPULAR NEIGHBORHOOD...MAKE YOUR APPOINTMENT TODAY!!','0.1612','5','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','0','Alvin South','Central Gas','1','MORGAN\'S LANDING SEC 1 (A0480 H & W) (ALVIN) BLK 1 LOT 12','Subdivision Lot','7022','Appraisal District','','231','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','3 - Alvin','WALT DISNEY ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','Morgans Landing Sec 1-2-3','4810','2.8854','Public Sewer,Public Water','2003','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-24T15:04:51.683' ,`MLSNumber` = '51608445' ,`ListAgentFullName` = 'Larry Cockman' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.838229' ,`Longitude` = '-95.787704' ,`PhotoCount` = '31' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = 'Modica' ,`StreetNumber` = '4438' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1929' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This almost like new home was built in 2017 and is simply incredible inside and out! Providing 1,929 square feet of living space, 4 spacious bedrooms, 2 bathrooms, wonderfully-equipped kitchen, and a bright and inviting living space! Boasting incredible attention to detail and upgrades throughout including gorgeous tile, stainless steel appliances, beautiful wood cabinetry, and modern finishes. The master bath is relaxing, featuring a spa like bath and sitting room, with so much more.  After a long day, come home and relax on your extended covered patio while grilling or just enjoying your family. The community of Ventana Lakes features pools, splash pads, trails, parks, a clubhouse, schools, easy access to 99 and I-10.' ,`Acres` = '0.1703' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 1 VENTANA LAKES SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7417' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Ventana Lakes Sec 9' ,`TaxAmount` = '7045' ,`TaxRate` = '3.2768' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669642094' WHERE `Matrix_Unique_ID` = '214602847'  --> 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','215047534','1669642094','215047534','2022-11-24T15:17:50.833','96042666','Alan Orozco','JLA Realty','','','30.070798','-95.519132','20','77379','6','299000.00','Active','Bright Bloom','6419','Lane','Spring','2','0','3','2129','Single-Family','You\'ve made it. You Are Home. Located in SpringBrooks, This Inviting 3 Bedroom and 2 Full bathroom Home Features A Spacious Study/Office room, open floors and a lovely Backyard Ready for Your Family\'s Next BBQ. This location is Ideal for the family looking for Nearby Major Retailers, Fine dining experiences and Quick access to I-45 and Grand Parkway ALL of which are Literal Minutes away. \r\nThis is One peaceful and Dependable Neighborhood with Friendly faces on every Corner.\r\nYou\'ll Feel Warm and cozy here because This Is THAT Place. Hurry and don\'t miss out on this Opportunity.','0.1452','14','','','','','Mud','1','','','Spring/Klein/Tomball','Central Electric','1','LT 5 BLK 3 SPRINGBROOK SEC 3','Subdivision Lot','6325','Appraisal District','','330','0','','2','','0','','','Gas Range','','Composition','32 - Klein','BENIGNUS ELEMENTARY SCHOOL','KLEIN OAK HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Contemporary/Modern','Springbrook Sec 03','6785','2.5965','Water District','2004','Appraisal District');  --> New record created successfully<br />