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-05T15:06:17.707' ,`MLSNumber` = '60209382' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = ' Non-MLS Agent' ,`SellingOfficeName` = 'Non-MLS ' ,`Latitude` = '29.405584' ,`Longitude` = '-95.045678' ,`PhotoCount` = '16' ,`PostalCode` = '77568' ,`RoomCount` = '15' ,`ListPrice` = '449860.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Morning Villa' ,`StreetNumber` = '13125' ,`StreetSuffix` = 'Drive' ,`City` = 'Texas City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2958' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Under construction. This beautiful Briarwood Home in Lago Mar has it all. Nestled on a lakefront lot, this 4-sided brick home boasts a premium elevation, no backyard neighbors, open ceilings, tile flooring, wrought iron spindles, faux wood blinds, cast stone fireplace, media room with surround sound prewire, study with French doors, full gutters, and a covered patio. Master new recipes in the kitchen, complete with granite countertops, tile backsplash, stainless steel appliances, 42” upper cabinets, & undercabinet lighting. With dual vanities, a drop-in tub, and a separate shower, the primary suite is the best place to unwind. Lago Mar is home to Texas’ largest crystal lagoon, a 12-acre Caribbean blue lagoon surrounded by white sand beaches. Other community amenities include a clubhouse, fitness center, and playground. Located off I-45, residents enjoy easy access to major business centers and popular shopping malls. Schools are zoned to Dickinson ISD. Book your private showing today!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Briarwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Texas City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 14 Block 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '17 - Dickinson' ,`SchoolElementary` = 'LOBIT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DICKINSON HIGH SCHOOL' ,`SchoolMiddle` = 'LOBIT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Lago Mar' ,`TaxAmount` = '' ,`TaxRate` = '3.5521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694806' WHERE `Matrix_Unique_ID` = '202054354' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T14:53:19.230' ,`MLSNumber` = '65287671' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = 'Nora Sanchez' ,`SellingOfficeName` = 'NextHome Realty Center' ,`Latitude` = '29.644636' ,`Longitude` = '-95.027897' ,`PhotoCount` = '29' ,`PostalCode` = '77571' ,`RoomCount` = '8' ,`ListPrice` = '350000.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Lucky Manor' ,`StreetNumber` = '177' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2327' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 65287671 - Built by HistoryMaker Homes - Ready Now! ~ Built by HistoryMaker Homes, January 2022 completion! This 3 bedroom, 2.5 bathroom, two-story home boasts a soaring two-story entry and 9\' ceilings throughout the remainder of the 1st floor. Luxury vinyl plank can be found in the common areas and all baths. The chef-inspired kitchen offers 42 inch white cabinetry with crown molding, ceramic tile backsplash, granite countertops, a corner walk-in pantry, and stainless-steel appliances that make entertaining easy. Settle into the spacious primary bedroom located on first floor and bathroom with dual sink vanity and 60-inch shower. This home comes with full sod, full irrigation, and covered back patio.' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 22 BLK 3 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5340' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694806' WHERE `Matrix_Unique_ID` = '202972493' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:08:56.743' ,`MLSNumber` = '73529159' ,`ListAgentFullName` = 'Michelle Comstock' ,`ListOfficeName` = 'Compass RE Texas, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.766174' ,`Longitude` = '-95.574173' ,`PhotoCount` = '36' ,`PostalCode` = '77079' ,`RoomCount` = '10' ,`ListPrice` = '2195000.00' ,`Status` = 'Active' ,`StreetName` = 'Wycliffe' ,`StreetNumber` = '303' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '6' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '6218' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to the home of your dreams on one of the most incredible lots that backs to the Terry Hershey Park Hike & Bike Trail. This home is a true showstopper so lightly lived in, it feels new! This magnificent custom home built by Trinity Estates Homes shows perfectly; outstanding attention to detail & excellent craftsmanship is evident throughout. As you walk in, you are greeted with the breathtaking view of the pool & spa, luscious landscape, and bike trail through the gorgeous windows. Primary bedroom down is a retreat of its own w/sitting area, fireplace, French doors that lead to a private patio, and views to the outside. All upstairs bedrooms are en suite, great size game room, wet bar & spacious 2nd floor patio with fireplace and tv. Outdoor living is at its best at this residence w/pool & spa w/fire bowls & water features, sit under the amazing covered patio w/fireplace, ceiling fans, tv & outdoor kitchen w/gas grill, sink, and woodburning pizza oven. You must see this beauty!' ,`Acres` = '0.4659' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '4' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 5 MEMORIAL TRAILS' ,`LotDesciption` = 'Greenbelt,Subdivision Lot' ,`LotSize` = '20294' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Double Oven,Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'RUMMEL CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'MEMORIAL MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'French,Other Style' ,`Subdivision` = 'Memorial Trails' ,`TaxAmount` = '49613' ,`TaxRate` = '2.4733' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2012' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694806' WHERE `Matrix_Unique_ID` = '205161560' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T14:23:29.863' ,`MLSNumber` = '77584980' ,`ListAgentFullName` = 'Hugo Mendoza' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.059571' ,`Longitude` = '-95.100825' ,`PhotoCount` = '18' ,`PostalCode` = '77336' ,`RoomCount` = '2' ,`ListPrice` = '235000.00' ,`Status` = 'Active' ,`StreetName` = 'Sandy' ,`StreetNumber` = '103' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1086' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful waterfront property!! Water access on two sides of property. Great place to spend your time fishing, boating or enjoying the peacefulness. city water available.' ,`Acres` = '0.28' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Huffman Area' ,`HeatSystem` = 'Butane' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 81A BLK 2 PLANTATION HILLS' ,`LotDesciption` = 'Water View,Wooded' ,`LotSize` = '12024' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '28 - Huffman' ,`SchoolElementary` = 'FALCON RIDGE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HARGRAVE HIGH SCHOOL' ,`SchoolMiddle` = 'HUFFMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Hills' ,`TaxAmount` = '1844' ,`TaxRate` = '2.4592' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1970' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694806' WHERE `Matrix_Unique_ID` = '206340261' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:09:05.933' ,`MLSNumber` = '17320010' ,`ListAgentFullName` = 'Lance Loken' ,`ListOfficeName` = 'Long Lake LTD' ,`SellingAgentFullName` = 'Irene Taylor' ,`SellingOfficeName` = 'REALM Real Estate Professional' ,`Latitude` = '29.836233' ,`Longitude` = '-95.727791' ,`PhotoCount` = '12' ,`PostalCode` = '77449' ,`RoomCount` = '16' ,`ListPrice` = '517215.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Enrique' ,`StreetNumber` = '20622' ,`StreetSuffix` = 'Drive' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3258' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This home is under construction. This beautiful Postwood Home in Westfield Ranch is what you’re looking for. Resting on a spacious lot, this 4-sided brick home boasts a stone front, no back neighbors, tile flooring, crown molding, curved staircase, wrought iron spindles, faux wood blinds, media room with surround sound pre-wire, sprinkler system, and a covered patio. Cook up new cuisines in the kitchen, equipped with granite countertops, tile backsplash, stainless steel appliances, and 42” upper cabinets. Community amenities include a playground, splash pad, and sports field. Located off Fry Road and the Grand Parkway, residents have quick access to a variety of popular restaurants and shopping centers, including the Katy Mills Mall. Students attend schools in the highly acclaimed Cypress-Fairbanks ISD. Don’t wait – call now for more information!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Postwood Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Bear Creek South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 18 Block 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '475' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'M ROBINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS PARK HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (CY-FAIR)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Westfield Ranch' ,`TaxAmount` = '' ,`TaxRate` = '3.32' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694806' WHERE `Matrix_Unique_ID` = '206990312' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:09:40.987' ,`MLSNumber` = '89010813' ,`ListAgentFullName` = 'Rachel Gilbert' ,`ListOfficeName` = 'JPAR-The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.864640' ,`Longitude` = '-97.027225' ,`PhotoCount` = '15' ,`PostalCode` = '77904' ,`RoomCount` = '11' ,`ListPrice` = '419000.00' ,`Status` = 'Active' ,`StreetName` = 'Woodchase' ,`StreetNumber` = '220' ,`StreetSuffix` = 'Drive' ,`City` = 'Victoria' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3664' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful spacious home with unlimited potential. House has original doors and windows. Air conditioning units recently serviced. The roof is all concrete shingles. Large master bedroom with ensuite and access to the back yard and patio area. Two Large Living areas downstairs and another upstairs allow for plenty of room for multigenerational family. There are two other bedrooms on the split plan that share a jack and jill bath each with its own sink and closets. Hall entrance to the upper level allows guests or family living upstairs privacy without having to enter the main space on the 1st level. House offers a 3-car garage. This house has so much to offer ....... call today to schedule your showing of this house, it won\'t last long.' ,`Acres` = '0.2869' ,`Area` = '66' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'WOODWAY III LOT 9 BLOCK 5' ,`LotDesciption` = 'Other' ,`LotSize` = '12496' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '363' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '191 - Victoria' ,`SchoolElementary` = 'ELLA SCHORLEMMER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VICTORIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'HAROLD CADE MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Woodway III' ,`TaxAmount` = '8818' ,`TaxRate` = '2.3976' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '1988' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694806' WHERE `Matrix_Unique_ID` = '207211667' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T14:30:33.627' ,`MLSNumber` = '56677148' ,`ListAgentFullName` = 'Craig Jones' ,`ListOfficeName` = 'Eastex Real Estate Brokerage' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.699498' ,`Longitude` = '-94.938897' ,`PhotoCount` = '33' ,`PostalCode` = '77351' ,`RoomCount` = '4' ,`ListPrice` = '549000.00' ,`Status` = 'Active' ,`StreetName` = 'Hummingbird' ,`StreetNumber` = '123' ,`StreetSuffix` = 'Circle' ,`City` = 'Livingston' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4957' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 4-bedroom 4.5 bath brick home with a large lot in the desirable Enchanted Forest Subdivision. Entertain your guest with your own in-ground pool or hang out in your living room around the open bar where you have full view of the pool. Part of the back yard is already fenced for your dogs and there is a backstop ready for you to play baseball. All of the bedrooms are spacious with each one having its own full bath. Most of the bedrooms have carpet while the majority of the house has tile. The garage has a door on both sides making it easy for you to pull in one side and out the other. The neighborhood has access to the city park that has the pool, tennis courts, track and golf course. The commute to Houston is easy by way of 59/I69. Come make this your home today!' ,`Acres` = '1.485' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ENCHANTED FOREST LOT 34 & 35' ,`LotDesciption` = 'In Golf Course Community,Subdivision Lot' ,`LotSize` = '64687' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Enchanted Forest' ,`TaxAmount` = '3893' ,`TaxRate` = '1.8745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '207452650' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:10:22.667' ,`MLSNumber` = '76613566' ,`ListAgentFullName` = 'Bobbie Alexander' ,`ListOfficeName` = 'Alexander Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.707417' ,`Longitude` = '-95.871251' ,`PhotoCount` = '35' ,`PostalCode` = '77441' ,`RoomCount` = '6' ,`ListPrice` = '543595.00' ,`Status` = 'Active' ,`StreetName` = 'Rising Moon' ,`StreetNumber` = '28607' ,`StreetSuffix` = 'Lane' ,`City` = 'Fulshear' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '2255' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS#76613566 - Built by Taylor Morrison - Ready September! Wedgewood’s expansive open-concept common area holds a gathering room, kitchen with island and step-in pantry, and a casual dining nook. A formal dining room opens to the main living area. Owner\'s suite features dual sinks and large walk in closets. Guest suite with private bath is located in front of the home. Corner lot! This Fulshear, TX 55+ new home community is at once innovative and just a whole lot of fun. Structural options added to 28607 Rising Moon Lane include: walk-in and mud-set shower at owner\'s bath, extended owner\'s suite, study.' ,`Acres` = '0.19' ,`Area` = '30' ,`BuilderName` = 'Taylor Morrison' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Approved Seniors Project,Exclusions,HOA First Right of Refusal,Home Protection Plan,Mud,Other Disclosures,Special Addendum' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Southwest' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 7 Block 2' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '8694' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '2925' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'HUGGINS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'FULSHEAR HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERTS/LEAMAN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,No Supra Keybox,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bonterra at Cross Creek Ranch 60\'s' ,`TaxAmount` = '' ,`TaxRate` = '3.37' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '208248484' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T14:54:25.247' ,`MLSNumber` = '44069101' ,`ListAgentFullName` = 'Ben Caballero' ,`ListOfficeName` = 'HomesUSA.com' ,`SellingAgentFullName` = 'Nora Sanchez' ,`SellingOfficeName` = 'NextHome Realty Center' ,`Latitude` = '29.645053' ,`Longitude` = '-95.028341' ,`PhotoCount` = '22' ,`PostalCode` = '77571' ,`RoomCount` = '7' ,`ListPrice` = '320633.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'Wedgewood Trace' ,`StreetNumber` = '121' ,`StreetSuffix` = 'Lane' ,`City` = 'La Porte' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1488' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'MLS# 44069101 - Built by HistoryMaker Homes - October completion! ~ Beautiful Caddo plan offers exemplary single-story living. Luxury vinyl plank flooring is found throughout the common areas and the entire home boasts 9\' ceilings. The home-chef will love the quartz counter tops, stainless-steel Whirlpool appliances, island, 42 cabinetry with crown molding, and corner walk-in pantry. The primary bedroom boasts a oversized shower plus separate soaking tub, dual sinks, and 2 separate closet. The secondary bedrooms and hall bath are located off the privately located hallway!!' ,`Acres` = '' ,`Area` = '7' ,`BuilderName` = 'HistoryMaker Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'La Porte/Shoreacres' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 11 BLK 3 ARTESIA VILLAGE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5340' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '575' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '35 - La Porte' ,`SchoolElementary` = 'BAYSHORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LA PORTE HIGH SCHOOL' ,`SchoolMiddle` = 'LA PORTE J H' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Artesia Village' ,`TaxAmount` = '' ,`TaxRate` = '2.78' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '208737808' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:56:38.713' ,`MLSNumber` = '94783169' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836398' ,`Longitude` = '-95.796830' ,`PhotoCount` = '22' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '434730.00' ,`Status` = 'Active' ,`StreetName` = 'Wild Bramble' ,`StreetNumber` = '24302' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2764' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready August 2022! Two story with more to adore. A formal dining room flows to the vast kitchen, casual meal spot & family oasis. Upstairs bed, game & media rooms hide from the tranquil downstairs primary suite. Oversized walk-in closet. Katy Pointe is located in a prime location in one of greater Houston’s hottest markets with easy access to the Grand Parkway, Katy Freeway, and a convenient commute to major employers. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Heat Pump,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0129 Plan 3L08B' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '210363832' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:57:39.210' ,`MLSNumber` = '77054445' ,`ListAgentFullName` = 'Patrick McGrath' ,`ListOfficeName` = 'Meritage Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.836343' ,`Longitude` = '-95.797217' ,`PhotoCount` = '11' ,`PostalCode` = '77493' ,`RoomCount` = '4' ,`ListPrice` = '409440.00' ,`Status` = 'Active' ,`StreetName` = 'Reese Ravine' ,`StreetNumber` = '4319' ,`StreetSuffix` = 'Lane' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2594' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand NEW energy-efficient home ready August 2022! Skip your commute and work from home in the quiet main level flex space. The upstairs game room makes a great media or play space. Downstairs, a large walk-in closet and bath complement the private primary suite. Katy Pointe is located in a prime location in one of greater Houston’s hottest markets with easy access to the Grand Parkway, Katy Freeway, and a convenient commute to major employers. Known for their energy-efficient features, our homes help you live a healthier and quieter lifestyle while saving thousands of dollars on utility bills.' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Meritage Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'SF 0110 Plan 880C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '590' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'BETHKE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Pointe' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '210364742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:08:37.840' ,`MLSNumber` = '40171230' ,`ListAgentFullName` = 'Wendy Devillier' ,`ListOfficeName` = 'Arrow Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.075048' ,`Longitude` = '-94.738309' ,`PhotoCount` = '8' ,`PostalCode` = '77575' ,`RoomCount` = '2' ,`ListPrice` = '92000.00' ,`Status` = 'Active' ,`StreetName` = 'Martin L King' ,`StreetNumber` = '834' ,`StreetSuffix` = 'Street' ,`City` = 'Ames' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '651' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '1' ,`Area` = '52' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Liberty' ,`HeatSystem` = 'Window Unit' ,`HOAMandatory` = '0' ,`Legal` = '000073 JAMES MARTIN, TRACT 142, ACRES 1.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '73 - Liberty' ,`SchoolElementary` = 'LIBERTY ELEMENTARY SCHOOL (LIBERTY)' ,`SchoolHigh` = 'LIBERTY HIGH SCHOOL (LIBERTY)' ,`SchoolMiddle` = 'LIBERTY MIDDLE SCHOOL (LIBERTY)' ,`ShowInstructions` = 'Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'James Martin' ,`TaxAmount` = '1449' ,`TaxRate` = '2.5796' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '210474099' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:05:16.387' ,`MLSNumber` = '91628429' ,`ListAgentFullName` = 'Melody Pevateaux' ,`ListOfficeName` = 'Weichert,REALTORS-Murray Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.371815' ,`Longitude` = '-95.244095' ,`PhotoCount` = '5' ,`PostalCode` = '77328' ,`RoomCount` = '4' ,`ListPrice` = '499000.00' ,`Status` = 'Active' ,`StreetName` = 'Holstein' ,`StreetNumber` = '4244' ,`StreetSuffix` = 'Drive' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2145' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home to Peach Creek Plantation! This BRAND NEW single level modern farmhouse is the one you\'ve been waiting for. Property features include luxury vinyl plank flooring, a massive kitchen island that\'s made for gathering, a walk in pantry, covered patio, and a home office. This lake view property is peacefully situated on one acre away from the hustle and bustle of the city, and is sure to WOW you! Make this one home today! Estimated completion Sep 2022.' ,`Acres` = '1.11' ,`Area` = '19' ,`BuilderName` = 'America\'s Home Place' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S782903 - PEACH CREEK PLANTATION 03, BLOCK 2, LOT 8, ACRES 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '48352' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '200' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'AUSTIN ELEMENTARY SCHOOL (CONROE)' ,`SchoolHigh` = 'CANEY CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'MOORHEAD JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Craftsman' ,`Subdivision` = 'Peach Creek Plantation 03' ,`TaxAmount` = '667' ,`TaxRate` = '1.8488' ,`WaterSewer` = 'Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694807' WHERE `Matrix_Unique_ID` = '211013890' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:11:39.540' ,`MLSNumber` = '6167441' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.233263' ,`Longitude` = '-95.241386' ,`PhotoCount` = '14' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '288990.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hollow' ,`StreetNumber` = '14854' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to HARRINGTON TRAILS -- just 30 minutes north of Downtown Houston with easy access to Hwy 59, Grand Parkway, and lots of great shopping & dining. This community features swimming pool/splash pad, Rec Center, trails, playground, and is walking distance from Timber Lakes Elementary School. This POPULAR 4 bed, 2.5 bath home features an open FAMILY ROOM w/ high ceilings, ISLAND kitchen that opens to dining and family room, LOTS of cabinet & counter space, vinyl plank wood flooring throughout main areas, UPSTAIRS GAME ROOM, and spacious guest bedrooms! Primary retreat with dual sinks, BUILT IN shelving, oversized shower, and walk-in closet. Enjoy the COVERED patio-- Perfect for entertaining! Zoned to Splendora ISD. Schedule your PRIVATE showing today!!' ,`Acres` = '0.11' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S573392 - Harrington Trails 05B, BLOCK 2, Lot 7' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694808' WHERE `Matrix_Unique_ID` = '211092798' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:02:35.697' ,`MLSNumber` = '94866740' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.232618' ,`Longitude` = '-95.242476' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '297875.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hollow' ,`StreetNumber` = '14902' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to HARRINGTON TRAILS -- just 30 minutes north of Downtown Houston with easy access to Hwy 59, Grand Parkway, and lots of great shopping & dining. This community features swimming pool/splash pad, Rec Center, trails, playground, and is walking distance from Timber Lakes Elementary School. This POPULAR 4 bed, 2.5 bath home features an open FAMILY ROOM w/ high ceilings, ISLAND kitchen that opens to dining and family room, LOTS of cabinet & counter space, vinyl plank wood flooring throughout main areas, UPSTAIRS GAME ROOM, and spacious guest bedrooms! Primary retreat with dual sinks, BUILT IN shelving, oversized shower, and walk-in closet. Enjoy the COVERED patio-- Perfect for entertaining! Zoned to Splendora ISD. Schedule your PRIVATE showing today!!' ,`Acres` = '0.11' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S573392 - Harrington Trails 05B, BLOCK 2, Lot 19' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694808' WHERE `Matrix_Unique_ID` = '211094274' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:12:28.867' ,`MLSNumber` = '51411665' ,`ListAgentFullName` = 'Scott Laird' ,`ListOfficeName` = 'Keller Williams Woodlands' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.233256' ,`Longitude` = '-95.242045' ,`PhotoCount` = '15' ,`PostalCode` = '77357' ,`RoomCount` = '5' ,`ListPrice` = '288990.00' ,`Status` = 'Active' ,`StreetName` = 'Cypress Hollow' ,`StreetNumber` = '14874' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'WELCOME HOME to HARRINGTON TRAILS -- just 30 minutes north of Downtown Houston with easy access to Hwy 59, Grand Parkway, and lots of great shopping & dining. This community features swimming pool/splash pad, Rec Center, trails, playground, and is walking distance from Timber Lakes Elementary School. This POPULAR 4 bed, 2.5 bath home features an open FAMILY ROOM w/ high ceilings, ISLAND kitchen that opens to dining and family room, LOTS of cabinet & counter space, vinyl plank wood flooring throughout main areas, UPSTAIRS GAME ROOM, and spacious guest bedrooms! Primary retreat with dual sinks, BUILT IN shelving, oversized shower, and walk-in closet. Enjoy the COVERED patio-- Perfect for entertaining! Zoned to Splendora ISD. Schedule your PRIVATE showing today!!' ,`Acres` = '0.11' ,`Area` = '40' ,`BuilderName` = 'DR Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'S573392 - Harrington Trails 05B, BLOCK 2, Lot 12' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '750' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '47 - Splendora' ,`SchoolElementary` = 'TIMBER LAKES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPLENDORA HIGH SCHOOL' ,`SchoolMiddle` = 'SPLENDORA JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Harrington Trails' ,`TaxAmount` = '' ,`TaxRate` = '3.42832' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694808' WHERE `Matrix_Unique_ID` = '211094923' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T15:00:51.520' ,`MLSNumber` = '24629651' ,`ListAgentFullName` = 'Wendi Bangoy' ,`ListOfficeName` = 'Keller Williams SoutheastTexas' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.920600' ,`Longitude` = '-94.004863' ,`PhotoCount` = '34' ,`PostalCode` = '75951' ,`RoomCount` = '6' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Houston' ,`StreetNumber` = '437' ,`StreetSuffix` = 'Street' ,`City` = 'Jasper' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '2' ,`SqFtTotal` = '1154' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Adorable cottage home in the heart of Historic Jasper! This ideally located home leaves you within a few miles of all major shopping, medical centers, schools and city events! Currently housing a retail and salon business, this adorable home 2 Bed / 1.5 Bath features multiple updates, large entertainment spaces and a quaint covered patio overlooking the fenced backyard! Space abounds with over 1900 sqft consisting of both a large living and separate dining space that opens onto the kitchen and finally leads to the covered patio. In keeping with the historic charm, the home features high ceilings throughout! A detached carport with large storage/office space is also located just off of the home and back covered patio! Call for more information today!' ,`Acres` = '0.28' ,`Area` = '46' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 2 JNO BEVIL 1179/313 0.28 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12197' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '149 - Jasper' ,`SchoolElementary` = 'PARNELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JASPER HIGH SCHOOL (JASPER)' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'N/A' ,`TaxAmount` = '1754' ,`TaxRate` = '2.1745' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663694808' WHERE `Matrix_Unique_ID` = '211095128' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-05T14:34:15.987' ,`MLSNumber` = '88204134' ,`ListAgentFullName` = 'Bradley Tiffan' ,`ListOfficeName` = 'Princeton Classic Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.499919' ,`Longitude` = '-95.392588' ,`PhotoCount` = '29' ,`PostalCode` = '77578' ,`RoomCount` = '6' ,`ListPrice` = '353481.00' ,`Status` = 'Active' ,`StreetName` = 'Carmel' ,`StreetNumber` = '7' ,`StreetSuffix` = 'Drive' ,`City` = 'Manvel' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Love where you live in the gated section of Rodeo Palms in Manvel, TX! The Carter floor plan is a charming 1-story home with 3 bedrooms, 2 bathrooms, expansive game room, and 2-car garage! This split floor plan home includes ALL of the designer finishes you\'ve been looking for including 4-sides brick and front and back gutters! The gourmet kitchen is sure to please with 42\" cabinetry and granite countertops! Retreat to the Owner\'s Suite featuring a separate tub and shower, separate vanities, and granite countertops. Enjoy the great outdoors with full sod and a sprinkler system! Don\'t miss your opportunity to call Rodeo Palms home, schedule a visit today!' ,`Acres` = '' ,`Area` = '5' ,`BuilderName` = 'PRINCETON CLASSIC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LOT 1 BLK 4 RODEO PALMS-THE LAKES SEC. 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10243' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'DON JETER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MANVEL HIGH SCHOOL' ,`SchoolMiddle` = 'RODEO PALMS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Rodeo Palms - The Lakes' ,`TaxAmount` = '' ,`TaxRate` = '3.7' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663694808' WHERE `Matrix_Unique_ID` = '211104048' --> Updated record success