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-17T09:41:57.463' ,`MLSNumber` = '20016531' ,`ListAgentFullName` = 'Brittany Hantz' ,`ListOfficeName` = 'Keller Williams Elite' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.804977' ,`Longitude` = '-94.908903' ,`PhotoCount` = '3' ,`PostalCode` = '77521' ,`RoomCount` = '6' ,`ListPrice` = '347149.00' ,`Status` = 'Active' ,`StreetName` = 'Brooks crossings' ,`StreetNumber` = '8026' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2070' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beauty is a 4 bedroom and 2 bath new home floor plan that offers a study at the entry, an open kitchen and spacious family room, an oversized master bedroom with a large walk-in closet, 3 secondary bedrooms, a convenient walk-in utility room, and a rear covered patio! Call today and make this house your home!' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'Anglia Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Chambers County' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = '12/1/4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '370' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'CLARK ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'GENTRY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'lynwood' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '204273527' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:53:46.807' ,`MLSNumber` = '45535511' ,`ListAgentFullName` = 'Gaynell Blackshear' ,`ListOfficeName` = 'Blackshear Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.748177' ,`Longitude` = '-94.948343' ,`PhotoCount` = '48' ,`PostalCode` = '77520' ,`RoomCount` = '6' ,`ListPrice` = '310000.00' ,`Status` = 'Active' ,`StreetName` = 'Windy' ,`StreetNumber` = '1304' ,`StreetSuffix` = 'Lane' ,`City` = 'Baytown' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home or business on 1/2 acre with room for all your big boy toys: RV\'s, trailers, side by sides, hunting gear, fishing gear and all the other things for fun. Ton\'s of storage and room outdoors. This would even be a great commercial property for a business/home. Located in the city limits of Baytown, no HOA and no restrictions on 1/2 acre! Lovely redone home with converted garage to large living area, updated flooring throughout, walls, paint, newer windows and newer roof. There are many new additions to this home from an super nice covered and concrete RV area, 16x16 storage with covered porches on two sides. An add on covered back patio and porch , 20x16 for your outdoor enjoyment. Also, a three car carport in front. Huge open side yard with shade trees for those family get-to-gathers, crawfish boils, parties and birthdays and enough room to play football! The home is fully fenced back and front. No HOA, NO RESTRICTIONS. REDUCED.' ,`Acres` = '0.6569' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Baytown/Harris County' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 & TR 6A BLK 2 GENNY GLENN U/R ABST 118 W BRITTON' ,`LotDesciption` = 'Other' ,`LotSize` = '28614' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '23 - Goose Creek Consolidated' ,`SchoolElementary` = 'JAMES BOWIE ELEMENTARY SCHOOL (GOOSE CREEK)' ,`SchoolHigh` = 'STERLING HIGH SCHOOL (GOOSE CREEK)' ,`SchoolMiddle` = 'CEDAR BAYOU J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'w Britton' ,`TaxAmount` = '3446' ,`TaxRate` = '2.97' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '205305004' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T08:39:08.973' ,`MLSNumber` = '73210576' ,`ListAgentFullName` = 'Arleen Murillo' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734320' ,`Longitude` = '-95.315546' ,`PhotoCount` = '6' ,`PostalCode` = '77023' ,`RoomCount` = '3' ,`ListPrice` = '799900.00' ,`Status` = 'Active' ,`StreetName` = 'Hughes' ,`StreetNumber` = '610' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location, Home is selling for Lot Value Only. Tenant Occupied please do not disturb tenants.\r\nInvestor Special, no restrictions. Builder\'s Dream with Lots of Opportunity to Build. Call today!' ,`Acres` = '0.514' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 12 & 13 LUNNON' ,`LotDesciption` = 'Cleared' ,`LotSize` = '22391' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CARRILLO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AUSTIN HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lunnon' ,`TaxAmount` = '6315' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1940' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '205434079' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:28:41.123' ,`MLSNumber` = '28577262' ,`ListAgentFullName` = 'DeAnna Green' ,`ListOfficeName` = 'Nydan Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.658608' ,`Longitude` = '-95.492991' ,`PhotoCount` = '18' ,`PostalCode` = '77096' ,`RoomCount` = '11' ,`ListPrice` = '395000.00' ,`Status` = 'Active' ,`StreetName` = 'Dunlap' ,`StreetNumber` = '11107' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous renovated home w/custom design finishes! Completely re-imagined home featuring many upgrades w/ open concept living. Huge family room open to spacious kitchen. Kitchen has designer 42\" cabinets with black and gold finishing\'s. Granite countertop and tiled backsplash, SS appliances, electric cooktop w/built in oven, under counter microwave, dishwasher. New light fixtures, ceiling fans (w/remotes), and interior doors. Fresh paint inside & out, hardware, baseboards. New flooring throughout-NO carpet! Primary retreat w/attached bonus room, could be office, nursery, HUGE dressing room! Primary bath has black & gold fixtures, gorgeous vanity w/granite counter, dual sinks, OVERSIZED stand alone shower with marble finishes & seamless glass. Hall bath also completely remodeled w/subway tile tub surround, vanity w/marble counter & lots of cabinetry. Third bathroom has stand alone shower! Close to Westbury Park & the highly rated Parker Elementary. NO FLOOD-not in floodplain!' ,`Acres` = '0.1873' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'N 2 FT OF LT 10 & S 66 FT OF LT 11 BLK 161 WESTBURY SEC 5' ,`LotDesciption` = 'Other' ,`LotSize` = '8160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'PARKER ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'MEYERLAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Westbury Sec 05' ,`TaxAmount` = '6204' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1963' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '206361774' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T08:57:46.980' ,`MLSNumber` = '15886207' ,`ListAgentFullName` = 'George Koutros' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.790564' ,`Longitude` = '-95.537630' ,`PhotoCount` = '32' ,`PostalCode` = '77055' ,`RoomCount` = '10' ,`ListPrice` = '799000.00' ,`Status` = 'Active' ,`StreetName` = 'Cedardale' ,`StreetNumber` = '9906' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2095' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Massive Renovation, and NEVER Flooded! This home features a Garage Living Space that includes a Dishwasher, Refrigerator, Bathroom and A/C which also cools the garage so it can be used as an additional work, or crafts space. The Large Pool also has an Outdoor Kitchen which is perfect for hosting all events. Home was taken down to the studs, and has a recently installed Roof, Electrical Wiring, Fixtures, Plumbing, and a Tankless Water Heater. The kitchen features an Enormous Island with Stainless Steel Appliances, amazing Granite Counter-Tops, and Gas Range. The location is second to none! Only 15 minutes to Downtown Houston. Minutes to City Centre, Memorial City Mall, Grocery Stores, and several High-End Retail Stores.' ,`Acres` = '0.1928' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 26 BLK 5 SPRING BRANCH WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1111111' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Spring Branch Woods Sec 01' ,`TaxAmount` = '13553' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1958' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '208625436' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:48:41.367' ,`MLSNumber` = '91094630' ,`ListAgentFullName` = 'Charles Chou' ,`ListOfficeName` = 'TreeGrace Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.685788' ,`Longitude` = '-95.440269' ,`PhotoCount` = '33' ,`PostalCode` = '77025' ,`RoomCount` = '7' ,`ListPrice` = '510000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodshire Village' ,`StreetNumber` = '4028' ,`StreetSuffix` = 'Estate' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location! Location! Location! Immaculate 3/3.5/2, 2019 construction nestles in a quaint gated community! Beautiful wood floors on first and second floors. Third floor primary and secondary bedrooms has carpet. High ceilings throughout the entire house. Spacious kitchen/living, kitchen has Bosch appliances, soft closing drawers. Fire place has gas log. Two balconies expands the living area. Extra large lot for garden opportunity. House is right next to the community parking lots, providing additional parking space and convenience to the house. Minutes to medical center, 610 south loop, Galleria area, Greenway plaza and downtown. Zoned to prestigious Bellaire High School. Existing washer and dryer stay with the house. House is in flood zone but has elevated foundation to eliminate the hazards and substantially reduced flood insurance. A rare found around medical center! Call for a private showing today!' ,`Acres` = '0.0621' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Knollwood/Woodside Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'TR 12A BLK 1 WOODSHIRE VILLAGE ESTATES' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '2705' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '234' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LONGFELLOW ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'WOODSHIRE VILLAGE ESTATES' ,`TaxAmount` = '11973' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '208803497' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:31:48.520' ,`MLSNumber` = '45677904' ,`ListAgentFullName` = 'Nikola Knezevic' ,`ListOfficeName` = 'NB Elite Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.899498' ,`Longitude` = '-93.975846' ,`PhotoCount` = '22' ,`PostalCode` = '77640' ,`RoomCount` = '4' ,`ListPrice` = '219900.00' ,`Status` = 'Active' ,`StreetName` = '48th' ,`StreetNumber` = '404' ,`StreetSuffix` = '' ,`City` = 'Port Arthur' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2468' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ready for immediate move-in! Nice large 4 bedroom 3 bath condo... Beautiful open kitchen with island...Large Livingroom with fireplace...NEW Carpet in all bedrooms...Stainless steel appliances...Look no further this home has it all and is move in ready!' ,`Acres` = '' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Corporate Listing,Owner/Agent,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'N 1/2 OF LT 4 BLK 4 HIGHLAND ADD' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = '' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'HIGHLAND TO PORT ARTHUR Class 4' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663699768' WHERE `Matrix_Unique_ID` = '208822091' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:54:13.823' ,`MLSNumber` = '4145942' ,`ListAgentFullName` = 'John Stanley' ,`ListOfficeName` = 'RE/MAX Associates Northeast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.924564' ,`Longitude` = '-95.294265' ,`PhotoCount` = '19' ,`PostalCode` = '77396' ,`RoomCount` = '11' ,`ListPrice` = '280000.00' ,`Status` = 'Active' ,`StreetName` = 'Ravendale' ,`StreetNumber` = '14106' ,`StreetSuffix` = 'Road' ,`City` = 'Humble' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TONS OF ROOM HERE...OLDER HOME LOCATED IN A QUIET NEGHBORHOOD OF HUMBLE WITH AN ABOVE GROUND POOL, WELL, SEPTIC, NO HOA AND LOW TAXES. REMODELLED SEVERAL YEARS AGO, TILED FLOORS,CABINETS, BLACK APPLIANCES,GRANITE COUNTER-TOPS. SITS ON TWO LOTS WITH PLENTY OF ROOM FOR CHILDREN TO PLAY. COULD EASILY BE A FIVE OR SIX BEDROOM HOME IF SOMEONE IS LOOKING FOR MORE SLEEPING AREA. ALL ROOMS ARE OF EXCELLENT SIZE.....YOU WON\'T BE DISAPPOINTED.' ,`Acres` = '0.1664' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 217 & 218 BLK 1O HUMBLE ROAD PLACE' ,`LotDesciption` = 'Cleared' ,`LotSize` = '14250' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'JOHNSON ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'MACARTHUR HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'ALDINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Humble Road Place' ,`TaxAmount` = '2097' ,`TaxRate` = '2.1553' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '209510897' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T08:47:00.673' ,`MLSNumber` = '36246565' ,`ListAgentFullName` = 'Jose Avila' ,`ListOfficeName` = 'CCD Ventures' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.653067' ,`Longitude` = '-95.504122' ,`PhotoCount` = '32' ,`PostalCode` = '77035' ,`RoomCount` = '9' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Teal Run' ,`StreetNumber` = '6411' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1966' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'INVESTOR/RENTAL OPPORTUNITY. This home has 3 bedrooms, 2 baths, 2 car garage, a formal dining room, a big living room, and a private study or a work room if you are working from home. The home is sold as-is and the seller will not do any repairs. The roof was replaced in 2020, A/C was replaced in 2017, and some parts of the house have Flex Plumbing. Work needed mostly cosmetics. THIS PROPERTY HAS NEVER FLOODED PER THE SELLER.' ,`Acres` = '0.1159' ,`Area` = '20' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Brays Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 23 BLK 1 SOUTHWOOD PLACE SEC 1' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5050' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HALPIN/TINSLEY' ,`SchoolHigh` = 'WESTBURY HIGH SCHOOL' ,`SchoolMiddle` = 'FONDREN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Southwood Place Sec 01' ,`TaxAmount` = '2564' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1977' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '209526507' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:52:12.990' ,`MLSNumber` = '77305247' ,`ListAgentFullName` = 'James Dolson' ,`ListOfficeName` = 'Berkshire Hathaway HomeServicePremier Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.714350' ,`Longitude` = '-95.098583' ,`PhotoCount` = '6' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '65000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 3277' ,`StreetNumber` = '2072' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '884' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Home is a 2 bedroom, 1 bath fixer upper with a nice size lot.' ,`Acres` = '0.3444' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'NUGENT\'S COVE SECTION 2 BLK 3 LOT 1 & 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nugents Cove Sec 2' ,`TaxAmount` = '1239' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '209857376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T08:49:18.700' ,`MLSNumber` = '37455426' ,`ListAgentFullName` = 'Derek Nemec' ,`ListOfficeName` = 'Bay City Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.979173' ,`Longitude` = '-95.951293' ,`PhotoCount` = '12' ,`PostalCode` = '77414' ,`RoomCount` = '4' ,`ListPrice` = '147900.00' ,`Status` = 'Active' ,`StreetName` = '3rd' ,`StreetNumber` = '3300' ,`StreetSuffix` = 'Street' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1159' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New listing! This home has newer PEX plumbing, hardwood flooring in the majority of the home, and a oversized fenced in backyard. This 3 bedroom 1.5 bath is absolutely move-in ready at a price that cannot be beat! This brick home is right next to an elementary school and situated in a convenient place in town. This home is easy to see!' ,`Acres` = '0.2033' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'VAUGHN S/D, LOT 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8856' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vaughn Sub' ,`TaxAmount` = '2242' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '210585832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:21:12.653' ,`MLSNumber` = '24770546' ,`ListAgentFullName` = 'Danish Rehman' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.160167' ,`Longitude` = '-95.445501' ,`PhotoCount` = '29' ,`PostalCode` = '77385' ,`RoomCount` = '9' ,`ListPrice` = '449000.00' ,`Status` = 'Active' ,`StreetName` = 'Kane' ,`StreetNumber` = '27218' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2760' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous remodeled 4 bed and 2 bath, one story home in a very desirable area of Oak Ridge North just minutes away from Woodlands Mall. Updates done through out the house which is not limited to new paint inside and out, remodeled kitchen with quarts countertops, custom island, updated no slam cabinets, sink, faucet, stainless steel appliances and light fixtures, wood look tile in the study, dining, kitchen and living area. Curved brick gas log fireplace in the living area. The bathrooms have granite countertops, a new bathtub, double sinks and newer light fixtures. Updated double pane windows and plush carpet in the bedrooms. A spacious game room has wood floors, bookshelves and a large closet with more shelves storage. Backyard feature a cover patio and wood deck for entertainment. Also only 2 year old rood and water heater.' ,`Acres` = '0.2534' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'S764007 - OAK RIDGE NORTH 07, BLOCK 12, LOT 22' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'OAK RIDGE ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'OAK RIDGE HIGH SCHOOL' ,`SchoolMiddle` = 'IRONS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Controlled Access,Leave Business Card,Lockbox Back,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Ridge North 07' ,`TaxAmount` = '6267' ,`TaxRate` = '2.321' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1968' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '210968275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:20:09.570' ,`MLSNumber` = '2588031' ,`ListAgentFullName` = 'Diana Mercado' ,`ListOfficeName` = 'LMS Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.782622' ,`Longitude` = '-95.390361' ,`PhotoCount` = '8' ,`PostalCode` = '77007' ,`RoomCount` = '5' ,`ListPrice` = '750000.00' ,`Status` = 'Active' ,`StreetName` = '6th 1/2' ,`StreetNumber` = '637' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1210' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Property is being sold for lot value. One of the last big lots located on this street, right in the heart of Houston Heights! Great opportunity for a new home with a hug yard, big enough for a pool with plenty of green space left. Mature trees provide plenty of shade ffrom this Texas Heat. Located within walking distance to many local restaurants and bars, parks, jogging trails and zoned to great schools. Commute to Downtown, Galleria or Energy Corridor is under 20 minutes! \r\n\r\nViewing of lot only, please request at least 24 hours in advance for viewing of the owner occupied home.\r\nOwner related to Agent.' ,`Acres` = '0.2169' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'TR 5B TAYLOR E A TRACT ABST 1 J AUSTIN' ,`LotDesciption` = 'Other' ,`LotSize` = '9450' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'HARVARD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'HEIGHTS' ,`TaxAmount` = '10920' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1920' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '211115326' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:20:34.777' ,`MLSNumber` = '26267097' ,`ListAgentFullName` = 'Amanda Walsh' ,`ListOfficeName` = 'Keller Williams Realty - Memorial' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798220' ,`Longitude` = '-95.576099' ,`PhotoCount` = '27' ,`PostalCode` = '77043' ,`RoomCount` = '9' ,`ListPrice` = '515000.00' ,`Status` = 'Active' ,`StreetName` = 'Wrenwood' ,`StreetNumber` = '10938' ,`StreetSuffix` = 'Green' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2798' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'IMPRESSIVE & SOPHISTICATED FREESTANDING townhome in the beautiful, gated Upland Park community. You will marvel over the countless upgrades & how well-appointed this gorgeous French-inspired beauty really is! Stunning wood flooring throughout paired with fabulous kitchen cabinetry upgraded to offer additional upper storage space & charming glass fronts for display (rare find)! You will greatly appreciate the FIRST-FLOOR living/kitchen area with soaring ceiling height, elegant gaslog fireplace, quality craftmanship, double-paned windows, magnificent Primary Suite, HUGE walk-in closets, & superb finishes! Third floor flex-room features a private bath & closet, which could function as a 4th bedrm/gameroom/media. Escape to one of the multiple outdoor living areas - 1st-floor back patio complete with artificial grass for low-maintenance or the enormous 3rd-floor rooftop deck complete with waterproof decking material. Community offers walking trails, community pool and lush landscaping!' ,`Acres` = '0.05' ,`Area` = '24' ,`BuilderName` = 'InTown Homes' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 UPLAND PARK 3RD PAR R/P & R/P AMEND' ,`LotDesciption` = 'Patio Lot,Subdivision Lot' ,`LotSize` = '2178' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SHERWOOD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'French,Traditional' ,`Subdivision` = 'Upland Park' ,`TaxAmount` = '9817' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699769' WHERE `Matrix_Unique_ID` = '211436261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-17T09:02:47.143' ,`MLSNumber` = '65535573' ,`ListAgentFullName` = 'Tien Dinh' ,`ListOfficeName` = 'International Investment' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.968081' ,`Longitude` = '-95.467276' ,`PhotoCount` = '13' ,`PostalCode` = '77014' ,`RoomCount` = '11' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Mardi Gras' ,`StreetNumber` = '12222' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home locate in quiet and lovely neighborhood, 4 bedrooms and 2 1/2 bath and attached 2 car garage. , Master bedroom is on the first floor with jetted tub and separate shower. High ceiling with warm family room, bright and light formal dinning room and office on the first floor, open game room upstairs. This home is convenient to Beltway 8, I-45, FM 1960. Easy commute to Bush IAH airport, The Woodlands, Willowbrook Mall and Downtown Houston. This house won\'t last long !!!!!' ,`Acres` = '0.1673' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek South' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 60 BLK 3 SILVERGLEN WEST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '7286' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '396' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'DELORAS E THOMPSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'STELLE CLAUGHTON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Silverglen West' ,`TaxAmount` = '6846' ,`TaxRate` = '2.8867' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663699770' WHERE `Matrix_Unique_ID` = '211500143' --> Updated record success