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-02T15:34:33.693' ,`MLSNumber` = '16550444' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Beazer Homes' ,`SellingAgentFullName` = 'Erica Vasquez' ,`SellingOfficeName` = 'CB&A, Realtors' ,`Latitude` = '29.847163' ,`Longitude` = '-95.815763' ,`PhotoCount` = '11' ,`PostalCode` = '77493' ,`RoomCount` = '11' ,`ListPrice` = '382607.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Sunway' ,`StreetNumber` = '5015' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2384' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '**Home is under construction.** Find total comfort in this beautiful Beazer Home in Marisol, boasting a brick façade, tile flooring, game room, open great room, and a covered patio. Prepare incredible feasts in the kitchen, equipped with a tile backsplash, stainless steel appliances, and 42” upper cabinets. Unwind in the relaxing primary suite, featuring a walk-in closet, dual vanities, and a shower. Residents of Marisol enjoy easy access to a variety of popular shopping and dining spots at the nearby Katy Mills Mall and LaCenterra at Cinco Ranch. Commuters love the easy drive to Downtown Houston and the Energy Corridor via I-10 and the Grand Parkway. Community comforts include a waterfall entry, green spaces, and walking trails. Schools are zoned to the top-rated Katy ISD. You don’t want to miss this home!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Beazer Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 27 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'HASKETT JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Marisol' ,`TaxAmount` = '' ,`TaxRate` = '3.59' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693668' WHERE `Matrix_Unique_ID` = '204269999' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:39:43.093' ,`MLSNumber` = '17657942' ,`ListAgentFullName` = 'Lucy Ware' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.013193' ,`Longitude` = '-95.568864' ,`PhotoCount` = '7' ,`PostalCode` = '77422' ,`RoomCount` = '4' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 769C' ,`StreetNumber` = '2627' ,`StreetSuffix` = '' ,`City` = 'Brazoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1600' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under Construction! (Trenton) This home will offer 3 bedrooms, 2 baths & a 2 car garage. The kitchen will have stainless steel appliances. Big living room that looks out to the covered patio. Spacious primary bedroom and bathroom.' ,`Acres` = '0.297' ,`Area` = '5' ,`BuilderName` = 'MPO Designs' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ROYAL RIDGE SEC 4 (A0059 CUMMINGS-A0020 AUSTIN) LOT 107' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12937' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Royal Ridge Sec 4' ,`TaxAmount` = '42' ,`TaxRate` = '1.6567' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693668' WHERE `Matrix_Unique_ID` = '207259725' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:15:28.803' ,`MLSNumber` = '13196333' ,`ListAgentFullName` = 'Tod Franklin' ,`ListOfficeName` = 'DFWCityhomes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.746754' ,`Longitude` = '-95.614790' ,`PhotoCount` = '45' ,`PostalCode` = '75801' ,`RoomCount` = '11' ,`ListPrice` = '469560.00' ,`Status` = 'Active' ,`StreetName` = 'Inwood' ,`StreetNumber` = '211' ,`StreetSuffix` = 'Drive' ,`City` = 'Palestine' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3409' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your chance at a rare opportunity to own this well preserved unique, custom-built contemporary perched on a large corner lot. Situated a short 2 blocks from an excellent private school. The exterior of this home boasts instant curb appeal with a pull-through circle drive with an impressive Port Cochere at the main entrance. The exterior is beautiful Texas Granbury stone and lovingly refurbished, California Redwood with a detached 2-car garage with a cedar closet, a storage closet, and custom overhead wire shelving.The main floor features Italian Ceramic tile throughout and plantation shutters on the copious floor-to ceiling bronze sunglass windows. It has formal dining with coffered ceilings and large raised separate breakfast room off the kitchen. The kitchen features white tile counters and custom, stained glass, showcase cabinets with stainless sinks and appliances. A half-bath and large laundry room can be accessed near the kitchen which also leads to back entrance of\r\nsunken bar.' ,`Acres` = '0.53' ,`Area` = '75' ,`BuilderName` = 'Paul Elliot' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Palestine Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'INWOOD TERRACE LOT 87A' ,`LotDesciption` = 'Corner' ,`LotSize` = '22760' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground,Vinyl Lined' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '71 - Palestine' ,`SchoolElementary` = '' ,`SchoolHigh` = 'PALESTINE HIGH SCHOOL' ,`SchoolMiddle` = 'PALESTINE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Split Level' ,`Subdivision` = 'Inwood Terrace' ,`TaxAmount` = '7065' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693668' WHERE `Matrix_Unique_ID` = '207848255' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:18:26.737' ,`MLSNumber` = '54596870' ,`ListAgentFullName` = 'Steven Tran' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.678395' ,`Longitude` = '-95.709150' ,`PhotoCount` = '17' ,`PostalCode` = '77407' ,`RoomCount` = '4' ,`ListPrice` = '400000.00' ,`Status` = 'Active' ,`StreetName` = 'Darby Park' ,`StreetNumber` = '9138' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2480' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 2-story carefully maintained home is located on a corner lot and in a cul-de-sac! It features 3 bedrooms and 2 bathrooms down including the primary bedroom. Primary bathroom has double sink vanity with separate tub and shower combo. There is a office/study next to the entrance. The kitchen has granite counter tops, tile backsplash, and stainless steel appliances. Upstairs you will find an additional bedroom and bathroom with a large game-room for entertaining. The game-room has been pre-plumbed for a sink. The backyard has a large covered patio with ample space to install a pool. Images are staged for virtual illustrations only.' ,`Acres` = '0.1739' ,`Area` = '37' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Mission Bend Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'GRAND VISTA SEC 3, BLOCK 1, LOT 12' ,`LotDesciption` = 'Corner,Cul-De-Sac,Subdivision Lot' ,`LotSize` = '7575' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '850' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'PATTERSON ELEMENTARY SCHOOL (FORT BEND)' ,`SchoolHigh` = 'BUSH HIGH SCHOOL' ,`SchoolMiddle` = 'CROCKETT MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Vista Sec 3' ,`TaxAmount` = '7106' ,`TaxRate` = '2.4429' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2014' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693668' WHERE `Matrix_Unique_ID` = '208249404' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:50:42.240' ,`MLSNumber` = '73360452' ,`ListAgentFullName` = 'Luis Ramirez' ,`ListOfficeName` = 'Realty Associates' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.703703' ,`Longitude` = '-95.442599' ,`PhotoCount` = '50' ,`PostalCode` = '77025' ,`RoomCount` = '9' ,`ListPrice` = '680000.00' ,`Status` = 'Active' ,`StreetName` = 'Academy' ,`StreetNumber` = '6909' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2824' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous tri-level townhouse in Park Braeswood Place is on the market! Lush landscape & attached 2-car garage plus 3rd additional parking spot is just the beginning. Sizable foyer welcomes you upon entry. Inside this value, you’ll find a laundry room, glossy wood floor, crown molding, wide baseboards, plantation shutters, & recessed lighting. Large & perfect flowing great room is an entertainer’s delight with its fireplace & balcony access. The gourmet kitchen showcases staggered cabinets w/crown molding, Travertine tile backsplash, SS appliances, granite counters, and an L-shape island w/breakfast bar. Snail staircases take you to the main suite comprised of a private exit, walk-in closet, & a luxurious ensuite w/a large dual vanity, granite counter, & jetted tub. 3rd floor HUGE loft perfect area for an entertainment center, and dedicated home office! The premium paver back patio has private access, great for BBQ and entertaining. Don’t miss it! Call today!' ,`Acres` = '0.0773' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Braeswood Place' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 6 BLK 1 AYRSHIRE SEC 16 AMEND' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '3368' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'TWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BELLAIRE HIGH SCHOOL' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Ayshire Amd Add Sec 16 Place' ,`TaxAmount` = '14325' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2007' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693668' WHERE `Matrix_Unique_ID` = '208680894' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:11:04.037' ,`MLSNumber` = '72759989' ,`ListAgentFullName` = 'Faron Daigle' ,`ListOfficeName` = 'Faron Daigle Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.140176' ,`Longitude` = '-95.055531' ,`PhotoCount` = '50' ,`PostalCode` = '77554' ,`RoomCount` = '11' ,`ListPrice` = '999000.00' ,`Status` = 'Active' ,`StreetName` = 'Bay' ,`StreetNumber` = '22315' ,`StreetSuffix` = 'Vista' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2167' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '22315 Bay Vista is a 4 B/R 3 bath, canal front home in Isla Del Sol. Exterior features: 18\'-20\' boat slip with electric lift & fish cleaning station, upper level deck overlooking the canal, tandem garage, outdoor shower, workshop, outdoor bar w/sink overlooks the canal & patio area, triple wide drive, 3-car covered parking & electric lift from ground to 1st living level. Siding replaced w/ cement board. Windows replaced with dbl pane hi-efficiency windows. Interior offers large family room w/built-in shelving & wall of windows overlooking the deck & canal, dbl island kitchen w/electric cook-top, convection oven, slab granite counter and island tops, B/I icemaker, huge walk-in pantry w/wine fridge, primary & 1 additional bedroom on 1st level, large indoor laundry & full bath #2 on the 1st level. French door access to private balcony in B/R\'s 1 & 2 overlooks the bay across the street. Oversized shower, dbl vanities, garden tub & large W/I closet in primary. New windstorm rated windows.' ,`Acres` = '0.093' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 27 BLK 8 ISLA DEL SOL SUB' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View,Waterfront' ,`LotSize` = '4051' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '300' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven,Single 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,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Isla Del Sol' ,`TaxAmount` = '11881' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693668' WHERE `Matrix_Unique_ID` = '209300231' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:12:05.173' ,`MLSNumber` = '74445915' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.072279' ,`Longitude` = '-94.005096' ,`PhotoCount` = '42' ,`PostalCode` = '75931' ,`RoomCount` = '11' ,`ListPrice` = '429000.00' ,`Status` = 'Active' ,`StreetName` = 'Wingate' ,`StreetNumber` = '1072' ,`StreetSuffix` = 'Boulevard' ,`City` = 'Brookeland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1614' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Unique find in the heart of Rayburn Country on over 3 acres!! This adorable 3 Bed / 2 Bath 1614 sqft home situated on 3.3 acres is ready to be your Lake Sam Rayburn get-away! Space and potential abound in this charming home featuring 4 attached garages with 1 bay currently equipped as a home workshop. The beautiful acreage leaves you with an immense amount of possibility from adding a workshop, garage, guest house or simply room for gardening or kid/pet play areas! A short cart ride to Rayburn Country Resort & Golfing or a small drive to Lake Sam Rayburn, Public Boat Ramps, Local Shopping, Restaurants and Angelina/Sabine National Forests! Whether you\'re in the market for full or part time property, this home is definitely a MUST SEE! \r\n*Virtually staged renderings in photos' ,`Acres` = '3.301' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'AB 987 W LANDES & CO SEC 152 TR 3 518 /923 3.301 ACRES' ,`LotDesciption` = 'Cleared,In Golf Course Community' ,`LotSize` = '143792' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '420' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '4' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '144 - Brookeland' ,`SchoolElementary` = 'BROOKELAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BROOKELAND HIGH SCHOOL' ,`SchoolMiddle` = 'BROOKELAND HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Rayburn Country' ,`TaxAmount` = '3243' ,`TaxRate` = '1.6721' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '209370910' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:54:58.450' ,`MLSNumber` = '75805162' ,`ListAgentFullName` = 'Bonnie Schinnerer' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809331' ,`Longitude` = '-94.834626' ,`PhotoCount` = '18' ,`PostalCode` = '77523' ,`RoomCount` = '9' ,`ListPrice` = '1800000.00' ,`Status` = 'Active' ,`StreetName` = 'FM 565 Road' ,`StreetNumber` = '5707' ,`StreetSuffix` = '' ,`City` = 'Baytown' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1152' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '2.48 acres. This property can be utilized for Commercial or Residential endeavors. The potential is endless, multi family, retail, etc.. Easy access to I-10 and Grand Parkway. Includes Manufactured Home and Shop. Water and Electricity on property.' ,`Acres` = '2.48' ,`Area` = '53' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = '306 TR 107C-0 ABJ WINFREE INCLUDES IMP ONLY P NO. 51593' ,`LotDesciption` = 'Other' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '' ,`TaxRate` = '1' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '209878297' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:03:06.610' ,`MLSNumber` = '62621264' ,`ListAgentFullName` = 'Fredricka Bradshaw' ,`ListOfficeName` = 'Mark Fox CO. Real Esate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.588273' ,`Longitude` = '-98.383873' ,`PhotoCount` = '14' ,`PostalCode` = '78654' ,`RoomCount` = '4' ,`ListPrice` = '130000.00' ,`Status` = 'Active' ,`StreetName` = 'Sweetbriar' ,`StreetNumber` = '130' ,`StreetSuffix` = 'Drive' ,`City` = 'Granite Shoals' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '564' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Shag-a-delic...this fun and eclectic 1969 manufactured home is a time capsule and is move-in ready. This 2 bedroom, 1 bath manufactured home is situated on two lots and has approximately 600sqft of living space. As a second home, as a lake house/cabin, the years have been kind to the home. Two storage buildings have ample room for boats or jet skis, with access to the storage buildings from the rear lot, with a gate on Bluebriar. There is a carport for shade from the hot Texas sun. All furnishings and dishes in the house convey, along with refrigerator, bed frames, and mattresses/box springs. This home would be great continuing as a second residence, lake house, or rental property. Granite Shoals is located on Lake LBJ, and is growing, and developing, with population growing at a steady rate. Minutes to Marble Falls and Horseshoe Bay, 50 minutes from Austin, and 1.5 hours from San Antonio.' ,`Acres` = '0.1148' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Propane,Space Heater' ,`HOAMandatory` = '0' ,`Legal` = 'S8210 SWEETBRIAR(SHERWOOD SHORES) LOT 53' ,`LotDesciption` = 'Cleared,Other,Subdivision Lot' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition,Wood Shingle' ,`SchoolDistrict` = '124 - Marble Falls' ,`SchoolElementary` = 'HIGHLAND LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MARBLE FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'MARBLE FALLS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Sweetbriar' ,`TaxAmount` = '286' ,`TaxRate` = '2.1198' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '1969' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '209901627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:04:51.677' ,`MLSNumber` = '97370895' ,`ListAgentFullName` = 'Lucy Ware' ,`ListOfficeName` = 'Birdsong Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.168439' ,`Longitude` = '-95.434659' ,`PhotoCount` = '7' ,`PostalCode` = '77515' ,`RoomCount` = '4' ,`ListPrice` = '204995.00' ,`Status` = 'Active' ,`StreetName` = 'W Live Oak Street' ,`StreetNumber` = '214' ,`StreetSuffix` = '' ,`City` = 'Angleton' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1360' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '4K Construction is excited to start New Construction in Jamison Park! These homes will offer a floor plan that will be great for entertaining. 3 spacious bedrooms, dining room, living area and a 1 car attached garage. Flooring includes vinyl planks, carpet and ceramic tile. The kitchen includes granite counter tops along with a dishwasher, electric stove & microwave. Both bathrooms will have quartz countertops with marble showers. These homes will come with a covered back patio area that is a great for relaxing. Schedule your appointment today! Elevations and plans are subject to change at builder\'s discretion.' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = '4K Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'KING SD (ANGLETON) LOT 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'WESTSIDE ELEMENTARY SCHOOL (ANGLETON)' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Jamison Angleton' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '209941558' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:39:05.403' ,`MLSNumber` = '22185482' ,`ListAgentFullName` = 'Sherril Bates' ,`ListOfficeName` = 'Bates-Brinkley Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.959176' ,`Longitude` = '-95.167269' ,`PhotoCount` = '50' ,`PostalCode` = '77044' ,`RoomCount` = '12' ,`ListPrice` = '690000.00' ,`Status` = 'Active' ,`StreetName` = 'Canova Hill' ,`StreetNumber` = '16106' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4875' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Absolutely stunning gorgeous home!!!!! Grand entry as you enter this home with formals and hardwood floors. The exquisite family room has 18ft ceilings with a whole wall of windows for great light and a feeling of the outdoors framed with wooden blinds. You will love the spacious kitchen, with large island, upgraded appliances, Butler\'s pantry, and pretty granite countertops ready for the Chef of the family. Two stairs ways up to the second floor, one off kitchen and entry area. Primary bedroom suite downstairs, plus additional guest suite for family. Upstairs has game room, media room and remaining three bedrooms upstairs plus an additional room 336 sq ft that was attic area that adds extra square footage. This home also has so many upgrades, such as $20,000 of chandeliers, and special lighting to name a few. Back yard has loads of extra concrete for extra activities. You must see to appreciate all the many features of this home. Call for viewing today!!!!' ,`Acres` = '0.2329' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Summerwood/Lakeshore' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 28 BLK 1 LAKESHORE SEC 14 AMEND' ,`LotDesciption` = 'Subdivision Lot,Wooded' ,`LotSize` = '10146' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '924' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '29 - Humble' ,`SchoolElementary` = 'LAKESHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SUMMER CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'AUTUMN RIDGE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Amending 01' ,`TaxAmount` = '12169' ,`TaxRate` = '2.863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '209982840' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:04:49.797' ,`MLSNumber` = '32254440' ,`ListAgentFullName` = 'William Gilley' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.369996' ,`Longitude` = '-95.639030' ,`PhotoCount` = '19' ,`PostalCode` = '77316' ,`RoomCount` = '9' ,`ListPrice` = '1205000.00' ,`Status` = 'Active' ,`StreetName` = 'Blue Heron' ,`StreetNumber` = '245' ,`StreetSuffix` = 'Drive' ,`City` = 'Montgomery' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4369' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW HOME UNDER CONSTRUCTION! Modern home style in Blue Heron Bay. Home will have the slab poured at the beginning of August. Anticipated completion date of January 2023.' ,`Acres` = '0.7955' ,`Area` = '39' ,`BuilderName` = 'ALCONCORP' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLUE HERON BAY 02, BLOCK 3, LOT 2' ,`LotDesciption` = 'Wooded' ,`LotSize` = '34650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '938' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '37 - Montgomery' ,`SchoolElementary` = 'STEWART CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAKE CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'OAK HILL JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Blue Heron Bay 02' ,`TaxAmount` = '2447' ,`TaxRate` = '2.3542' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '210532303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T15:27:47.580' ,`MLSNumber` = '30673722' ,`ListAgentFullName` = 'Duc Nguyen' ,`ListOfficeName` = 'America Investment Group ' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.697029' ,`Longitude` = '-95.507195' ,`PhotoCount` = '19' ,`PostalCode` = '77074' ,`RoomCount` = '3' ,`ListPrice` = '313500.00' ,`Status` = 'Active' ,`StreetName` = 'Carvel' ,`StreetNumber` = '7015' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1894' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Single family, no carpet, big back yard, close to Houston Baptist University, easy to go to HWY 59, Bellaire Blvd, shopping, Markets' ,`Acres` = '0.1818' ,`Area` = '21' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Sharpstown Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 32 SHARPSTOWN SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7920' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SUTTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SHARPSTOWN HIGH SCHOOL' ,`SchoolMiddle` = 'LONG MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Sharpstown Sec 02' ,`TaxAmount` = '4626' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1959' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693669' WHERE `Matrix_Unique_ID` = '210597277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:18:33.563' ,`MLSNumber` = '90482891' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.261069' ,`Longitude` = '-95.463103' ,`PhotoCount` = '44' ,`PostalCode` = '77515' ,`RoomCount` = '13' ,`ListPrice` = '834990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Ranch' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '4052' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated on almost 2.5 acres, the Laguna II is a sophisticated design packed with unique features! A 2 story grand entry with a sweeping spiral staircase, along with a two-story family room makes an impressive statement in this stunning five-bedroom plan. The secluded primary suite features a huge luxurious bathroom with his and hers walk-in closets, separate vanities, a large soaker tub, and a separate oversized walk-in shower. This home makes entertaining a breeze with a family-size media and game room on the second story.' ,`Acres` = '2.465' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 9, Block 5, Section 1' ,`LotDesciption` = 'Other' ,`LotSize` = '107375' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693670' WHERE `Matrix_Unique_ID` = '210637343' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:18:22.190' ,`MLSNumber` = '10349414' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.263719' ,`Longitude` = '-95.471467' ,`PhotoCount` = '21' ,`PostalCode` = '77515' ,`RoomCount` = '9' ,`ListPrice` = '772990.00' ,`Status` = 'Active' ,`StreetName` = 'Redbird' ,`StreetNumber` = '711' ,`StreetSuffix` = 'Court' ,`City` = 'Angleton' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3254' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This stunning plan includes 4 bedrooms, 3.5 bathrooms, a gameroom & a covered patio!' ,`Acres` = '2.031' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12, Block 2, Section 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '88470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693670' WHERE `Matrix_Unique_ID` = '210726627' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:18:11.287' ,`MLSNumber` = '87818732' ,`ListAgentFullName` = 'Bryan Bass' ,`ListOfficeName` = 'Texas Property Traders, INC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.264366' ,`Longitude` = '-95.468002' ,`PhotoCount` = '30' ,`PostalCode` = '77515' ,`RoomCount` = '10' ,`ListPrice` = '772990.00' ,`Status` = 'Active' ,`StreetName` = 'Chenango Lake' ,`StreetNumber` = '21303' ,`StreetSuffix` = 'Drive' ,`City` = 'Angleton' ,`BathsFull` = '4' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '3688' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The gorgeous Frisco plan boasts 5 bedrooms, 4 bathrooms & a gameroom and media room!' ,`Acres` = '1.385' ,`Area` = '5' ,`BuilderName` = 'CastleRock' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Angleton' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 2, Block 2, Section 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '60330' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '5 - Angleton' ,`SchoolElementary` = 'FRONTIER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANGLETON HIGH SCHOOL' ,`SchoolMiddle` = 'ANGLETON MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Other Style,Traditional' ,`Subdivision` = 'Chenango Ranch' ,`TaxAmount` = '' ,`TaxRate` = '1.986' ,`WaterSewer` = 'Aerobic,Public Water,Septic Tank' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693670' WHERE `Matrix_Unique_ID` = '210730116' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-02T14:51:20.623' ,`MLSNumber` = '52943377' ,`ListAgentFullName` = 'Michael Greiner' ,`ListOfficeName` = 'My Castle Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.890608' ,`Longitude` = '-94.009552' ,`PhotoCount` = '10' ,`PostalCode` = '77640' ,`RoomCount` = '6' ,`ListPrice` = '54750.00' ,`Status` = 'Active' ,`StreetName` = 'Shirley' ,`StreetNumber` = '2163' ,`StreetSuffix` = 'Street' ,`City` = 'Port Arthur' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1400' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'HOME BEING SOLD AS-IS. OWNER FIN. AVAILABLE. \r\n3 Bed, 1 Bath, 1 Car Garage. Home is approx 1400 SqFt. Lot is approx 9,100 SqFt.' ,`Acres` = '0.2089' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 7 BLK 23 PALOMAR' ,`LotDesciption` = 'Other' ,`LotSize` = '9100' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '236 - Port Arthur' ,`SchoolElementary` = 'PORT ACRES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MEMORIAL HIGH SCHOOL (PORT ARTHUR)' ,`SchoolMiddle` = 'LINCOLN MIDDLE SCHOOL (PORT ARTHUR)' ,`ShowInstructions` = 'Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Palomar' ,`TaxAmount` = '1789' ,`TaxRate` = '3.267' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693670' WHERE `Matrix_Unique_ID` = '210910226' --> Updated record success