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-23T15:49:28.473' ,`MLSNumber` = '30742959' ,`ListAgentFullName` = 'Abraham Lozano' ,`ListOfficeName` = 'The Monarch Team, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776447' ,`Longitude` = '-95.333235' ,`PhotoCount` = '43' ,`PostalCode` = '77020' ,`RoomCount` = '3' ,`ListPrice` = '524999.00' ,`Status` = 'Active' ,`StreetName` = 'Capron' ,`StreetNumber` = '1617' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2555' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to Capron Street! This new construction home has a multitude of features designed with you in mind. When you first enter your new home, you\'ll enjoy first floor living with a welcoming open concept; entry foyer; formal dining room with a bar wall then a spacious living room that meets the gorgeous kitchen. Custom built kitchen cabinets and sleek quartz counters. The breakfast room leads right out to the fenced yard. On the second floor your three spacious bedrooms and two bathroom (one en-suite master). This home provides a great opportunity to buy in a rapidly developing neighborhood - plus you\'re within minutes of entertainment spots, downtown, i-10 and many upcoming restaurants & bars opening each month! Estimated completion date 10/5/22' ,`Acres` = '0.101' ,`Area` = '2' ,`BuilderName` = 'STARP Home Builder' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 9 & 10A BLK 1 CHAPMANS SEC 3' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ATHERTON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'FLEMING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Chapmans Sec 03' ,`TaxAmount` = '1134' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094716' WHERE `Matrix_Unique_ID` = '210784861'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-23T15:31:42.213' ,`MLSNumber` = '28243243' ,`ListAgentFullName` = 'Aurelio Valdez' ,`ListOfficeName` = 'RE/MAX Prestige' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.794380' ,`Longitude` = '-95.791412' ,`PhotoCount` = '37' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '390000.00' ,`Status` = 'Active' ,`StreetName` = 'Blane' ,`StreetNumber` = '24523' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2725' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice property in the subdivision of Lakecrest.' ,`Acres` = '0.1599' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 4 LAKECREST SEC 7' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6966' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KING ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MORTON RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakecrest Sec 07' ,`TaxAmount` = '6636' ,`TaxRate` = '2.5733' ,`WaterSewer` = 'Public Water,Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094716' WHERE `Matrix_Unique_ID` = '213693455'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-23T16:46:11.563' ,`MLSNumber` = '21624032' ,`ListAgentFullName` = 'Stacey Ajaja' ,`ListOfficeName` = 'Wolex Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885857' ,`Longitude` = '-95.719024' ,`PhotoCount` = '36' ,`PostalCode` = '77433' ,`RoomCount` = '6' ,`ListPrice` = '261000.00' ,`Status` = 'Active' ,`StreetName` = 'Bering Landing' ,`StreetNumber` = '7402' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Pristine 3 bedroom home on a big corner lot, this home is move in ready and updated with fresh paint, updated bathrooms, AC unit 2021 with air sterilization system for clean air, water softener system, large kitchen with new stove, microwave, garage door replaced 2021, no carpet throughout home, home fully wired with cameras included with Vivint system for your peace of mind.  Home has never flooded.  Don\'t miss out on this one!!' ,`Acres` = '0.1501' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 66 BLK 2 OAK LANDING SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '6539' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '470' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'DURYEA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Lndg Sec 01' ,`TaxAmount` = '4728' ,`TaxRate` = '2.69' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094716' WHERE `Matrix_Unique_ID` = '213821268'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-23T15:09:41.400' ,`MLSNumber` = '42205904' ,`ListAgentFullName` = 'Melissa Morales' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.530690' ,`Longitude` = '-95.411279' ,`PhotoCount` = '47' ,`PostalCode` = '77578' ,`RoomCount` = '14' ,`ListPrice` = '629000.00' ,`Status` = 'Active' ,`StreetName` = 'Plum Creek' ,`StreetNumber` = '2207' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3008' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOAN ASSUMPTION AVAILABLE 3.625%  FRIDGE, WASHER/DRYER, GARAGE FREEZER & GARAGE WORK BENCH INCLUDED WITH ACCEPTABLE OFFER. Beautiful like-new single-story home in Pomona! Gorgeous wide-plank engineered wood floors throughout living areas and office, which also has a wall of built-in bookshelves and desk. Bright and airy open concept living room with fireplace is just steps from a dream kitchen with an extra-large island with seating, Silestone counters, herringbone backsplash, and lots of counter and cabinet space! Retreat to the primary bedroom with an en-suite with dual sinks, vanity seating, pedestal soaking tub, and TWO large walk-in closets. Two secondary bedrooms share a hall and a bath while another has its own hallway and bath toward the front of the house - perfect for a MIL or guest suite. Tandem oversized 3 car garage and Smart Home with security included in HOA fee. Don\'t miss the backyard patio and lots of green space!' ,`Acres` = '0.1927' ,`Area` = '5' ,`BuilderName` = 'Highland Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POMONA SEC 11 (A0298 HT&BRR) BLK 1 LOT 28' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8394' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'POMONA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Pomona Sec 11' ,`TaxAmount` = '15903' ,`TaxRate` = '3.7194' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094717' WHERE `Matrix_Unique_ID` = '214043789'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-23T15:38:10.330' ,`MLSNumber` = '80546415' ,`ListAgentFullName` = 'Cathleen Harrison' ,`ListOfficeName` = 'My Galveston Getaway, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.271421' ,`Longitude` = '-94.844125' ,`PhotoCount` = '17' ,`PostalCode` = '77551' ,`RoomCount` = '5' ,`ListPrice` = '295000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue R' ,`StreetNumber` = '7308' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1572' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quiet, end of dead end street.  Lovely 3 bedroom, 2 bath home ready for your personal touches.  Large family room connected to kitchen by the breakfast bar with granite counters.  Dining room off the kitchen for easy entertaining or family dinners or game nights.  Laundry/mud room accessible through hallway and also the 2 car garage.  Primary bedroom has walk in closet and en suite bath, 2nd full bath in hallway as well.  Small yard in the back.  New photos coming after the holidays - current photos are from when this seller acquired the property.  Seller wants to remove personal items before photos.' ,`Acres` = '0.0781' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Near West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'MAGNOLIA COURT SUB (2007) ABST 121, LOT 28, ACRES 0.078' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '3400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Magnolia Court Sub 2007' ,`TaxAmount` = '4262' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675094717' WHERE `Matrix_Unique_ID` = '214897062'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-12-23T15:39:01.247' ,`MLSNumber` = '76078454' ,`ListAgentFullName` = 'Etha Eglin' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.151554' ,`Longitude` = '-94.141141' ,`PhotoCount` = '28' ,`PostalCode` = '77708' ,`RoomCount` = '7' ,`ListPrice` = '302990.00' ,`Status` = 'Active' ,`StreetName` = 'Riplee' ,`StreetNumber` = '6705' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2041' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Kingston elevation P 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!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = 'D.R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '00000000000' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'HOMER DRIVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BEAUMONT UNITED HIGH SCHOOL' ,`SchoolMiddle` = 'KING MIDDLE SCHOOL (BEAUMONT)' ,`ShowInstructions` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Wood' ,`TaxAmount` = '' ,`TaxRate` = '2.6134' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675094717' WHERE `Matrix_Unique_ID` = '214992780'  --> 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','215788612','1675094717','215788612','2022-12-23T16:29:35.580','85913740','Steve Gary','Orchard Brokerage','','','29.930823','-95.244871','30','77396','16','445000.00','Active','Wortham Stream','14819','Court','Humble','3','1','5','3210','Single-Family','Click the Virtual Tour link to view the 3D walkthrough. Gorgeous brick and stone exterior welcomes you home. This 3,200+ square foot residence has ample space to entertain with an ideal floor plan. High ceilings and natural light are beaming throughout the family room. The kitchen features an island with bar seating, granite countertops, tile backsplash, and ample cabinetry waiting to be stocked. Located on the main level, the primary bedroom boasts an en-suite bath with double sinks, built-in vanity, separate shower, garden soaking tub, and large walk-in closet. Entertaining comes easy with the outdoor kitchen and covered patio.  Enjoy your view of the walking trail with pond, no neighbors behind you.  Enjoy the outdoors by heading over to Lake Point Park or Golf Club of Houston. HWY-8, I-69, Lake Houston, and restaurants are just minutes away for convenience. Your new oasis awaits! Recent upgrades: new carpet and fresh paint, French drains, also HVAVV is 2 years new.','0.1584','1','','','Washer Connections','','Mud,Sellers Disclosure','1','','1','Fall Creek Area','Central Gas','1','LT 8 BLK 1 EAGLE CREEK SEC 1','Subdivision Lot','6900','Appraisal District','','1090','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','29 - Humble','AUTUMN CREEK ELEMENTARY SCHOOL','SUMMER CREEK HIGH SCHOOL','WOODCREEK MIDDLE SCHOOL','Lockbox Front','Appraisal District','2','Traditional','Eagle Crk Sec 01','11292','3.0673','Water District','2010','Appraisal District');  --> New record created successfully<br />