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-05T17:55:49.627' ,`MLSNumber` = '39094430' ,`ListAgentFullName` = 'Wanda Simons' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.849910' ,`Longitude` = '-95.443620' ,`PhotoCount` = '10' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '152500.00' ,`Status` = 'Active' ,`StreetName` = 'Fisherman\'s Trail' ,`StreetNumber` = '93' ,`StreetSuffix` = '' ,`City` = 'Huntsville' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '864' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity to create a vacation rental or make it your own special getaway!  Beautiful wood paneling and floors make it a cozy cabin. Close to the Marina with access to the lake for fishing, boating, kayaking, and other water activities  This unique place includes Central A/C, energy-efficient windows and plenty of insulation.   There is also an enclosed boat shed along with a large, covered parking area that has water and electric connections perfect for parking an RV.' ,`Acres` = '0.39' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'HARMON CREEK RIDGE - SEC 1, LOT 909' ,`LotDesciption` = 'Cleared' ,`LotSize` = '17070' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'HUNTSVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harmon Creek Ridge' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675087693' WHERE `Matrix_Unique_ID` = '207444196'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T17:57:47.747' ,`MLSNumber` = '28183040' ,`ListAgentFullName` = 'Kuruvila Mathew' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635187' ,`Longitude` = '-95.134143' ,`PhotoCount` = '12' ,`PostalCode` = '77505' ,`RoomCount` = '16' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Barton Creek Drive' ,`StreetNumber` = '5107' ,`StreetSuffix` = '' ,`City` = 'Pasadena' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3499' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious 2 story home with detached 3-car garage located on an oversized cul-de-sac lot. House features 5 bedroom with 4 full baths with 2 bedrooms down with plenty of living space. It boasts high ceiling living room, huge master bedroom with tray ceiling, walk-in closets and oversized master bath, separate standup shower and garden tub. Second bedroom on the first floor could serve as a study/office. And it has an attached bath too, Jack and Jill. Upstairs has a huge Game room, Jack and Jill bathrooms. A Crystal 7-tier Chandler in the living room stays. Fully fenced back yard. New roof installed 03/2022, water heater, garbage disposal and one of the A/c units changed with in the last 2-3 years. Seller is installing new flooring/work in progress.' ,`Acres` = '' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 1 BAYWOOD OAKS VILLAGE SEC 4' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10231' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '16 - Deer Park' ,`SchoolElementary` = 'FAIRMONT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DEER PARK HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRMONT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Baywood Oaks Village Sec 04' ,`TaxAmount` = '8686' ,`TaxRate` = '2.6198' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1996' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087693' WHERE `Matrix_Unique_ID` = '211579103'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T18:48:24.307' ,`MLSNumber` = '54289863' ,`ListAgentFullName` = 'Janetta Penn' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.048115' ,`Longitude` = '-95.206283' ,`PhotoCount` = '46' ,`PostalCode` = '77339' ,`RoomCount` = '8' ,`ListPrice` = '559000.00' ,`Status` = 'Active' ,`StreetName` = 'Kings Forest' ,`StreetNumber` = '2810' ,`StreetSuffix` = 'Drive' ,`City` = 'Kingwood' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3136' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'KINGS FOREST Beauty! Located on wooded .7 acre lot in cds private Drive; this 5 Bdrm estate has been fully remodeled, including: water well, wood tile flooring, quartzite ctops, stainless steel appliances, recent lighting, fans, & interior (barely there gray); Primary suite is located downstairs, in addition to another bedroom down (could be study); Tons of white cabinetry and OS kitchen! Fireplace in the family room w/views of pool-sized backyard; List of upgrades online, 3 bedrooms up, close to restaurants, medical facilities, shopping, minutes away from Bush airport & Deerbrook mall!!' ,`Acres` = '0.7222' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 6B BLK 3 KINGS FOREST SEC 1' ,`LotDesciption` = 'Wooded' ,`LotSize` = '31459' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '695' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'BEAR BRANCH ELEMENTARY SCHOOL (HUMBLE)' ,`SchoolHigh` = 'KINGWOOD PARK HIGH SCHOOL' ,`SchoolMiddle` = 'KINGWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Forest Sec 01' ,`TaxAmount` = '10614' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087694' WHERE `Matrix_Unique_ID` = '213423853'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T17:27:10.167' ,`MLSNumber` = '75908424' ,`ListAgentFullName` = 'Lee DeForke Jr.' ,`ListOfficeName` = 'Lee DeForke Jr.' ,`SellingAgentFullName` = 'Justin Bell' ,`SellingOfficeName` = 'RE/MAX American Dream' ,`Latitude` = '29.406279' ,`Longitude` = '-95.274151' ,`PhotoCount` = '37' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '279900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Westfield' ,`StreetNumber` = '2603' ,`StreetSuffix` = 'Street' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully maintained one owner home on big corner lot. This home has a great feel and wonderful floor plan. Big front yard with Oak trees, backyard is fully fence with another big Oak. Walk in and feel the comfort with foyer and open living room with fireplace. Lots of windows to see out back and room for a pool. Kitchen has stove top island and lots of counter space. Dining room off kitchen with an additional breakfast area facing backyard and open to living area. All bedrooms on one side of the home with the master and master bath having double sinks, jetted tub and separate shower. Enjoy the large walk in closet too. There are two additional bedrooms and full bath as well as a bonus room that could be anything from craft, office, library, or even a small bedroom. You will love the feel of this home. Foundation was just completed 10/28/2022 Pending offer under contingency.' ,`Acres` = '0.2013' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'KINGS ROW (ALVIN) LOT 29 (E9\') - LOT 30 SEC 4' ,`LotDesciption` = 'Corner' ,`LotSize` = '8769' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'ALVIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'ALVIN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Row Alvin' ,`TaxAmount` = '4581' ,`TaxRate` = '2.8854' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1994' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087694' WHERE `Matrix_Unique_ID` = '214169683'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T18:27:01.523' ,`MLSNumber` = '66224017' ,`ListAgentFullName` = 'M C Thompson' ,`ListOfficeName` = 'McPherson Scott Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.681678' ,`Longitude` = '-95.718960' ,`PhotoCount` = '26' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '344777.00' ,`Status` = 'Active' ,`StreetName` = 'Carved Stone' ,`StreetNumber` = '8731' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3059' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Home!! with most of the Amenities your heart desires. Formal Living and Dining. Rather Spacious Kitchen, open to Breakfast area and Very large Family room, with Fireplace offering warmth and comfort.  N.B. 2 Primary Bedrooms, 1 upstairs the other is down. Upstairs Primary Br has its own sitting area. There is a HUGE Gameroom to love. ALL 4 Brs are very comfortably spacious. A Massive Backyard with paved Patio, providing for Space and comfort for all your parties and family events.  YOU are \'Gonna \'Love this one!!\r\n\r\n N.B. Water Softener system applies throughout the house.' ,`Acres` = '0.1674' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'BRADFORD PARK SEC 2, BLOCK 1, LOT 11' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7294' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Bradford Park Sec 2' ,`TaxAmount` = '6113' ,`TaxRate` = '2.3529' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087694' WHERE `Matrix_Unique_ID` = '214370885'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-05T17:47:17.650' ,`MLSNumber` = '85855092' ,`ListAgentFullName` = 'Sheritha Vaughns' ,`ListOfficeName` = 'Natalie Glass Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.125107' ,`Longitude` = '-95.391261' ,`PhotoCount` = '26' ,`PostalCode` = '77386' ,`RoomCount` = '4' ,`ListPrice` = '420000.00' ,`Status` = 'Active' ,`StreetName` = 'Legends Ridge' ,`StreetNumber` = '29806' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3030' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 29806 Legends Ridge! This beautiful 4 bedroom, 2 ½ bath, two story home is tucked away in the highly desired Gated Community of Canyon Gate at Legends Ranch! This home is perfectly located in between I-45, Hardy Toll, and Grand Parkway! Location provides immediate access to The Woodlands and 30 minutes to downtown Houston.  There are lots of dining and shopping options within minutes away! This beautiful home has lots of upgrades (Tile Wood, Granite Countertops, Crown Moulding, Covered Patio, and much, much, more!) and is perfect for entertaining, as well as just relaxing and enjoying the family! With over 3000 sq ft, this home is generous in space with an XXL Gameroom/Media Room!  This beauty is located on an extra-large street that leads to the community splash pad!  The waterfront view is an added bonus!  All measurements, square footage, and information deemed accurate, however, buyer to verify.' ,`Acres` = '0.1612' ,`Area` = '15' ,`BuilderName` = 'Gehan Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S328304 - CANYON GATE AT LEGENDS RANCH 04, BLOCK 3, LOT 24' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View' ,`LotSize` = '7020' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch 0' ,`TaxAmount` = '8294' ,`TaxRate` = '2.5587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675087694' WHERE `Matrix_Unique_ID` = '214758162'  --> Updated record success<br />