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-31T14:57:25.450' ,`MLSNumber` = '20627931' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.538964' ,`Longitude` = '-96.288516' ,`PhotoCount` = '10' ,`PostalCode` = '77845' ,`RoomCount` = '6' ,`ListPrice` = '589990.00' ,`Status` = 'Active' ,`StreetName` = 'Odell' ,`StreetNumber` = '4425' ,`StreetSuffix` = 'Lane' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Princeton Plan has it ALL! It is a 2,996 sqft 2-story home offering 4 bedrooms, 3 baths & OVERSIZED 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! The A-frame covered back patio is breathtaking! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 48 Section 210' ,`LotDesciption` = 'Corner' ,`LotSize` = '10155' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097982' WHERE `Matrix_Unique_ID` = '208598930' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:57:07.557' ,`MLSNumber` = '12481313' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.538964' ,`Longitude` = '-96.288516' ,`PhotoCount` = '10' ,`PostalCode` = '77845' ,`RoomCount` = '5' ,`ListPrice` = '549990.00' ,`Status` = 'Active' ,`StreetName` = 'Portland' ,`StreetNumber` = '2718' ,`StreetSuffix` = 'Avenue' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2482' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Tulane Floor Plan has it ALL! It is a 2,482 sqft 1-story home offering 3 bedrooms, 2.5 baths, STUDY & 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 6 Block 46 Section 208' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8855' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097982' WHERE `Matrix_Unique_ID` = '208600006' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:56:49.883' ,`MLSNumber` = '61561688' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.540358' ,`Longitude` = '-96.289121' ,`PhotoCount` = '7' ,`PostalCode` = '77845' ,`RoomCount` = '7' ,`ListPrice` = '569990.00' ,`Status` = 'Active' ,`StreetName` = 'Cainhorn' ,`StreetNumber` = '2702' ,`StreetSuffix` = 'Court' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2665' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Magnolia Floor Plan has it ALL! It is a 2,665 sqft 2-story home offering 5 bedrooms, 3 baths, Gameroom & 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 49 Section 210' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12363' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097983' WHERE `Matrix_Unique_ID` = '209170321' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T13:36:26.830' ,`MLSNumber` = '75521601' ,`ListAgentFullName` = 'Roberto Garza' ,`ListOfficeName` = 'Keller Williams HoustonCentral' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.610339' ,`Longitude` = '-95.247691' ,`PhotoCount` = '9' ,`PostalCode` = '77075' ,`RoomCount` = '3' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Misty Bridge' ,`StreetNumber` = '9431' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1456' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this wonderful 3 bed 2 bath home! This home has been well maintained and been freshly painted and ready for it’s new buyer! Walk inside where you will be flooded with lots of natural light, ceiling fans in the rooms keep you nice and cool from the scorching hot Texas summers. Located off of beltway 8 this allows you to get to major locations quickly. Close to good schools and grocery stores. Call today for a private showing!' ,`Acres` = '0.1515' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 30 BLK 1 SOUTHBRIDGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'ATKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southbridge Sec 01' ,`TaxAmount` = '4597' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097983' WHERE `Matrix_Unique_ID` = '209252876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:56:31.490' ,`MLSNumber` = '27927434' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.540764' ,`Longitude` = '-96.289550' ,`PhotoCount` = '26' ,`PostalCode` = '77845' ,`RoomCount` = '7' ,`ListPrice` = '569990.00' ,`Status` = 'Active' ,`StreetName` = 'Scatterby' ,`StreetNumber` = '2700' ,`StreetSuffix` = 'Cove' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2667' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Magnolia Floor Plan has it ALL! It is a 2,665 sqft 2-story home offering 3 bedrooms, 2.5 baths, Gameroom & 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 50 Section 210' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '14320' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097983' WHERE `Matrix_Unique_ID` = '209291640' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:56:16.220' ,`MLSNumber` = '5782967' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.540693' ,`Longitude` = '-96.292357' ,`PhotoCount` = '12' ,`PostalCode` = '77845' ,`RoomCount` = '8' ,`ListPrice` = '604990.00' ,`Status` = 'Active' ,`StreetName` = 'Wardford' ,`StreetNumber` = '2717' ,`StreetSuffix` = 'Way' ,`City` = 'College Station' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3277' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Victoria Plan has it ALL! It is a 3,277 sqft 2-story home offering 5 bedrooms, 4 baths & OVERSIZED 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! The A-frame covered back patio is breathtaking! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 42 Section 209' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8975' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097983' WHERE `Matrix_Unique_ID` = '209294650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:55:58.560' ,`MLSNumber` = '69246901' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.538893' ,`Longitude` = '-96.288039' ,`PhotoCount` = '18' ,`PostalCode` = '77845' ,`RoomCount` = '7' ,`ListPrice` = '589990.00' ,`Status` = 'Active' ,`StreetName` = 'Stronghold' ,`StreetNumber` = '2708' ,`StreetSuffix` = 'Cove' ,`City` = 'College Station' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2996' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Princeton Plan has it ALL! It is a 2,996 sqft 2-story home offering 4 bedrooms, 3 baths & OVERSIZED 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! The A-frame covered back patio is breathtaking! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 28 Block 48 Section 210' ,`LotDesciption` = 'Corner' ,`LotSize` = '9683' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097983' WHERE `Matrix_Unique_ID` = '209301304' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:55:32.103' ,`MLSNumber` = '47963836' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.540405' ,`Longitude` = '-96.289712' ,`PhotoCount` = '22' ,`PostalCode` = '77845' ,`RoomCount` = '6' ,`ListPrice` = '539990.00' ,`Status` = 'Active' ,`StreetName` = 'Scatterby' ,`StreetNumber` = '2713' ,`StreetSuffix` = 'Cove' ,`City` = 'College Station' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2431' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your new home awaits in the master-planned community of Castlegate II, located in the growing South College Station area. The stunning Tulane Floor Plan has it ALL! It is a 2,431 sqft 1-story home offering 3 bedrooms, 2 baths, STUDY & 2-car garage! The gorgeous kitchen features an oversized island, lots of cabinet space, soaring ceilings & overlooks the the family room. The primary bath has an oversized tub, walk-in shower with double sinks. The MASSIVE closet is a sight to see! Come out today and see this gorgeous home for yourself!' ,`Acres` = '' ,`Area` = '61' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2 Block 50 Section 210' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '9769' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'SPRING CREEK ELEMENTARY SCHOOL (College Station)' ,`SchoolHigh` = 'COLLEGE STATION HIGH SCHOOL' ,`SchoolMiddle` = 'WELLBORN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Castlegate II' ,`TaxAmount` = '' ,`TaxRate` = '2.26' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097984' WHERE `Matrix_Unique_ID` = '209310805' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T13:40:58.090' ,`MLSNumber` = '49208357' ,`ListAgentFullName` = 'Ignacio Avila' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.324665' ,`Longitude` = '-95.509166' ,`PhotoCount` = '27' ,`PostalCode` = '77304' ,`RoomCount` = '4' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Fork' ,`StreetNumber` = '4790' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3249' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home has everything!\r\nThe home is nestled in one of the best locations on the golf course.\r\nThe course views can start be seen the first moment you walk into the house.' ,`Acres` = '0.3639' ,`Area` = '19' ,`BuilderName` = 'Toch Properties, LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S949103 - WEST FORK 03, BLOCK 8, LOT 12, ACRES 0.3639' ,`LotDesciption` = 'On Golf Course' ,`LotSize` = '15851' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GIESINGER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'West Fork 03' ,`TaxAmount` = '1280' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097984' WHERE `Matrix_Unique_ID` = '210301010' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:27:57.973' ,`MLSNumber` = '40221222' ,`ListAgentFullName` = 'Claudia Hellmund' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747455' ,`Longitude` = '-95.519626' ,`PhotoCount` = '50' ,`PostalCode` = '77024' ,`RoomCount` = '14' ,`ListPrice` = '2995000.00' ,`Status` = 'Active' ,`StreetName` = 'MOTT' ,`StreetNumber` = '39' ,`StreetSuffix` = 'Lane' ,`City` = 'Piney Point Village' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6234' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Every once in a while you come across a very special home that makes your heart skip a beat...Opportunity awaits at one of the most private coveted streets at 39 Mott Lane, located in highly sought after Piney Point. This unique property offers expansive clean lines with a sophisticated contemporary sleek design that features modern geometry with the warmth of a sleek elegant architecture. Sits on an acre and a quarter elevated lot with a crisp mid century feel throughout. With it\'s stunning architecture and breathtaking views through the floor to ceiling glass windows and doors to the extensive lush grounds, reflective pool and bayou, this property stands out from the rest. Presents a front motor court, impressive gallery entry, formal living and dining with seamless fluidity to the outdoors. Gourmet kitchen open to breakfast area & family room catered for today\'s lifestyle. At second level offers 4 ensuite bedrooms plus luxurious primary retreat with grand bath, game room & laundry.' ,`Acres` = '1.2659' ,`Area` = '23' ,`BuilderName` = 'Woodmark Constructio' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Memorial Villages' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 EVERGREEN POINT' ,`LotDesciption` = 'Ravine,Water View,Wooded' ,`LotSize` = '55143' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'MEMORIAL DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Piney Point' ,`TaxAmount` = '45615' ,`TaxRate` = '2.1721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097984' WHERE `Matrix_Unique_ID` = '210483994' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:13:47.923' ,`MLSNumber` = '47914201' ,`ListAgentFullName` = 'Morad Fiki' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.750095' ,`Longitude` = '-95.494299' ,`PhotoCount` = '50' ,`PostalCode` = '77057' ,`RoomCount` = '16' ,`ListPrice` = '899900.00' ,`Status` = 'Active' ,`StreetName` = 'San Felipe' ,`StreetNumber` = '6240' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '4266' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury awaits you at this stunning home located in highly desirable Briargrove! The timeless look of the brick facade, landscaping, and circular driveway all contributes to its magnificent curb appeal. The solid wood double-door entry immediately opens to the grand foyer chandelier, elegant staircase with wrought iron detail, and living room with 22\' ceilings and walls of glass overlooking the backyard. Privately situated on the 1st floor, you\'ll find the spacious primary bedroom & ensuite bathroom, walk-in closet, standing shower & separate spa bathtub. Your inner chef will be inspired in the updated kitchen, offering a separate island w/ gas range, Monogram SS appliances, butler\'s pantry & breakfast nook. Upstairs you will find 5 additional rooms. As you tour the home, you\'ll notice that no detail was missed in this meticulously upgraded interior. Don\'t miss this opportunity to live in this top community centrally located to all major freeways, shopping, and top-rated schools!' ,`Acres` = '0.2331' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Briargrove' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 370 BLK 18 BRIARGROVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10153' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1210' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briargrove' ,`TaxAmount` = '24472' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097984' WHERE `Matrix_Unique_ID` = '212121726' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:59:46.377' ,`MLSNumber` = '14412299' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507853' ,`Longitude` = '-95.004216' ,`PhotoCount` = '17' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '432990.00' ,`Status` = 'Active' ,`StreetName` = 'Sellers Island' ,`StreetNumber` = '2809' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coastal living at its finest at Coastal Point community. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. Stunning NEW construction Laurel floor plan is a 1-Story, 3 beds, Study, Formal Dining, 2 baths & 2-car garage! The kitchen is open & bright offering gloss white kitchen backsplash, linen cabinets, coastal white granite countertops & wood flooring. Fully Sodded Yard with Sprinkler System! Home will be ready for a December move-in!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097985' WHERE `Matrix_Unique_ID` = '212246032' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:59:08.110' ,`MLSNumber` = '16998666' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507853' ,`Longitude` = '-95.004216' ,`PhotoCount` = '17' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '432990.00' ,`Status` = 'Active' ,`StreetName` = 'Sellers Island' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2033' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coastal living at its finest at Coastal Point community. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. Stunning NEW construction Laurel floor plan is a 1-Story, 3 beds, Study, Formal Dining, 2 baths & 2-car garage! The kitchen is open & bright offering santorini kitchen backsplash, slate gray cabinets, aura granite countertops & graphite wood flooring. Fully Sodded Yard with Sprinkler System! Home will be ready for a December move-in!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 17 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097985' WHERE `Matrix_Unique_ID` = '212247814' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:58:44.510' ,`MLSNumber` = '34724505' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507853' ,`Longitude` = '-95.004216' ,`PhotoCount` = '14' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '434990.00' ,`Status` = 'Active' ,`StreetName` = 'Finns Landing' ,`StreetNumber` = '4922' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1891' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coastal living at its finest at Coastal Point community. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. Stunning NEW construction Mahogany floor plan is a 1-Story, 3 beds, 2 baths & 2-car garage! The kitchen is open & bright offering beige kitchen backsplash, slate gray cabinets, brown itabaria granite countertops & graphite wood flooring. Fully Sodded Yard with Sprinkler System! Home will be ready for a December move-in!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 47 Block 3 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6083' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097985' WHERE `Matrix_Unique_ID` = '212473879' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T14:58:15.773' ,`MLSNumber` = '25324494' ,`ListAgentFullName` = 'April Maki' ,`ListOfficeName` = 'Gehan Homes Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507853' ,`Longitude` = '-95.004216' ,`PhotoCount` = '15' ,`PostalCode` = '77573' ,`RoomCount` = '7' ,`ListPrice` = '454990.00' ,`Status` = 'Active' ,`StreetName` = 'Finns Landing' ,`StreetNumber` = '4924' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2190' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy coastal living at its finest at Coastal Point community featuring new homes in League City, TX. This master-planned oasis offers a staycation lifestyle with walking trails and parks, a picturesque pond, and a resort-style pool. This home is our award winning Juniper Floor Plan featuring 1-story, 3 beds with flex space, 3 baths, STUDY with 2-car garage! Iron wood flooring in all main areas, spacious kitchen with linen cabinets & coastal white granite countertops, 8\' interior doors & covered patio! Fully sodded yard with sprinkler system. This home will be ready for a January 2023 move-in!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 46 Block 3 Section 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6102' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097985' WHERE `Matrix_Unique_ID` = '212474940' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T13:08:21.047' ,`MLSNumber` = '51789793' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.835660' ,`Longitude` = '-95.852970' ,`PhotoCount` = '26' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '351990.00' ,`Status` = 'Active' ,`StreetName` = 'Aurora Creek' ,`StreetNumber` = '434' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2102' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'SUNTERRA IS NOW OPEN!! KATY ISD- Colina Homes believes in building your dream 2-Story w/ 4Bedrooms (2 bed down & 2 bed up) + 3 Full Baths + LOFT at a price you CAN afford! Come see this open-concept home.This beautiful Kitchen features Maple Slate 42” Cabinets + Fantasy Brown Granite + Biscuit Matte Tile Backsplash on Subway Pattern + Stainless \"Farmhouse\" Single-Bowl Sink +Stainless Frigidaire Dishwasher, Vented Microwave & 5-BURNER GAS RANGE! Wood-like Flooring at Entry, Kitchen, Dining, Family Rm, Hallways, Utility & ALL Baths. Spacious Master Suite that boasts a walk-in Closet, 42\"-High Cabinets with Double Sinks, & 5’Spacious Separate Shower, 4 Sides Acme Brick, 2” Faux Wood Blinds,16 SEER Lennox Air System, Covered Back Patio much more! This Energy Efficient home will SAVE you $$$! CALL & MAKE YOUR APPOINTMENT TO VISIT TODAY. Come visit the model home located at 105 Eliana Shores.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 3 Sec 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6465' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.5' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675097986' WHERE `Matrix_Unique_ID` = '213798778' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T13:24:28.860' ,`MLSNumber` = '73246085' ,`ListAgentFullName` = 'Nolan Nix' ,`ListOfficeName` = 'Home Run Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045597' ,`Longitude` = '-95.223365' ,`PhotoCount` = '24' ,`PostalCode` = '77339' ,`RoomCount` = '9' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory Creek' ,`StreetNumber` = '2019' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2973' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Opportunity to Own an Upfront Trailwood Village Custom Home. No lights to 59! Completely Remodeled Kitchen Cabinets, Granite Counters w/ Tumbled Marble Backsplash, Double Stainless Ovens, and Pot Filler. Dining Room, Formal Living Room/Study, Family Room and Game Room ALL Downstairs! Master Bedroom Down with Updated Double Sink Vanity w/ Granite Counters. Roof with Radiant Barrier. Upstairs Bathroom has Granite Countertops. Park Like Setting Backyard w/ Extensive Decking Mature Trees. Short Walking Distance to Park, Pool, School, Baseball/Soccer Fields and River Grove Park. Never Flooded. A MUST SEE!!!' ,`Acres` = '0.2452' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 16 TRAILWOOD VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '410' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'FOSTER ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Trailwood Village' ,`TaxAmount` = '6336' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097986' WHERE `Matrix_Unique_ID` = '214564746' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T13:04:28.397' ,`MLSNumber` = '35217546' ,`ListAgentFullName` = 'Long Nguyen' ,`ListOfficeName` = '5th Stream Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.568935' ,`Longitude` = '-95.019985' ,`PhotoCount` = '28' ,`PostalCode` = '77586' ,`RoomCount` = '4' ,`ListPrice` = '255000.00' ,`Status` = 'Active' ,`StreetName` = 'Capri' ,`StreetNumber` = '1729' ,`StreetSuffix` = 'Lane' ,`City` = 'Seabrook' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A beautiful recently full remodeling House that\'s located minutes away from \"Kemah Boardwalk\". It can be a great starting home or a great long term or short term (Airbnb) rental investment property.\r\nBelow are all newly replacements:\r\n- All interior new paint\r\n- Two bathrooms full remodeled: walls up with 12x24 tile and Granite vanity countertops\r\n- New paint kitchen cabinets and Granite kitchen countertop\r\n- New 5mm Luxury Vinyl Plank wood look \"click & lock\" in all Common area and bedroom floors \r\n- New AC' ,`Acres` = '0.1515' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 16 BLK 3 MIRAMAR SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '52' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'BAY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'SEABROOK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Miramar Sec 03' ,`TaxAmount` = '4016' ,`TaxRate` = '2.2905' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097986' WHERE `Matrix_Unique_ID` = '214654977' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-31T13:56:39.117' ,`MLSNumber` = '30073403' ,`ListAgentFullName` = 'Randy Polasek' ,`ListOfficeName` = 'Impression Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.294959' ,`Longitude` = '-94.910083' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '10' ,`ListPrice` = '1975000.00' ,`Status` = 'Active' ,`StreetName` = 'Quayside' ,`StreetNumber` = '124' ,`StreetSuffix` = 'Drive' ,`City` = 'Tiki Island' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME BAYFRONT DBL LOT W/UNOBSTRUCTED VIEWS OF GALVESTON\'S WEST BAY, THE INTRACOASTAL CANAL, GLV ISLAND BRIDGE & MOODY GARDENS! SOUTHEAST FACING HOME/COOL OCEAN SUMMER BREEZES & BEAUTIFUL SUNRISES*COMPLETE REMODEL*2 BAY LOTS*2 FULL KITCHENS*2 LAUNDRY RMS*2 BUNKRMS*INTERIOR & 2 EXTERIOR STAIRCASES*2 OVERSIZED GAR BAYS*3 FIREPLS*5 BALCONIES & AN ELEVATOR*SOARING 21\'CEILINGS SHOWCASE FANTASTIC VIEWS FR EVERY RM*BOASTING DBL STACKED WALL TO WALL/FLR TO CEILING WINDOWS*OPEN KIT/LIVING+SEP WETBAR*LUXURIOUS PRIMARY SUITE OFFERS LARGE PICTURE WINDOWS,PRIVATE BAYVIEW BALCONY & MOSAIC GLASS TILE FP*SPA-LIKE PRIMARY BATH,QUARTZ CNTRS,DBL VANITY+MAKEUP STATION,FREESTANDING SOAKING TUB W/BAY VIEWS,LED FP & OVERSIZED SEEMLESS GLASS SHOWER*BAYSIDE BKYD PARADISE,TROPICAL POOL,TIKI HUT,PALMS,FLOWERING BUSHES & FRUIT TREES*PERFECT FOR ENTERTAINING*DBL LOT/OVER 120’WTRFRONT,50’FISHING PIER DECKING,COMM GRADE GREEN LED LIGHTS & BOAT LIFT*AMAZING FISHING RIGHT OFF THE DOCK*METICULOUSLY MAINTAINED IN & OUT!' ,`Acres` = '0.234' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = 'Tiki Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 7 S BUNDICK SUR LOT 113 REPLAT (114-0) TIKI ISLAND SEC' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '10193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '52 - Texas City' ,`SchoolElementary` = 'HAYLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA MARQUE HIGH SCHOOL (TEXAS CITY)' ,`SchoolMiddle` = 'LA MARQUE MIDDLE SCHOOL (TEXAS CITY)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Tiki Island 12' ,`TaxAmount` = '30441' ,`TaxRate` = '2.4912' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675097986' WHERE `Matrix_Unique_ID` = '215045262' --> 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','215490832','1675097986','215490832','2022-12-31T14:57:47.447','60387201','Christopher Webb','Pinnacle Realty Advisors','','','29.151888','-95.025707','29','77554','10','998000.00','Active','Bluewing Teal ct','4127','Court','Galveston','3','1','4','2418','Single-Family','This stunning 4 bedroom, 3.5 bathroom house is located on a beautiful canal with breathtaking views of the beach and bay. The property features a boat house, providing easy access to the water for all your boating needs. The house is just a short golf cart ride away from the beach, making it easy to enjoy the sandy shores.\r\n\r\nThe house is located in a gated neighborhood that offers a range of fantastic amenities, including a pool, tennis court, and boat ramp. The community also boasts nature trails and great fishing spots, providing plenty of opportunities to enjoy the great outdoors. \r\n\r\nAt an affordable price, this property offers the perfect combination of luxury and convenience. Don\'t miss out on the opportunity to make this stunning house your new home. Seller financing available. 5% down, 5% interest for 5 years.','0.2403','33','Bay Point Builders,','','','','Mud','1','','','West End','Central Electric','1','SUNSET COVE (2005), ABST 121, BLOCK F, LOT 13, ACRES 0.240','Corner,Water View,Waterfront','10469','Appraisal District','','2250','1','Never Lived In','1','','0','','','','','Composition','22 - Galveston','GISD OPEN ENROLL','BALL HIGH SCHOOL','GISD OPEN ENROLL','Supra Keybox,Vacant/Unoccupied','Builder','2','Other Style','Sunset Cove 2005','27337','2.1675','Public Sewer,Public Water','2021','Builder'); --> 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','215690806','1675097987','215690806','2022-12-31T13:17:27.810','11026765','Trenda Carlisle','Fathom Realty','','','30.428287','-95.578938','21','77318','6','324900.00','Active','Virgo','12775','Drive','Willis','2','0','3','1845','Single-Family','A Must See! Lovely Stone and Stucco 3 Bedroom 2 Bath Home with additional approx. 160 feet long driveway and custom built back porch covered patio/bar in Lakefront Community with many amenities including Marina, Boat Ramps and Swimming Pools, Community Center and more *Galley Kitchen with oversized Granite Bar & Stainless Appliance Package makes cooking here fun *Spacious Living Room w additional seating area *Grand Foyer *Nice Breakfast Room & More *Primary Suite offers soaking tub w separate shower, oversized vanity *spacious closet *2 additional Bedrooms & Guest Bathroom *Utility closet off kitchen *2 car attached garage *Large lot enjoys mature majestic trees and privacy fenced backyard *RV, Boat, etc. parking in additional driveway *Solar Screens *Minutes to Lake Conroe *Nearby shopping *Willis ISD *Easy commute to I45 *Nearby Medical Facilities *Easily commute to several Colleges *Hurry','0.2066','39','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Lake Conroe Area','Central Electric','1','POINT AQUARIUS 06, BLOCK 5, LOT 28','Cleared,Subdivision Lot','9000','Appraisal District','','1020','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','56 - Willis','W. LLOYD MEADOR ELEMENTARY SCHOOL','WILLIS HIGH SCHOOL','ROBERT P. BRABHAM MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','1','Traditional','Point Aquarius','5166','2.3849','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully