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-11-28T16:36:32.873' ,`MLSNumber` = '33001489' ,`ListAgentFullName` = 'Arthur Wayne Garza' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.765679' ,`Longitude` = '-94.423293' ,`PhotoCount` = '18' ,`PostalCode` = '75979' ,`RoomCount` = '4' ,`ListPrice` = '168500.00' ,`Status` = 'Active' ,`StreetName` = 'Pecan' ,`StreetNumber` = '1005' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1141' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0657 J. WHEAT,BLOCK 64, TRACT 4, ACRES 1.25' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'na' ,`TaxAmount` = '1422' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675085029' WHERE `Matrix_Unique_ID` = '207304849'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:20:44.157' ,`MLSNumber` = '84319980' ,`ListAgentFullName` = 'Alison Coy' ,`ListOfficeName` = 'Privet Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809111' ,`Longitude` = '-95.431603' ,`PhotoCount` = '10' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Ohsfeldt' ,`StreetNumber` = '2540' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction in desirable Shady Acres! This is our most popular floorplan for a reason, it\'s spacious with large bedrooms and plenty of windows to let in natural light. The oversized master bedroom comfortably fits large scale furniture, has a seating area and a special little nook for a coffee or tea bar. The master bathroom boasts marble tile floors and shower walls. Meticulously picked finishes set this home apart from any other. Come see this home today!' ,`Acres` = '0.0608' ,`Area` = '9' ,`BuilderName` = 'Redwood Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 SHADY ACRES SEC 2 5TH PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Shady Acres' ,`TaxAmount` = '2779' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085029' WHERE `Matrix_Unique_ID` = '211504876'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:04:03.007' ,`MLSNumber` = '63318009' ,`ListAgentFullName` = 'Megan Stultz' ,`ListOfficeName` = 'Fairwater Westmont Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.315696' ,`Longitude` = '-95.783465' ,`PhotoCount` = '48' ,`PostalCode` = '77316' ,`RoomCount` = '10' ,`ListPrice` = '2900000.00' ,`Status` = 'Active' ,`StreetName` = 'Lily Bean' ,`StreetNumber` = '4469' ,`StreetSuffix` = 'Road' ,`City` = 'Montgomery' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '5005' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning custom estate built by K&C Classic Homes is nestled among soaring trees and sits on Bluejack National\'s premier golf course. As you enter your home, you will notice the bright and airy open floor plan, large windows, and extensive custom details throughout! The home boasts five bedrooms including two primary bedrooms downstairs.  Each bedroom has a bathroom, and the upstairs enjoys a large game room. The screened in back porch is the perfect place to grill dinner, watch the game, and enjoy the outdoor fireplace Whether you are living at Bluejack National, that boasts the #1 Private golf course in the state of Texas, full-time, using it as a weekend getaway, or simply for the holidays, you owe it to yourself to make this home yours.' ,`Acres` = '0.57' ,`Area` = '39' ,`BuilderName` = 'K&C Classic Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montgomery County Northwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S263700 - BLUEJACK NATIONAL PHASE 1A, BLOCK 1, LOT 9' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '24829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'MONTGOMERY ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'MONTGOMERY HIGH SCHOOL' ,`SchoolMiddle` = 'MONTGOMERY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bluejack National Ph 1a' ,`TaxAmount` = '7633' ,`TaxRate` = '3.0742' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675085030' WHERE `Matrix_Unique_ID` = '211574630'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T16:34:23.383' ,`MLSNumber` = '35610015' ,`ListAgentFullName` = 'Arthur Wayne Garza' ,`ListOfficeName` = 'Keller Williams Realty-FM' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.522813' ,`Longitude` = '-93.780798' ,`PhotoCount` = '25' ,`PostalCode` = '75959' ,`RoomCount` = '3' ,`ListPrice` = '543000.00' ,`Status` = 'Active' ,`StreetName` = 'Carters Ferry' ,`StreetNumber` = '4465' ,`StreetSuffix` = '' ,`City` = 'Milam' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1408' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '3.25' ,`Area` = '79' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '3.043,Abst: 65 J A BURDITT, A 65 J A BURDITT SVY CABINS' ,`LotDesciption` = 'Cleared,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '217 - Hemphill' ,`SchoolElementary` = 'HEMPHILL ELEMENTARY SCHOOL (HEMPHILL)' ,`SchoolHigh` = 'HEMPHILL HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPHILL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'no' ,`TaxAmount` = '3950' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085030' WHERE `Matrix_Unique_ID` = '212527042'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:14:17.020' ,`MLSNumber` = '60881981' ,`ListAgentFullName` = 'Cari Goeke' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Jan Carroll' ,`SellingOfficeName` = 'Round Top Real Estate' ,`Latitude` = '30.151312' ,`Longitude` = '-96.370540' ,`PhotoCount` = '43' ,`PostalCode` = '77833' ,`RoomCount` = '5' ,`ListPrice` = '1449900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Gun And Rod' ,`StreetNumber` = '2320' ,`StreetSuffix` = 'Circle' ,`City` = 'Brenham' ,`BathsFull` = '6' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '4805' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to one of Brenham\'s finest homes, sophisticated and indescribable, nestled back on an acre of lush landscape in one of the most prominent and sought-after streets this community has to offer. This home is truly one of a kind, meticulously designed by the award winning, Jay Baker Architects out of Houston, TX, stunning from top to bottom, every detail thought out making this home classic and timeless. The property and home alike have been situated to boast a tremendous amount of privacy, allowing a country type ambiance while still being conveniently located within the city limits. The main home offers a bright and airy feel with a touch of French country meets modern architecture; from every angle of the interior home, you oversee the beautiful courtyard, a perfect centerpiece, three bedrooms, five bathrooms, multiple common areas and extras. The guest cottage offers one bedroom and one full bathroom. *Additional photos and buyer\'s package upon request.*' ,`Acres` = '1.038' ,`Area` = '58' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S3057 - GUN & ROD CIRCLE S/D, LOT 1 & 2, ACRES 1.038' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '45215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Grill' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '137 - Brenham' ,`SchoolElementary` = 'BISD DRAW' ,`SchoolHigh` = 'BRENHAM HIGH SCHOOL' ,`SchoolMiddle` = 'BRENHAM JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,French,Traditional' ,`Subdivision` = 'Gun & Rod Circle' ,`TaxAmount` = '19097' ,`TaxRate` = '2.0369' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085030' WHERE `Matrix_Unique_ID` = '212984975'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:13:10.770' ,`MLSNumber` = '26839319' ,`ListAgentFullName` = 'Marysol Calvillo' ,`ListOfficeName` = 'Elite Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.861181' ,`Longitude` = '-95.654794' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '5' ,`ListPrice` = '424900.00' ,`Status` = 'Active' ,`StreetName` = 'Carrollton Creek' ,`StreetNumber` = '5706' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3554' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for 4-bedroom 3.5 bath home on a HUGE cul-de-sac lot perfect for just someone who wants a Texas size home at a great price!! This home has double principal bedrooms, one upstairs and one downstairs; has multiple bonus rooms that can easily be converted into game rooms, office spaces, formals, or even an extra bedroom.  The big back yard is perfect for a pool, gardening, kids, and pets! Schedule your tour today!' ,`Acres` = '0.2783' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 2 VILLAGES OF LANGHAM CREEK 3' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '12122' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '375' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'TIPPS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LANGHAM CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'KAHLA MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Villages Langham Creek' ,`TaxAmount` = '6330' ,`TaxRate` = '2.861' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085030' WHERE `Matrix_Unique_ID` = '213859519'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:19:04.490' ,`MLSNumber` = '25637867' ,`ListAgentFullName` = 'Dwayne White' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776096' ,`Longitude` = '-95.038159' ,`PhotoCount` = '16' ,`PostalCode` = '77520' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Lazy' ,`StreetNumber` = '118' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1799' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful recently renovated 3 bedroom 2 full bath spacious home situated in a quiet neighborhood. It’s a definite must see with large living room featuring built in shelving and a cozy brick fireplace. It has a spacious kitchen with new appliances and granite countertops and gorgeous enclosed back patio. Schedule your appointment to take a tour of this gem.' ,`Acres` = '0.2893' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 43 LAKEWOOD SEC L' ,`LotDesciption` = 'Other' ,`LotSize` = '12600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lakewood' ,`TaxAmount` = '4242' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085031' WHERE `Matrix_Unique_ID` = '214332772'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:56:27.690' ,`MLSNumber` = '55345608' ,`ListAgentFullName` = 'Sarah Miller' ,`ListOfficeName` = 'Engel & Volkers Bryan College Station' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.571850' ,`Longitude` = '-96.225309' ,`PhotoCount` = '12' ,`PostalCode` = '77845' ,`RoomCount` = '13' ,`ListPrice` = '934900.00' ,`Status` = 'Active' ,`StreetName` = 'Arcadia Bluffs' ,`StreetNumber` = '1968' ,`StreetSuffix` = 'Drive' ,`City` = 'College Station' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enter the doors of this exquisite custom home, built by 5K Homes located in the new area of Pebble Creek! This 4 bedroom, 4 1/2 bathroom home is a dream with open floor plan, tall ceilings, & fabulous finishes. The living room has a stunning gas fireplace, wood shelving built-ins, a fantastic wet bar, & views into the kitchen & dining room. An exposed brick wall is a focal point in the large dining area. Off the dining room & kitchen, you will find a laundry room and butler’s pantry. The spacious master bedroom has gorgeous windows, & a master bathroom that has double sinks, walk-in shower, soaking tub, & walk-in closet. Downstairs find 2 additional bedrooms with their own full bathrooms with fantastic finishes & closets. Upstairs find an additional large bedroom with its own bathroom and walk-in closet. A private office can be found off the entry. Additional features include mud room, covered patio area with outdoor kitchen, spacious backyard, & 2 garages with a capacity for 3 cars.' ,`Acres` = '0.289' ,`Area` = '61' ,`BuilderName` = '5K Homes Inc.' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PEBBLE CREEK PH 11A, BLOCK 2, LOT 9' ,`LotDesciption` = 'Other' ,`LotSize` = '12588' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '153 - College Station' ,`SchoolElementary` = 'PEBBLE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'A & M CONSOLIDATED HIGH SCHOOL' ,`SchoolMiddle` = 'A & M CONSOLIDATED MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pebble Creek' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1675085031' WHERE `Matrix_Unique_ID` = '214608725'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:51:23.560' ,`MLSNumber` = '77008037' ,`ListAgentFullName` = 'Jake Moore' ,`ListOfficeName` = 'Jake Moore Home Selling Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.563449' ,`Longitude` = '-95.804564' ,`PhotoCount` = '13' ,`PostalCode` = '77471' ,`RoomCount` = '6' ,`ListPrice` = '209000.00' ,`Status` = 'Active' ,`StreetName` = '5th' ,`StreetNumber` = '419' ,`StreetSuffix` = 'Street' ,`City` = 'Rosenberg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1221' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'COMPLETELY RENOVATED! Are you looking for the relaxing lifestyle of a small town with the benefits of a brand new home? You\'ll enjoy both in this open concept one-story with 3 spacious bedrooms and 2 full bathrooms. The home is constructed with brand new foundation support, roof, HVAC, and PEX piping! Beautiful new flooring and paint throughout the home! Brand new windows offer abundant natural light. Have a staycation every day in the resort style bathrooms with stunning tile work and luxe fixtures. Kitchen boasts new cabinets, granite countertops, subway tile and stainless steel appliances. New fence gives you privacy in the sprawling backyard featuring a beautiful mature tree that will keep you cool as you sip ice cold tea on the back porch. Schedule your private tour today!' ,`Acres` = '' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROSENBERG , BLOCK 24, LOT 8 (PT)' ,`LotDesciption` = 'Other' ,`LotSize` = '2928' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'JACKSON ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rosenberg' ,`TaxAmount` = '699' ,`TaxRate` = '2.0748' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1938' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085031' WHERE `Matrix_Unique_ID` = '214632455'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T15:12:00.040' ,`MLSNumber` = '98693311' ,`ListAgentFullName` = 'Christina Ilonzeh' ,`ListOfficeName` = 'Christina Ilonzeh' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.599457' ,`Longitude` = '-95.531167' ,`PhotoCount` = '10' ,`PostalCode` = '77489' ,`RoomCount` = '3' ,`ListPrice` = '229000.00' ,`Status` = 'Active' ,`StreetName` = 'Grand Park' ,`StreetNumber` = '1739' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1244' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Recently remodeled 1 story, 3 bedroom 2 bathroom home located short walking distance to neighborhood amenities (park and tennis courts)! This lovely home features fresh paint, new appliances, granite countertops and is located on a spacious corner lot!' ,`Acres` = '0.1719' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'QUAIL GREEN WEST SEC 1, BLOCK 4, LOT 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7486' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'E A JONES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARSHALL HIGH SCHOOL (FORT BEND)' ,`SchoolMiddle` = 'MISSOURI CITY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Quail Green West Sec 1' ,`TaxAmount` = '4332' ,`TaxRate` = '3.1174' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085031' WHERE `Matrix_Unique_ID` = '214658572'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T16:16:10.133' ,`MLSNumber` = '97124735' ,`ListAgentFullName` = 'Jay Clemente' ,`ListOfficeName` = 'Realty World Homes & Estates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164415' ,`Longitude` = '-95.810783' ,`PhotoCount` = '29' ,`PostalCode` = '77447' ,`RoomCount` = '3' ,`ListPrice` = '349500.00' ,`Status` = 'Active' ,`StreetName` = 'Joseph' ,`StreetNumber` = '25342' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2544' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '2.15' ,`Area` = '26' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S441103 COUNTRY LANE ESTATES 3 BLK 3 LOT 13 ACRES 2.15' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '93654' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '144' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'FIELDS STORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Country Lane Estates 3' ,`TaxAmount` = '7445' ,`TaxRate` = '2.0243' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085032' WHERE `Matrix_Unique_ID` = '214665211'  --> 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','215140221','1675085032','215140221','2022-11-28T16:30:58.637','88033627','April Lendo','Keller Williams SoutheastTexas','','','31.069982','-94.028415','27','75931','3','425000.00','Active','Sweetbriar','155','Court','Brookeland','2','0','3','1398','Single-Family','NEW CONSTRUCTION! Beautiful new custom home on the 17th hole in Rayburn Country! From the quartz countertops to the spacious back porch, this is a place to call home! When entering the home though the oversized garage (29\' deep), there is ample space for a MUD room or office area. The large kitchen island and living area is great for entertaining! Master bathroom features quartz countertops with his and her sinks and custom walk in shower. Minutes from the boat ramps on Lake Sam Rayburn and just a golf cart ride away from Rayburn Country Resort! Enjoy all the amenities of the country club; including golf, swimming, fine dining, pickle ball, The Grind coffee shop and the new out door bar and restaurant, Sammy Ray\'s!','0.37','46','Of record','','Electric Dryer Connections','','No Disclosures','1','','0','','Central Electric','1','LOT 84 SEC 7 RAYBURN COUNTRY 1234/1096 0.37 ACRES','Cul-De-Sac','16117','Appraisal District','','','1','Never Lived In','2','','0','','','Electric Range','','Composition','144 - Brookeland','BROOKELAND ELEMENTARY SCHOOL','BROOKELAND HIGH SCHOOL','BROOKELAND HIGH SCHOOL','Lockbox Front','Seller','1','Contemporary/Modern','Rayburn Country Sub Sec 7','201','1.6721','Public Sewer,Public Water','2022','Seller');  --> New record created successfully<br />