A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
Checkmark Properties, 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":1352229,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6728955","MLSAGENTID":"NST502047447","MLSOFFICEID":"NST251770","ADDRESS":"23615 Underclift Street NW","ACRES":0.29,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Unfinished,Walkout","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Saint Francis","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":524900.0,"LASTPRICEDATE":"2025-05-29T17:41:03.473","LATITUDE":45.397982,"LENDEROWNED":"No","LISTDATE":"2025-05-29T05:00:00","LISTPRICE":524900.0,"LIVINGAREA":2212.0,"LONGITUDE":-93.357878,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-05-30T10:08:09.429","OFFICE_OFFICENAME":"Checkmark Properties, LLC.","PHOTOCOUNT":15,"POSTALCODE":"55070","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"***Assumable FHA Mortgage at 3.25%***Fiber Internet*** Two story beautiful open concept home featuring 4 bedrooms on one floor with laundry, 3 bathrooms, main flex room office, corner pantry, granite countertops, stainless appliances, main bedroom features dual walk-in closets, private master bath with ceramic tile shower & glass door, dual sink. Unfinished walkout basement for future expansion! Backs up to city park!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"15-St. Francis","SCHOOLDISTRICTPHONE":"763-753-7040","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-05-29T17:41:03.473","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Underclift","STREETNUMBER":"23615","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2021,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-05-29T17:41:03.473","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1-print-DSC02834.jpg\"},{\"Order\":2,\"Remarks\":\"13-print-DSC02729.jpg\"},{\"Order\":3,\"Remarks\":\"12-print-DSC02719.jpg\"},{\"Order\":4,\"Remarks\":\"15-print-DSC02739.jpg\"},{\"Order\":5,\"Remarks\":\"11-print-DSC02709.jpg\"},{\"Order\":6,\"Remarks\":\"9-print-DSC02699.jpg\"},{\"Order\":7,\"Remarks\":\"22-print-DSC02799.jpg\"},{\"Order\":8,\"Remarks\":\"17-print-DSC02759.jpg\"},{\"Order\":9,\"Remarks\":\"16-print-DSC02744.jpg\"},{\"Order\":10,\"Remarks\":\"18-print-DSC02764.jpg\"},{\"Order\":11,\"Remarks\":\"20-print-DSC02774.jpg\"},{\"Order\":12,\"Remarks\":\"21-print-DSC02779.jpg\"},{\"Order\":13,\"Remarks\":\"25-print-DSC02814.jpg\"},{\"Order\":14,\"Remarks\":\"3-print-DSC02849.jpg\"},{\"Order\":15,\"Remarks\":\"4-print-DSC02854.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7750368","LotSizeArea":"0.29","NST_AgeOfProperty":"4","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"French Doors,Kitchen Center Island,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Dryer,Range,Stainless Steel Appliances,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Daylight/Lookout Windows,Unfinished,Walkout","BasementYN":"True","NST_BathDesc":"Bathroom Ensuite,Private Primary,Walk-In Shower Stall","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","CarportSpaces":"0","City":"Saint Francis","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Concrete,Frame,Insulating Concrete Forms","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Informal Dining Room","Directions":"North on Rum River BLVD, West on 235th Ave NW, West 235th LN, Right on Underclift","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"200+ Amp Service","ConstructionMaterials":"Brick/Stone,Vinyl Siding","Fencing":"None","FireplaceFeatures":"Gas","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"1075","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Unassigned","NST_GarageDoorHeight":"8","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"820","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-05-29T17:36:17Z","NST_InternetOptions":"Fiber Optic","LandLeaseYN":"False","NST_LastUpdateDate":"2025-05-30","Latitude":"45.397982","NST_LenderOwned":"No","ListAgentKey":"NST108633","ListAgentMlsId":"NST502047447","ListingContractDate":"2025-05-29T05:00:00Z","ListOfficeKey":"NST1000426","ListOfficeName":"Checkmark Properties, LLC.","ListOfficeMlsId":"NST251770","ListPrice":"524900","LivingArea":"2212","Longitude":"-93.357878","LotFeatures":"Some Trees","LotSizeDimensions":"W91*140*90*135","LotSizeSquareFeet":"12458.16","LotSizeUnits":"Acres","ListingId":"NST6728955","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"323424210054","GarageSpaces":"4","NST_PatioPorchType":"Covered,Front Porch","PhotosCount":"15","PoolFeatures":"None","PostalCity":"Saint Francis","PostalCode":"55070","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Connexus Energy","NST_PresentUse":"Yearly","PublicRemarks":"***Assumable FHA Mortgage at 3.25%***Fiber Internet*** Two story beautiful open concept home featuring 4 bedrooms on one floor with laundry, 3 bathrooms, main flex room office, corner pantry, granite countertops, stainless appliances, main bedroom features dual walk-in closets, private master bath with ceramic tile shower & glass door, dual sink. Unfinished walkout basement for future expansion! Backs up to city park!","PublicSurveyRange":"24","PublicSurveySection":"32","PublicSurveyTownship":"34","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Office,Laundry","NST_AboveGradeSqFtTotal":"2212.0000","NST_BelowGradeSqFtTotal":"1075.0000","NST_MainLevelFinishedArea":"1075.0000","BuildingAreaTotal":"3287","HighSchoolDistrict":"St. Francis","NST_SchoolDistrictNumber":"15","NST_SchoolDistrictPhone":"763-753-7040","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,4 BR on One Level,Primary Bdr Suite","AboveGradeFinishedArea":"2212","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"NW","StreetName":"Underclift","StreetNumber":"23615","StreetNumberNumeric":"23615","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Rivers Edge 5th Add","NST_TaxWithAssessments":"0.0000","TaxYear":"2025","TaxAnnualAmount":"4724","WaterSource":"City Water/Connected","YearBuilt":"2021","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-05-30T10:08:09.429Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7750368\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"1-print-DSC02834.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/bf9672f9-ca78-45ed-8f1e-09bf67292311.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.155Z\",\"MediaKey\":\"68389c0fc2957f0b642e9c9f\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"13-print-DSC02729.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/d7cafd28-773c-4b47-8d39-f187e2d9cef3.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.228Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca0\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"12-print-DSC02719.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/932eabcd-bc38-41e1-b19b-1931fd75e272.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.171Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca1\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"15-print-DSC02739.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/9381abfe-dbec-44a4-8552-c26d4d454015.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.169Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca2\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"11-print-DSC02709.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/6572f26b-53d9-45eb-9055-6d31739cc77c.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.153Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca3\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"9-print-DSC02699.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/d87cc31a-6504-4480-baf5-2dec4c37b5a7.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.186Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca4\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"22-print-DSC02799.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/275cf2bf-7ba0-4927-be25-b1a8e239b234.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.208Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca5\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"17-print-DSC02759.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/ffb8acb6-a760-4625-87d0-0ee72ab6e77e.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.158Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca6\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"16-print-DSC02744.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/2e1380e6-6cd3-4419-ae6b-3010a6a69234.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.191Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca7\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"18-print-DSC02764.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/0cd35e31-74d8-4440-a2ed-1bf2ced5f589.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.181Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca8\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"20-print-DSC02774.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/c06f93f8-af3a-4bf1-9ede-51427ffe4927.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.117Z\",\"MediaKey\":\"68389c0fc2957f0b642e9ca9\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"21-print-DSC02779.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/eec04b07-cbae-4c49-9835-937eb9579d0a.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.144Z\",\"MediaKey\":\"68389c0fc2957f0b642e9caa\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"25-print-DSC02814.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/0e44ae34-aca5-4ed7-8cd3-1a639c04192c.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.152Z\",\"MediaKey\":\"68389c0fc2957f0b642e9cab\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"3-print-DSC02849.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/d561b77d-bd38-47ce-bab5-69ec16851c4c.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.197Z\",\"MediaKey\":\"68389c0fc2957f0b642e9cac\"},{\"ResourceRecordKey\":\"NST7750368\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"4-print-DSC02854.jpg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7750368/27397d41-92f5-47fc-a9ab-285dc6fa7f19.jpeg\",\"MediaModificationTimestamp\":\"2025-05-29T17:40:31.186Z\",\"MediaKey\":\"68389c0fc2957f0b642e9cad\"}]","PhotosChangeTimestamp":"2025-05-29T17:41:03.473Z","Rooms":"[{\"RoomKey\":\"NST115260522\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"17x16\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115260523\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115260524\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115260525\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115260526\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115260527\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115260528\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115260529\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115260530\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"6x5\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"1-print-DSC02834.jpg\"},{\"Order\":2,\"Remarks\":\"13-print-DSC02729.jpg\"},{\"Order\":3,\"Remarks\":\"12-print-DSC02719.jpg\"},{\"Order\":4,\"Remarks\":\"15-print-DSC02739.jpg\"},{\"Order\":5,\"Remarks\":\"11-print-DSC02709.jpg\"},{\"Order\":6,\"Remarks\":\"9-print-DSC02699.jpg\"},{\"Order\":7,\"Remarks\":\"22-print-DSC02799.jpg\"},{\"Order\":8,\"Remarks\":\"17-print-DSC02759.jpg\"},{\"Order\":9,\"Remarks\":\"16-print-DSC02744.jpg\"},{\"Order\":10,\"Remarks\":\"18-print-DSC02764.jpg\"},{\"Order\":11,\"Remarks\":\"20-print-DSC02774.jpg\"},{\"Order\":12,\"Remarks\":\"21-print-DSC02779.jpg\"},{\"Order\":13,\"Remarks\":\"25-print-DSC02814.jpg\"},{\"Order\":14,\"Remarks\":\"3-print-DSC02849.jpg\"},{\"Order\":15,\"Remarks\":\"4-print-DSC02854.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}