MLS# 7122356
2148 Delaware Avenue Sunfish Lake, MN 55118
Coldwell Banker 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":595962,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7122356","MLSAGENTID":"NST506007229","MLSCOAGENTID":"NST506097529","MLSOFFICEID":"NST8234","ADDRESS":"2148 Delaware Avenue","ACRES":6.65,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":5.0,"BEDROOMS":5.0,"CITY":"Sunfish Lake","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":2995000.0,"LASTPRICEDATE":"2026-08-05T20:15:07.093","LATITUDE":44.876908,"LENDEROWNED":"No","LISTDATE":"2026-08-05T05:00:00","LISTPRICE":2995000.0,"LIVINGAREA":5360.0,"LONGITUDE":-93.105022,"MODIFICATIONTIMESTAMP":"2026-08-05T20:15:07.093","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":18,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"An extraordinary opportunity to build your dream home on 6.5 private acres in the prestigious community\nof Sunfish Lake. Nestled among mature trees, this exceptional homesite offers a rare combination of\nprivacy, natural beauty, and convenience. The property features ideal walkout potential with\npicturesque treeline views, creating the perfect backdrop for seamless indoor-outdoor living. This tobe-built offering showcases a thoughtfully designed custom home by Urban Edge Homes, featuring\nexceptional craftsmanship, timeless design, and luxurious finishes throughout. Buyers can build this\nstunning plan as designed or collaborate with the builder to create a completely custom home tailored\nto their vision and lifestyle. A rare opportunity to create a one-of-a-kind luxury retreat surrounded\nby natural privacy in one of the Twin Cities' most sought-after communities.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"197-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"6514037002","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-05T20:15:07.093","LASTSTATUS":"Active","STREETNAME":"Delaware","STREETNUMBER":"2148","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2027,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-05T20:15:07.093","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Note, this is a model of the to be built home\"},{\"Order\":16,\"Remarks\":\"Lower level\"},{\"Order\":17,\"Remarks\":\"Main level\"},{\"Order\":18,\"Remarks\":\"Upper level\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7946793","NST_AboveGradeSqFtTotal":"3815","AboveGradeFinishedArea":"3815","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Balcony,Ceiling Fan(s),Deck,Exercise Room,French Doors,Hardwood Floors,Kitchen Center Island,Primary Bedroom Walk-In Closet,Natural Woodwork,Patio,Porch,In-Ground Sprinkler,Sun Room,Tile Floors,Vaulted Ceiling(s),Wet Bar,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Cooktop,Dishwasher,Disposal,Double Oven,Dryer,ENERGY STAR Qualified Appliances,Exhaust Fan,Gas Water Heater,Microwave,Refrigerator,Wall Oven,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","AttributionContact":"6122751343","NST_AttributionName":"Michael R. Distad","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Bathroom Ensuite,Full Primary,Private Primary,Main Floor 1/2 Bath,Upper Level 3/4 Bath,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"5","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1660","BelowGradeFinishedArea":"1545","CumulativeDaysOnMarket":"0","City":"Sunfish Lake","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room,Separate/Formal Dining Room","Directions":"From Hwy 62, South on Delaware. Home is on East Side of Delaware before Charlton Road.","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Stone,Cement Board,Wood","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1660","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"1401","NST_GarageDimensions":"45x25","GarageSpaces":"4","Heating":"Forced Air,Fireplace(s)","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.876908","LaundryFeatures":"Laundry Room,Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"2995000","ListingContractDate":"2026-08-05T05:00:00Z","ListingId":"NST7122356","LivingArea":"5360","Longitude":"-93.105022","LotSizeArea":"6.65","LotSizeDimensions":"561x580x205x410x378","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1895","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-05T15:14:23Z","ParcelNumber":"380300053021","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Deck,Front Porch,Patio","PhotosCount":"18","PhotosChangeTimestamp":"2026-08-05T20:15:07.093Z","PostalCity":"Sunfish Lake","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"An extraordinary opportunity to build your dream home on 6.5 private acres in the prestigious community\nof Sunfish Lake. Nestled among mature trees, this exceptional homesite offers a rare combination of\nprivacy, natural beauty, and convenience. The property features ideal walkout potential with\npicturesque treeline views, creating the perfect backdrop for seamless indoor-outdoor living. This tobe-built offering showcases a thoughtfully designed custom home by Urban Edge Homes, featuring\nexceptional craftsmanship, timeless design, and luxurious finishes throughout. Buyers can build this\nstunning plan as designed or collaborate with the builder to create a completely custom home tailored\nto their vision and lifestyle. A rare opportunity to create a one-of-a-kind luxury retreat surrounded\nby natural privacy in one of the Twin Cities' most sought-after communities.","PublicSurveyRange":"22","PublicSurveySection":"30","PublicSurveyTownship":"28","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","NST_SchoolDistrictFullName":"197 - West St. Paul-Mendota Hts.-Eagan","NST_SchoolDistrictNumber":"197","NST_SchoolDistrictPhone":"6514037002","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,4 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Delaware","StreetNumber":"2148","StreetNumberNumeric":"2148","StreetSuffix":"Avenue","TaxAnnualAmount":"11530","NST_TaxWithAssessments":"11530","TaxYear":"2026","NST_TotalArea":"5475","BuildingAreaTotal":"5475","Township":"Sunfish Lake","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2027","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST69573","CoListAgentMlsId":"NST506097529","CoListOfficeName":"Coldwell Banker Realty","ListAgentKey":"NST94781","ListAgentMlsId":"NST506007229","ListOfficeMlsId":"NST8234","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16460","ModificationTimestamp":"2026-08-05T20:15:07.093Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/b6dd391a-7a8e-43cd-ab92-cbfb5495f38f.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.245Z\",\"MediaKey\":\"NST124067618\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/a46e770d-7e47-44e2-9e02-13020ae0b9a9.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.245Z\",\"MediaKey\":\"NST124067610\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/356ccca2-8a0d-4b0a-821e-0fb4a65847af.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.267Z\",\"MediaKey\":\"NST124067611\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/95e77080-a287-49e0-83ec-e52320a296bb.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":650,\"ImageHeight\":1300,\"ImageSizeDescription\":\"650x1300\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.23Z\",\"MediaKey\":\"NST124067613\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/ad1025f5-62eb-4c43-97ee-04427c8abb56.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.26Z\",\"MediaKey\":\"NST124067616\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/a8eb29d4-7193-4907-b3e5-d69774a9eab7.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.255Z\",\"MediaKey\":\"NST124067614\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/ee23547b-f6ff-4bde-b624-2c740620486b.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.23Z\",\"MediaKey\":\"NST124067612\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/b08d3f79-c8c5-4992-bbcd-d6dfe07c0b41.jpeg\",\"LongDescription\":\"Note, this is a model of the to be built home\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T20:04:15.149Z\",\"MediaKey\":\"NST124067539\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/29805cac-3003-4aa8-9212-983f2c2818b8.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1672,\"ImageHeight\":941,\"ImageSizeDescription\":\"1672x941\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.245Z\",\"MediaKey\":\"NST124067599\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/a6d99d01-641e-4a62-871c-871a3f89b72d.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1920,\"ImageHeight\":1080,\"ImageSizeDescription\":\"1920x1080\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.245Z\",\"MediaKey\":\"NST124067595\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/be2a25d2-19c0-4820-aee5-86a5bf1551ad.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.253Z\",\"MediaKey\":\"NST124067619\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/1521cd4a-30b0-42a6-9d0b-ba1dd2af5f39.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.2Z\",\"MediaKey\":\"NST124067617\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/b0a95666-b5d0-4a6c-8a66-91141e014fa2.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.253Z\",\"MediaKey\":\"NST124067615\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/49030835-b036-485a-89af-243c7143ed43.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1386,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1386x2080\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.213Z\",\"MediaKey\":\"NST124067620\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/7f57ea6c-a638-49a9-a5cc-92d686261926.jpeg\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1672,\"ImageHeight\":941,\"ImageSizeDescription\":\"1672x941\",\"MediaModificationTimestamp\":\"2026-08-05T19:20:15.318Z\",\"MediaKey\":\"NST124067601\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/c34ff342-9f6f-4628-b67b-d0f82d359a79.jpeg\",\"LongDescription\":\"Lower level\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":996,\"ImageHeight\":1564,\"ImageSizeDescription\":\"996x1564\",\"MediaModificationTimestamp\":\"2026-08-05T20:04:15.162Z\",\"MediaKey\":\"NST124068027\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/aae5db95-2870-4096-9659-0b6a82966c8b.jpeg\",\"LongDescription\":\"Upper level\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1264,\"ImageHeight\":1282,\"ImageSizeDescription\":\"1264x1282\",\"MediaModificationTimestamp\":\"2026-08-05T20:04:15.243Z\",\"MediaKey\":\"NST124068028\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7946793/88a5f6f3-c4ab-472f-b3fb-dfd9c8b507be.jpeg\",\"LongDescription\":\"Main level\",\"ResourceRecordKey\":\"NST7946793\",\"ImageWidth\":1884,\"ImageHeight\":1562,\"ImageSizeDescription\":\"1884x1562\",\"MediaModificationTimestamp\":\"2026-08-05T20:04:15.21Z\",\"MediaKey\":\"NST124068020\"}]","Media__Order":"7","Media__MediaObjectID":"NST7","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7946793/b6dd391a-7a8e-43cd-ab92-cbfb5495f38f.jpeg","Media__ResourceRecordKey":"NST7946793","Media__ImageWidth":"2080","Media__ImageHeight":"1386","Media__ImageSizeDescription":"2080x1386","Media__MediaModificationTimestamp":"8/5/2026 7:20:15 PM","Media__MediaKey":"NST124067618","DocumentsChangeTimestamp":"2026-08-05T20:15:07.093Z","Rooms":"[{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"16x9\",\"NST_RoomSortOrder\":14,\"RoomType\":\"Bar/Wet Bar Room\",\"RoomKey\":\"NST116538057\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST116538046\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":13,\"RoomType\":\"Exercise Room\",\"RoomKey\":\"NST116538056\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"21x17\",\"NST_RoomSortOrder\":10,\"RoomType\":\"Family Room\",\"RoomKey\":\"NST116538053\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":9,\"RoomType\":\"Bedroom 5\",\"RoomKey\":\"NST116538052\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"21x14\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST116538048\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Bedroom 4\",\"RoomKey\":\"NST116538051\"},{\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"20x19\",\"NST_RoomSortOrder\":11,\"RoomType\":\"Game Room\",\"RoomKey\":\"NST116538054\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"21x15\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Great Room\",\"RoomKey\":\"NST116538044\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"20x12\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST116538045\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x8\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Office\",\"RoomKey\":\"NST116538047\"},{\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x5\",\"NST_RoomSortOrder\":12,\"RoomType\":\"Pantry (Walk-In)\",\"RoomKey\":\"NST116538055\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16x13\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST116538049\"},{\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST116538050\"}]","Rooms__RoomLevel":"Lower","Rooms__RoomDimensions":"16x9","Rooms__NST_RoomSortOrder":"14","Rooms__RoomType":"Bar/Wet Bar Room","Rooms__RoomKey":"NST116538057","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Note, this is a model of the to be built home\"},{\"Order\":16,\"Remarks\":\"Lower level\"},{\"Order\":17,\"Remarks\":\"Main level\"},{\"Order\":18,\"Remarks\":\"Upper level\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}
