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-20T15:23:04.417' ,`MLSNumber` = '85709428' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.186227' ,`Longitude` = '-96.277326' ,`PhotoCount` = '47' ,`PostalCode` = '77437' ,`RoomCount` = '5' ,`ListPrice` = '229999.00' ,`Status` = 'Active' ,`StreetName` = 'Palacios' ,`StreetNumber` = '507' ,`StreetSuffix` = '' ,`City` = 'El Campo' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '5' ,`SqFtTotal` = '2004' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.2537' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'NA' ,`LotDesciption` = 'Cleared' ,`LotSize` = '11051' ,`LotSizeSource` = 'Other' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '198 - El Campo' ,`SchoolElementary` = '' ,`SchoolHigh` = 'EL CAMPO HIGH SCHOOL' ,`SchoolMiddle` = 'EL CAMPO MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'El Campo' ,`TaxAmount` = '' ,`TaxRate` = '2.48' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701000' WHERE `Matrix_Unique_ID` = '197489054' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:30:16.087' ,`MLSNumber` = '87094703' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.302590' ,`Longitude` = '-96.071553' ,`PhotoCount` = '7' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = 'Golf Crest' ,`StreetNumber` = '2855' ,`StreetSuffix` = 'Drive' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open design that allows separation from the main living sightlines; to the galley kitchen and dinning area. Floor plan offers 3 spacious bedrooms and new kitchen appliances. Newly designed layout is great for active lifestyles and cleanliness by limiting carpet to the bedrooms only!! The newest exterior and interior color palates for exterior and interior design, that allows seamless coordination with new home furnishings and décor for years to come. Home also features state of the art energy efficiency; that will keep money at home! Builder offers 1-2-10 year warranty, move-in package. ** see floor plan layout in attachments (realtors see agent remarks)' ,`Acres` = '' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GOLF CREST EST. LOT 13' ,`LotDesciption` = 'Cleared' ,`LotSize` = '6443' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Golf Crest Estate' ,`TaxAmount` = '' ,`TaxRate` = '2.43' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663701000' WHERE `Matrix_Unique_ID` = '200951570' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:31:36.470' ,`MLSNumber` = '73730358' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.303244' ,`Longitude` = '-96.071489' ,`PhotoCount` = '42' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = 'Golf Crest' ,`StreetNumber` = '2849' ,`StreetSuffix` = 'Drive' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open design that allows separation from the main living sightlines; to the galley kitchen and dinning area. Floor plan offers 3 spacious bedrooms and new kitchen appliances. Newly designed layout is great for active lifestyles and cleanliness by limiting carpet to the bedrooms only!! The newest exterior and interior color palates for exterior and interior design, that allows seamless coordination with new home furnishings and décor for years to come. Home also features state of the art energy efficiency; that will keep money at home! Builder offers 1-2-10 year warranty, move-in package. ** see floor plan layout in attachments (realtors see agent remarks)' ,`Acres` = '0.1173' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GOLF CREST EST. LOT 10' ,`LotDesciption` = 'Cleared' ,`LotSize` = '5110' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Golf Crest Estate' ,`TaxAmount` = '' ,`TaxRate` = '2.43' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663701000' WHERE `Matrix_Unique_ID` = '200952227' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:32:04.427' ,`MLSNumber` = '12093757' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.302522' ,`Longitude` = '-96.071450' ,`PhotoCount` = '32' ,`PostalCode` = '77488' ,`RoomCount` = '3' ,`ListPrice` = '149999.00' ,`Status` = 'Active' ,`StreetName` = 'Golf Crest' ,`StreetNumber` = '2853' ,`StreetSuffix` = '' ,`City` = 'Wharton' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open design that allows separation from the main living sightlines; to the galley kitchen and dinning area. Floor plan offers 3 spacious bedrooms and new kitchen appliances. Newly designed layout is great for active lifestyles and cleanliness by limiting carpet to the bedrooms only!! The newest exterior and interior color palates for exterior and interior design, that allows seamless coordination with new home furnishings and décor for years to come. Home also features state of the art energy efficiency; that will keep money at home! Builder offers 1-2-10 year warranty, move-in package. ** see floor plan layout in attachments (realtors see agent remarks)' ,`Acres` = '0.1028' ,`Area` = '55' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'GOLF CREST EST. LOT 12' ,`LotDesciption` = 'Cleared' ,`LotSize` = '4478' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '180 - Wharton' ,`SchoolElementary` = 'CG SIVELLS/WHARTON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'WHARTON HIGH SCHOOL' ,`SchoolMiddle` = 'WHARTON JUNIOR HIGH' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Golf Crest Estate' ,`TaxAmount` = '' ,`TaxRate` = '2.43' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '200952512' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:28:42.630' ,`MLSNumber` = '17681734' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.976760' ,`Longitude` = '-95.976173' ,`PhotoCount` = '50' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '139999.00' ,`Status` = 'Active' ,`StreetName` = 'Moore' ,`StreetNumber` = '3212' ,`StreetSuffix` = 'Avenue' ,`City` = 'Bay City' ,`BathsFull` = '1' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1040' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Open design that allows separation from the main living sightlines; to the galley kitchen and dinning area. Floor plan offers 3 spacious bedrooms and new kitchen appliances. Newly designed layout is great for active lifestyles and cleanliness by limiting carpet to the bedrooms only!! The newest exterior and interior color palates for exterior and interior design, that allows seamless coordination with new home furnishings and décor for years to come. Home also features state of the art energy efficiency; that will keep money at home! Builder offers 1-2-10 year warranty, move-in package. ** see floor plan layout in attachments (realtors see agent remarks)' ,`Acres` = '0.138' ,`Area` = '54' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'LT 21 BLK 7' ,`LotDesciption` = 'Other' ,`LotSize` = '6011' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '' ,`OvenType` = 'Electric 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' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Morton-Corbett' ,`TaxAmount` = '' ,`TaxRate` = '2.82' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '' ,`YearBuiltSrc` = '' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '201495205' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:04:28.003' ,`MLSNumber` = '33677436' ,`ListAgentFullName` = 'Mohammad Elsaadi' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.751713' ,`Longitude` = '-95.388079' ,`PhotoCount` = '22' ,`PostalCode` = '77006' ,`RoomCount` = '6' ,`ListPrice` = '535000.00' ,`Status` = 'Active' ,`StreetName` = 'Bomar' ,`StreetNumber` = '572' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2347' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Gorgeous 3 bedroom & 3.5 bathroom home in a gated Montrose community. Located about 10-12 minutes from downtown this home comes with high ceilings, open concept and an abundance of natural light. Full kitchen remodel includes repainted cabinets, new handles, new dish washer and an updated kitchen island that makes perfect for entertaining guests. Plantation shutters installed throughout the home will convey with sale. Fridge, washer, dryer & crystal chandelier above dining table stay with the home as well. HOA fees include water, trash & gate maintenance. \r\n**NEVER FLOODED**' ,`Acres` = '0.051' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 27 BLK 1 MILLENNIUM HOMES ON BOMAR AVE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '2220' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1040' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'WILLIAM WHARTON K-8 DUAL LANGUAGE ACADEMY' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'GREGORY-LINCOLN MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '3' ,`Style` = 'Traditional' ,`Subdivision` = 'Millennium Homes On Bomar Ave' ,`TaxAmount` = '11112' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '206629503' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T14:27:38.673' ,`MLSNumber` = '20111194' ,`ListAgentFullName` = 'Valery Smith-Blank' ,`ListOfficeName` = 'RE/MAX Integrity' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.277975' ,`Longitude` = '-95.476774' ,`PhotoCount` = '31' ,`PostalCode` = '77304' ,`RoomCount` = '10' ,`ListPrice` = '643500.00' ,`Status` = 'Active' ,`StreetName` = 'Coral Bells' ,`StreetNumber` = '122' ,`StreetSuffix` = 'Lane' ,`City` = 'Conroe' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '3014' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Custom 1-story w/open floor plan. High ceilings. HURRY AND YOU CAN PICK ALL OF YOUR COLORS/FINISHES! Study & Living Room feature 12\' ceilings. Very open floor plan w/lots of natural light. The gourmet kitchen is beautiful w/custom cabinetry, lg. pantry, huge center island, BOSCH stainless appliances-incl., double ovens, 5 Burner Cooktop. If you buy now, you can still pick kitchen and powder room cabinets and other finish out selections. Primary Bedroom Retreat is HUGE w/a great sitting area & primary bath w/double sinks, sep. shower, over-sized tub. Huge closet. All bedrooms have separate baths. Lg. covered back porch plumbed for gas so you can add that outdoor kitchen. HUGE TX Basement w/easy stair access & a Workshop in the garage. This plan offers all of the design elements of the Model, but adds a MUD Room, re-designed utility room. Best of all this plan offers all of the pluses of our model, but at a lower price. NO FLOODING.' ,`Acres` = '' ,`Area` = '19' ,`BuilderName` = 'Jaeger Homes, Inc.' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Conroe Southwest' ,`HeatSystem` = 'Central Gas,Zoned' ,`HOAMandatory` = '1' ,`Legal` = 'S537506 - Grand Central Park 06, BLOCK 1, Lot 17' ,`LotDesciption` = 'Cul-De-Sac,Greenbelt,Subdivision Lot' ,`LotSize` = '9777' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1075' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '11 - Conroe' ,`SchoolElementary` = 'WILKINSON ELEMENTARY SCHOOL' ,`SchoolHigh` = 'CONROE HIGH SCHOOL' ,`SchoolMiddle` = 'PEET JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Grand Central Park' ,`TaxAmount` = '6220' ,`TaxRate` = '3.2585' ,`WaterSewer` = 'Public Sewer,Water District' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '207448047' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:23:37.580' ,`MLSNumber` = '70851185' ,`ListAgentFullName` = 'Joshua Hill' ,`ListOfficeName` = 'Compass RE Texas, LLCHeights' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.734913' ,`Longitude` = '-95.407884' ,`PhotoCount` = '34' ,`PostalCode` = '77098' ,`RoomCount` = '7' ,`ListPrice` = '739900.00' ,`Status` = 'Active' ,`StreetName` = 'Colquitt' ,`StreetNumber` = '1919' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2965' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Stunning gated home by Michael Thurman Custom Homes with ELEVATOR. This home features gorgeous hardwood floors throughout the main living areas, the primary bedroom and all stairs. Elevator leads to all 5 levels, including the rooftop deck(west facing view) featuring a gas fireplace and gas line ready for your outdoor kitchen! The Primary Suite has a lavish wet room with honed slate tile and oversized closet system featuring a Eurocave wine fridge. The fourth floor includes a large game room and guest bedroom. Recent updates include New HVAC (2021) and new paint (2022), epoxied garage floor, and solid Anderson doors on the 5th floor. Incredible location close to shopping, restaurants and great downtown living!' ,`Acres` = '0.0367' ,`Area` = '16' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Montrose' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 3 BLK 1 COLQUITT COURT' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '1597' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '27 - Houston' ,`SchoolElementary` = 'POE ELEMENTARY SCHOOL' ,`SchoolHigh` = 'LAMAR HIGH SCHOOL (HOUSTON)' ,`SchoolMiddle` = 'LANIER MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '5' ,`Style` = 'Traditional' ,`Subdivision` = 'Colquitt Court' ,`TaxAmount` = '13736' ,`TaxRate` = '2.3307' ,`WaterSewer` = 'Public Water,Septic Tank' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '209833959' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T14:31:11.577' ,`MLSNumber` = '10737968' ,`ListAgentFullName` = 'Ryan Sulit' ,`ListOfficeName` = 'Hans-Christian Realty & Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.981724' ,`Longitude` = '-95.406020' ,`PhotoCount` = '13' ,`PostalCode` = '77073' ,`RoomCount` = '8' ,`ListPrice` = '299900.00' ,`Status` = 'Active' ,`StreetName` = 'Ruby Red' ,`StreetNumber` = '19931' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2279' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Don\'t miss this opportunity to see this beautiful two story 4,2.5,2 family home. The home features tile flooring and carpet on all bedrooms. Newly installed roof.' ,`Acres` = '0.1364' ,`Area` = '12' ,`BuilderName` = 'D R Horton' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 1 BLK 1 IMPERIAL GREEN SEC 1' ,`LotDesciption` = 'Corner' ,`LotSize` = '5943' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '400' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Convection Oven,Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'HOYLAND ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'DUEITT MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Lockbox Front,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Contemporary/Modern' ,`Subdivision` = 'Imperial Green Sec 01' ,`TaxAmount` = '6164' ,`TaxRate` = '2.8904' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2008' ,`YearBuiltSrc` = 'Appraisal' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '210429122' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T14:03:27.590' ,`MLSNumber` = '4615089' ,`ListAgentFullName` = 'Jody Cassady' ,`ListOfficeName` = 'Full Stringer Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.666091' ,`Longitude` = '-95.963952' ,`PhotoCount` = '37' ,`PostalCode` = '77457' ,`RoomCount` = '4' ,`ListPrice` = '775000.00' ,`Status` = 'Active' ,`StreetName` = 'Private Road 670' ,`StreetNumber` = '162' ,`StreetSuffix` = '' ,`City` = 'Matagorda' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '1962' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully appointed home located on private road on Colorado River in Matagorda. Custom built hme featuring an open plan for kitchen, dining, living. Kitchen is set up for the chef extraordinaire! Granite countertops, sea glass backsplash, top of the line appliances including commercial style vent hood with a large island for entertaining. Walk in pantry and generous food preparation counter spaces. Amazing views with expansive windows throughout the entire house overlooking river, east bay, and west bay. Outdoor space with decking above the boat lift and under the home near the fishing pier! Top floor features a large master suite with a walk-in closet. The bathroom is complete with a tiled walk-in shower, large Jacuzzi tub and double sinks. Private balcony for the master suite. Two additional bedrooms and a tiled guest bath and laundry area on top floor. Custom draperies and solar screens throughout. Central vacuum for both floors. Come and view this gorgeous home!' ,`Acres` = '0.1715' ,`Area` = '54' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'COLORADO RIVER ESTATES SEC 1 LOT 41' ,`LotDesciption` = 'Waterfront' ,`LotSize` = '7470' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '0' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Other' ,`SchoolDistrict` = '170 - Matagorda' ,`SchoolElementary` = 'MATAGORDA ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'MATAGORDA ELEMENTARY SCHOOL' ,`ShowInstructions` = 'Lockbox Front' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Other Style' ,`Subdivision` = 'Colorado River Estate Sec 1' ,`TaxAmount` = '5665' ,`TaxRate` = '1.9245' ,`WaterSewer` = 'Other Water/Sewer' ,`YearBuilt` = '2011' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701001' WHERE `Matrix_Unique_ID` = '211129975' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:27:17.770' ,`MLSNumber` = '98568884' ,`ListAgentFullName` = 'Lyle Jackson' ,`ListOfficeName` = 'LJ Group Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '28.976214' ,`Longitude` = '-95.974450' ,`PhotoCount` = '9' ,`PostalCode` = '77414' ,`RoomCount` = '3' ,`ListPrice` = '169999.00' ,`Status` = 'Active' ,`StreetName` = 'AvenueB' ,`StreetNumber` = '2721' ,`StreetSuffix` = '' ,`City` = 'Bay City' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1278' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = '' ,`Acres` = '0.172' ,`Area` = '54' ,`BuilderName` = 'Censeo Homes' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 1 Block 29 Bay City Original Townsite' ,`LotDesciption` = 'Cleared' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '1' ,`NewConstructionDesc` = 'To Be Built/Under Construction' ,`NoOfGarageCap` = '1' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '132 - Bay City' ,`SchoolElementary` = 'TENIE HOLMES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'BAY CITY HIGH SCHOOL' ,`SchoolMiddle` = 'BAY CITY JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Builder' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Bay City Original Townsite' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2022' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1663701002' WHERE `Matrix_Unique_ID` = '211255049' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T14:05:21.437' ,`MLSNumber` = '28565520' ,`ListAgentFullName` = 'Marco Gumero' ,`ListOfficeName` = 'La Palma Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.998915' ,`Longitude` = '-95.413880' ,`PhotoCount` = '26' ,`PostalCode` = '77073' ,`RoomCount` = '9' ,`ListPrice` = '265000.00' ,`Status` = 'Active' ,`StreetName` = 'Brushy Glen' ,`StreetNumber` = '403' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '2053' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Two story home with 3 bedrooms and 2.5 bathrooms with attached garage. High ceiling, formal living and dinning area, family room with fireplace. Ceiling fans in all bedrooms. Master bedroom with walk-in closet, master bathroom with separate shower and bathtub, double sink. Laminate floor, carpet and vinyl. Close to I-45 and Hardy Toll Road.' ,`Acres` = '0.1365' ,`Area` = '12' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Aldine Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 45 BLK 2 NORTHRIDGE PARK WEST SEC 3' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '5948' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '346' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Freestanding Oven,Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Freestanding Range,Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '48 - Spring' ,`SchoolElementary` = 'EICKENROHT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'ANDY DEKANEY H S' ,`SchoolMiddle` = 'RICKY C BAILEY M S' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Northridge Park West Sec 03' ,`TaxAmount` = '4764' ,`TaxRate` = '2.5554' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2004' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701002' WHERE `Matrix_Unique_ID` = '211369743' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2022-08-20T15:48:57.630' ,`MLSNumber` = '68019223' ,`ListAgentFullName` = 'Amanda Ham' ,`ListOfficeName` = 'AE Realty' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.034720' ,`Longitude` = '-95.541809' ,`PhotoCount` = '35' ,`PostalCode` = '77379' ,`RoomCount` = '4' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Fernbluff' ,`StreetNumber` = '18226' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2990' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This beautiful traditional 2990sqft home boasts 4 bedrooms, 2.5 baths & a large upstairs gameroom. You will love the high ceilings, oversized closets, and custom wood cabinetry. The light & bright eat-in kitchen has granite countertops, Bosch dishwasher, gas stove, and pull out shelves in the bottom cabinets. The laundry rooms offers a broom closet with extra cabinets and counter space. The living & dining rooms have hardwood floors, crown molding, and custom shutters. The living room also features a built-in entertainment center, wet bar & gas fireplace. The primary suite has new carpet, 2 large closets, walk in shower, garden tub, and a double vanity with plenty of storage. All upstairs bedrooms & game room have new carpet. The huge backyard has an enormous stamped concrete patio with a pergola, perfect for entertaining. Call or text for an appointment.' ,`Acres` = '0.4132' ,`Area` = '13' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Champions Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 30 BLK 4 017*S2915536-001-004-030 SHANNON FOREST SEC 1' ,`LotDesciption` = 'Cleared,Other' ,`LotSize` = '18000' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '650' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '1' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '32 - Klein' ,`SchoolElementary` = 'EHRHARDT ELEMENTARY SCHOOL' ,`SchoolHigh` = 'KLEIN HIGH SCHOOL' ,`SchoolMiddle` = 'KLEB INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,Lockbox Front,Request Online Appointment,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Shannon Forest' ,`TaxAmount` = '6336' ,`TaxRate` = '2.5085' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1991' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1663701002' WHERE `Matrix_Unique_ID` = '211449277' --> Updated record success