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-09-27T03:51:46.793' ,`MLSNumber` = '76288148' ,`ListAgentFullName` = 'Gary Bailey' ,`ListOfficeName` = 'Gary S. Bailey' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.004217' ,`Longitude` = '-95.478402' ,`PhotoCount` = '37' ,`PostalCode` = '77068' ,`RoomCount` = '11' ,`ListPrice` = '665000.00' ,`Status` = 'Active' ,`StreetName` = 'Villa Fontana Way' ,`StreetNumber` = '16139' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Superb Luxury Golf Course Patio Home on Large Lot with Excellent Water and Golf Course Views! Gated Entry. Two Bedrooms Downstairs, and Two Bedrooms Upstairs, each with full baths. Kitchen Open to the den for entertaining and fun meals. Breakfast Area with views of the Golf Course and ponds create the perfect setting for a relaxing morning breakfast. Raised Study on Stairway has privacy- easy access.Second Bedroom on First Floor is tucked away and has an entry via the garage for a quite, private and easy access.Flooring is a combination of Travertine and beautiful Engineered Wood! Gameroom Upstairs has a covered Balcony and plenty of room outside to view the Golf Course and Distant Golfers trying to avoid the scenic Water Ponds. Back Yard Bar B Que with a sizeable play area and covered patio for outdoor grilling. Excellent home, slowing down and relaxing a bit, especially if you are still active in tennis and/or golf. Room for swimming pool(All Measurements Not Exact).' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 19 Block 1 Northgate Forest Place' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Patio Lot,Subdivision Lot' ,`LotSize` = '9596' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Northgate Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664270800' WHERE `Matrix_Unique_ID` = '206304508'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T02:51:44.700' ,`MLSNumber` = '59063430' ,`ListAgentFullName` = 'Rita Chanchlani' ,`ListOfficeName` = 'Soluna Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.579774' ,`Longitude` = '-95.549198' ,`PhotoCount` = '32' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Quail Creek' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2774' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique and one of a kind patio home. Very spacious and open with all upgrades. Granite in kitchen, tile and wood floors, built in appliances, crown molding, four bedrooms, walk in closet in master. Huge living and dining room. Lead glass door. Gas cooktop. No carpet in the house. Two car garage with Golf cart parking too. Come see this beautiful home. The backyard is a wrap around the house but the previous owners fenced off a section for their dog. Has gates to the backyard on both sides of the house' ,`Acres` = '0.1571' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL VALLEY PATIO HOMES, LOT 11' ,`LotDesciption` = 'Cul-De-Sac,In Golf Course Community,Patio Lot,Subdivision Lot' ,`LotSize` = '6843' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1047' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'QUAIL VALLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ELKINS HIGH SCHOOL' ,`SchoolMiddle` = 'QUAIL VALLEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Quail Valley Patio Homes' ,`TaxAmount` = '5601' ,`TaxRate` = '2.4603' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664270801' WHERE `Matrix_Unique_ID` = '210935916'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T03:33:57.690' ,`MLSNumber` = '14218267' ,`ListAgentFullName` = 'Jerelynn Smith Foy' ,`ListOfficeName` = 'Sky Real Estate Professionals' ,`SellingAgentFullName` = 'Janice Kopfler' ,`SellingOfficeName` = 'Coldwell Banker RealtyREALTORS' ,`Latitude` = '30.078472' ,`Longitude` = '-95.503242' ,`PhotoCount` = '24' ,`PostalCode` = '77388' ,`RoomCount` = '6' ,`ListPrice` = '263500.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Mandarin Glen' ,`StreetNumber` = '21114' ,`StreetSuffix` = 'Circle' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1558' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Price!! Great house in a convenient and great location. This cozy 1 story home features 3 bedrooms with 2 full baths. Large spacious family room with updated vinyl flooring. Granite countertops large pantry and lots of cabinets in the kitchen. Large primary bedroom with walk in closet. Primary bath features double sinks, separate shower and a garden tub. House sits on a premium lot close to shopping, dining and less than 10 miles from the Woodlands. Home never flooded, high and dry through Harvey and Tax day! Make your appointment today.' ,`Acres` = '0.1717' ,`Area` = '14' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 GOSLING PINES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7479' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'FOX ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'SCHINDEWOLF INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Gosling Pines Sec 02' ,`TaxAmount` = '5076' ,`TaxRate` = '2.644' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664270801' WHERE `Matrix_Unique_ID` = '212404218'  --> 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','212651364','1664270801','212651364','2022-09-27T02:20:14.093','5817162','Cindey Edwards','Southern Star Realty','','','30.041089','-95.526579','50','77379','12','535000.00','Active','River Rapids','7030','Lane','Spring','3','1','5','4647','Single-Family','As the seller\'s are moving out, envision your moving in to new beginnings with everything you can imagine & room enough for anything your heart desires! 5 Bedrooms, 3.5 Baths, Formal Living & Dining, French Doors leading into Study & out to front patio!!! Game room!!! Mediaroom!!! Lakes & walking trails! Amenity Center with kid galore activities! So much to offer you Must See to make your own!!! \r\nDon’t Delay, Call Today! Get your Keys right away!!!','0.1797','13','','','','','Sellers Disclosure','1','Freestanding,Gas Connections','1','Champions Area','Central Gas','1','LT 20 BLK 2 TWIN FALLS SEC 5','Subdivision Lot','7829','Appraisal District','','','0','','2','','0','','','','','Composition','32 - Klein','KUEHNLE ELEMENTARY SCHOOL','KLEIN HIGH SCHOOL','KRIMMEL INTERMEDIATE SCHOOL','Supra Keybox','Appraisal District','2','Traditional','Twin Falls Sec 5','9639','2.5085','Water District','2016','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','212747259','1664270801','212747259','2022-09-27T03:57:18.883','92964983','Shannan Gerik','Hallmark Realty, L.L.C.','','','29.701087','-96.540972','33','78934','3','575000.00','Active','Bonham','536','Street','Columbus','2','1','3','2622','Single-Family','Charming Stately Brick Home near downtown Columbus, TX.\r\n3 Bedroom, 2.5 bath corner lot property near schools, restaurants, churches, and shopping areas of small town Columbus, TX. Built in 1930, this 2.5 story home is set on almost a half of an acre, other impressive features include: yard sprinkler system, fenced-in backyard with spacious flower garden and goldfish pond, 2 car detached garage with extra carport with attached washer/dryer utility area, garden potting area, wood deck, and as an extra bonus-a separate small bldg. which is currently used as a guest house but could be also utilized as a mother-in-law suite, man cave, entertainment area or home office.  Call Hallmark Realty LLC in Columbus for a private showing today.','0.4251','56','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections,Wood Burning Fireplace','2','','Central Electric,Central Gas','0','BLK 34 LT 3 COLUMBUS HOUSE, GARAGE & GUEST HOUSE','Corner','18517','Appraisal District','','','0','','2','Electric Oven,Single Oven','0','','','Electric Range','','Composition','188 - Columbus','COLUMBUS ELEMENTARY SCHOOL','COLUMBUS HIGH SCHOOL','COLUMBUS JUNIOR HIGH SCHOOL','Accompany,Appointment Required','Appraisal District','2.5','Other Style','Columbus','5178','1.8359','Public Sewer,Public Water','1930','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T03:09:04.350' ,`MLSNumber` = '71111817' ,`ListAgentFullName` = 'Francois Delille' ,`ListOfficeName` = 'Cozy Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.332483' ,`Longitude` = '-95.502485' ,`PhotoCount` = '48' ,`PostalCode` = '77304' ,`RoomCount` = '6' ,`ListPrice` = '359995.00' ,`Status` = 'Active' ,`StreetName` = 'Holly Laurel' ,`StreetNumber` = '2503' ,`StreetSuffix` = 'Manor' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2383' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4 bedroom home is nestled in a nature-like setting, there is a nice pond on the side of the home with a huge backyard that is great for entertaining with family and friends. So please, look no further!!!! Set an appointment today and tour this lovely beauty to make this your home and create many memories. We are currently repairing the stairs.' ,`Acres` = '0.164' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S327803 - CANYON CREEK 03, BLOCK 4, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7146' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Creek 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664270801' WHERE `Matrix_Unique_ID` = '212868175'  --> 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','212924157','1664270801','212924157','2022-09-27T03:54:22.650','30546976','Marina Okorocha','Lone Star Realty','','','30.808526','-95.583164','22','77320','11','198900.00','Active','Avenue F','701','Boulevard','Huntsville','2','0','3','2304','Single-Family','Hidden Treasure is less than Minutes away from I-45, and Sam Houston University. \r\nNatural lighting, all Brick Home has plush white carpet in oversized bedrooms; ready to be styled and decorated; humongous bathrooms with vanity. Not to mention there are Skylights throughout the home!\r\nTake a walk to the historic downtown loaded with family fun and festivities for the seasons!\r\nThe property Depicts mature oak and pine trees in a peaceful neighborhood. Relax under the covered patio porch and covered car parking spaces. This nice-sized home sits on half an acre of land.\r\nDon’t miss out on this Gem of an opportunity to own your own Country Oasis.\r\n\r\n\r\nPriced to sell, under appraised value.  As-Is.','0.5422','43','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','Huntsville Area','Central Electric,Central Gas','0','WOODLAWN, LOT 34, 35, 36, 37','Corner','23618','Appraisal District','','','0','','0','Electric Oven','0','','','Electric Cooktop','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Lockbox Left Side,Request Online Appointment','Appraisal District','1','Traditional','WOODLAWN','3799','1.901719','Public Sewer,Public Water','1968','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-27T02:12:19.420' ,`MLSNumber` = '70325150' ,`ListAgentFullName` = 'Karen Gillespie' ,`ListOfficeName` = 'Karen Gillespie Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765297' ,`Longitude` = '-95.479201' ,`PhotoCount` = '21' ,`PostalCode` = '77057' ,`RoomCount` = '7' ,`ListPrice` = '885000.00' ,`Status` = 'Active' ,`StreetName` = 'Tangle Circle' ,`StreetNumber` = '5742' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3034' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! A gated Tanglewood Treasure. Tangle Circle Lane offers first floor living three to four bedrooms or gameroom, three and half baths and large private patio. First floor features a grand entry, living area, formal dining and island kitchen with breakfast area and a large walk in pantry. Additional features include hardwood floors, gas fireplace, crown molding throughout and new stainless steel appliances. The second floor features secondary bedrooms a large primary suite with high ceilings, double vanity, soaking tub, stand up shower with two large walk in closets and a private water closet. Third floor fourth bedroom with full bath/ Secondary Master or Flex space.' ,`Acres` = '0.0624' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 TANGLEWOOD CIRCLE' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2719' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Circle' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1664270801' WHERE `Matrix_Unique_ID` = '212984742'  --> Updated record success<br />