Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T19:00:53.203' ,`MLSNumber` = '88282840' ,`ListAgentFullName` = 'Pamela Green' ,`ListOfficeName` = 'Douglas Elliman Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.474330' ,`Longitude` = '-99.754342' ,`PhotoCount` = '26' ,`PostalCode` = '79603' ,`RoomCount` = '6' ,`ListPrice` = '110000.00' ,`Status` = 'Active' ,`StreetName` = 'Green' ,`StreetNumber` = '2157' ,`StreetSuffix` = 'Street' ,`City` = 'Abilene' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '650' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house has been fully renovated with no corners cut! Brand new, high-end kitchen cabinets, brand new laminate wood flooring, new appliance, ceiling fans, and faucets, cast-iron, new farm style kitchen sink, new pedestal bathroom sink, toilet, and tub. New tiled shower wall and kitchen backsplash. New energy efficient windows with new 1 1/2” blinds. Cleaned and graded front and backyard. Re-roof work done! New walkway from street to front door!!! State of the art mini-split AC/heat pump system in each room. Minutes from universities, hospitals, dining. Full 4 camera security system installed.' ,`Acres` = '' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'BLOCK 21, LOT 34 & N15 OF LT 33' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5940' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '275 - Abilene' ,`SchoolElementary` = 'ORTIZ ELEMENTARY SCHOOL (ABILENE)' ,`SchoolHigh` = 'ABILENE HIGH SCHOOL' ,`SchoolMiddle` = 'MANN MIDDLE SCHOOL (ABILENE)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sears Park (W of Catclaw, Woodland' ,`TaxAmount` = '877' ,`TaxRate` = '2.6705' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675099005' WHERE `Matrix_Unique_ID` = '207074120'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T19:20:36.663' ,`MLSNumber` = '3438935' ,`ListAgentFullName` = 'Kayla Riddle' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.189991' ,`Longitude` = '-95.651606' ,`PhotoCount` = '40' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '1295000.00' ,`Status` = 'Active' ,`StreetName` = 'Dobbin Huffsmith' ,`StreetNumber` = '31353' ,`StreetSuffix` = 'Road' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2611' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 8.2 acres of unrestricted property! This property can be used for commercial and/or residential purposes, the best of both worlds! Conveniently located on Dobbin Huffsmith, alongside many other commercial properties. The proposed WoodTrace Blvd. Extension will connect FM 2978 to SH 249, and will travel through Dobbin Huffsmith- just minutes from this property! The property boasts a single family home with 10 foot ceilings throughout, a large office, 3 bedrooms and 2.5 baths, and an open concept kitchen. The home also has approximately 600-800 sq ft of attic space that could easily be converted to additional living space or office space. The oversized shop is 1600 sq ft with a 400 sq ft office with large commercial tempered glass windows. The shop features 2 Trane heat pump A/C and heating systems, one to service the shop and one for the office space. Towards the back you will find a large socked pond. This property truly has it all!' ,`Acres` = '8.2' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0533 - SMITH JOHN H, TRACT 2D1-A, ACRES 2.15' ,`LotDesciption` = 'Cleared,Corner,Other,Water View' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'MAGNOLIA PARKWAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith John H' ,`TaxAmount` = '4491' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675099005' WHERE `Matrix_Unique_ID` = '212443758'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T19:32:17.210' ,`MLSNumber` = '4812695' ,`ListAgentFullName` = 'Patricia Dajani' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = 'Jeanine Kaminski-Ditzel' ,`SellingOfficeName` = 'Douglas Elliman Real Estate' ,`Latitude` = '29.726833' ,`Longitude` = '-95.392276' ,`PhotoCount` = '35' ,`PostalCode` = '77006' ,`RoomCount` = '12' ,`ListPrice` = '1999000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Berthea' ,`StreetNumber` = '1105' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '5500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another Stunning Offering from Gotham Development and Allie Wood Design Studio! This is an Incredible Modern home with fine finishes & details throughout! Features include: Queen Painted Brick Exterior, Pella windows, Elevator, Linear Vents, Wide Plank Wood Flooring (except baths). The first floor features a fantastic Island Kitchen with Breakfast Bar Seating open to the Family Room with a fireplace, built-ins & sliding wall of Glass Windows. There is also a Formal Entry, Chic Wine Vault/Bar, Dining Room with Paneled Walls and detailed ceiling. Owner\'s Suite with a Fireplace, Built-Ins & Terrace, Two Wardrobe Areas, Luxurious Master Bathroom with two Water Closets. Study with Paneled Walls, Built-Ins & Game Room with Terrace. Home Gym with a Glass Wall & Private Guest Suite. Back Yard/Patio with a Privacy Wall, Pergola, Outdoor Kitchen & Yard with room for a Pool, which is not included. Terraces finished with Water Proofing System. Located in Museum District! Completion Jan/Feb 2023.' ,`Acres` = '' ,`Area` = '17' ,`BuilderName` = 'Gotham Development' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Mock Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 1 2 3A & 11 BLK 9 TURNER N P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3658' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,French' ,`Subdivision` = 'Turner N P' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675099005' WHERE `Matrix_Unique_ID` = '212770684'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T19:13:45.587' ,`MLSNumber` = '64408851' ,`ListAgentFullName` = 'Russell Jackson' ,`ListOfficeName` = 'Criswell & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.726725' ,`Longitude` = '-95.357587' ,`PhotoCount` = '14' ,`PostalCode` = '77004' ,`RoomCount` = '6' ,`ListPrice` = '174000.00' ,`Status` = 'Active' ,`StreetName` = 'Berry' ,`StreetNumber` = '3279' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Investor Property!!  The property is located in a prime area, in proximity to U of H and TSU central campus.  Close to all major sporting arenas, medical center, museum district, downtown, and Metro-rail.  The home features granite countertops, central AC, and heat.  Also includes an enclosed utility room attached to the rear of the home.  No showing at this time until an offer is received,' ,`Acres` = '0.0943' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 16 FOREST HOME' ,`LotDesciption` = 'Other' ,`LotSize` = '4108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BLACKSHEAR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Forest Home' ,`TaxAmount` = '2631' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675099005' WHERE `Matrix_Unique_ID` = '214131664'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-02T20:17:36.227' ,`MLSNumber` = '63444564' ,`ListAgentFullName` = 'Darell Clem' ,`ListOfficeName` = 'Town & Country Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738468' ,`Longitude` = '-94.935460' ,`PhotoCount` = '41' ,`PostalCode` = '77520' ,`RoomCount` = '13' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Kilgore' ,`StreetNumber` = '1719' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '5076' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home this Hugh 5,000 plus square feet Home is amazing!! Spacious 5 bedrooms, 3 full baths. 2 half baths, 2 fireplaces, large family room, indoor cedar steam spa .  Property is perfect for large families or extended families, pretty acreage surrounded by wrought iron fence, with a beautiful pool,   plus a 1 bedroom , 1 bath guest house! There is a water well on property, a tennis/pickle ball court.  Rooms sizes are approximate. THIS HOME HAS EVERYTHING YOU WANT!  You will not want to miss this one !!' ,`Acres` = '7.41' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 25B 25C 26A & 26A-1 ABST 69 C SMITH' ,`LotDesciption` = 'Other' ,`LotSize` = '322779' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Smith C' ,`TaxAmount` = '12578' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675099006' WHERE `Matrix_Unique_ID` = '214407550'  --> 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','215340286','1675099006','215340286','2023-01-02T20:01:24.470','92592504','Jesus Alvarado','CENTURY 21 Western Realty','','','29.764784','-95.889746','29','77423','4','378900.00','Active','Boulder Bend','9948','Lane','Brookshire','3','1','4','2532','Single-Family','*** Beautiful 2 Story home in sought after Willow Creek Farms subdivision. Home features 4 bedrooms, 3 1/2 baths, spacious living area. The downstairs is completely tiled, and carpet in all bedrooms upstairs. You will love the kitchen w/granite counter tops, gas cooking, ample storage, open to the living area and features a large island, solid surface counters, and 42\" cabinets. Master bath includes double sinks, a garden tub, separate walk-in shower & and huge walk-in closet! Spacious guest bedrooms located up  stairs w/walk-in closets. One of the guest bedrooms has it\'s very own attached bathroom. Plenty of storage closets throughout. Extra room found downstairs, perfect office space to work from home.  Schedule your tour today!!','0.1328','26','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Katy - Southwest','Central Gas','1','S976105 WILLOW CREEK FARMS SEC5 BLK 4 LOT 18 ACRES .1328','Subdivision Lot','5785','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','30 - Katy','BRYANT ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','WOODCREEK JUNIOR HIGH SCHOOL','Appointment Required','Appraisal District','2','Traditional','Willow Creek Farms Sec5','10046','3.1705','Public Sewer,Public Water,Water District','2014','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','215776705','1675099006','215776705','2023-01-02T19:17:10.797','90687561','Maria Kogan','REALM Real Estate Professional','','','29.984132','-95.497327','32','77066','6','295000.00','Active','San Clemente','12714','Street','Houston','2','0','4','1858','Single-Family','Lovely 1-story, 4-bedroom, 2 bathroom, detached garage, traditional home with an enormous back yard. Remodeled approximately 2015 with granite kitchen and bathroom countertops, brush nickel hardware, facets, modern lighting, and trim molding through out the home. Central to living room is a gas brick fireplace sprawling the length of the cozy living room. Newly installed modern flooring added through the majority of home December 2022, also painted interior with light and neutral paint in December 2022. Minutes to 1960 close to shopping and dining.  Easy access to Beltway 8 and 249.','0.2732','13','','','','','Exclusions,Mud,Sellers Disclosure','1','Gas Connections','1','1960/Cypress Creek South','Central Gas','1','LT 10 BLK 11 FOUNTAINHEAD SEC 1','Subdivision Lot','11900','Appraisal District','','275','0','','1','Electric Oven','0','','','Electric Cooktop','','Composition','32 - Klein','GREENWOOD FOREST ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','WUNDERLICH INTERMEDIATE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Fountainhead Sec 01','5669','2.6215','Water District','1976','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','215833719','1675099006','215833719','2023-01-02T19:01:47.523','8428962','Azalea Marquez','Texas Premier Realty','','','29.841151','-95.550191','32','77041','7','266000.00','Active','Shadowdale','4938','Drive','Houston','2','0','3','1607','Single-Family','Great Property well cared for by owners.  3 bedroom 2 bath with spacious and high ceiling in living area.  Wood burning fireplace.  Owner added a 9x17 gameroom.  Kitchen has newer cabinets.  Exterior has 2.5 year old roof and all exterior wood replaced with cement fiberboard with new paint.  2 year old fence and 1 year old Central Heating and Air.  New interior paint also.  Clean and ready for new residents.  Call to schedule a showing.','0.1538','24','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','0','Freestanding,Wood Burning Fireplace','1','Spring Branch','Central Electric','1','LT 2 BLK 11 WESTBRANCH SEC 2','Cleared,Subdivision Lot','6700','Appraisal District','','275','0','','2','Electric Oven','0','','','Electric Range','','Composition','13 - Cypress-Fairbanks','KIRK ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Appointment Required','Seller','1','Contemporary/Modern','Westbranch Sec 02','5614','2.5842','Public Sewer,Public Water','1983','Appraisal District');  --> New record created successfully<br />