mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About Team
- Leech Lake Properties
- Lake Homes and Cabins
- Walker MN
- Affordable Lake Property
- Newest Properties
- Daily Hotsheets
- Cass County
- Hubbard County
- Itasca County
- Crow Wing County
- Aitkin County
- Advanced Search
- Buyers
- Sellers
- Estimate Request
- Contact
- Search Listings >>>
- Leech Lake, DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
Coldwell Banker Realty 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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, 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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1414034,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6795277","MLSAGENTID":"NST503516993","MLSOFFICEID":"NST26737","ADDRESS":"2604 4th Avenue NE","ACRES":1.39,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Rochester","CONTINGENCY":"None","COUNTY":"Olmsted","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Wood Siding","FORECLOSURE":"No","LASTPRICE":136000.0,"LASTPRICEDATE":"2025-09-26T20:26:03.79","LATITUDE":44.05065,"LENDEROWNED":"No","LISTDATE":"2025-09-26T05:00:00","LISTPRICE":136000.0,"LIVINGAREA":777.0,"LONGITUDE":-92.456053,"MODIFICATIONTIMESTAMP":"2025-09-27T10:05:06.202","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":18,"POSTALCODE":"55906","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Step inside this beautifully updated main floor condo where comfort meets convenience with zero steps and easy access throughout. Inside, you'll love the fresh, recently updated modern touches including brand new flooring, bathroom remodel and freshly painted walls that create a clean, inviting space. \nRelax and unwind outdoors with an amazing backyard view surrounded by a fence and a serene backyard, a rare find that offers peace and seclusion right in the city.\nEnjoy the unbeatable location just minutes from great dining, shopping, and entertainment and less that 10 minutes to downtown Rochester, Whether you're looking to own for less than rent or searching for an investment property, this condo checks all the boxes. Plus it comes with an active rental certificate and a newer roof (2024) for added peace of mind.\nMove in ready gem! Owner is the agent! Schedule your showing today, this won't last long!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"535-Rochester","SCHOOLDISTRICTPHONE":"507-328-3000","SCHOOLELEMENTARY":"Churchill-Hoover","SCHOOLHIGH":"Century","SCHOOLMIDDLE":"Kellogg","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-26T20:26:03.79","LASTSTATUS":"Active","STREETDIRSUFFIX":"NE","STREETNAME":"4th","STREETNUMBER":"2604","STREETSUFFIX":"Avenue","STYLE":"Low Rise","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1979,"ZONING":"Residential-Multi-Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-09-27T03:08:04.103","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"6.jpg\"},{\"Order\":7,\"Remarks\":\"7.jpg\"},{\"Order\":8,\"Remarks\":\"8.jpg\"},{\"Order\":9,\"Remarks\":\"9.jpg\"},{\"Order\":10,\"Remarks\":\"10.jpg\"},{\"Order\":11,\"Remarks\":\"11.jpg\"},{\"Order\":12,\"Remarks\":\"12.jpg\"},{\"Order\":13,\"Remarks\":\"13.jpg\"},{\"Order\":14,\"Remarks\":\"14.jpg\"},{\"Order\":15,\"Remarks\":\"15.jpg\"},{\"Order\":16,\"Remarks\":\"17.jpg\"},{\"Order\":17,\"Remarks\":\"16.jpg\"},{\"Order\":18,\"Remarks\":\"18.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7808042","LotSizeArea":"1.39","NST_AgeOfProperty":"46","NST_AgentOwner":"Yes","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Ceiling Fan(s),Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Patio,Walk-In Closet","Appliances":"Range,Refrigerator,Wall Oven","NST_AssessmentPending":"No","AssociationFeeIncludes":"Lawn Care,Parking,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"225","AssociationName":"Jakobson Management Coi","AssociationPhone":"507-536-0000","PropertyAttachedYN":"True","NST_AttributionContact":"507-666-8666","NST_AttributionName":"Ziad Alameddine","Basement":"None","BasementYN":"False","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Rochester","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Olmsted","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","Directions":"Broadway Ave N onto 24th St NE, turn right onto 4th Ave NE, unit is the far left side of the building","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Wood Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"777","NST_FractionalOwnershipYN":"No","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"Assigned","AccessibilityFeatures":"No Stairs External,No Stairs Internal","Heating":"Baseboard","OriginalEntryTimestamp":"2025-09-26T20:23:00Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-27","Latitude":"44.05065","NST_LenderOwned":"No","ListAgentKey":"NST520013","ListAgentMlsId":"NST503516993","ListingContractDate":"2025-09-26T05:00:00Z","ListOfficeKey":"NST26737","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST26737","ListPrice":"136000","LivingArea":"777","LockBoxType":"Combo","Longitude":"-92.456053","LotSizeDimensions":"Common","LotSizeSquareFeet":"60635.52","LotSizeUnits":"Acres","ListingId":"NST6795277","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SEMR","ParcelNumber":"742522021018","GarageSpaces":"0","PhotosCount":"18","PostalCity":"Rochester","PostalCode":"55906","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Step inside this beautifully updated main floor condo where comfort meets convenience with zero steps and easy access throughout. Inside, you'll love the fresh, recently updated modern touches including brand new flooring, bathroom remodel and freshly painted walls that create a clean, inviting space. \nRelax and unwind outdoors with an amazing backyard view surrounded by a fence and a serene backyard, a rare find that offers peace and seclusion right in the city.\nEnjoy the unbeatable location just minutes from great dining, shopping, and entertainment and less that 10 minutes to downtown Rochester, Whether you're looking to own for less than rent or searching for an investment property, this condo checks all the boxes. Plus it comes with an active rental certificate and a newer roof (2024) for added peace of mind.\nMove in ready gem! Owner is the agent! Schedule your showing today, this won't last long!","PublicSurveyRange":"14","PublicSurveySection":"25","PublicSurveyTownship":"107","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc,Pets Not Allowed","NST_AboveGradeSqFtTotal":"777.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"777.0000","BuildingAreaTotal":"777","HighSchoolDistrict":"Rochester","NST_SchoolDistrictNumber":"535","NST_SchoolDistrictPhone":"507-328-3000","ElementarySchool":"Churchill-Hoover","HighSchool":"Century","MiddleOrJuniorSchool":"Kellogg","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"777","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"NE","StreetName":"4th","StreetNumber":"2604","StreetNumberNumeric":"2604","StreetSuffix":"Avenue","PropertySubType":"Low Rise","SubdivisionName":"Cedar Estates Condos-Torrens","NST_TaxWithAssessments":"782.0000","TaxYear":"2025","TaxAnnualAmount":"782","UnitNumber":"1","WaterSource":"City Water/Connected","YearBuilt":"1979","ZoningDescription":"Residential-Multi-Family","ModificationTimestamp":"2025-09-27T10:05:06.202Z","PhotosChangeTimestamp":"2025-09-27T03:08:04.103Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7808042\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1.jpg\",\"ImageWidth\":768,\"ImageHeight\":576,\"ImageSizeDescription\":\"768x576\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/bd4bd822-4437-4327-9f17-3151f265c42c.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.076Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c61b\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"2.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/ad782877-4dc6-4a6f-afb6-18d366d4c568.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.078Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c61c\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"3.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/a475dd09-4f98-4509-9d55-1feecc2f1329.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c61d\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"4.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/33aa0ff5-f9db-4abd-8e63-c7254bfd1058.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c61e\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"5.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/d4be6642-df66-4018-a659-f777e4a89bbd.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.05Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c61f\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"6.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/fde606a8-d836-4e9d-a644-00ef38ff4c31.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.084Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c620\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"7.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/a4593a40-ed50-42a6-89e2-c8926c194a96.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.117Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c621\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"8.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/637c1ec8-2999-4c65-9e2d-80319f3c8589.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c622\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"9.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/84b45403-a9cc-4eed-a725-ed64f394b68b.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c623\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"10.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/5f33ef5c-4840-4238-89bc-58eb2e37a26f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.076Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c624\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"11.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/55eb946b-c4c7-4bfb-8b28-2b8b62d880df.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.076Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c625\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"12.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/62e5343f-244a-4d17-9c07-a9cf08f912c4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c626\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"13.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/70257ca2-e9aa-4b11-ba53-fcfefd63d406.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c627\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"14.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/095b3375-9eb8-4837-8120-42067c05b2ef.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.077Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c628\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"15.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/d4471e21-324a-4c39-a6a9-4f6f986f3d9d.jpeg\",\"MediaModificationTimestamp\":\"2025-09-26T20:50:27.149Z\",\"MediaKey\":\"68d6fc937f24cc6b3317c629\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"17.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/fc1340ad-c436-40ce-a391-36e3d0ef5956.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T03:07:19.977Z\",\"MediaKey\":\"68d754e87f24cc6b3317f38a\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"16.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/f2eb8205-7eba-4037-a210-b42f5aa21089.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T03:07:20.01Z\",\"MediaKey\":\"68d754e87f24cc6b3317f38b\"},{\"ResourceRecordKey\":\"NST7808042\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"18.jpg\",\"ImageWidth\":1500,\"ImageHeight\":844,\"ImageSizeDescription\":\"1500x844\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7808042/36883082-064d-4710-a171-761b0ea4626e.jpeg\",\"MediaModificationTimestamp\":\"2025-09-27T03:07:20.008Z\",\"MediaKey\":\"68d754e87f24cc6b3317f38c\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1.jpg\"},{\"Order\":2,\"Remarks\":\"2.jpg\"},{\"Order\":3,\"Remarks\":\"3.jpg\"},{\"Order\":4,\"Remarks\":\"4.jpg\"},{\"Order\":5,\"Remarks\":\"5.jpg\"},{\"Order\":6,\"Remarks\":\"6.jpg\"},{\"Order\":7,\"Remarks\":\"7.jpg\"},{\"Order\":8,\"Remarks\":\"8.jpg\"},{\"Order\":9,\"Remarks\":\"9.jpg\"},{\"Order\":10,\"Remarks\":\"10.jpg\"},{\"Order\":11,\"Remarks\":\"11.jpg\"},{\"Order\":12,\"Remarks\":\"12.jpg\"},{\"Order\":13,\"Remarks\":\"13.jpg\"},{\"Order\":14,\"Remarks\":\"14.jpg\"},{\"Order\":15,\"Remarks\":\"15.jpg\"},{\"Order\":16,\"Remarks\":\"17.jpg\"},{\"Order\":17,\"Remarks\":\"16.jpg\"},{\"Order\":18,\"Remarks\":\"18.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}
$MLSDESCRIPTION$
2604 4th Avenue NE Rochester, MN 55906
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2604 4th Avenue NE Rochester, MN 55906
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$