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-29T09:41:59.500' ,`MLSNumber` = '42694002' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.609085' ,`Longitude` = '-95.461924' ,`PhotoCount` = '29' ,`PostalCode` = '75839' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Caddo' ,`StreetNumber` = '72' ,`StreetSuffix` = 'Drive' ,`City` = 'Elkhart' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2132' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LAKE IONI HUNTING AND FISHING CLUB! If you’re looking for a great waterfront location, this one is a must see! With three waterfront lots totaling 1.58-acres, this property has tons of potential! The three bedroom, three bath, two-story home needs some TLC, but it has good bones and a new roof. The main floor has a large living and dining area that opens to the kitchen, a study or game room with storage closet, an enclosed sunroom overlooking the lake, as well as the primary bedroom with a private bath. For guests, there is an additional bathroom off the living area. Upstairs, there are two guest bedrooms a full bath. Outdoors, you will find a boat dock and pier in need of repair, as well as a storage building/shop. Give us a call today to schedule a private tour.' ,`Acres` = '1.58' ,`Area` = '75' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Elkhart Area' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE IONI LOT 72 (IMPROVEMENTS ONLY)' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '68824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '65 - Slocum' ,`SchoolElementary` = 'SLOCUM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SLOCUM HIGH SCHOOL' ,`SchoolMiddle` = 'SLOCUM HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Ioni' ,`TaxAmount` = '1475' ,`TaxRate` = '1.7418' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085309' WHERE `Matrix_Unique_ID` = '206610449'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T09:42:26.220' ,`MLSNumber` = '22423953' ,`ListAgentFullName` = 'Nancy Lawrence' ,`ListOfficeName` = 'Lawrence Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.280614' ,`Longitude` = '-95.573988' ,`PhotoCount` = '48' ,`PostalCode` = '75835' ,`RoomCount` = '5' ,`ListPrice` = '599000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 3045' ,`StreetNumber` = '909' ,`StreetSuffix` = '' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2518' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Expect to be impressed with this one-owner, four bedroom, two and one-half bath home in the Porter Springs community. Entering through the gorgeous front door, you’ll notice the formal dining and large living area. The living area has a pretty fireplace, lots of windows that bring the outside in, and you’ll appreciate the hand scrapped wood floors through the foyer, living, and dining rooms. The spacious island kitchen is a cook’s dream with custom cabinetry, granite countertops, and stainless appliances. Enjoy quaint meals in the breakfast nook that leads to the back patio. For your guests, there is half bath off the kitchen. The handy laundry has great storage space. The primary bedroom has a private bath with his and her vanities, jacuzzi tub, walk-in shower, and walk-in closet. Three guest bedrooms share a hall bath with a shower/tub combo. There is a home office/study as well. Outdoors, you’ll enjoy sitting on the front and back porches enjoying the country. Call today!' ,`Acres` = '1.899' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Z S THOMPSON AB 85 1.899 AC' ,`LotDesciption` = 'Other' ,`LotSize` = '82720' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '4786' ,`TaxRate` = '1.8725' ,`WaterSewer` = 'Aerobic,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085309' WHERE `Matrix_Unique_ID` = '206713820'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T09:35:46.297' ,`MLSNumber` = '67967832' ,`ListAgentFullName` = 'Douglas Erdy' ,`ListOfficeName` = 'Doug Erdy Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.883372' ,`Longitude` = '-95.210152' ,`PhotoCount` = '0' ,`PostalCode` = '77044' ,`RoomCount` = '6' ,`ListPrice` = '1590670.00' ,`Status` = 'Active' ,`StreetName` = 'Garrett' ,`StreetNumber` = '12315' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '1722' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Prime unrestriced \"hard corner\" with 2 single family homes located in site. 3.88 acres perfect for gas station-retail-RV park etc. New construction abundent in area' ,`Acres` = '3.89' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 15 & 16 IN LTS 32 & 33 BLK E LINCOLN PARK FARMS' ,`LotDesciption` = 'Corner,Wooded' ,`LotSize` = '169448' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '46 - Sheldon' ,`SchoolElementary` = 'GARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CE KING HIGH SCHOOL' ,`SchoolMiddle` = 'MICHAEL R. NULL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lincoln Park Farms' ,`TaxAmount` = '5706' ,`TaxRate` = '2.2893' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085309' WHERE `Matrix_Unique_ID` = '211397539'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:31:50.430' ,`MLSNumber` = '23038732' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.746801' ,`Longitude` = '-95.876978' ,`PhotoCount` = '46' ,`PostalCode` = '77494' ,`RoomCount` = '11' ,`ListPrice` = '329900.00' ,`Status` = 'Active' ,`StreetName` = 'Jarvis Bay' ,`StreetNumber` = '29410' ,`StreetSuffix` = 'Pass' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'ORIGINAL OWNER, TRUE PRIDE OF OWNERSHIP. Lovely and perfectly maintained home in desired community. This fabulous one story offers +/- 2094 Sqft with a wonderful and open concept. Step in the front door and you will be amazed how open and large the family space is. From the spacious and beautiful kitchen with rich granite and stainless appliances, tons of cabinets, plus a big island that looks out onto the open dining and family room. All the family space is done in large ceramic tile through all traffic areas. High ceilings and lots of windows make it all come together. Then step right out on to the huge concrete patio with paver stone finish, stretching across the entire back of the home. Back inside you find the primary en-suite tucked in the back corner of the home, with oversized shower, double sinks and dream size walk in closet. There are three other bedrooms, one of which could easily be used as a home office or play room. The secondary bath is upfront between two bedrooms.' ,`Acres` = '0.1446' ,`Area` = '30' ,`BuilderName` = 'Dr Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TAMARRON SEC 30, BLOCK 2, LOT 45' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '6301' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'TAMARRON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tamarron Sec 30' ,`TaxAmount` = '7699' ,`TaxRate` = '3.0648' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085310' WHERE `Matrix_Unique_ID` = '211925970'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:42:24.880' ,`MLSNumber` = '62158212' ,`ListAgentFullName` = 'Teresa Hill' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.749266' ,`Longitude` = '-95.050437' ,`PhotoCount` = '8' ,`PostalCode` = '77351' ,`RoomCount` = '2' ,`ListPrice` = '30000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedar' ,`StreetNumber` = '193' ,`StreetSuffix` = 'Ridge' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '0' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This listing is for the “Land Only”, Trailers will be removed from the property.  Currently occupied. All dimensions should be verified.' ,`Acres` = '0.3547' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'CEDAR RIDGE SECTION 1 LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cedar Ridge Sec 1' ,`TaxAmount` = '59' ,`TaxRate` = '1.9558' ,`WaterSewer` = 'Aerobic,Septic Tank' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675085310' WHERE `Matrix_Unique_ID` = '212027109'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:49:25.023' ,`MLSNumber` = '58451238' ,`ListAgentFullName` = 'Veronica Pena' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.185774' ,`Longitude` = '-95.096811' ,`PhotoCount` = '20' ,`PostalCode` = '77327' ,`RoomCount` = '3' ,`ListPrice` = '650000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Grove Rd' ,`StreetNumber` = '10100' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This corner lot is off of a main entrance to this fast growing community of Plum Grove and offers over 5 acres of land that has the potential to be a great place to build a home, a few homes, to have livestock or horses or for commercial use! This neighborhood has no restrictions. You’ll enjoy a pond stocked with catfish, perch and bass. There are also some fruit and pecan trees around the property as well! ' ,`Acres` = '' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = '000161 DAVID COLE, TRACT 32, ACRES 5.11' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'SOUTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = '' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'David Cole' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675085310' WHERE `Matrix_Unique_ID` = '212192554'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:58:01.260' ,`MLSNumber` = '52265840' ,`ListAgentFullName` = 'Cy Uchendu' ,`ListOfficeName` = 'Intercity, Realtors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.674375' ,`Longitude` = '-95.659743' ,`PhotoCount` = '49' ,`PostalCode` = '77498' ,`RoomCount` = '6' ,`ListPrice` = '500000.00' ,`Status` = 'Active' ,`StreetName` = 'WAUMSLEY WAY' ,`StreetNumber` = '15415' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3596' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 5/3/1 HOUSE,WITH MANY UPGRADES.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KINGSBRIDGE VILLAGE SEC 3, BLK3, LOT 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HOLLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'HODGES BEND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'KINGSBRIDGE VILLAGE' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085310' WHERE `Matrix_Unique_ID` = '212921218'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T09:05:31.337' ,`MLSNumber` = '68142538' ,`ListAgentFullName` = 'Jacki Hart' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.682576' ,`Longitude` = '-95.497414' ,`PhotoCount` = '18' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Ariel' ,`StreetNumber` = '5934' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2066' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful 4/2 in Braeburn Terrace neighborhood. Home has so much space including a formal living room and dining room as well a family room.  Home has NEVER FLOODED!!! New Plumbing and new Paint and an Elfa shelving system  in master closet make this home very desirable.  Home boosts a wonderful office space off the master bedroom as well as a bonus room off the family room which could be used a playroom / sunroom / or reading room.  Man cave / work space outside has ac and is an added bonus! This home has been in the same family since it was built! Make this home yours today!' ,`Acres` = '0.1607' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 36 BLK 15 BRAEBURN TERRACE SEC 2 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '10' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HEROD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Braeburn Terrace Sec 02 R/P' ,`TaxAmount` = '5093' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085311' WHERE `Matrix_Unique_ID` = '213457306'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:50:00.153' ,`MLSNumber` = '92876329' ,`ListAgentFullName` = 'Traye Wise' ,`ListOfficeName` = 'RE/MAX Signature' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.632590' ,`Longitude` = '-95.344662' ,`PhotoCount` = '27' ,`PostalCode` = '77048' ,`RoomCount` = '8' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Madden' ,`StreetNumber` = '5238' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1372' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful one story home completely remodeled.  Home features 4 bedrooms, 1.5 bath, Living/Family Room and Kitchen with Breakfast/Dining area.  Updates include NEW Soft Close Shaker Cabinets, Granite, Vinyl Plank Floors, Appliances, Lighting, Fixtures, Tile in Bathrooms, Paint, Roof and much more.  Updated Plumbing and Electrical.  Let this be the next place you call home.' ,`Acres` = '0.1591' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 34 CRESTMONT PARK SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CODWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'THOMAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Crestmont Park Sec 03' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085311' WHERE `Matrix_Unique_ID` = '214207950'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T09:09:54.593' ,`MLSNumber` = '29383972' ,`ListAgentFullName` = 'Melissa Wilson' ,`ListOfficeName` = 'MMW Realty Partners' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833100' ,`Longitude` = '-95.712674' ,`PhotoCount` = '23' ,`PostalCode` = '77449' ,`RoomCount` = '3' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Field Meadow' ,`StreetNumber` = '4222' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2240' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOVELY 3 BEDROOM, 2.5 BATHROOM HOME IN A QUIET NEIGHBORHOOD. THIS HOME FEATURES HIGH CEILINGS WITH PLENTY OF ROOM. COME RELAX IN THE LARGE LIVING ROOM AREA OR MAYBE EVEN THE DEN IN THE BACK WITH SMALL BAR AREA.' ,`Acres` = '0.1133' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 17 CYPRESS MEADOWS 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4935' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Cypress Meadows 03' ,`TaxAmount` = '5934' ,`TaxRate` = '2.796' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085311' WHERE `Matrix_Unique_ID` = '214307454'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T09:48:41.047' ,`MLSNumber` = '96436399' ,`ListAgentFullName` = 'Ashley Jackson' ,`ListOfficeName` = 'Martindale Real EstateInvestments' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.738392' ,`Longitude` = '-94.431012' ,`PhotoCount` = '23' ,`PostalCode` = '75979' ,`RoomCount` = '3' ,`ListPrice` = '194000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 1044' ,`StreetNumber` = '1215' ,`StreetSuffix` = '' ,`City` = 'Woodville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1540' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This fabulous 3 bedroom 1 bath brick home has been remodled and features a wonderful mother-in-law suite that is separate from the main home with it\'s own kitchenette and full bath as well. This home sits on 0.35+/-Acres just outside the city limits of Woodville, TX and is completely unrestricted!' ,`Acres` = '0.35' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S4775 MIMOSA SD (A487), LOT 7, ACRES .35' ,`LotDesciption` = 'Cleared' ,`LotSize` = '15246' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '253 - Woodville' ,`SchoolElementary` = 'WHEAT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WOODVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'WOODVILLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mimosa SD' ,`TaxAmount` = '1783' ,`TaxRate` = '1.9672' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675085311' WHERE `Matrix_Unique_ID` = '214405218'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:11:08.177' ,`MLSNumber` = '39047650' ,`ListAgentFullName` = 'Morgan Evans' ,`ListOfficeName` = 'RE/MAX Lake Livingston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.717569' ,`Longitude` = '-95.057533' ,`PhotoCount` = '13' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = 'Alta Vista' ,`StreetNumber` = '311' ,`StreetSuffix` = 'Drive' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1216' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Remodeled Home on two lots in Lake Livingston Village. This 3Bed/2Bath features new plumbing, paint and flooring.\r\nSubdivision amenities including, boat launch, fishing pier, putt putt golf, playground and swimming pool! \r\nCall today to schedule your showing.' ,`Acres` = '0.1745' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LAKE LIVINGSTON VILLAGE SECTION 7 LOT 8 & 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum,Other' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '142' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085311' WHERE `Matrix_Unique_ID` = '214567197'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-29T10:35:30.853' ,`MLSNumber` = '55991963' ,`ListAgentFullName` = 'Monica Hensarling' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.955686' ,`Longitude` = '-95.608088' ,`PhotoCount` = '27' ,`PostalCode` = '77429' ,`RoomCount` = '3' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Shadow Lake' ,`StreetNumber` = '12510' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2413' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Looking for the tranquility of the country charm, within close proximity of the city? Don\'t miss out on this beautiful, completely remodeled home in the heart of Cypress ON 3 ACRES. Situated close to 99 and 290, zoned CFISD and having no MUD taxes, what\'s not to love? Inside the home, you will find a beautifully updated kitchen with under cabinet lighting, double sinks and an island that can seat up to eight. A door from the kitchen will lead you out to the fenced back yard and to the pool/hot tub area. Great for entertaining! The primary suite has a luxurious bathroom with soaking tub, separate shower and vanities. Bathroom leads into a walk in closet with custom built shelves, cabinets, closet island and vanity. Fenced and cross fenced, this property is ready for any animals. Property has an attached 2 car garage, detached 2 car garage/workshop and metal barn, so there\'s plenty of room for all your toys and equipment. For additional extras, reach out today!' ,`Acres` = '3' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 74 & TR 73 CYPRESS CREEK ESTATES' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '130680' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground,Salt Water' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Creek Estates' ,`TaxAmount` = '10204' ,`TaxRate` = '2.1637' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675085312' WHERE `Matrix_Unique_ID` = '214952191'  --> 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','215153840','1675085312','215153840','2022-11-29T09:10:23.797','77100032','Justin Dickey','Keller Williams Professionals','','','29.832859','-95.855808','29','77493','10','415565.00','Active','Acapulco Mist','5335','Drive','Katy','3','0','4','2050','Single-Family','Colina Homes- Single Story: Elegant entry with coffered tall ceilings, 4 bedrooms, 3 baths location in our gated section of Sierra Vista! Spacious master closet with his/her sinks and sep. tub\r\nand shower. Tons of Beautiful Finishes included!!Gorgeous kitchen with stunning cabinets, granite\r\nand tiled backslash , Perfect backyard and a Large covered back patio ready for weekend BBQ\'s.\r\nYou\'re going to Love it! Situated in one of Katy\'s best communities. and offers everything your\r\nare looking in a family friendly community- amenities located in Sunterra, Crystal Lagoon coming soon!  PHOTOS ARE REPRESENTATIVE.','','25','Colina Homes','','Electric Dryer Connections','','No Disclosures','1','','','Katy - Old Towne','Central Gas','1','Lot 7 Block 2 Sec 40','Corner,Subdivision Lot','8123','Survey','','1300','1','To Be Built/Under Construction','3','','0','','','Freestanding Range,Gas Cooktop,Gas Range','','Composition','30 - Katy','ROBERTSON ELEMENTARY SCHOOL (KATY)','KATY HIGH SCHOOL','HASKETT JUNIOR HIGH SCHOOL','Accompany','Builder','1','Traditional','Sunterra','','3.5','Public Sewer,Public Water,Water District','2023','Builder');  --> New record created successfully<br />