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-11T23:38:59.653' ,`MLSNumber` = '14765659' ,`ListAgentFullName` = 'Alizain Maredia' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.754772' ,`Longitude` = '-95.728082' ,`PhotoCount` = '22' ,`PostalCode` = '77320' ,`RoomCount` = '9' ,`ListPrice` = '154900.00' ,`Status` = 'Active' ,`StreetName` = 'Jacob' ,`StreetNumber` = '17' ,`StreetSuffix` = 'Street' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1680' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful 4 bedroom/2 bathroom house is located just northwest of Huntsville. The Living Room is spacious and open with plenty of windows for natural light. Open Kitchen/Living/Dining areas. Split bedroom floor plan. Large master suite with walk-in closets; master bath features double sinks, large shower + garden tub. Large decks provides plenty of room for outdoor living space.' ,`Acres` = '0.601' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COGAN\'S CREEK, BLOCK 2, LOT 9, ACRES .601, MH LABEL# PFS0772' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '26180' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SAMUEL W HOUSTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cogans Creek' ,`TaxAmount` = '1205' ,`TaxRate` = '1.7534' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675126645' WHERE `Matrix_Unique_ID` = '212875433'  --> 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','214581713','1675126645','214581713','2023-01-12T00:33:45.263','31670501','Cecilia Cardenas','RE/MAX Grand','','','29.747344','-95.816029','43','77494','9','1999900.00','Active','Hunter','25927','Lane','Katy','5','1','5','6525','Single-Family','STUNNING NEW HOME ON ALMOST 1 ACRE WITH HEATED POOL AND SPA 5.5 BATHROOMS, BEAUTIFUL MEDIA ROOM PRE-WIRED FOR SURROUND SYSTEM AND PROJECTOR. HUGE GAME-ROOM AND STUDY. WINE CELLAR, 3.5 CAR GARAGE WITH EPOXY FLOORS. BUILT WITH QUALITY CRAFTMANSHIP THROUGHTOUT FROM STRONG PIER-BEAM FOUNDATION,2 A/C UNITS, 30 YEAR ROOF MATERIAL, ENERGY EFFICIENT WINDOWS AND FRONT, BACK DOOR, SPREAD FOAM INSULATION GIVES A VERY WEATHER TIGHT HOME. CIRCULAR DRIVEWAY WITH CONTROL IRON GATES. STONE AND STUCCO ELEVATION, 2 PATIOS, ONE WITH OUTDOOR KITCHEN.','0.9','36','LLC CONTRUCTION','','Electric Dryer Connections','','Owner/Agent,Sellers Disclosure','1','Freestanding','2','Katy - Southwest','Central Electric','0','0149 G W CARTWRIGHT, TRACT 15A (PT TR 6A) S/2 TR 15, ACRES .','Wooded','39204','Appraisal District','','','1','Never Lived In','3','Double Oven,Electric Oven','1','Heated,In Ground','','Electric Cooktop','','Composition','30 - Katy','WOODCREEK ELEMENTARY SCHOOL','TOMPKINS HIGH SCHOOL','CINCO RANCH JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Contemporary/Modern','G W Cartwright','4612','1.9045','Aerobic,Well','2022','Builder');  --> 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','215752554','1675126645','215752554','2023-01-12T00:33:42.893','68252418','Brooke Mason','Cross-Town Realty, LLC','','','30.494579','-96.468722','7','77878','7','254900.00','Active','Rustic Trace','101','','Snook','2','0','4','','Single-Family','You\'ll want to own this new-build home in the Grand Lake Community. This beautiful home features a flex room that could function as a study, craft room, or whatever else suits your needs. The kitchen highlights gorgeous cabinets, granite countertops, and Steel Appliances. In the primary bedroom, there is a private en-suite bath complete with dual vanity sinks and walk-in closet. The 3 secondary bedrooms are well-sized and share a full-sized bath. You\'ll love this dream home that\'s topped off with a relaxing porch and a 2-car garage.','','59','Century Complete Bld','','','','No Disclosures','','','','','Central Electric','1','S3451 GRAND LAKE OF SNOOK BLK 1 LOT 15, .254 ACRES','Subdivision Lot','','','','65','1','Never Lived In','2','','0','','','','','Composition','192 - Snook','SNOOK ELEMENTARY SCHOOL','SNOOK SECONDARY SCHOOL','SNOOK MIDDLE SCHOOL','Appointment Required','','1','Traditional','Grand Lake','','','Public Sewer,Public Water','','');  --> 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','216046874','1675126645','216046874','2023-01-11T23:21:23.003','28893539','Jared Turner','LennarVillageBldr-JaredTurner','','','29.518503','-95.784257','10','77471','8','335990.00','Active','Falling Moon','3604','Lane','Rosenberg','2','0','3','1990','Single-Family','NEW!  Lennar Fairway Collection \"Blackstone\" Plan with Elevation \"G\" in Sendero!  The beautiful one-story Blackstone plan by Lennar features an inviting front porch and entry foyer, a dining room, an island kitchen with walk-in pantry and breakfast room that offers access to a relaxing covered rear patio, a generous open family room  and a walk-in utility room. The master bedroom features an en suite master bathroom with dual sinks, stand-up shower, private toilet enclosure, and access to a large master closet.  *HOME ESTIMATED TO BE COMPLETE, APRIL, 2023*','','30','Lennar','','','','Mud,Other Disclosures','1','','0','Fort Bend South/Richmond','Central Gas','1','SEC 0005 BLK 001 LOT 050','Subdivision Lot','','','','756','1','To Be Built/Under Construction','2','','0','','','','','Composition','33 - Lamar Consolidated','MEYER ELEMENTARY SCHOOL (LAMAR)','RANDLE HIGH SCHOOL','WRIGHT JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Sendero','','3.09','Water District','2023','Builder');  --> 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','216289798','1675126645','216289798','2023-01-11T23:13:51.427','16095601','Carmen Weigle','American Realty','','','29.161486','-95.425319','12','77515','5','179500.00','Active','Plum','600','Street','Angleton','1','1','3','1192','Single-Family','Cozy Angleton home with 3 bedroom, 1.5 bathrooms with attached one car garage. This home has brand new wood look laminate flooring through out the home.  Freshly painted inside, including the kitchen cabinets.  Large family/living room with enough space for dining table.  Split floor plan.  Fenced in back yard, corner lot with shade trees. Garage access off of Anderson Street with additional parking.  Call today to schedule a showing.','0.1462','5','','','Electric Dryer Connections','','Sellers Disclosure,Special Addendum','1','','','Angleton','Central Gas','0','SANDY ACRES (ANGLETON) BLK 2 LOT 1','Subdivision Lot','6368','Appraisal District','','','0','','1','Gas Oven','0','','','Electric Range,Gas Range','','Composition','5 - Angleton','SOUTHSIDE ELEMENTARY SCHOOL (ANGLETON)','ANGLETON HIGH SCHOOL','ANGLETON MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Appraisal District','1','Ranch','Sandy Acres Angleton','2617','2.4554','Public Sewer,Public Water','1952','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','216309471','1675126645','216309471','2023-01-12T00:12:28.987','62138114','Pamela Ledet','Texas Ethics Realty, LLC','','','30.801000','-95.454327','42','77320','5','369900.00','Active','State Highway 19','3015','','Huntsville','2','0','3','1404','Single-Family','Great Business Opportunity with this Commercial and Residential property with 396 feet of Highway frontage. With almost 1 acre right off Highway 19 in Huntsville. This already established Antique and Resale Store comes fully stocked with hidden gems & a 3 bedroom 2 bath home built in November 2008 that sits behind it. Carport, multiple storage sheds, & RV Sewer & water Hookup. House could be used for residential use or turned into another shop. New Roof 2020! 50 blocks & Beams! Smart Boards w/termite protection! 3 septic tanks pumped and clean! No Carpet! All SS Appliances! The possibilities are endless! Call & schedule your showing today!','0.97','43','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Huntsville Area','Heat Pump,Wall Heater','0','MURRAY O (A-666), TRACT 6, ACRES .97','Cleared,Other,Wooded','42253','Appraisal District','','','0','','0','Convection Oven','0','','','Freestanding Range','','Composition','64 - Huntsville','HUNTSVILLE ELEMENTARY SCHOOL','HUNTSVILLE HIGH SCHOOL','MANCE PARK MIDDLE SCHOOL','Appointment Required,Leave Business Card,Supra Keybox','Appraisal District','1','Traditional','MURRAY','3301','1.6542','Public Water,Septic Tank','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','216309704','1675126645','216309704','2023-01-11T23:44:44.640','30733577','Rayito Stephens','Real Properties of Texas, PLLC','','','29.841418','-95.682924','30','77084','9','379990.00','Active','Longmoor','18335','Drive','Houston','3','1','4','3113','Single-Family','Beautiful custom home in fantastic community with mature trees. Stately, located on quiet cul de sac lot with 4 bedrooms (2 with built in desks and shelves), spacious study/additional bedroom/office downstairs by main entry. Spacious gameroom with built-in desk, three bedrooms upstairs. Lovely living area with spacious formal dining. Chef\'s kitchen with cooktop on island and granite countertops, walk-in pantry, open to breakfast with beautiful view of the backyard. Has 3.5 baths, 2 car detached garage, new carpet, new interior and exterior paint. Master down with walk-in jetted tub and separate shower, double closets and double sinks. Hollywood bath upstairs with double sinks.  Beautiful wood floors in the living, study, dining and mosaique floor on entry.  Gazebo in back. Community pool, walking trails, close shopping, easy commute, LOW TAXES, Estimated room measurements. 1st floor great for elderly or disabled person, lift on stairwell that has not been operated, can be removed.','0.2652','8','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','1','Bear Creek South','Central Gas','1','LT 9 BLK 47 DEERFIELD VILLAGE SEC 5','Cul-De-Sac','11551','Appraisal District','','835','0','','1','Double Oven','0','','','Gas Cooktop','','Composition','13 - Cypress-Fairbanks','WILSON ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS LAKES HIGH SCHOOL','WATKINS MIDDLE SCHOOL','Appointment Required,Vacant/Unoccupied','Appraisal District','2','Traditional','Deerfield Village Sec 05','6687','2.251','Water District','1987','Appraisal District');  --> New record created successfully<br />