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-09T22:49:06.127' ,`MLSNumber` = '24963620' ,`ListAgentFullName` = 'Dalila Pulido' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.729403' ,`Longitude` = '-94.954702' ,`PhotoCount` = '13' ,`PostalCode` = '77520' ,`RoomCount` = '2' ,`ListPrice` = '165000.00' ,`Status` = 'Active' ,`StreetName` = 'Shepherd' ,`StreetNumber` = '1117' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '994' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home located on a beautiful lot and quiet subdivision. \r\nHome is located near Roseland Park which offers a boat ramp, splash pad, picnic tables and a fishing pier.\r\nStepping into this stunning home you will fall in love with the gorgeous flooring, you will enjoy the extra room that can be used as a formal dining room, TV room or game room.\r\nThis home has been renovated and updated from floors to lights and everything in between. New carpet, new sinks, remodeled kitchen, fresh paint inside and outside, way too much to mention.\r\nSchedule your appointment today!!!' ,`Acres` = '0.2571' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 6 DANUBINA COURT SEC 2A' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'LORENZO DE ZAVALA ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Danubina Court Sec 02a' ,`TaxAmount` = '3026' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106979' WHERE `Matrix_Unique_ID` = '214574832'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T22:32:54.617' ,`MLSNumber` = '73740565' ,`ListAgentFullName` = 'Joel Rankin' ,`ListOfficeName` = 'J.D. Rankin and Associates    ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.529722' ,`Longitude` = '-95.023282' ,`PhotoCount` = '22' ,`PostalCode` = '77565' ,`RoomCount` = '6' ,`ListPrice` = '239900.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Ridge' ,`StreetNumber` = '1835' ,`StreetSuffix` = 'Drive' ,`City` = 'Kemah' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one-story home on a Cul-de-sac lot. Features include 3 bedrooms 2 full baths and 2 car attached garage.  Shows beautifully with decorator touches throughout.   The primary bedroom features an ensuite with double sinks, a garden tub, and separate shower.   Zoned to CCISD Education Village. The neighborhood offers a community pool and recreation park. Easy access to shopping, restaurants and Galveston Bay. Call for details, today.' ,`Acres` = '0.122' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 13 BLK 3 KEMAH OAKS SUB' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5313' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '440' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'STEWART ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kemah Oaks Sub 92' ,`TaxAmount` = '5022' ,`TaxRate` = '2.0134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106979' WHERE `Matrix_Unique_ID` = '214675382'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T22:00:25.890' ,`MLSNumber` = '67558429' ,`ListAgentFullName` = 'Aaron Cruz' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.368224' ,`Longitude` = '-95.081533' ,`PhotoCount` = '9' ,`PostalCode` = '77510' ,`RoomCount` = '0' ,`ListPrice` = '99000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 646' ,`StreetNumber` = '5201' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment property for a rental or commercial business. Corner lot on Main st and two blocks from Highway 6 in Santa Fe. Fifteen minutes to Galveston and 30 minutes to Houston.' ,`Acres` = '0.357' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 149 E MITCHELL SUR LOTS 1,2 & 3 (1-2) BLK 26 ALTA LOMA' ,`LotDesciption` = 'Corner' ,`LotSize` = '15551' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'WILLIAM F BARNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Alta Loma Townsite' ,`TaxAmount` = '4121' ,`TaxRate` = '2.5619' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106979' WHERE `Matrix_Unique_ID` = '214900385'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-09T22:31:03.063' ,`MLSNumber` = '79655689' ,`ListAgentFullName` = 'Joel Rankin' ,`ListOfficeName` = 'J.D. Rankin and Associates    ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583519' ,`Longitude` = '-95.008873' ,`PhotoCount` = '32' ,`PostalCode` = '77586' ,`RoomCount` = '6' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Allegro' ,`StreetNumber` = '4521' ,`StreetSuffix` = 'Drive' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2241' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 3 bedroom 2.5 bath home located in the Baybrook subdivision of Seabrook. Wonderful cul-de-sac lot with easy access to area nature trails. Features include formal dining, study, and primary bedroom on 1st floor and 2 bedrooms, full bath and study nook on 2nd floor.  Stainless steel appliances with granite countertops in kitchen that opens to living room with fireplace.' ,`Acres` = '0.1854' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 39 BLK 2 BAYBROOK SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8075' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Baybrook' ,`TaxAmount` = '5558' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675106980' WHERE `Matrix_Unique_ID` = '214921941'  --> 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','215277754','1675106980','215277754','2023-01-09T22:49:10.540','71356631','Jovany Trujillo','RE/MAX RESULTS','','','30.171260','-95.167031','47','77357','12','379000.00','Active','Athens','2215','Drive','New Caney','2','1','4','2484','Single-Family','Looking to get out of the city but still be close to Houston? This amazing 4 bedroom home will provide room for everyone to enjoy, with just short of half acre of land. Brand new flooring throughout the home and fresh paint will make your feel right at home. Don\'t miss out on this amazing home, it wont be here tomorrow!! Hurry Hurry','0.4744','40','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Wood Burning Fireplace','1','Porter/New Caney East','Central Electric','0','S839701 - ROMAN FOREST 01, BLOCK 5, LOT 21','Cleared,Subdivision Lot','20666','Survey','','','0','','2','','0','','','Electric Range','','Composition','39 - New Caney','DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)','NEW CANEY HIGH SCHOOL','KEEFER CROSSING MIDDLE SCHOOL','Appointment Required,Lockbox Front,Vacant/Unoccupied','Appraisal District','2','Traditional','Roman Forest 01','5808','2.9064','Public Sewer,Public Water','1972','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','215872765','1675106980','215872765','2023-01-09T21:03:44.937','74102992','Jimmy Franklin','Pulte Homes','','','29.398949','-95.238881','6','77511','6','269250.00','Active','Appaloosa','332','Drive','Alvin','3','0','4','1702','Single-Family','April 2023 completion! Morgan\'s plan by Centex was built on an oversized lot with no rear neighbors. Upgrades include upgraded brick and stone front elevation as well as blinds, stainless stove, microwave, and dishwasher. The primary bathroom will have a garden soaker tub and a separate glass shower. The quaint town of Alvin provides residents a retreat from city life while maintaining great accessibility to Downtown Houston and the Texas Medical Center. The new community of Mustang Ridge offers affordable new home construction on expansive homesites by a home builder with over 60 years of experience.','','5','Centex','','','','Mud','','','','Alvin South','Central Gas','1','Lot 11, Block 52, Section 1','Subdivision Lot','','','','350','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','WALT DISNEY ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','ALVIN JUNIOR HIGH SCHOOL','Appointment Required','Builder','1','Traditional','Mustang Ridge','','3.591','Public Sewer,Public Water,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','216183265','1675106980','216183265','2023-01-09T22:54:43.607','27896448','Steven Johnson','eXp Realty, LLC','','','30.010717','-95.494600','50','77068','10','329000.00','Active','Crystal Brook','15818','Drive','Houston','3','1','4','3174','Single-Family','THIS HOME HAS HAD SEVERAL IMPORTANT AREAS COMPLETELY REMODELED, THE ENTIRE UP STAIRS SECONDARY BATH AND NEW FLOORING ADDED STORAGE ALL 3 BEDROOMS LARGE AND ONE WITH ENTRANCE TO BALCONY STAIRS REDONE, THE MASTER BEDROOM AND MASTER BATH REMODELED, THE UTILITY ROOM AND POWDER ROOM REDONE, THEN THE SUNROOM/GAMEROOM/MANCAVE AWSOME AND REMODELED. THE KITCHEN HAS LOTS OF CABINETS AND COUNTERTOPS ORIGINAL WITH A BAR AND SINK IN THE FAMILY AREA, THE DETATCHED GARAGE HAS VERY LONG DRIVEWAY FOR PARKING, THERE\'S LOTS OF OUTSIDE PATIO AREAS. BEHIND THE GARAGE IS A POOL THAT HAS NOT BEEN FUNCTIONAL FOR MANY YEARS AND COULD BE COMPLETELY REDONE FOR LESS THAN YOU COULD DO FROM SCRATCH OR IT CAN BE BURIED. THE ROOF IS FUNCTIONING BUT OLD.','0.281','13','','','','','Sellers Disclosure','','','1','1960/Cypress Creek North','Central Gas','1','LT 36 BLK 26 OLDE OAKS SEC 1','Cul-De-Sac,Subdivision Lot','12240','Appraisal District','','633','0','','1','Gas Oven','0','','','Gas Range','','Composition','48 - Spring','PAT REYNOLDS ELEMENTARY SCHOOL','WESTFIELD HIGH SCHOOL','EDWIN M WELLS MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal','2','Traditional','Olde Oaks Sec 01','5487','2.3342','Public Sewer,Public Water','1978','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','216212982','1675106980','216212982','2023-01-09T22:28:36.910','14261310','Joel Rankin','J.D. Rankin and Associates    ','','','29.460715','-95.041317','18','77539','5','129900.00','Active','44th','4606','Street','Dickinson','1','0','2','884','Single-Family','Charming 2-bedroom 1 bath home located in the heart of Dickinson. Great access to Galveston, NASA and the Kemah Entertainment District. Features include large kitchen/breakfast area, 1 car garage, private living room and wonderful 10,039 sq .ft. lot. Call for details, today!','0.2305','33','','','Electric Dryer Connections,Washer Connections','','Real Estate Owned','','','','Dickinson','Central Gas','0','ABST 78 R HALL SUR LOT 4 EAST PARK ADDN','Subdivision Lot','10039','Appraisal District','','','0','','1','','0','','','','','Composition','17 - Dickinson','HUGHES ROAD ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','JOHN AND SHAMARION BARBER MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','East Park','2235','2.4615','Public Sewer,Public Water','1972','Appraisal District');  --> New record created successfully<br />