$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
National Realty Guild 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. Nolan Team | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Nolan Team | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. Nolan Team | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Nolan Team | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1349152,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6725651","MLSAGENTID":"NST502042244","MLSOFFICEID":"NST10669","ADDRESS":"1733 37th Avenue NE","ACRES":0.39,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Owner Access,Walkout","CITY":"Columbia Heights","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LAKEACRES":7.0,"LAKEDEPTH":"0","LAKEWATERFRONT":"Lake Front","LASTPRICE":549900.0,"LASTPRICEDATE":"2025-08-25T00:19:03.477","LATITUDE":45.036131,"LENDEROWNED":"No","LISTDATE":"2025-05-21T05:00:00","LISTPRICE":495000.0,"LIVINGAREA":3840.0,"LONGITUDE":-93.233092,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-08-25T15:01:03.64","OFFICE_OFFICENAME":"National Realty Guild","PHOTOCOUNT":7,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"No Rental City License Required if you have a 144G &/or 245D License if you have 5 or less residences. Fantastic investment opportunity in Columbia Heights! This spacious property was previously used as a triplex and is currently zoned R2. Property can be used as a single family home if no rental license is wanted. It can also be licensed as a Assisted Living Facility or Group Home for our business owners. Seller is open to Contract for Deed financing. Major updates include a new roof on house and garage (2017), two new boilers (2018), two new water heaters (2019) and updated bathrooms and kitchen on the lower level. Low maintenance, high potential! Perfect for a first time investor! Don’t miss this opportunity to add value and long-term cash flow to your portfolio!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"13-Columbia Heights","SCHOOLDISTRICTPHONE":"763-528-4500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-05-28T05:02:05.407","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"NE","STREETNAME":"37th","STREETNUMBER":"1733","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTFEET":"100","WATERFRONTNAME":"Hart","WATERFRONTNUM":"02008100","WATERFRONTPRESENT":true,"WATERFRONTVIEW":"Lake Front","YEARBUILT":1963,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-05-22T13:13:03.643","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Lake Front Duplex!\"},{\"Order\":2,\"Remarks\":\"Back Yard\"},{\"Order\":3,\"Remarks\":\"Unit 2 Full Bath\"},{\"Order\":4,\"Remarks\":\"Unit 2 Kitchen\"},{\"Order\":5,\"Remarks\":\"Basement Unit Kitchen\"},{\"Order\":6,\"Remarks\":\"Basement Unit Bath\"},{\"Order\":7,\"Remarks\":\"Front of Home\"}]","PHOTOORDER":"1,2,3,4,5,6,7","SOURCE":"MG_NST"}
{"ListingKey":"NST7747445","LotSizeArea":"0.39","NST_AgeOfProperty":"62","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","AssociationAmenities":"Coin-op Laundry Owned","NST_AssessmentPending":"No","Basement":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Owner Access,Walkout","BasementYN":"True","City":"Columbia Heights","PropertyType":"Residential Income","NST_ConstructionMaterialsDesc":"Concrete","NewConstructionYN":"False","Contingency":"None","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"89","CumulativeDaysOnMarket":"161","Directions":"Hwy 35W N, Exit Johnson St NE, Right onto 37th Ave Ne, Home on Left","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"200+ Amp Service","ManagerExpense":"5040","ElectricExpense":"2700","FuelExpense":"1380","InsuranceExpense":"1800","MaintenanceExpense":"0","OtherExpense":"0","OperatingExpense":"4200","TrashExpense":"0","WaterSewerExpense":"4200","NST_Expenses":"4200.0000","ConstructionMaterials":"Stucco","Fencing":"None","NST_ForeclosureStatus":"No","FoundationArea":"1920","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Concrete","NST_GarageSquareFeet":"528","GrossIncome":"72000","AccessibilityFeatures":"None","Heating":"Boiler","OriginalEntryTimestamp":"2025-05-28T05:00:05Z","NST_InternetOptions":"Cable,Fiber Optic","NST_LakeAcres":"7","NST_LakeChain":"N","NST_LakeDepth":"0","WaterfrontFeatures":"Lake Front","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-25","Latitude":"45.036131","NST_LenderOwned":"No","ListAgentKey":"NST98085","ListAgentMlsId":"NST502042244","ListingContractDate":"2025-05-21T05:00:00Z","ListOfficeKey":"NST17725","ListOfficeName":"National Realty Guild","ListOfficeMlsId":"NST10669","ListPrice":"495000","LivingArea":"3840","NST_LockBoxSource":"SPAAR","LockBoxType":"Combo","Longitude":"-93.233092","LotFeatures":"Some Trees","LotSizeDimensions":"S50x140x55Lx165","LotSizeUnits":"Acres","ListingId":"NST6725651","SourceSystemName":"RMLS","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","NST_OwnerOccupied":"No","OwnerPays":"Sewer,Trash Collection","ParcelNumber":"363024430025","GarageSpaces":"2","PhotosCount":"7","PostalCity":"Minneapolis","PostalCode":"55421","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"No Rental City License Required if you have a 144G &/or 245D License if you have 5 or less residences. Fantastic investment opportunity in Columbia Heights! This spacious property was previously used as a triplex and is currently zoned R2. Property can be used as a single family home if no rental license is wanted. It can also be licensed as a Assisted Living Facility or Group Home for our business owners. Seller is open to Contract for Deed financing. Major updates include a new roof on house and garage (2017), two new boilers (2018), two new water heaters (2019) and updated bathrooms and kitchen on the lower level. Low maintenance, high potential! Perfect for a first time investor! Don’t miss this opportunity to add value and long-term cash flow to your portfolio!","PublicSurveyRange":"24","PublicSurveySection":"36","PublicSurveyTownship":"30","NST_RangeNum":"Two","NST_RefrigeratorNum":"Two","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Yes","NST_RoadBetweenWaterfrontAndHomeYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","NST_AboveGradeSqFtTotal":"1920.0000","NST_BelowGradeSqFtTotal":"1920.0000","NST_MainLevelFinishedArea":"1920.0000","BuildingAreaTotal":"3840","HighSchoolDistrict":"Columbia Heights","NST_SchoolDistrictNumber":"13","NST_SchoolDistrictPhone":"763-528-4500","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1920","BelowGradeFinishedArea":"1920","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"NE","StreetName":"37th","StreetNumber":"1733","StreetNumberNumeric":"1733","StreetSuffix":"Avenue","PropertySubType":"Duplex Up and Down","SubdivisionName":"Aud Sub Waltons Sunny Ac 3rd","NST_TaxWithAssessments":"7164.0000","TaxYear":"2024","TaxAnnualAmount":"7164","TenantPays":"Electricity,Gas","NumberOfUnitsTotal":"2","WaterSource":"City Water/Connected","WaterfrontYN":"True","NST_WaterfrontFeet":"100","WaterBodyName":"Hart","NST_WaterfrontNum":"02008100","View":"Panoramic","YearBuilt":"1963","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-08-25T15:01:03.64Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7747445\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Lake Front Duplex!\",\"ImageWidth\":1208,\"ImageHeight\":1106,\"ImageSizeDescription\":\"1208x1106\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/07831a70-b8bf-4d51-9889-c8c77b5f127a.png\",\"MediaModificationTimestamp\":\"2025-05-21T23:36:30.403Z\",\"MediaKey\":\"682e637eadf009706066ce22\"},{\"ResourceRecordKey\":\"NST7747445\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Back Yard\",\"ImageWidth\":1202,\"ImageHeight\":1012,\"ImageSizeDescription\":\"1202x1012\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/7a26233d-5bbd-44ed-8e5a-c551f7e06c0c.png\",\"MediaModificationTimestamp\":\"2025-05-22T13:11:42.91Z\",\"MediaKey\":\"682f228ebeadd0560393371f\"},{\"ResourceRecordKey\":\"NST7747445\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Unit 2 Full Bath\",\"ImageWidth\":1144,\"ImageHeight\":1018,\"ImageSizeDescription\":\"1144x1018\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/b4e53632-b2ee-4ce7-8376-a2b6d48f7121.png\",\"MediaModificationTimestamp\":\"2025-05-22T13:11:42.868Z\",\"MediaKey\":\"682f228ebeadd05603933720\"},{\"ResourceRecordKey\":\"NST7747445\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Unit 2 Kitchen\",\"ImageWidth\":1328,\"ImageHeight\":1100,\"ImageSizeDescription\":\"1328x1100\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/a5260d00-7888-4225-9eeb-02b5c2d5cb63.png\",\"MediaModificationTimestamp\":\"2025-05-22T13:11:42.974Z\",\"MediaKey\":\"682f228ebeadd05603933721\"},{\"ResourceRecordKey\":\"NST7747445\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Basement Unit Kitchen\",\"ImageWidth\":1214,\"ImageHeight\":1090,\"ImageSizeDescription\":\"1214x1090\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/0c3b4b56-363d-449b-be2b-b6b7d9f71863.png\",\"MediaModificationTimestamp\":\"2025-05-22T13:11:42.883Z\",\"MediaKey\":\"682f228ebeadd05603933722\"},{\"ResourceRecordKey\":\"NST7747445\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Basement Unit Bath\",\"ImageWidth\":1188,\"ImageHeight\":1104,\"ImageSizeDescription\":\"1188x1104\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/ec2db0e3-1a1d-4de5-9924-afdb42f2bfec.png\",\"MediaModificationTimestamp\":\"2025-05-22T13:11:42.874Z\",\"MediaKey\":\"682f228ebeadd05603933723\"},{\"ResourceRecordKey\":\"NST7747445\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Front of Home\",\"ImageWidth\":1370,\"ImageHeight\":1036,\"ImageSizeDescription\":\"1370x1036\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7747445/af6757f7-6665-46f4-8431-da54d03b4891.png\",\"MediaModificationTimestamp\":\"2025-05-22T13:11:42.98Z\",\"MediaKey\":\"682f228ebeadd05603933724\"}]","PhotosChangeTimestamp":"2025-05-22T13:13:03.643Z","UnitTypes":"[{\"UnitTypeKey\":\"NST153775\",\"UnitTypeTotalRent\":36000,\"NST_UnitBath3Qtr\":\"0\",\"NST_UnitBathFull\":\"2\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":2,\"UnitTypeBedsTotal\":4,\"NST_MonthlyExpenses\":\"0.00\",\"NST_FamilyRoomRoomFeatures\":\"Family Room\",\"NST_UnitFireplaceNum\":\"0\",\"NST_UnitFurnished\":\"No\",\"NST_UnitID\":\"1\",\"NST_UnitLevel\":\"Main Level\",\"UnitTypeActualRent\":3000,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":\"10\",\"NST_UnitSqFt\":\"1920\"},{\"UnitTypeKey\":\"NST153776\",\"NST_UnitAmenities\":\"Ceiling Fan(s),Countertops-Granite,Kitchen Center Island\",\"UnitTypeTotalRent\":36000,\"NST_UnitAppl\":\"Dryer,Microwave,Range\",\"NST_UnitBath3Qtr\":\"0\",\"NST_UnitBathFull\":\"1\",\"NST_UnitBathHalf\":\"0\",\"NST_UnitBathQtr\":\"0\",\"UnitTypeBathsTotal\":1,\"UnitTypeBedsTotal\":3,\"NST_MonthlyExpenses\":\"0.00\",\"NST_UnitFireplaceNum\":\"0\",\"NST_UnitFurnished\":\"No\",\"NST_UnitID\":\"2\",\"NST_UnitLevel\":\"Below Ground\",\"UnitTypeActualRent\":3000,\"UnitTypeUnitsTotal\":1,\"NST_UnitRoomsTotal\":\"9\",\"NST_UnitSqFt\":\"1920\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Lake Front Duplex!\"},{\"Order\":2,\"Remarks\":\"Back Yard\"},{\"Order\":3,\"Remarks\":\"Unit 2 Full Bath\"},{\"Order\":4,\"Remarks\":\"Unit 2 Kitchen\"},{\"Order\":5,\"Remarks\":\"Basement Unit Kitchen\"},{\"Order\":6,\"Remarks\":\"Basement Unit Bath\"},{\"Order\":7,\"Remarks\":\"Front of Home\"}]","PhotoOrder":"1,2,3,4,5,6,7","CustomVTourURL":""}