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-30T09:26:45.980' ,`MLSNumber` = '52927945' ,`ListAgentFullName` = 'Mylene Th Pham' ,`ListOfficeName` = 'SOVRAN' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.730353' ,`Longitude` = '-95.482617' ,`PhotoCount` = '25' ,`PostalCode` = '77057' ,`RoomCount` = '3' ,`ListPrice` = '599990.00' ,`Status` = 'Active' ,`StreetName` = 'Beverly Forest' ,`StreetNumber` = '3318' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2085' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New construction, never lived in, and READY FOR IMMEDIATE MOVE IN home! Centrally located in town close to major freeway and near the Galleria Mall, this house features an open floor-plan with high ceilings and wood flooring throughout living areas and bedrooms. The kitchen has a built in wine cooler as well as a built in desk area to the side. The sizable primary bedroom features a bathroom with double sinks, a soaking tub, and storage shelving galore! Rooftop terrace on the 4th floor, perfect for hosting and or entertaining. Come see this house today! It is also to be featured on a TV show airing soon!' ,`Acres` = '0.0345' ,`Area` = '22' ,`BuilderName` = 'Reginal Design Cons' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Galleria' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 5 BLK 1 GLENHAVEN ESTATES SEC 2 PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1502' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SCHOOL AT ST GEORGE PLACE' ,`SchoolHigh` = 'WISDOM HIGH SCHOOL' ,`SchoolMiddle` = 'TANGLEWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Back' ,`SqFtSource` = 'Builder' ,`Stories` = '4' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'GLENHAVEN ESTATES' ,`TaxAmount` = '2696' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '206757148' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:59:42.803' ,`MLSNumber` = '37307529' ,`ListAgentFullName` = 'Carla Rae Southard' ,`ListOfficeName` = 'The Virtual Realty Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.860756' ,`Longitude` = '-95.668688' ,`PhotoCount` = '40' ,`PostalCode` = '77414' ,`RoomCount` = '7' ,`ListPrice` = '248862.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 672' ,`StreetNumber` = '195' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'DOLL HOUSE on the banks of Caney Creek. Completely remodeled in 2022 with updated tile floors in the kitchen, bath and utility rooms. Original hardwood floors on the first floor have been beautifully restored in the dining, living and bedrooms. The bedroom on the second floor has new carpet. The Kitchen is a dream with butcher block counter tops, a glass cooktop and wall oven. Spacious bathroom with marble countertop vanity, linen closet, and beautiful walk-in shower with dual shower heads. Front and back porch decks have been newly painted and decks have non-slip stain. This home is a short 5 minute drive to Sargent Beach! Many Bait camps, Restaurants, fishing, shelling and just enjoying the outdoors of the Texas Gulf Coast!!\r\nA MUST SEE dream home!' ,`Acres` = '0.281' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'PECAN SHADOWS SEC 1, LOT 3' ,`LotDesciption` = 'Subdivision Lot,Waterfront' ,`LotSize` = '12240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pecan Shadows Sec 1' ,`TaxAmount` = '1635' ,`TaxRate` = '1.9671' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1975' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '206925371' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:43:19.360' ,`MLSNumber` = '56439980' ,`ListAgentFullName` = 'Lupita Padilla' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.148587' ,`Longitude` = '-95.523309' ,`PhotoCount` = '35' ,`PostalCode` = '77389' ,`RoomCount` = '10' ,`ListPrice` = '1040000.00' ,`Status` = 'Active' ,`StreetName` = 'Valley Cottage' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Place' ,`City` = 'Spring' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4342' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Magnificent home in Creekside Park in The Woodlands, located in Paloma Springs neighborhood by the lake Paloma . A wonderful ONE and a half story home. An open floor plans that flows through the house. Features 5 bedrooms and 4.5 bathrooms. There is just one-bedroom upstairs with its private bathroom. A good size master bedroom is down with its magnificent ceilings and master bathroom. 3 other bedrooms are located downstairs too. Formal study with double French doors, formal dining room, butler’s pantry and a great size family room. Outdoor LANAI roof in the covered patio. There is enough space to build a pool. Enjoy the convenience of walking or biking to school and to the acclaimed Robert Fleming aquatic park. Zoned to exemplary Creekside Forest elementary. Creekside Park shopping centers are just minutes away. The Grand Parkway is around the corner. The views of the lake are fantastic. Available immediately.' ,`Acres` = '' ,`Area` = '14' ,`BuilderName` = 'Toll Brothers' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'The Woodlands' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 1 THE WOODLANDS VLG OF CREEKSIDE PARK 26' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '12249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'CREEKSIDE FOREST ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE PARK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'The Woodlands Creekside Park' ,`TaxAmount` = '18550' ,`TaxRate` = '2.6895' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '207420969' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:43:49.517' ,`MLSNumber` = '34684501' ,`ListAgentFullName` = 'Jamie Prasek' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.418356' ,`Longitude` = '-96.715849' ,`PhotoCount` = '22' ,`PostalCode` = '77983' ,`RoomCount` = '2' ,`ListPrice` = '126000.00' ,`Status` = 'Active' ,`StreetName` = 'Oakland' ,`StreetNumber` = '601' ,`StreetSuffix` = 'Avenue' ,`City` = 'Seadrift' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1536' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come check out these two charming units on a nice sized corner lot in beautiful Seadrift Tx! Unit #1 is a 1/1 with open kitchen and living, washroom, Mini split/WAC. Unit #2 is a 2/1 with open living and kitchen, wash room, mini split. RV hookup located in the back of property. Great investment opportunity, fishing camp, or weekender!' ,`Acres` = '0.326' ,`Area` = '65' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'SEADRIFT TOWNSITE, BLOCK 57, LOT 11,12' ,`LotDesciption` = 'Other' ,`LotSize` = '14201' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '169 - Calhoun County' ,`SchoolElementary` = 'SEADRIFT SCHOOL' ,`SchoolHigh` = 'CALHOUN HIGH SCHOOL' ,`SchoolMiddle` = 'SEADRIFT SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Seadrift Townsite' ,`TaxAmount` = '1779' ,`TaxRate` = '2.2666' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '208112748' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:03:32.913' ,`MLSNumber` = '18067102' ,`ListAgentFullName` = 'Justin Dickey' ,`ListOfficeName` = 'Keller Williams Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.405773' ,`Longitude` = '-95.059907' ,`PhotoCount` = '50' ,`PostalCode` = '77568' ,`RoomCount` = '7' ,`ListPrice` = '361822.00' ,`Status` = 'Active' ,`StreetName` = 'VILLA SOLA' ,`StreetNumber` = '13314' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2340' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL BRAND NEW COLINA HOME- 2 STORY WITH 4 BEDROOMS, 3 FULL BATHS , PLUS UPSTAIRS LOFT. DOWNSTAIRS HAS 2 BEDROOMS AND 2 FULL BATHS, UPSTAIRS HAS 2 BEDROOMS AND 1 FULL BATH, HUGE OPEN HOME PLAN WITH SKY LINE WINDOWS, VINYL PLANK FLOORING EVERYWHERE EXCEPT STAIRS & BEDROOMS AND LOFT, INCLUDES 2\' FAUX WOOD BLINDS, BUILT IN TAEXX PEST CONTROL, RINNAH TANKLESS WATER HEATER, BACK COVERED PATIO, UPGRADED -GRANITE KITCHEN COUNTERS, UPGRADED- KITCHEN BACKSPLASH, UPGRADED- 42\" CABINETS WITH CROWN MOLDING, STAINLESS STEEL 5 BURNER GAS APPLIANCES, BRICK ELEVATION, FRONT GUTTERS, LENNOX 16 SEER A/C, DOUBLE VANITY IN MASTER BATH, BUILT IN SHOE CASE IN MASTER CLOSET.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Colina Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9 Block 1 Sec 3' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5625' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1330' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.55' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '208165697' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:54:24.900' ,`MLSNumber` = '98971259' ,`ListAgentFullName` = 'Brenda Zambrano' ,`ListOfficeName` = 'One2Three Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.284002' ,`Longitude` = '-94.874564' ,`PhotoCount` = '27' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = '93rd' ,`StreetNumber` = '616' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1598' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Peace and tranquility awaits! This is an open-concept home nestled on a quiet street, between Offatts Bayou and West Bay just yards away from fishing, kayaking, or boating. The home features a large living/kitchen/dining area, vinyl floors throughout, quartz countertops in the kitchen and bathrooms, recessed lighting, and double crown molding. The home is surrounded with bay views and protected marsh lands, so there’s always a breeze. Enjoy the glowing sunrise off the back porch from the master suite in the morning, and in the evening, the beautiful sunset sky hues from the large living area windows or front porch. This home is located off of Teichman Point, a hidden gem of a neighborhood, less than 5 miles from the Seawall and the historic Strand district where there are unique dining options, boutique shopping, live music, and major island events. Here you’re able to enjoy all of the aspects of the “island life” while escaping the hustle and bustle of it when you’re ready to relax.' ,`Acres` = '0.1377' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Teichman/Channelview Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'PUESTA DEL SOL (2007) ABST 121, LOT 11, ACRES 0.138' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Puesta Del Sol 2007' ,`TaxAmount` = '7884' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2019' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '208841141' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:39:18.490' ,`MLSNumber` = '26968154' ,`ListAgentFullName` = 'Aislinn Phelan' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.879671' ,`Longitude` = '-93.944033' ,`PhotoCount` = '29' ,`PostalCode` = '77640' ,`RoomCount` = '6' ,`ListPrice` = '85000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '615' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1368' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investor Special! Rent Ready! This property is a 4 bedroom, 1 bathroom house in Port Arthur ISD. Laminate flooring and fresh paint throughout. The house features an inside utility space with washer and dryer hookups and a tankless water heater. The back yard has a partial chain link fence and out front is a covered porch.' ,`Acres` = '0.1607' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 489 CITY OF PORT ARTHUR' ,`LotDesciption` = 'Other' ,`LotSize` = '7000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'DEQUEEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Port Arthur City' ,`TaxAmount` = '2590' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704752' WHERE `Matrix_Unique_ID` = '208990218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:13:14.727' ,`MLSNumber` = '4414809' ,`ListAgentFullName` = 'Konae Mitchell' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.745236' ,`Longitude` = '-95.581332' ,`PhotoCount` = '22' ,`PostalCode` = '77077' ,`RoomCount` = '13' ,`ListPrice` = '378000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodland Springs' ,`StreetNumber` = '2011' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2455' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOTIVATED SELLERS - BRING ALL OFFERS\r\nNEW ROOF! NEW FENCE! NEW GUTTERS! NEW DRIVEWAY! NEW HVAC SYSTEM! NEW EXTERIOR PAINT! NEW WHITE QUARTZ COUNTERTOPS! (kitchen and primary), NEW KITCHEN BACKSPLASH! NEW KITCHEN FAUCET! NEW KITCHEN KNOBS! NEW POLARIS CLEANING SYSTEM ON POOL! NEW COMMERCIAL GRADE VINYL PLANK FLOORING! Staying with the house: the pool table, the refrigerator (new), washer and dryer. This updated home with a POOL has outstanding curb appeal: new driveway, 9x12 pergola front porch and nice landscaping. There is plenty of space to work from home in one of the four bedrooms or in the flex space upstairs which is currently used as a game room. Saltillo tile in the entry, living room, dining, kitchen, breakfast and utility rooms. 2nd full bath is updated with a jacuzzi tub and tile. Hardy Board siding installed in 2018. Downstairs is tile and vinyl plank. Spiral stairs and upstairs are berber carpet. THIS IS A \"MUST SEE\" HOUSE!' ,`Acres` = '0.1433' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 33 BLK 2 APRIL VILLAGE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6240' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '510' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ASKEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'REVERE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'April Village Sec 01' ,`TaxAmount` = '6409' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '209506244' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:44:09.137' ,`MLSNumber` = '88726871' ,`ListAgentFullName` = 'James Polomsky' ,`ListOfficeName` = 'Red Door Realty & Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.178077' ,`Longitude` = '-95.166240' ,`PhotoCount` = '20' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '293999.00' ,`Status` = 'Active' ,`StreetName` = 'Whispering Pines' ,`StreetNumber` = '2323' ,`StreetSuffix` = 'Street' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large 5 bedroom home with over sized lot. Kitchen was just upgraded, carpets were replaced, tile flooring all downstairs. Time to call this house a home!' ,`Acres` = '0.4603' ,`Area` = '40' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROMAN FOREST 01, BLOCK 14, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '20049' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'DOGWOOD ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Roman Forest 01' ,`TaxAmount` = '6267' ,`TaxRate` = '2.9064' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '209515604' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:56:05.517' ,`MLSNumber` = '95210313' ,`ListAgentFullName` = 'Christy Buck' ,`ListOfficeName` = 'Infinity Real Estate Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.598797' ,`Longitude` = '-95.232060' ,`PhotoCount` = '26' ,`PostalCode` = '77089' ,`RoomCount` = '6' ,`ListPrice` = '210000.00' ,`Status` = 'Active' ,`StreetName` = 'Kirkgreen' ,`StreetNumber` = '10534' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Investment opportunity! Tenant occupied as of 9/12/2022. Come check out this great home in cul-de-sac with large fenced yard. Open concept floor plan with wood burning fireplace and vaulted ceilings in the living area. Breakfast bar and eat-in kitchen with gas stove. Laminate flooring and tile throughout home other than bedrooms, double pane windows and updated bathrooms. Large covered patio. Backyard storage shed. Convenient location to the beltway and I45.' ,`Acres` = '0.1791' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 81 BLK 2 KIRKWOOD SOUTH SEC 5' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '190' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MOORE ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kirkwood South Sec 05' ,`TaxAmount` = '3994' ,`TaxRate` = '2.6355' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '209537470' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:46:59.173' ,`MLSNumber` = '16918978' ,`ListAgentFullName` = 'Brian Silverberg' ,`ListOfficeName` = 'Silver Key Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.798032' ,`Longitude` = '-95.440455' ,`PhotoCount` = '39' ,`PostalCode` = '77008' ,`RoomCount` = '8' ,`ListPrice` = '534000.00' ,`Status` = 'Active' ,`StreetName` = 'Droxford' ,`StreetNumber` = '2310' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1581' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'UNIQUE opportunity to own move in condition all brick home on huge OVERSIZED lot greater than 12,000 sqft. Imagine the possibilities with all that space (garden, pool), and so close to downtown Houston/Galleria. Three bedrooms with new carpet and 2 full baths. Freshly painted walls and trim. Formal living and dining room. Den with beautiful glass french doors looking out on huge back yard. Kitchen with new oven, gas range, tiled back splash, granite counters and shaker cabinets. Utility with cabinets and elec/gas connections.' ,`Acres` = '0.1808' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Timbergrove/Lazybrook' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 6 BLK 10 TIMBERGROVE MANOR SEC 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Timbergrove Manor 14' ,`TaxAmount` = '8784' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1961' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '209592864' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:38:53.153' ,`MLSNumber` = '68629672' ,`ListAgentFullName` = 'Domenic Santilli' ,`ListOfficeName` = 'Capital Trust Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.490684' ,`Longitude` = '-95.122102' ,`PhotoCount` = '20' ,`PostalCode` = '77573' ,`RoomCount` = '5' ,`ListPrice` = '249900.00' ,`Status` = 'Active' ,`StreetName` = 'Mimosa' ,`StreetNumber` = '2309' ,`StreetSuffix` = 'Court' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1704' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great one story home in Newport. This home is zoned to Clear Creek ISD. The kitchen opens to dining & living area. The living room has a tile surround fireplace, crown molding in entry and living area, black on black appliance in kitchen, double oven, bar top separates dining from living, garage door opener, mature trees, covered back patio/deck area, 4 sides brick. Needs a little love to make it your own. Roof replaced 2017.' ,`Acres` = '0.1567' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 3 PAGE 3 LOT 5 BLK 19 NEWPORT SEC 6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6825' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (CLEAR CREEK)' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Newport 6' ,`TaxAmount` = '4444' ,`TaxRate` = '2.0697' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '209641553' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:28:55.897' ,`MLSNumber` = '77439670' ,`ListAgentFullName` = 'Cesar Zambrano' ,`ListOfficeName` = 'Prime Texas Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.780694' ,`Longitude` = '-95.411359' ,`PhotoCount` = '9' ,`PostalCode` = '77007' ,`RoomCount` = '0' ,`ListPrice` = '409000.00' ,`Status` = 'Active' ,`StreetName` = 'Roy' ,`StreetNumber` = '2550' ,`StreetSuffix` = 'Circle' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '1294' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BUILDERS / INVESTORS!!! Amazing 14.930 sqft lot in Cottage Oaks. This is a unique piece of land in middle of Heights Area, ready for your new home. Located across the new M-K-T strip center, close to Memorial Park and Washington Corridor . Deed Restrictions in this neighborhood allow only 1 home per lot. No worries about crowded townhomes here...The home is a tear down home and has been abandoned for some time now. Home has a 4car garage a storage shed in back. Property can be walked with appointment. PROPERTY IS BEING SOLD AS IS...' ,`Acres` = '0.3427' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cottage Grove' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 35 BLK 1 COTTAGE OAKS' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14930' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Cottage Oaks' ,`TaxAmount` = '8853' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '209807288' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:09:43.963' ,`MLSNumber` = '35898196' ,`ListAgentFullName` = 'Dana Johnson' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.473377' ,`Longitude` = '-94.592177' ,`PhotoCount` = '29' ,`PostalCode` = '77650' ,`RoomCount` = '7' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Copacabana' ,`StreetNumber` = '956' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1930' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Views of the Beach & Intercoastal...This resort-style home will have you thinking twice about going back to the \"real world.\" 4/3/1 with over 1900 Sq ft. Plus 1140 sqft of deck. (10\' X 48\' covered). All the finishes you are used to: Granite, stainless, stylish lighting, designer colors, high end, luxury vinyl plank flooring. The gourmet Kitchen boasts custom cabinetry, granite countertops, farmhouse sink, stainless range, microwave & dishwasher, huge Pantry (large enough for 2nd fridge). Bar seating for 6, and additional table with granite top (built-in) with seating for 4. Family Room and Kitchen/Dining area offer a wall of windows overlooking the beautiful deck. 2nd, 3rd & 4th bedrooms share 2 full baths. Master Suite features shiplap accent wall, huge Master Closet, & Master Bath offers double vanity & 4X5 shower, plus linen storage. Energy efficient LED throughout interior & exterior. Should be complete Sept 30, 2022. *See additional Builder Specs & Upgrade Sheet, for more details.' ,`Acres` = '0.23' ,`Area` = '33' ,`BuilderName` = 'Williams Manor Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 B FRANKS SUR LOT 1 BLK 1 COPACABANA BY THE SEA' ,`LotDesciption` = 'Water View' ,`LotSize` = '10108' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Copacabana' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '210112844' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:57:06.450' ,`MLSNumber` = '53047528' ,`ListAgentFullName` = 'Natalie Malla' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.823456' ,`Longitude` = '-95.451677' ,`PhotoCount` = '39' ,`PostalCode` = '77018' ,`RoomCount` = '11' ,`ListPrice` = '1395000.00' ,`Status` = 'Active' ,`StreetName` = 'Althea' ,`StreetNumber` = '2323' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4556' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Another masterpiece by the highly sought after Venice Custom Homes! The quality of construction and attention to detail is evident upon entering this timeless home with unmatched curb appeal. Contemporary elegance with a well thought-out and spacious layout. Primary bedroom suite offers separate luxury bath and gorgeous walk-in custom closet. Designer light fixtures throughout. All Sub-Zero/ Wolf appliances including double oven. Stunning modern TWO-SIDED fireplace perfect for entertaining! Quality finishes. First floor study with a full bath can be used as a 4th bedroom. Fabulous second floor patio overlooking the backyard and neighborhood park. Second backyard space includes a lovely downstairs patio. Plenty of room for a pool!' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Venice Custom Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Oak Forest East Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 6 OAK FOREST SEC 13' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7534' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'STEVENS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Forest Sec 13' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704753' WHERE `Matrix_Unique_ID` = '210668349' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:33:59.087' ,`MLSNumber` = '77384147' ,`ListAgentFullName` = 'Emilio Zaporteza' ,`ListOfficeName` = 'Vez Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.928608' ,`Longitude` = '-95.256870' ,`PhotoCount` = '45' ,`PostalCode` = '77396' ,`RoomCount` = '13' ,`ListPrice` = '589900.00' ,`Status` = 'Active' ,`StreetName` = 'Birch Arbor' ,`StreetNumber` = '14702' ,`StreetSuffix` = 'Court' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '2' ,`BedsTotal` = '5' ,`SqFtTotal` = '4410' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This house is located on a corner cul de sac street. Very spacious floor plan. It features, Home office, island kitchen with Granite counter top, 5 bedrooms, 3 full bath and 2 half bath, large gameroom and extra room that can be another game room or media room, swimming pool, outdoor kitchen, Water softener and Home generator,' ,`Acres` = '0.2344' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fall Creek Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 38 BLK 2 FALL CREEK SEC 10' ,`LotDesciption` = 'Corner,Cul-De-Sac' ,`LotSize` = '10212' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1090' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'AUTUMN CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'WOODCREEK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Fall Creek Sec 10' ,`TaxAmount` = '13617' ,`TaxRate` = '2.9973' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704754' WHERE `Matrix_Unique_ID` = '210797685' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:29:55.253' ,`MLSNumber` = '45361252' ,`ListAgentFullName` = 'Michele Kimmons' ,`ListOfficeName` = 'Michele Kimmons Properties,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.676289' ,`Longitude` = '-95.022973' ,`PhotoCount` = '50' ,`PostalCode` = '77351' ,`RoomCount` = '9' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Fm 3126' ,`StreetNumber` = '8468' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2448' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3.3 unrestricted acres of waterfront property on Lake Livingston. Beautiful wooded property with over 300 LF of waterfront with a great view of Pine Island. This 4/3/3 2400 SF home has an open concept LR/DR/Kitchen area. High cathedral ceiling, built-in bookcases and a large wood burning FP make this property unique. A 400 SF sun room was added and has a 7x7 spa included. Home is cooled by a 48000 BTU heat pump.\r\nThe 3 car garage with a full bath is 940 SF. Boathouse has 4 boat slips and is also included. Property has a deep well, 11 zone sprinkler system from lake, and a 3 tank septic system. There is a 24x12 storage shed that was added for yard equipment. Property is partially wooded with a long gravel/asphalt driveway. A separate 24x24 building with half bath, huge BBQ pits, air conditioning, built in tables, and a kitchen, that is located up at the front of property. Many possibilities for this wonderful property, don\'t miss!!!' ,`Acres` = '3.35' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 33 JAMES S GARNER SURVEY TRACT 95-C & 96B-1' ,`LotDesciption` = 'Waterfront,Wooded' ,`LotSize` = '145926' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'n/a' ,`TaxAmount` = '10966' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704754' WHERE `Matrix_Unique_ID` = '210907918' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:51:38.310' ,`MLSNumber` = '74151855' ,`ListAgentFullName` = 'Jenifer Duguay' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789021' ,`Longitude` = '-95.406007' ,`PhotoCount` = '50' ,`PostalCode` = '77008' ,`RoomCount` = '10' ,`ListPrice` = '800000.00' ,`Status` = 'Active' ,`StreetName` = 'Herkimer' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2487' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Who needs a vehicle when you can literally live, work and play all from home? This private gated home includes 4 bedrooms,2 homes offices, formal dining, built-in desk areas. Perfectly located within walking distance to entertainment, parks, shopping, restaurants and nightlife. This fantastically renovated home features upgrades such as the gorgeous hardwood oak floors including areas laid in a herringbone pattern. Upgrades include double pane windows,Int & Ext paint,light fixtures,fans,faucets & much more.Large front lawn w/double wide driveway. Beautiful renovated kitchen w/island,gas cooktop w/downdraft vent to exterior, granite counter,subway tile backsplash,undermount lighting,walk-in pantry,oversized stainless sink & refrigerator.Open to the family room.Fireplace.Built-in cabinets. Bluetooth vanity mirrors in 2 bathrooms.Primary suite w/spa like bathroom features shower, gorgeous stand alone tub.Huge walk-in closet w/built-ins.Tons of storage.Truly a turn key home. LOW TAX RATE!' ,`Acres` = '0.0698' ,`Area` = '9' ,`BuilderName` = 'Rosemond Custom Home' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 HOUSTON HEIGHTS PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOVE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEIGHTS HIGH SCHOOL' ,`SchoolMiddle` = 'HOGG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Heights Pt Rep' ,`TaxAmount` = '12376' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704754' WHERE `Matrix_Unique_ID` = '210954881' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:11:32.410' ,`MLSNumber` = '94826388' ,`ListAgentFullName` = 'Erica Beyer' ,`ListOfficeName` = 'CB&A, Realtors- Loop Central' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.958759' ,`Longitude` = '-95.302091' ,`PhotoCount` = '20' ,`PostalCode` = '77396' ,`RoomCount` = '4' ,`ListPrice` = '315000.00' ,`Status` = 'Active' ,`StreetName` = 'Townsan' ,`StreetNumber` = '6003' ,`StreetSuffix` = 'Road' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '830' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2 Lots, This property has a large yard plenty of room, fenced all around No restrictions. House had total reno in 2015, new cabinets granite counters. New plumbing, new fixtures (electrical/plumbing) New electrical receptacles, wired for cable TV and Ethernet. Large metal building with concrete slab and utilities. Shop 30 x 40 1200 sq ft. ready for shop work 4\'\' slab w/office.The 2-storage sheds under roof are 8X20 w/ lighting. Minutes from Bush Intercontinental Airport & Hardy Toll Rd./Beltway 8.' ,`Acres` = '0.34' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area West' ,`HeatSystem` = 'Other Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 123 & 124 BLK 7 GLEN LEE PLACE SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '15000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'FRANCIS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'JONES MIDDLE SCHOOL (ALDINE)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Leave Business Card,Lockbox Front,Request Online Appointment,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Glen Lee Place 1' ,`TaxAmount` = '1967' ,`TaxRate` = '2.5119' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704754' WHERE `Matrix_Unique_ID` = '211253207' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:58:23.947' ,`MLSNumber` = '68000025' ,`ListAgentFullName` = 'John Prell' ,`ListOfficeName` = 'Creekview Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.054758' ,`Longitude` = '-95.443863' ,`PhotoCount` = '50' ,`PostalCode` = '77566' ,`RoomCount` = '7' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Huckleberry' ,`StreetNumber` = '421' ,`StreetSuffix` = 'Drive' ,`City` = 'Lake Jackson' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3271' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Quality built custom home on Oyster Creek. Home has great flow for active living w great view of the water. Bright kitchen w island, generous cabinetry, stainless appliances. Huge laundry rm w sewing/folding counter & pantry. Formal dining overlooks well-groomed backyard & creek. Nice screened patio. 3bed/2.5bath down (primary) and 2bed bedrooms/1bath up (add\'l optional primary bedroom). 4th bedroom up can be a gameroom. Roof 5/2010, carpet/paint 7/2022. Two floored attic areas, insulated exterior walls & insulated interior walls. Oversized garage w storage rm, ample parking for accessory vehicles. Pride of ownership shows through-out. This is a well- cared for gem in desirable neighborhood. Great opportunity and truly beautiful.' ,`Acres` = '0.3681' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Jackson' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TANGLEWOOD SEC 5 (LAKE JACKSON), BLOCK 18, LOT 12' ,`LotDesciption` = 'Subdivision Lot,Water View,Waterfront' ,`LotSize` = '16034' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'BRANNEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'LAKE JACKSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tanglewood Lake Jackson' ,`TaxAmount` = '8515' ,`TaxRate` = '2.3371' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1989' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704754' WHERE `Matrix_Unique_ID` = '211294729' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:46:29.580' ,`MLSNumber` = '32117408' ,`ListAgentFullName` = 'Hudson Holmes' ,`ListOfficeName` = 'Joe Tramonte Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.308589' ,`Longitude` = '-94.783809' ,`PhotoCount` = '40' ,`PostalCode` = '77550' ,`RoomCount` = '6' ,`ListPrice` = '529000.00' ,`Status` = 'Active' ,`StreetName` = '14th' ,`StreetNumber` = '313' ,`StreetSuffix` = 'Street' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Lovely, Historic East End, Victorian home located within the shadows of UTMB. A short walk/bike ride to some of the Island\'s favorite restaurants, bars, attractions and of course, The Strand! This home immediately welcomes you with a white picket fence and rose bushes. Old time Island charm greets you when you enter the front doors. Three inviting porches to sit and enjoy Galveston breezes, with locations off two of the three bedrooms, plus the main entrance. Chef\'s kitchen delight with gas gourmet stove, a wide center island, extra large pantry and new cabinets that extend all the way to 10\' ceiling. All stainless steel appliances are included. Original, refurbished hardwood floors located in some areas of the home. Relax in the sunny formal living and dining rooms. Updated utility room/main floor bathroom. All three bedrooms are up, with renovated bathroom and large walk in shower. There is also an outdoor seating area in the side yard. Own a piece of the Island, own peace of mind!' ,`Acres` = '0.0584' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR PT OF LOTS 8 & 9 (8-2) BLK 554 GALVE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2542' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Victorian' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '6946' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1905' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704754' WHERE `Matrix_Unique_ID` = '211300644' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:19:01.320' ,`MLSNumber` = '51107135' ,`ListAgentFullName` = 'Alexis Garcia' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.186778' ,`Longitude` = '-95.427744' ,`PhotoCount` = '28' ,`PostalCode` = '77515' ,`RoomCount` = '3' ,`ListPrice` = '229900.00' ,`Status` = 'Active' ,`StreetName` = 'Manor' ,`StreetNumber` = '609' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location, Location, Location!!!! Welcome to 609 Manor Dr! This 3 bedroom/2 bath home has a split floor plan. It has high ceilings, large living room & the utility room is inside! It also has brand new flooring throughout the home!! This cheerful home is located on a dead end road! It won\'t last long! Get your showing scheduled today!!!' ,`Acres` = '0.1653' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'PLANTATION NORTH (ANGLETON), BLOCK 6, LOT 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7200' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'NORTHSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation North Angleton' ,`TaxAmount` = '4848' ,`TaxRate` = '2.6102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211597985' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:09:47.130' ,`MLSNumber` = '8236977' ,`ListAgentFullName` = 'Jay Patel' ,`ListOfficeName` = 'New Trends Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.945920' ,`Longitude` = '-95.249048' ,`PhotoCount` = '50' ,`PostalCode` = '77396' ,`RoomCount` = '10' ,`ListPrice` = '439900.00' ,`Status` = 'Active' ,`StreetName` = 'Barlow Springs' ,`StreetNumber` = '9506' ,`StreetSuffix` = 'Lane' ,`City` = 'Humble' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '3510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Must see this open and airy home on a large dead-end cul-de-sac lot. Updated kitchen with granite countertops and oversized pantry open to the family room. Beautifully tiled entrance & Breakfast area. Full bedroom and bathroom downstairs. Second floor primary bedroom en-suite bath features a separate shower, dual vanities, and a garden tub. Large Utility Room. Pre-wired Media room that is currently used as a bedroom. Plenty of storage in the garage. Huge backyard with patio. GATED COMMUNITY with covered basketball court and pool. Easy access to Beltway 8 and 10 minutes to IAH.' ,`Acres` = '0.2217' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Humble Area East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 52 BLK 1 CANYON GATE AT PARK LAKES SEC 13' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '9658' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'PARK LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUMBLE HIGH SCHOOL' ,`SchoolMiddle` = 'HUMBLE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate/Pk Lakes Sec 13' ,`TaxAmount` = '8635' ,`TaxRate` = '2.9873' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2015' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211766218' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:27:44.467' ,`MLSNumber` = '81728156' ,`ListAgentFullName` = 'Andrea Garcia' ,`ListOfficeName` = 'RE/MAX RESULTS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.483388' ,`Longitude` = '-94.918482' ,`PhotoCount` = '27' ,`PostalCode` = '77539' ,`RoomCount` = '4' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = '5 th' ,`StreetNumber` = '818' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1236' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely STUNNING 2 year old home with FABULOUS bay views!! This property is truly gorgeous with features and amenities to include: rich wood look tile flooring throughout the home, HUGE Island kitchen with granite counter tops, large pantry, and stainless appliances, open floor plan with high ceilings, half bath on 1st floor, beautiful primary bedroom with bay views, private balcony, and luxurious en-suite bath, 2nd floor utility room, spacious 2nd bedroom with a private bath beautifully finished. The home sits on 2 lots so there is loads of parking space for vehicles, your boat, and water toys. The property is fully fenced and is 1 street away from the water. You truly can\'t get much better than this! Welcome Home!' ,`Acres` = '0.1538' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS SUR LOTS 33 & 34 (33-1) BLK 145 SAN LEON T' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6700' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '6150' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2020' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211833484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:58:15.583' ,`MLSNumber` = '83649552' ,`ListAgentFullName` = 'Robert Searcy' ,`ListOfficeName` = 'Robert Searcy Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.675333' ,`Longitude` = '-95.280368' ,`PhotoCount` = '21' ,`PostalCode` = '77061' ,`RoomCount` = '8' ,`ListPrice` = '389900.00' ,`Status` = 'Active' ,`StreetName` = 'De Leon' ,`StreetNumber` = '8134' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2745' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Poised on a spacious 12,788 sq ft (per HCAD) leafy corner lot in a prime section of the historic district, this well-maintained traditional offers lots of space & character. Original beautiful solid hardwood floors. Updated kitchen is very open to the breakfast area & den with fireplace. Both formals provide great entertaining spaces. 3 spacious bedrooms in the one wing, with a 4th additional bedroom and full bath tucked behind the kitchen wing. Perfect space for extended family, live-in Nanny or as a more secluded home office. Garage plus attached, gated carport provides covered parking for 4 vehicles. Per seller, a number of important improvements over the last few years, including upgraded windows, sewer line replacement, AC & landscaping upgrades, to name just a few. Just 1 exit outside the loop with quick access to downtown, Med Center, major Universities, Hobby & the fabulous new Botanical Garden. Glenbrook was named a top neighborhood by This Old House, and Houstonia magazine.' ,`Acres` = '0.2936' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hobby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 11 BLK 63 GLENBROOK VALLEY SEC 11' ,`LotDesciption` = 'Corner' ,`LotSize` = '12788' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '40' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'CORNELIUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CHAVEZ HIGH SCHOOL' ,`SchoolMiddle` = 'ORTIZ MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Colonial,Ranch' ,`Subdivision` = 'Glenbrook Valley' ,`TaxAmount` = '5314' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1957' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211930291' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:26:29.913' ,`MLSNumber` = '33581860' ,`ListAgentFullName` = 'Michael O\'Neal' ,`ListOfficeName` = 'Keller Williams RealtyNortheast' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.058125' ,`Longitude` = '-95.182673' ,`PhotoCount` = '30' ,`PostalCode` = '77345' ,`RoomCount` = '4' ,`ListPrice` = '300000.00' ,`Status` = 'Active' ,`StreetName` = 'Pinewood Park' ,`StreetNumber` = '4310' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1732' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful Patio home in Kings Crossing. Spacious three bedroom/two baths, open floor plan with French doors that lead to the outside. New stainless steel appliances, fresh paint throughout, and beautifully landscaped.' ,`Acres` = '0.1584' ,`Area` = '32' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Kingwood East' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 13 BLK 5 KINGS CROSSING SEC 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6900' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '484' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'GREENTREE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KINGWOOD HIGH SCHOOL' ,`SchoolMiddle` = 'RIVERWOOD MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Kings Crossing Sec 07' ,`TaxAmount` = '5089' ,`TaxRate` = '2.5839' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1984' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211936565' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:36:57.327' ,`MLSNumber` = '28186898' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.816598' ,`Longitude` = '-95.397277' ,`PhotoCount` = '16' ,`PostalCode` = '77018' ,`RoomCount` = '3' ,`ListPrice` = '464999.00' ,`Status` = 'Active' ,`StreetName` = 'E 33rd Street' ,`StreetNumber` = '209' ,`StreetSuffix` = '' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1950' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW CONSTRUCTION!!!! Located in the heart of independence Heights, this home is close to many local hotspots such as restaurants and nightlife in the Heights. You will also be minutes away from many major business districts including Downtown, the Galleria, and Med Center. Each home has a private driveway, spacious backyard and downstairs living with an additional game room/flex space upstairs! In addition, the home is equipped with engineered hardwoods throughout living areas, quartz countertops, modern hardware, and boasts natural light.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Urban Arc' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'tbd' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURRUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WASHINGTON HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Independence Heights' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211955093' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T08:37:24.550' ,`MLSNumber` = '64127799' ,`ListAgentFullName` = 'Charlotte Williams' ,`ListOfficeName` = 'Keller Williams Arlington' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '32.586532' ,`Longitude` = '-95.205744' ,`PhotoCount` = '12' ,`PostalCode` = '75765' ,`RoomCount` = '0' ,`ListPrice` = '75000.00' ,`Status` = 'Active' ,`StreetName` = 'Moore' ,`StreetNumber` = '110' ,`StreetSuffix` = 'Street' ,`City` = 'Hawkins' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'PRIME space in Hawkins! Build here on two lots at the corner of Beulah and Moore St, close to downtown Hawkins and Highway 80! This property is currently being used as workshop space but it would also make a great home or business site. A new workshop and carport complete with electrical and water provides plenty of project space and includes solar panels, a transferable security system, and a small bathroom with composting toilet. Gravel parking and fencing make the lot secure and private. There are tons of possibilities for this property! Enjoy the benefits of being close to FM 14, Highway 80, and near Tyler and Longview. Call today!' ,`Acres` = '' ,`Area` = '84' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1,2 Block 27 Hawkins Townsites' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '588 - Hawkins' ,`SchoolElementary` = 'HAWKINS ELEMENTARY SCHOOL (HAWKINS)' ,`SchoolHigh` = 'HAWKINS HIGH SCHOOL' ,`SchoolMiddle` = 'HAWKINS MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = '' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Unknown' ,`TaxAmount` = '114' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '9999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704755' WHERE `Matrix_Unique_ID` = '211964836' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:31:07.837' ,`MLSNumber` = '95291525' ,`ListAgentFullName` = 'Rachael Pieprzyca' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.213194' ,`Longitude` = '-96.281416' ,`PhotoCount` = '13' ,`PostalCode` = '77437' ,`RoomCount` = '2' ,`ListPrice` = '166500.00' ,`Status` = 'Active' ,`StreetName` = 'Sabla' ,`StreetNumber` = '114' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cozy updated starter house. Move in Ready with new carpet in living room and bedrooms. New flooring in Utility room. Hard wood floors in kitchen. Come see this property located on a 1/2 acre lot in El Campo. Large mature trees. Close to shopping and restaurants. Detached carport with extra storage. Washer and dryer, refrigerator, stove, and new microwave all convey with property. Fresh exterior paint, new ceiling fans and fixtures. AC is only 2 years old.' ,`Acres` = '0.5235' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'SABLATURA LOT 9C' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '22804' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sablatura' ,`TaxAmount` = '2695' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1945' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663704756' WHERE `Matrix_Unique_ID` = '211964849' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:23:34.013' ,`MLSNumber` = '92102235' ,`ListAgentFullName` = 'Jack Lipar' ,`ListOfficeName` = 'LGI Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.182221' ,`Longitude` = '-95.799425' ,`PhotoCount` = '8' ,`PostalCode` = '77355' ,`RoomCount` = '10' ,`ListPrice` = '293900.00' ,`Status` = 'Active' ,`StreetName` = 'Ellison' ,`StreetNumber` = '22015' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1787' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This popular one story home offers excellent curb appeal with the front bay window design. This home will go fast so do not miss the opportunity to tour this magnificent 4-bedroom, 2-bath home featuring all the space for you and your family. This home also offers an upgraded spacious kitchen which is fully equipped with all brand new Whirlpool appliances. Adjacent to the kitchen is the beautiful breakfast nook which showcases the bay windows to the front yard, offering a peaceful view. This spacious lot offers a nice fenced in backyard for your family, pets, and even entertaining! Think of all the possibilities. The quiet peaceful community of Williams Trace offers an on-site playground, splashpad, and shaded picnic areas all within walking distance from this home.' ,`Acres` = '' ,`Area` = '15' ,`BuilderName` = 'LGI Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MGL L9, Bl2, Sec3 of Williams Trace' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '348' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'WILLIE E. WILLIAMS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'MAGNOLIA JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Williams Trace' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704756' WHERE `Matrix_Unique_ID` = '211966054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:27:33.513' ,`MLSNumber` = '83325626' ,`ListAgentFullName` = 'Thuong Gist' ,`ListOfficeName` = 'Brookhaven Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.386397' ,`Longitude` = '-96.038111' ,`PhotoCount` = '37' ,`PostalCode` = '77868' ,`RoomCount` = '9' ,`ListPrice` = '1250000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 446' ,`StreetNumber` = '15598' ,`StreetSuffix` = '' ,`City` = 'Navasota' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '3882' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Modern Farmhouse on 20 acres AG EXEMPTED located 20 minutes from Texas A&M and less than an hour from Houston (Woodlands/Tomball/Cypress). Built in 2016, this Designer home has almost 3900sf of living space with two 10-12 feet wide covered porches that are great for entertaining, INCREDIBLE views and keeping the home cool in the summers. There are 5 spacious bedrooms with 4.5 baths in an open floor plan. Kitchen equipped with granite counter tops, double oven with gas cooktop, farmhouse sink and pot filler. Very well built with Shiplap walls, High ceilings and wood floors. 32x64 Barn/Wood Shop with electricity in the back along with a small storage shed. Plenty of acreage to build a fishing pond or your very own pool oasis. High Speed Fiber Optic (1gig).' ,`Acres` = '20' ,`Area` = '60' ,`BuilderName` = 'Trendmaker' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0044 JESSE B MC NEALY, TRACT 13-6, ACRES 20' ,`LotDesciption` = 'Wooded' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '129 - Navasota' ,`SchoolElementary` = 'HIGH POINT ELEMENTARY SCHOOL (Navasota)' ,`SchoolHigh` = 'NAVASOTA HIGH SCHOOL' ,`SchoolMiddle` = 'NAVASOTA JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Ranch' ,`Subdivision` = 'other' ,`TaxAmount` = '8137' ,`TaxRate` = '1.7749' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704756' WHERE `Matrix_Unique_ID` = '211966255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-30T09:40:33.350' ,`MLSNumber` = '4889294' ,`ListAgentFullName` = 'Natasha Tessier' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.064067' ,`Longitude` = '-95.650043' ,`PhotoCount` = '50' ,`PostalCode` = '77377' ,`RoomCount` = '9' ,`ListPrice` = '1795000.00' ,`Status` = 'Active' ,`StreetName` = 'Rugged Lark' ,`StreetNumber` = '18' ,`StreetSuffix` = 'Circle' ,`City` = 'Tomball' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '5875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Luxury smart home nestled on oversized lot in prestigious Willowcreek Ranch! Upgrades galore including multiple smart home features! Extensive architectural details throughout and family friendly layout with all the bells and whistles! Grand entry welcomes guest with a sweeping staircase and views to the gorgeous vaulted beamed ceiling family room. High end kitchen is open for easy entertaining and features 2 large islands, Jenn Air Pro gas cooktop, double ovens, and oversized built in refrigerator. Large game room down and pristine backyard with extensive 2500 sqft travertine patio, outdoor kitchen, fireplace & gorgeous resort style pool! Private owners retreat boast high beam ceiling & luxury bath with one of a kind ceiling & full walk through shower plus his/hers massive closets. Oversized laundry/hobby room features a dog shower & second refrigerator. Spacious loft, two secondary bedrooms, two baths and bonus storage spaces up. Great schools and great location! A must see!' ,`Acres` = '0.8907' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Tomball Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 14 BLK 1 WILLOWCREEK RANCH SEC 2 PAR R/P & EXTN' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '38800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '53 - Tomball' ,`SchoolElementary` = 'GRAND OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'TOMBALL HIGH SCHOOL' ,`SchoolMiddle` = 'GRAND LAKES JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowcreek Ranch' ,`TaxAmount` = '39142' ,`TaxRate` = '2.7372' ,`WaterSewer` = 'Aerobic,Water District' ,`YearBuilt` = '2018' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663704756' WHERE `Matrix_Unique_ID` = '211966562' --> Updated record success