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$
Ashworth Real Estate 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":576235,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7097348","MLSAGENTID":"NST502045564","MLSOFFICEID":"NST251939","ADDRESS":"15725 Sycamore Street NW","ACRES":2.18,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Block","BATHSTOTAL":3.0,"BEDROOMS":5.0,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":3400.0,"LASTPRICEDATE":"2026-06-23T00:32:06.6","LATITUDE":45.255524,"LENDEROWNED":"No","LISTDATE":"2026-06-22T05:00:00","LISTPRICE":3400.0,"LIVINGAREA":2562.0,"LONGITUDE":-93.288339,"MODIFICATIONTIMESTAMP":"2026-06-23T01:05:06.432","OFFICE_OFFICENAME":"Ashworth Real Estate","PHOTOCOUNT":12,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"5 bedroom, 3 bath on over 2 acres. Very private but close to highways, and shopping and restaurants.\nOpen concept Kitchen/living room is great for entertaining. Large Primary Bedroom with 3/4 bath. 2 other\nbedrooms on main level. Lower level has 2 more bedrooms, full bath and a kitchen is perfect Mother In Law\nSuite. If you are looking for privacy this is it. Right in the middle of city but you would never know\nit.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-06-23T00:32:06.6","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Sycamore","STREETNUMBER":"15725","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1978,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-23T01:05:06.432","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Kitchen with Granite Counters\"},{\"Order\":2,\"Remarks\":\"Dining Room\"},{\"Order\":3,\"Remarks\":\"Living Room off Kitchen and Dining\"},{\"Order\":4,\"Remarks\":\"Main Floor Bath\"},{\"Order\":5,\"Remarks\":\"Primary Bedroom\"},{\"Order\":6,\"Remarks\":\"Primary Bath\"},{\"Order\":7,\"Remarks\":\"2nd Kitchen\"},{\"Order\":8,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":9,\"Remarks\":\"Bedroom\"},{\"Order\":10,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":11,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":12,\"Remarks\":\"Lower Level Full Bath\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7922978","NST_AboveGradeSqFtTotal":"1456","AboveGradeFinishedArea":"1456","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"Yes","NST_AmenitiesUnit":"Deck","NST_ApplicationFee":"50","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-07-01T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Block","BasementYN":"True","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1106","BelowGradeFinishedArea":"1106","CumulativeDaysOnMarket":"0","City":"Andover","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","Directions":"Hansen Blvd. N. to Crosstown(18)or 161st. to Sycamore L to home --behind trees on right-3rd lot N.","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stucco","FireplaceYN":"True","FireplacesTotal":"2","NST_ForSaleMLNumber":"7073006","FoundationArea":"1456","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","NST_GarageSquareFeet":"600","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.255524","LaundryFeatures":"Lower Level","NST_LeasePrice":"3400","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListingContractDate":"2026-06-22T05:00:00Z","ListingId":"NST7097348","LivingArea":"2562","Longitude":"-93.288339","LotSizeArea":"2.18","LotSizeDimensions":"185x359","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1456","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-06-22T19:26:29Z","OwnerPays":"None","ParcelNumber":"TBD","ParkingFeatures":"Attached Garage","PhotosCount":"12","PhotosChangeTimestamp":"2026-06-23T01:05:06.432Z","PostalCity":"Andover","PostalCode":"55304","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","PublicRemarks":"5 bedroom, 3 bath on over 2 acres. Very private but close to highways, and shopping and restaurants.\nOpen concept Kitchen/living room is great for entertaining. Large Primary Bedroom with 3/4 bath. 2 other\nbedrooms on main level. Lower level has 2 more bedrooms, full bath and a kitchen is perfect Mother In Law\nSuite. If you are looking for privacy this is it. Right in the middle of city but you would never know\nit.","PublicSurveyRange":"24","PublicSurveySection":"14","PublicSurveyTownship":"32","NST_RentSpreeURL":"https://www.rentspree.com/apply/6a39a7b267e6fa7cff04634c?utm_source=northstarmls&utm_medium=applylink&utm_campaign=partner_integration","NST_RentSpreeYN":"Y","NST_RentalLicenseType":"Other","NST_RentalLicenseYN":"Y","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","NST_SecurityDeposit":"3400","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"Sycamore","StreetNumber":"15725","StreetNumberNumeric":"15725","StreetSuffix":"Street","SubdivisionName":"Cobbs Add To North","TenantPays":"All Utilities","NST_TotalArea":"2562","BuildingAreaTotal":"2562","Township":"Andover","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1978","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST104892","ListAgentMlsId":"NST502045564","ListOfficeMlsId":"NST251939","ListOfficeName":"Ashworth Real Estate","ListOfficeKey":"NST1000694","ModificationTimestamp":"2026-06-23T01:05:06.432Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/330f52b1-fe19-4e97-8b90-d3dc600138f6.jpeg\",\"LongDescription\":\"Kitchen with Granite Counters\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T00:31:07.853Z\",\"MediaKey\":\"NST123137553\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/6498474f-cd2a-42b7-804a-7d829ba97c66.jpeg\",\"LongDescription\":\"Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.354Z\",\"MediaKey\":\"NST123137596\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/1e548070-d635-41e8-bdaa-5760870cf910.jpeg\",\"LongDescription\":\"Lower Level Full Bath\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.344Z\",\"MediaKey\":\"NST123137606\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/922214ad-5730-4e02-83c4-2fbe7d9143af.jpeg\",\"LongDescription\":\"Lower Level Family Room\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.359Z\",\"MediaKey\":\"NST123137597\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/a37400c9-9aba-42b0-a878-5274fb3e078f.jpeg\",\"LongDescription\":\"Primary Bath\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.359Z\",\"MediaKey\":\"NST123137555\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/13938b91-fa51-4e29-82e5-652eedbc2fc1.jpeg\",\"LongDescription\":\"Main Floor Bath\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.368Z\",\"MediaKey\":\"NST123137556\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/763599aa-42e1-4c08-a865-479467242be7.jpeg\",\"LongDescription\":\"Lower Level Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.424Z\",\"MediaKey\":\"NST123137594\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/564b55ec-0d88-488a-b4a0-46f40aa7a7c1.jpeg\",\"LongDescription\":\"Dining Room\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T00:31:07.765Z\",\"MediaKey\":\"NST123137607\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/4ab223fa-b8cc-4318-b854-6b6df332ba82.jpeg\",\"LongDescription\":\"2nd Kitchen\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.36Z\",\"MediaKey\":\"NST123137598\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/04ff975d-9ac3-43ef-b35e-352d5a16b716.jpeg\",\"LongDescription\":\"Primary Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.383Z\",\"MediaKey\":\"NST123137604\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/3053edfe-2316-4a07-8060-72307a2076f8.jpeg\",\"LongDescription\":\"Living Room off Kitchen and Dining\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T00:31:07.877Z\",\"MediaKey\":\"NST123137600\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7922978/14348f0b-ccbc-4196-be8a-bd215c6c5838.jpeg\",\"LongDescription\":\"Lower Level Bedroom\",\"ResourceRecordKey\":\"NST7922978\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-06-23T01:04:06.484Z\",\"MediaKey\":\"NST123137595\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7922978/330f52b1-fe19-4e97-8b90-d3dc600138f6.jpeg","Media__LongDescription":"Kitchen with Granite Counters","Media__ResourceRecordKey":"NST7922978","Media__ImageWidth":"2080","Media__ImageHeight":"1566","Media__ImageSizeDescription":"2080x1566","Media__MediaModificationTimestamp":"6/23/2026 12:31:07 AM","Media__MediaKey":"NST123137553","DocumentsChangeTimestamp":"2026-06-23T00:27:06.653Z","Rooms":"[{\"RoomKey\":\"NST116382211\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382212\",\"RoomDimensions\":\"13x16\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382232\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116382215\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382231\",\"RoomDimensions\":\"12x14\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116382213\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382214\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Kitchen- 2nd\",\"RoomLevel\":\"Lower\"},{\"RoomKey\":\"NST116382210\",\"RoomDimensions\":\"15x20\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382216\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\"},{\"RoomKey\":\"NST116382230\",\"RoomDimensions\":\"12x15\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\"}]","Rooms__RoomKey":"NST116382211","Rooms__RoomDimensions":"12x12","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Kitchen with Granite Counters\"},{\"Order\":2,\"Remarks\":\"Dining Room\"},{\"Order\":3,\"Remarks\":\"Living Room off Kitchen and Dining\"},{\"Order\":4,\"Remarks\":\"Main Floor Bath\"},{\"Order\":5,\"Remarks\":\"Primary Bedroom\"},{\"Order\":6,\"Remarks\":\"Primary Bath\"},{\"Order\":7,\"Remarks\":\"2nd Kitchen\"},{\"Order\":8,\"Remarks\":\"Lower Level Family Room\"},{\"Order\":9,\"Remarks\":\"Bedroom\"},{\"Order\":10,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":11,\"Remarks\":\"Lower Level Bedroom\"},{\"Order\":12,\"Remarks\":\"Lower Level Full Bath\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}
$MLSDESCRIPTION$
15725 Sycamore Street NW Andover, MN 55304
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
15725 Sycamore Street NW Andover, MN 55304
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$