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-10T09:49:54.120' ,`MLSNumber` = '15760563' ,`ListAgentFullName` = 'Teri Walter' ,`ListOfficeName` = 'K. Hovnanian of Houston II, LL' ,`SellingAgentFullName` = 'Bonnie Schinnerer' ,`SellingOfficeName` = 'eXp Realty, LLC' ,`Latitude` = '29.818755' ,`Longitude` = '-94.837899' ,`PhotoCount` = '17' ,`PostalCode` = '77523' ,`RoomCount` = '12' ,`ListPrice` = '404950.00' ,`Status` = 'Pending Continue to Show' ,`StreetName` = 'South River' ,`StreetNumber` = '14002' ,`StreetSuffix` = 'Drive' ,`City` = 'Baytown' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2439' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Ashville plan is a beautiful two-story with 4 bedrooms, 3 baths and 2 car garage. The kitchen features upgraded maple cabinets and quartz countertops with low bar top. Two bedrooms, including owner\'s suite, located downstairs. Huge owner\'s suite features a spa like owner\'s bath with tub, separate shower and big walk-in closet. Double sinks in owner\'s bath and hall bath 2. Cozy loft space and 2 secondary bedrooms located upstairs. Covered patio in backyard, perfect for entertaining. Low tax rate and zoned to Barbers Hill ISD. Offered by: K Hovnanian Houston River Farms, LLC.' ,`Acres` = '' ,`Area` = '53' ,`BuilderName` = 'K. Hovnanian Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Chambers County West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '28/1/6' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8093' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '700' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '6 - Barbers Hill' ,`SchoolElementary` = 'BARBERS HILL SOUTH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BARBERS HILL HIGH SCHOOL' ,`SchoolMiddle` = 'BARBERS HILL SOUTH MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,No Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'River Farms' ,`TaxAmount` = '' ,`TaxRate` = '1.69399' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '207008212' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T08:39:02.203' ,`MLSNumber` = '26569852' ,`ListAgentFullName` = 'Dianna Richards' ,`ListOfficeName` = 'RE/MAX Space Center-Clear Lake' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.449009' ,`Longitude` = '-95.279643' ,`PhotoCount` = '50' ,`PostalCode` = '77511' ,`RoomCount` = '12' ,`ListPrice` = '1900000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 147' ,`StreetNumber` = '1299' ,`StreetSuffix` = '' ,`City` = 'Alvin' ,`BathsFull` = '5' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '6010' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Graced by it\'s beauty and impeccable details, this stunning home sits on 2 acres. Upon entry, you are greeted by an abundance of elegance with soaring ceilings, exquisite chandeliers with an amazing view of the back yard oasis including a large patio, heated pool and spa. Intricate floorplan includes formal living and dining room, a gourmet kitchen, oversized island looks into family room, primary bedroom accommodates oversized furniture and seating area. The two garage apartments that could be used as maids quarters. Call for your private showing. This property has been used as rental. Owner will consider carrying the note with 30% down for 10 years. Call for your private showing' ,`Acres` = '2' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace,Mock Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Alvin North' ,`HeatSystem` = 'Central Gas,Window Unit,Zoned' ,`HOAMandatory` = '0' ,`Legal` = 'A0473 H T & B R R TRACT 37B ACRES 2.0' ,`LotDesciption` = 'Cleared' ,`LotSize` = '87120' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,Heated,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '3 - Alvin' ,`SchoolElementary` = 'HOOD-CASE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ALVIN HIGH SCHOOL' ,`SchoolMiddle` = 'G W HARBY J H' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Wellman Sub' ,`TaxAmount` = '17318' ,`TaxRate` = '2.2174' ,`WaterSewer` = 'Aerobic,Septic Tank,Well' ,`YearBuilt` = '2017' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '208288014' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T09:31:10.393' ,`MLSNumber` = '33387880' ,`ListAgentFullName` = 'Lary Barton' ,`ListOfficeName` = 'Martha Turner Sotheby\'s International Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.761082' ,`Longitude` = '-95.616687' ,`PhotoCount` = '12' ,`PostalCode` = '77077' ,`RoomCount` = '0' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Briar Bayou' ,`StreetNumber` = '1106' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '0' ,`BathsHalf` = '0' ,`BedsTotal` = '0' ,`SqFtTotal` = '3110' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Situated in the heart of Houston’s Energy Corridor in beautiful Briar Forest this, traditional 3110 sq ft. 2-story, 4-bedroom, 2.5-bath home is full of tremendous possibilities! Customize this home or build your dream home on this gorgeous 22,697sq. ft lot surrounded by mature oak trees. Enjoy being in the middle of the Energy Corridor surrounded by nature. Located minutes from great shopping and restaurants on Eldridge, City Centre, Memorial City and walk or bike to Buffalo Bayou Trail in Terry Hershey Park. Do not miss this opportunity.' ,`Acres` = '0.5211' ,`Area` = '31' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Energy Corridor' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '1' ,`Legal` = 'LT 16 BRIARFOREST U/R' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '22697' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '250' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'DAILY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WESTSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRIAR MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Briarforest' ,`TaxAmount` = '9659' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1973' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '209119430' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T09:27:25.387' ,`MLSNumber` = '13307824' ,`ListAgentFullName` = 'Amanda Bures' ,`ListOfficeName` = 'RE/MAX Professionals' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.207945' ,`Longitude` = '-96.267940' ,`PhotoCount` = '20' ,`PostalCode` = '77437' ,`RoomCount` = '3' ,`ListPrice` = '215000.00' ,`Status` = 'Active' ,`StreetName` = 'Ellen' ,`StreetNumber` = '813' ,`StreetSuffix` = 'Street' ,`City` = 'El Campo' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1656' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Look no further. this spacious 3 bedroom, 2 bath, brick home could be yours. When you walk in the front door, you are greeted by a large family room located right off the dining room. A set of double doors, lead into a cover patio perfect for entertaining friends and guest. Come take a look for yourself.' ,`Acres` = '0.2525' ,`Area` = '55' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'WILLOWBEND LOT 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '10999' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Willowbend' ,`TaxAmount` = '3731' ,`TaxRate` = '2.4815' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '209721316' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T09:41:48.337' ,`MLSNumber` = '30927677' ,`ListAgentFullName` = 'Sardar Anamul' ,`ListOfficeName` = 'Prompt Realty & Mortgage, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.712392' ,`Longitude` = '-95.584858' ,`PhotoCount` = '37' ,`PostalCode` = '77072' ,`RoomCount` = '11' ,`ListPrice` = '340000.00' ,`Status` = 'Active' ,`StreetName` = 'Logan Ridge' ,`StreetNumber` = '11721' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3261' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Nice comfortable 5 bed 2 full bathroom and one half bathroom in High star village.The kitchen is open to the living room and breakfast area. Easy access to Westpark Tollway & Beltway 8. Water and Trushpick up are included with HOA fee. Shopping Center, restaurant and Grocery store nearby. Close to Major highway.' ,`Acres` = '0.0932' ,`Area` = '28' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Alief' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 HIGH STAR PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4058' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '2 - Alief' ,`SchoolElementary` = 'CHANCELLOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'AISD DRAW' ,`SchoolMiddle` = 'ALIEF MIDDLE SCHOOL' ,`ShowInstructions` = 'Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'High Star Place' ,`TaxAmount` = '5803' ,`TaxRate` = '2.4411' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '209871284' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T09:41:23.267' ,`MLSNumber` = '48102272' ,`ListAgentFullName` = 'Karisa Tinsley' ,`ListOfficeName` = 'JLA Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.462104' ,`Longitude` = '-94.611836' ,`PhotoCount` = '48' ,`PostalCode` = '77650' ,`RoomCount` = '5' ,`ListPrice` = '895000.00' ,`Status` = 'Active' ,`StreetName` = 'Gilmore' ,`StreetNumber` = '2479' ,`StreetSuffix` = '' ,`City` = 'Crystal Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here\'s the PERFECT FULLY FURNISHED 2ND ROW CABIN W/UNOBSTRUCTED OCEAN VIEW & BEACH ACCESS to call home, AirBNB or Vacay retreat! Get ready for summertime fun & making New Years resolutions at a beach bonfire. 3BR w/wood look tile floors& neutral colors & huge closets. 2 full baths w/granite counter tops, a glass enclosed shower/tub with an additional outdoor private shower. Open concept den & kitchen is perfect space to gather for holidays. Granite countertops, lots of custom wood cabinets, huge wrap around breakfast bar w/ 6 barstools & perfect size 6 top dining table to accommodate a crowd. All solid concrete under cabin & parking area. Custom built in wood post tables & picnic table w/ stools. Covered & uncovered deck to sunbath is ideal. Covered & convenient service elevator that is a MUST! Fully enclosed garage for your golf cart. 100 yds to beach on dead end street & super close to BIG STORE w/ easy beach hwy access.' ,`Acres` = '0.15' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Crystal Beach' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'ABST 65 PAGE 7 LOT 174 PEARL BEACHADDN' ,`LotDesciption` = 'Cleared,Cul-De-Sac,Water View,Waterfront' ,`LotSize` = '' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Pearl Beach' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '210449529' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T09:16:26.837' ,`MLSNumber` = '33350332' ,`ListAgentFullName` = 'Zulma Cuevas' ,`ListOfficeName` = 'DBL Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.464500' ,`Longitude` = '-95.475317' ,`PhotoCount` = '33' ,`PostalCode` = '77378' ,`RoomCount` = '3' ,`ListPrice` = '369000.00' ,`Status` = 'Active' ,`StreetName` = 'Big Bow Bend' ,`StreetNumber` = '15492' ,`StreetSuffix` = '' ,`City` = 'Willis' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2061' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'New Constructed Home in Arrowhead Lakes Subdivision in Willis. Featuring 3 bedrooms, 2 full bathrooms & a half bath with open concept kitchen/dining/living areas, walk-in pantry, granite countertops, and upstairs game room. Many custom touches throughout make this home so appealing. Located just outside of Conroe.' ,`Acres` = '0.155' ,`Area` = '19' ,`BuilderName` = 'M Mendoza' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Willis Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ARROWHEAD LAKES 02, BLOCK 17, LOT 23' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '150' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`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` = 'Accompany,Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Arrowhead Lakes 02' ,`TaxAmount` = '149' ,`TaxRate` = '1.8448' ,`WaterSewer` = 'Aerobic' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696600' WHERE `Matrix_Unique_ID` = '210499696' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T08:57:54.557' ,`MLSNumber` = '79621945' ,`ListAgentFullName` = 'Kimber James' ,`ListOfficeName` = 'Provenzano Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.956942' ,`Longitude` = '-95.359636' ,`PhotoCount` = '40' ,`PostalCode` = '77541' ,`RoomCount` = '6' ,`ListPrice` = '899000.00' ,`Status` = 'Active' ,`StreetName` = 'Front' ,`StreetNumber` = '223' ,`StreetSuffix` = 'Street' ,`City` = 'Freeport' ,`BathsFull` = '4' ,`BathsHalf` = '1' ,`BedsTotal` = '6' ,`SqFtTotal` = '2926' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful river front home has it all. The oversized garage also opens in the back to the outdoor kitchen. There is a full bathroom and living area off the garage. There is also an outdoor shower. Follow the stairs to the dock out to the water for fishing or jet skiing. The 2nd level of the house has outdoor seating with an outdoor fireplace and tv. Inside the home you will find the open concept floorplan with kitchen/dining/living area with an amazing view of the river. Utility and half bath are off the living area. All the bedrooms are at the other end of the home for privacy. The large primary bedroom has a large walk-in closet and beautiful bathroom. Two of the other bedrooms share a Jack and Jill bath. The end of the hall has an office that doubles as a bedroom and another very large bedroom. On the 3rd floor there is a media room with a full bath. The home also has a lift and a water softener. Make your appointment today to see this beautiful home. It is a must see!!' ,`Acres` = '0.1162' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Freeport' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'BRIDGEPOINT (A0099 ELI MITCHELL) (FREEPORT) LOT 12' ,`LotDesciption` = 'Water View,Waterfront' ,`LotSize` = '5062' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '7 - Brazosport' ,`SchoolElementary` = 'VELASCO ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BRAZOSPORT HIGH SCHOOL' ,`SchoolMiddle` = 'FREEPORT INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Other Style' ,`Subdivision` = 'Bridgepoint' ,`TaxAmount` = '12177' ,`TaxRate` = '2.5981' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2013' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663696601' WHERE `Matrix_Unique_ID` = '211136176' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-10T09:14:54.173' ,`MLSNumber` = '24959492' ,`ListAgentFullName` = 'Daisy Lopez' ,`ListOfficeName` = 'Move Up America' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.875809' ,`Longitude` = '-95.794249' ,`PhotoCount` = '17' ,`PostalCode` = '77493' ,`RoomCount` = '5' ,`ListPrice` = '377140.00' ,`Status` = 'Active' ,`StreetName` = 'Tallgrass Meadow' ,`StreetNumber` = '24307' ,`StreetSuffix` = 'Trail' ,`City` = 'Katy' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1702' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Large scrumptious Chef\'s kitchen with two islands!! Dining space has large picture windows with views of the the backporch and backyard with sod and sprinklers. This popular 3 bedroom two bath home has vinyl wood flooring in the living spaces and carpet in all the bedrooms. White cabinets with luxurious white, gray and black granite kitchen counters. Main bath has a tub, shower and two sinks.\r\n\r\n \r\n \r\n \r\n \r\n!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = 'Chesmar Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Katy - Old Towne' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'Lot: 36 Block: 4 Section: 35' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1280' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '30 - Katy' ,`SchoolElementary` = 'MCELWAIN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PAETOW HIGH SCHOOL' ,`SchoolMiddle` = 'STOCKDICK JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Elyson' ,`TaxAmount` = '' ,`TaxRate` = '3.495' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663696601' WHERE `Matrix_Unique_ID` = '211203887' --> Updated record success