{"Id":1413676,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6794616","MLSAGENTID":"NST506019660","MLSOFFICEID":"NST253015","ADDRESS":"2557 County Rd I","ACRES":0.33,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Mounds View","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":419900.0,"LASTPRICEDATE":"2025-09-26T13:10:04.013","LATITUDE":45.10839048,"LENDEROWNED":"No","LISTDATE":"2025-09-26T05:00:00","LISTPRICE":419900.0,"LIVINGAREA":1461.0,"LONGITUDE":-93.20985362,"MODIFICATIONTIMESTAMP":"2025-09-26T13:10:04.012","OFFICE_OFFICENAME":"LPT Realty, LLC","PHOTOCOUNT":0,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Rare new construction opportunity in a coveted location of Mounds View. This beautiful open concept slab on grade features a spacious living area, custom cabinets, well designed primary bed/bathroom and much more! Located just minutes from the freeway and blocks from dining, shopping, and recreation.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-26T13:10:04.013","LASTSTATUS":"Active","STREETNAME":"County Rd I","STREETNUMBER":"2557","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-26T13:10:04.012","SOURCE":"MG_NST"}
{"ListingKey":"NST7807468","LotSizeArea":"0.33","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"None","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"2","NST_BuilderLicense":"631919","BuilderName":"BOULDER CONTRACTING LLC","City":"Mounds View","PropertyType":"Residential","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"From County Rd 10 turn north on Long Lake Rd, at the intersection of Long Lake Rd and County Rd I go left\nand the home is second on the right hand side.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1461","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"440","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-26T13:07:57Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-26","Latitude":"45.1083904838","NST_LenderOwned":"No","ListAgentKey":"NST507984","ListAgentMlsId":"NST506019660","ListingContractDate":"2025-09-26T05:00:00Z","ListOfficeKey":"NST1001758","ListOfficeName":"LPT Realty, LLC","ListOfficeMlsId":"NST253015","ListPrice":"419900","LivingArea":"1461","Longitude":"-93.2098536153","LotSizeDimensions":"75x191","LotSizeSquareFeet":"14374.8","LotSizeUnits":"Acres","ListingId":"NST6794616","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","ParcelNumber":"063023440079","GarageSpaces":"2","PhotosCount":"0","PostalCity":"Mounds View","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Rare new construction opportunity in a coveted location of Mounds View. This beautiful open concept slab on grade features a spacious living area, custom cabinets, well designed primary bed/bathroom and much more! Located just minutes from the freeway and blocks from dining, shopping, and recreation.","NST_RentalLicenseYN":"No","RoomType":"Kitchen,Dining Room,Living Room,Bedroom 1,Bedroom 2,Primary Bathroom,Bathroom,Laundry","NST_AboveGradeSqFtTotal":"1461.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1461.0000","BuildingAreaTotal":"1461","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1461","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"County Rd I","StreetNumber":"2557","StreetNumberNumeric":"2557","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"1066.0000","TaxYear":"2025","TaxAnnualAmount":"1066","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-26T13:10:04.012Z","OriginatingSystemName":"northstar","PhotosChangeTimestamp":"2025-09-26T13:10:04.012Z","Rooms":"[{\"RoomKey\":\"NST115646489\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115646490\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115646491\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x14\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115646492\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x14\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115646493\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115646494\",\"RoomType\":\"Primary Bathroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x7\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115646495\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x6\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115646496\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x6\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","CustomVTourURL":""}