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` = '2022-12-08T15:26:56.777' ,`MLSNumber` = '94808584' ,`ListAgentFullName` = 'Deana Fojt' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.765666' ,`Longitude` = '-95.040004' ,`PhotoCount` = '34' ,`PostalCode` = '77520' ,`RoomCount` = '7' ,`ListPrice` = '344800.00' ,`Status` = 'Active' ,`StreetName` = 'Rue Orleans' ,`StreetNumber` = '209' ,`StreetSuffix` = 'Street' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a rare find in popular Pointe Royale subdivision. Gorgeous water front property with view of San Jacinto Monument. This Slate, Concrete and Steel Beam home will last a lifetime. This home did get a small amount of water in the bottom floor during IKE but was grandfathered to redo the bottom floor. Awesome commercial grade bulkhead makes for a beautiful landscaped yard. The lot next door is available for sale when the home sells. Large covered carport with workshop/gameroom on bottom floor with bath. Upstairs is huge rooms with wonderful views. Two large bedrooms and balcony for sitting and enjoying morning coffee. Primary bedroom has luxury bath with jacuzzi tub, custom vanity and walk in shower. All buyers need to do is add their special touch to make this a showplace!' ,`Acres` = '0.3604' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 19 BLK 2 POINTE ROYALE SEC 1' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '15700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pointe Royale Sec 01' ,`TaxAmount` = '4867' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088790' WHERE `Matrix_Unique_ID` = '210082908' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T16:10:18.577' ,`MLSNumber` = '15833321' ,`ListAgentFullName` = 'Maria Navejas' ,`ListOfficeName` = 'Realty ONE Group, Experience' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.183090' ,`Longitude` = '-95.167881' ,`PhotoCount` = '20' ,`PostalCode` = '77357' ,`RoomCount` = '11' ,`ListPrice` = '485000.00' ,`Status` = 'Active' ,`StreetName` = 'Centurian Circle' ,`StreetNumber` = '2334' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2444' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction! Gorgeous 1 story stone & brick home on a huge lot featuring 4 bedrooms, 3.5 Bathrooms, 2 car garage plus a long driveway. You are welcomed with a beautiful knotty alder front French door! Living room boasts of a 14ft cathedral ceiling & an open layout with 10 ft ceilings & 8 ft doors throughout the home plus a fireplace. The kitchen is equipped with a walk in pantry, white quartz countertops, pot filler, stainless steel appliances, 30 inch gas range, under cabinet lighting & soft close drawer/cabinets. The spacious primary suite has a separate tub & shower with white quartz countertops. The primary closet has plenty of storage space and has a convenient walk through access to the Utility room. Fourth bedroom an en-suite with a private bathroom. Additional features includes secondary bedroom with a built in bookshelf & a covered back porch measuring 19x15. Located within a 30 min drive to The Woodlands & Minute Maid Park.' ,`Acres` = '0.6199' ,`Area` = '40' ,`BuilderName` = 'BT Grace Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 02, BLOCK 7, LOT 29' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '27005' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 02' ,`TaxAmount` = '1295' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088791' WHERE `Matrix_Unique_ID` = '214225066' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T15:22:37.963' ,`MLSNumber` = '98573866' ,`ListAgentFullName` = 'Tylitha French' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.522935' ,`Longitude` = '-94.442295' ,`PhotoCount` = '19' ,`PostalCode` = '77663' ,`RoomCount` = '6' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar Lane' ,`StreetNumber` = '101' ,`StreetSuffix` = '' ,`City` = 'Village Mills' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this beautifully remodeled home in Village Mills located 20 min North of Lumberton. Its 3 bedroom, 2 full bathrooms with a stunning kitchen, living room with brick fireplace and peaceful scenery. Enjoy country living in a private gated community with a lake, golf course, horse stables and many more community amenities.' ,`Acres` = '0.3091' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 2 WILDWOOD P# WW2-1-A I# 2018-86285 06/26/2018' ,`LotDesciption` = 'Cleared,Corner,In Golf Course Community,Subdivision Lot' ,`LotSize` = '13464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '192' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '1012 - Warren' ,`SchoolElementary` = 'WARREN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KOUNTZE HIGH SCHOOL' ,`SchoolMiddle` = 'KOUNTZE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wildwood' ,`TaxAmount` = '1905' ,`TaxRate` = '1.9244' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088791' WHERE `Matrix_Unique_ID` = '214902256' --> 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','215421271','1675088791','215421271','2022-12-08T15:53:44.810','23516951','Gay Kelly','UTR TEXAS, REALTORS','','','29.683617','-95.646136','25','77083','9','295970.00','Active','Earlswood','14715','Drive','Houston','2','0','4','2243','Single-Family','Notice the value in this 1 story, 4 bedroom home with a pool in the popular neighborhood of Providence! Completely remodeled kitchen in 2020-Cabinets including soft closing drawers, double oven, cooktop, countertops, vent hood, sink & more! Updated family room with gas log fireplace will compliment those cozy nights. Plantation shutters in kitchen, breakfast, and family room give a decorative touch to the rooms! Plenty of room to entertain with a formal dining room and additional living room. Large master will accommodate large furniture and 2 walk-in closets! Don\'t forget the enclosed POOL for pure enjoyment in the Texas summers! Nice outside patio and wood deck plus back yard green space if needed. Recently added: flow tech salt free water condition, water heater, dishwasher','0.177','37','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Mission Bend Area','Central Gas','1','PROVIDENCE SEC 1, BLOCK 3, LOT 16','Subdivision Lot','7711','Appraisal District','','350','0','','2','Double Oven,Electric Oven','1','Gunite','','Electric Cooktop','','Composition','19 - Fort Bend','FLEMING ELEMENTARY SCHOOL (FORT BEND)','KEMPNER HIGH SCHOOL','HODGES BEND MIDDLE SCHOOL','Appointment Required,Lockbox Right Side,Supra Keybox','Appraisal District','1','Traditional','Providence Sec 1','6157','2.3389','Water District','1982','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','215432650','1675088791','215432650','2022-12-08T15:27:04.187','5967092','Tod Franklin','DFWCityhomes','','','28.953959','-95.285327','12','77541','5','459000.00','Active','Bluewater','1741','Highway','Surfside Beach','2','0','2','1148','Single-Family','This brand new beach house sits right on Swan Lake. Beach views in the front and bay view in the back! This house is loaded with premium features such as a full wrap around porch, security cameras and tile floors throughout. Outdoor shower. Huge covered front porch! Spacious open living area with beautiful crown molding. The kitchen boasts custom cabinets with built-in stainless steel appliances, quartz countertops, tile backsplash and a large island with butcher block counter! Guest bath with tile shower/tub combo. The master suite features twin closets, double vanity and tile shower with glass enclosure. Relax on the beach or enjoy some of the best fishing on the Gulf Coast with a local public boat ramp less than a mile away.','0.6','5','South TX Constructor','','','','Sellers Disclosure','','','','Surfside','Central Electric','0','B C I C DIV 1 LOT 208C (A0009 B T ARCHER) (SURFSIDE) ACRES 0','Cleared,Water View,Waterfront','26136','Other','','','1','Never Lived In','','','0','','','','','Composition','7 - Brazosport','VELASCO ELEMENTARY SCHOOL','BRAZOSPORT HIGH SCHOOL','FREEPORT INTERMEDIATE SCHOOL','Appointment Required','Seller','1','Other Style','B C I C Div 1','1435','2.2043','Public Water,Septic Tank','2022','Seller'); --> 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','215457121','1675088791','215457121','2022-12-08T16:39:59.890','72096217','Julio Kiliddjian','RE/MAX Associates Northeast','','','29.770978','-95.119362','18','77530','5','350000.00','Active','De Zavalla','15917','Road','Channelview','1','0','5','1548','Single-Family','.99 Acres of fenced UNRESTRICTED land with a 3 bedroom that has been converted to a 5 bedroom. If you want to be in Channelview near the ship channel on UNRESTRICTED land with plenty of room to grow - THIS IS IT!\r\nPlenty of square footage on this cleared lot to do what you want. Home is 1548 SF and needs some improvements. detached garage. excellent location for the right person or family or families. Bring your RV and all your toys if you want.','0.99','2','','','Electric Dryer Connections,Washer Connections','','Mud,No Disclosures','0','','0','North Channel','Window Unit','0','LT 2 BLK 6 CHANNELVIEW ACRES','Cleared,Other','43124','Appraisal District','','','0','','2','','0','','','Electric Cooktop','','Composition','8 - Channelview','DEZAVALA ELEMENTARY SCHOOL (CHANNELVIEW)','CHANNELVIEW HIGH SCHOOL','JOHNSON JUNIOR HIGH','Appointment Required,No Supra Keybox','Appraisal District','1','Traditional','Channelview Acres','2074','2.3266','Public Sewer,Public Water','1940','Appraisal District'); --> New record created successfully