• Active/Pending
  • Clearwater - Recently Sold
  • Clearwater Lake Lots
  • Search MLS #
  • Search other lakes
  • Sign up for automated updates
  • Mortgage calculator
  • Favorites
  • Contact Us
  • MENU

    MLS# 6730373 - 1223 42nd Avenue N Minneapolis, MN 55412

    Neighborhoods

    Keller Williams Realty Integrity Lakes is the brokerage office representing the seller for this listing.

    Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.

    The data relating to real estate for sale on this site comes in part from the broker reciprocity program of the Regional multiple Listing Service of Minnesota, Inc. real estate listings held by brokerage firms other than are marked with the Broker Reciprocity logo or the Broker reciprocity house icon and detailed information about them includes the names(s) of the listing brokers. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

    {"Id":1369698,"ORGTABLE":"RAW_Property","MLSCLASS":"COM","MLSNUMBER":"NST6730373","MLSAGENTID":"NST502050027","MLSCOAGENTID":"NST502052776","MLSOFFICEID":"NST6582","ADDRESS":"1223 42nd Avenue N","ACRES":0.16,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Single Tenant Access","CITY":"Minneapolis","CONTINGENCY":"None","COUNTY":"Hennepin","CURRENTUSE":"Beauty/Barber Shop,Residential,Retail,Bar/Tavern","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick Veneer","FORECLOSURE":"No","LASTPRICE":549900.0,"LASTPRICEDATE":"2025-07-16T15:07:03.55","LATITUDE":45.031371,"LENDEROWNED":"No","LISTDATE":"2025-06-13T05:00:00","LISTPRICE":499900.0,"LIVINGAREA":5900.0,"LONGITUDE":-93.295405,"LOTDESCRIPTION":"Infill Lot","MODIFICATIONTIMESTAMP":"2025-07-16T15:07:03.55","NEIGHBORHOOD":"Webber - Camden","OFFICE_OFFICENAME":"Keller Williams Realty Integrity Lakes","PHOTOCOUNT":3,"POSTALCODE":"55412","POTENTIALSHORTSALE":"No","PUBLICREMARKS":"This amazing opportunity to own a mixed-use building in the Camden Neighborhood of Minneapolis. Sale includes the bar. Two residential units upstairs, plus 5 commercial units on main level. Lots of off-street parking and opportunities to expand. One residential unit is vacant but has on offer to rent. Second residential unit has same tenants for 15 years. A great corner location with multiple revenue streams!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Rubber","SALEINCLUDES":"Building,Business,Fixture/Equipment,Inventory,Leases,Liquor License","SCHOOLDISTRICTNUMBER":"1-Minneapolis","SCHOOLDISTRICTPHONE":"612-668-0000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-17T05:02:05.323","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"42nd","STREETNUMBER":"1223","STREETSUFFIX":"Avenue","STYLE":"Mixed Use","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1901,"ZONING":"Business/Commercial","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-13T18:28:04.501","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_1103.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_1102.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_1098.jpeg\"}]","PHOTOORDER":"1,2,3","SOURCE":"MG_NST"}
    {"ListingKey":"NST7751605","LotSizeArea":"0.16","NST_AgeOfProperty":"124","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","AssociationAmenities":"None","Appliances":"Gas Water Heater,Range,Refrigerator","NST_AssessmentPending":"No","Basement":"Full,Single Tenant Access","BasementYN":"True","PropertySubType":"Mixed Use","NST_CeilingHeight":"8-10","City":"Minneapolis","PropertyType":"Commercial Sale","NST_ConstructionMaterialsDesc":"Brick,Frame","Contingency":"None","Cooling":"None","CountyOrParish":"Hennepin","CurrentUse":"Beauty/Barber Shop,Residential,Retail,Bar/Tavern","DaysOnMarket":"29","CumulativeDaysOnMarket":"29","Directions":"94W to Dowling Ave Exit. Left at the light to Fremont Ave N. Right on Fremont until arriving at the property on the right.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ManagerExpense":"0","ElectricExpense":"0","FuelExpense":"0","InsuranceExpense":"0","MaintenanceExpense":"0","OtherExpense":"0","OperatingExpense":"0","TrashExpense":"0","WaterSewerExpense":"0","NST_Expenses":"0.0000","ConstructionMaterials":"Brick Veneer","NST_ForeclosureStatus":"No","FoundationArea":"2950","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Parking Lot,Paved,Unassigned","NST_GarageDimensions":"25x30","NST_GarageSquareFeet":"750","GrossIncome":"0","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2025-06-17T05:00:05Z","NST_InternetOptions":"Cable,Satellite","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-16","Latitude":"45.031371","NST_LenderOwned":"No","ListAgentKey":"NST226446","ListAgentMlsId":"NST502050027","CoListAgentKey":"NST506774","CoListAgentMlsId":"NST502052776","ListingContractDate":"2025-06-13T05:00:00Z","ListOfficeKey":"NST11236","ListOfficeName":"Keller Williams Realty Integrity Lakes","ListOfficeMlsId":"NST6582","ListPrice":"499900","Longitude":"-93.295405","LotFeatures":"Infill Lot","LotSizeDimensions":"55.1x128","LotSizeUnits":"Square Feet","ListingId":"NST6730373","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Webber - Camden","NetOperatingIncome":"0","NST_OfficeBoard":"MAAR","NST_OverheadDoorClearance":"0-9 Feet","OwnerPays":"Electricity,Gas,Insurance,Janitorial Service,Repairs","ParcelNumber":"0402924120152","GarageSpaces":"1","NST_ParkingOpen":"12","NST_PatioPorchType":"Rear Porch","PhotosCount":"3","PostalCity":"Minneapolis","PostalCode":"55412","NST_PotentialShortSale":"No","PossibleUse":"Office,Retail,Shop","PublicRemarks":"This amazing opportunity to own a mixed-use building in the Camden Neighborhood of Minneapolis. Sale includes the bar. Two residential units upstairs, plus 5 commercial units on main level. Lots of off-street parking and opportunities to expand. One residential unit is vacant but has on offer to rent. Second residential unit has same tenants for 15 years. A great corner location with multiple revenue streams!","PublicSurveyRange":"24","PublicSurveySection":"04","PublicSurveyTownship":"29","NST_RangeNum":"Three","NST_RefrigeratorNum":"Three","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Yes","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Rubber","Inclusions":"Building,Business,Fixture/Equipment,Inventory,Leases,Liquor License","HighSchoolDistrict":"Minneapolis","NST_SchoolDistrictNumber":"1","NST_SchoolDistrictPhone":"612-668-0000","Sewer":"City Sewer/Connected","BuildingAreaTotal":"5900","StateOrProvince":"MN","StandardStatus":"Active","StreetDirSuffix":"N","StreetName":"42nd","StreetNumber":"1223","StreetNumberNumeric":"1223","StreetSuffix":"Avenue","SubdivisionName":"Wyoming Park Add","NST_TaxWithAssessments":"13119.0000","TaxYear":"2025","TaxAnnualAmount":"13119","TenantPays":"Cable TV,Electricity","NumberOfUnitsTotal":"8","Utilities":"Electric Separate,Heating Common","WaterSource":"City Water/Connected","YearBuilt":"1901","ZoningDescription":"Business/Commercial","ModificationTimestamp":"2025-07-16T15:07:03.55Z","PhotosChangeTimestamp":"2025-06-13T18:28:04.501Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7751605\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"IMG_1103.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7751605/dc498a90-55ad-400d-a9fa-35a6f912466b.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T18:27:29.183Z\",\"MediaKey\":\"684c6d91109caa789cd7cc95\"},{\"ResourceRecordKey\":\"NST7751605\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"IMG_1102.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7751605/5d80640e-2d5a-4448-9d3e-7f82bd55afaa.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T18:27:29.181Z\",\"MediaKey\":\"684c6d91109caa789cd7cc96\"},{\"ResourceRecordKey\":\"NST7751605\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"IMG_1098.jpeg\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7751605/6891c65b-72f0-4038-a1f9-ca2546617fc6.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T18:27:29.162Z\",\"MediaKey\":\"684c6d91109caa789cd7cc97\"}]","UnitTypes":"[{\"UnitTypeBedsTotal\":3,\"NST_UnitBathFull\":\"1\",\"UnitTypeKey\":\"NST18807\",\"NST_LeaseExpirationDt\":\"2025-06-30\",\"NST_UnitLevel\":\"SECND\",\"UnitTypeActualRent\":2020,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":\"5\",\"NST_UnitID\":\"1\",\"NST_UnitNumber\":\"2\",\"NST_UnitIsLeased\":\"1\"},{\"UnitTypeKey\":\"NST18808\",\"NST_UnitLevel\":\"SECND\",\"UnitTypeBathsTotal\":0,\"NST_UnitRoomsTotal\":\"3\",\"NST_UnitID\":\"2\",\"NST_UnitNumber\":\"1\",\"NST_UnitIsLeased\":\"0\"},{\"UnitTypeKey\":\"NST18809\",\"UnitTypeBathsTotal\":0,\"NST_UnitRoomsTotal\":\"1\",\"NST_UnitID\":\"3\",\"NST_UnitNumber\":\"3\",\"NST_UnitIsLeased\":\"0\"},{\"UnitTypeKey\":\"NST18810\",\"NST_LeaseExpirationDt\":\"2025-06-30\",\"UnitTypeActualRent\":700,\"NST_UnitBath3Qtr\":\"1\",\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":\"2\",\"NST_UnitID\":\"4\",\"NST_UnitNumber\":\"4\",\"NST_UnitIsLeased\":\"1\"},{\"NST_UnitBathHalf\":\"1\",\"UnitTypeKey\":\"NST18811\",\"NST_LeaseExpirationDt\":\"2025-06-30\",\"UnitTypeActualRent\":1500,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":\"3\",\"NST_UnitID\":\"5\",\"NST_UnitNumber\":\"5\",\"NST_UnitIsLeased\":\"1\"},{\"NST_UnitBathHalf\":\"2\",\"UnitTypeKey\":\"NST18812\",\"NST_LeaseExpirationDt\":\"2025-06-30\",\"NST_UnitLevel\":\"MULTI\",\"UnitTypeActualRent\":1000,\"UnitTypeBathsTotal\":2,\"NST_UnitRoomsTotal\":\"3\",\"NST_UnitID\":\"6\",\"NST_UnitNumber\":\"6\",\"NST_UnitIsLeased\":\"1\"},{\"NST_UnitBathHalf\":\"1\",\"UnitTypeKey\":\"NST18813\",\"NST_LeaseExpirationDt\":\"2025-06-30\",\"UnitTypeActualRent\":900,\"UnitTypeBathsTotal\":1,\"NST_UnitRoomsTotal\":\"2\",\"NST_UnitID\":\"7\",\"NST_UnitNumber\":\"7\",\"NST_UnitIsLeased\":\"1\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_1103.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_1102.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_1098.jpeg\"}]","PhotoOrder":"1,2,3","CustomVTourURL":""}
    ©2025, All rights reserved. Created with REC by AfterNorth.