mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About
- Pelican Lake
- Ossawinnamakee Lake
- Horseshoe Lake
- Advanced Search
- Daily Hotsheets
- Buyers
- Sellers
- Estimate Request
- Popular Listings
- Favorite Listings
- Pelican Lakes Association
- Conservation Club
- DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
eXp 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":591896,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7112384","MLSAGENTID":"NST506096042","MLSOFFICEID":"NST25792","ADDRESS":"2800 Hamline Avenue N","ACRES":9.569,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":2.0,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":false,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":147500.0,"LASTPRICEDATE":"2026-07-28T17:01:08.18","LATITUDE":45.026168,"LENDEROWNED":"No","LISTDATE":"2026-07-28T05:00:00","LISTPRICE":147500.0,"LIVINGAREA":907.0,"LONGITUDE":-93.156103,"LOTDESCRIPTION":"Public Transit (w/in 6 blks)","MODIFICATIONTIMESTAMP":"2026-07-29T10:17:11.141","OFFICE_OFFICENAME":"eXp Realty","PHOTOCOUNT":13,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to the Hamline House! Enjoy condo living on the 3rd floor overlooking green space with east and south views. This unit is flooded with natural light, has a deck to enjoy the morning sunshine! The building is getting a refresh so pardon the projects as you look! Beautiful community space that has also been updated. This is a pet-free building. Great place to call home and be near the local colleges, shopping, restaurants, lakes, parks, State Fair shuttles, and more! Love where you live!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Tar/Gravel","SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-28T17:01:08.18","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hamline","STREETNUMBER":"2800","STREETSUFFIX":"Avenue","STYLE":"(CC) Low Rise (3- Levels)","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1969,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-28T16:55:07.411","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Light and bright 3rd floor corner unit with East and South views!\"},{\"Order\":2,\"Remarks\":\"Light and bright living!\"},{\"Order\":3,\"Remarks\":\"View 2 of living space!\"},{\"Order\":4,\"Remarks\":\"Darling kitchen that open to an informal dining and living room\"},{\"Order\":5,\"Remarks\":\"Ample storage, pantry not shown\"},{\"Order\":7,\"Remarks\":\"Bedroom 1 East facing window, double closet not shown\"},{\"Order\":8,\"Remarks\":\"Bedroom 2 South facing window, closet not shown.\"},{\"Order\":9,\"Remarks\":\"Laundry down the hall from unit.\"},{\"Order\":10,\"Remarks\":\"Beautiful UPDATED Community Room, kitchen, fireplace, walks out to large patio. Great space to entertain your friends and family. The pool is currently under construction.\"},{\"Order\":11,\"Remarks\":\"IMG_9843.JPG\"},{\"Order\":12,\"Remarks\":\"IMG_9844.JPG\"},{\"Order\":13,\"Remarks\":\"Front entrance and guest parking\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7937102","NST_AboveGradeSqFtTotal":"907","AboveGradeFinishedArea":"907","AccessibilityFeatures":"Accessible Elevator Installed","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Deck","Appliances":"Dishwasher,Range,Refrigerator,Stainless Steel Appliances","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationAmenities":"Car Wash,Coin-op Laundry Leased,Laundry,Elevator(s),Lobby Entrance,Patio,Security Building","AssociationFee":"0","AttributionContact":"6512079643","NST_AttributionName":"Pamela J. Wilson","Basement":"None","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"174","City":"Roseville","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Wall Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Breakfast Bar,Informal Dining Room","Directions":"Snelling to Cty C E to Hamline, N to building.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"Circuit Breakers","ExteriorFeatures":"Stone","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"907","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","GarageSpaces":"1","Heating":"Boiler","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"False","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.026168","LaundryFeatures":"Common Area,Laundry Room","NST_LenderOwned":"No","Levels":"One","ListPrice":"147500","ListingContractDate":"2026-07-28T05:00:00Z","ListingId":"NST7112384","LivingArea":"907","LockBoxType":"Supra","Longitude":"-93.156103","LotFeatures":"Public Transit (w/in 6 blks)","LotSizeArea":"9.569","LotSizeDimensions":"common","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"907","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-07-28T11:54:42Z","ParcelNumber":"032923420230","ParkingFeatures":"Parking Lot,Shared Garage/Stall,Underground","PhotosCount":"13","PhotosChangeTimestamp":"2026-07-28T16:55:07.411Z","PoolFeatures":"Heated,Indoor,Shared","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) Low Rise (3- Levels)","PropertyType":"Residential","PublicRemarks":"Welcome to the Hamline House! Enjoy condo living on the 3rd floor overlooking green space with east and south views. This unit is flooded with natural light, has a deck to enjoy the morning sunshine! The building is getting a refresh so pardon the projects as you look! Beautiful community space that has also been updated. This is a pet-free building. Great place to call home and be near the local colleges, shopping, restaurants, lakes, parks, State Fair shuttles, and more! Love where you live!","PublicSurveyRange":"23","PublicSurveySection":"03","PublicSurveyTownship":"29","RoadFrontageType":"Paved Streets","Roof":"Tar/Gravel","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","NST_SharedRooms":"Amusement/Party Room,Exercise Room","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Hamline","StreetNumber":"2800","StreetNumberNumeric":"2800","StreetSuffix":"Avenue","SubdivisionName":"Apt Own No41 Hamline House","TaxAnnualAmount":"2190","NST_TaxWithAssessments":"2190","TaxYear":"2026","NST_TotalArea":"907","BuildingAreaTotal":"907","Township":"Roseville","UnitNumber":"347","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1969","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST62671","ListAgentMlsId":"NST506096042","ListOfficeMlsId":"NST25792","ListOfficeName":"eXp Realty","ListOfficeKey":"NST25792","ModificationTimestamp":"2026-07-29T10:17:11.141Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Darling kitchen that open to an informal dining and living room\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/4414284b-79bd-443d-9d8f-e5d6f259811a.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.341Z\",\"MediaKey\":\"NST123874868\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Bedroom 2 South facing window, closet not shown.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/26a2575e-ca38-453f-8ca7-db41cfc8c2eb.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.457Z\",\"MediaKey\":\"NST123874866\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7937102\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/f416e3bc-0e86-4211-904c-e80b8688c062.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.386Z\",\"MediaKey\":\"NST123874865\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Ample storage, pantry not shown\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/786279de-7f49-45c9-b705-d98c1e222454.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1370,\"ImageSizeDescription\":\"2048x1370\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.34Z\",\"MediaKey\":\"NST123874862\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"View 2 of living space!\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/72a9060f-59cb-4128-94f4-1be05958d348.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.339Z\",\"MediaKey\":\"NST123874869\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Laundry down the hall from unit.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/abad6dfb-39bc-4b62-975d-d6245f05044c.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.328Z\",\"MediaKey\":\"NST123874864\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Beautiful UPDATED Community Room, kitchen, fireplace, walks out to large patio. Great space to entertain your friends and family. The pool is currently under construction.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/73912388-5e87-4106-a554-2ffd65a257fd.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.336Z\",\"MediaKey\":\"NST123874863\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Bedroom 1 East facing window, double closet not shown\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/13d8afdc-dc30-4cc0-b457-e6249f866cc3.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.381Z\",\"MediaKey\":\"NST123874867\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Light and bright living!\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/514561aa-34fb-41a3-9e3d-a98cf52f2ecb.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.35Z\",\"MediaKey\":\"NST123874870\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"IMG_9844.JPG\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/d94cfa60-066d-426b-a4d5-eed27c457690.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-28T15:31:09.498Z\",\"MediaKey\":\"NST123874875\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Light and bright 3rd floor corner unit with East and South views!\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/008ed5fc-8423-4eb9-a804-b87b4b16d722.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-28T15:54:08.095Z\",\"MediaKey\":\"NST123874877\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"Front entrance and guest parking\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/169cdff0-34cb-4f58-ba2b-3dffa7a6c484.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-28T16:50:09.418Z\",\"MediaKey\":\"NST123875462\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7937102\",\"LongDescription\":\"IMG_9843.JPG\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7937102/596a16d4-010c-4b8c-bfcd-cea49c068eab.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-07-28T15:31:09.504Z\",\"MediaKey\":\"NST123874876\"}]","Media__Order":"4","Media__MediaObjectID":"NST4","Media__ResourceRecordKey":"NST7937102","Media__LongDescription":"Darling kitchen that open to an informal dining and living room","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7937102/4414284b-79bd-443d-9d8f-e5d6f259811a.jpeg","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"7/28/2026 4:50:09 PM","Media__MediaKey":"NST123874868","DocumentsChangeTimestamp":"2026-07-28T16:55:07.411Z","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Light and bright 3rd floor corner unit with East and South views!\"},{\"Order\":2,\"Remarks\":\"Light and bright living!\"},{\"Order\":3,\"Remarks\":\"View 2 of living space!\"},{\"Order\":4,\"Remarks\":\"Darling kitchen that open to an informal dining and living room\"},{\"Order\":5,\"Remarks\":\"Ample storage, pantry not shown\"},{\"Order\":7,\"Remarks\":\"Bedroom 1 East facing window, double closet not shown\"},{\"Order\":8,\"Remarks\":\"Bedroom 2 South facing window, closet not shown.\"},{\"Order\":9,\"Remarks\":\"Laundry down the hall from unit.\"},{\"Order\":10,\"Remarks\":\"Beautiful UPDATED Community Room, kitchen, fireplace, walks out to large patio. Great space to entertain your friends and family. The pool is currently under construction.\"},{\"Order\":11,\"Remarks\":\"IMG_9843.JPG\"},{\"Order\":12,\"Remarks\":\"IMG_9844.JPG\"},{\"Order\":13,\"Remarks\":\"Front entrance and guest parking\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}