Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)<br>Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)<br>Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)<br>Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)<br>Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)<br>Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)<br>Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)<br>Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)<br>Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)<br>Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)<br>Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)<br>Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)<br>Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)<br>Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)<br>Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)<br>Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)<br>Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)<br>Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)<br>Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)<br>Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)<br>Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)<br>Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)<br>Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)<br>Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)<br>Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)<br>Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)<br>Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)<br>Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)<br>Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)<br>Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)<br>Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)<br>Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)<br>Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)<br>Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)<br>Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)<br>Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)<br>Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)<br>Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)<br>Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)<br>Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)<br>Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)<br>Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)<br>Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)<br>Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)<br>Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)<br>Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)<br>Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)<br>Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)<br>Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)<br>Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)<br>Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)<br>Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)<br>Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)<br>Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)<br>Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)<br>Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)<br>Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)<br>Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)<br>Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)<br>Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)<br>Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)<br>Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)<br>Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)<br>Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)<br>Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)<br>Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)<br>Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T09:33:16.277' ,`MLSNumber` = '95748281' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.201357' ,`Longitude` = '-96.269368' ,`PhotoCount` = '18' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '89000.00' ,`Status` = 'Active' ,`StreetName` = 'Main' ,`StreetNumber` = '511' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1046' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This charming 2 bed home sits on a huge corner lot with room for great entertaining or even build another home, workshop.   This one is in a great location close to HEB, other shopping, dining and entertainment.   With a little TLC this would be a great home to make your own or great investment opportunity but the beautiful hardwood floors are under the carpet in all rooms, carpet has been opened up for you to see, plumbing all updated in 2021 and electrical was updated a few years ago per seller.   Call fast to schedule your private showing.' ,`Acres` = '0.1607' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating,Wall Heater' ,`HOAMandatory` = '0' ,`Legal` = 'LUNDY CENTRAL BLOCK 1 LOT 7' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lundy Central' ,`TaxAmount` = '1566' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1939' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094998' WHERE `Matrix_Unique_ID` = '204869296'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T09:27:06.583' ,`MLSNumber` = '53331471' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.002085' ,`Longitude` = '-95.797658' ,`PhotoCount` = '41' ,`PostalCode` = '77447' ,`RoomCount` = '4' ,`ListPrice` = '399900.00' ,`Status` = 'Active' ,`StreetName` = 'Adam Prairie' ,`StreetNumber` = '16319' ,`StreetSuffix` = 'Drive' ,`City` = 'Hockley' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2695' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This totally updated 3 bed 2 full bath home sits on a large corner lot, great open concept with high ceilings, formal entry, kitchen/dining/living combo.  Kitchen has a huge island with seating area for breakfast for visiting.   Sink/dishwasher on the island, nice gas drop in cooktop with double ovens and lots of cabinet space.  The huge living area is adorned with a gas log fireplace and so many windows on the back wall that let that natural lighting in.   Great split bedroom floorplan offers the owner ultimate privacy with the 2 guest bedrooms at the front of the home and the master suite at the back.   There is a nice flex room off the wide formal entry that can be your home office, library or even a 4th bedroom.  Master en-suite boasts a huge soaker tub, separate walk-in shower with glass doors, split his/hers vanities and huge walk-in closet that will amaze.  Great fenced in back and side yard for entertaining, relaxing and furry friends.   Sprinkler system keeps your lawn green.' ,`Acres` = '0.2035' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 35 BLK 1 STONE CREEK RANCH SEC 5' ,`LotDesciption` = 'Cleared,Corner,Subdivision Lot' ,`LotSize` = '8863' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '950' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'WALLER JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Stone Creek Ranch' ,`TaxAmount` = '9693' ,`TaxRate` = '3.1924' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094998' WHERE `Matrix_Unique_ID` = '212627516'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T09:05:08.810' ,`MLSNumber` = '37334050' ,`ListAgentFullName` = 'Tiffany Romero' ,`ListOfficeName` = '1st Class Real Estate Elevate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.811641' ,`Longitude` = '-94.838069' ,`PhotoCount` = '25' ,`PostalCode` = '77523' ,`RoomCount` = '7' ,`ListPrice` = '254500.00' ,`Status` = 'Active' ,`StreetName` = 'Rainbow' ,`StreetNumber` = '5514' ,`StreetSuffix` = 'Road' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1335' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Location! This beautiful home has 3 bedrooms, 2 bathrooms and family room. The kitchen overlooks family room has granite countertops gorgeous wood cabinets and a breakfast bar. The refrigerator and island can stay with the home Primary bedroom includes a large window overlooking the back yard, as well as a spacious bathroom and walk-in closet. A covered front entry, front yard landscaping and fenced backyard add to the curb appeal of this adorable, move-in ready home. The backyard has a beautiful custom made palapa with lights and fan. Schedule a tour today.' ,`Acres` = '0.131' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BK 3 JOSEPHS COVE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5706' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Josephs Cove Sec 3' ,`TaxAmount` = '3738' ,`TaxRate` = '1.7058' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094998' WHERE `Matrix_Unique_ID` = '213576616'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T09:25:15.967' ,`MLSNumber` = '7380199' ,`ListAgentFullName` = 'Lisa Perez' ,`ListOfficeName` = 'Country Pride Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.196300' ,`Longitude` = '-96.281490' ,`PhotoCount` = '41' ,`PostalCode` = '77437' ,`RoomCount` = '5' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'China' ,`StreetNumber` = '809' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2036' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This remarkable home features a huge kitchen with tons of cabinets, double ovens, drop in range, dishwasher, beautiful granite countertops and much more.   The oversized living room is also a big plus with gorgeous wood floors, built-in shelving and ample room for the largest furnishings.  Access the home with it\'s large formal entryway.   Master has it\'s own full bath with lots of storage space, beautiful granite countertops, ceramic tile floors, nicely tiled tub/shower combo.    Main home boasts 3 bedrooms and 2 full bath and there are 2 additional guest bedrooms behind the garage with a full bath as well.   Great covered patio area out back opens to the fully fenced backyard with plenty of shade for the sunny days.   All rooms are nice and big.  You can\'t help but to notice the great curb appeal and nice landscaping upon arrival.   Call fast to see this one!' ,`Acres` = '0.2486' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A20142 ABST.142 TRACT BLK 15, TRACT 21F' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10829' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'El Campo' ,`TaxAmount` = '6149' ,`TaxRate` = '2.3981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1986' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094999' WHERE `Matrix_Unique_ID` = '214566569'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T10:19:52.450' ,`MLSNumber` = '37169539' ,`ListAgentFullName` = 'Marcia Livingston' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.688387' ,`Longitude` = '-95.467252' ,`PhotoCount` = '30' ,`PostalCode` = '77096' ,`RoomCount` = '9' ,`ListPrice` = '405000.00' ,`Status` = 'Active' ,`StreetName` = 'Carew' ,`StreetNumber` = '5034' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1417' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, well-crafted and remodeled home is ready for move-in: Insulated windows replaced throughout, remodeled bathrooms and kitchen including cabinets, granite counters and stainless appliance. Espresso cabinetry and tile flooring. Modern interior and exterior doors. Situated 2 blocks to Bellaire High and a short walk to Lovett Elementary. Convenient to the Medical Center, Galleria, Downtown and Reliant. It is also in walking distance to the restaurants and abundant shopping at Meyerland Center, including Starbucks, HEB grocery & BBVA bank. Large partially covered patio. Oversized corner lot for future investment.' ,`Acres` = '0.2342' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Meyerland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 10 MEYERLAND SEC 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '10200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Meyerland Sec 01' ,`TaxAmount` = '7567' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094999' WHERE `Matrix_Unique_ID` = '214696283'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-24T09:53:07.583' ,`MLSNumber` = '49055330' ,`ListAgentFullName` = 'Debra Brock' ,`ListOfficeName` = 'Vacasa Real Estate LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '27.637829' ,`Longitude` = '-97.291864' ,`PhotoCount` = '38' ,`PostalCode` = '78418' ,`RoomCount` = '13' ,`ListPrice` = '525000.00' ,`Status` = 'Active' ,`StreetName` = 'Debra' ,`StreetNumber` = '2745' ,`StreetSuffix` = 'Lane' ,`City` = 'Corpus Christi' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1843' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment opportunity or move right in! Catch the Coastal Country vibe in this fully remodeled home sitting on 2.23 acres. Water views of the bay along Laguna Shores and distant view of JFK bridge from the second level balcony.  Neighboring Redhead Pond is a wildlife viewing site along the Great Texas Coastal Birding Trail and protected wildlife refuge. Total remodel with long list of new and updated features.  Make this your home or next investment property!' ,`Acres` = '2.2282' ,`Area` = '85' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Home Protection Plan,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'WESTS LAGUNA MADRE PL UNIDV INT IN OF LT 5R BK A' ,`LotDesciption` = 'Cleared,Corner,Water View' ,`LotSize` = '97060' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '516 - Flour Bluff' ,`SchoolElementary` = 'FLOUR BLUFF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FLOUR BLUFF HIGH SCHOOL' ,`SchoolMiddle` = 'FLOUR BLUFF JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access,Leave Business Card,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Ranch' ,`Subdivision` = 'Wests Laguna Madre Place' ,`TaxAmount` = '4428' ,`TaxRate` = '2.3879' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094999' WHERE `Matrix_Unique_ID` = '215050351'  --> 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','215801631','1675094999','215801631','2022-12-24T10:31:54.273','40500385','Etha Eglin','Keller Williams Metropolitan','','','30.151554','-94.141141','27','77708','9','299990.00','Active','Riplee Street','6735','Street','Beaumont','2','0','4','2042','Single-Family','The Kingston elevation O is a one-story home featuring 4 bedrooms, 2 baths, and 2 car garage beautifully crafted new construction home by D.R. Horton.. The entry opens to the guest bedrooms, bath with linen closet. Center kitchen includes oversized breakfast bar with beautiful counter tops and stainless-steel appliances. Open concept floorplan boasts large, combined family room and dining area. The primary suite features a sloped ceiling and attractive primary bath with dual vanities, water closet and walk-in closet. The standard rear covered patio is located off the family room. Beaumont\'s trendy hidden neighborhood, Spring Wood is tucked away on RFD Road just off FM 105 and Major Drive. Schedule your tour today!','','51','D.R. Horton','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Other Disclosures','1','','','','Central Gas','1','Lot 14 Block 3 Sec 2 Springwood','Corner,Subdivision Lot','7200','Survey','','300','1','To Be Built/Under Construction','','Gas Oven','0','','','Gas Range','','Composition','143 - Beaumont','HOMER DRIVE ELEMENTARY SCHOOL','BEAUMONT UNITED HIGH SCHOOL','KING MIDDLE SCHOOL (BEAUMONT)','Accompany,Appointment Required,Vacant/Unoccupied','Builder','1','Traditional','Springwood','','2.645','Public Sewer,Public Water','2023','Builder');  --> New record created successfully<br />