$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Property Solution LLC 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. Heartland Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate, 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. Heartland Real Estate is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":605691,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7134203","MLSAGENTID":"NST502045336","MLSOFFICEID":"NST27358","ADDRESS":"823 Juno Avenue","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Partial,Unfinished","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":365000.0,"LASTPRICEDATE":"2026-08-27T21:53:07.283","LATITUDE":44.926153,"LENDEROWNED":"No","LISTDATE":"2026-08-27T05:00:00","LISTPRICE":365000.0,"LIVINGAREA":1470.0,"LONGITUDE":-93.134678,"MODIFICATIONTIMESTAMP":"2026-08-28T02:23:06.373","NEIGHBORHOOD":"103","OFFICE_OFFICENAME":"Property Solution LLC","PHOTOCOUNT":6,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Spacious 4 bedroom 2 bathroom with hard wood floors, detached 2 car garage. Enjoy a charming enclosed four season porch which provides additional space for family gatherings. The back yard is fully fenced to give you privacy and space to relax under the mature tree. Home features new refrigerator, furnace, A/C, water heater and carpet upstairs.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-27T21:53:07.283","LASTSTATUS":"Active","STREETNAME":"Juno","STREETNUMBER":"823","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1883,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-28T02:23:06.373","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_1188.jpg\"},{\"Order\":2,\"Remarks\":\"Back yard.jpg\"},{\"Order\":3,\"Remarks\":\"3rd Bedroom.jpg\"},{\"Order\":4,\"Remarks\":\"4th Bedroom 2.jpg\"},{\"Order\":5,\"Remarks\":\"4th Bedroom.jpg\"},{\"Order\":6,\"Remarks\":\"Front Entry.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6","SOURCE":"MG_NST"}
{"ListingKey":"NST7957984","NST_AboveGradeSqFtTotal":"1470","AboveGradeFinishedArea":"1470","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Hardwood Floors,Porch,Washer/Dryer Hookup","Appliances":"Dishwasher,Dryer,Freezer,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Partial,Unfinished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"735","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Saint Paul","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Off Victoria street, take left on Juno to property on left.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-08-27T21:53:07.284Z","DaysOnMarket":"0","Electric":"100 Amp Service","ExteriorFeatures":"Vinyl","Fencing":"Full,Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"735","FoundationDetails":"Block,Stone","NST_FoundationDimensions":"35x21","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"624","NST_GarageDimensions":"26x24","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.926153","NST_LenderOwned":"No","Levels":"Two","ListPrice":"365000","ListingContractDate":"2026-08-27T05:00:00Z","ListingId":"NST7134203","LivingArea":"1470","Longitude":"-93.134678","LotSizeArea":"0.11","LotSizeDimensions":"40x120","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"735","NST_ManufacturedHome":"N","NST_NeighborhoodName":"West Seventh","NST_NeighborhoodNumber":"103","OriginalEntryTimestamp":"2026-08-27T16:48:26Z","ParcelNumber":"112823420039","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Enclosed,Front Porch","PhotosCount":"6","PhotosChangeTimestamp":"2026-08-28T02:23:06.373Z","PostalCity":"Saint Paul","PostalCode":"55102","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Spacious 4 bedroom 2 bathroom with hard wood floors, detached 2 car garage. Enjoy a charming enclosed four season porch which provides additional space for family gatherings. The back yard is fully fenced to give you privacy and space to relax under the mature tree. Home features new refrigerator, furnace, A/C, water heater and carpet upstairs.","PublicSurveyRange":"23","PublicSurveySection":"11","PublicSurveyTownship":"28","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Juno","StreetNumber":"823","StreetNumberNumeric":"823","StreetSuffix":"Avenue","SubdivisionName":"Clarkes Add","TaxAnnualAmount":"4024","NST_TaxWithAssessments":"4024","TaxYear":"2026","NST_TotalArea":"2205","BuildingAreaTotal":"2205","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1883","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST104373","ListAgentMlsId":"NST502045336","ListOfficeMlsId":"NST27358","ListOfficeName":"Property Solution LLC","ListOfficeKey":"NST27358","ModificationTimestamp":"2026-08-28T02:23:06.373Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7957984\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"4th Bedroom 2.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957984/9e4aa4cd-b579-4691-9323-05d6130a4c43.jpeg\",\"ImageWidth\":1802,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1802x2080\",\"MediaModificationTimestamp\":\"2026-08-28T02:23:05.449Z\",\"MediaKey\":\"NST124530328\"},{\"ResourceRecordKey\":\"NST7957984\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"Front Entry.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957984/d705279c-5296-4808-9dc2-2765bd07d483.jpeg\",\"ImageWidth\":1819,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1819x2080\",\"MediaModificationTimestamp\":\"2026-08-28T02:23:05.465Z\",\"MediaKey\":\"NST124530325\"},{\"ResourceRecordKey\":\"NST7957984\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_1188.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957984/4ed7612b-a844-4c55-96f7-0b74f8b412d8.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1528,\"ImageSizeDescription\":\"2080x1528\",\"MediaModificationTimestamp\":\"2026-08-27T22:13:05.22Z\",\"MediaKey\":\"NST124527297\"},{\"ResourceRecordKey\":\"NST7957984\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"3rd Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957984/8e89eb41-0916-467b-91f4-157907d5e0b2.jpeg\",\"ImageWidth\":1882,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1882x2080\",\"MediaModificationTimestamp\":\"2026-08-28T02:23:05.506Z\",\"MediaKey\":\"NST124530329\"},{\"ResourceRecordKey\":\"NST7957984\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"4th Bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957984/fb967504-fb4e-46a2-8a49-6ac2ebf25da3.jpeg\",\"ImageWidth\":1859,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1859x2080\",\"MediaModificationTimestamp\":\"2026-08-28T02:23:05.532Z\",\"MediaKey\":\"NST124530327\"},{\"ResourceRecordKey\":\"NST7957984\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Back yard.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7957984/9ec09029-a736-48f6-a025-31fa2e341d9c.jpeg\",\"ImageWidth\":1657,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1657x2080\",\"MediaModificationTimestamp\":\"2026-08-28T02:23:05.55Z\",\"MediaKey\":\"NST124530326\"}]","Media__ResourceRecordKey":"NST7957984","Media__Order":"4","Media__MediaObjectID":"NST4","Media__LongDescription":"4th Bedroom 2.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7957984/9e4aa4cd-b579-4691-9323-05d6130a4c43.jpeg","Media__ImageWidth":"1802","Media__ImageHeight":"2080","Media__ImageSizeDescription":"1802x2080","Media__MediaModificationTimestamp":"8/28/2026 2:23:05 AM","Media__MediaKey":"NST124530328","Rooms":"[{\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST116611056\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\"},{\"RoomDimensions\":\"15x10\",\"RoomKey\":\"NST116611058\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\"},{\"RoomDimensions\":\"12x8\",\"RoomKey\":\"NST116611061\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 4\"},{\"RoomDimensions\":\"21x15\",\"RoomKey\":\"NST116611057\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\"},{\"RoomDimensions\":\"13x11\",\"RoomKey\":\"NST116611055\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\"},{\"RoomDimensions\":\"13x8\",\"RoomKey\":\"NST116611059\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\"},{\"RoomDimensions\":\"13x8\",\"RoomKey\":\"NST116611060\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomDimensions":"13x11","Rooms__RoomKey":"NST116611056","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_1188.jpg\"},{\"Order\":2,\"Remarks\":\"Back yard.jpg\"},{\"Order\":3,\"Remarks\":\"3rd Bedroom.jpg\"},{\"Order\":4,\"Remarks\":\"4th Bedroom 2.jpg\"},{\"Order\":5,\"Remarks\":\"4th Bedroom.jpg\"},{\"Order\":6,\"Remarks\":\"Front Entry.jpg\"}]","PhotoOrder":"1,2,3,4,5,6","CustomVTourURL":""}
Box 152 Pine River, MN 56474
Doug Zaske, Owner/Broker
Office: 218.587.4424
Cell: 218.820.8688