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-11-28T14:27:21.880' ,`MLSNumber` = '8118681' ,`ListAgentFullName` = 'Kevin King' ,`ListOfficeName` = 'RE/MAX ONE - Premier' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.731198' ,`Longitude` = '-94.965703' ,`PhotoCount` = '6' ,`PostalCode` = '77520' ,`RoomCount` = '3' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Texas' ,`StreetNumber` = '201' ,`StreetSuffix` = 'Avenue' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great Opportunity to own your own business. Great location.' ,`Acres` = '0.2296' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 13 14 15 & 16 BLK 55 (016 & 051*THOMAS WRIGHT) GOOSE CRE' ,`LotDesciption` = 'Corner' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'ASHBEL SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'HORACE MANN J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Goose Creek' ,`TaxAmount` = '3586' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084998' WHERE `Matrix_Unique_ID` = '208180308'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T13:49:21.930' ,`MLSNumber` = '71751204' ,`ListAgentFullName` = 'Jeffrey Lutz' ,`ListOfficeName` = 'RE/MAX Fine Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796082' ,`Longitude` = '-95.683004' ,`PhotoCount` = '50' ,`PostalCode` = '77084' ,`RoomCount` = '10' ,`ListPrice` = '289900.00' ,`Status` = 'Active' ,`StreetName` = 'Pepperwood' ,`StreetNumber` = '1910' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1869' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'LOCATION LOCATION LOCATION! Wonderfully updated and nice home, in a small pocket size community with excellent access to IH 10. This lovely three bedroom home features beautiful wood look tile in the family, dining, kitchen and hallways. There is modern nice tile in the baths, with carpet in the bedrooms only. This spacious home offers lots of natural light, huge family room with cozy wood burning fireplace, vaulted ceilings, big kitchen with connecting dining area on one side and breakfast on the other other. The kitchen is well appointed with wonderful granite tops, stainless appliances, painted real wood cabinets, big and spacious with sink window to driveway and side door. The primary bedroom is tucked away in the back with nicely redone en-suite, featuring double sinks, modern shower, granite lavatory, and two closets. The secondary bedrooms are both spacious and offer a nice hall bath with double sinks, and separate toilet and tub room. Big back yard with outside sitting area.' ,`Acres` = '0.1641' ,`Area` = '8' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 69 BLK 3 MAYDE CREEK FARMS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '515' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'SCHMALZ ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mayde Creek Farms Sec 01' ,`TaxAmount` = '5290' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084998' WHERE `Matrix_Unique_ID` = '212080495'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T13:05:13.373' ,`MLSNumber` = '4274763' ,`ListAgentFullName` = 'Rachel Anderson' ,`ListOfficeName` = 'Rachel Anderson Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.723488' ,`Longitude` = '-96.105288' ,`PhotoCount` = '22' ,`PostalCode` = '75840' ,`RoomCount` = '3' ,`ListPrice` = '139000.00' ,`Status` = 'Active' ,`StreetName` = 'FCR 540' ,`StreetNumber` = '131' ,`StreetSuffix` = '' ,`City` = 'Fairfield' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '1' ,`SqFtTotal` = '640' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Relax on the open deck while you watch the deer come right through your front yard!  Wooded tract with a cozy 1 bed, 1 bath cabin (approx. 16 x 40)  Explore the trails that zigzag through the property leading to the small pond that has great potential for expansion.  The home faces FCR 549, but there is road frontage on three sides.  With driveways on both 540 and 549, there is easy access & plenty of room to add another home.  Graceland double loft 10 x 16 storage building is included.  30 amp RV connection.  Above ground septic, community water, just minutes from I-45, approx. 90 miles south of Dallas.' ,`Acres` = '4.98' ,`Area` = '74' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freestone County' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'WILDWOOD - J KORN A-15 TR 47' ,`LotDesciption` = 'Wooded' ,`LotSize` = '216929' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '226 - Fairfield' ,`SchoolElementary` = 'FAIRFIELD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FAIRFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'FAIRFIELD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Wildwood' ,`TaxAmount` = '1315' ,`TaxRate` = '1.7349' ,`WaterSewer` = 'Septic Tank,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1675084998' WHERE `Matrix_Unique_ID` = '213548029'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T14:39:46.743' ,`MLSNumber` = '80519657' ,`ListAgentFullName` = 'Luis Gomez' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.787873' ,`Longitude` = '-95.187662' ,`PhotoCount` = '14' ,`PostalCode` = '77015' ,`RoomCount` = '4' ,`ListPrice` = '198900.00' ,`Status` = 'Active' ,`StreetName` = 'Granada' ,`StreetNumber` = '13374' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '988' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW ELECTRICAL, NEW PLUMBING, NDW DRAINAGE, NEW AIR CONDITIONER, NEW KITCHEN, NEW CABINETS, NEW BATHROOM, THE HOUSE HAS BEEN COMPLETERLY RENOVATED INTERIOR AND EXTERIOR.' ,`Acres` = '0.1952' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 733 BLK 27 HOME OWNED ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8505' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GREEN VALLEY ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'CUNNINGHAM MIDDLE SCHOOL (GALENA PARK)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates Sec 02' ,`TaxAmount` = '2724' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084998' WHERE `Matrix_Unique_ID` = '213749773'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T13:43:05.107' ,`MLSNumber` = '53526087' ,`ListAgentFullName` = 'Amy Chance' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.057770' ,`Longitude` = '-94.150220' ,`PhotoCount` = '24' ,`PostalCode` = '77707' ,`RoomCount` = '4' ,`ListPrice` = '292000.00' ,`Status` = 'Active' ,`StreetName` = 'Ridgeline' ,`StreetNumber` = '5115' ,`StreetSuffix` = 'Circle' ,`City` = 'Beaumont' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1976' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Spacious home available in the quiet Wolf Creek subdivision right off of Washington Ave. This 4 bed, 2 bath, 2 car garage home is a 1976 square foot, brick home with landscaped front yard. This home has tile floors, granite throughout the kitchen and bathrooms, stainless appliances, laundry room and a large living area with plenty of space to spread out. All bedrooms have carpet and the master bath has a walk-in closet and separate shower and garden tub. The house has neutral colors, high ceilings and beautiful tile work. If you are looking for peace and tranquility in the middle of the city, this is it.' ,`Acres` = '0.164' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 13 BLOCK 2 WOLF CREEK SEC 1' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '7145' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '143 - Beaumont' ,`SchoolElementary` = 'CALDWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WEST BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'ODOM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wolf Creek' ,`TaxAmount` = '4164' ,`TaxRate` = '2.645' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084999' WHERE `Matrix_Unique_ID` = '213803600'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T13:00:03.880' ,`MLSNumber` = '10373117' ,`ListAgentFullName` = 'Gary Barbles' ,`ListOfficeName` = 'GP Investment Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766878' ,`Longitude` = '-94.998847' ,`PhotoCount` = '10' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '249000.00' ,`Status` = 'Active' ,`StreetName` = 'Country Club' ,`StreetNumber` = '4027' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1465' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Bellvue plan is a one-story home featuring 3 bedrooms, 2 baths, and 2 car garage. The foyer opens to the guest bedrooms w/ walk-in closets & bath with linen shelves. Kitchen includes a breakfast bar, beautiful counter tops, stainless steel appliances, corner pantry and opens to family room. The owner\'s suite has sloped ceiling and attractive master bath with dual vanities, water closet and walk-in closet. This home includes side by side refrigerator, washer, dryer, blinds, garage door opener, and tankless water heater. DR Horton builds homes that are energy efficient and offer smart features such as the Honeywell bluetooth thermostats, Sky Door Bell Cameras, wireless security on exterior door, and Amazon Echo. Be a part of the community while enjoying covered pavilion and gorgeous pool with children’s play area, playground, lakes and walking trails, and 19 acres of preserved land for recreational use and future putting green' ,`Acres` = '0.1377' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 4 GOOSE CREEK RESERVE SEC 4' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'TRAVIS ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'LEE HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'BAYTOWN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Goose Creek Reserve' ,`TaxAmount` = '7111' ,`TaxRate` = '3.63' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084999' WHERE `Matrix_Unique_ID` = '214095110'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T14:55:25.150' ,`MLSNumber` = '69510358' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'KB Home Houston' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.635643' ,`Longitude` = '-95.813359' ,`PhotoCount` = '6' ,`PostalCode` = '77406' ,`RoomCount` = '12' ,`ListPrice` = '403518.00' ,`Status` = 'Active' ,`StreetName` = 'Gazelle Leap' ,`StreetNumber` = '4919' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2961' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Cherish lasting memories in this lovely KB Home in Deer Run Meadows, boasting a brick front, extended entry, wrought iron spindles, and an open great room. Dream up new recipes in the kitchen, equipped with granite countertops, stainless steel Energy Star® appliances, 42-in. cabinets, and undercabinet lighting. The serene primary suite features extended dual vanities, a 42-in. Kohler Master Windward® tub, and a separate shower. The community of Deer Run Meadows is conveniently located near Westpark Tollway and the Grand Parkway, giving commuters quick access to the Energy Corridor, Sugar Land, and Downtown Houston. Shops and restaurants at the Shops of Bella Terra and Brazos Town Center are only a short distance away. Community amenities include a covered pavilion, park, and playground. Zoned to the Lamar Consolidated ISD.' ,`Acres` = '' ,`Area` = '37' ,`BuilderName` = 'KB Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Fort Bend County North/Richmond' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 21 Block 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '660' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'BENTLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FOSTER HIGH SCHOOL' ,`SchoolMiddle` = 'WERTHEIMER/BRISCOE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Deer Run Meadows' ,`TaxAmount` = '' ,`TaxRate` = '2.895' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675084999' WHERE `Matrix_Unique_ID` = '214123780'  --> 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','214253400','1675084999','214253400','2022-11-28T13:15:19.200','74645598','Sapramjeet Singh','SJS International LLC','','','29.864986','-95.610032','6','77041','0','379000.00','Active','Gusty Trail','6418','Lane','Houston','2','1','4','2822','Single-Family','4/2.5/2 home with many recent updates (2022) including: Brand new roof, paint, wood flooring. Updated bathrooms, kitchen with granite countertops. House is on a cul-de-sac street so no through traffic, great for families. Easy access to Bltwy 8, I-10 and minutes from City Center.','','8','','','','','Mud,Sellers Disclosure','1','','','Eldridge North','Central Electric,Central Gas','1','LT 48 BLK 1 CONCORD BRIDGE NORTH SEC 4','Cleared','6508','Appraisal District','','300','0','','2','','0','','','','','Composition','13 - Cypress-Fairbanks','LEE ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)','CYPRESS FALLS HIGH SCHOOL','TRUITT MIDDLE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Traditional','Concord Bridge North Sec 04','7783','2.471','Public Sewer,Public Water','2001','Appraisal District');  --> New record created successfully<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T13:08:57.353' ,`MLSNumber` = '62234504' ,`ListAgentFullName` = 'Lyndsey Le' ,`ListOfficeName` = 'Platinum K Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.723045' ,`Longitude` = '-95.321762' ,`PhotoCount` = '40' ,`PostalCode` = '77023' ,`RoomCount` = '5' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Des Jardines' ,`StreetNumber` = '1749' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BACK ON MARKET WITH A $35K PRICE REDUCTION! HURRY! Don\'t miss out on this charming remodeled 3-bedroom 2-bath home with great curb appeal, located near University of Houston, TMC, Houston Downtown, East Downtown, Midtown, and Montrose with quick & easy access to I-45! Featuring an open floor plan w/ amble natural light, laminate wood flooring throughout, and neutral paint tones. Open family/living room flows into the formal dining room w/ decorative light & leads into the kitchen boasting crisp white cabinetry, stainless steel appliances, brushed nickel fixtures, granite countertops & tile backsplash. An extra wide hall area leads to the 3 good sized and spacious bedrooms. Don\'t forget the walk-in pantry and spacious utility room! 24\" foundation water/moisture barrier installed all around the house. NEW PRIVATE FENCE!! Come tour this beautiful updated home and see for yourself all this property has to offer! Schedule your showing today!' ,`Acres` = '0.1664' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 37 & 38A DES JARDINS PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7250' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HENDERSON J ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Des Jardins Place' ,`TaxAmount` = '4418' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084999' WHERE `Matrix_Unique_ID` = '215066886'  --> Updated record success<br />UPDATE propData2 SET `MatrixModifiedDT` = '2022-11-28T13:20:55.120' ,`MLSNumber` = '5736706' ,`ListAgentFullName` = 'Jamion Blackwell' ,`ListOfficeName` = 'Radius Agent LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.320391' ,`Longitude` = '-95.457278' ,`PhotoCount` = '14' ,`PostalCode` = '77301' ,`RoomCount` = '12' ,`ListPrice` = '2500000.00' ,`Status` = 'Active' ,`StreetName` = 'Dallas' ,`StreetNumber` = '204' ,`StreetSuffix` = 'Street' ,`City` = 'Conroe' ,`BathsFull` = '11' ,`BathsHalf` = '1' ,`BedsTotal` = '12' ,`SqFtTotal` = '10858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '1930\'s Traditional home currently used as an assisted living facility available. It can be sold with that business/brand at an additional fee. The bedrooms are currently double occupancy with each bed potentially generating S3-5k in revenue. The current license is for 16 occupants, however there is currently room for 22. The home sits on 1.43 acres for further expansion. Elevator to access top floor, solar panels, fire suppression sprinklers, dedicated cameras for resident\'s families, and management/staff (separate from owners) in place. All licenses and permits are current. The revenue potential on this property exceeds S64k/month. The property has roughly 10 tours a week, but is in need of some design, light renovations, and repairs. This home would be great for someone that wants that 1930s charm or is thinking of starting and running a franchisable business model. Please view attachments. Contact agent for Seller\'s Disclosure or a tour of the property.' ,`Acres` = '1.429' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S691003 - LEWIS 03, LOT 17-B, S691004 LOT 2-B, ACRES 1.429' ,`LotDesciption` = 'Cleared' ,`LotSize` = '62247' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'HOUSTON ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lewis 03' ,`TaxAmount` = '19388' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1936' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675084999' WHERE `Matrix_Unique_ID` = '215099689'  --> 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','215130822','1675085000','215130822','2022-11-28T13:42:57.353','2047873','Uy-Vu Mui','Texas Signature Realty','','','29.960404','-95.516623','32','77066','9','305000.00','Active','Saragosa Crossing','6438','Lane','Houston','2','1','4','2896','Single-Family','Beautiful 2 story home - never flooded. This home offers high ceilings, open floor plan and extra room for cooking and dining. Master suite on 1st floor featuring walk in closet, double sinks, separate shower and jetted tub. Gourmet kitchne feature granite tops, spacious breakfast area. Second floor equipped with 3 additional bedrooms, spacious gameroom loft give a ton of space and plenty of storage. No back neighbors. Easy access to supermarkets, HW 249, BW 8 with lots of dining and shopping. Neighborhood amenities include pool, playground, tennis courts and clubhouse.','0.1292','13','','','','','Sellers Disclosure','','Gaslog Fireplace','1','1960/Cypress Creek South','Central Electric,Central Gas','1','LT 14 BLK 2 CHAMPIONS CROSSING SEC 4','Corner,Cul-De-Sac','5628','Appraisal District','','530','0','','2','Gas Oven','0','','','Gas Cooktop','','Composition','32 - Klein','KLENK ELEMENTARY SCHOOL','KLEIN FOREST HIGH SCHOOL','WUNDERLICH INTERMEDIATE SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,Request Online Appointment,Vacant/Unoccupied','Appraisal District','2','Traditional','Champions Xing Sec 04','8863','3.3765','Public Sewer,Public Water','2009','Appraisal District');  --> New record created successfully<br />