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-18T11:40:32.737' ,`MLSNumber` = '24072179' ,`ListAgentFullName` = 'Marangeli Aranzamendi' ,`ListOfficeName` = 'Executive Texas Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.085683' ,`Longitude` = '-96.069809' ,`PhotoCount` = '29' ,`PostalCode` = '77445' ,`RoomCount` = '4' ,`ListPrice` = '335000.00' ,`Status` = 'Active' ,`StreetName` = '2nd St' ,`StreetNumber` = '2036' ,`StreetSuffix` = '' ,`City` = 'Hempstead' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1871' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Minutes from mayor highway 4 bedroom 2 bathroom NEW home. Beautiful stone elevation, kitchen granite countertops, separate tub and shower in master bathroom, large covered porch and more. Easy access and lots of growth happening nearby. 45 min drive to Houston area.' ,`Acres` = '0.2152' ,`Area` = '26' ,`BuilderName` = 'Ponce\'s Hometown' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Hempstead' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'S519000 HEMPSTEAD BLK 496 LOT S/2 OF 4 & ALL OF 5' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '9374' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '24 - Hempstead' ,`SchoolElementary` = 'HEMPSTEAD ELEMENTARY SCHOOL' ,`SchoolHigh` = 'HEMPSTEAD HIGH SCHOOL' ,`SchoolMiddle` = 'HEMPSTEAD MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Hempstead' ,`TaxAmount` = '435' ,`TaxRate` = '2.4184' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700174' WHERE `Matrix_Unique_ID` = '205961178' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:51:54.760' ,`MLSNumber` = '71685097' ,`ListAgentFullName` = 'David Wen' ,`ListOfficeName` = 'Unity Real Estate Services LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.577574' ,`Longitude` = '-95.637437' ,`PhotoCount` = '31' ,`PostalCode` = '77479' ,`RoomCount` = '4' ,`ListPrice` = '560000.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Trail' ,`StreetNumber` = '4307' ,`StreetSuffix` = 'Court' ,`City` = 'Sugar Land' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '3713' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'In sought after crescent lakes, first colony. Minutes walking distance away from Colony Meadows Elementary, The Honor Roll School, and Clements High School. Great floorplan and beautiful shutter blinds downstairs. Great schools, great and quiet neighborhood, walking distance to Smart Financial Centre and golf course. Very low tax rates.' ,`Acres` = '0.1977' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Sugar Land South' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CRESCENT LAKES SEC 2, BLOCK 3, LOT 14' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8610' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'COLONY MEADOWS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEMENTS HIGH SCHOOL' ,`SchoolMiddle` = 'FORT SETTLEMENT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Crescent Lakes Sec 2' ,`TaxAmount` = '10534' ,`TaxRate` = '2.1584' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1995' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700174' WHERE `Matrix_Unique_ID` = '206517413' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:35:42.930' ,`MLSNumber` = '35162316' ,`ListAgentFullName` = 'Therese Rogers' ,`ListOfficeName` = 'JPAR - The Sears Group' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.477023' ,`Longitude` = '-98.863049' ,`PhotoCount` = '32' ,`PostalCode` = '78624' ,`RoomCount` = '9' ,`ListPrice` = '850000.00' ,`Status` = 'Active' ,`StreetName` = 'Sagebiel Ranch' ,`StreetNumber` = '23' ,`StreetSuffix` = 'Road' ,`City` = 'Fredericksburg' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2002' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'What a welcoming retreat!! 4/5 bed, 1ba with fireplace and open kitchen is a first generation German pioneer home. If you\'re searching for the perfect location to build your dream business, this 11.25 acres of unlimited potential for farming, a vineyard winery, Airbnb, or bed and breakfast is a MUST SEE. This property is located in walking distance of the well-known, breath-taking famous Enchanted Rock mountains. Gorgeous hikes and beautiful views of the arts of nature. Large concrete floor barn at the rear of property with 2 stalls and a restroom inside. There\'s also a workshop at the rear of the main home, either could be converted into livable space. Enjoy this quiet and peaceful country setting, take in the views and watch the abundance of tranquility. NO HOA. Ag Exemption' ,`Acres` = '11.25' ,`Area` = '83' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ABS A0049 P BUGLER #489, 11.51 ACRES' ,`LotDesciption` = 'Cleared' ,`LotSize` = '457816' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '285 - Fredericksburg' ,`SchoolElementary` = '' ,`SchoolHigh` = 'FREDERICKSBURG HIGH SCHOOL' ,`SchoolMiddle` = '' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'FBG 965 NORTH' ,`TaxAmount` = '50' ,`TaxRate` = '1.3418' ,`WaterSewer` = 'Septic Tank' ,`YearBuilt` = '1907' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '207282699' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:39:39.527' ,`MLSNumber` = '74669731' ,`ListAgentFullName` = 'Kristen Novicke' ,`ListOfficeName` = 'Texas Trust Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.778708' ,`Longitude` = '-96.299175' ,`PhotoCount` = '24' ,`PostalCode` = '77474' ,`RoomCount` = '7' ,`ListPrice` = '555000.00' ,`Status` = 'Active' ,`StreetName` = 'Kulow' ,`StreetNumber` = '10046' ,`StreetSuffix` = 'Road' ,`City` = 'Sealy' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1887' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Come enjoy Country Living just miles from Cat Spring!! Situated on a hill top allows for awesome views of the country side and Texas sunset. This immaculate 3 bedroom, 2 1/2 bath home is on 6 acres and is being sold by the original owners! Kitchen has a breakfast area and lots of cabinet and counter space. Comfortable living space with fireplace; Spacious primary bedroom with large bath; Property has two septic systems and an 1800+ square foot shop/barn with four overhead doors. Make your appointment today and don\'t miss out seeing this impressive property!' ,`Acres` = '6' ,`Area` = '57' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace,Wood Burning Fireplace' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Butane' ,`HOAMandatory` = '0' ,`Legal` = 'A228 H & T C R R ACRES 6.000' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '261360' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '109 - Sealy' ,`SchoolElementary` = 'SEALY ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SEALY HIGH SCHOOL' ,`SchoolMiddle` = 'SEALY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Kulow Rd' ,`TaxAmount` = '5768' ,`TaxRate` = '1.8832' ,`WaterSewer` = 'Septic Tank,Well' ,`YearBuilt` = '2002' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '207904277' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:10:55.313' ,`MLSNumber` = '33572853' ,`ListAgentFullName` = 'Usman Toor' ,`ListOfficeName` = 'REALM Real Estate Professional' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.669703' ,`Longitude` = '-95.353154' ,`PhotoCount` = '26' ,`PostalCode` = '77033' ,`RoomCount` = '4' ,`ListPrice` = '425000.00' ,`Status` = 'Active' ,`StreetName` = 'Sunflower' ,`StreetNumber` = '4909' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1889' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautiful 2 story home, located near to medical center, a lot of new construction going on around the neighborhood, no HOA and low TAX, call for more details!!!' ,`Acres` = '0.0631' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Medical Center South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 4 BLK 1 SUNFLOWER CROSSING' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2750' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BASTIAN ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WORTHING HIGH SCHOOL' ,`SchoolMiddle` = 'ATTUCKS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Sunflower Xing' ,`TaxAmount` = '409' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '208956857' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:13:02.060' ,`MLSNumber` = '28870203' ,`ListAgentFullName` = 'Amy Shao' ,`ListOfficeName` = 'HomeSmart' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.885765' ,`Longitude` = '-95.705865' ,`PhotoCount` = '7' ,`PostalCode` = '77433' ,`RoomCount` = '9' ,`ListPrice` = '268000.00' ,`Status` = 'Active' ,`StreetName` = 'Narcissus Brook' ,`StreetNumber` = '19623' ,`StreetSuffix` = 'Lane' ,`City` = 'Cypress' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2000' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great 3 bedroom plus large game room with a closet, on a cul de sac. All bedrooms up. Laminate wood and title floor -- No Carpet!! Recent AC unit. Currently sell \"as is & where it is\" . The price will be chnaged back after remodeling. Good for ower ocuupid & investment both. Don\'t miss it!' ,`Acres` = '' ,`Area` = '25' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Owner/Agent,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Cypress South' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 40 BLK 1 YAUPON PLACE SEC 1' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '4464' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '312' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '13 - Cypress-Fairbanks' ,`SchoolElementary` = 'JOWELL ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CYPRESS SPRINGS HIGH SCHOOL' ,`SchoolMiddle` = 'HOPPER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Call Occupant,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Yaupon Place' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '209416376' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:37:22.423' ,`MLSNumber` = '24276612' ,`ListAgentFullName` = 'Jacqueline Wallman' ,`ListOfficeName` = 'Texas Homes Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.776029' ,`Longitude` = '-95.593552' ,`PhotoCount` = '32' ,`PostalCode` = '77079' ,`RoomCount` = '7' ,`ListPrice` = '519000.00' ,`Status` = 'Active' ,`StreetName` = 'Kimberley' ,`StreetNumber` = '14127' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1912' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Welcome Home! Spacious 3 BR Home In Desirable Community. This Home Features Tile & Wood Flooring Throughout. High Ceilings and Ceiling Fans. Both Formals Upon Entry. Spacious Den with French Doors Leading Out to Backyard Area. Kitchen Comes With Granite Counter Tops, Tile Backsplash, Breakfast Bar and Window Seating Area. Primary with Huge Walk In Closet and Built Ins! Nice Size Secondary Rooms. Long Driveway with Additional Parking in Back and Detached 2 Car Garage. Mature trees offer plenty of shade. Come Take A Look Today, You Don\'t Want To Miss Out on This Home!' ,`Acres` = '0.1692' ,`Area` = '23' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Memorial West' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 3 BLK 3 NOTTINGHAM WEST SEC 2' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '7370' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '680' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WILCHESTER ELEMENTARY SCHOOL' ,`SchoolHigh` = 'STRATFORD HIGH SCHOOL (SPRING BRANCH)' ,`SchoolMiddle` = 'SPRING FOREST MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Nottingham West Sec 02' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1965' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '209591393' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:37:08.900' ,`MLSNumber` = '27776852' ,`ListAgentFullName` = 'Kimberly Durham' ,`ListOfficeName` = 'Pecan Classic Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.759159' ,`Longitude` = '-95.342116' ,`PhotoCount` = '38' ,`PostalCode` = '77003' ,`RoomCount` = '6' ,`ListPrice` = '409900.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '454' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1920' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Contemporary 3 story Townhome located in an EaDo gated community. Walking distance to the Historic Navigation Esplanade which hosts a weekly farmers market, live music and other events, Minute Maid Park, The Original Ninfa\'s, and many breweries. One mile from Saint Arnolds. 1st floor has a secondary bedroom/office with a private bathroom and 2 car garage. 2nd floor boasts a large family room, 1/2 bath, dining area, and an open kitchen with a large granite island, gas stove top and under cabinet lighting. 3rd floor is the Master Suite, secondary bedroom, and utility. Beautiful engineered wood floors throughout! No carpet! Several upgrades! Pet friendly backyard is fenced with artificial turf and a small patio. This community overlooks Buffalo Bayou with tons of open grass land for walking or pets. Immediate access to 45, 59, and I-10' ,`Acres` = '0.041' ,`Area` = '4' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'East End Revitalized' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 8 BLK 1 PARKVIEW ON THE BAYOU' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1785' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'BURNET ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WHEATLEY HIGH SCHOOL' ,`SchoolMiddle` = 'NAVARRO MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required,Leave Business Card,Supra Keybox' ,`SqFtSource` = 'Seller' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern,Split Level' ,`Subdivision` = 'Parkview/Bayou' ,`TaxAmount` = '8470' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2016' ,`YearBuiltSrc` = 'Seller' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '209893491' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:02:16.957' ,`MLSNumber` = '27820807' ,`ListAgentFullName` = 'Sherry Bruno' ,`ListOfficeName` = 'Lake Area Homes, Bruno Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.798276' ,`Longitude` = '-95.170037' ,`PhotoCount` = '14' ,`PostalCode` = '77364' ,`RoomCount` = '4' ,`ListPrice` = '139900.00' ,`Status` = 'Active' ,`StreetName` = 'Belize' ,`StreetNumber` = '60' ,`StreetSuffix` = 'Drive' ,`City` = 'Point Blank' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '832' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Cute Lake House in Gated Waterfront Community. The home has 2 bedrooms, 1 bath, a large patio off the back of the home, 2 lots, and a large workshop. The home has been painted inside and upgrades made. Come take a peek at this little beauty. The boat ramp is about a five-minute walk, park just to the right of the home and pool about a minute away from the community center. A storage 10 x 12 shed is included. Perfect weekends get away, or home.' ,`Acres` = '0.4042' ,`Area` = '64' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'MAGNOLIA LAKE ESTATES I, SEC F OF HVL, LOT 90 & 91, ACRES .4' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '17607' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '42' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range,Freestanding Range' ,`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,Controlled Access,Leave Business Card' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Magnolia Lake Estate I Sec F' ,`TaxAmount` = '945' ,`TaxRate` = '1.6254' ,`WaterSewer` = 'Public Sewer' ,`YearBuilt` = '2006' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '210682509' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:34:45.943' ,`MLSNumber` = '36083398' ,`ListAgentFullName` = 'Dan McCarver' ,`ListOfficeName` = 'BHGRE Gary Greene' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.592034' ,`Longitude` = '-95.134829' ,`PhotoCount` = '50' ,`PostalCode` = '77062' ,`RoomCount` = '12' ,`ListPrice` = '819000.00' ,`Status` = 'Active' ,`StreetName` = 'Lofty Mountain' ,`StreetNumber` = '14207' ,`StreetSuffix` = 'Trail' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '4117' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Serene setting on #5 Bay Oaks Country Club Golf Course. Stately traditional design built by Kustom Kastles. Soaring two story Great Room with fpl, wood floors and a tall wall of windows. Spacious dining room and home office all featuring the builder\'s quality millwork. Primary bedroom and bath are down, three bedrooms & game room up. Updated appliances and Quartz countertops in chef\'s kitchen, which is open to family room. Vaulted home office is thru the leaded glass pocket doors at entry. Covered patio has a wonderful view of the course.' ,`Acres` = '0.2882' ,`Area` = '7' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Clear Lake Area' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'LT 10 BLK 1 BAY OAKS SEC 3' ,`LotDesciption` = 'In Golf Course Community,On Golf Course,Subdivision Lot,Wooded' ,`LotSize` = '12555' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '930' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '3' ,`OvenType` = 'Convection Oven,Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '9 - Clear Creek' ,`SchoolElementary` = 'FALCON PASS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CLEAR LAKE HIGH SCHOOL' ,`SchoolMiddle` = 'SPACE CENTER INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay Oaks' ,`TaxAmount` = '19226' ,`TaxRate` = '2.5769' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700175' WHERE `Matrix_Unique_ID` = '210999226' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:10:42.143' ,`MLSNumber` = '50733912' ,`ListAgentFullName` = 'Carlar Bennett' ,`ListOfficeName` = 'Keller Williams Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.717499' ,`Longitude` = '-95.058850' ,`PhotoCount` = '14' ,`PostalCode` = '77351' ,`RoomCount` = '3' ,`ListPrice` = '150000.00' ,`Status` = 'Active' ,`StreetName` = 'Greenway' ,`StreetNumber` = '107' ,`StreetSuffix` = '' ,`City` = 'Livingston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '902' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Charming 3 bed 2 bath home is situated in the Lake Livingston Village. Lake Livingston Village is a beautifully wooded subdivision located in the heart of Polk County. Interior features include a large living room that opens up to the kitchen/dining area boasting ample cabinet space + a nook. Exterior features include a massive newly paved covered 2 car carport and beautiful landscaping, Lake Livingston Village has amenities everyone is sure to enjoy such as a subdivision boat ramp, fishing pier, and a picnic area for the family! This home is priced to sell and won\'t last long. Schedule a private tour today! Amenities are exclusively for residents and their guests. \r\n===BEDROOM SIZES ARE APPROX MEASUREMENT===\r\nIncome-producing property on 3 bedroom 2 bath sits on 2 lots in Lake Livingston Village. Single wide 14X76 manufactured home which could be leased for about $1,200/month.' ,`Acres` = '0.0812' ,`Area` = '44' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Lake Livingston Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'Lake Livingston Village Section 7 Lot 240, Lot 241' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = 'Unknown' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '24' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '103 - Livingston' ,`SchoolElementary` = 'LISD OPEN ENROLL' ,`SchoolHigh` = 'LIVINGSTON HIGH SCHOOL' ,`SchoolMiddle` = 'LIVINGSTON JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Lake Livingston Village' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1982' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700176' WHERE `Matrix_Unique_ID` = '211127109' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:44:55.577' ,`MLSNumber` = '22351110' ,`ListAgentFullName` = 'Jared Turner' ,`ListOfficeName` = 'Turner Mangum,LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.864700' ,`Longitude` = '-95.282900' ,`PhotoCount` = '6' ,`PostalCode` = '77016' ,`RoomCount` = '3' ,`ListPrice` = '238415.00' ,`Status` = 'Active' ,`StreetName` = 'Red Orchid' ,`StreetNumber` = '10519' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1553' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'The Somerville floorplan. Brand new open concept one story plan.' ,`Acres` = '' ,`Area` = '2' ,`BuilderName` = 'Rausch Coleman Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northeast Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = '5-4-11' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '450' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SHADYDALE ELEMENTARY' ,`SchoolHigh` = 'NORTH FOREST HIGH SCHOOL' ,`SchoolMiddle` = 'FOREST BROOK MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Wayside Village' ,`TaxAmount` = '' ,`TaxRate` = '3.13' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700176' WHERE `Matrix_Unique_ID` = '211306251' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:27:18.127' ,`MLSNumber` = '78586016' ,`ListAgentFullName` = 'Meaghan Arceneaux' ,`ListOfficeName` = 'Mega Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.847105' ,`Longitude` = '-95.678794' ,`PhotoCount` = '32' ,`PostalCode` = '77414' ,`RoomCount` = '5' ,`ListPrice` = '480000.00' ,`Status` = 'Active' ,`StreetName` = 'County Road 282' ,`StreetNumber` = '411' ,`StreetSuffix` = '' ,`City` = 'Sargent' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2280' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'If plenty of space inside and out is what you desire, this is the one! 2280 square feet! This home in Sargent Texas features two living areas, 5 bedrooms, 2 baths, indoor utility/washer/dryer area, a fireplace, and an inviting tub to soak in after a long day. All this and more on 19.35 unrestricted acres. Imagine yourself living here, on this peaceful quiet road with minimal traffic, and just 8 minutes from Sargent Beach which has many great places to fish or just relax and take in the scenery. Speaking of fish! The pond in the backyard has bass AND blue and yellow catfish! You won\'t want to imagine yourself anywhere else. Large kitchen was made for cooking and it\'s complete with a pot filler! Roof replaced a few months ago. Home has well and is on an aerobic septic system. There is an additional well and septic, as there was previously another home on the property next to where this home is now, the current owner is unaware of the working condition of the additional well and septic.' ,`Acres` = '19.35' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'AB 0071, G PENTECOST, ACRES 19.35, MH LABEL# NTA1483620' ,`LotDesciption` = 'Other,Water View' ,`LotSize` = '842886' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '134 - Van Vleck' ,`SchoolElementary` = 'VAN VLECK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'VAN VLECK HIGH SCHOOL' ,`SchoolMiddle` = 'O H HERMAN MIDDLE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'VV SEC 3 ALL MH' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Aerobic,Well' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663700176' WHERE `Matrix_Unique_ID` = '211350120' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T10:53:28.130' ,`MLSNumber` = '84319980' ,`ListAgentFullName` = 'Alison Coy' ,`ListOfficeName` = 'Privet Residential' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.809111' ,`Longitude` = '-95.431603' ,`PhotoCount` = '10' ,`PostalCode` = '77008' ,`RoomCount` = '3' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Ohsfeldt' ,`StreetNumber` = '2540' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2283' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Brand new construction in desirable Shady Acres! This is our most popular floorplan for a reason, it\'s spacious with large bedrooms and plenty of windows to let in natural light. The oversized master bedroom comfortably fits large scale furniture, has a seating area and a special little nook for a coffee or tea bar. The master bathroom boasts marble tile floors and shower walls. Meticulously picked finishes set this home apart from any other. Come see this home today!' ,`Acres` = '0.0608' ,`Area` = '9' ,`BuilderName` = 'Redwood Construction' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Heights/Greater Heights' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 1 BLK 1 SHADY ACRES SEC 2 5TH PAR R/P' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2650' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'SINCLAIR ELEMENTARY SCHOOL (HOUSTON)' ,`SchoolHigh` = 'WALTRIP HIGH SCHOOL' ,`SchoolMiddle` = 'HAMILTON MIDDLE SCHOOL (HOUSTON)' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '3' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Shady Acres' ,`TaxAmount` = '2779' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700176' WHERE `Matrix_Unique_ID` = '211504876' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-18T11:35:54.520' ,`MLSNumber` = '43877970' ,`ListAgentFullName` = 'Patrick Burbridge' ,`ListOfficeName` = 'CitiQuest Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.851238' ,`Longitude` = '-95.438581' ,`PhotoCount` = '27' ,`PostalCode` = '77091' ,`RoomCount` = '5' ,`ListPrice` = '344900.00' ,`Status` = 'Active' ,`StreetName` = 'Highland Sky' ,`StreetNumber` = '5805' ,`StreetSuffix` = 'Lane' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1568' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'TO-BE-BUILT! OPEN HOUSES AT THE SALES OFFICE - 5406 TUSKEGEE ST. Saturdays & Sundays 1-5pm. Move-in ready by SUMMER 2023! Gorgeous new construction by Disama Group. Nestled in gated community on a quiet street, this stunning two-story floor plan with private driveway offers an open concept living & kitchen area on the first floor that extends to a spacious fenced backyard. Primary suit and 2 secondary bedrooms on the second floor. Upgraded finishes throughout including smart home system, Quartz counter tops, stainless-steel appliances, primary bathroom - free standing bathtub & upgraded cabinets with soft close drawers. Enjoy this 30-home gated community located minutes away from Downtown Houston. Easy access to I45 and 610.\r\nPhotos and Matterport from another community by the same builder. Finishes and layout WILL VARY!\r\nFor GPS please use 1837 Mansfield St. Houston TX 77091.' ,`Acres` = '' ,`Area` = '9' ,`BuilderName` = 'Disama Group' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Northwest Houston' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 13 BLK 1' ,`LotDesciption` = 'Patio Lot' ,`LotSize` = '2420' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1425' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '1 - Aldine' ,`SchoolElementary` = 'ANDERSON ACADEMY' ,`SchoolHigh` = 'CARVER H S FOR APPLIED TECH/ENGINEERING/ARTS' ,`SchoolMiddle` = 'DREW ACADEMY' ,`ShowInstructions` = 'Supra Keybox' ,`SqFtSource` = 'Builder' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Mansfield Square' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2023' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663700176' WHERE `Matrix_Unique_ID` = '211563905' --> Updated record success