mike@minnesotarealestatesales.com
Phone: 218-821-4775
- Mille Lacs Lake Homes
- Mille Lacs Lake Lots
- Newest Listings
- Aitkin County
- Crow Wing County
- Mille Lacs County
- Estimate Request
- About Team
- Sellers
- Buyers
- Daily Hotsheets
- DNR Lake Information
- Best Mille Lacs Lake Resorts
Contact me here...
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Leading Edge 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":604589,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7133291","MLSAGENTID":"NST496506604","MLSOFFICEID":"NST26247","ADDRESS":"2594 Fairview Avenue N","ACRES":0.355,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":250000.0,"LASTPRICEDATE":"2026-08-25T20:19:06.77","LATITUDE":45.019255,"LENDEROWNED":"Yes","LISTDATE":"2026-08-25T05:00:00","LISTPRICE":250000.0,"LIVINGAREA":980.0,"LONGITUDE":-93.17658,"MODIFICATIONTIMESTAMP":"2026-08-25T20:31:06.615","OFFICE_OFFICENAME":"Leading Edge Realty","PHOTOCOUNT":12,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to 2594 Fairview Ave N, a charming single-level home offering comfortable living spaces, a generous lot, and an inviting setting in the desirable Roseville area. With 3 bedrooms, 1.5 bathrooms, and approximately 1,000 square feet, this home provides a practical layout with plenty of room to make it your own. The full basement adds valuable flexibility for storage, hobbies, recreation, or future living space.\n\nSet on an approximately 0.36-acre lot, the property offers an expansive outdoor footprint that is increasingly hard to find. window conditioning and gas heating provide year-round comfort, while the home's one-level design offers convenient everyday living. The established residential setting combines the appeal of a quiet neighborhood with convenient access to the shopping, dining, parks, recreation, and everyday amenities throughout Roseville and the surrounding Twin Cities area.\n\nWhether you're looking for your first home, a comfortable place to settle in, or an opportunity to personalize a property to suit your style, 2594 Fairview Ave N offers an appealing combination of space, location, and potential. Come see how this inviting property can fit your vision for home.\nSold as-is buyer to verify all information and conditions.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-25T20:19:06.77","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Fairview","STREETNUMBER":"2594","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1956,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-08-25T20:19:06.77","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_4178.JPG\"},{\"Order\":2,\"Remarks\":\"IMG_4195.JPG\"},{\"Order\":3,\"Remarks\":\"IMG_4194.JPG\"},{\"Order\":4,\"Remarks\":\"IMG_4180.JPG\"},{\"Order\":5,\"Remarks\":\"IMG_4181.JPG\"},{\"Order\":6,\"Remarks\":\"IMG_4185.JPG\"},{\"Order\":7,\"Remarks\":\"IMG_4187.JPG\"},{\"Order\":8,\"Remarks\":\"IMG_4189.JPG\"},{\"Order\":9,\"Remarks\":\"IMG_4191.JPG\"},{\"Order\":10,\"Remarks\":\"IMG_4198.JPG\"},{\"Order\":11,\"Remarks\":\"IMG_4200.JPG\"},{\"Order\":12,\"Remarks\":\"IMG_4207.JPG\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7957238","NST_AboveGradeSqFtTotal":"980","AboveGradeFinishedArea":"980","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Unfinished","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"980","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Roseville","NewConstructionYN":"False","Contingency":"None","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","Directions":"County C to Fairview Ave to home","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Steel Siding","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"980","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"0","Heating":"Forced Air","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.019255","NST_LenderOwned":"Yes","Levels":"One","ListPrice":"250000","ListingContractDate":"2026-08-25T05:00:00Z","ListingId":"NST7133291","LivingArea":"980","Longitude":"-93.17658","LotSizeArea":"0.355","LotSizeDimensions":"80x149x94x198","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"980","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-25T15:17:57Z","ParcelNumber":"092923120021","ParkingFeatures":"Asphalt","PhotosCount":"12","PhotosChangeTimestamp":"2026-08-25T20:19:06.77Z","PostalCity":"Saint Paul","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to 2594 Fairview Ave N, a charming single-level home offering comfortable living spaces, a generous lot, and an inviting setting in the desirable Roseville area. With 3 bedrooms, 1.5 bathrooms, and approximately 1,000 square feet, this home provides a practical layout with plenty of room to make it your own. The full basement adds valuable flexibility for storage, hobbies, recreation, or future living space.\n\nSet on an approximately 0.36-acre lot, the property offers an expansive outdoor footprint that is increasingly hard to find. window conditioning and gas heating provide year-round comfort, while the home's one-level design offers convenient everyday living. The established residential setting combines the appeal of a quiet neighborhood with convenient access to the shopping, dining, parks, recreation, and everyday amenities throughout Roseville and the surrounding Twin Cities area.\n\nWhether you're looking for your first home, a comfortable place to settle in, or an opportunity to personalize a property to suit your style, 2594 Fairview Ave N offers an appealing combination of space, location, and potential. Come see how this inviting property can fit your vision for home.\nSold as-is buyer to verify all information and conditions.","PublicSurveyRange":"23","PublicSurveySection":"09","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Fairview","StreetNumber":"2594","StreetNumberNumeric":"2594","StreetSuffix":"Avenue","SubdivisionName":"James Fourth Add","TaxAnnualAmount":"4216","NST_TaxWithAssessments":"4216","TaxYear":"2026","NST_TotalArea":"1960","BuildingAreaTotal":"1960","Township":"Roseville","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1956","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST74985","ListAgentMlsId":"NST496506604","ListOfficeMlsId":"NST26247","ListOfficeName":"Leading Edge Realty","ListOfficeKey":"NST26247","ModificationTimestamp":"2026-08-25T20:31:06.615Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4187.JPG\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/6ff5dfb0-fcf3-4f61-9e2c-9d23d1b3f95a.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.496Z\",\"MediaKey\":\"NST124472724\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4178.JPG\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/a4330491-1913-4680-853e-6b5c1433abd6.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.472Z\",\"MediaKey\":\"NST124472728\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4181.JPG\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/86df2c65-cde3-453d-a352-5e3602091187.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.474Z\",\"MediaKey\":\"NST124472726\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4189.JPG\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/40677635-8ab3-4226-aafe-d8a279d6c043.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.45Z\",\"MediaKey\":\"NST124472723\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4185.JPG\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/3f6f9f4c-7d6c-4b51-bd27-20a6b30aea1d.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.454Z\",\"MediaKey\":\"NST124472725\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4200.JPG\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/65e0b787-7b2f-4cad-8817-670d340d57cc.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.494Z\",\"MediaKey\":\"NST124472718\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4191.JPG\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/2d5478ad-ad93-4835-8405-74b0d7901fb4.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.465Z\",\"MediaKey\":\"NST124472722\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4198.JPG\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/9ae689cd-bb6a-41c3-8418-70e3014e6d93.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.46Z\",\"MediaKey\":\"NST124472719\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4194.JPG\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/5ed0d949-c1e4-48a8-ae86-124536e54d80.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.51Z\",\"MediaKey\":\"NST124472721\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4180.JPG\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/05448e78-7110-4183-82c4-598331d4cc21.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.477Z\",\"MediaKey\":\"NST124472727\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4207.JPG\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/e4e1b59b-0fc3-42b2-85c5-e55731051a10.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.497Z\",\"MediaKey\":\"NST124472717\"},{\"ResourceRecordKey\":\"NST7957238\",\"LongDescription\":\"IMG_4195.JPG\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957238/52af2340-2f4f-42f5-bc71-4a85bdecab5a.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-25T20:18:13.472Z\",\"MediaKey\":\"NST124472720\"}]","Media__ResourceRecordKey":"NST7957238","Media__LongDescription":"IMG_4187.JPG","Media__Order":"7","Media__MediaObjectID":"NST7","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7957238/6ff5dfb0-fcf3-4f61-9e2c-9d23d1b3f95a.jpeg","Media__ImageWidth":"480","Media__ImageHeight":"640","Media__ImageSizeDescription":"480x640","Media__MediaModificationTimestamp":"8/25/2026 8:18:13 PM","Media__MediaKey":"NST124472724","DocumentsChangeTimestamp":"2026-08-25T20:18:07.465Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_4178.JPG\"},{\"Order\":2,\"Remarks\":\"IMG_4195.JPG\"},{\"Order\":3,\"Remarks\":\"IMG_4194.JPG\"},{\"Order\":4,\"Remarks\":\"IMG_4180.JPG\"},{\"Order\":5,\"Remarks\":\"IMG_4181.JPG\"},{\"Order\":6,\"Remarks\":\"IMG_4185.JPG\"},{\"Order\":7,\"Remarks\":\"IMG_4187.JPG\"},{\"Order\":8,\"Remarks\":\"IMG_4189.JPG\"},{\"Order\":9,\"Remarks\":\"IMG_4191.JPG\"},{\"Order\":10,\"Remarks\":\"IMG_4198.JPG\"},{\"Order\":11,\"Remarks\":\"IMG_4200.JPG\"},{\"Order\":12,\"Remarks\":\"IMG_4207.JPG\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}
$MLSDESCRIPTION$
2594 Fairview Avenue N Roseville, MN 55113
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
2594 Fairview Avenue N Roseville, MN 55113
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$