A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
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. 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.
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.
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":649000.0,"LASTPRICEDATE":"2025-06-17T18:48:03.677","LATITUDE":45.036131,"LENDEROWNED":"No","LISTDATE":"2025-05-21T05:00:00","LISTPRICE":569900.0,"LIVINGAREA":3840.0,"LONGITUDE":-93.233092,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-06-17T18:48:03.676","OFFICE_OFFICENAME":"National Realty Guild","PHOTOCOUNT":7,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Fantastic investment opportunity in Columbia Heights! This spacious property was previously used as a triplex and is currently zoned R2 and will need to be converted back into a legal duplex to meet city requirements. Property can be used as a single family home if no rental license is wanted. Seller is open to Contract for Deed financing at 5% interest, 30% down for 5 years. 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":"20","CumulativeDaysOnMarket":"92","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-06-17","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":"569900","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":"Fantastic investment opportunity in Columbia Heights! This spacious property was previously used as a triplex and is currently zoned R2 and will need to be converted back into a legal duplex to meet city requirements. Property can be used as a single family home if no rental license is wanted. Seller is open to Contract for Deed financing at 5% interest, 30% down for 5 years. 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-06-17T18:48:03.676Z","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":""}