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-12-31T16:19:43.100' ,`MLSNumber` = '29896445' ,`ListAgentFullName` = 'Brenda Moon' ,`ListOfficeName` = 'Alliance Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.047512' ,`Longitude` = '-95.335551' ,`PhotoCount` = '42' ,`PostalCode` = '77373' ,`RoomCount` = '12' ,`ListPrice` = '1999999.00' ,`Status` = 'Active' ,`StreetName` = 'Treaschwig' ,`StreetNumber` = '6530' ,`StreetSuffix` = 'Road' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4528' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful unrestricted Ranch Style home on approximately 27.34 acres. Located in desirable Spring, Texas. Area attractions include but not limited too, scenic forested trails in Carter Park along Spring Creek great for hiking, biking and equestrian activities.  Cypresswood Golf Club,  Property has a 6 stall barn and tack room with a fully fenced pasture.  Home features 5/6 bedrooms with built-ins and large closets.  Primary suite on 1st floor.  Kitchen is a cooks dream and offers great entertaining options, formal dining, Executive Study/Office to allow privacy for remote work from home. Huge bonus room upstairs that can be used for game room or whatever your heart desires.  Crown molding, 6 car garage with loft, plenty of parking for entertaining, RV, ETC.  Easy access to Houston IAH Airport, shopping, and dining.  Property is AG EXEMPT so bring your horses.  Great Income Development Opportunity.  THIS PROPERTY IS A MUST SEE!!!  All sizes are approximate and should be verified.' ,`Acres` = '27.34' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 11C-2 23A-1A 23A-2 & 23B-1 (HOMESITE) ABST 282 R GILES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '1190930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Giles Robert' ,`TaxAmount` = '9226' ,`TaxRate` = '2.1367' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098020' WHERE `Matrix_Unique_ID` = '206847096'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T15:04:40.570' ,`MLSNumber` = '44930553' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507853' ,`Longitude` = '-95.004216' ,`PhotoCount` = '43' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '477990.00' ,`Status` = 'Active' ,`StreetName` = 'Summer Sunrise' ,`StreetNumber` = '4939' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2200' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Juniper Floor Plan featuring 1-Story, 5 Beds, 3 Baths and 2-Car Garage! Vinyl Plank Flooring in all Main Areas, Spacious Kitchen with 42\" Snowbound Cabinets with Cabinet Hardware & Living Areas, Island with Omegastone Countertops, 8\' Interior Doors & Oversized Covered Patio!  Fully Sodded Yard with Sprinkler System!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 5 Section 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '11063' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098020' WHERE `Matrix_Unique_ID` = '207986032'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T15:00:57.260' ,`MLSNumber` = '14899266' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507853' ,`Longitude` = '-95.004216' ,`PhotoCount` = '18' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '489990.00' ,`Status` = 'Active' ,`StreetName` = 'Sellers Island' ,`StreetNumber` = '2716' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2655' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coastal living at its finest at Coastal Point community. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. Stunning NEW construction Magnolia floor plan is a 2-Story, 3 beds with study & upstairs game room, 2.5 baths & 2-car garage! The kitchen is open & bright offering bright white kitchen backsplash, slate gray cabinets, brown itabaria granite countertops & graphite wood flooring. Fully Sodded Yard with Sprinkler System & Extended Covered Patio! Home will be ready for an October move-in!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 34 Block 3 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098020' WHERE `Matrix_Unique_ID` = '210407537'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T15:18:17.457' ,`MLSNumber` = '6888797' ,`ListAgentFullName` = 'Ernesto Guevara' ,`ListOfficeName` = 'Vive Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.742750' ,`Longitude` = '-95.240780' ,`PhotoCount` = '36' ,`PostalCode` = '77547' ,`RoomCount` = '4' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '1905' ,`StreetSuffix` = 'Street' ,`City` = 'Galena Park' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two homes for the price of one!! Don\'t miss out on this beautiful 4 bed/ 2 full bath custom home that is walking distance from the local food store. This home features many details in the exterior as well as the interior that give the home character, from the tile flooring, the crown molding and the kitchen with newly installed granite countertops and tile backsplash. Walking out of the back door you will find your self under a large covered patio, perfect for those family BBQs. Across the patio you will enter into a large air conditioned game room/living room that is connected to the guest house and it features a custom built bar. The guest house has 2bed, 1full bath, a kitchen with granite countertops, a living room and a laundry room. No HOA!!' ,`Acres` = '0.2296' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 4 & 1O BLK 78 CLINTON' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'MACARTHUR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Clinton' ,`TaxAmount` = '6853' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675098020' WHERE `Matrix_Unique_ID` = '211279865'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T16:56:33.713' ,`MLSNumber` = '86361367' ,`ListAgentFullName` = 'Lindsey Williams' ,`ListOfficeName` = 'Keller Williams Realty Austin' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.686770' ,`Longitude` = '-95.265714' ,`PhotoCount` = '15' ,`PostalCode` = '77331' ,`RoomCount` = '5' ,`ListPrice` = '226500.00' ,`Status` = 'Active' ,`StreetName` = 'Willow Springs' ,`StreetNumber` = '870' ,`StreetSuffix` = 'Road' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Country living at its finest. Perfect place to relax and enjoy the abundant wildlife. This 3 bedroom 2 bath home offers a split bedroom plan that is ideal for privacy for the primary bedroom. With a living room and an additional sitting area off of the kitchen there is plenty of room for the whole family. The en suite bathroom off the primary bedroom features a large soaking tub to wind down in after a long day. This property is ready for your horses, cattle or fur babies as it is fenced and offers a pole barn for shelter. If you\'re looking for a private and quite place to call home, look no further!' ,`Acres` = '2.5' ,`Area` = '64' ,`BuilderName` = 'Fleetwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A225 WILLIAM MCGEE, TRACT 4.1, ACRES 2.5' ,`LotDesciption` = 'Other' ,`LotSize` = '108900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'n/a' ,`TaxAmount` = '852' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675098021' WHERE `Matrix_Unique_ID` = '213511960'  --> 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','215918764','1675098021','215918764','2022-12-31T15:14:51.213','2416990','Jane NgaDung Nguyen','Alpha, REALTORS','','','29.892893','-95.691175','13','77433','7','285000.00','Active','Westgate Park','18722','Drive','Cypress','2','1','3','2130','Single-Family','Solid wood cabinets in kitchen. Cultured Marble Countertops in Kitchen and baths. Stainless Steel appliances. 1st floor is hard wood & tile. AC coil (2mos old with 10-years transferrable warranty). Fence all around ( 2yrs), water heater (2 yrs). garage door (2yrs). Gutter around, lease is up July 31,2023. Current rent is $ 1700. Need 2 hrs notices.','0.1133','25','','','','','Sellers Disclosure','1','','','Cypress South','Central Gas','1','LT 4 BLK 3 WESTGATE SEC 15','Cleared','4937','Appraisal District','','660','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','13 - Cypress-Fairbanks','COPELAND ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS SPRINGS HIGH SCHOOL','KAHLA MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','2','Traditional','Westgate Sec 15','5414','2.671','Water District','2008','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','215921644','1675098021','215921644','2022-12-31T16:34:23.337','21886391','Casey Lawson-Knox','Realty Associates','','','30.325134','-94.976687','20','77327','6','340000.00','Active','County Road 2234 2','142','','Cleveland','2','1','3','2198','Single-Family','DO NOT MISS this cute country home with a new 50 Year Roof and A/C System on over an acre! Here you can enjoy the country life but also be just a short drive to dining, shopping, entertainment and more! This spacious home sits on over an acre and features a huge living room with high ceilings that is semi-open to the kitchen via the large breakfast bar, a separate breakfast and dining area that could be used as a home office or a second living area, a spacious primary with en-suite bath that features a large soaking tub and handicap accessible shower, and roomy secondary bedrooms with huge closets! The kitchen comes equipped with all appliances, ample cabinet space and a pantry! Schedule your showing today!','1.189','52','','','Washer Connections','','Sellers Disclosure','1','','0','Cleveland Area','Central Gas','0','000025 M DONAHO, TRACT 309, ACRES 1.189','Cleared','51793','Appraisal District','','','0','','2','Gas Oven','0','','','Gas Range','','Composition','102 - Tarkington','TARKINGTON PRIMARY SCHOOL','TARKINGTON HIGH SCHOOL','TARKINGTON MIDDLE SCHOOL','Accompany,Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','M Donaho','4469','1.4124','Aerobic,Public Water','2000','Appraisal District');  --> New record created successfully<br />