Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":1402593,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6781275","MLSAGENTID":"NST502014514","MLSCOAGENTID":"NST502046819","MLSOFFICEID":"NST6387","ADDRESS":"7861 Ramsey Parkway NW","ACRES":0.06,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":369900.0,"LASTPRICEDATE":"2025-09-03T15:42:04.193","LATITUDE":45.23762856,"LENDEROWNED":"No","LISTDATE":"2025-09-02T05:00:00","LISTPRICE":359900.0,"LIVINGAREA":1930.0,"LONGITUDE":-93.46600615,"MODIFICATIONTIMESTAMP":"2025-09-03T19:30:03.942","OFFICE_OFFICENAME":"Wright-Sherburne Realty","PHOTOCOUNT":14,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"**Ask about our 1% incentive for closing costs or interest rate buydown with our preferred lender - AND BONUS Washer & Dryer Included!** Quick Close Available and SELF- GUIDED TOURS available Daily! \nItroducing, the Terrace in Waterfront Village. A spacious 4 bedroom, 3 bath home conveniently located near all of the amenities of the COR in Ramsey. Association for lawn care, sanitation & snow removal. Highlights include an open concept living space, 4 bedrooms, 3 bathrooms, and 2 car garage! Primary suite includes a private bathroom and walk-in closet. Kitchen features an expansive center island with white cabinets, quartz countertops, & stainless steel appliances. Sod, Irrigation System, & landscaping included. Photos & renderings may not depict actual plan, materials, & finishes may vary. Home is walking distance to North Commons Park and The COR in Ramsey offering amenities including dining, shopping, walking paths, Metro Transit station, & more! All measurements are approximate","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-02T10:09:03.783","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Ramsey","STREETNUMBER":"7861","STREETSUFFIX":"Parkway","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2024,"ZONING":"Residential-Single Family","VIRTUALTOUR_URL1":"https://my.matterport.com/show/?m=EEiQgJGYDxb&mls=1","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-09-02T10:06:09.48","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"7861 Ramsey Pkwy\"},{\"Order\":2,\"Remarks\":\"Kitchen photo has been virtual staged\"},{\"Order\":3,\"Remarks\":\"Kitchen & Dining\"},{\"Order\":4,\"Remarks\":\"Kitchen & Dining\"},{\"Order\":5,\"Remarks\":\"Main Level\"},{\"Order\":6,\"Remarks\":\"Main Level\"},{\"Order\":7,\"Remarks\":\"Terrace photo has been virtual staged\"},{\"Order\":8,\"Remarks\":\"Main Level\"},{\"Order\":9,\"Remarks\":\"Main Level\"},{\"Order\":10,\"Remarks\":\"photo has been virtual staged\"},{\"Order\":11,\"Remarks\":\"photo has been virtual staged\"},{\"Order\":12,\"Remarks\":\"photo has been virtual staged\"},{\"Order\":13,\"Remarks\":\"primary suite photo has been virtual staged\"},{\"Order\":14,\"Remarks\":\"primary closet\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7795948","LotSizeArea":"0.06","NST_AgeOfProperty":"1","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Center Island","Appliances":"Dishwasher,Disposal,Dryer,Microwave,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationFeeIncludes":"Lawn Care,Professional Mgmt,Trash,Snow Removal","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"172","AssociationName":"Sharper Management","AssociationPhone":"952-224-4777","PropertyAttachedYN":"False","Basement":"None","BasementYN":"False","NST_BathDesc":"Full Primary,Main Floor 1/2 Bath,Upper Level 3/4 Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BuilderLicense":"638832","BuilderName":"CENTRA HOMES LLC","City":"Ramsey","PropertyType":"Residential","NST_CommunityName":"Waterfront Village","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Hwy 10, North on Armstrong Blvd NW, East on Bunker Lake Blvd, South to Zeolite St NW to home on Right","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Vinyl Siding","Fencing":"None","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"751","NST_FractionalOwnershipYN":"No","RoadFrontageType":"Private Road","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt","NST_GarageDimensions":"19x23","NST_GarageSquareFeet":"470","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-02T10:01:07Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-03","Latitude":"45.2376285596","NST_LenderOwned":"No","ListAgentKey":"NST45230","ListAgentMlsId":"NST502014514","CoListAgentKey":"NST107408","CoListAgentMlsId":"NST502046819","ListingContractDate":"2025-09-02T05:00:00Z","ListOfficeKey":"NST14883","ListOfficeName":"Wright-Sherburne Realty","ListOfficeMlsId":"NST6387","ListPrice":"359900","LivingArea":"1930","Longitude":"-93.4660061539","LotSizeDimensions":"30x110","LotSizeSquareFeet":"2526.48","LotSizeUnits":"Acres","ListingId":"NST6781275","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","NST_ModelHours":"Daily 9am - 7pm","NST_ModelLocation":"7861 Ramsey Pkwy NW","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"TBD","GarageSpaces":"2","PhotosCount":"14","PostalCity":"Ramsey","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"**Ask about our 1% incentive for closing costs or interest rate buydown with our preferred lender - AND BONUS Washer & Dryer Included!** Quick Close Available and SELF- GUIDED TOURS available Daily! \nItroducing, the Terrace in Waterfront Village. A spacious 4 bedroom, 3 bath home conveniently located near all of the amenities of the COR in Ramsey. Association for lawn care, sanitation & snow removal. Highlights include an open concept living space, 4 bedrooms, 3 bathrooms, and 2 car garage! Primary suite includes a private bathroom and walk-in closet. Kitchen features an expansive center island with white cabinets, quartz countertops, & stainless steel appliances. Sod, Irrigation System, & landscaping included. Photos & renderings may not depict actual plan, materials, & finishes may vary. Home is walking distance to North Commons Park and The COR in Ramsey offering amenities including dining, shopping, walking paths, Metro Transit station, & more! All measurements are approximate","NST_RentalLicenseYN":"No","NST_Restrictions":"Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit","RoadResponsibility":"Association Maintained Road","Roof":"Asphalt","RoomType":"Living Room,Kitchen,Dining Room,Mud Room,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Laundry","NST_AboveGradeSqFtTotal":"1930.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"751.0000","BuildingAreaTotal":"1930","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,4 BR on One Level,Primary Bdr Suite","AboveGradeFinishedArea":"1930","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"NW","StreetName":"Ramsey","StreetNumber":"7861","StreetNumberNumeric":"7861","StreetSuffix":"Parkway","PropertySubType":"Single Family Residence","SubdivisionName":"Waterfront Village","NST_TaxWithAssessments":"0.0000","TaxYear":"2025","TaxAnnualAmount":"0","NST_TotalUnitsSold":"0","VirtualTourURLUnbranded":"https://my.matterport.com/show/?m=EEiQgJGYDxb&mls=1","NST_VirtualTourURLUnbranded2":"https://shultz-photo-design-llc.seehouseat.com/2309505?idx=1","WaterSource":"City Water/Connected","YearBuilt":"2024","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-03T19:30:03.942Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7795948\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"7861 Ramsey Pkwy\",\"ImageWidth\":1125,\"ImageHeight\":1520,\"ImageSizeDescription\":\"1125x1520\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/557c8f8b-42be-4806-a5f5-a1adc8e3edd1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.598Z\",\"MediaKey\":\"68b6c17a73025b492f9fc517\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Kitchen photo has been virtual staged\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/3b83c09f-4ce0-4588-8b07-f2aec86e6203.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.563Z\",\"MediaKey\":\"68b6c17a73025b492f9fc518\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Kitchen & Dining\",\"ImageWidth\":1028,\"ImageHeight\":759,\"ImageSizeDescription\":\"1028x759\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/eeeffcb5-fcfe-42f6-9587-b75a3a11b782.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:02:22.295Z\",\"MediaKey\":\"68b6c0aec9d38869282460c1\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Kitchen & Dining\",\"ImageWidth\":690,\"ImageHeight\":644,\"ImageSizeDescription\":\"690x644\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/ac1efdcf-f362-4964-b46a-316301c00d58.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:02:22.324Z\",\"MediaKey\":\"68b6c0aec9d38869282460c2\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Main Level\",\"ImageWidth\":1017,\"ImageHeight\":756,\"ImageSizeDescription\":\"1017x756\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/00179336-437d-471b-99e2-1e3ccc636bd3.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:02:22.255Z\",\"MediaKey\":\"68b6c0aec9d38869282460c3\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Main Level\",\"ImageWidth\":1026,\"ImageHeight\":759,\"ImageSizeDescription\":\"1026x759\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/7f934f6d-2c7b-4de0-8d0f-3944f93fda7b.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:02:22.29Z\",\"MediaKey\":\"68b6c0aec9d38869282460c4\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Terrace photo has been virtual staged\",\"ImageWidth\":1499,\"ImageHeight\":1000,\"ImageSizeDescription\":\"1499x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/005e3865-120b-4203-bb5b-5b4cb127833f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.569Z\",\"MediaKey\":\"68b6c17a73025b492f9fc519\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Main Level\",\"ImageWidth\":1020,\"ImageHeight\":758,\"ImageSizeDescription\":\"1020x758\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/fd38fdb8-345b-4909-a7ba-37d595f570f8.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:02:22.274Z\",\"MediaKey\":\"68b6c0aec9d38869282460c6\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Main Level\",\"ImageWidth\":1019,\"ImageHeight\":754,\"ImageSizeDescription\":\"1019x754\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/a23b8ad7-09cf-4449-aa76-e121b91869fc.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:02:22.257Z\",\"MediaKey\":\"68b6c0aec9d38869282460c7\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"photo has been virtual staged\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/9a9ff9b5-abe3-4f14-ba3b-78c2194fb299.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.568Z\",\"MediaKey\":\"68b6c17a73025b492f9fc51a\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"photo has been virtual staged\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/9a009896-e29f-42ef-8bfa-d35fd78a2c10.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.568Z\",\"MediaKey\":\"68b6c17a73025b492f9fc51b\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"photo has been virtual staged\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/3c276a8a-c92b-482f-b617-39cf15323ea5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.565Z\",\"MediaKey\":\"68b6c17a73025b492f9fc51c\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"primary suite photo has been virtual staged\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/79281ff1-393b-44d8-8d40-b62173008897.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.586Z\",\"MediaKey\":\"68b6c17a73025b492f9fc51d\"},{\"ResourceRecordKey\":\"NST7795948\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"primary closet\",\"ImageWidth\":667,\"ImageHeight\":1000,\"ImageSizeDescription\":\"667x1000\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795948/61c99bbc-79f3-4fff-9c9d-5f146f54d111.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:05:46.56Z\",\"MediaKey\":\"68b6c17a73025b492f9fc51e\"}]","PhotosChangeTimestamp":"2025-09-02T10:06:09.48Z","Rooms":"[{\"RoomKey\":\"NST115569080\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115569081\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11'10x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115569082\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11'10x10'6\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115569083\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8'10x5'8\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115569084\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14'x13'8\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115569085\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10'10x10'6\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115569086\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9'8x10'8\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115569087\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x9'8\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115569088\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"7861 Ramsey Pkwy\"},{\"Order\":2,\"Remarks\":\"Kitchen photo has been virtual staged\"},{\"Order\":3,\"Remarks\":\"Kitchen & Dining\"},{\"Order\":4,\"Remarks\":\"Kitchen & Dining\"},{\"Order\":5,\"Remarks\":\"Main Level\"},{\"Order\":6,\"Remarks\":\"Main Level\"},{\"Order\":7,\"Remarks\":\"Terrace photo has been virtual staged\"},{\"Order\":8,\"Remarks\":\"Main Level\"},{\"Order\":9,\"Remarks\":\"Main Level\"},{\"Order\":10,\"Remarks\":\"photo has been virtual staged\"},{\"Order\":11,\"Remarks\":\"photo has been virtual staged\"},{\"Order\":12,\"Remarks\":\"photo has been virtual staged\"},{\"Order\":13,\"Remarks\":\"primary suite photo has been virtual staged\"},{\"Order\":14,\"Remarks\":\"primary closet\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}