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-15T12:21:29.657' ,`MLSNumber` = '59405473' ,`ListAgentFullName` = 'Albert Grothe' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.137134' ,`Longitude` = '-95.442060' ,`PhotoCount` = '17' ,`PostalCode` = '77386' ,`RoomCount` = '5' ,`ListPrice` = '374000.00' ,`Status` = 'Active' ,`StreetName` = 'Maplewood' ,`StreetNumber` = '25803' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful custom built single story home in Oak Ridge North subdivision. On a large corner lot with a beautiful patio and pool in the large backyard. Home has never flooded and has plenty of space inside and out.  Low taxes and no HOA!' ,`Acres` = '0.4449' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'OAK RIDGE NORTH 02, LOT 185' ,`LotDesciption` = 'Corner' ,`LotSize` = '19382' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge North' ,`TaxAmount` = '4655' ,`TaxRate` = '2.0087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091365' WHERE `Matrix_Unique_ID` = '213801191'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T11:07:55.013' ,`MLSNumber` = '11166908' ,`ListAgentFullName` = 'Goran Mandich' ,`ListOfficeName` = 'Texas Signature Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.333676' ,`Longitude` = '-96.652329' ,`PhotoCount` = '28' ,`PostalCode` = '77879' ,`RoomCount` = '5' ,`ListPrice` = '164900.00' ,`Status` = 'Active' ,`StreetName` = 'Boysenberry' ,`StreetNumber` = '551' ,`StreetSuffix` = '' ,`City` = 'Somerville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1042' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW, NEW , NEW just move  in and enjoy.  \r\n\r\nBrand new 2022 never lived in 3 bedroom 2 full baths 16x 68 manufactured home located on .49 acre of wooded land in the Enchanted Oaks Subdivision. No restrictions and can be used for commercial. Wooded buffer around property. Perfect for a homestead, business, weekend getaway, or vacation home. New electric utilities, public water, and aerobic septic system. Comes with new refrigerator, dryer, dishwasher, central heat and air conditioning. Just minutes away from Lake Somerville Birch Creek State Park. Ready to move in and enjoy good country living!' ,`Acres` = '0.4929' ,`Area` = '59' ,`BuilderName` = 'CAVCO' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S2507 ENCHANTED OAKS PARK LOT 214 0.4929 ACRES' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '21469' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '158 - Somerville' ,`SchoolElementary` = 'SOMERVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SOMERVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'SOMERVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enchanted Oaks Park' ,`TaxAmount` = '169' ,`TaxRate` = '1.7844' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1675091365' WHERE `Matrix_Unique_ID` = '213804728'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T11:17:46.533' ,`MLSNumber` = '82791165' ,`ListAgentFullName` = 'Dana Bellanger' ,`ListOfficeName` = '2011 AMERICAN REAL ESTATE CO.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.244314' ,`Longitude` = '-94.198143' ,`PhotoCount` = '49' ,`PostalCode` = '77657' ,`RoomCount` = '12' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'Nonie' ,`StreetNumber` = '17830' ,`StreetSuffix` = 'Lane' ,`City` = 'Lumberton' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3813' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Sprawling 4/2.5 Estate Nestled on 3/4 of an Acre in Acclaimed Lumberton ISD!! This massive home has room for any family with two large living areas, two kitchens, a three-car garage, and updated bedrooms. Throughout the home you will find little surprises, like a large L-shaped room above the garage with its own mini-split, separate power room complete with vanity & desk off of the master bedroom, &office or nursery space off of a secondary bedroom. There is even a walk-in hallway that gives you access to all of the entertainment equipment neatly hidden out of sight. The large kitchen features a breakfast bar, extra desk/breakfast bar space, a gas cooktop, exterior water filtration system, & a new dishwasher. Serene outdoors spaces are sure to wow your guests with plenty of covered spaces, outdoor fan, pergola, and two fenced areas! There is also high-powered pool equipment with an iron-fenced in paved area - perfect for anyone wanting to put in a pool!' ,`Acres` = '0.7806' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas,Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LOTS 67A & 68A COUNTRY LANE EST AB 14 E DUNCAN P# CL13-68-A' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '34003' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Country Lane Estates' ,`TaxAmount` = '7111' ,`TaxRate` = '1.8866' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091365' WHERE `Matrix_Unique_ID` = '214086631'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T11:35:15.213' ,`MLSNumber` = '6611062' ,`ListAgentFullName` = 'Frank Johnston' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906107' ,`Longitude` = '-96.677366' ,`PhotoCount` = '22' ,`PostalCode` = '78940' ,`RoomCount` = '2' ,`ListPrice` = '794000.00' ,`Status` = 'Active' ,`StreetName` = 'Bell' ,`StreetNumber` = '101' ,`StreetSuffix` = 'Street' ,`City` = 'Fayetteville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1890' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Historic Home 1913 restored and remodeled to provide comfort, while retaining original charm and character of the period. Approaching the home one is struck by the appealing architectural style. The 14’ tall ceilings in Formals gives you a feeling of spaciousness. Hardwood floors throughout visually stretch your living area. Wide, deep front porch adds to your useable space, as does rear porch with seating. All new water lines, plumbing fixtures, & hot water heater. New electrical wiring, plugs & fixtures. New kitchen cabinets, countertop & new included appliances. Resurfaced antique sink reminds you of being back in grandma’s home. Imagine the enjoyment of spending time here with family and friends. One room cottage at rear of property could serve as studio, office, etc. Iconic “Root Cellar” in yard adds nostalgic. Oversize lot features mature trees, gardens & fire pit. A weekend at this peaceful enclave will lift your spirits and refresh you like a vacation. Discover this one now!' ,`Acres` = '0.482' ,`Area` = '69' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'CITY OF FAYETTEVILLE (390) BLK E 0.482 HSE, GAR, STGS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20996' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '204 - Fayetteville' ,`SchoolElementary` = 'FAYETTEVILLE HIGH SCHOOL' ,`SchoolHigh` = 'FAYETTEVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'FAYETTEVILLE HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'City Of Fayetteville 390' ,`TaxAmount` = '5263' ,`TaxRate` = '1.9294' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1915' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091366' WHERE `Matrix_Unique_ID` = '214489523'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-15T12:49:12.693' ,`MLSNumber` = '90431613' ,`ListAgentFullName` = 'Priscilla Pompey' ,`ListOfficeName` = 'PHP & Associates, Inc.' ,`SellingAgentFullName` = 'Jackie Carter' ,`SellingOfficeName` = 'CB&A, Realtors- Loop Central' ,`Latitude` = '29.618589' ,`Longitude` = '-95.406079' ,`PhotoCount` = '6' ,`PostalCode` = '77047' ,`RoomCount` = '4' ,`ListPrice` = '245000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Royal Bell' ,`StreetNumber` = '13106' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1935' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 story home located on a cul-de-sac  lot with 3 bedrooms 2 full baths plus 1/2 bath down stairs and a game room upstairs.  House needs minor upgrade.  Kitchen has sile stone countertops and entire house is equipped with faux wooden blinds.' ,`Acres` = '0.1229' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Five Corners' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 79 BLK 2 REGAL OAKS SEC 5' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '5353' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '380' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ALMEDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'LAWSON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Regal Oaks Sec 05' ,`TaxAmount` = '5800' ,`TaxRate` = '2.9007' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675091366' WHERE `Matrix_Unique_ID` = '214920757'  --> 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','215045123','1675091366','215045123','2022-12-15T11:32:10.983','91481427','Paul Crandall','Keller Williams Premier RealtyKaty','','','29.918770','-95.564743','47','77064','14','385000.00','Active','Tallowbend','10202','Court','Houston','2','1','4','3173','Single-Family','Welcome home to this ideally located two story home in Willow Pointe Subdivision in the Cy Fair ISD.\r\nPerfect location for any buyer: corner, cul-de-sac as well as seconds away from the beltway. You can be\r\nat any part of the northwest part of town in minutes. Home is 4 bedroom/2 ½ bath and has formal\r\ndining and living room upon entry. Family area opens up to the kitchen area and has plenty of space.\r\nPrimary bed is down with full bathroom offering dual sinks, whirlpool tub, separate shower and walk in\r\ncloset. Three additional bedrooms upstairs with additional full bath as well as MASSIVE game room area\r\nthat is multiuse. Incredible backyard space with covered patio: a fantastic way to start the morning\r\noff or to end the day after work. Don’t miss out on this perfect location with ideal amount of space.','0.257','10','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Exclusions,Mud,Sellers Disclosure','1','Gaslog Fireplace','1','Jersey Village','Central Gas','1','LT 35 BLK 2 WILLOW POINTE SEC 7','Corner,Cul-De-Sac,Subdivision Lot','11195','Appraisal District','','575','0','','2','Freestanding Oven,Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','13 - Cypress-Fairbanks','WILLBERN ELEMENTARY SCHOOL','CYPRESS RIDGE HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','2','Traditional','WILLOW POINTE','7788','2.641','Water District','1999','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215580500','1675091366','215580500','2022-12-15T11:17:20.153','94590104','Nicole Freer','NICOLE FREER GROUP','','','29.402233','-95.059567','7','77568','8','369062.00','Active','Sweet Bay','2206','Drive','Texas City','3','0','4','1875','Single-Family','ASHTON WOODS NEW CONSTRUCTION - Welcome home to 2206 Sweet Bay Drive, a Milan Premium Collection, in the community of Lago Mar and zoned to Dickinson ISD. The Prism floorplan features 4 bedrooms, 3 full baths, an attached 2 car garage and over 1,800 square feet of living space. Don\'t forget to step out back for a view of the backyard. You don\'t want to miss all this gorgeous home has to offer! Estimated completion is April 2023. Call to schedule your showing today! Days on market reflect the number of days the home has been under construction.','','33','Ashton Woods','','Electric Dryer Connections','','Mud,Other Disclosures','1','','','Texas City','Central Gas','1','Lago Mar Section 5, Lot 1, Block 3','Subdivision Lot','5400','Survey','','1330','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','17 - Dickinson','LOBIT ELEMENTARY SCHOOL','DICKINSON HIGH SCHOOL','LOBIT MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Builder','1','Traditional','Lago Mar','','3.55','Water District','2022','Builder');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215604991','1675091366','215604991','2022-12-15T12:52:18.860','78545437','Justin Guyer','RE/MAX Professionals','','','28.730519','-96.417699','50','77465','3','325000.00','Active','Bayview','1978','Drive','Palacios','2','0','3','1020','Single-Family','Spectacular waterview home in the gated community of Cape Carancahua. Offered as fully furnished, you can relax and enjoy the ambiance of the 530 acre coastal community from your covered patio with gorgeous views of Carancahua Bay. Inside you\'ll find the home is fully updated and loaded with custom finishes, designer colors, coastal furniture and stainless steel appliances. The kitchen provides ample space for the inspired cook and is adorned with custom cabinets, tile backsplash, and show-stopping American Maple butcher block counter tops finished in warm Walnut stain and triple sealed. Both bathrooms are accessible and feature coordinating tile floors & shower surrounds with beautiful glass doors. The exterior of the home has hardi siding, double pane windows, covered patio, bull rock drainage and expansive yard. Community amenities include: Boat Ramp, Lighted Fishing Piers, Playground, Nature Parks, Community Center, Tennis Courts, 2 Pools, Outdoor Pavilion and relaxed atmosphere.','0.37','67','','','Electric Dryer Connections,Washer Connections','','Sellers Disclosure','1','','','','Central Electric','1','CAPE CARANCAHUA #1, LOT 168, ACRES 0.18','Subdivision Lot,Water View','16117','Appraisal District','','400','0','','0','Electric Oven,Freestanding Oven,Single Oven','0','','','Electric Range,Freestanding Range','','Composition','156 - Palacios','CENTRAL ELEMENTARY SCHOOL (PALACIOS)','PALACIOS HIGH SCHOOL','PALACIOS JUNIOR HIGH SCHOOL','Appointment Required,Controlled Access,Vacant/Unoccupied','Seller','2','Traditional','Cape Carancahua','1721','1.8978','Aerobic,Public Water','1982','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215635049','1675091366','215635049','2022-12-15T12:15:32.537','10996630','Orian Caldwell','Coldwell Banker Realty','','','29.664627','-95.478086','29','77096','3','475000.00','Active','Oasis','10702','Drive','Houston','3','0','3','1882','Single-Family','Fully remodeled home in 2022… this house was taken down to the studs and everything was replaced and approved by the City of Houston.\r\nfoundation was repaired\r\n- new under slab plumbing sewer lines \r\n- new pex fresh water supply lines  \r\n- new Electrical wiring and panel \r\n- new windows \r\n- new floors \r\n- new air ducts and furnace \r\n- new insulation \r\n- custom kitchen with quartz countertops \r\n- 3 showers with quartz countertops and glass\r\nDoors \r\n- new doors , trims , paint \r\n- -high ceilings in living area \r\n- new Cosmo appliances\r\n- new roof\r\nAnd an extended covered 700 square foot patio along with a 300 square foot air conditioned  electric shed included in the backyard.','0.2204','20','','','','','Sellers Disclosure','1','','','Brays Oaks','Central Gas','0','LT 9 BLK 39 WESTBURY SEC 2','Corner,Subdivision Lot','9600','Appraisal District','','','0','','0','','0','','','','','Composition','27 - Houston','PARKER ELEMENTARY SCHOOL (HOUSTON)','WESTBURY HIGH SCHOOL','MEYERLAND MIDDLE SCHOOL','Appointment Required','Seller','1','Ranch','Westbury Sec 02','6925','2.3307','Public Sewer,Public Water','1960','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215639418','1675091366','215639418','2022-12-15T12:30:37.000','64828910','Hannah Vaughan','RE/MAX ONE - Premier','','','29.956800','-95.087008','23','77532','3','160000.00','Active','Meeker','307','Street','Crosby','2','0','3','1216','Single-Family','Home Sweet Home!  This 3 bedroom 2 bath mobile home has been well taken care of and it\'s on a great sized piece of land.  It\'s your own private paradise.  Almost a whole acre with no back neighbors.  Schedule your showing today on this open floorplan.  Updated showers in the primary and secondary bathrooms give this home a great modern look.','0.87','1','','','','','Sellers Disclosure','','','','Crosby Area','Central Electric','0','LT 5 TALL CEDARS SEC 2 U/R','Cul-De-Sac','37897','Appraisal District','','','0','','0','','0','','','','','Composition','12 - Crosby','NEWPORT ELEMENTARY SCHOOL','CROSBY HIGH SCHOOL','CROSBY MIDDLE SCHOOL (CROSBY)','Appointment Required','Appraisal District','1','Other Style','Tall Cedars Sec 02 U/R','784','2.0943','Septic Tank,Well','2003','Appraisal District');  --> New record created successfully<br />INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215639697','1675091366','215639697','2022-12-15T12:37:02.557','54564478','David Jones','Evans and Associates','','','30.683625','-95.006720','29','77351','2','59900.00','Active','Pritchard','657','Road','Livingston','1','1','1','882','Single-Family','2 BEDROOM MOBILE HOME ON 2 LOTS LOCATED NEAR LAKE LIVINGSTON. WASH ROOM JUST OFF THE BACK PORCH. OUT BUILDING, CARPORT. LOCATED AT THE BACK OF THE SUBDIVISION NOT MUCH TRAFFIC.','0.34','44','','','','','Sellers Disclosure','','','','Lake Livingston Area','Space Heater','1','PUTNAMS LANDING SECTION 1 LOT 539 THRU 542 SERIAL# 11711465S','Subdivision Lot','15000','Appraisal District','','15','0','','0','','0','','','','','Aluminum','103 - Livingston','LISD OPEN ENROLL','LIVINGSTON HIGH SCHOOL','LIVINGSTON JUNIOR HIGH SCHOOL','Appointment Required,Lockbox Front','Appraisal District','1','Traditional','Putnams Landing Sec 1','347','1.8745','Public Water,Septic Tank','1973','Appraisal District');  --> New record created successfully<br />