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-08-10T13:41:29.260' ,`MLSNumber` = '47305458' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.841513' ,`Longitude` = '-95.860283' ,`PhotoCount` = '9' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '509990.00' ,`Status` = 'Active' ,`StreetName` = 'Cape Capri' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Shea Home in a Gated section in the Sunterra Community. This beautiful home will have a stucco and stone exterior. The interior has gorgeous tray ceilings in the entry and primary room ceilings. Also, 3 bedrooms, 3 1/2 bathrooms, with stacking sliders, double ovens ,primary bay window, wood flooring, 8ft doors, valet bench that includes hooks for hanging, full gutters, Speaker prewire, 5.1 Surround Sound prewire, Smart home capabilities, and full sprinkler system.' ,`Acres` = '' ,`Area` = '26' ,`BuilderName` = 'Shea Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 29, block 1, Section 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7064' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1800' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Double Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BRYANT ELEMENTARY SCHOOL (KATY)' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Sunterra' ,`TaxAmount` = '' ,`TaxRate` = '3.53' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696662' WHERE `Matrix_Unique_ID` = '206963052' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:50:29.957' ,`MLSNumber` = '43962545' ,`ListAgentFullName` = 'Hester Bell' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.196330' ,`Longitude` = '-94.231674' ,`PhotoCount` = '40' ,`PostalCode` = '77657' ,`RoomCount` = '12' ,`ListPrice` = '4500000.00' ,`Status` = 'Active' ,`StreetName` = 'Keith' ,`StreetNumber` = '5880' ,`StreetSuffix` = '' ,`City` = 'Beaumont' ,`BathsFull` = '5' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '7861' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Step into another world in this exceptional estate in the heart of Southeast Texas! A masterpiece of details with stone brought in from West Texas, this is a once in a lifetime opportunity to experience every luxury you can imagine! Breathtaking scenery with a stocked pond, fish camp, garden with raised beds, greenhouse and chicken coop. Meditation grotto can be seen from the house just past the stone patio with oak tree canopy, cascading fountains and firepit. Inside the home are reclaimed wood beams from Louisiana, soaring cathedral ceilings and a floorplan that flows seamlessly from one room to the next. The dreamy gourmet kitchen features embossed tile ceiling, Wolf gas range, double ovens and dishwashers, Calacatta marble counters and an abundance of storage. Primary bedroom is a sanctuary with fireplace and private bath has walk-in shower, soaker tub and laundry room inside the closet. Spa room has inground stone hot tub and sauna. A stunning home with much, much more to offer!' ,`Acres` = '6.65' ,`Area` = '49' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '3' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LOT 154 CRESTWOOD ESTATES P#CRWE-154 I# 1733/479 9/14/05' ,`LotDesciption` = 'Cleared,Wooded' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '154 - Lumberton' ,`SchoolElementary` = 'LUMBERTON PRIMARY SCHOOL' ,`SchoolHigh` = 'LUMBERTON HIGH SCHOOL' ,`SchoolMiddle` = 'LUMBERTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Crestwood Estates' ,`TaxAmount` = '14252' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663696662' WHERE `Matrix_Unique_ID` = '207067717' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:51:24.273' ,`MLSNumber` = '84289624' ,`ListAgentFullName` = 'Joseph Ferrer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.390933' ,`Longitude` = '-95.112054' ,`PhotoCount` = '15' ,`PostalCode` = '77510' ,`RoomCount` = '6' ,`ListPrice` = '540000.00' ,`Status` = 'Active' ,`StreetName` = 'Shouse' ,`StreetNumber` = '3602' ,`StreetSuffix` = 'Road' ,`City` = 'Santa Fe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2016' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '6.797 ACRES OF LAND WITH A HOME IN THE HEART OF SANTA FE!!! Looking for place for a Country Home or a place to stable your horses??? Located Not far from HWY 6 and the Heart of Santa Fe. Come see this 1.5 story-4/3 home. Barn/Stables for Horses. Wood Back porch/deck. Pastures are gated and fenced. CALL TO SCHEDULE YOUR PRIVATE SHOWING!!!' ,`Acres` = '6.797' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Santa Fe' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 1 PAGE 10 S PT OF LOT 220 THAMANS 2ND SUB' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '296077' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '45 - Santa Fe' ,`SchoolElementary` = 'ROY J. WOLLAM ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SANTA FE HIGH SCHOOL' ,`SchoolMiddle` = 'SANTA FE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Thamans 2nd Sub 91' ,`TaxAmount` = '9482' ,`TaxRate` = '2.3536' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696662' WHERE `Matrix_Unique_ID` = '207357407' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:51:43.073' ,`MLSNumber` = '49716869' ,`ListAgentFullName` = 'Rallin Welch' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.747643' ,`Longitude` = '-95.438980' ,`PhotoCount` = '40' ,`PostalCode` = '77019' ,`RoomCount` = '13' ,`ListPrice` = '3799000.00' ,`Status` = 'Active' ,`StreetName` = 'Olympia' ,`StreetNumber` = '3800' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '5' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '6600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful recent built 2019 River Oaks home from Welch Builders! Exterior features include slate roof, copper\r\ngutters, flashing & chimney caps, aluminum clad insulated wood windows, steel double front door, slurried\r\nbrick exterior, antique Cedar Bayou brick accents, cedar exposed rafter tails & soffits, outdoor Isokern\r\nfireplace & loggia, and shutters. Interior features include Wolf & Subzero appliances, elevator two indoor\r\nIsokern fireplaces, foam insulation, LED lighting, Navien tankless heaters and exquisite finishes.' ,`Acres` = '0.1808' ,`Area` = '16' ,`BuilderName` = 'Welch Builders, LLC' ,`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` = '3' ,`GeoMarketArea` = 'River Oaks Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 39 BLK 82 RIVER OAKS SEC 11' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7875' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1986' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Other,Slate' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'RIVER OAKS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Photos/No Videos,No Supra Keybox,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'River Oaks' ,`TaxAmount` = '78739' ,`TaxRate` = '2.5264' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696662' WHERE `Matrix_Unique_ID` = '207632406' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:02:36.430' ,`MLSNumber` = '37588152' ,`ListAgentFullName` = 'Line Viens' ,`ListOfficeName` = 'RE/MAX Alliance' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.983093' ,`Longitude` = '-95.543698' ,`PhotoCount` = '44' ,`PostalCode` = '77069' ,`RoomCount` = '11' ,`ListPrice` = '435000.00' ,`Status` = 'Active' ,`StreetName` = 'Championship Lane' ,`StreetNumber` = '14207' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Golden opportunity to own this beautiful home in the established community of Champions Racket Club. Smart home, lights and security system can be controlled from anywhere through your phone. Remarkable engineered flooring, plantations shutters, double paned windows throughout. The tour begins at the extended 2 story foyer with a private study with French doors and elegant formal living and dining. The floor plan flows to a large open family room with double-sided fireplace. The chef of the family will love the gorgeous kitchen with double oven, island, granite counter tops, abundant white cabinets, oversized breakfast bar, walk-in pantry, and breakfast nook. The primary suite features double sinks, jetted tub, separate shower, and 2 closets. Upstairs you will find a large game room, 3 additional bedrooms and 2 full baths. Home theater system included. The backyard is very private with extensive wood deck and gazebo. If you have been waiting for a lovely home, don\'t look further!!!!' ,`Acres` = '' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 2 BLK 1 Champions Racquet Club' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '9375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'YEAGER ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Champions Racquet Club' ,`TaxAmount` = '9288' ,`TaxRate` = '2.51' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696662' WHERE `Matrix_Unique_ID` = '208884230' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:49:27.590' ,`MLSNumber` = '32790218' ,`ListAgentFullName` = 'Jesse Strickler' ,`ListOfficeName` = 'Cameron Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.363600' ,`Longitude` = '-95.174800' ,`PhotoCount` = '23' ,`PostalCode` = '77328' ,`RoomCount` = '11' ,`ListPrice` = '249500.00' ,`Status` = 'Active' ,`StreetName` = 'Smith' ,`StreetNumber` = '421' ,`StreetSuffix` = 'Lane' ,`City` = 'Cleveland' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1228' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You have to hear this place to believe it!! Sweet little house in the woods. Secluded, peaceful, partially wooded lot surrounded by intact forest. Recently painted inside and power washed and painted exterior. Newly replaced flooring in primary bathroom. Large screened porch, as well as generously sized front and back covered porches. Currently 2 bedroom, utility room could be used as another bedroom as the square footage is the same as the secondary bedroom. There is a workshop area attached to the house that could be used as a laundry room or utilized to expand the home. storage room attached to carport as well as an enclosed well house, with enough space to serve as a garden. fridge, washer, dryer, and chest freezer are included' ,`Acres` = '2.56' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Coldspring/South San Jacinto County' ,`HeatSystem` = 'Central Gas,Propane' ,`HOAMandatory` = '0' ,`Legal` = 'A196 SAMUEL LUSK, TRACT 170, ACRES 2.56' ,`LotDesciption` = 'Wooded' ,`LotSize` = '111514' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NONE' ,`TaxAmount` = '2590' ,`TaxRate` = '1.9249' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696662' WHERE `Matrix_Unique_ID` = '209129270' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:48:11.277' ,`MLSNumber` = '5377922' ,`ListAgentFullName` = 'Roxie Krisher Hippard' ,`ListOfficeName` = 'Krisher-McKay, Inc., REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.900586' ,`Longitude` = '-95.026394' ,`PhotoCount` = '29' ,`PostalCode` = '77532' ,`RoomCount` = '5' ,`ListPrice` = '874900.00' ,`Status` = 'Active' ,`StreetName` = 'Bohemian Hall' ,`StreetNumber` = '14823' ,`StreetSuffix` = 'Road' ,`City` = 'Crosby' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a rare find...15.95 acres m/l with two barns**One barn is 36\'36\' with a 15\' overhang.**This barn has four stalls**Each stall is 12\'x12\'**Tack room is 24\'x12\'** The other barn is a shed row style 18\'x48\' including a chicken pen and storage area. Ideal for horse boarding. This is a great property for your livestock. Beautiful crossed fenced pastures with a pond. Mature tree lined property**Unrestricted**The house has a fully fenced yard with a covered breezeway that leads to a oversized 2 car garage**Great location and easy access to I-10, HWY 90 and the new Grand parkway**Plenty of room to build your dream home**' ,`Acres` = '15.95' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'PT TR 6A (HOMESITE) ABST 805 T TOBY' ,`LotDesciption` = 'Other' ,`LotSize` = '694782' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'T Toby' ,`TaxAmount` = '1844' ,`TaxRate` = '2.0943' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '209338337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:20:21.633' ,`MLSNumber` = '34287699' ,`ListAgentFullName` = 'John Petty' ,`ListOfficeName` = 'John Petty, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.890965' ,`Longitude` = '-96.163656' ,`PhotoCount` = '17' ,`PostalCode` = '77440' ,`RoomCount` = '3' ,`ListPrice` = '95000.00' ,`Status` = 'Active' ,`StreetName` = 'State Hwy 35' ,`StreetNumber` = '12165' ,`StreetSuffix` = '' ,`City` = 'Elmaton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1728' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'On over 2 acres of land, this country home is the perfect property! With a new metal roof and flex piping, only a bit more TLC needed for this rural home. Three barns and plenty of storage. Great investment opportunity!' ,`Acres` = '2.09' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 0051, T JAMISON, TRACT 14 - PT LT, ACRES 2.09, EL MATON F' ,`LotDesciption` = 'Other' ,`LotSize` = '91040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '133 - Tidehaven' ,`SchoolElementary` = '' ,`SchoolHigh` = 'TIDEHAVEN HIGH SCHOOL' ,`SchoolMiddle` = 'TIDEHAVEN INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style,Ranch,Traditional' ,`Subdivision` = 'El Maton Farms Sub' ,`TaxAmount` = '1620' ,`TaxRate` = '1.8566' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1987' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '209572782' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:31:48.090' ,`MLSNumber` = '86244200' ,`ListAgentFullName` = 'Elaine Marak' ,`ListOfficeName` = 'Elaine Marak Real Estate' ,`SellingAgentFullName` = 'David Karstedt' ,`SellingOfficeName` = '1st Texas, Realtors' ,`Latitude` = '29.495943' ,`Longitude` = '-95.144850' ,`PhotoCount` = '49' ,`PostalCode` = '77573' ,`RoomCount` = '4' ,`ListPrice` = '399900.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Creekside' ,`StreetNumber` = '231' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2533' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy Creekside Estates Lifestyle! Popular Wycoff custom home, all brick, gated drive and more! Private location with no back neighbors and large back yard. Open concept interior includes both formals or dining and study, large open family room with fireplace and built-ins, wall of windows overlooking patio. Chef style kitchen with gas cooking, island, lots of custom cabinets, huge custom tandem pantry, big breakfast area and more! Huge utility room inside off guest half bath. Split plan with large main bedroom and bath, big tub, double sinks. Recent updates include roof and hvac system. Don\'t miss this, ready for move-in today!' ,`Acres` = '0.2755' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 9 J DICKINSON SUR LOT 7 BLK 1 CREEKSIDE ESTATES SEC 1 *' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'HALL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Creekside Estates Sec 1 93' ,`TaxAmount` = '6796' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1993' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '210056866' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:17:24.033' ,`MLSNumber` = '84253492' ,`ListAgentFullName` = 'Tammi Freund' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.465890' ,`Longitude` = '-95.252060' ,`PhotoCount` = '41' ,`PostalCode` = '77511' ,`RoomCount` = '8' ,`ListPrice` = '305000.00' ,`Status` = 'Active' ,`StreetName` = 'Kendall Cove' ,`StreetNumber` = '5183' ,`StreetSuffix` = 'Court' ,`City` = 'Alvin' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1802' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOM HOME!! Come see your future home, beauty in the heart of KENDALL LAKES!! Gorgeous 2015 Home has everything you are looking for!! This beautiful 4 bedroom 2 bath plus an office-Welcomes you with a beautiful entry way, high ceilings and your dream kitchen with beautiful granite countertops. Open concept to living room, perfect size back yard and covered palapa. Imagine yourself barbecuing and enjoying family time in your Palapa! You are going to love your primary bedroom and bathroom including the two separate sinks, tub, stand up shower and walk in closet. The home offers beautiful flooring throughout, is also situated near the end of cul-de-sac street and much more! COME SEE YOUR FUTURE HOME TODAY!!' ,`Acres` = '0.131' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'KENDALL LAKES SEC 3 (A0482 HT&BRR)(ALVIN) BLK 2 LOT 9' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '5706' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'MARK TWAIN ELEMENTARY SCHOOL (ALVIN)' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kendall Lakes Sec 3' ,`TaxAmount` = '7783' ,`TaxRate` = '3.5854' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '210428484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:43:04.760' ,`MLSNumber` = '30435892' ,`ListAgentFullName` = 'Brooke White' ,`ListOfficeName` = 'Sprout Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.351974' ,`Longitude` = '-95.542988' ,`PhotoCount` = '11' ,`PostalCode` = '77304' ,`RoomCount` = '5' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'La Salle' ,`StreetNumber` = '12090' ,`StreetSuffix` = 'Branch' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2538' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come see this immaculate, completely updated home... EVERYTHING IS NEW ON THE INSIDE!!!!! New sheetrock, tile, carpet, counters, appliances, roof, HVAC system, and even new plumbing! This beautiful house boasts quartz countertops, subway tile backsplash, stainless appliances, gas stove top, built in microwave with vent hood, massive pantry, many gorgeous built-ins throughout home, covered pergola patio, upgraded carpet! Trees in back yard to be freshly pruned and manicured soon...This home is completely TURNKEY, beautifully designed and clean - move in ready TODAY!' ,`Acres` = '0.1584' ,`Area` = '19' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LA SALLE CROSSING 01 (WESTLAKE), BLOCK 3, LOT 47' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'GORDON-REED ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'La Salle Crossing 01 Westlake' ,`TaxAmount` = '5965' ,`TaxRate` = '2.8638' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '210707946' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:38:51.597' ,`MLSNumber` = '74536205' ,`ListAgentFullName` = 'Eric Johnson' ,`ListOfficeName` = 'L. Custen Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.888734' ,`Longitude` = '-95.521646' ,`PhotoCount` = '9' ,`PostalCode` = '77040' ,`RoomCount` = '2' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Ridge' ,`StreetNumber` = '8347' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large lot in quiet neighborhood. Home needs a little TLC, but great starter home or investment property. One of the largest lots in the neighborhood!' ,`Acres` = '0.0781' ,`Area` = '11' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'HOA First Right of Refusal,Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TRS 40B & 41B BLK 3 S PT LT 41 COURTYARD HOMES 3 SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '230' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'REED ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'DEAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Courtyard Homes 03 Sec 01' ,`TaxAmount` = '3884' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1983' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '210959505' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:02:43.963' ,`MLSNumber` = '59435525' ,`ListAgentFullName` = 'Jude Nassar' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.755388' ,`Longitude` = '-95.569564' ,`PhotoCount` = '37' ,`PostalCode` = '77042' ,`RoomCount` = '7' ,`ListPrice` = '580000.00' ,`Status` = 'Active' ,`StreetName` = 'Tupper Lake' ,`StreetNumber` = '10827' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2738' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NICE 4 BEDROOM 2 1/2 BATH SPACIOUS HOME, NEWER FLOORING, STAINLESS APPLIANCES, NEWER UPGRADES DONE BEFORE TENANT MOVED IN, WELL TAKEN CARE OF, LARGE LIVING ROOM PERFECT FOR FAMILY GATHERINGS WITH FIREPLACE, NICE SIZE BACKYARD WITH POOL FOR ENTERTAINING AND ENJOYING THOSE HOT SUMMER DAYS, HOME IS CONVENIENTLY LOCATED CLOSED TO SHOPPING CENTERS AND RESTAURANTS. MUST SEE TO APPRECIATE' ,`Acres` = '0.2649' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 6 LAKESIDE FOREST SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11537' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '811' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WALNUT BEND ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lakeside Forest Sec 02' ,`TaxAmount` = '11251' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696663' WHERE `Matrix_Unique_ID` = '211005374' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:02:23.153' ,`MLSNumber` = '52751677' ,`ListAgentFullName` = 'Jude Nassar' ,`ListOfficeName` = 'Vibrant Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.773127' ,`Longitude` = '-95.638413' ,`PhotoCount` = '50' ,`PostalCode` = '77079' ,`RoomCount` = '8' ,`ListPrice` = '440000.00' ,`Status` = 'Active' ,`StreetName` = 'Cranberry Hill' ,`StreetNumber` = '923' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home with private patio in a quiet cul-de-sac, conveniently located in the Energy Corridor, home features 3 bedrooms 2 1/2 bath, master bedroom downstairs with private patio, huge living room perfect for entertaining, spacious kitchen with all stainless steel appliances, garage is located in the alley, easy access to shopping centers, close to City Centre and walking distance to Terry Hershey Park. This house is a must see to appreciate.' ,`Acres` = '0.1039' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Seller may be subject to foreign tax and Buyer withholding per IRS,Sellers Disclosure,Tenant Occupied' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BLK 1 FLEETWOOD WEST SEC 1' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4528' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'WOLFE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TAYLOR HIGH SCHOOL (KATY)' ,`SchoolMiddle` = 'MEMORIAL PARKWAY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fleetwood West 1' ,`TaxAmount` = '9333' ,`TaxRate` = '2.4889' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696664' WHERE `Matrix_Unique_ID` = '211058043' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T12:14:13.827' ,`MLSNumber` = '17133071' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Legend Home Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.051441' ,`Longitude` = '-95.359401' ,`PhotoCount` = '23' ,`PostalCode` = '77373' ,`RoomCount` = '6' ,`ListPrice` = '309990.00' ,`Status` = 'Active' ,`StreetName` = 'Yellow Ginko' ,`StreetNumber` = '4826' ,`StreetSuffix` = 'Trail' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in Cypresswood Landing in Spring, TX! Conveniently located with easy access to Grand Parkway, I-45, FM 1960, and I-69 - commuting to the Energy Corridor, The Woodlands, or Bush Intercontinental Airport is a breeze! The Shannon plan is a spacious 2-story home with 4 bedrooms (1 Guest Suite down, 3 up), 3.5 bathrooms, and a 2-car garage. With an open kitchen, dining, and family room - you\'ll love entertaining in this home! The gourmet kitchen is sure to please with 42\" cabinets, granite countertops and stainless steel appliances! Upstairs features a private retreat for all the bedrooms! Retreat to the Owner\'s Suite featuring a garden tub and shower and a walk-in closet! Enjoy the great outdoors with a covered patio! Don’t miss your opportunity to call Cypresswood Landing home, schedule a visit today!' ,`Acres` = '' ,`Area` = '12' ,`BuilderName` = 'LEGEND HOMES' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 7 BLK 4 CYPRESSWOOD LANDING SEC. 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4000' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'CHET BURCHETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING HIGH SCHOOL' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Cypresswood Landing' ,`TaxAmount` = '' ,`TaxRate` = '2.61' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696664' WHERE `Matrix_Unique_ID` = '211168036' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T13:21:03.840' ,`MLSNumber` = '96590337' ,`ListAgentFullName` = 'Paula Smith' ,`ListOfficeName` = 'Insight Realty Network' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816870' ,`Longitude` = '-94.978756' ,`PhotoCount` = '11' ,`PostalCode` = '77521' ,`RoomCount` = '11' ,`ListPrice` = '298999.00' ,`Status` = 'Active' ,`StreetName` = 'Cinnamon Lake' ,`StreetNumber` = '5406' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3018' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous two story home. Beautiful grand foyer at the entry with contemporary style openings to kitchen and breakfast area great for entertainment.' ,`Acres` = '0.1286' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 SPRINGFIELD ESTATES SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5603' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '340' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'VICTORIA WALKER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GOOSE CREEK MEMORIAL' ,`SchoolMiddle` = 'HIGHLANDS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Springfield Estates Sec' ,`TaxAmount` = '6696' ,`TaxRate` = '3.095' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663696664' WHERE `Matrix_Unique_ID` = '211257815' --> Updated record success