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-09-01T06:01:48.523' ,`MLSNumber` = '13735507' ,`ListAgentFullName` = 'Anderson Tolosa' ,`ListOfficeName` = 'Keller Williams Premier RealtyKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.848851' ,`Longitude` = '-95.176278' ,`PhotoCount` = '26' ,`PostalCode` = '77360' ,`RoomCount` = '4' ,`ListPrice` = '640000.00' ,`Status` = 'Active' ,`StreetName` = 'York Rd' ,`StreetNumber` = '318' ,`StreetSuffix` = '' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2091' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Why go on vacay when you can stay on this precious BARDOMINIUM? This is the PLACE!! Beautiful Country home nestled on 10 \"NO RESTRICTED\" ACRES .  FULL PACKAGE DEAL!!!   Cozy home with huge bedrooms, nice size Living Room, and a magnificent relaxing PORCH. Do You Need land? We got you covered with 10 FENCED acres of land; roads are suitable for ATVS, GATORS, or TRACTORS. Equipped with a HUGE GARAGE which can be used either to store your cars, land or water toys; This garage comes with wonderful GUEST ROOM with a private full bath, kitchen bar, half bath. LAKE LIVINGSTON just 5 minutes away, bring your jet sky, fishing boat and start making memories. GAS LINE AVAILABLE.     DON\'T WAIT MORE AND MAKE THIS BEAUTIFUL PARADISE YOURS!!!' ,`Acres` = '10' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Trinity Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COUNTY LINE LOT 6' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'County Line' ,`TaxAmount` = '2674' ,`TaxRate` = '1.7215' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705477' WHERE `Matrix_Unique_ID` = '210049525'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T06:17:14.517' ,`MLSNumber` = '50335265' ,`ListAgentFullName` = 'Jahcorrian Burkes' ,`ListOfficeName` = 'Connect Realty' ,`SellingAgentFullName` = 'Sade Farmer' ,`SellingOfficeName` = 'Coldwell Banker Realty' ,`Latitude` = '30.039441' ,`Longitude` = '-95.441160' ,`PhotoCount` = '29' ,`PostalCode` = '77388' ,`RoomCount` = '9' ,`ListPrice` = '420000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lost Mine' ,`StreetNumber` = '19118' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3641' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, location, location! Welcome home to this 4 bed, 3.5 bath home in the sought after gated community of Cypress Forest Lakes. Built in 2013, this open concept home features stunning first floor owner suite with room for sitting area and large primary bath features jetted tub, tiled shower with a bench, and walk in closet. Chef’s kitchen boasts oversized island with granite counter tops, 42” cabinets, ss appliances, double oven and new gas cooktop. Two living areas on first floor, ample seating options at the island and adjacent dining room. New extended back patio and outdoor television offers the perfect living space to entertain indoors and out. Three additional bedrooms, 19x19” game room and 2 full baths upstairs. Community features include walking paths, lakes, swimming pool, clubhouse, fitness and tennis courts. Klein ISD. Quick close possible! Seller willing to contribute towards closing.' ,`Acres` = '0.1424' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring/Klein' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 3 CYPRESS FOREST LAKES SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '6201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '840' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'LEMM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN COLLINS HIGH SCHOOL' ,`SchoolMiddle` = 'STRACK INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypress Forest Lakes Sec 01' ,`TaxAmount` = '9230' ,`TaxRate` = '2.484' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705477' WHERE `Matrix_Unique_ID` = '210610174'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T07:36:09.867' ,`MLSNumber` = '98754868' ,`ListAgentFullName` = 'Leann Acuna' ,`ListOfficeName` = 'San Antonio Portfolio KW RE' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.246349' ,`Longitude` = '-95.565249' ,`PhotoCount` = '45' ,`PostalCode` = '77354' ,`RoomCount` = '6' ,`ListPrice` = '710500.00' ,`Status` = 'Active' ,`StreetName` = 'Sendera Ranch' ,`StreetNumber` = '1911' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2416' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning home located on an oversized lot in the sought after Montgomery Trace!! Beautiful 3 bedroom home with charm and style. Open floor plan and crown molding in stunning entry way that leads into a formal dining area with mid-wall molding and an abundance of natural light. Cozy living room with stone fireplace and custom built in shelving. A true chef\'s kitchen with Silestone countertops, gas cooking, double ovens, and breakfast bar. Adjoining secondary dining space is the perfect spot for entertaining. Spacious master bedroom with jetted tub, tiled shower, and double vanities in en suite bathroom. Picturesque screened porch is the perfect area to enjoy your over 1.5 acre backyard oasis. Large 30 X 50 ft shop just within walking distance off the back porch complete with radiant barrier, multiple roll-up doors, T-5 lighting and 120V/240V electrical service throughout. Large 10 X 16 shed, next to the shop, for additional storage. Don\'t miss out on this one of a kind property today!!' ,`Acres` = '1.563' ,`Area` = '15' ,`BuilderName` = 'UNKNOWN' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'MONTGOMERY TRACE 03, BLOCK 3, LOT 3' ,`LotDesciption` = 'Greenbelt,Wooded' ,`LotSize` = '68084' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'LONE STAR ELEMENTARY SCHOOL (MONTGOMERY)' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Montgomery Trace 03' ,`TaxAmount` = '6926' ,`TaxRate` = '1.8237' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1997' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663705477' WHERE `Matrix_Unique_ID` = '210995559'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T06:37:53.067' ,`MLSNumber` = '25317522' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.395200' ,`Longitude` = '-95.482530' ,`PhotoCount` = '23' ,`PostalCode` = '77378' ,`RoomCount` = '6' ,`ListPrice` = '319990.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Cavern' ,`StreetNumber` = '255' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2442' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Corner Lot** Welcome home to the Granville plan with its warm and spacious open floorplan featuring the Owners Suite on the 1st floor!  The Granville is our model home and we only have 2 left.  The Granville comes with 4 bedrooms 2.5 bathrooms with a study.   9\' ceilings on main floor, Granite kitchen counters, 42\" kitchen cabinets and a gas stove. Luxury vinyl plank flooring, dual sinks in primary bath w/ extended shower. This home is very energy efficient and has CAT 6 Internet wiring and Smart Home Options.. Cozy community with a grand entrance. The neighborhood is nestled in mature trees. Located right off I-45 North of the Woodlands/Conroe. Call today to for a personal tour.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Centex Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '1' ,`Legal` = '15402' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'A.R. TURNER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Pines at Seven Coves' ,`TaxAmount` = '' ,`TaxRate` = '3.18' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663705477' WHERE `Matrix_Unique_ID` = '211370958'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-01T07:13:04.940' ,`MLSNumber` = '96876107' ,`ListAgentFullName` = 'Anthony Hines' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.945140' ,`Longitude` = '-95.362762' ,`PhotoCount` = '21' ,`PostalCode` = '77541' ,`RoomCount` = '3' ,`ListPrice` = '129000.00' ,`Status` = 'Active' ,`StreetName` = '12th' ,`StreetNumber` = '1027' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This very nice 3 bedroom 1 bath is ready for its next owner. The home has been equipped with new floors and paint through out and some updates to the kitchen and other areas. The Home sits on a very spacious corner lot with a front drive way giving quick and easy access to the front door. Enjoy extra storage space with a shed in the back yard that can be converted into a workshop or whatever the new home owner can imagine. Don\'t wait and see for yourself and schedule a showing.' ,`Acres` = '0.1469' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SOUTH VIEW GARDENS (FREEPORT) BLK 9 LOT 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'South View Gardens Freeport' ,`TaxAmount` = '2410' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663705478' WHERE `Matrix_Unique_ID` = '211802994'  --> 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','211942261','1663705478','211942261','2022-09-01T06:50:58.960','14141820','Meagan Bordelon','Bernstein Realty, Inc.','','','29.762687','-95.540331','29','77024','11','940000.00','Active','Stoney Creek','266','Drive','Houston','2','1','4','2463','Single-Family','Four Bedroom, 2 Bath, well-loved, Vintage Charmer located in Bunker Hill Village in the Whispering Oaks Subdivision. Wonderful floorplan with the potential to make your own. Large bathrooms and closets make for a wonderful footprint. Bright sunroom attached to the back. Wooded lot in backyard overlooks tranquil Stoney Creek. Walking distance to Memorial Forest Pool and Frostwood Elementary. Zoned to exemplary Memorial Middle School and Memorial High School. Per Seller there has been no history of flooding. Schedule an appointment to see this one-of-a-kind home today.','0.2571','23','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gas Connections','1','Memorial Villages','Central Gas','1','Lot 3 Block 3 Whispering Oaks','Subdivision Lot,Wooded','11200','Appraisal District','','100','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','49 - Spring Branch','FROSTWOOD ELEMENTARY SCHOOL','MEMORIAL HIGH SCHOOL (SPRING BRANCH)','MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)','Appointment Required,Supra Keybox','Appraisal District','1','Ranch','Whispering Oaks','15760','2.1865','Public Sewer,Public Water','1960','Appraisal District');  --> New record created successfully<br />