• Home
  • About
  • Contact
  • Property Search
  • Favorites

MLS# 7079943 - 212 42nd Avenue NE Columbia Heights, MN 55421

Show Images
Neighborhoods

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. Brad Wadsten is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Brad Wadsten, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":562038,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7079943","MLSAGENTID":"NST506012760","MLSOFFICEID":"NST10669","ADDRESS":"212 42nd Avenue NE","ACRES":0.188,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Columbia Heights","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":2200.0,"LASTPRICEDATE":"2026-05-23T17:14:07.697","LATITUDE":45.044302,"LENDEROWNED":"No","LISTDATE":"2026-05-23T05:00:00","LISTPRICE":2200.0,"LIVINGAREA":1700.0,"LONGITUDE":-93.26522,"MODIFICATIONTIMESTAMP":"2026-05-23T21:23:06.401","OFFICE_OFFICENAME":"National Realty Guild","PHOTOCOUNT":14,"POSTALCODE":"55421","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Please contact the agent for any questions or private showings. Rent is $2200 and so is the deposit. Pet fee is a one time non-refundable $500 with breed and weight restrictions. The application fee is $50 per adult. 12-month lease term. No smoking allowed anywhere on the premises. Tenant is responsible for all utilities except water, sewer, and trash. Pets are allowed; however, weight and breed restrictions apply, please contact the listing agent for details. Tenants are required to maintain renters insurance throughout the lease term.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"13-Columbia Heights","SCHOOLDISTRICTPHONE":"7635284500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-23T17:14:07.697","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"42nd","STREETNUMBER":"212","STREETSUFFIX":"Avenue","STYLE":"Duplex Side by Side","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1963,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-23T17:14:07.696","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_6712.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_6713.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_6714.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_6715.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_6716.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_6717.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_6718.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_6719.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_6722.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_6720.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_6721.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_6723.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_6725.jpeg\"},{\"Order\":14,\"Remarks\":\"212 42nd Ave Front Photo.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7906799","NST_AboveGradeSqFtTotal":"1750","AboveGradeFinishedArea":"1100","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dryer,Exhaust Fan,Gas Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_ApplicationFee":"50","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-06-01T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Finished","BasementYN":"True","NST_BathDesc":"Main Floor 1/2 Bath,Upper Level 3/4 Bath","BathroomsFull":"0","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"750","BelowGradeFinishedArea":"600","CumulativeDaysOnMarket":"0","City":"Columbia Heights","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Window Unit(s)","CountyOrParish":"Anoka","Directions":"University to 40th (west) to 2nd street (north) to 42nd Ave (east)","DocumentsCount":"0","DaysOnMarket":"0","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1188","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","GarageSpaces":"2","Heating":"Radiator","HighSchoolDistrict":"Columbia Heights","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.044302","LaundryFeatures":"In Basement","NST_LeasePrice":"2200","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2026-05-23T05:00:00Z","ListingId":"NST7079943","LivingArea":"1700","Longitude":"-93.26522","LotSizeArea":"0.188","LotSizeDimensions":"60X139X54X139","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"750","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-05-23T12:14:01Z","OwnerPays":"Sewer,Trash Collection,Water","ParcelNumber":"353024230075","ParkingFeatures":"Detached Garage,Shared Driveway","PhotosCount":"14","PhotosChangeTimestamp":"2026-05-23T17:14:07.696Z","PostalCity":"Minneapolis","PostalCode":"55421","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"Duplex Side by Side","PropertyType":"Residential Lease","PublicRemarks":"Please contact the agent for any questions or private showings. Rent is $2200 and so is the deposit. Pet fee is a one time non-refundable $500 with breed and weight restrictions. The application fee is $50 per adult. 12-month lease term. No smoking allowed anywhere on the premises. Tenant is responsible for all utilities except water, sewer, and trash. Pets are allowed; however, weight and breed restrictions apply, please contact the listing agent for details. Tenants are required to maintain renters insurance throughout the lease term.","PublicSurveyRange":"24","PublicSurveySection":"35","PublicSurveyTownship":"30","NST_RentSpreeURL":"https://www.rentspree.com/apply/6a11dfee00555ec7d45f75c7?utm_source=northstarmls&utm_medium=applylink&utm_campaign=partner_integration","NST_RentSpreeYN":"Y","NST_SchoolDistrictNumber":"13","NST_SchoolDistrictPhone":"7635284500","NST_SecurityDeposit":"2200","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NE","StreetName":"42nd","StreetNumber":"212","StreetNumberNumeric":"212","StreetSuffix":"Avenue","SubdivisionName":"Rear Bl D Col Heights Annex","TenantPays":"Broadband,Electricity,Gas,Snow Removal","BuildingAreaTotal":"2500","Township":"Columbia Heights","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1963","ZoningDescription":"Residential-Multi-Family","ListAgentKey":"NST104286","ListAgentMlsId":"NST506012760","ListOfficeMlsId":"NST10669","ListOfficeName":"National Realty Guild","ListOfficeKey":"NST17725","ModificationTimestamp":"2026-05-23T21:23:06.401Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"IMG_6717.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/0633a6c3-47d1-4d79-b5ca-ca7a55f92f33.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.054Z\",\"MediaKey\":\"NST122452165\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"IMG_6719.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/788275b0-12e5-4c08-ae13-5840be548ee0.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.061Z\",\"MediaKey\":\"NST122452167\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"IMG_6716.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/1f755e91-90ce-456d-bc4c-4e817c32e132.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.043Z\",\"MediaKey\":\"NST122452164\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_6712.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/c10b690c-2093-4ce1-a06f-84d4bcba32cc.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.078Z\",\"MediaKey\":\"NST122452160\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"IMG_6720.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/0b871683-f584-475a-b0eb-a3d276079b5a.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.097Z\",\"MediaKey\":\"NST122452169\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_6714.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/5212052e-0baa-4d13-b03b-06bd3ea8fa92.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.068Z\",\"MediaKey\":\"NST122452162\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"IMG_6722.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/2ac2271d-a701-45ae-b4a7-ba446ee44224.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.06Z\",\"MediaKey\":\"NST122452168\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"IMG_6713.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/69f46c61-de82-4c67-a355-7dac60789e32.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.078Z\",\"MediaKey\":\"NST122452161\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"212 42nd Ave Front Photo.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/53e82843-7071-41a5-a9a1-ee18cd6fb687.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.064Z\",\"MediaKey\":\"NST122452173\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_6715.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/1f4b6084-a3db-4b67-bdbf-41e7d7d1e394.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.08Z\",\"MediaKey\":\"NST122452163\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"IMG_6725.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/893e96eb-e039-449d-a48d-0939a2860456.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.036Z\",\"MediaKey\":\"NST122452172\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"IMG_6721.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/6dfde736-06f5-4ee1-992e-c19f6bcab147.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.117Z\",\"MediaKey\":\"NST122452170\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"IMG_6723.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/e5e480b6-a95e-4935-ab96-33c57f536a7e.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.037Z\",\"MediaKey\":\"NST122452171\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"IMG_6718.jpeg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7906799/93fd36e8-338f-4108-821e-9b3f47dd3528.jpeg\",\"ResourceRecordKey\":\"NST7906799\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-05-23T17:14:05.037Z\",\"MediaKey\":\"NST122452166\"}]","Media__Order":"6","Media__MediaObjectID":"NST6","Media__LongDescription":"IMG_6717.jpeg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7906799/0633a6c3-47d1-4d79-b5ca-ca7a55f92f33.jpeg","Media__ResourceRecordKey":"NST7906799","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"5/23/2026 5:14:05 PM","Media__MediaKey":"NST122452165","DocumentsChangeTimestamp":"2026-05-23T17:14:07.697Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_6712.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_6713.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_6714.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_6715.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_6716.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_6717.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_6718.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_6719.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_6722.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_6720.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_6721.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_6723.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_6725.jpeg\"},{\"Order\":14,\"Remarks\":\"212 42nd Ave Front Photo.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}