MLS# 7126836
15623 Sycamore Street NW Andover, MN 55304
Keller Williams Classic Realty is the brokerage office representing the seller for this listing.
Copyright 2026, 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. Jim Christensen is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Jim Christensen, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
$LABEL$
$CONTENT$
$DESC$
{"Id":600504,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7126836","MLSAGENTID":"NST502018244","MLSCOAGENTID":"NST506008857","MLSOFFICEID":"NST1865","ADDRESS":"15623 Sycamore Street NW","ACRES":0.74,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Full,Sump Basket,Unfinished,Walkout","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Andover","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":799900.0,"LASTPRICEDATE":"2026-08-15T00:37:06.073","LATITUDE":45.25371518,"LENDEROWNED":"No","LISTDATE":"2026-08-14T05:00:00","LISTPRICE":799900.0,"LIVINGAREA":2967.0,"LONGITUDE":-93.28771816,"MODIFICATIONTIMESTAMP":"2026-08-15T10:20:11.871","OFFICE_OFFICENAME":"Keller Williams Classic Realty","PHOTOCOUNT":7,"POSTALCODE":"55304","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to Boulder Prairie Estates! Andover's newest neighborhood. Where your future dream home awaits in sought-afterAndover! This new construction home will feature 4 bedrooms, 3 bathrooms, and an open-concept living and dining area—perfect for modern living. More lots & plans to choose to from!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-15T00:37:06.073","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Sycamore","STREETNUMBER":"15623","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-15T00:37:06.074","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Norway E.png\"},{\"Order\":2,\"Remarks\":\"Norway LL1.png\"},{\"Order\":3,\"Remarks\":\"Norway LL2.png\"},{\"Order\":4,\"Remarks\":\"Norway ML1.png\"},{\"Order\":5,\"Remarks\":\"Norway ML2.png\"},{\"Order\":6,\"Remarks\":\"Norway UL1.png\"},{\"Order\":7,\"Remarks\":\"Norway UL2.png\"}]","PHOTOORDER":"1,2,3,4,5,6,7","SOURCE":"MG_NST"}
{"ListingKey":"NST7950643","NST_AboveGradeSqFtTotal":"2967","AboveGradeFinishedArea":"2967","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Dishwasher,Disposal,Humidifier,Gas Water Heater,Microwave,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Daylight/Lookout Windows,Full,Sump Basket,Unfinished,Walkout","BasementYN":"True","NST_BathDesc":"Full Primary,Private Primary,Main Floor 1/2 Bath,Rough In,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1352","BelowGradeFinishedArea":"0","NST_BuilderLicense":"356604","BuilderName":"SHARPER HOMES INC","CumulativeDaysOnMarket":"0","City":"Andover","NST_CommunityName":"Boulder Prairie Estates","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Yes","NST_ListPriceHigh":"1000000","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Hwy 10 to Hanson Blvd, North to Crosstown Blvd, east to Sycamore, South to home on left.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"200+ Amp Service","ExteriorFeatures":"Stone,Cement Board,Vinyl","FireplaceFeatures":"Gas","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1352","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"1008","NST_GarageDimensions":"42x24","GarageSpaces":"4","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.2537151768","LaundryFeatures":"Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"799900","ListingContractDate":"2026-08-14T05:00:00Z","ListingId":"NST7126836","LivingArea":"2967","Longitude":"-93.2877181638","LotSizeArea":"0.74","LotSizeDimensions":"74x154x46x59x209x114x131","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1352","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-14T19:35:29Z","ParcelNumber":"233224110049","ParkingFeatures":"Attached Garage,Asphalt","PhotosCount":"7","PhotosChangeTimestamp":"2026-08-15T00:37:06.074Z","PostalCity":"Andover","PostalCode":"55304","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to Boulder Prairie Estates! Andover's newest neighborhood. Where your future dream home awaits in sought-afterAndover! This new construction home will feature 4 bedrooms, 3 bathrooms, and an open-concept living and dining area—perfect for modern living. More lots & plans to choose to from!","NST_SchoolDistrictFullName":"11 - Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"7635061000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,4 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"Sycamore","StreetNumber":"15623","StreetNumberNumeric":"15623","StreetSuffix":"Street","TaxAnnualAmount":"0","NST_TaxWithAssessments":"0","TaxYear":"2026","NST_TotalArea":"4319","BuildingAreaTotal":"4319","Township":"Andover","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST98256","CoListAgentMlsId":"NST506008857","CoListOfficeName":"Keller Williams Classic Realty","ListAgentKey":"NST49646","ListAgentMlsId":"NST502018244","ListOfficeMlsId":"NST1865","ListOfficeName":"Keller Williams Classic Realty","ListOfficeKey":"NST14003","ModificationTimestamp":"2026-08-15T10:20:11.871Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7950643\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/8f3e023d-40af-4469-a9ff-e7ea1edcbc68.jpeg\",\"LongDescription\":\"Norway LL2.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.093Z\",\"MediaKey\":\"NST124254133\"},{\"ResourceRecordKey\":\"NST7950643\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/d24ba1e2-88d5-401d-be68-0721fc80ea20.jpeg\",\"LongDescription\":\"Norway LL1.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.116Z\",\"MediaKey\":\"NST124254134\"},{\"ResourceRecordKey\":\"NST7950643\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/89757d20-80f6-4653-ad28-193be7e32b30.jpeg\",\"LongDescription\":\"Norway ML2.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.084Z\",\"MediaKey\":\"NST124254131\"},{\"ResourceRecordKey\":\"NST7950643\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/c6de677c-1c5b-4377-b601-57ae2962fd43.jpeg\",\"LongDescription\":\"Norway UL2.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.094Z\",\"MediaKey\":\"NST124254129\"},{\"ResourceRecordKey\":\"NST7950643\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/6d0a396b-3ea8-4539-b052-3e497184ede8.jpeg\",\"LongDescription\":\"Norway ML1.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.179Z\",\"MediaKey\":\"NST124254132\"},{\"ResourceRecordKey\":\"NST7950643\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/48dd1dec-3968-40e8-b0ff-04cfee4492f5.jpeg\",\"LongDescription\":\"Norway E.png\",\"ImageWidth\":1920,\"ImageHeight\":1080,\"ImageSizeDescription\":\"1920x1080\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.167Z\",\"MediaKey\":\"NST124254135\"},{\"ResourceRecordKey\":\"NST7950643\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950643/426918df-9aa2-46a1-bce8-43662e51e21f.jpeg\",\"LongDescription\":\"Norway UL1.png\",\"ImageWidth\":1600,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1600x1200\",\"MediaModificationTimestamp\":\"2026-08-15T00:36:15.149Z\",\"MediaKey\":\"NST124254130\"}]","Media__ResourceRecordKey":"NST7950643","Media__Order":"3","Media__MediaObjectID":"NST3","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7950643/8f3e023d-40af-4469-a9ff-e7ea1edcbc68.jpeg","Media__LongDescription":"Norway LL2.png","Media__ImageWidth":"1600","Media__ImageHeight":"1200","Media__ImageSizeDescription":"1600x1200","Media__MediaModificationTimestamp":"8/15/2026 12:36:15 AM","Media__MediaKey":"NST124254133","DocumentsChangeTimestamp":"2026-08-15T00:37:06.074Z","Rooms":"[{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"RoomKey\":\"NST116565674\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16x15\",\"RoomKey\":\"NST116565676\"},{\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"RoomKey\":\"NST116565679\"},{\"RoomType\":\"Great Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x16\",\"RoomKey\":\"NST116565672\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"RoomKey\":\"NST116565673\"},{\"RoomType\":\"Loft\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x6\",\"RoomKey\":\"NST116565680\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST116565677\"},{\"RoomType\":\"Sun Room\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"RoomKey\":\"NST116565675\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"RoomKey\":\"NST116565678\"}]","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"14x12","Rooms__RoomKey":"NST116565674","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Norway E.png\"},{\"Order\":2,\"Remarks\":\"Norway LL1.png\"},{\"Order\":3,\"Remarks\":\"Norway LL2.png\"},{\"Order\":4,\"Remarks\":\"Norway ML1.png\"},{\"Order\":5,\"Remarks\":\"Norway ML2.png\"},{\"Order\":6,\"Remarks\":\"Norway UL1.png\"},{\"Order\":7,\"Remarks\":\"Norway UL2.png\"}]","PhotoOrder":"1,2,3,4,5,6,7","CustomVTourURL":""}
