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-24T05:51:35.970' ,`MLSNumber` = '36091302' ,`ListAgentFullName` = 'Katie Gaffigan' ,`ListOfficeName` = 'Segue Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.080187' ,`Longitude` = '-95.712629' ,`PhotoCount` = '30' ,`PostalCode` = '77377' ,`RoomCount` = '3' ,`ListPrice` = '819900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 2920' ,`StreetNumber` = '18702' ,`StreetSuffix` = 'Road' ,`City` = 'Tomball' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom built home with details throughout. Crown molding, coffered ceilings, custom cabinetry, bright sunroom, water softner, finised garage, mosquito misting system, this home has it all. The property is setup for wheelchair access including, wide doorways, ramps, and a wheelchair friendly shower. Excellent location with great visibility & 111 feet of frontage on FM 2920 in high density residential & commercial populated area in rapidly expanding Tomball, TX. Property includes a 3,462 SF custom home/office with gourmet kitchen, high-end finishes & immense attention to detail. Tract are less than 2 miles from the Grand Parkway (99) & only 5 miles from SH-249. Adjoining 1 & 1.02 acres with 1,539 SF & 1,036 SF offices also available for sale with +/- 340 combined feet of frontage along FM 2920 for all 3 tracts' ,`Acres` = '1' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TR 23D-1 ABST 7 S BROWN' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'ROSEHILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'TOMBALL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'unrestricted' ,`TaxAmount` = '10888' ,`TaxRate` = '2.1425' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638651' WHERE `Matrix_Unique_ID` = '203578573'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T05:43:09.693' ,`MLSNumber` = '25145817' ,`ListAgentFullName` = 'Angela Stancik' ,`ListOfficeName` = 'ThisIsLivin Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.031872' ,`Longitude` = '-96.505497' ,`PhotoCount` = '28' ,`PostalCode` = '77962' ,`RoomCount` = '3' ,`ListPrice` = '172900.00' ,`Status` = 'Active' ,`StreetName` = 'Marx' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Street' ,`City` = 'Ganado' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable one-story home on a corner lot with 3 bedrooms and 1.5 bathrooms.  Located in a desirable part of town with plenty of parking space for your guests.  Spacious family room extends into the formal dining area.  From the dining room, the floorplan flows nicely to the eat-in kitchen which has an abundance of cabinets, drawers and counter space.  Split floorplan is light and bright with easy clean laminate floors (installed 2018) and fresh paint.  Bedrooms are a perfect size with nice closets.  Bedroom addition has the potential to be a perfect primary suite with a few updates.   Home also features new roof (2019 - 30 yr. shingles), New HVAC with ducts & insulation (2020), extended driveway (poured in 2014).  Storage shed located in the backyard will convey.  Don\'t let this one get away - Call today to schedule a tour!' ,`Acres` = '0.2121' ,`Area` = '67' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GREENLAWN, BLOCK 2, LOT 8, ACRES 0.21' ,`LotDesciption` = 'Corner' ,`LotSize` = '9240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '265 - Ganado' ,`SchoolElementary` = 'GANADO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GANADO HIGH SCHOOL' ,`SchoolMiddle` = 'GANADO JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Greenlawn' ,`TaxAmount` = '3136' ,`TaxRate` = '2.4965' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1925' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638651' WHERE `Matrix_Unique_ID` = '211153620'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T05:54:40.360' ,`MLSNumber` = '20168238' ,`ListAgentFullName` = 'Son Pham' ,`ListOfficeName` = 'Home State Realty Firm LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.689990' ,`Longitude` = '-95.575586' ,`PhotoCount` = '12' ,`PostalCode` = '77072' ,`RoomCount` = '3' ,`ListPrice` = '225000.00' ,`Status` = 'Active' ,`StreetName` = 'Leamont' ,`StreetNumber` = '8111' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1471' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'READY TO MOVE IN.' ,`Acres` = '0.1515' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 13 BELLAIRE WEST SEC 8' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Bellaire West Sec 08' ,`TaxAmount` = '3985' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638652' WHERE `Matrix_Unique_ID` = '212079273'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T05:36:53.830' ,`MLSNumber` = '69577948' ,`ListAgentFullName` = 'Natasha Simon' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.566606' ,`Longitude` = '-95.247491' ,`PhotoCount` = '50' ,`PostalCode` = '77089' ,`RoomCount` = '12' ,`ListPrice` = '439990.00' ,`Status` = 'Active' ,`StreetName` = 'Millstone Canyon' ,`StreetNumber` = '2210' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3578' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! This home includes 5 bedrooms, 3.5 baths, 3 car garage along with media room, gameroom and both formal living and formal dining rooms. The primary bedroom is downstairs with a sitting area with separate access to the backyard as well as the master bath includes separate tub and shower with shower seat. Covered patio and huge backyard on a corner lot w/ remote control fireplace.This home is also energy-efficient and ready to move in! The Brazos\' beautifully designed kitchen connects the formal and breakfast nook. Community amenities include lakes, pool, recreation center & trails. Great access Beltway 8 and I-45 (Pearland Area). Known for their energy efficient features, our homes help you live a healthier & quieter lifestyle while saving on utility bills. Call today for your showing this will not last long!' ,`Acres` = '0.2386' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 6 RIVERSTONE RANCH AT CLEAR CREEK SEC 5' ,`LotDesciption` = 'Corner' ,`LotSize` = '10394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'SOUTH BELT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'RIVERSTONE RANCH AT CLEAR CREEK' ,`TaxAmount` = '14253' ,`TaxRate` = '3.6869' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638652' WHERE `Matrix_Unique_ID` = '212460110'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T05:55:29.560' ,`MLSNumber` = '72624738' ,`ListAgentFullName` = 'Barett Engelhardt' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048540' ,`Longitude` = '-95.379783' ,`PhotoCount` = '23' ,`PostalCode` = '77373' ,`RoomCount` = '5' ,`ListPrice` = '248900.00' ,`Status` = 'Active' ,`StreetName` = 'Pebworth' ,`StreetNumber` = '22910' ,`StreetSuffix` = 'Place' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1474' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Move-in ready single story home LOADED w/ upgrades in the popular Cypress Trails community offering a gated pool, & quick access to Timber Lane Hike/Bike trail, Mercer Botanic Gardens, Cypresswood Golf Club  & more!\r\n\r\nGreat open floorplan connects the modernized kitchen with the family room. Large living room boasts soaring ceilings and lots of natural light. New paint inside and out, new lighting, new luxury vinyl plank, and NO HISTORY OF FLOODING! Superb access to I-45 N Corridor and Hardy Toll Road! Make an appointment today!\r\n\r\nSeller to include One year Home Warranty.' ,`Acres` = '0.1653' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 25 BLK 4 TIMBER LANE SEC 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'GLORIA MARSHALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Timber Lane' ,`TaxAmount` = '4126' ,`TaxRate` = '3.1786' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638652' WHERE `Matrix_Unique_ID` = '213154668'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T05:55:04.913' ,`MLSNumber` = '88935614' ,`ListAgentFullName` = 'Patricia Matthews' ,`ListOfficeName` = 'Century 21 Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.934318' ,`Longitude` = '-95.334904' ,`PhotoCount` = '50' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '249333.00' ,`Status` = 'Active' ,`StreetName` = 'Westwood' ,`StreetNumber` = '1' ,`StreetSuffix` = 'Drive' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This 3/2 has an office/study & many updates & remodeled areas throughout. It sits on an oversized lot with a large private covered deck for outdoor entertaining and relaxing. The open floor plan makes for easy family living with a stunning eat-in kitchen featuring custom cabinets with lazy susan, pull out trash bin, & spice rack. Additional updates include: Seamless Rainmaster Gutters, Porcelain wood-look hand scraped tile throughout the home, can lighting, PEX plumbing, windows, A/C and duct work, roof, water heater, water softener, all Moen faucets. Both bathrooms have been remodeled with wheelchair access in the guest bathroom. Westwood Shores is Lake Livingston\'s premier gated waterfront community. Enter through the 24/7 manned gate to find an abundance of amenities. Including golf, pool, country club with bar and grill, tennis courts, fitness center, miniature golf, and the marina and launch ramp with fishing access to Lake Livingston. Don\'t miss out on this home!' ,`Acres` = '0.3938' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'WESTWOOD SHORES SECTION 04, BLOCK 65 LOT 39' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '17155' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2136' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '63 - Trinity' ,`SchoolElementary` = 'LANSBERRY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TRINITY HIGH SCHOOL (HEB)' ,`SchoolMiddle` = 'TRINITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westwood Shores Sec 4' ,`TaxAmount` = '3489' ,`TaxRate` = '2.5863' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638652' WHERE `Matrix_Unique_ID` = '213443676'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-10-24T05:44:14.120' ,`MLSNumber` = '54438644' ,`ListAgentFullName` = 'Leslie Williams' ,`ListOfficeName` = 'Braggs Broker Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.498054' ,`Longitude` = '-95.544592' ,`PhotoCount` = '41' ,`PostalCode` = '77459' ,`RoomCount` = '15' ,`ListPrice` = '550000.00' ,`Status` = 'Active' ,`StreetName` = 'Otter Creek' ,`StreetNumber` = '8211' ,`StreetSuffix` = 'Way' ,`City` = 'Missouri City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3421' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 8211 Otter Creek Way nestled in Sienna Village of Waters Lake in Sienna. The floor plan offers a huge game room and full bath on the 2nd floor. Office on the 1st floor so you can work from home. The kitchen has dark granite countertops and soft closing drawers. The closet of the first two bedrooms has custom built-in closet organizers and drawers. The primary bedroom is huge and the  bathroom comes with a jetted tub and a gigantic walk-in closet with three levels to hang your clothes. NOTE, the room measurements is an approximate. This house comes equipped with 2 water filtration and an irrigation system. The backyard is huge, private and has a storage shed. This master plan community has 5 swimming pools, 2 water parks, 2 fitness centers, a tennis complex and a golf course. Easy access to the medical center and downtown Houston via highway 288 and Fort Bend Pkwy. Hobby Airport by way of Beltway 8 and I-45 for your travel needs. Schedule your visit today.' ,`Acres` = '0.1875' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Levee District,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SIENNA VILLAGE OF WATERS LAKE SEC 27, BLOCK 1, LOT 15' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '8168' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1307' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SCANLAN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Sienna Village Of Waters Lake Sec 27' ,`TaxAmount` = '8627' ,`TaxRate` = '2.6079' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1666638652' WHERE `Matrix_Unique_ID` = '213505617'  --> 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','213791850','1666638653','213791850','2022-10-24T05:54:47.300','43611373','Joseph Lucco','Frank J. Lucco & Associates','','','30.121671','-95.727794','9','77355','9','220000.00','Active','Turtle Creek','18615','Way','Magnolia','2','0','3','2340','Single-Family','NO DEED RESTRICTIONS PER SELLER. INVESTOR\'S DREAM PROPERTY ON NEARLY A FULL ACRE.  CASH OFFERS PREFERRED. NEEDS WORK AND IS READY TO BE REMODELED BY NEW OWNER/INVESTOR. PRICED TO SELL \"AS IS\". ADDITIONAL HOUSE/STRUCTURE AT REAR OF PROPERTY CONSIDERED TO HAVE NO VALUE-PLEASE DO NOT ENTER. ROOM SIZES ARE APPROXIMATE ONLY, BUYER SHOULD VERIFY.','0.9771','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure,Tenant Occupied','1','','0','Tomball','Central Electric','0','TURTLE CREEK 02, BLOCK 2, LOT 7, ACRES 0.980','Subdivision Lot','42562','Appraisal District','','','0','','0','','0','','','','','Composition','36 - Magnolia','J.L. LYON ELEMENTARY SCHOOL','MAGNOLIA WEST HIGH SCHOOL','MAGNOLIA JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','2','Traditional','Turtle Creek 02','6232','1.8587','Other Water/Sewer,Septic Tank','1995','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','213976238','1666638653','213976238','2022-10-24T05:43:48.927','94993720','Norma Jasso','Walzel Properties','','','29.695992','-95.704833','27','77407','6','359000.00','Active','Flintrock Hollow','7310','Trail','Richmond','2','0','4','2092','Single-Family','You are going to love what this one story home has to offer! It is a 4 bedroom, 2 full baths, with a 2 car garage, located in the Lakeview Retreat in Richmond Tx. Very well cared for by the original owner. This open floor plan features an abundance of natural light and high ceilings. Tall Gourmet Kitchen Cabinets, nice Backsplash Tile, Granite Countertops, Gas Range, and Stainless Steel Appliances. Tile throughout living area and carpet in bedrooms only. Spacious Primary bedroom with Double Sink Vanity, Tub, a seperate shower & Walk- in Closet. The secondary rooms are also spacious. Tankless water Heater, Smart home system connections with Doorbell Camera and Electric Deadbolt. Covered Patio on an oversize lot.  Easy access to Westpark Tollway, Grand Parkway and Hwy 6.. Amenities include: Community Pool and Playground, Walking Trails. For a private tour, Call your Agent today !! No Flooding !','0.176','37','DR HORTON','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Mission Bend Area','Central Electric,Central Gas','1','LAKEVIEW RETREAT SEC 3, BLOCK 5, LOT 7','Subdivision Lot','7665','Appraisal District','','850','0','','2','Gas Oven','0','','','Gas Range','','Tile,Wood Shingle','19 - Fort Bend','SEGUIN ELEMENTARY (FORT BEND)','BUSH HIGH SCHOOL','CROCKETT MIDDLE SCHOOL (FORT BEND)','Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','1','Other Style','Lakeview Retreat Sec 3','8373','3.0697','Water District','2019','Appraisal District');  --> New record created successfully<br />