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-01T17:46:41.220' ,`MLSNumber` = '10809285' ,`ListAgentFullName` = 'Diana Esparza' ,`ListOfficeName` = 'RE/MAX Northwest, REALTORS' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.786177' ,`Longitude` = '-95.359604' ,`PhotoCount` = '17' ,`PostalCode` = '77009' ,`RoomCount` = '5' ,`ListPrice` = '259000.00' ,`Status` = 'Active' ,`StreetName` = 'Hammock' ,`StreetNumber` = '1115' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '648' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.1148' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Exclusions,Probate,Sellers Disclosure' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'No Heating' ,`HOAMandatory` = '0' ,`Legal` = 'LT 95 McGowen' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'KETELSEN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'MARSHALL MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Mcgowen' ,`TaxAmount` = '3600' ,`TaxRate` = '2.3994' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1930' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693322' WHERE `Matrix_Unique_ID` = '194523290' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:54:48.970' ,`MLSNumber` = '96012444' ,`ListAgentFullName` = 'Adriana Cepeda' ,`ListOfficeName` = 'J Holt Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.913210' ,`Longitude` = '-95.047669' ,`PhotoCount` = '43' ,`PostalCode` = '77532' ,`RoomCount` = '4' ,`ListPrice` = '599900.00' ,`Status` = 'Active' ,`StreetName` = 'Hwy 90' ,`StreetNumber` = '4343' ,`StreetSuffix` = 'Freeway' ,`City` = 'Crosby' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Also for sale $449,900. Without mobile home and porch. / Or with mobile home price as listed. Great Commercial and/ or multifamily Property for your business.Frontage is 140.41 ft. Slightly over an acre. Cleared Huge lot with small building or house 15x30 (approx. 535 sq ft).Aluminum garage (shed/barn) 19x20 Property is fenced with a fence surrounding the entire property and automatic gate. Listed in HCAD as a Commercial, Multifamily Lot. Please check zoning for your need. Double wide mobile home in the back is completely remodeled in the last 2 years beautiful floors, granite kitchen island. Jacuzzi etc. 3/2 home split floor plan. 20X20 porch. Front apartment 1/1 can be used as office. That apt. is currently being leased. The huge Canopy 60X30 ft does not have electricity nor doors. dirt has been put on driveway to level and use as driveway. Running water to the side of lot. Possibilities exist for big trucks. Estimate bedroom sizes.' ,`Acres` = '1.1437' ,`Area` = '1' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Other Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = 'Mock Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crosby Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'TR 15 BLK 9 RUNNEBERG ESTATES SEC 2 U/R ABST 518 A I LEWIS' ,`LotDesciption` = 'Cleared' ,`LotSize` = '49820' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '12' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '12 - Crosby' ,`SchoolElementary` = 'BARRETT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CROSBY HIGH SCHOOL' ,`SchoolMiddle` = 'CROSBY MIDDLE SCHOOL (CROSBY)' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Runneberg Estates Sub Sec 2' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693322' WHERE `Matrix_Unique_ID` = '201624296' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:18:31.093' ,`MLSNumber` = '80429937' ,`ListAgentFullName` = 'Hector Bustillo' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.142915' ,`Longitude` = '-95.044451' ,`PhotoCount` = '34' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '267990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5203' ,`StreetNumber` = '1064' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come look at this amazing home nestled just a short drive from the new 99 Grand Parkway \"NOW OPEN!\" This estate offer a spacious yard with plenty of room to entertain. Striking kitchen with quartz counter tops and stunning backsplash, with a sophisticated design that\'s space-efficient, with plenty of cabinet space for all your chef supplies. This elegant home encompasses an open concept that showcases the welcoming living room and high 9\' foot ceiling provided throughout the home to include impressive ceiling fans. Has a stunning primary bedroom with an elegant shower and tub combo dressed with tile, granite counter top vanity, and enormous walk-in closet. Well proportioned spacious rooms that embraces the natural light this home possesses. Impressive well designed home that features an incredible amount of substantial space all across the home that will suit everything you\'ve been looking for in a home. Obtain this beautiful home and enjoy the many benefits this home has to offer!' ,`Acres` = '0.29' ,`Area` = '52' ,`BuilderName` = 'Gonzalo Alarcon' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 4, BLOCK 65, LOT 6077, ACRES .29' ,`LotDesciption` = 'Cleared' ,`LotSize` = '12632' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '822' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693322' WHERE `Matrix_Unique_ID` = '207910434' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:18:15.540' ,`MLSNumber` = '70050829' ,`ListAgentFullName` = 'Hector Bustillo' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.143008' ,`Longitude` = '-95.044234' ,`PhotoCount` = '42' ,`PostalCode` = '77327' ,`RoomCount` = '6' ,`ListPrice` = '267990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5203' ,`StreetNumber` = '1074' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come look at this amazing home nestled just a short drive from the new 99 Grand Parkway \"NOW OPEN!\" This estate offer a spacious yard with plenty of room to entertain. Striking kitchen with quartz counter tops and stunning backsplash, with a sophisticated design that\'s space-efficient, with plenty of cabinet space for all your chef supplies. This elegant home encompasses an open concept that showcases the welcoming living room and high 9\' foot ceiling provided throughout the home to include impressive ceiling fans. Has a stunning primary bedroom with an elegant shower and tub combo dressed with tile, granite counter top vanity, and enormous walk-in closet. Well proportioned spacious rooms that embraces the natural light this home possesses. Impressive well designed home that features an incredible amount of substantial space all across the home that will suit everything you\'ve been looking for in a home. Obtain this beautiful home and enjoy the many benefits this home has to offer!' ,`Acres` = '0.3' ,`Area` = '52' ,`BuilderName` = 'Gonzalo Alcaron' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 4, BLOCK 65, LOT 6076, ACRES 0.3000' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '841' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '207989112' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:17:58.973' ,`MLSNumber` = '41695397' ,`ListAgentFullName` = 'Hector Bustillo' ,`ListOfficeName` = 'FYI Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.143152' ,`Longitude` = '-95.044264' ,`PhotoCount` = '31' ,`PostalCode` = '77327' ,`RoomCount` = '7' ,`ListPrice` = '267990.00' ,`Status` = 'Active' ,`StreetName` = 'Road 5203' ,`StreetNumber` = '1084' ,`StreetSuffix` = '' ,`City` = 'Cleveland' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1490' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come look at this amazing home nestled just a short drive from the new 99 Grand Parkway \"NOW OPEN!\" This estate offer a spacious yard with plenty of room to entertain. Striking kitchen with quartz counter tops and stunning backsplash, with a sophisticated design that\'s space-efficient, with plenty of cabinet space for all your chef supplies. This elegant home encompasses an open concept that showcases the welcoming living room and high 9\' foot ceiling provided throughout the home to include impressive ceiling fans. Has a stunning primary bedroom with an elegant shower and tub combo dressed with tile, granite counter top vanity, and enormous walk-in closet. Well proportioned spacious rooms that embraces the natural light this home possesses. Impressive well designed home that features an incredible amount of substantial space all across the home that will suit everything you\'ve been looking for in a home. Obtain this beautiful home and enjoy the many benefits this home has to offer!' ,`Acres` = '0.3' ,`Area` = '52' ,`BuilderName` = 'Gonzalo Alarcon' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cleveland Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'SANTA FE, SEC 4, BLOCK 65, LOT 6075, ACRES 0.3000' ,`LotDesciption` = 'Cleared' ,`LotSize` = '13068' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '160' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'Never Lived In' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '100 - Cleveland' ,`SchoolElementary` = 'COTTONWOOD SCHOOL (CLEVELAND)' ,`SchoolHigh` = 'CLEVELAND HIGH SCHOOL' ,`SchoolMiddle` = 'CLEVELAND MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Santa Fe' ,`TaxAmount` = '841' ,`TaxRate` = '2.1513' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '207992556' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:13:23.417' ,`MLSNumber` = '14895801' ,`ListAgentFullName` = 'Vicki Head' ,`ListOfficeName` = 'Top Rope Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.969418' ,`Longitude` = '-95.954023' ,`PhotoCount` = '28' ,`PostalCode` = '77414' ,`RoomCount` = '13' ,`ListPrice` = '399000.00' ,`Status` = 'Active' ,`StreetName` = 'Valhalla' ,`StreetNumber` = '3' ,`StreetSuffix` = 'Drive' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2678' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This is a rare find in Exclusive Valhalla Subdivision. Pristine, custom, move-in ready one-story home on 1/2 acre lot..This home has custom features through-out. As you enter the front door you are greeted with beauty.. a study on the right & formal living on the left which leads to the formal dining room. Huge family room with beautiful double sided fireplace to sunroom. A large primary bedroom with large on-suite. The backyard has a large covered patio & lots of space to enjoy the outdoors. Resent upgrades: new roof, hardwood floors, kitchen backsplash, dishwasher, new fence, sprinkler system, front door, plus an additional workshop in the back yard. Oversized 2 car garage with a climate controlled workshop there also & extra parking.' ,`Acres` = '0.5379' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'VALHALLA S/D SEC 1, LOT 10' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '23430' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = '' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Valhalla Sub Sec 1' ,`TaxAmount` = '7226' ,`TaxRate` = '2.8238' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '208331852' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:59:57.927' ,`MLSNumber` = '12652084' ,`ListAgentFullName` = 'Gay Fundling' ,`ListOfficeName` = 'Galveston Island Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.190865' ,`Longitude` = '-94.976253' ,`PhotoCount` = '20' ,`PostalCode` = '77554' ,`RoomCount` = '8' ,`ListPrice` = '530000.00' ,`Status` = 'Active' ,`StreetName` = 'Jolly Roger' ,`StreetNumber` = '4907' ,`StreetSuffix` = '' ,`City` = 'Jamaica Beach' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1470' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Polynesian designed island home. Built for the sea breeze. Huge living/ dining great room, with soaring solid beamed ceiling and ceramic tiled floors. The kitchen is the heart of this home with tiny blue tiled counter tops and extra serving buffet, breakfast bar for the extended family. Surrounded with the plush cushion built-ins that double as large storage compartments. Wild life views of the Galveston island State park to the east at sunrise. Waterfront deck over the extra wide channel that leads to the Famous West Bay sunsets. Catch of the day right off your dock.\r\nCentrally located between the beach and bay just a golf cart ride away. A plus to be on the Christmas Boat parade route. Priced \"AS IS\" like an artist\'s blank palette this home is waiting for your expertise.' ,`Acres` = '0.1598' ,`Area` = '33' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Freestanding' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West End' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'ABST 121 HALL & JONES SUR LOT 6 BLK O JAMAICA BEACH SEC 7' ,`LotDesciption` = 'Subdivision Lot,Water View' ,`LotSize` = '6960' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '45' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '22 - Galveston' ,`SchoolElementary` = 'GISD OPEN ENROLL' ,`SchoolHigh` = 'BALL HIGH SCHOOL' ,`SchoolMiddle` = 'GISD OPEN ENROLL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Jamaica Beach 7' ,`TaxAmount` = '6765' ,`TaxRate` = '1.7044' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1964' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '208641979' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:07:13.577' ,`MLSNumber` = '45480259' ,`ListAgentFullName` = 'Bruce Ham' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.812097' ,`Longitude` = '-95.346268' ,`PhotoCount` = '31' ,`PostalCode` = '77026' ,`RoomCount` = '7' ,`ListPrice` = '199900.00' ,`Status` = 'Active' ,`StreetName` = 'Avenue Of Oaks' ,`StreetNumber` = '2517' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2080' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Here is your opportunity to snag this lovely starter home in the subdivision of Central Gardens. Bring your great ideas and with some TLC this home will be ready to foster a countless amount of memories! Living room and den offering an abundance of space. Lovely dining room ready to host all special gatherings. 3 bedrooms, 2.5 bathroom and situated on a 2,080 sq. ft. lot! No restrictions! No flooding! This home lies within close proximity to I-610 and US-59! This community is fast growing! Commercial property right next door and new construction home to the front. Give us a call today to make it yours! It will not last!' ,`Acres` = '0.2009' ,`Area` = '9' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,No Disclosures,Probate' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northside' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 14 BLK 14 CENTRAL GARDENS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'ROSS ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'NORTHSIDE HIGH SCHOOL' ,`SchoolMiddle` = 'KEY MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Central Gardens Sec 02' ,`TaxAmount` = '2364' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '209364842' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:59:23.467' ,`MLSNumber` = '82507571' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507846' ,`Longitude` = '-95.002203' ,`PhotoCount` = '15' ,`PostalCode` = '77573' ,`RoomCount` = '13' ,`ListPrice` = '529917.00' ,`Status` = 'Active' ,`StreetName` = 'Sellers Island' ,`StreetNumber` = '2705' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '2811' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Caledon layout with it\'s tall great room ceilings, 4 bedrooms with optional 5th/study, spacious owner\'s suite, and open concept kitchen and dining is a perfect combination of functional and inviting. Whitewater stone backsplash, durable luxury vinyl flooring, travertine flooring in owners bath, barley maple island and white upper cabinets with matte black handles is a achromatic approach that proves to be modern, but still warm and relaxing. Let the elevated design touches of this home welcome and inspire you!' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 12 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6012' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '2.8' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '209676605' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:54:56.193' ,`MLSNumber` = '82487629' ,`ListAgentFullName` = 'Jimmy Franklin' ,`ListOfficeName` = 'Empire Communities' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.507413' ,`Longitude` = '-95.001959' ,`PhotoCount` = '8' ,`PostalCode` = '77573' ,`RoomCount` = '13' ,`ListPrice` = '529087.00' ,`Status` = 'Active' ,`StreetName` = 'Sellers Island' ,`StreetNumber` = '2713' ,`StreetSuffix` = 'Street' ,`City` = 'League City' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Collingwood plan includes wood beam detailing on the exterior, as well as a front porch inspires a farmhouse feel you can find in Texas Hill Country. The kitchen, which includes a dedicated pantry space and an oversized island and open concept to living area is perfect for gathering. The natural wood cabinets and wild dunes flooring will transport you to the country side. The design touches combined with the natural light from the windows are intended to keep things warm while still feeling lifted.' ,`Acres` = '' ,`Area` = '33' ,`BuilderName` = 'Empire Communities' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'League City' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'Lot 16 Block 4 Section 4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6000' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '935' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'SANDRA MOSSMAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR FALLS HIGH SCHOOL' ,`SchoolMiddle` = 'BAYSIDE INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Coastal Point' ,`TaxAmount` = '' ,`TaxRate` = '3.11' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693323' WHERE `Matrix_Unique_ID` = '209740237' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T17:06:09.803' ,`MLSNumber` = '77939943' ,`ListAgentFullName` = 'Karen Reidel' ,`ListOfficeName` = 'Matticks Real Estate &Property Management' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.920588' ,`Longitude` = '-95.254612' ,`PhotoCount` = '28' ,`PostalCode` = '75862' ,`RoomCount` = '7' ,`ListPrice` = '159000.00' ,`Status` = 'Active' ,`StreetName` = 'Lakeside' ,`StreetNumber` = '767' ,`StreetSuffix` = 'Loop' ,`City` = 'Trinity' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '5' ,`SqFtTotal` = '2128' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome to your new home, to appreciate what this community and home on four lots have to offer you will want to see for yourself! If you are looking for a manned gated waterfront community with lake access, a park for the kiddos, a fishing pier, a place to park your boat for the day, a pool for the summer & you want space for the entire family and friends, this is the home for you. The community also offers a clubhouse & put-put golf. Drive-up & admire the mature pear trees in the front yard, the double carport to park your cars & protect them from the summer heat. This well-maintained five-bedroom home is just a short walk or golf cart ride down to the lake. Walk in the front door into the oversized living room with three secondary bedrooms, and bathroom to the left and spacious kitchen, primary bedroom, an additional bedroom or office, laundry & half bath to the right. The kitchen has a large island & breakfast bar that can seat several people along with room for a kitchen table.' ,`Acres` = '0.552' ,`Area` = '42' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Estate,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'HARBOR POINT SECTION D, LOT 056, 057, 055, LABEL # RAD117322' ,`LotDesciption` = 'Cleared,Subdivision Lot,Wooded' ,`LotSize` = '24047' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '402' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Aluminum' ,`SchoolDistrict` = '59 - Groveton' ,`SchoolElementary` = 'GROVETON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'GROVETON J H-H S' ,`SchoolMiddle` = 'GROVETON J H-H S' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Other Style' ,`Subdivision` = 'Harbor Point Sec D' ,`TaxAmount` = '2409' ,`TaxRate` = '1.6133' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1998' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693324' WHERE `Matrix_Unique_ID` = '209964630' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T17:18:06.413' ,`MLSNumber` = '38467873' ,`ListAgentFullName` = 'John Broussard' ,`ListOfficeName` = 'John N Broussard' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.031049' ,`Longitude` = '-95.836278' ,`PhotoCount` = '38' ,`PostalCode` = '77447' ,`RoomCount` = '6' ,`ListPrice` = '1499000.00' ,`Status` = 'Active' ,`StreetName` = 'Bauer Hockley' ,`StreetNumber` = '26325' ,`StreetSuffix` = 'Road' ,`City` = 'Hockley' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3454' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Priced to sell Owner motivated! Completely custom Tuscan style home on 5 acres w/pond & remote gate. Minutes from 99 & Cypress amenities. Meticulous upgrades throughout. Italian plaster walls,crown molding,Hand scraped Walnut hardwoods, high end granite/marble in all wet areas. Master suite-must see to believe. Very nice private guest suite. Large game room easily converted to additional bedroom. Open floorplan,coffered ceilings, Wine cellar, large office. Too many upgrades to list, wood shutters, granite/marble window sills, security cameras and hidden safe room. Huge covered porch overlooking backyard oasis w/pool house (storage). 40x66steel building with 3 16x16 overhead rollup doors & 950sf 1BR apartment. Additional RV shed 50/110service that backs up to 1 acre fenced area for animals, could easily be converted to stables. whole house generator. water well & septic. extensive landscaping and irrigation covering all acreage. Owner willing to sell custom furniture and farm equipment.' ,`Acres` = '5' ,`Area` = '35' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Hockley' ,`HeatSystem` = 'Propane' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 8A-2 & 8C ABST 332 HARRIS CO SCH LDS 21' ,`LotDesciption` = 'Wooded' ,`LotSize` = '217800' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Tile' ,`SchoolDistrict` = '55 - Waller' ,`SchoolElementary` = 'ROBERTS ROAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALLER HIGH SCHOOL' ,`SchoolMiddle` = 'SCHULTZ JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Contemporary/Modern,Mediterranean' ,`Subdivision` = 'Hockley' ,`TaxAmount` = '17611' ,`TaxRate` = '2.006' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2010' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693324' WHERE `Matrix_Unique_ID` = '210059584' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:07:34.527' ,`MLSNumber` = '3946581' ,`ListAgentFullName` = 'Patricia Webber' ,`ListOfficeName` = 'Key 2 Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.906517' ,`Longitude` = '-95.574887' ,`PhotoCount` = '38' ,`PostalCode` = '77064' ,`RoomCount` = '9' ,`ListPrice` = '416000.00' ,`Status` = 'Active' ,`StreetName` = 'Gold Point' ,`StreetNumber` = '10419' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3108' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'STUNNING EXECUTIVE CUSTOM BUILT BY IVY HOMES.FLOWING FLOORPLAN PERFECT FOR ENTERTAINING.2 STORY IMPRESSIVE ENTRY W/LOVELY CHANDELIER LEADS TO FORMAL DINING W/16 FT/ CEILING ,WALL OF WINDOWS & CHAIR RAIL. SPACIOUS LIVING W 2 SIDED FIREPLACE DOUBLE CROWN MOLDING,RECESSED LIGHTING & WOOD SHUTTERS..GOURMET ISLAND KITCHEN W MASSIVE AMT OF CUSTOM CABINETRY,GRANITE COUNTERS,STAINLESS APPLIANCES & WALKIN PANTRY-OPEN TO SECOND LIVING AREA W/FIREPLACE.SPACIOUS PRIMARY BEDRM W/ONSUITE W/JACUZZI TUB/SEP SHOWER,CUSTOM CABINETS & 2 VANITIESLHUGE GAMERM UP W/BUILTINS.UPSTAIRS PRIMARY W/PRIVATE BATH.2 STORY GARAGE W/STAIRS LEADING TO HUGE FLOORED STORAGE WHICH COULD BE COVERTED TO PRIVATE OFC OR GAMERM. EXTRAS INCUDE NEWLY PAINTED INTERIOR & TRIM THRUOUT,UPDATED LIGHTING,NEW VINYL PLANK IN DINING,BOTH LIVING AREAS,KITCHEN/BREAKFAST,NEW CARPET IN BEDRMS & GAMERM,CUSTOM CABINETRY THRUOUT,DOUBLE CROWN MOLDING & CUSTOM MILL WORK.NEVER FLOODED PER SELLER.CYFAIR SCHOOLS/CLOSE TO 290 & BELTWAY 8.MUST SEE!!' ,`Acres` = '0.1954' ,`Area` = '10' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Jersey Village' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 26 BLK 3 WINCHESTER COUNTRY TRAILS SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8510' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'BANG ELEMENTARY SCHOOL' ,`SchoolHigh` = 'JERSEY VILLAGE HIGH SCHOOL' ,`SchoolMiddle` = 'COOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Winchester Country Trls Sec 02' ,`TaxAmount` = '7487' ,`TaxRate` = '2.521' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1990' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693324' WHERE `Matrix_Unique_ID` = '210061341' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:15:16.237' ,`MLSNumber` = '97622443' ,`ListAgentFullName` = 'Cheyenne Deason' ,`ListOfficeName` = 'Covenant Properties RealEstate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.159735' ,`Longitude` = '-95.612569' ,`PhotoCount` = '48' ,`PostalCode` = '77486' ,`RoomCount` = '11' ,`ListPrice` = '349900.00' ,`Status` = 'Active' ,`StreetName` = 'Riverside' ,`StreetNumber` = '2110' ,`StreetSuffix` = 'Drive' ,`City` = 'West Columbia' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '2700' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome home! This contemporary, Columbia Lakes original is a renovated and unique gem. No expense has been spared in bringing this wonderful family home back to life. The quality of craftsmanship and high-end millwork are undeniable upon entry. The exterior of the home has been updated with Hardi cement board siding, which affords the same integrity as a new construction home. There are 3 bedrooms, 3 full baths, and a beautiful study that would make a great home office, or even a playroom. There\'s ample storage space with the custom built-ins, and large closets. The bedrooms, study, den, and dining room, all open up with beautiful French doors into the unique 2-story sunroom that looks out onto the recreational golf course of Columbia Lakes. Enjoy the community pool and golf during the day, and relax in your own hot tub in the evening!' ,`Acres` = '0.2152' ,`Area` = '5' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'West of the Brazos' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'COLUMBIA LAKES SEC 1 (A0133 M VARNER) BLK 7 LOT 18' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '600' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '10 - Columbia-Brazoria' ,`SchoolElementary` = '' ,`SchoolHigh` = 'COLUMBIA HIGH SCHOOL' ,`SchoolMiddle` = 'WEST BRAZOS JUNIOR HIGH' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Seller' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Columbia Lakes Sec 1-2-3-4-5' ,`TaxAmount` = '5649' ,`TaxRate` = '2.1863' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '1980' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663693324' WHERE `Matrix_Unique_ID` = '210843057' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T16:17:53.950' ,`MLSNumber` = '38541912' ,`ListAgentFullName` = 'Kristie Hernandez' ,`ListOfficeName` = 'Keller Williams Metropolitan' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.777213' ,`Longitude` = '-95.296826' ,`PhotoCount` = '3' ,`PostalCode` = '77020' ,`RoomCount` = '2' ,`ListPrice` = '155000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenville' ,`StreetNumber` = '7224' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '992' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '*INVESTOR OPPORTUNITY* This property is less than 2 blocks away from the interstate and 10 minutes from Downtown Houston. This home is tenant occupied. Please DO NOT disturb tenants.' ,`Acres` = '0.1148' ,`Area` = '2' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Denver Harbor' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LTS 12 & 13 BLK 61 HOUSTON HARBOR' ,`LotDesciption` = 'Other' ,`LotSize` = '5000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Wood Shingle' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'MARTINEZ R ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'MCREYNOLDS MIDDLE SCHOOL' ,`ShowInstructions` = 'Temporarily No Showings' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Houston Harbor' ,`TaxAmount` = '2006' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1948' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663693324' WHERE `Matrix_Unique_ID` = '210884760' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-01T17:40:37.213' ,`MLSNumber` = '77135063' ,`ListAgentFullName` = 'Gustavo Alvarado' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.825407' ,`Longitude` = '-95.410923' ,`PhotoCount` = '12' ,`PostalCode` = '77018' ,`RoomCount` = '4' ,`ListPrice` = '1350000.00' ,`Status` = 'Active' ,`StreetName` = '42nd' ,`StreetNumber` = '703' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3500' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Coming soon- Beautiful NEW construction! CORNET LOT! Two-story Modern Luxury house! It features four bedrooms, three bathrooms and one half-bath. HIGH Ceilings, with an amazing wide entryway. In the entrance you will see a beautiful custom wood work in the stairs, something unique! Hardwood/ flooring. Elegant kitchen, with custom counter tops, Island with quartz, top brands of stainless steel appliances. Large living room with gorgeous fireplace. Spacious primary bedroom downstairs with double sinks, separate shower and tub, and large walk-in-closet. Formal study. Upstairs 3 bedrooms, This a DREAM HOME, you must come and see it by yourself, you will not be disappointed, top in quality and luxury! Perfect LOT FOR A POOL.\r\nApproximate Completion Date: October/24/2022\r\nSample pictures are from previous constructions. \r\nNO flood zone!' ,`Acres` = '0.3492' ,`Area` = '9' ,`BuilderName` = 'Great Happens LLC' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Garden Oaks' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'TRS 3 & 4 BLK 28 GARDEN OAKS SEC 2' ,`LotDesciption` = 'Corner' ,`LotSize` = '15210' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'GARDEN OAKS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'BLACK MIDDLE SCHOOL' ,`ShowInstructions` = 'No Appointment Required,Vacant/Unoccupied' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Colonial,Ranch,Spanish,Traditional' ,`Subdivision` = 'Garden Oaks Sec 02' ,`TaxAmount` = '7864' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663693324' WHERE `Matrix_Unique_ID` = '210919577' --> Updated record success