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` = '2023-01-22T08:28:51.733' ,`MLSNumber` = '11561913' ,`ListAgentFullName` = 'Dorothy Yee' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = 'Patricio Andrin' ,`SellingOfficeName` = 'Lone Star Realty' ,`Latitude` = '29.698367' ,`Longitude` = '-95.640732' ,`PhotoCount` = '23' ,`PostalCode` = '77083' ,`RoomCount` = '8' ,`ListPrice` = '338000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Autumn Sun' ,`StreetNumber` = '7251' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2140' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic 2 story, 4 bedrooms, 2.5 baths, 2 car garage. Family Room, Formal Dining Room and Gameroom. All new carpet, fresh paint, new vinyl wood floors, new 5 burner gas range, new dishwasher and new microwave. New water heater. Tile flooring in entry, kitchen and breakfast area, bathrooms and utility room. Primary bedroom downstairs. 3 bedrooms, gameroom and utility room on second floor. Refrigerator, washer and dryer included. Ready for move-in. Low tax rate and Low HOA fees. Seller will provide a one year home warranty' ,`Acres` = '' ,`Area` = '28' ,`BuilderName` = 'Brighton Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 4 TERRA DEL SOL SEC 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '558' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'HICKS ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALBRIGHT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Terra Del Sol' ,`TaxAmount` = '6211' ,`TaxRate` = '2.5785' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217469' WHERE `Matrix_Unique_ID` = '208153834' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T07:38:36.557' ,`MLSNumber` = '87947166' ,`ListAgentFullName` = 'Robert Peltier' ,`ListOfficeName` = 'Bob Peltier & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.023729' ,`Longitude` = '-95.513323' ,`PhotoCount` = '50' ,`PostalCode` = '77422' ,`RoomCount` = '8' ,`ListPrice` = '649900.00' ,`Status` = 'Active' ,`StreetName` = 'COUNTY ROAD 400' ,`StreetNumber` = '7273' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2300' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lake Jackson, Brazoria area country farm house on almost 14 acres! Fenced for livestock or horses. Currently AG EXEMPT. No restrictions. Built by B & M Woodworks. Mature oak and pecan trees. Great neighborhood, clean area, nice country homes. Beautiful, natural light throughout the entire home. Remarkable handcrafted wood countertops. Over 600+/- SQFT. of potential living space above the garage that could easily be converted into a game room, media room, office, workshop, or whatever your heart desires. Short commute to work. 15 mins to the San Bernard River. Apx. 1 hour to the medical center. Less than 10 mins to the mall. Wooded in the back and touches up to hundreds of acres of farm land. Put up a feeder and watch the deer come in! The property does currently have cattle and horses on it. Don’t miss out on this unique opportunity to have your very own ranchette right on the edge of town. Give us a call today for your private showing! Watch the VIRTUAL TOUR VIDEO.' ,`Acres` = '13.8832' ,`Area` = '5' ,`BuilderName` = 'B & M Woodworks' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 S F AUSTIN TRACT 19 (DIV 16) ACRES 13.3832' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'CR 400' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Well' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217469' WHERE `Matrix_Unique_ID` = '208945094' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T08:12:49.443' ,`MLSNumber` = '81080695' ,`ListAgentFullName` = 'Sherrie Bass' ,`ListOfficeName` = 'Bluewater Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.071324' ,`Longitude` = '-95.124355' ,`PhotoCount` = '38' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '398800.00' ,`Status` = 'Active' ,`StreetName` = 'Jolly Roger' ,`StreetNumber` = '12910' ,`StreetSuffix` = 'Drive' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1176' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this little gem in paradise!! Great location to the beach entrance with views to the gulf and sunrise. Open floor plan with kitchen, dining, and living area with a loft for extra sleeping. This property has been a vacation rental for a few years and has a following. Treasure Island has a community building, boat ramp, and fishing pier on the bayside. You can golf cart all the way down the island for fantastic shelling and fishing or to the bayside to watch the sunset.' ,`Acres` = '0.1148' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Treasure Island' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'TREASURE ISLAND (A0029 S F AUSTIN), BLOCK 16, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '5001' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Treasure Island' ,`TaxAmount` = '4412' ,`TaxRate` = '2.3804' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217469' WHERE `Matrix_Unique_ID` = '211074107' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T08:12:14.797' ,`MLSNumber` = '89175228' ,`ListAgentFullName` = 'Charlene Findley' ,`ListOfficeName` = 'Boom Real Estate' ,`SellingAgentFullName` = 'Charlene Findley' ,`SellingOfficeName` = 'Boom Real Estate' ,`Latitude` = '29.981909' ,`Longitude` = '-95.112276' ,`PhotoCount` = '44' ,`PostalCode` = '77532' ,`RoomCount` = '11' ,`ListPrice` = '294900.00' ,`Status` = 'Option Pending' ,`StreetName` = 'White Feather' ,`StreetNumber` = '1803' ,`StreetSuffix` = 'Trail' ,`City` = 'Crosby' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2707' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous home backs up to Indian Shores golf course. The living room has a high ceiling with a soaring stone fireplace. Lots of windows that face the golf course. Wet bar. Spacious kitchen with quartz counters and tile backsplash, plenty of cabinets for all your cooking gadgets. Primary bedroom with access to the back patio, lg. walk-in closet, double sinks vanity, separate shower, and jetted tub. Game room upstairs. Laminate wood flooring throughout the home, tile in bathrooms. Covered back patio. Access to Lake Houston, boat launch, pool, and clubhouse. Low HOA fees. HUFFMAN ISD.' ,`Acres` = '0.302' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 27 INDIAN SHORES SEC 4' ,`LotDesciption` = 'In Golf Course Community,On Golf Course' ,`LotSize` = '13156' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'HUFFMAN ELEMENTARY SCHOOL (HUFFMAN)' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Shores Sec 04' ,`TaxAmount` = '6859' ,`TaxRate` = '2.5873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217470' WHERE `Matrix_Unique_ID` = '212562737' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T08:03:59.243' ,`MLSNumber` = '83459362' ,`ListAgentFullName` = 'Stephen Krueger' ,`ListOfficeName` = 'RE/MAX Grand' ,`SellingAgentFullName` = 'Stephen Krueger' ,`SellingOfficeName` = 'RE/MAX Grand' ,`Latitude` = '29.345534' ,`Longitude` = '-95.480794' ,`PhotoCount` = '46' ,`PostalCode` = '77583' ,`RoomCount` = '12' ,`ListPrice` = '635000.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Suncreek' ,`StreetNumber` = '16703' ,`StreetSuffix` = 'Ranch' ,`City` = 'Rosharon' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '4201' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRICED WELL BELOW MARKET VALUE - Awesome opportunity to own a country home on 5 acres, with a pool! This 5-bedroom home has space for everyone. The open floorplan offers a formal dining room, large kitchen that opens into the living room and space for large built-in refrigerator units. Primary bedroom is on the first floor, with a large ensuite bathroom with a gorgeous stand-alone soaking tub. There is a secondary bedroom downstairs w/ access to a full bathroom. The upstairs boasts 2 large rooms that could be used for game rooms or media rooms, plus 3 good sized bedrooms. One secondary bedroom upstairs even has an ensuite bath and balcony. 2nd floor A/C new 6/21 The beautiful lot is partially fenced and has a gorgeous pool, just steps from the back door. Complete surveillance system with DVR stays and the propane tank was recently filled. Great opportunity with a low tax rate. Horses welcome. Perfect for FFA or 4H projects. NEVER FLOODED' ,`Acres` = '5' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Rosharon' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'SUNCREEK RANCH SEC 1 (A0125 A ROBINSON) BLK 4 LOT 5' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Suncreek Ranch' ,`TaxAmount` = '6951' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217470' WHERE `Matrix_Unique_ID` = '213723064' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-22T08:54:38.147' ,`MLSNumber` = '88453290' ,`ListAgentFullName` = 'Benjamin Deal' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.983697' ,`Longitude` = '-95.502918' ,`PhotoCount` = '20' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '240000.00' ,`Status` = 'Active' ,`StreetName` = 'Weldon' ,`StreetNumber` = '10219' ,`StreetSuffix` = 'Road' ,`City` = 'Jones Creek' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Who\'s ready for space!? We\'ve got the one for you! This 3-bedroom, 2 bathroom home is situated on 1.59 acres and features a detached two car garage! Totally remodeled and turn key, this home is sure to catch your eye from the moment you arrive. Upon entry take note of the high ceilings and windows showcasing the property and tons of natural light. You will fall in love with the open, fully renovated kitchen with new stainless-steel appliances, cabinets and granite countertops. The home features a split and open floor plan making this desirable for most with a fully updated bathroom. New, durable and easy to clean wood-look tile throughout and barn doors in the rooms. This one will not last long! Schedule your showing today!' ,`Acres` = '1.5956' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 S F AUSTIN TRACT 3D (DIV 17) ACRES 1.5956 (%JONES CREE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '69504' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '4296' ,`TaxRate` = '2.5124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675217470' WHERE `Matrix_Unique_ID` = '214945303' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215057948','1675217470','215057948','2023-01-22T08:21:56.863','67727707','Elizabeth Burkett','eXp Realty, LLC','Breanna Kincaid','Stone\'s Throw Realty','30.163396','-95.411423','46','77385','9','515000.00','Option Pending','Creek View','11710','Lane','Conroe','2','1','3','2385','Single-Family','Home is where your comfort zone is, one visit here and you\'ll never want to go anywhere else. As you travel into White Oak Estates, you\'ll enjoy the country sceneries, a warm community and all the welcoming amenities. This meticulously maintained split floor plan single story home features 3 bedrooms, 2.5 bathrooms and a home office. The open concept provides a great entertaining space for everyone to enjoy. Built-in cabinetry throughout offering tons of storage. Primary bedroom has a gas burning fireplace, updated en-suite, roomy walk-in closet, and French doors that allow private access to a fully enclosed sunroom. Nestled among the trees and sitting on well over an acre you\'ll find plenty of room to walk, bike, hike, ride horses and all while keeping in close proximity to shopping, fine dining and entertainment.','1.2694','15','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Freestanding,Gas Connections,Gaslog Fireplace','1','Spring Northeast','Propane','1','WHITE OAK ESTATES 03, BLOCK 7, LOT 5','Subdivision Lot,Wooded','55295','Appraisal District','','625','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','11 - Conroe','HOUSER ELEMENTARY SCHOOL','OAK RIDGE HIGH SCHOOL','IRONS JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied','Appraisal','1','Traditional','White Oak Estates 03','6697','1.8487','Aerobic,Water District','1999','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215659589','1675217470','215659589','2023-01-22T08:06:31.970','35673664','Tommy Bowen','JLA Realty','','','30.592473','-94.944905','27','77335','7','298000.00','Active','US Highway 59','8536','','Goodrich','3','0','4','1650','Single-Family','NEWLY BUILT 4 bedroom, 3 bath home conveniently located with road front access to I-69. This home can also be commercial. Open concept design from kitchen to living area would be perfect for many business ventures. Designed to accommodate the handicapped, this home could be used to facilitate those in need of assisted living. Rooms are large and spacious, ranging from 10X9 up to 13X12. Also imagine your main or secondary office headquarters conveniently located between Houston and Livingston with direct access to I-69. A crossover is located directly in front of this property giving it the perfect location for accessing I-69 northbound. Residential or commercial use, this home is move in ready. Sidewalks surround the home on all sides. Buyer will be responsible for new survey. Call today and get your appointment scheduled.','0.37','44','Christian Obando','','','','No Disclosures','','','','Lake Livingston Area','Central Electric','0','ABST 77 AUGUSTIN VIESCA SURVEY TRACT 562-B','Cleared','16117','Appraisal District','','','1','Never Lived In','0','','0','','','','','Composition','138 - Goodrich','GOODRICH ELEMENTARY SCHOOL','GOODRICH HIGH SCHOOL','GOODRICH MIDDLE SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied','Seller','1','Traditional','N/A','117','1.7032','Public Water,Septic Tank','2022','Seller'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216221125','1675217471','216221125','2023-01-22T08:16:18.023','67655641','Andrea Curran','Compass RE Texas, LLC','','','30.048658','-95.595147','16','77375','3','235000.00','Active','Twisted Creek','19710','Drive','Tomball','2','0','3','1570','Single-Family','Adorable one story home in the Tomball community of Three Lakes. This home features 3 bedrooms, 2 bathrooms, and spacious family room. High ceilings and an open floor plan for entertaining. Large, energy efficient, windows for an abundance of natural light. Spacious backyard with room for a swing set or trampoline. Zoned to highly rated Klein ISD schools. Community amenities include a covered playground and swimming pool. Easy access to Hwy 249 and Grand Parkway 99, close proximity to dining and shopping!','0.1035','14','','','Washer Connections','','Mud,Sellers Disclosure','1','','','Spring/Klein/Tomball','Central Gas','1','LT 16 BLK 8 THREE LAKES EAST SEC 4','Subdivision Lot','4508','Appraisal District','','350','0','','2','Freestanding Oven','0','','','Freestanding Range','','Composition','32 - Klein','KOHRVILLE ELEMENTARY SCHOOL','KLEIN CAIN HIGH SCHOOL','ULRICH INTERMEDIATE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Three Lakes','5512','2.7066','Water District','2003','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216252290','1675217471','216252290','2023-01-22T08:09:21.740','59470434','Maria Franco','Texcom Realty, Inc.','Mygdalia Hernandez','Texcom Realty, Inc.','30.138085','-94.905831','16','77535','7','522852.00','Option Pending','Road 6615','108','','Dayton','2','1','4','2563','Single-Family','Welcome to this Gorgeous designed custom-built home on 3/4 of an acre. Home is UNDER CONSTRUCTION. The living room opens up to a spectacular island with 13 ft. ceilings, 14 ft. tray ceilings. Living room offers a fireplace with floating shelves and built in cabinets. 8ft. doors through out the whole house. Kitchen offers custom built cabinetry. Huge walk-in pantry with lots of cabinet space. Granite throughout kitchen. Good size laundry room with space for extra refrigerator. Master bedroom offers a huge shower with separate tub to soak in. Custom walk-in closet. Flex room for an in home office or the perfect 4th bedroom. Enjoy a true sense of community in a sought after part of Liberty County. Enjoy rural living at its finest!','0.689','52','Johann Custom Homes','','Washer Connections','','No Disclosures','1','Gas Connections','1','Dayton','Central Gas','1','ENCINO ESTATES, SEC 2, BLOCK 9, LOT 20, ACRES 0.6890','Cleared','30013','Appraisal District','','450','1','Never Lived In','2','Double Oven','0','','','Gas Cooktop','','Composition','74 - Dayton','STEPHEN F. AUSTIN ELEMENTARY SCHOOL (DAYTON)','DAYTON HIGH SCHOOL','WOODROW WILSON JUNIOR HIGH SCHOOL','Supra Keybox','Builder','1','Contemporary/Modern,Split Level,Traditional','Encino Estates','903','1.7512','Aerobic,Septic Tank','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216440389','1675217471','216440389','2023-01-22T08:34:28.900','29489297','Juan Salcedo','ASIN Realty','Emily Braud','Compass RE Texas, LLC','30.198090','-95.481115','27','77382','8','384900.00','Option Pending','Avonlea','159','Court','Spring','2','0','3','2087','Single-Family','Lovely home located in The Woodlands. This 1 story home offers 3 spacious bedrooms, 2 full baths, office/study room, open space for living, dining room and kitchen w/island. It also offers a beautiful fireplace. It\'s great location makes your life easier, it is near beautiful parks, shopping centers, restaurants and so much more!! This is a one time opportunity and won\'t last long!','','15','','','','','Mud,Sellers Disclosure','1','Gaslog Fireplace','1','The Woodlands','Central Gas','0','S971924 - WDLNDS VIL ALDEN BR 24, BLOCK 2, LOT 1','Corner,Subdivision Lot','8626','Appraisal District','','','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','11 - Conroe','DAVID ELEMENTARY SCHOOL','THE WOODLANDS COLLEGE PARK HIGH SCHOOL','KNOX JUNIOR HIGH SCHOOL','Appointment Required,Supra Keybox','Seller','1','Traditional','Wdlnds Village Alden Br','','','Water District','1996','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216456316','1675217471','216456316','2023-01-22T08:55:24.213','42520943','Anne Hettiger','Segue Real Estate Group','','','29.981362','-95.705551','35','77429','8','270000.00','Active','Arbormont','18418','Drive','Cypress','2','0','4','1804','Single-Family','Beautiful, 4/2 single story home in Cypress Mill subdivision. Close to 290, restaurants, shopping and 99. Features include spacious family room with cozy wood burning fireplace, large formal dining room for all your family get togethers. The spacious kitchen has built in microwave, tons of storage and large pantry. The master bedroom has double sink vanities with beautiful white countertops, separate tub & shower, and large walk in closet. Additional bedrooms are all perfect sizes for your guests. Spacious, fully fenced backyard will be the perfect hang out spot for entertaining. Home features brand NEW roof, fresh paint, new fixtures and new carpet throughout.','0.1543','35','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Wood Burning Fireplace','1','Cypress North','Central Gas','1','LT 10 BLK 2 CYPRESS MILL SEC 1','Subdivision Lot','6720','Appraisal District','','600','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','A ROBISON ELEMENTARY SCHOOL','CYPRESS WOODS HIGH SCHOOL','SPILLANE MIDDLE SCHOOL','Appointment Required','Appraisal District','1','Traditional','Cypress Mill','5891','2.761','Water District','1986','Appraisal District'); --> New record created successfully