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-03T10:23:38.893' ,`MLSNumber` = '85384804' ,`ListAgentFullName` = 'Warren Green' ,`ListOfficeName` = 'Weichert, Realtors - BCS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.391328' ,`Longitude` = '-96.338762' ,`PhotoCount` = '21' ,`PostalCode` = '76642' ,`RoomCount` = '4' ,`ListPrice` = '849900.00' ,`Status` = 'Active' ,`StreetName` = 'Lcr 763' ,`StreetNumber` = '595' ,`StreetSuffix` = '' ,`City` = 'Groesbeck' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2262' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Perfect Getaway on Lake Limestone. This home has large common areas with forever views of Lake Limestone. It comes fully furnished including a ski boat and a pontoon boat. You could close today and spend the weekend on the lake tomorrow! The home also includes a large out building that contains an extra sleeping area.' ,`Acres` = '0.8775' ,`Area` = '73' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BLAINS CREEK LAKE LIMESTONE, LOT 012' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '38223' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '222 - Groesbeck' ,`SchoolElementary` = 'GROESBECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROESBECK HIGH SCHOOL' ,`SchoolMiddle` = 'GROESBECK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Blains Creek' ,`TaxAmount` = '7504' ,`TaxRate` = '2.298' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1999' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693983' WHERE `Matrix_Unique_ID` = '205681815' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:37:57.040' ,`MLSNumber` = '26732271' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.005549' ,`Longitude` = '-95.403252' ,`PhotoCount` = '14' ,`PostalCode` = '77073' ,`RoomCount` = '7' ,`ListPrice` = '279900.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Trace' ,`StreetNumber` = '15915' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1944' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1107' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 9 IMPERIAL TRACE SEC 1' ,`LotDesciption` = 'Other' ,`LotSize` = '4824' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '350' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'DUNN ELEMENTARY SCHOOL (ALDINE)' ,`SchoolHigh` = 'NIMITZ HIGH SCHOOL (ALDINE)' ,`SchoolMiddle` = 'LEWIS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Imperial Trace' ,`TaxAmount` = '5031' ,`TaxRate` = '2.7445' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693983' WHERE `Matrix_Unique_ID` = '207314463' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:32:05.380' ,`MLSNumber` = '60658884' ,`ListAgentFullName` = 'Lynn Winget' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.198750' ,`Longitude` = '-94.948649' ,`PhotoCount` = '39' ,`PostalCode` = '77554' ,`RoomCount` = '7' ,`ListPrice` = '1299000.00' ,`Status` = 'Active' ,`StreetName` = 'Spyglass Circle' ,`StreetNumber` = '14407' ,`StreetSuffix` = '' ,`City` = 'Galveston' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated Home in Pirates Beach West! Located on a large corner lot, this home boasts stunning beach views from bedrooms and decks. all new furnishing, Fireplace, New Flooring, Downstairs Master Suite and Electric and Manual Shutters. There is plenty of room for everyone to enjoy the incredible views. Large living & dining area Kitchen features quartz counter tops, separate pantry, & large breakfast bar for additional serving and seating. An additional seating area upstairs is perfect for the kids to wind down after a day at the beach. Primary bedroom on the first level has deck access with Gulf views. Primary bath features a separate walk-in shower and tub. Ground level features a wide driveway with abundant outdoor space for entertaining and easy access to the beach. Electric and manual storm shutters This beautiful home conveys fully furnished with owners exclusioins,ready for your immediate enjoyment. Seller is motivated' ,`Acres` = '0.211' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 41 LOT 10 BLK 5 PIRATES BEACH SEC 10 PARTIAL R' ,`LotDesciption` = 'Water View' ,`LotSize` = '9193' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '389' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Pirates Beach Sec 10 Amd' ,`TaxAmount` = '10751' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693983' WHERE `Matrix_Unique_ID` = '207421109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:44:47.820' ,`MLSNumber` = '54251738' ,`ListAgentFullName` = 'Lanell Duke' ,`ListOfficeName` = 'Coldwell Banker Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.764797' ,`Longitude` = '-95.175326' ,`PhotoCount` = '19' ,`PostalCode` = '77364' ,`RoomCount` = '8' ,`ListPrice` = '254900.00' ,`Status` = 'Active' ,`StreetName` = 'Clearview' ,`StreetNumber` = '31' ,`StreetSuffix` = 'Street' ,`City` = 'Point Blank' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2315' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely lake view home sits on .4211 of an acre in a quiet Lake Livingston neighborhood and features a fenced back yard, with nice outdoor space for quiet relaxing times outdoors or for entertaining. The home has a screened in back porch with a view of the lake for you to relax on while not being bothered with all the bugs that are around during the summer. The home is a 2 bed 2 bath with a guest house and 2 garages, one with a work area and 1 car parking, the other is a 1 car garage. The guest house has 1 bedroom, a full bath and living area. Come take a look, sit on the back decks or in the screened porch, this may just be the home you\'re looking for.\r\nThis home has had previous foundation repair (piers were placed under home where foundation had settled) and has a Transferable Lifetime Warranty on the foundation repair.' ,`Acres` = '0.4211' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'POINT LOOK OUT ESTS #1, BLOCK 16, LOT 10, 12 & THE W 1/2 OF' ,`LotDesciption` = 'Cleared,Subdivision Lot,Water View' ,`LotSize` = '18343' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '101 - Coldspring-Oakhurst Consolidated' ,`SchoolElementary` = 'JAMES STREET ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLDSPRING-OAKHURST HIGH SCHOOL' ,`SchoolMiddle` = 'LINCOLN JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Point Look Out Estates #1' ,`TaxAmount` = '3732' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '207619204' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:40:44.887' ,`MLSNumber` = '75261274' ,`ListAgentFullName` = 'Sandra Tsui' ,`ListOfficeName` = 'Keller Williams Realty -SW' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.704495' ,`Longitude` = '-95.418003' ,`PhotoCount` = '24' ,`PostalCode` = '77030' ,`RoomCount` = '8' ,`ListPrice` = '720000.00' ,`Status` = 'Active' ,`StreetName` = 'Gramercy' ,`StreetNumber` = '2526' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2767' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful home is located on a large corner lot (9520 sqft) at Gramercy and Kirby. Minutes to medical center, rice village, and Herman Park. This timeless single story home boasts 3 large bedrooms, extremely spacious living and family rooms along with formal dining. The home boasts an outstanding open kitchen, updated granite counter tops in kitchen, dryer, dishwasher, furnaces, and refrigerator. Alon with wood flooring in family, kitchen, and breakfast.' ,`Acres` = '0.2185' ,`Area` = '17' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Rice/Museum District' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 & TR 19A BLK 27 BRAESWOOD' ,`LotDesciption` = 'Corner' ,`LotSize` = '9520' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROBERTS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'PERSHING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Braeswood' ,`TaxAmount` = '13450' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1955' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '207773613' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:20:49.360' ,`MLSNumber` = '95599521' ,`ListAgentFullName` = 'Deborah Bly' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.595587' ,`Longitude` = '-95.209026' ,`PhotoCount` = '14' ,`PostalCode` = '77089' ,`RoomCount` = '9' ,`ListPrice` = '249999.00' ,`Status` = 'Active' ,`StreetName` = 'Graywood' ,`StreetNumber` = '11602' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1595' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Tenant Occupied. Do not disturb Tenant. House with tall & beautiful Pine trees on a large lot in cul-de-sac. House is in nice & quiet neighborhood & centrally located near intersection of Beltway 8 & 45 Gulf freeway. Approximately ten minutes from Pearland, Clearlake, Nasa Space Center, Kemah League City, Friendswood, Pasadena. Fifteen minutes to downtown. Lovely starter home and a great place to grow together. With a bit of love and care , you can make it yours!' ,`Acres` = '0.2296' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 9 BLK 8 WOOD MEADOW SEC 1 2ND R/P' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '10000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'BURNETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DOBIE HIGH SCHOOL' ,`SchoolMiddle` = 'THOMPSON INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Wood Meadow Sec 01 02 R/P' ,`TaxAmount` = '5546' ,`TaxRate` = '2.7255' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1978' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '207948779' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:35:18.017' ,`MLSNumber` = '23189691' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'LennarVillageBldr-JaredTurner' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.164663' ,`Longitude` = '-95.197151' ,`PhotoCount` = '8' ,`PostalCode` = '77357' ,`RoomCount` = '10' ,`ListPrice` = '410000.00' ,`Status` = 'Active' ,`StreetName` = 'Lazzaro Springs' ,`StreetNumber` = '18909' ,`StreetSuffix` = 'Drive' ,`City` = 'New Caney' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2743' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'NEW! Lennar Homes Fairway Collection, \'\'Wakefield\'\' Plan, Elevation \'\'D\'\' in beautiful Tavola! The lovely two-story Wakefield floor plan from the Fairway Collection by Lennar offers an open layout that creates an effortless flow, ideal for modern living. As the only first floor bedroom, the primary suite enjoys privacy, while upstairs includes a bonus room and three secondary bedrooms.' ,`Acres` = '' ,`Area` = '40' ,`BuilderName` = 'Lennar Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Porter/New Caney East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SEC 0042 BLK 002 LOT 015' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1125' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '39 - New Caney' ,`SchoolElementary` = 'TAVOLA ELEMENTARY SCHOOL (NEW CANEY)' ,`SchoolHigh` = 'NEW CANEY HIGH SCHOOL' ,`SchoolMiddle` = 'KEEFER CROSSING MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Tavola' ,`TaxAmount` = '' ,`TaxRate` = '3.5826' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '208702742' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:45:13.493' ,`MLSNumber` = '50305268' ,`ListAgentFullName` = 'Tammy Fruge' ,`ListOfficeName` = 'Westin Homes' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.153651' ,`Longitude` = '-95.581117' ,`PhotoCount` = '9' ,`PostalCode` = '77354' ,`RoomCount` = '16' ,`ListPrice` = '649683.00' ,`Status` = 'Active' ,`StreetName` = 'Regal Scott' ,`StreetNumber` = '27112' ,`StreetSuffix` = 'Drive' ,`City` = 'Magnolia' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3800' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Westin Homes NEW Construction (Hopkins III, Elevation B) CURRENTLY BEING BUILT. Two Story. 4 bedrooms, 3.5 baths. Elegant double front door entry. Primary suite with spacious walk-in closet. Spacious island kitchen with breakfast area is open to the family room. Formal dining room. First floor study. Second floor game room, media room and additional 3 bedrooms. Extended covered patio and attached 2 car garage. NorthGrove offers easy access to all the conveniences and necessities of modern living with The Woodlands, Tomball, and Conroe all a short distance away. With resort-style amenities, including The Retreat, a 9,400-sq.-ft. clubhouse, Northgrove is the perfect escape from the daily grind. Enjoy a fitness center, pool, children\'s play areas and more. Stop by the Westin Homes model home today to find out more about Northgrove!' ,`Acres` = '0.2046' ,`Area` = '15' ,`BuilderName` = 'Westin Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'BLOCK 4, LOT 20' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8911' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1295' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'CEDRIC C. SMITH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northgrove' ,`TaxAmount` = '2250' ,`TaxRate` = '3.2087' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '209352215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:59:37.027' ,`MLSNumber` = '44727615' ,`ListAgentFullName` = 'Tonya Brown' ,`ListOfficeName` = 'Compass RE Texas, LLCKaty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.714983' ,`Longitude` = '-95.354014' ,`PhotoCount` = '45' ,`PostalCode` = '77004' ,`RoomCount` = '10' ,`ListPrice` = '385000.00' ,`Status` = 'Active' ,`StreetName` = 'Arbor' ,`StreetNumber` = '3806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2510' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to 3806 Arbor St in Oak Manor which offers quick access to Downtown, the Medical Center, Univ of Houston, and Texas Southern Univ. This recently updated home boasts 4 bedrooms and 2 spacious bathrooms, large living and dining areas, an open kitchen and breakfast, and additional flex / game room space. This gem was completely remodeled and expanded in 2013 with modern touches like crown molding, chair railing, new flooring, recessing light fixtures, new ceiling fans throughout, new windows, and interior / exterior paint… just to name a few. The extended and circular driveway welcome your guests and both the side and backyard provide ample space for relaxation and outdoor entertaining. The manicured lawn provides a clean slate for you to implement your own landscape design. The layout of this home offers unique flexibility and plenty of storage space. Buyer and Buyer’s Agents to verify measurements. Don’t let this one get away! Call to you schedule your appointment today.' ,`Acres` = '0.1515' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'University Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 2 BLK 5 OAK MANOR SEC 2' ,`LotDesciption` = 'Cleared,Subdivision Lot' ,`LotSize` = '6600' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'LOCKHART ELEMENTARY SCHOOL' ,`SchoolHigh` = 'YATES HIGH SCHOOL' ,`SchoolMiddle` = 'CULLEN MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Photos/No Videos,Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Oak Manor Sec 02' ,`TaxAmount` = '6547' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1952' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '209562021' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:01:06.160' ,`MLSNumber` = '92315616' ,`ListAgentFullName` = 'Wei Fang' ,`ListOfficeName` = '3H Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.738827' ,`Longitude` = '-95.247714' ,`PhotoCount` = '13' ,`PostalCode` = '77547' ,`RoomCount` = '6' ,`ListPrice` = '185000.00' ,`Status` = 'Active' ,`StreetName` = '8th' ,`StreetNumber` = '2223' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1306' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'You don\'t want to miss this great house on a huge lot of over 10,000 sqt. 3 bedrooms with 2 Living Rooms! Detached garage facing one street and the house entrace facing another way. Free to choose which way to go. Big storage above the garage and can store your stuff separate from your house. Quiet neighborhood, close to church and good school zones. Come submit your offer, and it won\'t last long!' ,`Acres` = '0.2363' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'North Channel' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 GALENA TERRACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10295' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '21 - Galena Park' ,`SchoolElementary` = 'GALENA PARK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GALENA PARK HIGH SCHOOL' ,`SchoolMiddle` = 'GALENA PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Galena Terrace' ,`TaxAmount` = '2415' ,`TaxRate` = '3.22' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1950' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663693984' WHERE `Matrix_Unique_ID` = '209653871' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:08:54.320' ,`MLSNumber` = '51002502' ,`ListAgentFullName` = 'Meredith Welsh' ,`ListOfficeName` = 'RE/MAX Leading Edge' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.199079' ,`Longitude` = '-94.949161' ,`PhotoCount` = '45' ,`PostalCode` = '77554' ,`RoomCount` = '5' ,`ListPrice` = '999900.00' ,`Status` = 'Active' ,`StreetName` = 'Spyglass' ,`StreetNumber` = '14410' ,`StreetSuffix` = 'Circle' ,`City` = 'Galveston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2350' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Enjoy the best of beach living and an exceptional outdoor experience with the private pool/spa and large covered patio! Located just a short walk from the beach, this 5 bedroom home is in the exclusive Pirates Beach West neighborhood, a great community and rental history. This home features a primary suite and extra half bath on the first floor, additional bedrooms and bath on the second floor, and a great first floor front porch. The ground level features the pool/spa which is heated and fully fenced, covered patio, outdoor shower with hot/cold plumbing, two separate enclosed garages, and an expansive dual entry driveway. Updates include recently remodeled pool/spa, new wood flooring, new water heaters, new LED lighting throughout, new ceiling fans, and a new roof in 2017. This exciting property conveys fully furnished.' ,`Acres` = '0.1858' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 PAGE 41 LOT 17 BLK 4 PIRATES BEACH SEC 10 PARTIAL R' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8094' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '495' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Pirates Beach Sec 10 Amd' ,`TaxAmount` = '10164' ,`TaxRate` = '2.0324' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '209925587' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:18:01.897' ,`MLSNumber` = '5229056' ,`ListAgentFullName` = 'Deborah Bly' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.495278' ,`Longitude` = '-95.138474' ,`PhotoCount` = '37' ,`PostalCode` = '77573' ,`RoomCount` = '9' ,`ListPrice` = '379000.00' ,`Status` = 'Active' ,`StreetName` = 'Running Pine' ,`StreetNumber` = '4414' ,`StreetSuffix` = 'Drive' ,`City` = 'League City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2579' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful home in the desirable Claremont Park subdivision. Spacious kitchen with gas range, granite countertops, open to the formal dining room. All bedrooms upstairs. Large primary suite with a huge walk-in closet and bath with double vanities. Spacious bedrooms and a secondary full bath upstairs. Huge, open backyard with a gas line for a grill! New paint outside! No flooding!! Come take a look today before it\'s gone!' ,`Acres` = '0.2123' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CLAREMONT PARK SEC 1 (98), BLOCK 4, LOT 18, ACRES .212' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '9248' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'GILMORE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'CREEKSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Claremont Park Sec 1 98' ,`TaxAmount` = '6689' ,`TaxRate` = '2.2667' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '209940100' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:04:25.940' ,`MLSNumber` = '40978942' ,`ListAgentFullName` = 'Anissa McGowan' ,`ListOfficeName` = 'Strada' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.795726' ,`Longitude` = '-95.820460' ,`PhotoCount` = '6' ,`PostalCode` = '77493' ,`RoomCount` = '2' ,`ListPrice` = '475000.00' ,`Status` = 'Active' ,`StreetName` = 'East' ,`StreetNumber` = '1617' ,`StreetSuffix` = 'Avenue' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1496' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The City of Katy provides the highest quality of life for its residents. Beautiful neighborhoods, master-planned communities and abundant green space for parks and recreation. Katy ISD ranks among the top school districts in the country, offering students excellent education. Many large, mid-size and small businesses call Katy home, and the City of Katy is proactive in economic development to create a business-friendly environment. This property is located in the heart of Katy and offers both commercial/residential opportunities. Zoned to Katy Elementary, Katy Jr. High and Katy High School. Centrally located to all Katy has to offers. Let\'s connect and schedule your private showing today!' ,`Acres` = '0.52' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT PT 6 TR 13B KATY OL .52AC' ,`LotDesciption` = 'Other' ,`LotSize` = '22651' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'KATY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KATY HIGH SCHOOL' ,`SchoolMiddle` = 'KATY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Katy Ol 44 Htc Rr Sur' ,`TaxAmount` = '4764' ,`TaxRate` = '2.3852' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1946' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '210060741' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:45:11.500' ,`MLSNumber` = '27204955' ,`ListAgentFullName` = 'Deborah Gray' ,`ListOfficeName` = 'Results Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.973466' ,`Longitude` = '-95.558340' ,`PhotoCount` = '32' ,`PostalCode` = '77070' ,`RoomCount` = '10' ,`ListPrice` = '320000.00' ,`Status` = 'Active' ,`StreetName` = 'Coolshire' ,`StreetNumber` = '8130' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2630' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Inside or outside there is plenty of room in this 2,600+sqft home to have family gatherings. You can enjoy cooking outside with a huge wood deck and you can stay cool in the pool on these hot Texas summer days. If it\'s too hot outside, there is plenty of room inside with central air conditioning. You can enjoy being in the large living room with beautiful wood flooring. Bring your personal touches and make this your dream home. One bathroom has a wheelchair accessible shower as well. SELLER IS INCLUDING THE WASHER/DRYER, DISHWASHER, REFRIGERATOR AND IS ALSO INCLUDING A NEW SURVEY! MOTIVATED SELLER!' ,`Acres` = '0.2515' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Mud,Tenant Occupied' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 LESS 4\" BLK 5 PRESTONWOOD FOREST SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '10954' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '702' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Above Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (CY-FAIR)' ,`SchoolHigh` = 'CYPRESS CREEK HIGH SCHOOL' ,`SchoolMiddle` = 'BLEYL MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Back,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Prestonwood Forest' ,`TaxAmount` = '5389' ,`TaxRate` = '2.4903' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1972' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '210144279' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:45:17.290' ,`MLSNumber` = '41576702' ,`ListAgentFullName` = 'Robert Salmons' ,`ListOfficeName` = 'Entera Realty LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.464333' ,`Longitude` = '-95.469465' ,`PhotoCount` = '18' ,`PostalCode` = '77583' ,`RoomCount` = '5' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Tartan' ,`StreetNumber` = '8214' ,`StreetSuffix` = 'Court' ,`City` = 'Rosharon' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2094' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1157' ,`Area` = '38' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Sienna Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'SOUTHERN COLONY SEC 1, BLOCK 4, LOT 38' ,`LotDesciption` = 'Other' ,`LotSize` = '5040' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '500' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'HERITAGE ROSE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'RIDGE POINT HIGH SCHOOL' ,`SchoolMiddle` = 'THORNTON MIDDLE SCHOOL (FORT BEND)' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Southern Colony Sec 1' ,`TaxAmount` = '5310' ,`TaxRate` = '3.1329' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '210393190' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:57:20.057' ,`MLSNumber` = '69502814' ,`ListAgentFullName` = 'Nancy Cooper' ,`ListOfficeName` = 'Lucky Money Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.461466' ,`Longitude` = '-95.553565' ,`PhotoCount` = '18' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '200000.00' ,`Status` = 'Active' ,`StreetName` = 'Starboard' ,`StreetNumber` = '15111' ,`StreetSuffix` = 'Drive' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1557' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Waterfront community of Conroe Bay! Open Floor Plan sits on an oversize lot with fruit trees and includes a Sunroom, Wrap around porch, Oversized 2-car garage and additional parking in-front. All Appliances are only 2 years old, as well as the A/C, wood plank tile in both bathrooms, and quart kitchen countertops. Pier and Beam and electrical have been replaced. Schedule your appointment today. Selling AS IS.' ,`Acres` = '0.34' ,`Area` = '39' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'CONROE BAY, BLOCK 2, LOT 30, LOT 31, LOT 32' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '14614' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '275' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'PARMLEY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'LYNN LUCAS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Conroe Bay' ,`TaxAmount` = '3178' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1979' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '210427856' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:38:58.820' ,`MLSNumber` = '2391539' ,`ListAgentFullName` = 'AJ Guel' ,`ListOfficeName` = 'John Petty, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.829621' ,`Longitude` = '-96.995274' ,`PhotoCount` = '16' ,`PostalCode` = '77901' ,`RoomCount` = '4' ,`ListPrice` = '239000.00' ,`Status` = 'Active' ,`StreetName` = 'Melrose' ,`StreetNumber` = '1006' ,`StreetSuffix` = 'Avenue' ,`City` = 'Victoria' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1744' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Updated 4 bed 2 bath with the backyard of your dreams! You will love this split floor plan home located in a quiet neighborhood. New flooring, roof, and storm windows make this home move-in ready. 4th bedroom is the only room upstairs and is perfect for a teenager or can be used as an office for quiet work time away from the rest of the home. The 14,288 sq ft lot is ready for all your outdoor activities!' ,`Acres` = '0.328' ,`Area` = '66' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'CRESTWOOD SUBD LOT 15 BLOCK 4' ,`LotDesciption` = 'Other' ,`LotSize` = '14288' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '191 - Victoria' ,`SchoolElementary` = 'SHIELDS ELEMENTARY MAGNET SCHOOL' ,`SchoolHigh` = 'VICTORIA WEST HIGH SCHOOL' ,`SchoolMiddle` = 'HAROLD CADE MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crestwood Sub' ,`TaxAmount` = '2618' ,`TaxRate` = '2.4266' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1951' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693985' WHERE `Matrix_Unique_ID` = '210902606' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:24:06.490' ,`MLSNumber` = '52245128' ,`ListAgentFullName` = 'Jacqueline Wallman' ,`ListOfficeName` = 'Texas Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.130729' ,`Longitude` = '-95.387200' ,`PhotoCount` = '28' ,`PostalCode` = '77386' ,`RoomCount` = '7' ,`ListPrice` = '318900.00' ,`Status` = 'Active' ,`StreetName` = 'Leaf Vines' ,`StreetNumber` = '3515' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1978' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Your search has ended! 3 BR Home in Desired Gated Community. Home features tile flooring in entry and all wet areas. Both formals upon entry. Spacious den with ceiling fan, warming fireplace, and plenty of lighting. Kitchen comes with Breakfast Room, Breakfast Bar and plenty of cabinet/counter space. Large primary with walk in closet, double sinks and separate tub/shower. Nice size secondary rooms. Plenty of Backyard Space, Perfect for Entertaining. Come See Today!' ,`Acres` = '0.1808' ,`Area` = '15' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Spring Northeast' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S328305 - CANYON GATE AT LEGENDS RANCH 05, BLOCK 1, LOT 40' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7874' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '455' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'BIRNHAM WOODS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GRAND OAKS HIGH SCHOOL' ,`SchoolMiddle` = 'YORK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At Legends Ranch 0' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693986' WHERE `Matrix_Unique_ID` = '210987764' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T10:47:48.367' ,`MLSNumber` = '83191671' ,`ListAgentFullName` = 'Jay Schulz' ,`ListOfficeName` = 'Zarco Properties, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.736145' ,`Longitude` = '-95.525890' ,`PhotoCount` = '35' ,`PostalCode` = '77320' ,`RoomCount` = '4' ,`ListPrice` = '429900.00' ,`Status` = 'Active' ,`StreetName` = 'Badger' ,`StreetNumber` = '2201' ,`StreetSuffix` = 'Lane' ,`City` = 'Huntsville' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2603' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Mixed use property on 1 acre 0.2 miles from SH-19. Great location surrounded by businesses and residential. Property has tons of available space to subdivide or add another building for commercial or residential use. Separate building/apartment in back could be leased and generate income.' ,`Acres` = '1' ,`Area` = '43' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Huntsville Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'MCMILLIAN T P (A-388), TRACT 22, ACRES 1.0' ,`LotDesciption` = 'Cleared,Corner' ,`LotSize` = '43560' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '64 - Huntsville' ,`SchoolElementary` = 'SCOTT JOHNSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HUNTSVILLE HIGH SCHOOL' ,`SchoolMiddle` = 'MANCE PARK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'McMillian T P' ,`TaxAmount` = '4144' ,`TaxRate` = '1.9384' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1974' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693986' WHERE `Matrix_Unique_ID` = '210989303' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:21:38.563' ,`MLSNumber` = '26942422' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.403887' ,`Longitude` = '-95.511934' ,`PhotoCount` = '24' ,`PostalCode` = '77318' ,`RoomCount` = '7' ,`ListPrice` = '461690.00' ,`Status` = 'Active' ,`StreetName` = 'Lukewood' ,`StreetNumber` = '111' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2432' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'San Francisco Plan - Elevation F (Brick) 2 Story - 4 bedrooms - 3 1/2 Bathrooms - Covered Patio - 2 Car Garage - no rear neighbors! Home is scheduled to be complete in January 2023, as such photos are representative. Selections and features will vary, for more info, please contact Chesmar Homes in The Woodlands Hills' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927115 - The Woodlands Hills 15, BLOCK 2, Lot 9' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4680' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodland Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693986' WHERE `Matrix_Unique_ID` = '210992233' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:28:54.470' ,`MLSNumber` = '44116026' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.404921' ,`Longitude` = '-95.512291' ,`PhotoCount` = '25' ,`PostalCode` = '77318' ,`RoomCount` = '8' ,`ListPrice` = '471515.00' ,`Status` = 'Active' ,`StreetName` = 'Lukewood' ,`StreetNumber` = '115' ,`StreetSuffix` = 'Circle' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2425' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Durham Plan - Elevation A (Brick) 2 Story - 5 bedrooms (1 can serve as a Study or 2 bedrooms down) - 3 Bathrooms - Covered Patio - 2 Car Garage - no rear neighbors! \r\nNew home under construction, photos are representative and not of actual home. January 2023 estimated completion. Chesmar Homes is the builder.' ,`Acres` = '' ,`Area` = '39' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Conroe Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S927115 - The Woodlands Hills 15, BLOCK 2, Lot 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4920' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '995' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '56 - Willis' ,`SchoolElementary` = 'W. LLOYD MEADOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WILLIS HIGH SCHOOL' ,`SchoolMiddle` = 'ROBERT P. BRABHAM MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'The Woodland Hills' ,`TaxAmount` = '' ,`TaxRate` = '3.28' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693986' WHERE `Matrix_Unique_ID` = '210992687' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-03T11:52:26.283' ,`MLSNumber` = '38486028' ,`ListAgentFullName` = 'Yun Truong' ,`ListOfficeName` = 'AlphaMax Realty Inc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.691888' ,`Longitude` = '-95.590571' ,`PhotoCount` = '32' ,`PostalCode` = '77072' ,`RoomCount` = '4' ,`ListPrice` = '267000.00' ,`Status` = 'Active' ,`StreetName` = 'Hendon' ,`StreetNumber` = '12018' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '1635' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1641' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 31 BLK 5 CATALINA SQUARE SEC 2' ,`LotDesciption` = 'Cleared' ,`LotSize` = '7150' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '120' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'MARTIN ELEMENTARY SCHOOL (ALIEF)' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'KILLOUGH MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1.5' ,`Style` = 'Traditional' ,`Subdivision` = 'Catalina Square Sec 02' ,`TaxAmount` = '3270' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1967' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693986' WHERE `Matrix_Unique_ID` = '210994335' --> Updated record success