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-08T09:09:03.597' ,`MLSNumber` = '68837063' ,`ListAgentFullName` = 'Kelli Owens' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.746431' ,`Longitude` = '-95.092581' ,`PhotoCount` = '21' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Yellowstone' ,`StreetNumber` = '161' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1316' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 3 bedroom, 2 bath home is sitting on almost half an acre in one of the most highly sought-after neighborhoods of Lake Livingston. The home is currently an Airbnb, so if you are wanting a home to live in or to start your Airbnb business, this is the place for you.  Furniture can be negotiated with the sale of the home. The kitchen and living room have an open layout and include a nice wood burning fireplace. The interior and exterior are recently painted. Other features include updated kitchen and bathroom counters; and double sinks in the master bath. New tile flooring throughout, and the property has never flooded! This house is ready for you to call home!  This is an active Airbnb, please request a tour,  if there is no guest the tour will be approved.  If there are guests, we will need to schedule the showing after they check out of the property. OWNER CARRYBACK ONLY.' ,`Acres` = '0.4591' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'INDIAN HILL ESTATES SECTION 1 BLK 4 LOT 36 & 37' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Indian Hill Estates Sec 1' ,`TaxAmount` = '2228' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088695' WHERE `Matrix_Unique_ID` = '209963718'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T09:24:55.467' ,`MLSNumber` = '34384073' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Julie Husband' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '29.806614' ,`Longitude` = '-94.893404' ,`PhotoCount` = '13' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '329293.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Santa Ana' ,`StreetNumber` = '2103' ,`StreetSuffix` = 'Way' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1851' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** This gorgeous Beazer Home on a corner lot in Southwinds is what you’re looking for, boasting sloped ceilings, wood-look tile flooring, an open great room, and an extended covered patio. Spend quality time in the kitchen, equipped with quartz countertops, mosaic backsplash, stainless steel appliances, and 42” upper cabinets. Unwind I the tranquil primary suite features a walk-in closet, dual vanities, a tub, and a separate shower. With direct access to the Grand Parkway and I-10, commuters from Southwinds love the easy drive to Downtown Houston and other major business areas. A variety of popular restaurants, shops, and beaches are only a short distance away. Community comforts include a pool, recreation center, playground, and picnic area. Zoned to the Goose Creek CISD. This could be your dream home – call now!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 4' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwinds' ,`TaxAmount` = '' ,`TaxRate` = '2.86069' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675088695' WHERE `Matrix_Unique_ID` = '210560225'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T09:15:20.780' ,`MLSNumber` = '83808784' ,`ListAgentFullName` = 'Ayesha Khan' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.671664' ,`Longitude` = '-95.652430' ,`PhotoCount` = '21' ,`PostalCode` = '77498' ,`RoomCount` = '9' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Weldridge drive' ,`StreetNumber` = '9646' ,`StreetSuffix` = 'Drive' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2334' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1862' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSBRIDGE PLACE SEC 2, BLOCK 1, LOT 12' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '8112' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '560' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kingsbridge Place Sec 2' ,`TaxAmount` = '4839' ,`TaxRate` = '2.3389' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2001' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088695' WHERE `Matrix_Unique_ID` = '211638777'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T09:45:06.630' ,`MLSNumber` = '95291525' ,`ListAgentFullName` = 'Rachael Pieprzyca' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.213194' ,`Longitude` = '-96.281416' ,`PhotoCount` = '13' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '159900.00' ,`Status` = 'Active' ,`StreetName` = 'Sabla' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy updated starter house. Move in Ready with new carpet in living room and bedrooms. New flooring in Utility room.  Hard wood floors in kitchen. Come see this property located on a 1/2 acre lot in El Campo.  Large mature trees. Close to shopping and restaurants.  Detached carport with extra storage.  Washer and dryer, refrigerator, stove, and new microwave all convey with property. Fresh exterior paint, new ceiling fans and fixtures.  AC is only 2 years old.' ,`Acres` = '0.5235' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SABLATURA LOT 9C' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '22804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sablatura' ,`TaxAmount` = '2695' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088696' WHERE `Matrix_Unique_ID` = '211964849'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-08T09:53:56.843' ,`MLSNumber` = '19181637' ,`ListAgentFullName` = 'Justin Hilton' ,`ListOfficeName` = 'Southwest Realty Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.049581' ,`Longitude` = '-95.635295' ,`PhotoCount` = '42' ,`PostalCode` = '77422' ,`RoomCount` = '0' ,`ListPrice` = '695000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 747a' ,`StreetNumber` = '4765' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3253' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unbelievable San Bernard River home in Riverwood Estates! Like no other, this unique and stunning home was built for entertaining. Extremely rare riverfront property! Open concept is an understatement. The layout provides an expansive feel w/ its high ceilings & large great room. The perfect place to create unforgettable memories w/ family gatherings and parties. Step out back and soak up the Texas sun on over 1200 sq/ft of furnished patio and decking, then take a dip in the pool overlooking the river & watch the wake surfers/skiers. This home offers amazing river views w/ large full view doors facing the pool & river. Completely renovated in ‘17 w/custom cabinetry & granite counters throughout, Italian tile flooring with handmade Texas stars inlayed, custom tiled walk in showers, interior paint, shutters, & KitchenAid appliances. Three car garage. ONE ACRE LOT W/ 30’x40’ SHOP INCLUDED! See update list attached in docs. CONVEYS COMPLETELY FURNISHED!' ,`Acres` = '0.567' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric,Heat Pump,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0056 JAMES CUMMINGS TRACT 36C (CALLED R-11) (RIVERWOOD EST' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '24699' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'James Cummings' ,`TaxAmount` = '6847' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675088696' WHERE `Matrix_Unique_ID` = '214019557'  --> 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','214889066','1675088696','214889066','2022-12-08T10:18:54.977','37302656','Travis Stahl','Nobles Realty Group, LLC','','','30.560042','-96.291482','34','77845','5','299995.00','Active','Leyla','2514','Lane','College Station','2','1','3','1565','Single-Family','Cute 3 bed 2 bath home. Contains an open floor plan with raised ceilings throughout living, kitchen, and dining areas along with granite countertops. Walk in pantry and an eating bar. In the hallway with a office nook there are doors to 2 bedrooms that are connected with a Jack and Jill bathroom. In the primary bedroom there is a full bathroom that contains a soaking bathtub with a separate walk in shower and a large walk in closet. The main selling point of this house is the backyard which has had some major work done to it to add some large in ground garden beds which surround a beautiful and unique stone fire pit surrounded with a potential seating area. This home also contains solar panels which has lowered the cost of utilities. This home is also very close to College station high school and only a short distance to the towerpoint area consisting of shopping, grocery stores, restaurants & medical facilities. Easy access to both Hwy 6 and Wellborn Rd.','0.1345','61','','','','','Sellers Disclosure','1','','','','Central Gas,Solar Assisted','1','EDELWEISS RIDGE, BLOCK 3, LOT 5','Subdivision Lot','5859','Appraisal District','','140','0','','2','','0','','','','','Composition','153 - College Station','CREEK VIEW ELEMENTARY SCHOOL','COLLEGE STATION HIGH SCHOOL','COLLEGE STATION MIDDLE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox','Appraisal District','1','Traditional','Edelweiss Ridge','5423','2.1321','Public Sewer,Public Water','2011','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','215090025','1675088696','215090025','2022-12-08T10:45:41.467','37490783','Willdavis Uche','Texas United Realty','','','29.913142','-95.671266','32','77095','10','321999.00','Active','Curry Landing','9530','Drive','Houston','2','1','4','2252','Single-Family','Welcome to this charming 2 story home with 4 bedroom 2.5 baths and a game room upstairs and a beautiful backyard. Zoned to an excellent Cy-Fair ISD and minutes away from major highway, shopping and dining.','0.136','8','DR HORTON','','Electric Dryer Connections,Gas Dryer Connections','','Sellers Disclosure','1','','1','Copperfield Area','Central Gas','1','LT 66 BLK 2 CANYON LAKES AT STONEGATE SEC 11','Other','5922','Appraisal District','','950','0','','2','Freestanding Oven','0','','','Gas Cooktop,Gas Range','','Composition','13 - Cypress-Fairbanks','BIRKES ELEMENTARY SCHOOL','CYPRESS RANCH HIGH SCHOOL','ARAGON MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied','Appraisal District','2','Contemporary/Modern','Canyon Lks/Stonegate Sec 11','6963','2.561','Water District','2005','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','215240964','1675088696','215240964','2022-12-08T09:08:59.010','77347636','Lance Loken','Long Lake LTD','','','30.298185','-95.407313','12','77301','14','475000.00','Active','Mesquite Pod','3017','Trail','Conroe','3','1','4','3000','Single-Family','This home is under construction. Enjoy the many comforts of this Briarwood Home in Barton Creek Ranch. This 4-sided brick home boasts a premium elevation, tile flooring, full gutters, a front porch, wrought iron spindles, a cast stone fireplace, a study with French doors, a mud set walk-in shower in the spacious primary suite, and a covered patio. Cook up new cuisines in the island kitchen, equipped with granite countertops, tile backsplash, double oven, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Located off Hwy 105, and I-45, the home is only minutes away from The Woodlands Mall, Market Street, and the Cynthia Woods Mitchell Pavilion. Schools are a part of the highly-acclaimed Conroe ISD. Don’t wait – call today for more information!','','19','Briarwood Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Conroe Southeast','Central Gas','1','Lot 11 Block 3','Subdivision Lot','','','','650','1','To Be Built/Under Construction','2','Freestanding Oven,Gas Oven,Single Oven','0','','','Gas Range','','Composition','11 - Conroe','RUNYAN ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Barton Creek Ranch','','2.8479','Water District','2022','Builder');  --> 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','215241584','1675088696','215241584','2022-12-08T09:08:22.430','21054683','Lance Loken','Long Lake LTD','','','30.293380','-95.410845','8','77301','18','514990.00','Active','Hawthorn Stream','1917','Way','Conroe','4','1','5','4038','Single-Family','This home is under construction. Fall in love with this incredible Briarwood Home in Barton Creek Ranch. Resting on a spacious lot, this 4-sided brick home boasts a premium elevation, no back neighbors, tile flooring, entry crown molding, wrought iron spindles, faux wood blinds, a natural stone fireplace, a game room and theater, a study with French doors, and a covered patio. Try a new recipe in the island kitchen, equipped with granite countertops, a double oven, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. The serene primary suite features a drop-in tub and a separate shower. Located off Hwy 105, and I-45, the home is only minutes away from The Woodlands Mall, Market Street, and the Cynthia Woods Mitchell Pavilion. Schools are a part of the highly-acclaimed Conroe ISD. Don’t wait – call today for more information!','','19','Briarwood Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud','1','Gaslog Fireplace','1','Conroe Southeast','Central Gas','1','Lot 4 Block 3','Subdivision Lot','','','','650','1','Never Lived In','2','Double Oven','0','','','Gas Range','','Composition','11 - Conroe','RUNYAN ELEMENTARY SCHOOL','CONROE HIGH SCHOOL','STOCKTON JUNIOR HIGH SCHOOL','Appointment Required','Builder','2','Traditional','Barton Creek Ranch','','2.8479','Public Sewer,Public Water','2022','Builder');  --> 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','215420690','1675088696','215420690','2022-12-08T09:27:18.780','52965843','Crystal Olenbush','AustinRealEstate.com','','','30.247628','-97.786053','32','78704','7','4700000.00','Active','Oak Park','2905','Drive','Austin','4','2','5','4473','Single-Family','Truly unique Modern Tutor Design is under construction in the highly sought-after Barton Hills neighborhood. This 5-bedroom home includes a spacious ground-floor primary suite with Cathedral Ceilings and with exposed structure\r\nprimary bath with double basin, shower room, and freestanding tub. Cathedral ceilings with exposed structure, custom windows, a double-sided fireplace, a spacious living room, and expansive sliding doors for indoor and outdoor entertaining with a private pool and hot tub will wow any guests upon arrival. All guest bedrooms on the lower level with their own living area is a perfect setup for a family with teens. Off of the two-car garage, there is a large mud room and laundry room.','0.2768','83','Urban ATX','','','','No Disclosures','','','1','','Central Electric','0','LOT 3 BLK D BARTON HILLS SEC 1','Subdivision Lot','12057','Other','','','1','To Be Built/Under Construction','2','','1','In Ground','','','','Aluminum','111 - Austin','BARTON HILLS ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (AUSTIN)','O. HENRY MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Barton Hills Sec 01','23628','2.1767','Public Sewer,Public Water','2021','Builder');  --> 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','215420767','1675088696','215420767','2022-12-08T09:22:36.990','51997593','Crystal Olenbush','AustinRealEstate.com','','','30.252837','-97.779811','26','78704','7','7000000.00','Active','Fortune','2306','Drive','Austin','6','1','6','5716','Single-Family','Deluxe master suite AND en suite guest on the first floor.\r\nThe second-floor en suite guest plus Jack and Jill bedrooms that share a bath, JnJ bedroom at the rear has a large deck overlooking the pool;6th bedroom with bathroom is on the third floor with a balcony and amazing view.\r\nChefs kitchen with large island and additional bar sink, huge walk-in pantry\r\nLaundry and drop zone at upper garage entrance close to the kitchen\r\nMorning room with marble tiled gas fireplace, custom bookcases, overlooking the pool\r\nGathering room with coffered ceiling, large gas fireplace, and wall of windows that open completely to screened porch. The half bath is a pool bath on the back of the house 40-foot lap pool\r\nThe fully finished lower level includes a garage, billiards room, game room, bar, entertainment area, exercise room, full bath, and additional laundry room.','0.2083','83','Urban ATX','','','','No Disclosures','','','2','','Central Gas','0','LOT 6 BLK B FORTUNE ESTATES SEC 3','Subdivision Lot','9074','Other','','','1','To Be Built/Under Construction','','','1','In Ground','','','','Aluminum','111 - Austin','BARTON HILLS ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (AUSTIN)','O. HENRY MIDDLE SCHOOL','Appointment Required','Builder','3','Contemporary/Modern','Fortune Estates Sec 03','41504','2.1767','Public Sewer,Public Water','2020','Builder');  --> 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','215438111','1675088696','215438111','2022-12-08T10:09:09.277','93666814','Crystal Olenbush','AustinRealEstate.com','','','30.249447','-97.786350','22','78704','4','4135200.00','Active','Cedarview','2901','Drive','Austin','3','1','4','3447','Single-Family','Must see this modern gem in the highly desirable Barton Springs Home. \r\n303 SF Pool\r\n81 SF Spa\r\n2 Story\r\nUnique Structural Design\r\nFloating Stairs\r\nHigh Ceilings\r\nCustom Windows\r\nDouble Height Living Room with Fireplace\r\nPrivate Interior Courtyard\r\nSecond Floor Roof Deck with Bar Top for Entertaining with views of Downtown\r\nLarge Patio Doors for Indoor-Outdoor Entertaining\r\nMud / Utility Connected to Garage\r\nLuxury Master Suite with Private Patio\r\nSpacious Master Bath with Single Basin, Shower Room, Freestanding Tub, and a Private Outdoor Shower\r\nWalk In Closet with Built-In Shelves\r\nHigh-End Finishes','0.2157','83','Urban ATX','','','','No Disclosures','','','1','','Central Electric,Central Gas','0','LOT 7 BLK O BARTON HILLS SEC 2','Subdivision Lot','9310','Other','','','1','To Be Built/Under Construction','2','','1','In Ground','','','','Aluminum','111 - Austin','BARTON HILLS ELEMENTARY SCHOOL','AUSTIN HIGH SCHOOL (AUSTIN)','O. HENRY MIDDLE SCHOOL','Appointment Required','Builder','2','Contemporary/Modern','Barton Hills Sec 02','20678','2.1767','Public Sewer,Public Water','2021','Builder');  --> New record created successfully<br />