Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T17:37:20.463' ,`MLSNumber` = '84516640' ,`ListAgentFullName` = 'Charles Miller' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.821500' ,`Longitude` = '-95.128625' ,`PhotoCount` = '43' ,`PostalCode` = '77360' ,`RoomCount` = '9' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = 'Hilltop' ,`StreetNumber` = '111' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2436' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently renovated home with two completely separate living living spaces in the beautiful Pine Harbor subdivision on Lake Livingston. The upstairs living space is approximately 1400SF with full kitchen, 3 bedrooms and 2 full bathrooms, spacious living area, and utilities. The downstairs living space is approximately 1000SF with full kitchen, 1 bedroom and 1 full bathroom, utilities, and 1 car garage. Separate water, electricity, addresses, and climate control. Seasonal water views and only a short walk away from the lake and subdivision boat launch. Close to town and only one hour North of Houston.' ,`Acres` = '0.53' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PINE HARBOR SECTION 3 BLK 3 LOT 30' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23347' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pine Harbor Sec 3' ,`TaxAmount` = '3674' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094372' WHERE `Matrix_Unique_ID` = '206050094'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T17:01:16.337' ,`MLSNumber` = '76159351' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Honor Hilton' ,`SellingOfficeName` = 'Home Sweet Home RE Group' ,`Latitude` = '30.063014' ,`Longitude` = '-95.715878' ,`PhotoCount` = '17' ,`PostalCode` = '77377' ,`RoomCount` = '13' ,`ListPrice` = '474511.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Yearling Pasture' ,`StreetNumber` = '20427' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2877' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Fall in love with this charming Beazer Home in Amira, boasting a brick façade, luxury vinyl plank flooring, wrought iron spindles, a fireplace, a study with French doors, an open great room, and an extended covered patio. Imagine up new recipes in the kitchen, equipped with quartz countertops, mosaic backsplash, 30” cooktop, stainless steel appliances, pendant lighting, and under-counter lighting. Relax in the serene primary suite featuring a walk-in closet, dual vanities, and a mud set shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are zoned to the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 15 Block 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094372' WHERE `Matrix_Unique_ID` = '208837579'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T17:13:15.243' ,`MLSNumber` = '93909918' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Becky Matthews' ,`SellingOfficeName` = 'Ward Kellner Properties, Inc.' ,`Latitude` = '30.061539' ,`Longitude` = '-95.720396' ,`PhotoCount` = '16' ,`PostalCode` = '77377' ,`RoomCount` = '10' ,`ListPrice` = '450691.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Rose Gray' ,`StreetNumber` = '20330' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2505' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Seek comfort in this lovely Beazer Home in Amira, boasting a brick façade, wood-look tile flooring, a fireplace, a study with French doors, an open great room, and an extended covered patio. Spend time in the kitchen, equipped with quartz countertops, mosaic backsplash, large cove molding, stainless steel appliances, 42” upper cabinets, and pendant lighting. Complete with a walk-in closet, dual vanities, a tub, and a separate shower, the primary suite is the perfect place for unwinding. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are zoned to the top-rated Tomball ISD. Arrange your private showing today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 11 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094372' WHERE `Matrix_Unique_ID` = '208838535'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T17:04:22.563' ,`MLSNumber` = '75458825' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Dorothy Wanko' ,`SellingOfficeName` = 'TEXdot Real Estate Services,Inc.' ,`Latitude` = '30.061595' ,`Longitude` = '-95.720213' ,`PhotoCount` = '11' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '424325.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hackney Trot' ,`StreetNumber` = '18911' ,`StreetSuffix` = 'Lane' ,`City` = 'Tomball' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2337' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This stunning Beazer Home in Amira has it all, boasting a brick façade, sloped ceilings, luxury vinyl plank flooring, cast stone fireplace, a study with French doors, an open great room, and an extended covered patio. Whip up meals for guests in the kitchen, equipped with quartz countertops, tile backsplash, large cove molding, 30” cooktop, stainless steel appliances, 42” upper cabinets, pendant lighting, and under-counter lighting. Unwind in the serene primary suite, featuring a walk-in closet, dual vanities, and a mud set shower. With the community situated so close to the Grand Parkway and Hwy 249, residents are only minutes away from a variety of dining and shopping options. Amira amenities include an infinity-edge pool, dog park, and gym. Nearby schools are zoned to the top-rated Tomball ISD. Call now to learn more!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 25 Block 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '975' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Amira' ,`TaxAmount` = '' ,`TaxRate` = '3.551993' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094372' WHERE `Matrix_Unique_ID` = '208839474'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T17:27:51.033' ,`MLSNumber` = '96471122' ,`ListAgentFullName` = 'Adam Olsen' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.590490' ,`Longitude` = '-95.133658' ,`PhotoCount` = '42' ,`PostalCode` = '77331' ,`RoomCount` = '4' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'State Highway 150' ,`StreetNumber` = '14962' ,`StreetSuffix` = '' ,`City` = 'Coldspring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION! Situated on .46 acres, this property boasts a 2,110 Sq Ft building that is versatile in use and could be used for residential or commercial purposes. In the low-tax area of San Jacinto county, the property is located right off of State Highway 150, making it a prime location. This property is priced to sell and won\'t last long! Schedule a private tour today!' ,`Acres` = '0.46' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WEST ADDITION, BLOCK 12, LOT 1, W 6.73\' OF 2, PT OF 3 & 4, 5' ,`LotDesciption` = 'Cleared' ,`LotSize` = '20037' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Other' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'West Add' ,`TaxAmount` = '1774' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094373' WHERE `Matrix_Unique_ID` = '209637010'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T17:21:47.250' ,`MLSNumber` = '7721351' ,`ListAgentFullName` = 'Janice Jones-Martin' ,`ListOfficeName` = 'Clark Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.170176' ,`Longitude` = '-95.451075' ,`PhotoCount` = '45' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '504000.00' ,`Status` = 'Active' ,`StreetName` = 'Heritage Oaks' ,`StreetNumber` = '704' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3948' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy a great view from the living area as you can hardly wait to step into your very own backyard paradise fenced for privacy.  Bedrock hand-carved and painted natural rock pool.  Separate pergola or palapa covered sitting areas day or night lighting to entertain or relax like you\'ve always wanted. Kitchen have granite, breakfast area, and tile flooring. \r\nThe large primary bedroom ambience, sitting area and singing in the rain showers.   Lots of closet space throughout.\r\nThe 3 bedroom, 4.5 bath home has an extra suite with electric stove and dishwasher in the efficiency kitchen and its own full bathroom all under one roof for Gen-X or college bound student is a huge plus.   Indoor Utility room centrally located.  Upstairs is the media room with a full bath as well.   \r\nOver-sized 3-car garage has a safe built into floor of the slab is there to stay.  Extra space well-lit and storage building with electricity.' ,`Acres` = '0.5722' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'HERITAGE OAKS (A0380 & A0699) (ANGLETON) BLK 7 LOT 3' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '24925' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Oaks' ,`TaxAmount` = '11993' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094373' WHERE `Matrix_Unique_ID` = '209707876'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-22T18:43:06.010' ,`MLSNumber` = '5305570' ,`ListAgentFullName` = 'Joyce Martin' ,`ListOfficeName` = 'Martin Beazley Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.670256' ,`Longitude` = '-94.995077' ,`PhotoCount` = '27' ,`PostalCode` = '77571' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Bayridge' ,`StreetNumber` = '414' ,`StreetSuffix` = 'Road' ,`City` = 'Morgan\'s Point' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Historical home in Morgan\'s Point on over half an acre with lots of possibilities. Stand alone two car garage has a new minisplit heating and AC unit in the garage installed in 2022.  On the patio in the rear of the home overlooking the spacious back yard is a new hot tub; there is also a trampoline in the yard.   Balcony on the second floor is a great spot for morning coffee with a view of the channel.  Home is minutes from Sylvan Beach Park. This could be an investment property or your personal costal getaway just minutes from the city.' ,`Acres` = '0.5808' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 8 9 10 & 11 & E 10 FT OF LT 7 BLK 1058 LA PORTE' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '25300' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'LA PORTE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French' ,`Subdivision` = 'La Porte' ,`TaxAmount` = '5196' ,`TaxRate` = '2.9614' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094373' WHERE `Matrix_Unique_ID` = '213056372'  --> Updated record success<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215649712','1675094373','215649712','2022-12-22T18:45:17.453','9727212','Huy Phan','Keller Williams Signature','','','29.614674','-95.567001','50','77477','8','599000.00','Active','Whitney Oaks','615','Lane','Stafford','3','1','4','3721','Single-Family','Welcome to this gorgeous Westin Home in Estates at Promenade! Great location and easy access to Hwy 6, Beltway 8, 69, 90, nearby shopping centers, restaurants. Perfect layout with 4 spacious bedrooms and 3.5 baths. The home features elegant entry way with high ceilings, tile/wood flooring and crown molding through out, nice office, formal dining and game room/home theater upstairs. Enjoy the open concept living and kitchen area which is ideal for entertaining with family and friends. Relaxing backyard with nice detached patio. This won’t last long. Schedule your showing now!','0.1515','29','WESTIN HOMES','','Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','1','Stafford Area','Central Gas','1','ESTATES AT PROMENADE SEC 1, BLOCK 2, LOT 30','Subdivision Lot','6600','Appraisal District','','590','0','','2','Electric Oven,Single Oven','0','','','Electric Cooktop','','Composition','50 - Stafford','STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)','STAFFORD HIGH SCHOOL','STAFFORD INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment','Appraisal District','2','Traditional','Estates At Promenade Sec 1','7470','1.9342','Water District','2013','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215812637','1675094373','215812637','2022-12-22T18:49:44.313','76731704','Jessica Portillo','Intero Real Estate Services','','','30.531302','-96.290278','10','77845','6','259950.00','Active','Clear Meadow Creek','3811','Avenue','College Station','2','0','3','1206','Single-Family','This is the perfect starter home or ideal investor property. Home is occupied, tenant lease runs through June 2023. No showings, unless approved by tenant.','0.1401','61','','','','','Sellers Disclosure','','','','','Central Gas','1','CREEK MEADOWS SEC 2 PH 1B, BLOCK 2, LOT 6','Subdivision Lot','6103','Appraisal District','','344','0','','2','','0','','','','','Wood Shingle','153 - College Station','GREEN PRAIRIE ELEMENTARY SCHOOL','A & M CONSOLIDATED HIGH SCHOOL','WELLBORN MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Creek Mdws Sec 02 Ph 01b','4669','2.1321','Public Sewer,Public Water','2012','Appraisal District');  --> New record created successfully<br />