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-08T12:27:27.883' ,`MLSNumber` = '71884500' ,`ListAgentFullName` = 'Allen Hebert' ,`ListOfficeName` = 'Register Real Estate Advisors' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.484744' ,`Longitude` = '-94.931517' ,`PhotoCount` = '48' ,`PostalCode` = '77539' ,`RoomCount` = '8' ,`ListPrice` = '449990.00' ,`Status` = 'Active' ,`StreetName` = '18th' ,`StreetNumber` = '909' ,`StreetSuffix` = 'Street' ,`City` = 'San Leon' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to San Leon where the fish are biting, and views are stunning. Unique Waterview property on a Corner lot, recently renovated 4-bedroom 2 bath. Covered parking for cars, boats or Rv\'s. Located minutes from the bay! Take in the fabulous bay breezes and sunsets while enjoying the evening on your deck, or at one of the many great restaurants, bars and shops just a short trip down the road. The property includes the home, separate commercial workshop with office and storage building. The commercial building has been a paint n body shop, transmission shop and taco stand. Perfect for a second home or income generating vacation rental less than ten minutes’ drive to all that Kemah has to offer, thirty minutes’ drive to Galveston, and only 45 minutes into the heart of Houston! So close to Gilhooley\'s, Topwater Grill & Pier 6.' ,`Acres` = '0.3076' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Bacliff/San Leon' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 10 A EDWARDS LOTS 20 THRU 23 BLK 157-A SAN LEON & IMPS*' ,`LotDesciption` = 'Corner,Water View' ,`LotSize` = '13400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Freestanding Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'SAN LEON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'JOHN AND SHAMARION BARBER MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Seller' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'San Leon' ,`TaxAmount` = '5105' ,`TaxRate` = '2.6219' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695913' WHERE `Matrix_Unique_ID` = '201114364' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T12:18:19.870' ,`MLSNumber` = '38088595' ,`ListAgentFullName` = 'Donna Mitchell' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.949819' ,`Longitude` = '-95.287947' ,`PhotoCount` = '18' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '489000.00' ,`Status` = 'Active' ,`StreetName` = 'Surf' ,`StreetNumber` = '116' ,`StreetSuffix` = 'Drive' ,`City` = 'Surfside Beach' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '895' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'A rental investor\'s DREAM!! The Shark Shack is a great rental property opportunity in a great location! Currently set up as an AirBnB , 2 bed/1 bath beach house, which sleeps 8-9, plus an area to park an RV. Includes golf carts and is sold fully furnished with a fun surfer vibe, large TV\'s in living area and both bedrooms, video games for kiddos, refrigerator, range, microwave, washer and dryer all to remain with the house. The tankless water heater helps make sure everyone can take a HOT shower. You will love the amazing views from both the recently added upper and lower decks. Enjoy the sunrise on the roof deck for a beautiful view of the sunrise or sunsets on the ocean. Just a short walk or golf cart ride down to the enjoy the beaches of Surfside.' ,`Acres` = '0.1205' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures,Sellers Disclosure,Special Addendum' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'SURFSIDE BLK 514 LOT 6 (A0051 F J CALVIT)' ,`LotDesciption` = 'Other' ,`LotSize` = '5249' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'FLEMING ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Call Occupant,Leave Business Card,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'City of Surfside' ,`TaxAmount` = '2425' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Public Sewer,Public Water,Septic Tank' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695913' WHERE `Matrix_Unique_ID` = '203904261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:36:33.940' ,`MLSNumber` = '65284241' ,`ListAgentFullName` = 'Katherine Cleveland' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.071325' ,`Longitude` = '-94.035796' ,`PhotoCount` = '20' ,`PostalCode` = '75931' ,`RoomCount` = '8' ,`ListPrice` = '549900.00' ,`Status` = 'Active' ,`StreetName` = 'Parkside Loop' ,`StreetNumber` = '177' ,`StreetSuffix` = '' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2462' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'BEAUTIFUL 4/2.1/2 with oversized 31-8 x 23-6 air conditioned garage with lower cabinet, open kitchen/dining/living, master downstairs. Neutral colors, Quartz countertops & pretty white cabinets in kitchen and all baths, polished concrete downstairs & carpet & tile only upstairs, with a minor adjustment the 4th bedroom is large enough to put up a wall to divide & easily add a game room. House is plumbed for gas, gas drop for dryer & stove are installed, just have to add a tank. 2 stage HVAC with fresh air return. Spray Foam insulation on all exterior walls, all bedrooms insulated for sound proofing, metal roof, large porch on front.' ,`Acres` = '' ,`Area` = '46' ,`BuilderName` = 'Cleveland Constructi' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 43 Section 2 Rayburn Country' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '80' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1.5' ,`Style` = 'Other Style' ,`Subdivision` = 'Rayburn Country' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695913' WHERE `Matrix_Unique_ID` = '208281732' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T12:35:42.107' ,`MLSNumber` = '4917390' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '30.015063' ,`Longitude` = '-95.650220' ,`PhotoCount` = '15' ,`PostalCode` = '77429' ,`RoomCount` = '16' ,`ListPrice` = '472175.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Poplar Lake' ,`StreetNumber` = '14623' ,`StreetSuffix` = 'Trail' ,`City` = 'Cypress' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2836' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. Your next home could be this amazing Lake Ridge Builders home in Telge Ranch. Nestled on a spacious lot, this 3-sided brick home boasts a premium elevation, no back neighbors, high ceilings, tile flooring, wrought iron spindles, faux wood blinds, study with French doors, media room, dual vanities in the primary suite, full gutters, sprinkler system, and a covered patio. Prepare incredible feasts in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, and undercabinet lighting. Telge Ranch’s amenities include a recreational park and splash pad. The community is located near the Grand Parkway and Hwy 249, giving residents easy access to a variety of dining, shopping, and entertainment options. Students attend schools in the acclaimed Cypress-Fairbanks ISD. This home is waiting for you – call today!' ,`Acres` = '' ,`Area` = '35' ,`BuilderName` = 'Lake Ridge Builders' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 13 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BLACK ELEMENTARY SCHOOL (CYPRESS-FAIRBANKS)' ,`SchoolHigh` = 'CY-FAIR HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (CYPRESS-FAIRBANKS)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Telge Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.07' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '208662409' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T12:34:43.483' ,`MLSNumber` = '61784374' ,`ListAgentFullName` = 'Michelle Eads' ,`ListOfficeName` = 'Redfin Corporation' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.003092' ,`Longitude` = '-95.497581' ,`PhotoCount` = '46' ,`PostalCode` = '77068' ,`RoomCount` = '12' ,`ListPrice` = '309000.00' ,`Status` = 'Active' ,`StreetName` = 'Brightwood' ,`StreetNumber` = '3903' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3100' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'One owner well maintained home! Sellers added 452 sq ft of large bonus room over garage & an extra bedroom to this lovely home for a spacious total of 3100 sq ft. There are rear exterior stairs leading up to the 2nd floor w/ an entrance near the game room. Upstairs you\'ll find all the bedrooms as well as a loft space w/ built-ins. There is ample parking w/shade & an oversized side entry garage that leads to a lovely covered breezeway & a gorgeous backyard that the seller has put much love into gardening. Brand new roof in 2018, all new HVAC system 2019 - both units, w/ new ductwork as well, & water heater only 4 years old. The whole home was repainted inside & out in 2021 & new super plush carpet was installed in family room downstairs & on the stairway. (Flooring to be updated upstairs!) Dishwasher 2020. F/W/D & portable generator stay w/home. Sprinklers in front. Don\'t miss an opportunity to turn this property into your dream home! Never flooded, gorgeous established neighborhood!' ,`Acres` = '0.2605' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '1960/Cypress Creek North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 20 BLK 21 OAK CREEK VILLAGE SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '11346' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'PAT REYNOLDS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTFIELD HIGH SCHOOL' ,`SchoolMiddle` = 'EDWIN M WELLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Oak Creek Village' ,`TaxAmount` = '5613' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '209344574' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:26:58.693' ,`MLSNumber` = '2315958' ,`ListAgentFullName` = 'Joe Wimberly' ,`ListOfficeName` = 'Lifestyles Realty, Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.297012' ,`Longitude` = '-94.797062' ,`PhotoCount` = '29' ,`PostalCode` = '77550' ,`RoomCount` = '5' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue L' ,`StreetNumber` = '2728' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1838' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Incredible 2-story Galveston home with garage apartment!! The home was recently remodeled but retained a lot of the Galveston charm! You will have Convenient access to Ball High School, shopping, and beaches! You will LOVE that it has 3 full bathrooms and tons of closet space!! Currently, Main house tenant occupied through Feb 2023 and garage apartment through Aug 2022. Don\'t miss your chance!' ,`Acres` = '0.1185' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 14 BLK 87 GALVESTON' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '5160' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Galveston Townsite' ,`TaxAmount` = '4256' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '209396168' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T12:40:36.767' ,`MLSNumber` = '13762818' ,`ListAgentFullName` = 'Kayla Hayden' ,`ListOfficeName` = 'Top Guns Realty on Lake Conroe' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.955349' ,`Longitude` = '-95.907006' ,`PhotoCount` = '40' ,`PostalCode` = '77864' ,`RoomCount` = '13' ,`ListPrice` = '380000.00' ,`Status` = 'Active' ,`StreetName` = 'Shipp' ,`StreetNumber` = '305' ,`StreetSuffix` = 'Street' ,`City` = 'Madisonville' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2641' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous Tilson home right in the heart of Madisonville!! This home is ideal for the family needing lots of room inside and out with the convenience of being in town. This 2,641 sq. ft southern living home boasts 4 bedrooms, 3 full baths, covered front and back porches and awesome floor plan! This split floor plan offers a large kitchen/dining combo that opens up to the living area, adequate bedrooms with a large primary suite and plenty of closet spaces. There is plenty of room for parking for the family and friends and even room for utility parking. The backyard is fully fenced and has an above-ground pool, a small animal shed, a chicken coop, and a feed room. Bring your animals, invite your friends and enjoy this beautiful property and forever home! Call The Wells Team today for your tour!!' ,`Acres` = '0.658' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Madisonville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'A0010 JOB S COLLARD TRACT 549 .658 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '28662' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Right Side' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Js Collard League A-10' ,`TaxAmount` = '6145' ,`TaxRate` = '2.4226' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '209420922' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T12:12:47.803' ,`MLSNumber` = '88892765' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.692807' ,`Longitude` = '-95.212222' ,`PhotoCount` = '15' ,`PostalCode` = '77506' ,`RoomCount` = '2' ,`ListPrice` = '145000.00' ,`Status` = 'Active' ,`StreetName` = 'Denham' ,`StreetNumber` = '109' ,`StreetSuffix` = 'Avenue' ,`City` = 'Pasadena' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '672' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully renovated home in Pasadena. This charming one story features vinyl plank flooring throughout, new cabinetry, granite countertops, new appliances, fresh neutral interior paint, recessed lighting, crown molding throughout & more! Walking/biking distance to the elementary school. Minutes from 225, Beltway 8, 610, 45, Houston Ship Channel & more. Don\'t miss this one!' ,`Acres` = '0.1263' ,`Area` = '6' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Pasadena' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = 'LT 5 BLK 1 VINCE BAYOU PLACE SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5500' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'MORALES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SAM RAYBURN HIGH SCHOOL' ,`SchoolMiddle` = 'SOUTHMORE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Vince Bayou Place' ,`TaxAmount` = '1657' ,`TaxRate` = '2.6514' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '209829807' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:59:28.650' ,`MLSNumber` = '29824521' ,`ListAgentFullName` = 'Zulma Cuevas' ,`ListOfficeName` = 'DBL Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.928020' ,`Longitude` = '-95.902447' ,`PhotoCount` = '45' ,`PostalCode` = '77864' ,`RoomCount` = '3' ,`ListPrice` = '539000.00' ,`Status` = 'Active' ,`StreetName` = 'Wehmeyer' ,`StreetNumber` = '1792' ,`StreetSuffix` = 'Lane' ,`City` = 'Madisonville' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2349' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Wehmeyer - Spacious and Traditional Brick Home offers the new home buyer a wonderful opportunity to live in a desirable area of Madison County. The home has a classic interior featuring 3 bedrooms, 2 full bathrooms, 2 living areas, an office, attached carport, and nice back porch. This corner lot is situated on 3.74 acres has a double entrance; there are several mature oak trees, an uncovered outdoor patio, a 1600 SF (per CAD) pole barn, stock pens, and cross fencing for your animals; horses are welcome. There is ample room to entertain indoors and outdoors here; there are no restrictions or HOA. Enjoy living in a country setting on a few acres with the added benefits of being about 5 minutes from town, schools and shopping. Schedule your private showing today.' ,`Acres` = '3.74' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Madisonville Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'A0010 JOB S COLLARD TRACT 8 3.74 ACRES' ,`LotDesciption` = 'Corner' ,`LotSize` = '162914' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '175 - Madisonville Consolidated' ,`SchoolElementary` = 'MADISONVILLE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MADISONVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MADISONVILLE JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'NA' ,`TaxAmount` = '2935' ,`TaxRate` = '1.7287' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '210066667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:00:09.867' ,`MLSNumber` = '58207659' ,`ListAgentFullName` = 'Gary Bisha' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.983073' ,`Longitude` = '-95.502785' ,`PhotoCount` = '25' ,`PostalCode` = '77541' ,`RoomCount` = '7' ,`ListPrice` = '239990.00' ,`Status` = 'Active' ,`StreetName` = 'Weldon' ,`StreetNumber` = '10219' ,`StreetSuffix` = 'Road' ,`City` = 'Freeport' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1610' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to a Fully Remodeled Home in the historic Jones Creek. Everything is brand new in the house, tile floors , new Granite Countertops , New appliances. Huge lot with no restrictions.' ,`Acres` = '1.5956' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric,Heat Pump' ,`HOAMandatory` = '0' ,`Legal` = 'A0020 S F AUSTIN TRACT 3D (DIV 17) ACRES 1.5956 (%JONES CREE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '69696' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop,Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (BRAZOSPORT)' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'S F Austin' ,`TaxAmount` = '3457' ,`TaxRate` = '2.5124' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '1985' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '210626269' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:14:32.880' ,`MLSNumber` = '68504764' ,`ListAgentFullName` = 'Tammie Bell' ,`ListOfficeName` = 'TBT Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.968306' ,`Longitude` = '-95.268257' ,`PhotoCount` = '8' ,`PostalCode` = '77541' ,`RoomCount` = '5' ,`ListPrice` = '608000.00' ,`Status` = 'Active' ,`StreetName` = 'Bluewater' ,`StreetNumber` = '1743' ,`StreetSuffix` = 'Highway' ,`City` = 'Surfside Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1676' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Ever dreamed of living by the beach? Here\'s your chance! This is a brand new, beautiful 3 bedroom, 2 bathroom beach house! Walk into this spacious open floor plan. The living space is in the front of the home and the bedrooms are towards the back. You won\'t want to miss out on this home, call today for your private showing.' ,`Acres` = '0.6' ,`Area` = '5' ,`BuilderName` = 'Smyth Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Surfside' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'B C I C DIV 1 LOT 208 (A0009 B T ARCHER) (SURFSIDE) ACRES 0.' ,`LotDesciption` = 'Water View' ,`LotSize` = '26136' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'B C I C Div 1' ,`TaxAmount` = '1087' ,`TaxRate` = '2.333' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695914' WHERE `Matrix_Unique_ID` = '211088163' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:01:35.697' ,`MLSNumber` = '51860745' ,`ListAgentFullName` = 'Ronnie Matthews' ,`ListOfficeName` = 'RE/MAX Legends' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.138544' ,`Longitude` = '-95.375532' ,`PhotoCount` = '34' ,`PostalCode` = '77386' ,`RoomCount` = '9' ,`ListPrice` = '439888.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Timbers' ,`StreetNumber` = '3901' ,`StreetSuffix` = 'Lane' ,`City` = 'Spring' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2779' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MOVE-IN READY! GORGEOUS NEWER 4 BEDROOM ON GREAT CORNER LOT! Manicured Exterior with Stone Accents, Covered Front Porch, & Balcony! New Carpet + Fresh Interior Paint (6/2022)! Extensive Hardwood Flooring! Impressive High Ceiling Foyer! Versatile Home Office/Study - French Doors + Crown Millwork! Chef\'s Dream Kitchen: Stainless Appliances + Abundant 42\" White Cabinetry + Tile Backsplash + Corner Walk-In Pantry! Refrigerator Stays! Light & Bright Breakfast Area - Direct Access to Covered Patio! Supersized Family Room - Corner Gas Log Fireplace! Privately Located First Floor Master Suite - Lovely Garden Bath with Dual Sinks + Big Walk-In Closet! Beautiful Iron Staircase Leads to Huge Gameroom/Media Room, Which Offers French Doors Opening Onto Balcony! Big Secondary Bedrooms! Convenient Indoor Utility Room! Covered Patio Overlooks Tranquil Backyard! Automatic Sprinkler System! Master Planned Community with Lake, Rec Center, Pool, Picnic Areas, Sports Courts, ++! Minutes to GP 99! WOW!' ,`Acres` = '0.1437' ,`Area` = '15' ,`BuilderName` = 'Lennar' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S504216 - FALLS AT IMPERIAL OAKS 16, BLOCK 1, LOT 1' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '6258' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BRADLEY ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Falls At Imperial Oaks' ,`TaxAmount` = '10050' ,`TaxRate` = '3.1987' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695915' WHERE `Matrix_Unique_ID` = '211094651' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:16:43.027' ,`MLSNumber` = '2299682' ,`ListAgentFullName` = 'Mitzie Larson' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.280126' ,`Longitude` = '-94.826833' ,`PhotoCount` = '44' ,`PostalCode` = '77551' ,`RoomCount` = '7' ,`ListPrice` = '499900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Q' ,`StreetNumber` = '5605' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1296' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come tour this Galveston Beauty with Great Curb Appeal! Completely rebuilt in 2009! Lovely front porch balcony. Great open space into the Living/Kitchen area with recessed lighting. Breakfast Bar. Kitchen boasts of Granite Countertops & Stainless Steel Appliances. Solid Wood Custom Cabinet. Clean & Crisp front bedroom. Guest bath has granite countertops with a shower/bath combo. Huge Primary Ensuite with Walk-In closet. Super Sized bathroom with granite countertops, double sinks, Garden Tub AND an Extra Large Separate Shower! Laundry room Inside! Extra Large 24X14 Upstairs Back Deck(2021)! Ground floor has an additional 1296 sq.ft. This spacious area has epoxy flooring, appliances, work bench & a 1/2 bath with tons of storage space. Man Cave or Office! This space can be converted into an enclosed area with full bath. Covered Patio! Mobile Generator! Covered Carport! Nice Backyard with a garden space! 2009: Windows/Plumbing/Electrical. Security Cameras/Monitor & Appliances Included!' ,`Acres` = '0.1157' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Midtown - Galveston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 628 M B MENARD SUR LOT 6 SPECIAL SUB AKA LOTS 1 THRU 12' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Denver Resurvey' ,`TaxAmount` = '3448' ,`TaxRate` = '2.0662' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1949' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663695915' WHERE `Matrix_Unique_ID` = '211161323' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-08T13:56:52.890' ,`MLSNumber` = '2211598' ,`ListAgentFullName` = 'Shahar Zarfati' ,`ListOfficeName` = 'Winhill Advisors - Kirby' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.796691' ,`Longitude` = '-95.474135' ,`PhotoCount` = '12' ,`PostalCode` = '77055' ,`RoomCount` = '6' ,`ListPrice` = '730000.00' ,`Status` = 'Active' ,`StreetName` = 'Caywood' ,`StreetNumber` = '1506' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2993' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning new construction at Houston\'s well-established Spring Branch East. CUSTOM SINGLE-FAMILY HOME. The home offers 3 bedrooms, 2.5 baths, a separate Study, Electric Fireplace in Family Room, a formal dining room, breakfast area. \r\nGated driveway with plenty of space to park your car & guests car -20 FEET SPACE.\r\nNO HOA! Hardwood, Beautiful island kitchen, Stainless steel, custom kitchen cabinets. \r\nMultiple custom features such as crown moldings, patio space.\r\nLocated mints from CITY CENTER, GALLERIA, MARQ-E, UPTOWN & TRAILS OF MEMORIAL PARK!! EASY ACCESS TO I-10, 610, 290, AND I-45.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = 'PCA Estate Home' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Block 1, Lot 2' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '3805' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'HOUSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'LANDRUM MIDDLE SCHOOL' ,`ShowInstructions` = 'No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern,Traditional' ,`Subdivision` = 'SHADYVILLA' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663695915' WHERE `Matrix_Unique_ID` = '211177315' --> Updated record success