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-19T06:46:19.990' ,`MLSNumber` = '82307687' ,`ListAgentFullName` = 'Kathy Carlisle' ,`ListOfficeName` = 'RCR Properties Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.058019' ,`Longitude` = '-95.445386' ,`PhotoCount` = '32' ,`PostalCode` = '77566' ,`RoomCount` = '12' ,`ListPrice` = '355000.00' ,`Status` = 'Active' ,`StreetName` = 'Arrowwood' ,`StreetNumber` = '129' ,`StreetSuffix` = 'Street' ,`City` = 'Lake Jackson' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3068' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to beautiful 129 Arrowwood in Lake Jackson!-best of both- country living, but minutes away shopping, restaurants. Walk in the formal dinning /study and a oversize family room with a gas/log fire place. With a breakfast nook and a nice size kitchen with plenty of cabinets . This kitchen has so much charm  with painted knobs on a few of the knobs and the walk in  pantry with a glass door to see what\'s waiting for you .Huge primary bedroom and a  En -suite bath with a touch of vintage style. Walk upstairs and find a oversize game room to make memories  for all the entertaining you can do. Three bedrooms upstairs and extra room in the closets. This Tanglewood  neighborhood is tucked away with all the mature trees and runs along Oyster Creek. Splash in your pool at the end of the day! Want last long and quickly make your appt. New windows all through out this entire  beautiful home.' ,`Acres` = '0.3927' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Home Protection Plan,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD SEC 4 (LAKE JACKSON), BLOCK 10, LOT 15' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '17106' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Lake Jackson' ,`TaxAmount` = '7618' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1981' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040701' WHERE `Matrix_Unique_ID` = '211422224'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T05:02:16.347' ,`MLSNumber` = '28557464' ,`ListAgentFullName` = 'Brian Covault' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.771136' ,`Longitude` = '-95.757403' ,`PhotoCount` = '21' ,`PostalCode` = '77450' ,`RoomCount` = '4' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Cimarron' ,`StreetNumber` = '22215' ,`StreetSuffix` = 'Parkway' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1758' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Price Reduced! Welcome home to this beautifully updated 4 Bedroom house in the sought after area of Cimarron. The remodeled kitchen boasts luxurious quartz counter tops with subway tile and new cabinets. Both bathrooms have been remodeled with custom tile work and brand-new vanities. Fresh paint throughout the house on the walls, ceilings, and trim. Enjoy new tile floors in the foyer, kitchen, and bathrooms, premium laminate flooring in the living areas as well as the primary bedroom plus new carpet in the secondary bedrooms. The laundry room is inside, along with ample storage space. Relax on your covered patio and enjoy outdoor activities in your oversized backyard. HVAC is only 4 years old and roof covering only 7 years old, plus vinyl siding for low maintenance and double pane windows too. Zoned to highly acclaimed Katy ISD and close to tons of dining and shopping. Schedule your showing today!' ,`Acres` = '0.2169' ,`Area` = '36' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Southeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 4 BLK 3 CIMARRON SEC 1 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '460' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'CINCO RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'WEST MEMORIAL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cimarron Sec 01 R/P' ,`TaxAmount` = '4381' ,`TaxRate` = '2.3283' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040702' WHERE `Matrix_Unique_ID` = '213595361'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T05:29:18.170' ,`MLSNumber` = '58042706' ,`ListAgentFullName` = 'Tania James' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.045326' ,`Longitude` = '-95.517205' ,`PhotoCount` = '30' ,`PostalCode` = '77379' ,`RoomCount` = '5' ,`ListPrice` = '499999.00' ,`Status` = 'Active' ,`StreetName` = 'St Marcella' ,`StreetNumber` = '6407' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4900' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this one of a kind, 6-bedroom, 3.5 full bathroom home in the heart of Klein, Texas! . The open concept home makes a great space for entertaining guests. Primary bedroom downstairs. Additional perks include quiet, friendly neighborhood, easement with easy access to the park, Front lake view, game room and media room upstairs. Schedule your showing as soon as possible, this home will sell fast!' ,`Acres` = '0.1584' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 4 CHANCEL' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '986' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'KUEHNLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KRIMMEL INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Chancel' ,`TaxAmount` = '9659' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040702' WHERE `Matrix_Unique_ID` = '213739588'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T05:58:24.070' ,`MLSNumber` = '55102630' ,`ListAgentFullName` = 'Melissa Shechter' ,`ListOfficeName` = 'Ironwood Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.037419' ,`Longitude` = '-95.472179' ,`PhotoCount` = '24' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '299980.00' ,`Status` = 'Active' ,`StreetName` = 'Shipman' ,`StreetNumber` = '3807' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable 4/2.5/2 car detached home nestled in the popular Cypresswood Subdivision. High vaulted ceiling in living space. Floor to ceiling brick fireplace makes a nice warm focal point in living room. Wet bar. Nice granite in kitchen with stone tile backsplash and breakfast bar. Spacious breakfast space. Large laundry room in home on first floor. Primary bedroom with 2 closets large granite vanity. New patio doors that open to new patio deck to enjoy your coffee. Upstairs starts with open loft game room. 3 bedrooms on second floor with large closets, new blinds, and new carpet and paint. Upstairs full bathroom with new paint and granite countertops. New exterior and interior paint throughout. All new siding. New pex plumbing throughout. New AC condenser. New carpet in all the bedrooms, new laminate in living and dining room. Nice covered back patio. Mature trees and fresh new landscaping.' ,`Acres` = '0.1848' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 24 BLK 22 CYPRESSWOOD SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '535' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'HAUDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood' ,`TaxAmount` = '4631' ,`TaxRate` = '2.4645' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040702' WHERE `Matrix_Unique_ID` = '213868645'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T05:44:49.743' ,`MLSNumber` = '88333410' ,`ListAgentFullName` = 'Britton Vincent' ,`ListOfficeName` = 'Legend Texas Properties' ,`SellingAgentFullName` = 'Julia Iavitsa' ,`SellingOfficeName` = 'Elux Real Estate' ,`Latitude` = '29.741408' ,`Longitude` = '-95.642845' ,`PhotoCount` = '24' ,`PostalCode` = '77077' ,`RoomCount` = '12' ,`ListPrice` = '274980.00' ,`Status` = 'Option Pending' ,`StreetName` = 'Briarview' ,`StreetNumber` = '2114' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2206' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BIG FAMILY?  This 2-story brick colonial just may be the one!  4 bedroom, 2.1 bath, 2 car detached garage; outdoor balcony; Solid construction, large backyard, great schools with easy access to I-10 and Energy Corridor. Move-in ready.  Selling As-Is;  Awaiting your personal touch.  Schedule a showing today!' ,`Acres` = '0.216' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 9 BRIAR VILLAGE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '9410' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '569' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Colonial' ,`Subdivision` = 'Briar Village' ,`TaxAmount` = '4520' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040702' WHERE `Matrix_Unique_ID` = '214652816'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T06:32:38.483' ,`MLSNumber` = '60725819' ,`ListAgentFullName` = 'M. Carmen Fujimoto' ,`ListOfficeName` = 'Maddie Lowe Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.382172' ,`Longitude` = '-96.620702' ,`PhotoCount` = '35' ,`PostalCode` = '77836' ,`RoomCount` = '4' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 412' ,`StreetNumber` = '2278' ,`StreetSuffix` = '' ,`City` = 'Caldwell' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Barndominium sits on 1 Acre fenced surround!  As you drive in you\'ll notice the circle driveway in front of the home! The interior space has open concept Floor Plan of 2000 Sq ft!  Kitchen has walk-in pantry, custom cabinets with beautiful Granite counters and Island kitchen open to the Dining Area and Family Room. The attached Workshop with 1000 sq ft of space has two Roll-up doors on each side and a 1/2 bath recently installed.' ,`Acres` = '1' ,`Area` = '59' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Reports Available,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0064 AUSTIN, S.F., ACRES 1' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'N/A' ,`TaxAmount` = '4525' ,`TaxRate` = '1.78' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1669040703' WHERE `Matrix_Unique_ID` = '214653971'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-19T06:38:01.397' ,`MLSNumber` = '97858340' ,`ListAgentFullName` = 'Doris Santos' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.848882' ,`Longitude` = '-95.744683' ,`PhotoCount` = '27' ,`PostalCode` = '77449' ,`RoomCount` = '9' ,`ListPrice` = '289000.00' ,`Status` = 'Active' ,`StreetName` = 'Dove Hill' ,`StreetNumber` = '5119' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1515' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL ALMOST NEW D. R. HORTON BUILT 1 STORY! Desirable Open Concept Interior Layout! Split Plan Design Affords Maximum Privacy! Impressive Foyer Leads to Gourmet Island Kitchen with Corner Pantry, Stainless steel Appliances, includes Refrigerator PLUS Spacious Dining area & Large Living Area! Great Primary Suite - Adjoining Bath with Huge Walk-In Closet + Oversized Shower! Large Secondary Bedrooms - Both with Walk-In Closets! Indoor Utility Room with Direct Access from Garage! washer and Dryer included. Ring bell with visible camera on cell phone. Covered Patio Enhances Backyard Setting! Zoned in Katy schools!. MUST SEE!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 2 JASMINE HEIGHTS SEC 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '320' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'GOLBOW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'MCDONALD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jasmine Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1669040703' WHERE `Matrix_Unique_ID` = '214758964'  --> 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','214911725','1669040703','214911725','2022-11-19T06:47:26.550','57785901','Diane Lominac','Century 21 Realty Partners','','','30.095266','-95.339594','50','77386','14','1195000.00','Active','Ossineke','5016','Court','Spring','4','0','5','4143','Single-Family','5/4/3 w pool & spa on a 1 acre, cul de sac homesite in sought-after acreage community. Enter the 2-story foyer to appreciate the finishes & attention to detail. Work from home in the executive study. Kitchen w island, dbl ovens, & a hammered copper sink are a few things to delight the family chef. Wine bar connects to the formal dining area. Owner\'s suite w access to the covered patio and a spa-like bath w dual vanities plus jet tub & sep shower. The walk-in closet is not to be missed! 2nd bdrm down w prvt bath & access to the backyard. 3 bdrms & 2 baths up along w a pool table-sized gameroom & dedicated theater rm. Walk-in attic. Endless hours of fun or tranquil relaxation in the fenced yard w pool & spa, plus a cozy firepit. The car enthusiast or anyone needing extra space will appreciate the ovrszd 3 car garage, including a climate-controlled 3rd bay. Whole home generator. If you crave the quiet of the country but need the convenience of the city–this is it! Low taxes. No flooding.','1.0014','40','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Other Disclosures,Sellers Disclosure','1','Gas Connections,Gaslog Fireplace','1','Spring Northeast','Central Gas,Zoned','1','S257204 - BENDERS LANDING ESTATES 04, BLOCK 8, LOT 11','Cul-De-Sac,Subdivision Lot,Wooded','43622','Appraisal District','','1250','0','','3','Double Oven,Electric Oven','1','Gunite,Heated,In Ground','','Gas Cooktop','','Composition','11 - Conroe','ANN K. SNYDER ELEMENTARY SCHOOL','GRAND OAKS HIGH SCHOOL','YORK JUNIOR HIGH SCHOOL','Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox','Appraisal District','2','Traditional','Benders Landing Estates','12983','1.8487','Aerobic,Other Water/Sewer','2012','Appraisal District');  --> New record created successfully<br />