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-08-01T12:48:00.900' ,`MLSNumber` = '65154854' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.952354' ,`Longitude` = '-96.247489' ,`PhotoCount` = '31' ,`PostalCode` = '77418' ,`RoomCount` = '2' ,`ListPrice` = '549999.00' ,`Status` = 'Active' ,`StreetName` = 'Mechanic' ,`StreetNumber` = '413 & 437' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1735' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the last remaining areas in Bellville that is waiting to be developed! This 2 acre property has access from 3 streets, ideal for someone to develop into lots for homes. Currently on the property, 2 homes, one of which was built in 1895, per records that the owner has found, and a barn dating to the same time. The second home occupied by owner is a 2 bed, 1 bath complete with an air conditioned workroom perfect for crafting or a home office. Also included is a metal barn and plenty of mature trees for enjoying the outdoors.' ,`Acres` = '2.028' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A073 J NICHOLS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '88339' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '2116' ,`TaxRate` = '2.1068' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '202107586' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:00:39.350' ,`MLSNumber` = '35606662' ,`ListAgentFullName` = 'Thomas Sharpe' ,`ListOfficeName` = 'Texas Shoreline Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.638421' ,`Longitude` = '-96.456226' ,`PhotoCount` = '16' ,`PostalCode` = '77979' ,`RoomCount` = '5' ,`ListPrice` = '104900.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 172' ,`StreetNumber` = '27338' ,`StreetSuffix` = 'Highway' ,`City` = 'Port Lavaca' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1260' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fisherman\'s dream. Excellent fishing and duck hunting for the avid outdoorsman. Be on Keller Bay in just minutes. Two boat ramps and a nice play ground at Olivia Hatteras park are a short walk from the home. A short 20 minute drive to Lake Texana for fresh water fishing, so you get the best of both worlds. New Hardi siding was installed in 2017 and the roof is approximately 9 years old. In 2017 Home was repiped with PVC pipe and also all new plumbing fixtures, toilets, sinks, waterheater and showers.' ,`Acres` = '0.1377' ,`Area` = '65' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'OLIVIA TOWNSITE, BLOCK 59, LOT PT OF 2' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5998' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '169 - Calhoun County' ,`SchoolElementary` = 'HARRISON/JEFFERSON/MADISON eLEMENTARY SCHOOL' ,`SchoolHigh` = 'CALHOUN HIGH SCHOOL' ,`SchoolMiddle` = 'TRAVIS MIDDLE SCHOOL (CALHOUN COUNTY)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Back,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Olivia Townsite' ,`TaxAmount` = '833' ,`TaxRate` = '1.7153' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '202749137' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:47:46.050' ,`MLSNumber` = '94086597' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.951817' ,`Longitude` = '-96.247935' ,`PhotoCount` = '31' ,`PostalCode` = '77418' ,`RoomCount` = '2' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Mechanic' ,`StreetNumber` = '413' ,`StreetSuffix` = 'Street' ,`City` = 'Bellville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1735' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One of the last remaining areas in Bellville that is waiting to be developed! This home is a 2 bed, 1 bath complete with an air conditioned workroom perfect for crafting or a home office. Also included is a metal barn and plenty of mature trees for enjoying the outdoors. Want more space? Adjacent to this homes is an additional 1.5 acres available for sale.' ,`Acres` = '0.512' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST A073 J NICHOLS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22302' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '136 - Bellville' ,`SchoolElementary` = 'WEST END ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'BELLVILLE JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1932' ,`TaxRate` = '2.1116' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '203544078' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:47:04.227' ,`MLSNumber` = '76926878' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.699550' ,`Longitude` = '-95.966854' ,`PhotoCount` = '25' ,`PostalCode` = '77457' ,`RoomCount` = '3' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 251' ,`StreetNumber` = '1509' ,`StreetSuffix` = '' ,`City` = 'Matagorda' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location, are you looking for nearby beach property, here it is! Well maintained and recently updated home in Matagorda is ready for you! Offering 3 bedrooms, 3 bathrooms, this home has plenty of space for entertaining with an open-concept kitchen, dining, and living room. Recent upgrades include A/C, both water heaters replaced in 2020, and new paint/updates in the kitchen, living and dining room in 2021. As you step outside, you\'ll find a completely fenced yard for your four-legged family members along with a full one acre to expand if you need. Did we mention the best part? A 40 x 30 metal building to house your boat, lawnmower, or other valuables. Along with both an attached and detached carport, this property has it all! Come take a look for yourself, this one won\'t last long!' ,`Acres` = '1.072' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WIGHTMAN MATAGORDA OUTLOTS AB 101 PT OUTLOT 12 1.072 AC (TR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '46696' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '170 - Matagorda' ,`SchoolElementary` = 'MATAGORDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'MATAGORDA ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Matagorda Townsite' ,`TaxAmount` = '4482' ,`TaxRate` = '1.7637' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '204865891' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:41:24.047' ,`MLSNumber` = '52290863' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480075' ,`Longitude` = '-95.455609' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '378130.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemead' ,`StreetNumber` = '1214' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Brick and Stone front accent with accent shutters. Upgraded front door and blinds included. Crisp Interior Package with Ceramic Tile flooring throughout in many areas downstairs. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0368 Plan 880B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '207627607' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:46:43.797' ,`MLSNumber` = '42162957' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.480051' ,`Longitude` = '-95.455519' ,`PhotoCount` = '8' ,`PostalCode` = '77583' ,`RoomCount` = '6' ,`ListPrice` = '380866.00' ,`Status` = 'Active' ,`StreetName` = 'Rosemead' ,`StreetNumber` = '1226' ,`StreetSuffix` = 'Drive' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready October 2022! Brick and Stone front accent with accent shutters. Upgraded front door and blinds included. Fresh Interior Package with wood look ceramic tile flooring throughout in many areas downstairs. Many included features with each Meritage Home at Glendale Lakes include rear covered patio, brick front accent, M Connected features, Spray Foam insulation, tankless water heater, grand kitchen island, sodded back yard, front gutters and many other included features. Located in the acclaimed Fort Bend ISD, Glendale Lakes is nestled in Rosharon with great access to nearby dining, entertainment and retail with major employment centers such as the Houston Medical Center, Galleria and Hobby Airport all just a short drive away. With an onsite elementary school, you\'ll relax knowing the kids don\'t have to travel far. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars.' ,`Acres` = '' ,`Area` = '38' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0365 Plan 880B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '550' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Glendale Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '207894637' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:53:51.687' ,`MLSNumber` = '67996624' ,`ListAgentFullName` = 'Dale Ross' ,`ListOfficeName` = 'Keller Williams Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981285' ,`Longitude` = '-95.686599' ,`PhotoCount` = '39' ,`PostalCode` = '77429' ,`RoomCount` = '11' ,`ListPrice` = '1200000.00' ,`Status` = 'Active' ,`StreetName` = 'Dry Creek' ,`StreetNumber` = '14505' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '4' ,`SqFtTotal` = '3938' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 14505 Dry Creek Dr. Buckle up & get ready for take-off, this extraordinary property will have you flying high! Located in the aviation-centered private community of Skinner Road Airport, this hidden gem is a pilots dream! Sitting on over an acre of land w/ a private drive leading to your dazzling 2 story home, oversized hangar w/ an office & ½ bath, airplane pad & direct runway access! You’ll appreciate the curb appeal of this fine property - plush green Bermuda grass, stunning stone exterior & a charming covered patio for both the upper & lower level. Open your front doors to an elegant two story entryway w/ high ceilings, crown molding, 18” Italian tile floors & a layout that’s designed for entertaining! Including a private study, an elegant dining room, 2 lower level large primary bedrooms w/ an en-suite, an oversized upstairs game room & secondary bedrooms w/ balcony access! Make a move in the flight direction & soar on over to this magnificent property while you can!' ,`Acres` = '1.2' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 67B-2A & 67A-1B1 ABST 710 T J STANSBURY' ,`LotDesciption` = 'Airpark,Subdivision Lot' ,`LotSize` = '52272' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'A ROBISON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'GOODSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'STANSBURY THOS J' ,`TaxAmount` = '9775' ,`TaxRate` = '2.091' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693261' WHERE `Matrix_Unique_ID` = '208767625' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:57:29.430' ,`MLSNumber` = '93907610' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.583768' ,`Longitude` = '-95.745135' ,`PhotoCount` = '9' ,`PostalCode` = '77406' ,`RoomCount` = '5' ,`ListPrice` = '382145.00' ,`Status` = 'Active' ,`StreetName` = 'Muscadine Hollow' ,`StreetNumber` = '1146' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready December 2022! A private flex space in the Oleander makes a perfect home office or play room. Clear sight lines from the kitchen through the family room bring everyone together, while twin secondary bedrooms are tucked away in their own hall. Make long commutes a thing of the past thanks to major road improvements on US-90 and FM 359. The kids will love attending school in the sought-after Lamar Consolidated ISD and the area offers an affordably low tax rate. Downtown Richmond is home to many new boutiques, restaurants, and longstanding businesses. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0248 Plan L401F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '825' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LONG ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'LAMAR CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'WESSENDORF/LAMAR JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mandola Farms' ,`TaxAmount` = '' ,`TaxRate` = '2.41' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '209048216' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:45:25.013' ,`MLSNumber` = '906516' ,`ListAgentFullName` = 'David Tyer' ,`ListOfficeName` = 'Tyer Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.312368' ,`Longitude` = '-95.454991' ,`PhotoCount` = '40' ,`PostalCode` = '75835' ,`RoomCount` = '5' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '600' ,`StreetSuffix` = 'Street' ,`City` = 'Crockett' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3696' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to purchase and enjoy a property that was built in 1920. This 4/5 bedroom 3 full bath home has 3,700 square feet of heating and cooling. YOu will love the spacious rooms throughout along with the tall ceilings, original wood flooring, large windows, and original staircase. The kitchen does offer some updates along with great counter and cabinet space. Off the kitchen is a living area complete with a wood-burning fireplace. On the other side of the kitchen are two other living areas along with a separate dining room and office. Outside you will find a get front and side porch perfect for enjoying the half-acre corner lot. The back of the house has a two-car carport and a fenced-in area. Two new HVAC systems were added to this great property this summer. Do not miss out on the opportunity to restore the beautiful home back to what it once was!' ,`Acres` = '0.55' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A E GOSSETT AB 423 .55 AC' ,`LotDesciption` = 'Cleared' ,`LotSize` = '23958' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'N/A' ,`TaxAmount` = '3304' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '209339536' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:48:11.493' ,`MLSNumber` = '67399593' ,`ListAgentFullName` = 'Jimmy Simien' ,`ListOfficeName` = 'Simien Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.536106' ,`Longitude` = '-95.216053' ,`PhotoCount` = '35' ,`PostalCode` = '77546' ,`RoomCount` = '7' ,`ListPrice` = '259500.00' ,`Status` = 'Active' ,`StreetName` = 'Brandywyne' ,`StreetNumber` = '304' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'CHARMING 3 BEDROOM 2 BATH HOME IN FRIENDSWOOD! NEW PAINT AND CARPET. OVERSIZED BACKYARD. UTILITY ROOM IN HOME. CIRCLE DRIVEWAY WITH COVERED PARKING. QUICK ACCESS TO NEARBY SHOPPING AND DINNING AT BAYBROOK MALL. CALL TO SCHEDULE YOUR PERSONAL SHOWING TODAY!' ,`Acres` = '0.239' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 20 PERRY & AUSTIN SUR E 24.17 FT OF LOT 2 & W 46.83 FT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '20 - Friendswood' ,`SchoolElementary` = 'WESTWOOD ELEMENTARY SCHOOL (FRIENDSWOOD)' ,`SchoolHigh` = 'FRIENDSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'FRIENDSWOOD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Anna Alea Kingspark/Whitehall' ,`TaxAmount` = '5046' ,`TaxRate` = '2.2832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '209860774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:43:05.040' ,`MLSNumber` = '72106673' ,`ListAgentFullName` = 'Maria Williams' ,`ListOfficeName` = 'Texcom Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.194179' ,`Longitude` = '-95.134531' ,`PhotoCount` = '5' ,`PostalCode` = '77372' ,`RoomCount` = '8' ,`ListPrice` = '574000.00' ,`Status` = 'Active' ,`StreetName` = 'Saba' ,`StreetNumber` = '17114' ,`StreetSuffix` = '' ,`City` = 'Splendora' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2697' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction! Another beautiful 4 bedrooms/3 bath/3 car garage home by Garan Builders. The truly exceptional open-design floor plan features a warm, welcoming interior and comes equipped with a home office, good-sized living room and well-proportioned rooms. Make memories in this custom-built kitchen, which includes granite countertops and a tile backsplash. Sized for spacious comfort, the king-sized main bedroom provides a spacious bathrooms and his-and-hers walk-in closets. Adding to the home\'s charm are tile floors throughout the main living spaces. The expansive backyard features a covered patio. A wonderful space for fun. Perfectly positioned in a quiet section of Montgomery County. Live the outdoor lifestyle you\'ve dreamed of! A rare opportunity. Schedule your showing before it’s gone.' ,`Acres` = '1.1' ,`Area` = '40' ,`BuilderName` = 'Garan Builders, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'S827600 - RIO VISTA, BLOCK 2, LOT 34, ACRES 1.1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '47916' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'PEACH CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Mediterranean' ,`Subdivision` = 'Rio Vista' ,`TaxAmount` = '1008' ,`TaxRate` = '2.2341' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '209913668' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:36:55.450' ,`MLSNumber` = '44607076' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.444369' ,`Longitude` = '-95.399964' ,`PhotoCount` = '4' ,`PostalCode` = '77583' ,`RoomCount` = '10' ,`ListPrice` = '733657.00' ,`Status` = 'Active' ,`StreetName` = 'Sanger' ,`StreetNumber` = '9534' ,`StreetSuffix` = 'Way' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3404' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Construction by Shea Homes. Plan 6025. Est. Completion 12/2022. This inviting and spacious single-story home offers 4 bedrooms, 3.5 bathrooms, and a 3-car tandem garage. As you walk through the gorgeous rotunda in the entry, you will find hallways that lead to the secondary bedrooms and office. The Great Room awaits at the end of the hall with a 12\' ceiling featuring beautiful cedar beams, fireplace and stacked sliding doors that fill the space with natural light. An oversized Casual Dining Room leads out to the large, covered patio. Back inside, the gourmet Kitchen included cabinets galore, double ovens, a 5-burner gas cooktop, large kitchen island and a huge walk-in pantry. The primary suite is the perfect place to relax featuring a bay window and spa like bathroom with dual vanities, shower with bench seat and garden tub. A Media Room off the Great Room will provide the perfect space to entertain family and friends. come and Live the Difference in a Shea Home!' ,`Acres` = '0.2492' ,`Area` = '5' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MERIDIANA SEC 44 (A0282 & A0286) (MANVEL) BLK 1 LOT 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10855' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MERIDIANA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'IOWA COLONY HIGH SCHOOL' ,`SchoolMiddle` = 'CAFFEY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meridiana' ,`TaxAmount` = '2070' ,`TaxRate` = '3.6807' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '210464269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:14:31.440' ,`MLSNumber` = '73280705' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.749330' ,`Longitude` = '-95.884196' ,`PhotoCount` = '10' ,`PostalCode` = '77423' ,`RoomCount` = '9' ,`ListPrice` = '501212.00' ,`Status` = 'Active' ,`StreetName` = 'Sycamore Wood' ,`StreetNumber` = '2862' ,`StreetSuffix` = 'Trace' ,`City` = 'Fulshear' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2721' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar\'s Vista Collection \"Cedar Point\" Plan with Elevation \"B\" in Jordan Ranch! The versatile one and half story Cedar Point plan by Lennar features a family room, island kitchen with breakfast nook, formal dining room, master suite, covered rear patio, and a second floor game room and full bath. The Cedar Point floor plan includes options to add a first floor study, and a second floor fifth bedroom. *HOME ESTIMATED TO BE COMPLETE, JANUARY, 2023.*' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0028 BLK 002 LOT 006' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1050' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'LINDSEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Jordan Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.19' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '210575735' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:35:34.923' ,`MLSNumber` = '86104076' ,`ListAgentFullName` = 'Kathryn Hammond' ,`ListOfficeName` = 'RE/MAX On The Water - Bolivar' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.457760' ,`Longitude` = '-94.625480' ,`PhotoCount` = '43' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '598000.00' ,`Status` = 'Active' ,`StreetName` = 'CANAL' ,`StreetNumber` = '2100' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1428' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful three bedroom/two bath home is a dream come true. This large home has a nice big family room,\r\nfacing the front deck. The home features, luxury vinyl flooring, tray ceilings, a wrap around deck. a cargo lift,\r\nand a palapa bar. The yard is fenced for your pets. The sellers uses this home for weekends, and it has never been used as a rental. This \"like new\" home has been well maintained and it will sell furnished. As you can see in the pictures, this property is close to the beach with easy beach access for swimming, fishing and beach combing. \r\nExcellent location in our beach resort paradise on the Bolivar Peninsula.' ,`Acres` = '0.1148' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 57 ALBERDIE ADDN NO 1' ,`LotDesciption` = 'Cul-De-Sac,Water View' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Alberdie Add 1' ,`TaxAmount` = '5427' ,`TaxRate` = '1.6103' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693262' WHERE `Matrix_Unique_ID` = '210815899' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:26:18.393' ,`MLSNumber` = '81059716' ,`ListAgentFullName` = 'Faline Windell' ,`ListOfficeName` = 'Page Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293170' ,`Longitude` = '-95.546960' ,`PhotoCount` = '10' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '669700.00' ,`Status` = 'Active' ,`StreetName` = 'Triple Crown Way' ,`StreetNumber` = '11217' ,`StreetSuffix` = '' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3189' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Country Home with a Pond & 4 Spacious Bedrooms, 3 Full Bathrooms, Open Concept Living, Kitchen, Dining, all on 1st floor with Large Game Room on 2nd. Stunning Chef\'s Kitchen with Granite or Quartz Counters, Stainless Steel Appliances, Double Ovens, 5 Burner Gas Range, 3rd Row Cabinets with Lighting, Dovetail Drawers with Soft Close Hardware & Large Open Island to Living and Dining. Spacious, Open & Airy Throughout with Large Covered Patio perfect for Indoor/Outdoor Living opening to your Private, Wooded, Backyard Oasis & Pond. Custom Features & Trim Work, Energy Efficient with Environments for Living Designation, 16 SEER HVAC, Tankless Water Heater. Serene Country Living Conveniently located close to I-45, Shopping, Restaurants with Low Tax Rate around 1.8488%. Homesite includes Pond for Fishing, Kayaking, Paddelboarding. Personalize Selections Now!' ,`Acres` = '1.243' ,`Area` = '39' ,`BuilderName` = 'Hallmark Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Old Kentucky Farms 02, Block 1, Lot 25' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '54145' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Old Kentucky Farms' ,`TaxAmount` = '' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663693263' WHERE `Matrix_Unique_ID` = '210899157' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T13:42:43.670' ,`MLSNumber` = '61301257' ,`ListAgentFullName` = 'Jon Strong' ,`ListOfficeName` = 'RE/MAX Prime Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.419294' ,`Longitude` = '-95.508261' ,`PhotoCount` = '27' ,`PostalCode` = '77318' ,`RoomCount` = '3' ,`ListPrice` = '459900.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 1097' ,`StreetNumber` = '10322' ,`StreetSuffix` = 'Road' ,`City` = 'Willis' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1256' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! This home has prime location on FM 1097 W in Willis. It is less than a mile from both the lake and I-45, and on a section of 1097 that has recently been upgraded and widened. The property is a total of 19,650 square feet or 0.4511 of an acre. It has a driveway off of 1097 in the front and off Pecan in the back. It has endless possibilities for any type of business with its proximity to both Lake Conroe and Interstate 45. The property has a 1250 square foot home as well as a 1250 square foot shop on the property.' ,`Acres` = '0.4511' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S591002 - HULON LAKES 02, BLOCK 11, LOT 23, 24' ,`LotDesciption` = 'Wooded' ,`LotSize` = '19650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'C.C. HARDY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Hulon Lakes' ,`TaxAmount` = '3155' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693263' WHERE `Matrix_Unique_ID` = '210899912' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T12:20:35.760' ,`MLSNumber` = '60034109' ,`ListAgentFullName` = 'Faline Windell' ,`ListOfficeName` = 'Page Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.293456' ,`Longitude` = '-95.547043' ,`PhotoCount` = '9' ,`PostalCode` = '77304' ,`RoomCount` = '8' ,`ListPrice` = '665700.00' ,`Status` = 'Active' ,`StreetName` = 'Triple Crown' ,`StreetNumber` = '11211' ,`StreetSuffix` = 'Way' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2981' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Country Home on a Pond with 3 Spacious Bedrooms, Large Study, 3 1/2 Bathrooms, Open Concept Living, Kitchen, Dining all on 1st floor with Large Bonus Room on 2nd. Stunning Chef\'s Kitchen with Granite or Quartz Counters, Stainless Steel Appliances, Double Ovens, 5 Burner Gas Range, 3rd Row Cabinets with Lighting, Dovetail Drawers with Soft Close Hardware & Large Open Island to Living & Dining. Spacious, Open & Airy Throughout with Oversized Covered Patio perfect for Indoor/Outdoor Living opening to your Private, Waterfront, Backyard Oasis on a beautiful Pond that is included in your homesite acreage. Custom Features & Trim Work, Energy Efficient with Environments for Living Designation, 16 SEER HVAC, Tankless Water Heater. Serene Country Living Conveniently located close to I-45, Shopping, Restaurants with low tax rate. Personalize Selections Now!' ,`Acres` = '1.098' ,`Area` = '39' ,`BuilderName` = 'Hallmark Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Old Kentucky Farms 02, Block 1, Lot 24' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Water View,Waterfront,Wooded' ,`LotSize` = '47828' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Old Kentucky Farms' ,`TaxAmount` = '' ,`TaxRate` = '1.9103' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663693263' WHERE `Matrix_Unique_ID` = '210900074' --> Updated record success