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-11T14:37:54.457' ,`MLSNumber` = '36904930' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'Emerald Homes' ,`SellingAgentFullName` = 'Lomil Truitt' ,`SellingOfficeName` = 'Jane Byrd Properties INTL.' ,`Latitude` = '29.983215' ,`Longitude` = '-95.136347' ,`PhotoCount` = '10' ,`PostalCode` = '77044' ,`RoomCount` = '7' ,`ListPrice` = '901490.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Brunel' ,`StreetNumber` = '9230' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3498' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'RESORT-STYLE LAKEFRONT LIVING- DIRECT LAKE ACCESS FROM YOUR OWN BACKYARD! Exclusive Gated Community + Low-Traffic Cul-de-Sac Street! Enjoy Amazing Sunsets & Watch Boats From Your Covered Back Porch & Huge Upstairs Veranda! Soaring High Ceilings, Solid Mahogany Front Door! Grey Kitchen Cabinetry, White Subway Tile, Granite Counters, Farmhouse Sink, & Stainless Whirlpool Appliances (Including 5 Burner Gas Cooktop + Double Ovens)! 8\' Interior Doors, Privately Located First Floor Owner\'s Retreat with Luxurious Bath: Frameless Shower with Bench & Stand-Alone Tub! Sprinkler System in Front AND Back Yards! Three Car Garage with Openers! Covered Back Patio - Pre-Plumbed for Future Outdoor Kitchen! Spray Foam Insulation, 16 SEER A/C, & Smart Home Automation System! Tankless Water Heater, DuPure Water Filtration System, PLUS MORE! WOW!!' ,`Acres` = '0.2837' ,`Area` = '1' ,`BuilderName` = 'Emerald Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Atascocita South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 49 BLK 1 BRIDGES ON LAKE HOUSTON SEC 8' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '12359' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1300' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WEST LAKE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridges On Lake Houston' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '205136752' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:02:02.383' ,`MLSNumber` = '92064100' ,`ListAgentFullName` = 'Sherry Capps' ,`ListOfficeName` = 'Wyatt Real Estate' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.498141' ,`Longitude` = '-94.928687' ,`PhotoCount` = '37' ,`PostalCode` = '77539' ,`RoomCount` = '5' ,`ListPrice` = '220000.00' ,`Status` = 'Option Pending' ,`StreetName` = '19th' ,`StreetNumber` = '133' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Galveston bay water view home sitting on 5 lots. Home has 2-bedrooms, 2 baths with a sunroom that can be used as a third bedroom. Elevated floor plan with covered parking and lots of storage underneath. Screened porch at front, back deck and water views from many rooms. Home has newer replaced double pane windows. There is so much potential for this property. Over 13,000 sq ft. lot.' ,`Acres` = '0.3076' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARD SUR LOTS 5 THRU 8 BLK 4 SAN LEON TOWNSITE' ,`LotDesciption` = 'Cleared,Water View' ,`LotSize` = '13399' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '5571' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1976' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '205494120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:35:39.300' ,`MLSNumber` = '81024168' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Darrell Fountain' ,`SellingOfficeName` = 'BHGRE Gary Greene' ,`Latitude` = '30.221248' ,`Longitude` = '-95.240160' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '247990.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Hazel Branch' ,`StreetNumber` = '14785' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1858' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Express Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Harrington Trails 05A, BLOCK 4, Lot 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '205935771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:30:59.710' ,`MLSNumber` = '72818691' ,`ListAgentFullName` = 'Shary Luthe' ,`ListOfficeName` = 'Home Sweet Home Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.809830' ,`Longitude` = '-95.114200' ,`PhotoCount` = '13' ,`PostalCode` = '77360' ,`RoomCount` = '3' ,`ListPrice` = '125000.00' ,`Status` = 'Active' ,`StreetName` = 'Hickory' ,`StreetNumber` = '105' ,`StreetSuffix` = 'Valley' ,`City` = 'Onalaska' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome To A True Barndo To Make Your Own! The Structure Features 2400 Sqft Of Space To Make It Exactly How You Would Like- So Many Possibilities! It Is Partially Gutted And Has Public Water And Sewer. The Property Features A Great Amount Of Yard Space- 5 Lots- Totaling Approximately 3/4 Of An Acre With No Restrictions! Come Make This Your Own Today!' ,`Acres` = '0.7565' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'HICKORY VALLEY WEST LOT 33-37' ,`LotDesciption` = 'Cleared,Corner,Ravine' ,`LotSize` = '32953' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '104 - Onalaska' ,`SchoolElementary` = 'ONALASKA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ONALASKA JR/SR HIGH SCHOOL' ,`SchoolMiddle` = 'ONALASKA JR/SR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Barndominium' ,`Subdivision` = 'Hickory Valley West' ,`TaxAmount` = '1878' ,`TaxRate` = '2.054' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '206091346' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:37:15.037' ,`MLSNumber` = '47867492' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Kelly Donawa' ,`SellingOfficeName` = 'JLA Realty' ,`Latitude` = '30.195222' ,`Longitude` = '-95.150867' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '4' ,`ListPrice` = '331740.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Forest View' ,`StreetNumber` = '918' ,`StreetSuffix` = '' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1831' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fantastic brand NEW DR Horton home situated on 17,935 square foot wooded homesite with 3 car garage! This 4 bedroom property also features a useful study! Modern finishes and an amazing use of natural light! The open kitchen features shaker cabinets, granite countertops and stainless-steel appliances. Spacious Primary Suite is tucked away for your own private retreat with separate shower and garden tub. The home has front sprinklers, and a home automation system. You will appreciate the great storage and energy efficient features throughout. Hurry and call today!' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 4 Block 10 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17935' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Estates at Roman Forest' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '207512294' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:36:44.647' ,`MLSNumber` = '59120050' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = 'Jason Aguirre' ,`SellingOfficeName` = 'Fathom Realty' ,`Latitude` = '29.835480' ,`Longitude` = '-95.771825' ,`PhotoCount` = '14' ,`PostalCode` = '77449' ,`RoomCount` = '6' ,`ListPrice` = '447735.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Magliana' ,`StreetNumber` = '4203' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW MODERN DESIGN! This beautiful Two story home features an open concept with luxurious hard surface plank flooring, an abundance of cabinet space in the kitchen. Under cabinet lighting in the kitchen with stainless steel built-in appliances & quartz countertops. The master has quartz counter tops, double sinks and a separate shower and tub!! Huge game room!!! Smart Home Technology, fully landscaped front & back including sprinkler system. Tankless water heater. Garage door opener. Large covered back patio. 16-SEER A/C and SO MUCH MORE!' ,`Acres` = '0.1536' ,`Area` = '25' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 19 BLK 3 VENTANA LAKES EAST SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6691' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Ventana Lakes' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '208247901' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:57:03.150' ,`MLSNumber` = '95667078' ,`ListAgentFullName` = 'Stephen Metarelis' ,`ListOfficeName` = 'Offerpad Brokerage, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.932778' ,`Longitude` = '-95.733746' ,`PhotoCount` = '19' ,`PostalCode` = '77433' ,`RoomCount` = '4' ,`ListPrice` = '478900.00' ,`Status` = 'Active' ,`StreetName` = 'Penn Farm' ,`StreetNumber` = '18718' ,`StreetSuffix` = 'Drive' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2466' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful, modern stucco and stone 1-story Trendmaker built home in Bridgeland Parkland Village with 3 bedrooms and 2.5 baths is in like-new condition! Living room with lots of windows to bring in natural light is open to the kitchen featuring a large, curved center island with breakfast bar, stainless steel appliances, upgraded cabinets and quartz countertops. Formal dining room is also part of the open concept social area. Primary bedroom with luxurious ensuite bath. Split plan with 2 secondary bedrooms sharing a connecting bathroom. Half Bath and Laundry Room off the Extended Entry. Plan also includes an office/study with access to side patio. Nicely landscaped front yard. Backyard with covered patio and privacy fence. Bridgeland is a nationlly recognized master planned community with plenty of recreational amenities including a treehouse park and multiple pools and parks. Welcome to your new home!' ,`Acres` = '0.1561' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 1 BRIDGELAND PARKLAND VILLAGE SEC 10 R/P' ,`LotDesciption` = 'Other' ,`LotSize` = '6799' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '655' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'MCGOWN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRIDGELAND HIGH SCHOOL' ,`SchoolMiddle` = 'SMITH MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bridgeland Parkland Village' ,`TaxAmount` = '14145' ,`TaxRate` = '3.541' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709385' WHERE `Matrix_Unique_ID` = '209729132' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:30:39.893' ,`MLSNumber` = '62526203' ,`ListAgentFullName` = 'Vidhi Nayak' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658376' ,`Longitude` = '-95.635100' ,`PhotoCount` = '23' ,`PostalCode` = '77498' ,`RoomCount` = '3' ,`ListPrice` = '269000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Falls DR' ,`StreetNumber` = '14031' ,`StreetSuffix` = '' ,`City` = 'Sugar Land' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1274' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Fully RENOVATED!!! The roof is two years old, brand new A/C, newly widened driveway, new cabinets, granite, remodeled bathrooms with new mirrors, open floor plan, new fixtures, new mini-blinds, new electrical switches, and plugs, and a whole home generator, etc.' ,`Acres` = '' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sugar Land North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TOWNEWEST SEC 6, BLOCK 5, LOT 76' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '335' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'SUGAR MILL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KEMPNER HIGH SCHOOL' ,`SchoolMiddle` = 'SUGAR LAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'TOWNWEST' ,`TaxAmount` = '' ,`TaxRate` = '2.3329' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '210243381' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:55:32.590' ,`MLSNumber` = '40108968' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.523776' ,`Longitude` = '-95.308025' ,`PhotoCount` = '32' ,`PostalCode` = '77584' ,`RoomCount` = '8' ,`ListPrice` = '275000.00' ,`Status` = 'Active' ,`StreetName` = 'Wayne' ,`StreetNumber` = '17175' ,`StreetSuffix` = 'Lane' ,`City` = 'Pearland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1352' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wonderful Pearland opportunity on almost a 1/2 acre lot - country living at its best. Main home offers 3 bedrooms with 2 full bathrooms (plus 1/2 bath in back addition), vinyl floors, ceiling fans, fresh paint (2022*), granite counters in kitchen, fridge, electric freestanding range with hood. Extra room could work as a living space and/or study. Covered patio area with plenty of greenspace for entertaining! Don\'t forget to check out the additional space behind the home which could be utilized as an office or living quarters. Space includes two separate air conditioned rooms (previously used as a hair salon), recessed lighting, ceiling fans, concrete & Vinyl flooring and private entrances. Roof (13 years*), HVAC (2018*). Square footage of this space is NOT included in county square footage. No Deed Restrictions per Seller. NO HOA, LOW taxes, Pearland ISD schools. This home awaits your personal touches. Schedule your private showing today. *Per Seller' ,`Acres` = '0.4' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pearland' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0245 H T & B R R TRACT 25A1A ACRES 0.4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17424' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '42 - Pearland' ,`SchoolElementary` = 'MASSEY RANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PEARLAND HIGH SCHOOL' ,`SchoolMiddle` = 'PEARLAND JUNIOR HIGH SOUTH' ,`ShowInstructions` = 'Lockbox Left Side,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'H T & B R R' ,`TaxAmount` = '2788' ,`TaxRate` = '1.9537' ,`WaterSewer` = 'Other Water/Sewer,Septic Tank' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '210380479' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:05:55.790' ,`MLSNumber` = '92852645' ,`ListAgentFullName` = 'Dustin Young' ,`ListOfficeName` = 'Compean Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804716' ,`Longitude` = '-95.368128' ,`PhotoCount` = '31' ,`PostalCode` = '77009' ,`RoomCount` = '6' ,`ListPrice` = '439000.00' ,`Status` = 'Active' ,`StreetName` = 'Canadian' ,`StreetNumber` = '214' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1934' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous recently remodeled home in the ever expanding Northside Village. Gorgeous modern kitchen, new paint, new bricks, new driveway, walkway, floors, counters, etc. Really is a home you have to see to believe. Set up your viewing today!' ,`Acres` = '0.1607' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 15 & TR 14 BLK 27 LINDALE PARK SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'JEFFERSON ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lindale Park Sec 05' ,`TaxAmount` = '6446' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1954' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '210548552' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:37:03.233' ,`MLSNumber` = '29681671' ,`ListAgentFullName` = 'Lisa Kornhauser' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734862' ,`Longitude` = '-95.414646' ,`PhotoCount` = '7' ,`PostalCode` = '77098' ,`RoomCount` = '0' ,`ListPrice` = '725000.00' ,`Status` = 'Active' ,`StreetName` = 'Colquitt' ,`StreetNumber` = '2239' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Seller is in the process of clearing the lot! Fantastic opportunity to build a new home in the highly desirable Upper Kirby area. This property sits on a 6,875 SF lot (55\' x 125\') and is blocks from upscale restaurants and shops. Seller has full set of plans not tied to any builder- can be made available to buyer with an acceptable offer.' ,`Acres` = '0.1578' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Upper Kirby' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 10 BLK 2 COLQUITT COURT SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Colquitt Court Sec 01' ,`TaxAmount` = '13180' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '210816881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:10:17.147' ,`MLSNumber` = '48954431' ,`ListAgentFullName` = 'Willian Garcia Mejia' ,`ListOfficeName` = 'Riverbend Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.421187' ,`Longitude` = '-95.032854' ,`PhotoCount` = '4' ,`PostalCode` = '77591' ,`RoomCount` = '3' ,`ListPrice` = '314990.00' ,`Status` = 'Active' ,`StreetName` = 'Crawford St' ,`StreetNumber` = '11004' ,`StreetSuffix` = '' ,`City` = 'Texas City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1821' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to you New HOME built by Cyrene Homes! In Section 2 of Cobblestone Subdivision, High ceilings with open floorplan will greet you as you enter this beautiful home! Kitchen is donned with a wonderful breakfast bar along with an \"eat-in\" area which then opens to the living area. The island includes plenty of seating and is perfect for entertaining or those grab and go mornings! Granite counter-tops, Stainless steel appliances are only a few things that make this home sparkle! All finishes and colors allow for soothing home feel that make you want to say, \"AAAHHHH\"...I\'m home! See our standard feature list for more details! We also have other floor plans available to build.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Cyrene' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Cobblestonee Lot 55 Blk 0' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'HUGHES ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Cobblestone' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '211025546' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:28:18.747' ,`MLSNumber` = '35923295' ,`ListAgentFullName` = 'Teresa Wagoner' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812883' ,`Longitude` = '-95.700822' ,`PhotoCount` = '26' ,`PostalCode` = '77084' ,`RoomCount` = '8' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Fern Shadows' ,`StreetNumber` = '19014' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2945' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful, large and exceptional one story home located on a quiet culdesac. 3 car garage, 2.5 baths, 2 AC zones, great floor plan, all rooms are large and comfortable. Large study can be used as 4th Bedroom or a gameroom or media room. Full size Dining Room with access to the kitchen. Huge family room opens to the kitchen and breakfast area with fire place. Oversized master suite with large bath and walk-in closet. Laminate flooring throughout, tile in family room and wet area, stainless steel appliances, large covered patio. Water softener, Close to schools, shopping and Restaurants! Katy ISD!' ,`Acres` = '0.185' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Katy - North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 1 OAK RIDGE PLACE SEC 2' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '8058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '545' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MAYDE CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAYDE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MAYDE CREEK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge Place Sec 02' ,`TaxAmount` = '6493' ,`TaxRate` = '2.487' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '211123423' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:11:04.570' ,`MLSNumber` = '20804352' ,`ListAgentFullName` = 'Gladys Lopez' ,`ListOfficeName` = 'Can-2 Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.772716' ,`Longitude` = '-95.170127' ,`PhotoCount` = '13' ,`PostalCode` = '77015' ,`RoomCount` = '6' ,`ListPrice` = '209900.00' ,`Status` = 'Active' ,`StreetName` = 'Muscatine' ,`StreetNumber` = '14231' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1064' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 bedroom starter home. Ready to move in. Close I-10 and Belt Way 8. \r\n Measurements are approximate Please verify room dimensions and schools.' ,`Acres` = '0.1326' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 17 BLK 102 CLOVER LEAF SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5775' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CLOVERLEAF ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Clover Leaf Sec 02' ,`TaxAmount` = '4182' ,`TaxRate` = '2.5853' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709386' WHERE `Matrix_Unique_ID` = '211360615' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:29:57.403' ,`MLSNumber` = '73966648' ,`ListAgentFullName` = 'Jorge Tenorio' ,`ListOfficeName` = 'Maxima Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.779914' ,`Longitude` = '-95.189339' ,`PhotoCount` = '34' ,`PostalCode` = '77015' ,`RoomCount` = '7' ,`ListPrice` = '251900.00' ,`Status` = 'Active' ,`StreetName` = 'Emporia' ,`StreetNumber` = '13335' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1609' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLER, REMODELED HOME THROUGHOUT, SUPER NICE PROPERTY AND READY TO BE SOLD four bedrooms two full bathrooms, new flooring, new kitchen, cabinets and pantry, tile work in master bath, freshly painted in and out, new water heather, brand new SS appliances, low maintenance, solar panels working perfect and saving a lot in energy (sellers got a check back from their energy company every year), large backyard ready to build your outdoor kitchen or pool NEVER FLOODED, send your offer now.' ,`Acres` = '0.1928' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1096 BLK 35 HOME OWNED ESTATES SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'CIMARRON ELEMENTARY SCHOOL (GALENA PARK)' ,`SchoolHigh` = 'NORTH SHORE SENIOR HIGH SCHOOL' ,`SchoolMiddle` = 'NORTH SHORE MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Home Owned Estates' ,`TaxAmount` = '3026' ,`TaxRate` = '2.7702' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211418499' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:02:22.883' ,`MLSNumber` = '88313721' ,`ListAgentFullName` = 'Peggy Dunne' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = 'Nicole Brende' ,`SellingOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`Latitude` = '29.758061' ,`Longitude` = '-95.475393' ,`PhotoCount` = '18' ,`PostalCode` = '77056' ,`RoomCount` = '12' ,`ListPrice` = '1825000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Holly Springs' ,`StreetNumber` = '5543' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3874' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME PROPERTY!!! Exceptional location for a RARE almost1/2 ACRE lot in the heart of exclusive TANGLEWOOD. Stunning OAK TREES frame the existing one-story dwelling which features 4 ensuite bedrooms, gracious formals, a large den with high ceiling, generous room sizes, and great storage throughout the home. The owner occupies the property and the home is very livable but Selling AS IS at LOT VALUE. This is a fabulous opportunity to either reimagine the existing home or build the home of your dreams on this premier lot just steps away from Tanglewood Boulevard, one of the most popular walking/jogging sites in Houston, and close to some of the city\'s finest shopping, restaurants, and vibrant business centers.' ,`Acres` = '0.4651' ,`Area` = '22' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Tanglewood Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 17 BLK 39 TANGLEWOOD SEC 9' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '20258' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BRIARGROVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Sec 09' ,`TaxAmount` = '31580' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211499943' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:33:29.167' ,`MLSNumber` = '53843135' ,`ListAgentFullName` = 'Megan Wall' ,`ListOfficeName` = 'Century 21 Olympian LakeJackson' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.034293' ,`Longitude` = '-95.567687' ,`PhotoCount` = '16' ,`PostalCode` = '77422' ,`RoomCount` = '6' ,`ListPrice` = '140000.00' ,`Status` = 'Active' ,`StreetName` = 'Brooks' ,`StreetNumber` = '1106' ,`StreetSuffix` = 'Street' ,`City` = 'Brazoria' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '768' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great investment property! 3 Bed 1 Bath, can be used for residential or commercial property. House needs a little TLC. New walk-in shower installed 2020 with a lifetime warranty.' ,`Acres` = '0.19' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 S F AUSTIN TRACT 9E1A-9E1E (DIV 13) ACRES 0.19 (BRAZOR' ,`LotDesciption` = 'Cleared' ,`LotSize` = '8276' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '1108' ,`TaxRate` = '2.3372' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211602119' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:49:10.523' ,`MLSNumber` = '48133612' ,`ListAgentFullName` = 'Donna Dufrene' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.904906' ,`Longitude` = '-94.412718' ,`PhotoCount` = '44' ,`PostalCode` = '75938' ,`RoomCount` = '8' ,`ListPrice` = '699000.00' ,`Status` = 'Active' ,`StreetName` = 'Elder' ,`StreetNumber` = '805' ,`StreetSuffix` = 'Street' ,`City` = 'Colmesneil' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3392' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peace and Tranquility! Imagine relaxing in the morning on a 900 ft. covered wrap around porch overlooking rolling hills with shaded trees. This lovely ranch style home has a huge kitchen/living/dining open concept adorned by high ceilings with beautiful beams. There is also a large family area/den, with vaulted ceilings which makes a great party area, game room or TV room. All bedrooms have their own private bath. Beautiful wood floors throughout the home. Home features a huge oversized garage. There is a 48K backup generator included along with a barn, stables, tack room and loafing shed for livestock. Included on property is a separate storage area ,2 basketball goals and an above ground pool for outdoor fun. Home is surrounded with built in mosquito sprayers and has a lasting metal roof. There is also a like-new, lovely mobile home included on the property that can be used for \r\nguests or a rental. No flooding ever, this is an absolutely must-see country living property!' ,`Acres` = '19.12' ,`Area` = '48' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tyler County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0009 W. CAMPBELL, ACRES 19.12' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '427 - Colmesneil' ,`SchoolElementary` = 'COLMESNEIL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLMESNEIL HIGH SCHOOL' ,`SchoolMiddle` = 'COLMESNEIL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Left Side,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Campbell' ,`TaxAmount` = '9105' ,`TaxRate` = '2.0383' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211674414' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:32:57.607' ,`MLSNumber` = '91510825' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'D.R. Horton Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.833384' ,`Longitude` = '-95.860744' ,`PhotoCount` = '22' ,`PostalCode` = '77493' ,`RoomCount` = '8' ,`ListPrice` = '452790.00' ,`Status` = 'Active' ,`StreetName` = 'Sunrise Gables' ,`StreetNumber` = '1561' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2599' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNBELIEVABLE NEW D. R. HORTON BUILT 4 BEDROOM! Sought-After Interior Layout with Primary Bedroom & Home Office/5th Bedroom Down! Impressive Two Story Foyer with Soaring Ceilings & Beautiful Staircase with Iron Railings! Luxurious Quartz Counters & Backsplash in Island Kitchen, Along with 42\" White Cabinetry with Under Cabinet Lighting, Oversized Island with Navy Cabinetry, & Farmhouse Style Sink! Du Pure Water Filtration System & Stainless Steel Whirlpool Appliances (Including 5 Burner Gas Cooktop)! First Floor Primary Suite with Walk-In Closet & Garden Bath! Three Big Secondary Bedrooms - AND Massive Gameroom/Media Room Up! Wood-Look Vinyl Plank Flooring, Fully Landscaped Front & Back Yards, Sprinkler System, Covered Patio, Tankless Water Heater by Rinnai, Smart Home Technology, PLUS MORE! Great Community with Pool, Tennis Courts, & Clubhouse! Easy Access to the Grand Parkway! Estimated Completion - February 2023.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'D. R. Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SUNTERRA 15 BLK 1 LOT 16' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'ROBERTSON ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.629' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211697486' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T14:05:27.833' ,`MLSNumber` = '44119716' ,`ListAgentFullName` = 'Lucinda Bright' ,`ListOfficeName` = 'KJ Platinum Properties LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.543650' ,`Longitude` = '-95.186204' ,`PhotoCount` = '50' ,`PostalCode` = '77546' ,`RoomCount` = '13' ,`ListPrice` = '394000.00' ,`Status` = 'Active' ,`StreetName` = 'Red Lantern' ,`StreetNumber` = '4803' ,`StreetSuffix` = 'Drive' ,`City` = 'Friendswood' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2286' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to this beautiful home nestled in the quaint neighborhood of Heritage Park. As you walk into the home, you are greeted by the open foyer and high ceilings, beautiful crown molding and well-maintained floors throughout the downstairs. On your left is a formal dining room that accesses the kitchen, large utility room, and guest bath. The kitchen is just gorgeous with new quartz counter tops and fresh paint. The primary bedroom is located on the first floor with lots of natural light, with an elegant bathroom that includes double sinks and a walk-in closet, separate jetted tub and shower. Upstairs there are 3 spacious bedrooms, a large game room and a shared bathroom. As you walk downstairs to the backyard, you are greeted by a nice patio, beautiful pool and nice backyard to entertain you guests. This home offers quick access to 45, parks, schools and lots of shopping! Don\'t let this one get away!' ,`Acres` = '0.2545' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Friendswood' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 5 HERITAGE PARK SEC 8 R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11087' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '387' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2212' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'WEDGEWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR BROOK HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Heritage Park Sec 08 R/P' ,`TaxAmount` = '5762' ,`TaxRate` = '2.166' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211709829' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-09-11T15:47:38.577' ,`MLSNumber` = '22989717' ,`ListAgentFullName` = 'Anna Ventura' ,`ListOfficeName` = 'Texas United Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.663178' ,`Longitude` = '-95.281946' ,`PhotoCount` = '26' ,`PostalCode` = '77061' ,`RoomCount` = '7' ,`ListPrice` = '232000.00' ,`Status` = 'Active' ,`StreetName` = 'WILMERDEAN' ,`StreetNumber` = '7626' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1484' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '3 bedrooms, 2 Bath, 2 Car garage. Beautiful property ready to move in, full of details, painted inside and out, 2021 AC/heater units, new electric box, both bathrooms updated, new light fixtures in living room, granite in Kitchen counter top, 30 years roof, new front door and new burglar bar door, new floors in Kitchen, dining room and living room. Big bonus:an enclose porch with gas stove and sink could be maybe an apartment or something else just add some extras details .' ,`Acres` = '0.1656' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 48 GLENBROOK VALLEY SEC 9' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7215' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LEWIS/Bellfort Academy' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Split Level,Traditional' ,`Subdivision` = 'Glenbrook Valley Sec 09' ,`TaxAmount` = '5904' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663709387' WHERE `Matrix_Unique_ID` = '211976142' --> 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','212391150','1663709388','212391150','2022-09-11T15:29:04.690','15178054','Gary Steuernagel','Keller Williams Realty -SW','','','29.674180','-95.697535','29','77407','8','400000.00','Active','Tenasserim Pine','18115','Trace','Richmond','3','0','4','2719','Single-Family','Mission Trace\'s beautiful 1 story, 4 bedrooms 3 baths plan, one of the largest one story plans in the area at 2,719 sq. ft. with extended tile and upgraded carpet floors throughout! Upgraded granite counter tops in the kitchen, ceramic tile, ceramic back splash, blinds throughout, island kitchen, ceiling fans with light fixtures, and so much more! Spacious kitchen with a huge kitchen island plus extra-large cabinets for extra storage and organization make this the perfect kitchen for daily living and for entertaining! Very large primary bedroom, The high ceilings and open concept are more energy efficient and thus have lower utility bills! This gorgeous home is loaded with upgrades. Has a sprinkler system and a large backyard! This home will not last!! Zoned to exemplary Fort Bend Schools. Convenient location. Close to major highways. Restaurants, shopping centers, banks, malls and schools nearby.','0.1722','37','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','0','Sugar Land West','Central Gas','1','MISSION TRACE SEC 3, BLOCK 1, LOT 28','Subdivision Lot','7500','Appraisal District','','700','0','','2','Electric Oven','0','','','Gas Range','','Composition','19 - Fort Bend','PATTERSON ELEMENTARY SCHOOL (FORT BEND)','TRAVIS HIGH SCHOOL (FORT BEND)','BOWIE MIDDLE SCHOOL (FORT BEND)','Appointment Required,Leave Business Card,No Supra Keybox','Appraisal District','1','Traditional','Mission Trace Sec 3','6800','2.4429','Water District','2015','Appraisal District'); --> 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','212405212','1663709388','212405212','2022-09-11T15:19:48.743','60110219','Beverly Bradley','Weekley Homes','','','29.447462','-95.396560','12','77578','7','419827.00','Active','Bronte','9306','Lane','Manvel','2','0','3','2090','Single-Family','Welcome to your beautiful new home in Meridiana, with all the space, style, and expert craftsmanship you need to live your best life. Your Owner’s Retreat makes it easy to rest and refresh in luxury with a contemporary en suite bathroom and a large walk-in closet. Put your interior design skills on display in the open-concept study, family room, dining area, and gourmet kitchen. The kitchen rests at the heart of this home, balancing impressive style with easy function, all while maintaining an open design that flows throughout the sunny living spaces. Both secondary bedrooms provide plenty of individual privacy and great places unique personalities to shine.\r\n \r\nAsk the David Weekley at Meridiana Team about the superb upgrades to the kitchen and Owner’s Bath of this new construction home in Manvel, Texas!','','5','David Weekley Homes','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Home Protection Plan,Mud,No Disclosures','1','','0','Alvin North','Central Gas,Zoned','1','Lot 04 Block 2','Subdivision Lot','','Survey','','1050','1','To Be Built/Under Construction','2','Convection Oven,Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','MERIDIANA ELEMENTARY SCHOOL','IOWA COLONY HIGH SCHOOL','CAFFEY JUNIOR HIGH SCHOOL','Appointment Required,Request Online Appointment,Vacant/Unoccupied','Builder','1','Contemporary/Modern,Traditional','Meridiana','','3.63','Water District','2022','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','212405779','1663709388','212405779','2022-09-11T14:02:30.493','35216262','Crystal Olenbush','AustinRealEstate.com','','','30.314565','-97.960031','3','78738','9','775000.00','Active','Senia','14404','Bend','Austin','3','1','4','2545','Single-Family','Located off of Bee Cave Parkway, across from the large Bee Cave Park with trails, pavilions, etc. Situated in a very walkable area and in the lowest tax rate for a planned community in the Lake Travis ISD at 1.8%. Less than 1 mile to the Hill Country Galleria. 4 Bedroom + Game Room + Formal Dining or Study, Two Story Ceilings in Family Room with Fireplace, Open Floor plan with Silestone countertops. All Appliances Convey. Priced to Sell!','0.137','83','','','','','Owner/Agent','','','1','','Central Gas','1','LOT 7 BLK D LADERA PHS 1','Other','5968','Appraisal District','','153','0','','2','','0','','','','','Composition','115 - Lake Travis','LAKE POINTE ELEMENTARY SCHOOL (LAKE TRAVIS)','LAKE TRAVIS HIGH SCHOOL','BEE CAVE MIDDLE SCHOOL','Appointment Required,No Supra Keybox','Appraisal District','2','Other Style','Ladera Ph 1','14444','1.8193','Public Water','2013','Appraisal District'); --> 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','212406031','1663709388','212406031','2022-09-11T14:45:59.597','40179909','Michael Gray','JPAR - The Sears Group','','','29.608710','-95.722420','22','77406','7','299900.00','Active','Country Place','2723','Drive','Richmond','2','0','4','2215','Single-Family','Back on the market...Beautiful Remodeled Split Level with No Rear Neighbors. Brand New 4 Ton A/C with New Duct Work Very rare home with upper deck where you can see miles of farm land with the most beautiful sunrises. 4 Bedrooms 2 Bathrooms with an oversized garage. This plan boasts a private Primary Downstairs with access to a covered patio. Second living area off primary bedroom gives this a private retreat for the owner with built ins and a fireplace. Home has a fully remodeled Kitchen with New Cabinets, Flooring, Backsplsh, Quartz Countertops, Farm Sink, Dishwasher, Gas Cooktop, Under Cabinet Microwave, Chimney Style Vent Hood, Dishwasher, Wine Bar and Custom Pantry Area around Refrigerator . Custom Touches include Barn Door Custom Beams Around Kitchen and Custom Farmhouse Curtains.','0.1568','37','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Fort Bend County North/Richmond','Central Gas','1','THE GROVE SEC 4, BLOCK 10, LOT 84, R/P','Greenbelt,In Golf Course Community','6829','Appraisal District','','195','0','','2','Electric Oven,Single Oven','0','','','Gas Cooktop','','Composition','33 - Lamar Consolidated','AUSTIN ELEMENTARY SCHOOL (LAMAR)','LAMAR CONSOLIDATED HIGH SCHOOL','WESSENDORF/LAMAR JUNIOR HIGH SCHOOL','Accompany,Appointment Required,Leave Business Card,Lockbox Front','Appraisal District','2','Split Level','The Grove Sec 4','4816','2.3298','Public Sewer,Public Water,Water District','1983','Appraisal District'); --> 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','212406485','1663709388','212406485','2022-09-11T15:40:27.630','91035248','Anika Bryant Williams','StepStone Realty LLC','','','29.575475','-95.237880','0','77089','4','380900.00','Active','Paintbrush Ledge','9506','Lane','Houston','2','1','4','2642','Single-Family','Just the home you\'re looking for! This traditional 2-story makes for a perfect family home, offering two primary bedrooms, one up and one down, both featuring en suite bathrooms with separate soaking tubs and showers plus double sinks. Secondary bedrooms are upstairs and share a guest bath also with double sinks. The formal dining is open to an entryway that leads to the family room open to a kitchen with ample counter and cabinet space plus stainless steel appliances. From the front porch to the backyard, there is plenty of room to enjoy outdoor relaxing or entertaining. So look no further! Appointments are available now so make yours TODAY!','0.2126','3','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Gas Connections','1','Southbelt/Ellington','Central Gas','1','LT 7 BLK 2 RIVERSTONE RANCH SEC 8','Subdivision Lot','9259','Appraisal District','','700','0','','2','Gas Oven','0','','','Freestanding Range,Gas Range','','Composition','41 - Pasadena','SOUTH BELT ELEMENTARY SCHOOL','DOBIE HIGH SCHOOL','THOMPSON INTERMEDIATE SCHOOL','Appointment Required,Lockbox Front,No Supra Keybox,Request Online Appointment','Appraisal District','2','Traditional','Riverstone Ranch','7265','2.7255','Water District','2003','Appraisal District'); --> New record created successfully