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-08T05:25:44.020' ,`MLSNumber` = '65139778' ,`ListAgentFullName` = 'Steven Little' ,`ListOfficeName` = 'Little Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.657162' ,`Longitude` = '-95.070507' ,`PhotoCount` = '24' ,`PostalCode` = '77571' ,`RoomCount` = '5' ,`ListPrice` = '219999.00' ,`Status` = 'Active' ,`StreetName` = 'Rustic Gate' ,`StreetNumber` = '10426' ,`StreetSuffix` = 'Road' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1508' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UPGRADED NICE!! A must see. Great Deal in Fairmont Park. No back neighbors. Fridge, Washer and dryer included! One year home warranty included. One year lawn package offered.  Ready to move in and enjoy. You must act quickly.' ,`Acres` = '0.2204' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 18 FAIRMONT PARK SEC 2' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '9600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LEO RIZZUTO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Fairmont Park' ,`TaxAmount` = '4995' ,`TaxRate` = '2.7208' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1971' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238115' WHERE `Matrix_Unique_ID` = '210847719'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:32:12.127' ,`MLSNumber` = '69327957' ,`ListAgentFullName` = 'Livee Gao' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635824' ,`Longitude` = '-95.814486' ,`PhotoCount` = '13' ,`PostalCode` = '77406' ,`RoomCount` = '9' ,`ListPrice` = '365000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Deer Lane' ,`StreetNumber` = '4927' ,`StreetSuffix` = '' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful new home with water view. Large back yard. Kitchen opens to family room. Huge walk-in pantry. All big bedrooms upstairs. Lots of windows in game room. Extra storage space in garage. Garage door opener. A must see!' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'KB Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT4, BLK2' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '5850' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Run Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.922' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665238115' WHERE `Matrix_Unique_ID` = '211623785'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:55:58.233' ,`MLSNumber` = '8877107' ,`ListAgentFullName` = 'Brandy Liss' ,`ListOfficeName` = 'Priority One Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.652837' ,`Longitude` = '-95.177025' ,`PhotoCount` = '40' ,`PostalCode` = '77504' ,`RoomCount` = '10' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Argentina' ,`StreetNumber` = '4310' ,`StreetSuffix` = 'Circle' ,`City` = 'Pasadena' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2653' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning Custom-Built Home in a Quiet Cul-de-Sac. Looking for something unique, one of a kind? You\'ll love this stunning custom built home! From the carved Tester bed to the copper roof accents, this home is full of beautiful details. Plus, it\'s located in a quiet cul-de-sac and has low HOA fees. Never flooded! You\'ll enjoy plenty of peace and privacy here. The lush landscaping and well-manicured lawn are just an added bonus. Inside you\'ll find plenty of space to spread out with three bedrooms and two and a half bathrooms. The large walk in closet is a real bonus and comes complete with built-ins. This home is perfect for those who love to entertain - the open floor plan makes it easy to host gatherings of all sizes. Don\'t miss out on this one - call today for your private showing! See attached Features and Updates sheet attached in forms--so many amazing features and upgrades.' ,`Acres` = '0.2057' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 VISTA VILLAS SEC 3' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '8960' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '25' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'JENSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PASADENA)' ,`SchoolMiddle` = 'PARKVIEW INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Vista Villas' ,`TaxAmount` = '7239' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238115' WHERE `Matrix_Unique_ID` = '212202056'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:37:31.330' ,`MLSNumber` = '92519044' ,`ListAgentFullName` = 'Kristin Gyldenege' ,`ListOfficeName` = 'Locke and Key Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.066492' ,`Longitude` = '-95.929125' ,`PhotoCount` = '34' ,`PostalCode` = '77484' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Brazeal' ,`StreetNumber` = '2706' ,`StreetSuffix` = 'Street' ,`City` = 'Waller' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2312' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a true treasure! Completely remodeled with gorgeous greens....this dream home is waiting for you! Huge 4 car pull through garage with possible man cave or accessory unit with half bath existing. Private pond on big open lot. Surrounded by big Oak and pecan trees. Option of city water or your own private well! Watch the sunset from your screened in back porch or from your front porch swings. Huge bedrooms. Tons of cabinet space. Gorgeous quartz kitchen. GORGEOUS master bath with clawfoot tub. Extra out building could be converted to apartment or workshop. Roof is 2018. The possibilities are endless. Fantastic neighborhood! Easy access to 290. This one is a show stopper. BRING ALL OFFERS' ,`Acres` = '1' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Waller' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A314000 A-140 H E HEDGEPETH TRACT 2 ACRES 1.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '6' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = '' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'He Hedgepeth Surv Abs 140' ,`TaxAmount` = '6571' ,`TaxRate` = '2.6131' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238115' WHERE `Matrix_Unique_ID` = '212335058'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:43:08.083' ,`MLSNumber` = '23264792' ,`ListAgentFullName` = 'Rich Nickel' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.071287' ,`Longitude` = '-95.185184' ,`PhotoCount` = '38' ,`PostalCode` = '77345' ,`RoomCount` = '9' ,`ListPrice` = '309500.00' ,`Status` = 'Active' ,`StreetName` = 'Sweetgum Hill' ,`StreetNumber` = '3719' ,`StreetSuffix` = 'Lane' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2542' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This two story brick home is just the place for you. Quiet street, amazing schools, community pool and playground with nearby greenbelts and easy access to HWY 59.  The kitchen has been beautifully updated with Corian counter tops, you\'ll love the large walkin pantry and open floor plan with tile floors flowing from the kitchen into the family room. You will notice the natural light, the large windows give this home a bright feeling. Large covered patio located right off the kitchen, great for barbecues and dinners outside. Primary suite is on the second floor, soaker tub, separate frameless glass shower, and large amount of closet space really make for a good amount of storage. Upstairs are three spacious bedrooms with ceiling fans and mini blinds.  This is just the one for you. Seller is motivated, bring your offers. According to the owner, home has not flooded.' ,`Acres` = '0.1618' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 50 BLK 7 MILLS BRANCH VILLAGE SEC 2 AMD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '480' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'HIDDEN HOLLOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mills Branch Village Sec 02 Am' ,`TaxAmount` = '6352' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238115' WHERE `Matrix_Unique_ID` = '212530808'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:18:32.857' ,`MLSNumber` = '39430904' ,`ListAgentFullName` = 'Jose Ramirez' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797237' ,`Longitude` = '-95.376543' ,`PhotoCount` = '36' ,`PostalCode` = '77009' ,`RoomCount` = '4' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Walton' ,`StreetNumber` = '701' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2850' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a beautifully remodeled and expanded home in highly sought-after Brooke Smith!  Almost new construction with new electrical, plumbing, HVAC, roof, windows, siding, cabinets, Quartz countertops, floors…too much to list!  The craftsman style home boasts an open floor plan, primary en-suites on 1st and 2nd floors, game room, office, 2-car detached garage, and many other wonderful features.  French White Oak floors throughout, solid Quartz countertops in kitchen and bathrooms, Moen shower fixtures, stainless steel appliances, the list goes on and on.  The primary en-suite bathroom downstairs will remind you of a luxurious spa, with double sinks, plenty of storage, a soaking tub, and spacious walk-in shower.  Walk in pantry and closets offer plenty of storage space for meticulous organization.  Upstairs office offers a great view with French doors for privacy.  Schedule your showing today before it’s gone!' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = 'Forthright Construct' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 105 BROOKE SMITH' ,`LotDesciption` = 'Corner' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BROWNING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Craftsman' ,`Subdivision` = 'Brooke Smith' ,`TaxAmount` = '6931' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665238116' WHERE `Matrix_Unique_ID` = '212640022'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:40:59.247' ,`MLSNumber` = '37704341' ,`ListAgentFullName` = 'Meg Taylor' ,`ListOfficeName` = 'CB&A, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.397075' ,`Longitude` = '-95.608809' ,`PhotoCount` = '41' ,`PostalCode` = '77356' ,`RoomCount` = '6' ,`ListPrice` = '368000.00' ,`Status` = 'Active' ,`StreetName` = 'Fairhaven' ,`StreetNumber` = '12207' ,`StreetSuffix` = 'Lane' ,`City` = 'Montgomery' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom/2 bath home with a back yard paradise! This amazing one-story home on a cul-de-sac features a large study with art niche and French doors for privacy. A stylish open-concept kitchen with large island with sink, Bosch dishwasher and under-cabinet lighting. Spacious family room with wall of windows for view to back yard. Lovely primary suite with bay windows with room for sitting area.  Relax outdoors with your very own back yard oasis - stunning pool with water features and LED lighting, impressive landscaping, and covered patio that also has Sunbrella curtains. Even with all this to enjoy, there is still plenty of room for all the extras in this back yard! This home is also equipped with a water softener and full sprinkler system. Come see all that this home and living in Walden has to offer!' ,`Acres` = '0.2645' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WALDEN 01, BLOCK 4, LOT 82' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community' ,`LotSize` = '11523' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MADELEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Walden' ,`TaxAmount` = '5341' ,`TaxRate` = '2.1392' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238116' WHERE `Matrix_Unique_ID` = '213205229'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:50:26.877' ,`MLSNumber` = '24461303' ,`ListAgentFullName` = 'Kim Fazzino' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.199291' ,`Longitude` = '-95.554360' ,`PhotoCount` = '37' ,`PostalCode` = '77382' ,`RoomCount` = '16' ,`ListPrice` = '3300000.00' ,`Status` = 'Active' ,`StreetName` = 'Norlund' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Way' ,`City` = 'The Woodlands' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '9060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Rare opportunity to create your perfect home! Sellers have meticulously removed all flooring, kitchen counters & bathrooms to remodel this incredible property and have left a blank slate. Dreams will come true in this European inspired custom home in gated Carlton Woods located on Signature Hole (#15) of Jack Nicklaus Course. French doors throughout open to balconies & verandas w/ views of pool, golf course & pond. Grand foyer w/sweeping staircase opens to library area on 2nd floor. Private block-paneled study. Wine cellar near formal dining & living. Kitchen showcases large butcher-block island, hidden microwave, Viking 6-burner w/griddle, SubZero, large walk-in pantry, & private work area. Kitchen is open to den for ease in entertaining. Perfectly designed for guests w/ secondary bedroom downstairs. Romantic primary retreat overlooks backyard paradise. Upstairs features media room, gameroom, plus 4 beds & ensuite baths. Pool, spa, travertine surround, outdoor kitchen and fireplace.' ,`Acres` = '0.7628' ,`Area` = '15' ,`BuilderName` = 'Jeff Paul' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S960010 - WDLNDS VIL OF CARLTON WOODS 10, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,In Golf Course Community,On Golf Course,Water View,Wooded' ,`LotSize` = '33229' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'TOUGH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'THE WOODLANDS HIGH SCHOOL' ,`SchoolMiddle` = 'MCCULLOUGH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Carlton Woods' ,`TaxAmount` = '55610' ,`TaxRate` = '2.1816' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238116' WHERE `Matrix_Unique_ID` = '213261449'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:49:02.183' ,`MLSNumber` = '51701032' ,`ListAgentFullName` = 'Jerry Wang' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598339' ,`Longitude` = '-95.635698' ,`PhotoCount` = '12' ,`PostalCode` = '77479' ,`RoomCount` = '4' ,`ListPrice` = '589000.00' ,`Status` = 'Active' ,`StreetName` = 'Meadow Bay Ct' ,`StreetNumber` = '1402' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Newly upgraded charming home, first floor with hardwood/tiles, quartz countertops, and fresh paint throughout the property!  With SS appliances.  Amazing 2-story home features 4 beds, 3.5 baths, living room, formal dining room, play area, fireplace, and a detached 2-car garage. Master bedroom on the first floor with spacious bedroom--bath w/ dual sinks, jacuzzi tub & separate shower. Zoned to top rated schools. Convenient access to  59/69 and Hwy 6, close to shopping mall, Costco, Walmart, HEB, Target, and restaurants, next to a lake trail.' ,`Acres` = '0.2445' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MEADOW LAKES SEC 1, BLOCK 1, LOT 28' ,`LotDesciption` = 'Corner' ,`LotSize` = '10650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Meadow Lakes Sec 1' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238116' WHERE `Matrix_Unique_ID` = '213403468'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T05:52:01.193' ,`MLSNumber` = '92550319' ,`ListAgentFullName` = 'Dorian Wintill' ,`ListOfficeName` = 'Dorian Wintill' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.936608' ,`Longitude` = '-95.674721' ,`PhotoCount` = '0' ,`PostalCode` = '77095' ,`RoomCount` = '10' ,`ListPrice` = '350000.00' ,`Status` = 'Active' ,`StreetName` = 'Falls' ,`StreetNumber` = '10943' ,`StreetSuffix` = 'Terrace' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2560' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move in ready! Remodeled kitchen with custom maple cabinets and quartzite countertops; remodeled primary bath with frameless glass shower and two sinks with marble countertops; luxury vinyl plank flooring in the living areas downstairs; recent carpet upstairs in all bedrooms and game room; remodeled secondary bath upstairs; two car garage; lawn irrigation system; extended back patio. Come see today!' ,`Acres` = '0.1523' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Copperfield Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 43 BLK 2 RIATA RANCH SEC 8 AMEND' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6636' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '840' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'WOODARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'SPILLANE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Riata Ranch Sec 08 Amd' ,`TaxAmount` = '6662' ,`TaxRate` = '2.711' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1665238116' WHERE `Matrix_Unique_ID` = '213425815'  --> 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','213442189','1665238117','213442189','2022-10-08T04:05:49.020','49186079','Rita Armstrong','UTR TEXAS, REALTORS','','','29.553146','-95.146080','33','77598','6','280000.00','Active','Roxton Ridge','15739','Drive','Webster','2','0','3','1380','Single-Family','BEAUTIFULLY UPDATED CHARMER! WELL-MAINTAINED INSIDE/OUTSIDE. GRANITE COUNTERS IN KITCHEN & PRIMARY BATH. FRESHILY INSTALLED CARPET IN SPLIT BEDROOM PLAN. JUST PAINTED BASEBOARDS, FRONT PORCH RAILING, FP HEARTH. WHOLE HOME POWERWASHED. NEWLY REFINISHED TUB IN UPDATED 2ND BATH. WOOD-LOOK FLOORING IN LIVING & DINING. ABUNDANT NATURAL LIGHT. CEILING FANS IN ALL ROOMS. BIG BACKYARD WITH PATIO FOR OUTDOOR COOKING & FUN. CONVENIENTLY LOCATED TO MAJOR THOROUGHFARES, SHOPPING, RESTAURANTS, ETC. NO HOA OR MUD TAX. MAKE THIS GREAT HOME YOURS! SCHEDULE A PRIVATE SHOWING TODAY!','0.1515','7','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Clear Lake Area','Central Gas','0','LT 34 BLK 18 PIPERS MEADOW SEC 3','Subdivision Lot','6600','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','9 - Clear Creek','WHITCOMB ELEMENTARY SCHOOL','CLEAR LAKE HIGH SCHOOL','CLEARLAKE INTERMEDIATE SCHOOL','Lockbox Front','Appraisal District','1','Traditional','Pipers Meadow Sec 03','4506','2.3169','Public Sewer,Public Water','1983','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-08T04:49:32.703' ,`MLSNumber` = '15540757' ,`ListAgentFullName` = 'Kathy L.R Mercado' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.402264' ,`Longitude` = '-95.802757' ,`PhotoCount` = '13' ,`PostalCode` = '77461' ,`RoomCount` = '4' ,`ListPrice` = '299999.00' ,`Status` = 'Active' ,`StreetName` = 'Trey' ,`StreetNumber` = '10310' ,`StreetSuffix` = 'Road' ,`City` = 'Needville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 10310 Trey Dr! This property sits on over 1/2 acre. This 3 bedroom 2 bathroom new construction home has high ceilings, office/study nook, and covered front porch & patio. The primary bedroom features a bathroom with double sinks, rainfall shower head, and a walk in closet. Enjoy the amazing big backyard. Zoned to highly sought after Needville ISD. Perfect for a first-time homebuyer, anyone looking to downsize, or investor. Make this your home today!' ,`Acres` = '0.6899' ,`Area` = '30' ,`BuilderName` = 'Cascada Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ROSEMEADOW SEC 3, BLOCK 5, LOT 16, SERIAL OC010314052A & B,' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '30052' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '38 - Needville' ,`SchoolElementary` = 'NEEDVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NEEDVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'NEEDVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Rosemeadow' ,`TaxAmount` = '5888' ,`TaxRate` = '1.8957' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1665238117' WHERE `Matrix_Unique_ID` = '213446252'  --> 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','213451766','1665238117','213451766','2022-10-08T04:50:12.903','28287293','Lauren Luneau','Century 21 Realty Partners','','','30.372413','-95.531402','38','77304','5','437500.00','Active','Brimstone Hill','5835','Lane','Conroe','3','0','4','2725','Single-Family','Charming, single story 4/3/2 with dedicated study & screened porch nestled in the waterfront community of Water Crest on Lake Conroe. Thoughtful split floorplan offers a large owner\'s retreat with spa-like bath including: double sinks, separate tub & shower, and walk-in closet. Two of the large secondary bedrooms share a Full Bath with dual sinks, 4th Bedroom with a dedicated ensuite bath. The heart of this home is the designer kitchen with an abundance of counter & cabinet space with rolling drawers on all lower cabinets; additional under-cabinet, recessed and pendant lights; walk-in pantry & huge granite island. Spacious, open family room. Formal dining room. Entertain in the private backyard with screened patio, no back neighbors, and fruit trees (oranges & blueberries). Abundant community amenities include 2 resort pools, parks, a fishing pond, a clubhouse, and private pier & boat launch. Washer, dryer and refrigerator included. No previous flooding.','0.1938','39','DR Horton','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Lake Conroe Area','Central Gas','1','S954414 - WATER CREST ON LAKE CONROE 14, BLOCK 1, LOT 15','Greenbelt,Subdivision Lot','8441','Appraisal District','','900','0','','2','Freestanding Oven','0','','','Gas Range','','Composition','56 - Willis','LAGWAY ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Ranch,Traditional','Water Crest On Lake Conroe','9253','3.0823','Water District','2020','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','213452817','1665238117','213452817','2022-10-08T05:29:20.607','31666932','Kristin Gyldenege','Locke and Key Homes','','','30.295917','-94.812420','26','77327','3','175000.00','Active','Jensen','644','','Cleveland','1','1','3','600','Single-Family','A you ready for the perfect weekend getaway? Or maybe you are looking to add to your air bnb portfolio? This perfect little charmer is ready! Property features wrap around porch, ample storage shed, fully fenced yard, fire pit and large patio for grilling and gathering. Home is a pristine 2 generous bedrooms ( one being completely separate) with an adorable loft upstairs, 1 full bathroom in main home and a half bath in the apartment. All bedrooms easily accommodate queen sized beds. Open concept living room and kitchen with room for pull out bed/sofa in living room capable of sleeping 8 very comfortably. This home has been impeccably maintained. NO FLOODING EVER. Check out the resort style amenities with 5 private stocked lakes, river access, 2 miles of private beach, equestrian center, 3 private pools, Playgrounds, splash pad, and multiple pavilions.','','52','','','','','Sellers Disclosure','','','','Liberty County East','Central Electric,Central Gas','1','Cypress Lakes Block 4 Unit 2 Lot 211','Cleared','','','','1200','0','','0','','0','','','','','Aluminum','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Appointment Required,Controlled Access,Lockbox Front','Seller','1','Traditional','Cypress Lakes 01','734','1.53','Public Sewer,Public Water','2017','Seller');  --> New record created successfully<br />