Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
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)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T14:05:13.007' ,`MLSNumber` = '83079116' ,`ListAgentFullName` = 'Asad Asaduddin' ,`ListOfficeName` = 'Columbia Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.627666' ,`Longitude` = '-95.635970' ,`PhotoCount` = '18' ,`PostalCode` = '77498' ,`RoomCount` = '7' ,`ListPrice` = '299000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue H' ,`StreetNumber` = '214' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'R E D U C E D BY $18000. Seller is the real estate broker/invester open to repairs. Complete replacement under City of Sugar Land permit-plumbing, electrical, cabinets, flooring, sheetrock finished January 2020. New foundation slab in the back for a planned two story addition. Room dimensions are approximate. Please overlook unkept house and yard but in good condition. Tenant moving out but being given time for health and family problems. The only two items reported by her are oven and water leak from outside to master bedroom closet floor in heavy rain. Older part of Sugar Land great neighborhood never flooded. Adjacent lot 218 Ave H included in the sale. Good opportunity for add on facility for commercial. Easy access to Hwy 90, Hwy 6 and Freeway 59/69.' ,`Acres` = '0.117' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MAYFIELD PARK SEC 1, BLOCK 2, LOT 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5095' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LAKEVIEW ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mayfield Park Sec 1' ,`TaxAmount` = '3540' ,`TaxRate` = '2.0094' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706735' WHERE `Matrix_Unique_ID` = '205135763' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T14:01:48.647' ,`MLSNumber` = '84141749' ,`ListAgentFullName` = 'Asad Asaduddin' ,`ListOfficeName` = 'Columbia Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.634904' ,`Longitude` = '-95.546646' ,`PhotoCount` = '8' ,`PostalCode` = '77477' ,`RoomCount` = '4' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Folkcrest' ,`StreetNumber` = '12927' ,`StreetSuffix` = 'Way' ,`City` = 'Stafford' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1814' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'VACANT NOW. Great and peaceful neighborhood. Fort Bend schools. Broker is the owner/seller.' ,`Acres` = '0.2233' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Stafford Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MISSOURI CITY ESTATES , BLOCK 12, LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9727' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '50 - Stafford' ,`SchoolElementary` = 'STAFFORD ELEMENTARY SCHOOL (STAFFORD MSD)' ,`SchoolHigh` = 'STAFFORD HIGH SCHOOL' ,`SchoolMiddle` = 'STAFFORD INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Missouri City Estates' ,`TaxAmount` = '3168' ,`TaxRate` = '1.9342' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706735' WHERE `Matrix_Unique_ID` = '205162045' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T15:38:46.230' ,`MLSNumber` = '86265928' ,`ListAgentFullName` = 'Dionne Randle' ,`ListOfficeName` = 'MOD Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.515873' ,`Longitude` = '-95.054269' ,`PhotoCount` = '45' ,`PostalCode` = '77573' ,`RoomCount` = '11' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Pine Mills' ,`StreetNumber` = '412' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2060' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is great for entertaining. New roof 2022 with 30-year shingles, PVC plumbing, new elegant lighting, new carpet, and freshly painted. The kitchen is open to the family room and has stainless appliances; refrigerator included, the spacious primary bedroom is downstairs, and the primary bathroom has his and her closets, and double sinks with a vanity. The backyard is huge and great for entertaining.' ,`Acres` = '0.1831' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 18 M MULDOON SUR LOT 5 BLK 12 MEADOW BEND SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7975' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HYDE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'LEAGUECITY INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Meadow Bend 2' ,`TaxAmount` = '5423' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663706735' WHERE `Matrix_Unique_ID` = '209150339' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T14:52:33.970' ,`MLSNumber` = '9006938' ,`ListAgentFullName` = 'Darin Young' ,`ListOfficeName` = 'RE/MAX Universal' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.955227' ,`Longitude` = '-95.616791' ,`PhotoCount` = '50' ,`PostalCode` = '77429' ,`RoomCount` = '12' ,`ListPrice` = '445000.00' ,`Status` = 'Active' ,`StreetName` = 'CRAIGWOOD LANE' ,`StreetNumber` = '12614' ,`StreetSuffix` = '' ,`City` = 'Cypress' ,`BathsFull` = '4' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4013' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is back to active.Foundation specialist letter attached for a good foundation report.Inspection report is available upon request. Home has had many items repaired. This is a MUST see Bungalow Hideaway in Cypress in Historic Timberlake Estates Neighborhood. The home has been cleaned and ready for listing. No other repairs will be done by seller.Price offer negotiated will NOT be lowered after any inspection should you choose to pay for yet another inspection so don’t even bother to ask! You will view nature at its finest with the driveway Bamboo wall built as privacy with the right side neighbor.The entryway fountain adds the finishing touches to the initial ambiance of a rest and relax homestead.This home is HUGE! Complete with 2 Primary bedrooms, 2 gaslog fireplaces,Covered Patio and Porch,with a separate Garage Apartment Dance Studio and kitchenette, Primary Kitchen, MIL suite with yet another kitchenette, 2 home offices, and plenty of outside storage and a 1 car garage as well.' ,`Acres` = '0.45' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 10 BLCK 11 TIMBERLAKE ESTATES' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '19560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MILLSAP ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'ARNOLD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Mediterranean,Ranch' ,`Subdivision` = 'TIMBERLAKE ESTATES' ,`TaxAmount` = '700' ,`TaxRate` = '2.3' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1966' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706735' WHERE `Matrix_Unique_ID` = '209523171' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T15:12:43.830' ,`MLSNumber` = '45688876' ,`ListAgentFullName` = 'Teresa Scott' ,`ListOfficeName` = 'One Plus Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.797769' ,`Longitude` = '-95.885602' ,`PhotoCount` = '41' ,`PostalCode` = '77493' ,`RoomCount` = '12' ,`ListPrice` = '914800.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Horse' ,`StreetNumber` = '1703' ,`StreetSuffix` = 'Canyon' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3433' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'GORGEOUS HOUSE in Highly Sought After Community that is in Katy ISD & Zoned to Katy High School. This Spectacular, yet Comfy Home is on almost 2 acres, at the end of cul-de-sac, and Waterfront! EXTENSIVE UPGRADES & Renovations have been done to this Modern-Country Home: A POOL, OUTDOOR Kitchen, FIRE PIT, MOSQUITO MISTING System, OUTDOOR Retractable Shade, 2 NEW A/C Units, 2 NEW Furnaces, NEW 30 Year ROOF w/Transferable Warranty, NEW Carpeting, Quartz & Granite counter tops, New Fixtures, Fresh Paint & more! Kitchen has a Wine Rack, Tile Back Splash, walk in Pantry, plus lots of cabinets & counter space. The Oversized 3 Car Garage, DOUBLE Pane Windows, TECH Shield & A Removable POOL SAFETY GATE helps add to the Homes Energy Efficiency & Safety! Beautiful & STUNNING views from almost every room. Head out to the Incredible back yard to enjoy all the amenities or head behind the house for some fishing! NO WATER BILL or MUD TAX! HOME NEVER LOST POWER during FREEZE & HOME Has NEVER FLOODED!' ,`Acres` = '1.3804' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S733104 REMINGTON TRAILS 4 BLK 1 LOT 24 ACRES 1.3804' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Subdivision Lot,Waterfront' ,`LotSize` = '60130' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Remington Trails 4' ,`TaxAmount` = '11247' ,`TaxRate` = '2.1293' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706735' WHERE `Matrix_Unique_ID` = '210624849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T15:46:26.580' ,`MLSNumber` = '29154819' ,`ListAgentFullName` = 'Johnna Maertz' ,`ListOfficeName` = 'Blue Dolphin Realty, LLC.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.527621' ,`Longitude` = '-96.578927' ,`PhotoCount` = '44' ,`PostalCode` = '77470' ,`RoomCount` = '7' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Tinkler' ,`StreetNumber` = '2715' ,`StreetSuffix` = 'Street' ,`City` = 'Rock Island' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1524' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready to get away from the rat race.well here you go!Sitting on just shy of ½ an acre there\'s plenty of room for your garden,animals,etc. The home has 3-5 bedrooms. The pass through, L shaped, full bath has a door to the master & one to the hall & features a tub/shower combo. The front door has a formal entry into the home & the XL living area. The kitchen is open to the living room over a breakfast bar & has a large pantry. The bedrooms are nice size as are the closets. The floors are tile, laminate, concrete, & “lay-down” carpet which you can easily remove to redo the floors as you wish. Out the back door is a nice breezeway which is connected to a large, enclosed RV area, workshop, & storage. There is a step down pit for working on autos, RVs, tractors, etc… This property is an easy drive to the coast, Richmond/Rosenberg area, Katy, Columbus, Victoria, and ONLY 6 MILES FROM SPLASHWAY WATER PARK IN SHERIDAN TEXAS. You could air B&B it!!! Don’t delay, call today for your showing!' ,`Acres` = '0.48' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Butane' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 41 LT 19-24 ROCK ISLAND HOUSE & BLDG' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '21000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Rock Island' ,`TaxAmount` = '1205' ,`TaxRate` = '1.5459' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706735' WHERE `Matrix_Unique_ID` = '211188689' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T14:48:17.850' ,`MLSNumber` = '50987840' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Keller Williams Platinum' ,`SellingAgentFullName` = 'Joe Tijerina' ,`SellingOfficeName` = 'Century 21 Garlington & Assoc.' ,`Latitude` = '29.799719' ,`Longitude` = '-95.173354' ,`PhotoCount` = '45' ,`PostalCode` = '77015' ,`RoomCount` = '8' ,`ListPrice` = '289999.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Double Pine' ,`StreetNumber` = '14006' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2083' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Make lifelong memories in this gorgeous 3-bedroom, 2-bathroom home in Woodforest North, boasting a brick exterior, high ceilings, wood flooring, gas log fireplace, study/flex room, a formal living room and a breakfast nook. Entertain guests in the expansive backyard, complete with a covered patio, sparkling pool, wooded deck, and a gazebo. Try new cuisines in the island kitchen, equipped with granite countertops, a gas cooktop, breakfast bar, and pendant lighting. Take a well-deserved break in the primary suite, complete with a walk-in closet, dual vanities, a jetted tub, and a separate shower. The community is conveniently situated between U.S 90 and I-10 along the Greens Bayou. Residents can find dining and shopping at New Forest Crossing, Fifth Ward, and the Shops at Stone Park. Enjoy outdoor recreation at the nearby Sheldon Lake and Herman Brown Park. Nearby schools are a part of Galena Park ISD.' ,`Acres` = '0.2172' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 3 WOODFOREST NORTH SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9460' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'HAVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodforest North' ,`TaxAmount` = '5335' ,`TaxRate` = '2.9394' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706736' WHERE `Matrix_Unique_ID` = '211464728' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-04T15:45:33.887' ,`MLSNumber` = '12710378' ,`ListAgentFullName` = 'Tili Capistran' ,`ListOfficeName` = 'Intero Real Estate Services' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.956200' ,`Longitude` = '-95.451998' ,`PhotoCount` = '12' ,`PostalCode` = '77067' ,`RoomCount` = '3' ,`ListPrice` = '244999.00' ,`Status` = 'Active' ,`StreetName` = 'Bee' ,`StreetNumber` = '11810' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1701' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Come fall in love with this 3 bed 2 bath charming home in a quiet neighborhood. This is an incredible opportunity to live just minutes from I-45 and S. Sam Houston Pkwy along with restaurants and shopping centers. Home features a family friendly decent size back yard where kids and pets can enjoy. Yard is huge enough to add a pool. Home is calling out your name. Call for your showing appt today. Property Sold As-Is.' ,`Acres` = '0.1731' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 14 RUSHWOOD SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '7540' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'JOAN LINK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rushwood Sec 02' ,`TaxAmount` = '5126' ,`TaxRate` = '3.0367' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663706736' WHERE `Matrix_Unique_ID` = '211795837' --> Updated record success
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','212123559','1663706736','212123559','2022-09-04T15:13:41.033','21649358','Alex Rezende','AroundTown Properties Inc','','','29.814066','-95.348478','21','77026','6','344888.00','Active','Linder','2010','Street','Houston','2','1','3','1611','Single-Family','This brand new smart home features 3 Bedrooms & 2.5 Baths a 2 car attached garage & a low maintenance backyard! Granite countertops & built-in stainless steel appliances in the open concept kitchen with tons of natural light. Tile flooring throughout the living areas/walkways and carpet in all bedrooms. Smart Home Features include LED lights, smart garage door opener, Smart thermostat, Smart lock, Smart doorbell, electric car outlet, low voltage panel, smart light switch, HVAC 16 SEER. Linder Landing is perfectly situated just North of Downtown Houston and only minuted from 610. The prime location provides convenient access to Downtown Houston and other major employment centers, fine dining, shopping & entertainment! This exclusive community is comprised of only five homes and features modern floor plans and high-end interior finishes. Quality construction by MTY Builders paired with the luxurious open concept design is sure to impress! 5 Units starting at $344,888.','','9','MTY Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','Northside','Central Gas','0','Lot 2 Blk 1 Linder Landing','Cleared','2142','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ROSS ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Contemporary/Modern','Linder Landing','','2.33','Public Sewer,Public Water','2021','Builder'); --> New record created successfully
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','212124245','1663706736','212124245','2022-09-04T15:12:29.460','72479530','Alex Rezende','AroundTown Properties Inc','','','29.814066','-95.348478','21','77026','6','344888.00','Active','Linder','2008','Street','Houston','2','1','3','1611','Single-Family','This brand new smart home features 3 Bedrooms & 2.5 Baths a 2 car attached garage & a low maintenance backyard! Granite countertops & built-in stainless steel appliances in the open concept kitchen with tons of natural light. Tile flooring throughout the living areas/walkways and carpet in all bedrooms. Smart Home Features include LED lights, smart garage door opener, Smart thermostat, Smart lock, Smart doorbell, electric car outlet, low voltage panel, smart light switch, HVAC 16 SEER. Linder Landing is perfectly situated just North of Downtown Houston and only minuted from 610. The prime location provides convenient access to Downtown Houston and other major employment centers, fine dining, shopping & entertainment! This exclusive community is comprised of only five homes and features modern floor plans and high-end interior finishes. Quality construction by MTY Builders paired with the luxurious open concept design is sure to impress! 5 Units starting at $344,888.','','9','MTY Builders','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Corporate Listing','1','','','Northside','Central Gas','0','Lot 1 Blk 1 Linder Landing','Cleared','2142','Appraisal District','','','1','To Be Built/Under Construction','2','Gas Oven','0','','','Gas Range','','Composition','27 - Houston','ROSS ELEMENTARY SCHOOL (HOUSTON)','NORTHSIDE HIGH SCHOOL','KEY MIDDLE SCHOOL','Accompany,Appointment Required','Builder','2','Contemporary/Modern','Linder Landing','','2.33','Public Sewer,Public Water','2021','Builder'); --> New record created successfully
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','212178773','1663706736','212178773','2022-09-04T15:01:09.387','37876142','Beau Laviolette','A Action Realty','','','30.807698','-95.104688','13','77360','1','69900.00','Active','Caribou','101','Street','Onalaska','1','0','1','576','Single-Family','Come check out this nice rustic cabin just minutes from Beautiful lake Livingston. With access, via private subdivision boat ramp, to our 90,000+ acre lake this cabin will have you relaxing by the lake in no time. You won\'t want to miss this opportunity, places in this price range with lake access don\'t last long call for your showing today.','0.1306','44','','','','','Sellers Disclosure','','','','Lake Livingston Area','Other Heating','1','IMPALA WOODS SECTION 2 BLK 18 LOT 22','Subdivision Lot','5687','Appraisal District','','120','0','','0','','0','','','','','Aluminum','104 - Onalaska','ONALASKA ELEMENTARY SCHOOL','ONALASKA JR/SR HIGH SCHOOL','ONALASKA JR/SR HIGH SCHOOL','Appointment Required','Appraisal','1','Other Style','Impala Woods Sec 2','750','2.054','Public Sewer,Public Water','2018','Appraisal District'); --> New record created successfully