$LABEL$$CONTENT$
$DESC$
MLS# 6774447 - 8917 Joliet Avenue N Grant, MN 55082
RE/MAX Results 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. Cummings Janzen Realty, Inc. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Cummings Janzen Realty, Inc., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":1397645,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST6774447","MLSAGENTID":"NST502015375","MLSOFFICEID":"NST5057","ADDRESS":"8917 Joliet Avenue N","ACRES":5.95,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Concrete,Sump Basket,Sump Pump,Walkout","BATHSTOTAL":5.0,"BEDROOMS":5,"CITY":"Grant","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LAKEACRES":37.0,"LAKEDEPTH":"0","LAKEWATERFRONT":"Lake Front","LASTPRICE":6500.0,"LASTPRICEDATE":"2025-08-19T02:05:04.707","LATITUDE":45.076496,"LENDEROWNED":"No","LISTDATE":"2025-08-18T05:00:00","LISTPRICE":6500.0,"LIVINGAREA":4875.0,"LONGITUDE":-92.909086,"LOTDESCRIPTION":"Many Trees","MODIFICATIONTIMESTAMP":"2025-08-19T02:05:04.706","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":17,"POSTALCODE":"55082","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Fully furnished Executive home in coveted Mahtomedi #832 schools! 5BR/5BA/3CAR Executive Rambler – with approximately 4700FSF. 6 acres on Masterman Lake in Grant. Idyllic one owner home lovingly cared for. Stunning layout with nearly 3k FSF on main floor. Large foyer with floor to ceiling LR windows, formal dining, great family space with kitchen, eat-in DR & Family room on main. 1/2 bath, laundry, large entry from the 3 car garage & screen porch. Primary BR has enormous closet, large ceramic bath with 2 sinks and separate tub & shower. \nLL has family room, pool table & bar area. 3 BR, 2 with ensuite baths & another full bath. Large storage room. \nUnique opportunity to rent in this quiet community right between White Bear & Stillwater. Mahtomedi Middle & High School are a quick 5 minutes away.\nAvailable now thru June 15th – (could be shorter or potentially longer if someone needed) Landscaping, Lawn & Trash included. Internet & TV could be left attached for $250 a month. One month security deposit along with first & last months rent up front.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"832-Mahtomedi","SCHOOLDISTRICTPHONE":"651-407-2001","SEWER":"Septic System Compliant - Yes","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-19T02:05:04.707","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Joliet","STREETNUMBER":"8917","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Rent","WATER":"Well","WATERFRONTNAME":"Masterman","WATERFRONTNUM":"82012600","WATERFRONTPRESENT":true,"WATERFRONTVIEW":"Lake Front","YEARBUILT":1998,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-19T02:05:04.706","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"2.JPEG\"},{\"Order\":2,\"Remarks\":\"3.JPEG\"},{\"Order\":3,\"Remarks\":\"4.JPEG\"},{\"Order\":4,\"Remarks\":\"5.JPEG\"},{\"Order\":5,\"Remarks\":\"6.JPEG\"},{\"Order\":6,\"Remarks\":\"7.JPEG\"},{\"Order\":7,\"Remarks\":\"8.JPEG\"},{\"Order\":8,\"Remarks\":\"9.JPEG\"},{\"Order\":9,\"Remarks\":\"10.JPEG\"},{\"Order\":10,\"Remarks\":\"14.JPEG\"},{\"Order\":11,\"Remarks\":\"15.JPEG\"},{\"Order\":12,\"Remarks\":\"16.JPEG\"},{\"Order\":13,\"Remarks\":\"17.JPEG\"},{\"Order\":14,\"Remarks\":\"18.JPEG\"},{\"Order\":15,\"Remarks\":\"19.JPEG\"},{\"Order\":16,\"Remarks\":\"20.JPEG\"},{\"Order\":17,\"Remarks\":\"1.JPEG\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7789978","LotSizeArea":"5.95","NST_AgeOfProperty":"27","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_ApplicationFee":"250.0000","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","AvailabilityDate":"2025-08-20T05:00:00Z","NST_BackgroundCheckReq":"Yes","Basement":"Drain Tiled,Concrete,Sump Basket,Sump Pump,Walkout","BasementYN":"True","NST_BathDesc":"Two Basement Baths,Two Primary Baths,3/4 Basement,Double Sink,Full Primary,Full Basement,Private Primary,Main Floor 1/2 Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"5","BedroomsTotal":"5","City":"Grant","PropertyType":"Residential Lease","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","Directions":"96 to Juliet (s) to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers,200+ Amp Service","ConstructionMaterials":"Stucco","FireplaceFeatures":"Two Sided,Amusement Room,Family Room,Living Room","FireplaceYN":"True","FireplacesTotal":"3","NST_ForeclosureStatus":"No","FoundationArea":"2786","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Furnished","ParkingFeatures":"Attached Garage,Concrete,Heated Garage,Insulated Garage","NST_GarageDoorHeight":"8","AccessibilityFeatures":"Other","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-18T20:55:35Z","NST_InternetOptions":"Cable","NST_LakeAcres":"37","NST_LakeChain":"N","NST_LakeDepth":"0","WaterfrontFeatures":"Lake Front","LandLeaseYN":"False","NST_LastUpdateDate":"2025-08-18","Latitude":"45.076496","NST_LeasePrice":"6500.0000","NST_LenderOwned":"No","ListAgentKey":"NST52224","ListAgentMlsId":"NST502015375","ListingContractDate":"2025-08-18T05:00:00Z","ListOfficeKey":"NST16271","ListOfficeName":"RE/MAX Results","ListOfficeMlsId":"NST5057","LivingArea":"4875","Longitude":"-92.909086","LotFeatures":"Many Trees","LotSizeDimensions":"0x0","LotSizeUnits":"Acres","ListingId":"NST6774447","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","LeaseTerm":"6 Months","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","OwnerPays":"Trash Collection,Water","ParcelNumber":"2203021120002","GarageSpaces":"3","NST_ParkingOpen":"4","NST_PatioPorchType":"Composite Decking,Screened,Side Porch","PhotosCount":"17","PostalCity":"Stillwater","PostalCode":"55082","NST_PrePaidRent":"Yes","NST_PresentUse":"Yearly","PublicRemarks":"Fully furnished Executive home in coveted Mahtomedi #832 schools! 5BR/5BA/3CAR Executive Rambler – with approximately 4700FSF. 6 acres on Masterman Lake in Grant. Idyllic one owner home lovingly cared for. Stunning layout with nearly 3k FSF on main floor. Large foyer with floor to ceiling LR windows, formal dining, great family space with kitchen, eat-in DR & Family room on main. 1/2 bath, laundry, large entry from the 3 car garage & screen porch. Primary BR has enormous closet, large ceramic bath with 2 sinks and separate tub & shower. \nLL has family room, pool table & bar area. 3 BR, 2 with ensuite baths & another full bath. Large storage room. \nUnique opportunity to rent in this quiet community right between White Bear & Stillwater. Mahtomedi Middle & High School are a quick 5 minutes away.\nAvailable now thru June 15th – (could be shorter or potentially longer if someone needed) Landscaping, Lawn & Trash included. Internet & TV could be left attached for $250 a month. One month security deposit along with first & last months rent up front.","PublicSurveyRange":"21","PublicSurveySection":"22","PublicSurveyTownship":"30","ListPrice":"6500","NST_RentalLicenseYN":"No","NST_RoadBetweenWaterfrontAndHomeYN":"No","NST_AboveGradeSqFtTotal":"2786.0000","NST_BelowGradeSqFtTotal":"2786.0000","NST_MainLevelFinishedArea":"2786.0000","BuildingAreaTotal":"5572","HighSchoolDistrict":"Mahtomedi","NST_SchoolDistrictNumber":"832","NST_SchoolDistrictPhone":"651-407-2001","NST_SecurityDeposit":"6500.0000","Sewer":"Septic System Compliant - Yes","NST_SmokingPermitted":"No","AboveGradeFinishedArea":"2786","BelowGradeFinishedArea":"2089","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"N","StreetName":"Joliet","StreetNumber":"8917","StreetNumberNumeric":"8917","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Hiltons Whitetail Ridge","TenantPays":"Cable TV","WaterSource":"Well","WaterfrontYN":"True","WaterBodyName":"Masterman","NST_WaterfrontNum":"82012600","WoodedArea":"5","YearBuilt":"1998","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-08-19T02:05:04.706Z","PhotosChangeTimestamp":"2025-08-19T02:05:04.706Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7789978\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"2.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/1203dc97-705a-4cf3-82f6-44732e6fa8f5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:27.01Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860906\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"3.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/befc8d94-c3ea-4c68-8fa7-be9c302b19bc.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.998Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860907\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"4.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/0111b0aa-9f2c-4e29-906d-94586d199762.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.969Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860908\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"5.JPEG\",\"ImageWidth\":2016,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2016x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/b46307e6-0850-4a05-8625-93a3990a8b01.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.993Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860909\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"6.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/6df8b382-50dd-4c97-9f8a-17b033d875ab.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.995Z\",\"MediaKey\":\"68a3dbab6b1abc0d7386090a\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"7.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/66dd8a6d-5b20-4c90-9734-27e924c6e24f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.914Z\",\"MediaKey\":\"68a3dbab6b1abc0d7386090b\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"8.JPEG\",\"ImageWidth\":1872,\"ImageHeight\":1678,\"ImageSizeDescription\":\"1872x1678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/df286ba0-2656-48a2-8916-29e272217315.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:27.016Z\",\"MediaKey\":\"68a3dbab6b1abc0d7386090c\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"9.JPEG\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/6c80a2e7-3fca-4029-8016-fc6385a78751.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.934Z\",\"MediaKey\":\"68a3dbab6b1abc0d7386090d\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"10.JPEG\",\"ImageWidth\":1662,\"ImageHeight\":1890,\"ImageSizeDescription\":\"1662x1890\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/6aa3abc7-2cd1-4051-a727-da4629da2d55.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.958Z\",\"MediaKey\":\"68a3dbab6b1abc0d7386090e\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"14.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/5cc97196-88df-4c83-9abe-b97ca16e1e32.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.975Z\",\"MediaKey\":\"68a3dbab6b1abc0d7386090f\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"15.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/f68808cc-5e31-434c-bdb7-3b8e728b60d3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.995Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860910\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"16.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/a77c9485-5fec-4236-88db-e1aa86bb432e.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.982Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860911\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"17.JPEG\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/71664c69-3887-4cac-98b3-afe7d244f8a3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.934Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860912\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"18.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/3e77b836-00aa-4b6f-bbbe-00378048ca2a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:27.012Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860913\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"19.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/76d753f2-669e-43a4-aa77-5ecf568fdd73.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.959Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860914\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"20.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/bff3ad9e-00a2-46b2-aded-ecdaa04d9844.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.973Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860915\"},{\"ResourceRecordKey\":\"NST7789978\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"1.JPEG\",\"ImageWidth\":2048,\"ImageHeight\":1536,\"ImageSizeDescription\":\"2048x1536\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7789978/d1bd6410-1c70-4197-bb48-88eeeceee15a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-19T02:04:26.998Z\",\"MediaKey\":\"68a3dbab6b1abc0d73860916\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"2.JPEG\"},{\"Order\":2,\"Remarks\":\"3.JPEG\"},{\"Order\":3,\"Remarks\":\"4.JPEG\"},{\"Order\":4,\"Remarks\":\"5.JPEG\"},{\"Order\":5,\"Remarks\":\"6.JPEG\"},{\"Order\":6,\"Remarks\":\"7.JPEG\"},{\"Order\":7,\"Remarks\":\"8.JPEG\"},{\"Order\":8,\"Remarks\":\"9.JPEG\"},{\"Order\":9,\"Remarks\":\"10.JPEG\"},{\"Order\":10,\"Remarks\":\"14.JPEG\"},{\"Order\":11,\"Remarks\":\"15.JPEG\"},{\"Order\":12,\"Remarks\":\"16.JPEG\"},{\"Order\":13,\"Remarks\":\"17.JPEG\"},{\"Order\":14,\"Remarks\":\"18.JPEG\"},{\"Order\":15,\"Remarks\":\"19.JPEG\"},{\"Order\":16,\"Remarks\":\"20.JPEG\"},{\"Order\":17,\"Remarks\":\"1.JPEG\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}