A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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":""}