Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-26T01:22:35.307' ,`MLSNumber` = '19708229' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.056062' ,`Longitude` = '-95.415176' ,`PhotoCount` = '32' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Creekside' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Lane' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3580' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Creekside in Lake Jackson. This home is built by Aplin Homes. The home will be a very spacious 5 bedroom, 3 bathroom, and 3 car attached garage. The primary room has a massive closet with plenty of storage space. Upstairs, there is a bonus room. Don\'t let this home pass you by, make it your forever! Call today for your private showing.' ,`Acres` = '0.4456' ,`Area` = '5' ,`BuilderName` = 'Aplin Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'CREEKSIDE SD SEC 4 (A0066 JE GROCE) (LAKE JACKSON) BLK 4 LOT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside SD' ,`TaxAmount` = '1249' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675258684' WHERE `Matrix_Unique_ID` = '208045728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-26T01:22:35.307' ,`MLSNumber` = '77690629' ,`ListAgentFullName` = 'Sara Robertson' ,`ListOfficeName` = 'RE/MAX American Dream' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.387734' ,`Longitude` = '-95.287711' ,`PhotoCount` = '28' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1462' ,`StreetNumber` = '10726' ,`StreetSuffix` = 'Road' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3172' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEWLY UPDATED! NEW PRICE!! This Ranch style home has it all! Over 3100 square feet of living space including 4 bedrooms, 2.5 bathrooms, Family room with wet bar and fireplace, island cooktop kitchen, HUGE in-house utility room, and an oversized flex room. Updates include new interior paint and flooring throughout, Quartz countertops & ceramic tile backsplash in the kitchen, brand new dishwasher and wine fridge, tile shower surrounds in both bathrooms and a new cast iron tub in the hall bath! 25x30 Shop, 2 car attached/detached garage, covered front and back porches, walking distance to Bob & Betty Nelson Elementary!!' ,`Acres` = '1.9' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MASTERSON (A0100 F MOORE) LOT 1B1B1 ACRES 1.9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '82764' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'NELSON ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRVIEW JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Right Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Masterson' ,`TaxAmount` = '7422' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675258684' WHERE `Matrix_Unique_ID` = '209670325' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-26T01:22:35.307' ,`MLSNumber` = '71237850' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.039654' ,`Longitude` = '-95.405887' ,`PhotoCount` = '32' ,`PostalCode` = '77531' ,`RoomCount` = '6' ,`ListPrice` = '369900.00' ,`Status` = 'Active' ,`StreetName` = 'Jackson' ,`StreetNumber` = '506' ,`StreetSuffix` = 'Avenue' ,`City` = 'Clute' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2526' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to College Park Estates! This is a beautiful 4 bedroom, 2.5 bathroom with a 2 car attached garage! This is a split floor plan. The kitchen is a chef\'s dream with plenty of cabinet and counter space and it opens up to the living room. The countertops and backsplash have been updated. The primary bedroom is very spacious with an updated bathroom. Access the backyard oasis from the primary bedroom. There is a tiki bar and hot tub. The home has a beautiful lake view from the backyard. There is a screen patio, also great for entertaining! You don\'t want to miss out on this home, call today for your private showing!' ,`Acres` = '0.2938' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Clute' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COLLEGE PARK ESTATES SEC 4 (A0066 J E GROCE) (CLUTE) BLK 2 L' ,`LotDesciption` = 'Cleared,Subdivision Lot,Waterfront' ,`LotSize` = '12798' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'GRIFFITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'CLUTE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'College Park Estates' ,`TaxAmount` = '8904' ,`TaxRate` = '2.6231' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675258684' WHERE `Matrix_Unique_ID` = '212700554' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-26T01:22:35.307' ,`MLSNumber` = '55411525' ,`ListAgentFullName` = 'Sharon Powell' ,`ListOfficeName` = 'Insight Realty Network' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.837656' ,`Longitude` = '-95.792563' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '9' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Windflower Valley' ,`StreetNumber` = '4427' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful immaculate home has not been lived in long 4 bedroom, 3.5 bath 2-story home in Katy Pointe subdivision. This home comes with many customizations. Some customized features include a wall feature in the primary bedroom, cabinets and tile flooring in the laundry room, a tiled wall in the half bath, and outside lighting to display the exterior of the home. Other features include beautiful wood and glass entry door, and wood-look floors flowing through the first level with the exception of the custom flooring in the laundry room, and half bath. Carpet areas are all bedrooms, media room, gameroom, and stairs. A computer niche with a curved wall between the kitchen and dining room. It can also be used as a wine bar. Covered patio with a spacious backyard to make your dreams come true. Minutes away from the Grand Parkway and I-10.' ,`Acres` = '0.1273' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 (PURE ACCT) (30 YR SPECIAL WAIVER)(JUR 356) (MAIN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5546' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Katy Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675258685' WHERE `Matrix_Unique_ID` = '213902742' --> Updated record success
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','215328973','1675258685','215328973','2023-01-26T01:22:35.307','92717792','Elizabeth Cencini','HOUSTON TOP REALTY','','','29.929724','-95.487699','48','77086','12','285000.00','Active','Trail Valley','6822','Way','Houston','3','0','5','2396','Single-Family','Completely renovated! Right across from Carimichael elementary school, this home features 2 living areas, two separate kitchen areas arranging the home space into two separate living spaces. Freshly painted walls, new laminate flooring, two fireplaces, three full size bathrooms all recently updated. The front kitchen has beautiful tile floors, stainless steel appliances and granite counters. The second kitchen is smaller but also has a stove, refrigerator, new kitchen cabinets and a laundry room. Lots of space in this home with extra large storage shed in the backyard and a two car garage.','0.1641','11','','','','','Sellers Disclosure','1','','2','Aldine Area','Central Electric','1','LT 12 BLK 11 NORTHWEST PARK SEC 1','Subdivision Lot','7150','Appraisal District','','380','0','','2','','0','','','','','Composition','1 - Aldine','CARMICHAEL ELEMENTARY SCHOOL','DAVIS HIGH SCHOOL (ALDINE)','SHOTWELL MIDDLE SCHOOL','Appointment Required,Lockbox Right Side','Appraisal District','1','Traditional','Northwest Park','5620','2.4283','Public Sewer,Public Water','1976','Appraisal District'); --> New record created successfully
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','216240731','1675258685','216240731','2023-01-26T01:22:35.307','57828887','Tanna Villarreal','Martha Turner Sotheby\'s International Realty','','','30.243870','-95.483566','20','77384','7','395000.00','Active','Jacobs Forest','1527','Drive','Conroe','2','0','4','2087','Single-Family','Welcome to Jacobs Reserve! The rolling streets and hidden entrance create a relaxing experience as you enter into the community. Once home, enjoy nature and all her beauty from your own back porch! This beautiful single story features hardwood and tile flooring throughout. No carpet! You will love the upgraded cabinetry, wood burning fireplace with custom mantle, oversized walk-in shower in the primary bathroom and much more! If you love custom finishes, you will love this home! Move-in ready with washer/dryer and refrigerator!','0.2163','15','','','Electric Dryer Connections','','Corporate Listing,Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Conroe Southwest','Central Electric,Central Gas','1','HOLLY TERRACE AT JACOBS RESERVE 04, BLOCK 01, LOT 15','Greenbelt,Subdivision Lot','9420','Appraisal District','','750','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop,Gas Cooktop','','Composition','11 - Conroe','GALATAS ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Back,Request Online Appointment,Supra Keybox','Appraisal District','1','Ranch,Traditional','Holly Terrace at Jacobs Reserve','8138','2.7488','Public Sewer,Public Water,Water District','2015','Appraisal District'); --> New record created successfully