A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
Bridge Realty, 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. 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":603125,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7131355","MLSAGENTID":"NST506020837","MLSCOAGENTID":"NST502002622","MLSOFFICEID":"NST10982","ADDRESS":"16499 Foliage Avenue W","ACRES":0.0298,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Egress Window(s),Finished,Partially Finished,Storage Space","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Rosemount","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":260000.0,"LASTPRICEDATE":"2026-08-21T15:28:07.24","LATITUDE":44.710837,"LENDEROWNED":"No","LISTDATE":"2026-08-20T05:00:00","LISTPRICE":260000.0,"LIVINGAREA":1995.0,"LONGITUDE":-93.202595,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-08-21T17:12:06.915","OFFICE_OFFICENAME":"Bridge Realty, LLC","PHOTOCOUNT":17,"POSTALCODE":"55068","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"OPPORTUNITY KNOCKS!\nA wonderful place to start, this charming Rosemount rambler checks all the boxes. Featuring four bedrooms, two bathrooms plus many mechanical updates that have already been handled, including a new roof in 2023. The relaxing three-season porch overlooks a nicely manicured lot that features a fenced yard, fun fire pit, and backs directly to Sleepy Hollow Park. Attached two-car garage and so much more. All within the sought-after 196 school district. Your finishing touches will help you build instant equity! \nBE FIRST, THIS ONE WONT LAST!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"196-Rosemount-Apple Valley-Eagan","SCHOOLDISTRICTPHONE":"6514237700","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-21T15:28:07.24","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Foliage","STREETNUMBER":"16499","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1972,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-08-21T16:38:06.791","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"Living Room\"},{\"Order\":3,\"Remarks\":\"Kitchen\"},{\"Order\":4,\"Remarks\":\"Dining Room\"},{\"Order\":5,\"Remarks\":\"Bedroom 1\"},{\"Order\":6,\"Remarks\":\"Bedroom 2\"},{\"Order\":7,\"Remarks\":\"Bedroom 3\"},{\"Order\":8,\"Remarks\":\"Bathroom\"},{\"Order\":9,\"Remarks\":\"Basement\"},{\"Order\":10,\"Remarks\":\"Laundry\"},{\"Order\":11,\"Remarks\":\"Basement Bathroom\"},{\"Order\":12,\"Remarks\":\"Backyard\"},{\"Order\":13,\"Remarks\":\"Basement\"},{\"Order\":14,\"Remarks\":\"Porch\"},{\"Order\":15,\"Remarks\":\"Aerial View\"},{\"Order\":16,\"Remarks\":\"Main Level\"},{\"Order\":17,\"Remarks\":\"Lower Level\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7955506","NST_AboveGradeSqFtTotal":"1150","AboveGradeFinishedArea":"1253","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AssociationFeeIncludes":"Air Conditioning","Basement":"Block,Egress Window(s),Finished,Partially Finished,Storage Space","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1066","BelowGradeFinishedArea":"742","CumulativeDaysOnMarket":"1","City":"Rosemount","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","Directions":"Cedar Ave S- 160th- E- Foliage-So-to home","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-08-21T15:57:07.471Z","DaysOnMarket":"1","ExteriorFeatures":"Vinyl","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1066","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"440","NST_GarageDimensions":"20x22","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Rosemount-Apple Valley-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.710837","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One","ListPrice":"260000","ListingContractDate":"2026-08-20T05:00:00Z","ListingId":"NST7131355","LivingArea":"1995","LockBoxType":"Combo","Longitude":"-93.202595","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"1300","LotSizeDimensions":"79x130x106","LotSizeUnits":"Square Feet","NST_MainLevelFinishedArea":"867","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-21T10:27:11Z","ParcelNumber":"222117207110","ParkingFeatures":"Attached Garage,Concrete","PhotosCount":"17","PhotosChangeTimestamp":"2026-08-21T16:38:06.791Z","PostalCity":"Rosemount","PostalCode":"55068","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"OPPORTUNITY KNOCKS!\nA wonderful place to start, this charming Rosemount rambler checks all the boxes. Featuring four bedrooms, two bathrooms plus many mechanical updates that have already been handled, including a new roof in 2023. The relaxing three-season porch overlooks a nicely manicured lot that features a fenced yard, fun fire pit, and backs directly to Sleepy Hollow Park. Attached two-car garage and so much more. All within the sought-after 196 school district. Your finishing touches will help you build instant equity! \nBE FIRST, THIS ONE WONT LAST!","PublicSurveyRange":"20","PublicSurveySection":"03","PublicSurveyTownship":"114","NST_SchoolDistrictFullName":"196 - Rosemount-Apple Valley-Eagan","NST_SchoolDistrictNumber":"196","NST_SchoolDistrictPhone":"6514237700","Sewer":"City Sewer - In Street","NST_SpecialSearch":"3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"W","StreetName":"Foliage","StreetNumber":"16499","StreetNumberNumeric":"16499","StreetSuffix":"Avenue","SubdivisionName":"Donnays Valley Park 3rd Add","TaxAnnualAmount":"3505","NST_TaxWithAssessments":"3624","TaxYear":"2026","NST_TotalArea":"2216","BuildingAreaTotal":"2216","Township":"Lakeville","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1972","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST59050","CoListAgentMlsId":"NST502002622","CoListOfficeName":"Bridge Realty, LLC","ListAgentKey":"NST519989","ListAgentMlsId":"NST506020837","ListOfficeMlsId":"NST10982","ListOfficeName":"Bridge Realty, LLC","ListOfficeKey":"NST18899","ModificationTimestamp":"2026-08-21T17:12:06.915Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Living Room\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/838818ce-f73d-4124-b7c8-1b7c70e2d9d0.jpeg\",\"ImageWidth\":666,\"ImageHeight\":370,\"ImageSizeDescription\":\"666x370\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.002Z\",\"MediaKey\":\"NST124403381\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Lower Level\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/3c637958-11d5-4288-8f76-0c564d2739b4.jpeg\",\"ImageWidth\":666,\"ImageHeight\":500,\"ImageSizeDescription\":\"666x500\",\"MediaModificationTimestamp\":\"2026-08-21T16:37:09.58Z\",\"MediaKey\":\"NST124403385\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Basement\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/647efe91-e1fb-4d0d-a2c5-c23c42a704ce.jpeg\",\"ImageWidth\":666,\"ImageHeight\":380,\"ImageSizeDescription\":\"666x380\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.012Z\",\"MediaKey\":\"NST124403388\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Bedroom 1\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/5c39f4d6-2307-4076-91f3-fb21683e6ed4.jpeg\",\"ImageWidth\":666,\"ImageHeight\":397,\"ImageSizeDescription\":\"666x397\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.014Z\",\"MediaKey\":\"NST124403379\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Porch\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/dcce411d-2a80-4cb6-a843-ff7946ab5ad8.jpeg\",\"ImageWidth\":666,\"ImageHeight\":414,\"ImageSizeDescription\":\"666x414\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:12.998Z\",\"MediaKey\":\"NST124403389\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Bedroom 3\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/8356eca9-206e-4d8b-9107-b0e3897b8352.jpeg\",\"ImageWidth\":666,\"ImageHeight\":384,\"ImageSizeDescription\":\"666x384\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.014Z\",\"MediaKey\":\"NST124403382\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Basement Bathroom\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/4b57da50-8c85-475b-b717-92320525e724.jpeg\",\"ImageWidth\":666,\"ImageHeight\":410,\"ImageSizeDescription\":\"666x410\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.022Z\",\"MediaKey\":\"NST124403399\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Main Level\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/9671dbb1-edfe-4bb2-bb4e-c2d3285e9d26.jpeg\",\"ImageWidth\":666,\"ImageHeight\":500,\"ImageSizeDescription\":\"666x500\",\"MediaModificationTimestamp\":\"2026-08-21T16:37:09.586Z\",\"MediaKey\":\"NST124403398\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Dining Room\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/b60e4581-6894-45fd-8056-cd5bf678de51.jpeg\",\"ImageWidth\":666,\"ImageHeight\":389,\"ImageSizeDescription\":\"666x389\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.016Z\",\"MediaKey\":\"NST124403380\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Laundry\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/769eae71-1db4-42e2-af16-9bc979c9b6aa.jpeg\",\"ImageWidth\":666,\"ImageHeight\":391,\"ImageSizeDescription\":\"666x391\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.052Z\",\"MediaKey\":\"NST124403396\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Kitchen\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/ea87a60c-8b78-4b24-9301-809c51f9d724.jpeg\",\"ImageWidth\":666,\"ImageHeight\":390,\"ImageSizeDescription\":\"666x390\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.014Z\",\"MediaKey\":\"NST124403390\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Front\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/10391028-0415-4e0d-b042-b2bac4ceb878.jpeg\",\"ImageWidth\":666,\"ImageHeight\":400,\"ImageSizeDescription\":\"666x400\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.002Z\",\"MediaKey\":\"NST124403387\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Aerial View\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/9cb1a0de-0ca5-47a6-b643-c1452901ccca.jpeg\",\"ImageWidth\":666,\"ImageHeight\":500,\"ImageSizeDescription\":\"666x500\",\"MediaModificationTimestamp\":\"2026-08-21T15:49:19.631Z\",\"MediaKey\":\"NST124403378\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Bedroom 2\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/83975834-46a1-4dea-8de0-0792916c3461.jpeg\",\"ImageWidth\":666,\"ImageHeight\":387,\"ImageSizeDescription\":\"666x387\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.027Z\",\"MediaKey\":\"NST124403392\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Bathroom\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/65b8b0fe-1475-4b69-ab8f-d42e5a9ef019.jpeg\",\"ImageWidth\":666,\"ImageHeight\":443,\"ImageSizeDescription\":\"666x443\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.012Z\",\"MediaKey\":\"NST124403386\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Basement\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/4db78561-f34b-477e-9298-df3b8fa9fbc5.jpeg\",\"ImageWidth\":666,\"ImageHeight\":376,\"ImageSizeDescription\":\"666x376\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.014Z\",\"MediaKey\":\"NST124403394\"},{\"ResourceRecordKey\":\"NST7955506\",\"LongDescription\":\"Backyard\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7955506/d61b2434-6145-4dcd-b0af-dd2ab8e1a96c.jpeg\",\"ImageWidth\":666,\"ImageHeight\":392,\"ImageSizeDescription\":\"666x392\",\"MediaModificationTimestamp\":\"2026-08-21T15:50:13.014Z\",\"MediaKey\":\"NST124403391\"}]","Media__ResourceRecordKey":"NST7955506","Media__LongDescription":"Living Room","Media__Order":"2","Media__MediaObjectID":"NST2","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7955506/838818ce-f73d-4124-b7c8-1b7c70e2d9d0.jpeg","Media__ImageWidth":"666","Media__ImageHeight":"370","Media__ImageSizeDescription":"666x370","Media__MediaModificationTimestamp":"8/21/2026 3:50:13 PM","Media__MediaKey":"NST124403381","Rooms":"[{\"RoomType\":\"Bathroom\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x8\",\"RoomKey\":\"NST116593299\"},{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8x12\",\"RoomKey\":\"NST116593297\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST116593293\"},{\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x11\",\"RoomKey\":\"NST116593300\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x9\",\"RoomKey\":\"NST116593296\"},{\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"21x11\",\"RoomKey\":\"NST116593298\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x11\",\"RoomKey\":\"NST116593294\"},{\"RoomType\":\"Sitting Room\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"26x11\",\"RoomKey\":\"NST116593301\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x11\",\"RoomKey\":\"NST116593295\"}]","Rooms__RoomType":"Bathroom","Rooms__NST_RoomSortOrder":"7","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"7x8","Rooms__RoomKey":"NST116593299","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front\"},{\"Order\":2,\"Remarks\":\"Living Room\"},{\"Order\":3,\"Remarks\":\"Kitchen\"},{\"Order\":4,\"Remarks\":\"Dining Room\"},{\"Order\":5,\"Remarks\":\"Bedroom 1\"},{\"Order\":6,\"Remarks\":\"Bedroom 2\"},{\"Order\":7,\"Remarks\":\"Bedroom 3\"},{\"Order\":8,\"Remarks\":\"Bathroom\"},{\"Order\":9,\"Remarks\":\"Basement\"},{\"Order\":10,\"Remarks\":\"Laundry\"},{\"Order\":11,\"Remarks\":\"Basement Bathroom\"},{\"Order\":12,\"Remarks\":\"Backyard\"},{\"Order\":13,\"Remarks\":\"Basement\"},{\"Order\":14,\"Remarks\":\"Porch\"},{\"Order\":15,\"Remarks\":\"Aerial View\"},{\"Order\":16,\"Remarks\":\"Main Level\"},{\"Order\":17,\"Remarks\":\"Lower Level\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}