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":1402594,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6781276","MLSAGENTID":"NST502014514","MLSCOAGENTID":"NST502046819","MLSOFFICEID":"NST6387","ADDRESS":"7867 Ramsey Parkway NW","ACRES":0.06,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":3,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":349900.0,"LASTPRICEDATE":"2025-09-03T15:42:04.213","LATITUDE":45.23764367,"LENDEROWNED":"No","LISTDATE":"2025-09-02T05:00:00","LISTPRICE":339900.0,"LIVINGAREA":1690.0,"LONGITUDE":-93.46640849,"MODIFICATIONTIMESTAMP":"2025-09-04T10:05:05.802","OFFICE_OFFICENAME":"Wright-Sherburne Realty","PHOTOCOUNT":12,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"**Ask about our 1% incentive for closing costs or interest rate buydown with our preferred lender** Introducing, the Alpine in Waterfront Village! Price Improvement! This home offers a Spacious 3 bed, 3 bath home conveniently located near all of the amenities of the COR in Ramsey! Quick Close! Association for lawn care, sanitation & snow removal. 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. Inquire about Seller's contribution to closing costs using preferred lender & title company. 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 many amenities including amphitheater, dining, shopping, ballfields, 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:20:03.493","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Ramsey","STREETNUMBER":"7867","STREETSUFFIX":"Parkway","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","VIRTUALTOUR_URL1":"https://my.matterport.com/show/?m=JZv9qeaHvCZ&mls=1","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-09-03T02:42:05.725","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Similar Home Shown\"},{\"Order\":2,\"Remarks\":\"Alpine Photo has been virtual Staged\"},{\"Order\":3,\"Remarks\":\"Kitchen\"},{\"Order\":4,\"Remarks\":\"Alpine Living Room 01 Photo has been virtual staged\"},{\"Order\":6,\"Remarks\":\"Grand Entrance\"},{\"Order\":7,\"Remarks\":\"Main Level 1/2 Bth\"},{\"Order\":8,\"Remarks\":\"Mud Room\"},{\"Order\":9,\"Remarks\":\"Upper Level\"},{\"Order\":14,\"Remarks\":\"Alpine Bedroom 2 04 Photo has been virtual staged\"},{\"Order\":15,\"Remarks\":\"Alpine Bedroom 2 05 Photo has been virtual staged\"},{\"Order\":17,\"Remarks\":\"Upper Level Laundry\"},{\"Order\":18,\"Remarks\":\"7867 Ramsey Pkwy NW\"}]","PHOTOORDER":"1,2,3,4,6,7,8,9,14,15,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7795949","LotSizeArea":"0.06","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Center Island","Appliances":"Dishwasher,Disposal,Microwave,Range,Refrigerator,Stainless Steel Appliances","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,Private Primary,Main Floor 1/2 Bath,Upper Level 3/4 Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BuilderLicense":"638832","BuilderName":"CENTRA HOMES LLC","City":"Ramsey","PropertyType":"Residential","NST_CommunityName":"Waterfront Village","NST_CompletionDate":"2025-09-30","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Y","DaysOnMarket":"2","CumulativeDaysOnMarket":"2","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Hwy 10, North on Armstrong Blvd NW, East on Bunker Lake Blvd, Zeolite St NW to Ramsey Parkway NW to home on Right","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone,Vinyl Siding","Fencing":"None","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"711","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Parking Lot","NST_GarageDimensions":"19x21","NST_GarageSquareFeet":"406","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-02T10:11:15Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-04","Latitude":"45.2376436694","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":"339900","LivingArea":"1690","Longitude":"-93.4664084852","LotSizeDimensions":"34x105x30x103","LotSizeSquareFeet":"2613.6","LotSizeUnits":"Acres","ListingId":"NST6781276","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"283225220095","GarageSpaces":"2","PhotosCount":"12","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** Introducing, the Alpine in Waterfront Village! Price Improvement! This home offers a Spacious 3 bed, 3 bath home conveniently located near all of the amenities of the COR in Ramsey! Quick Close! Association for lawn care, sanitation & snow removal. 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. Inquire about Seller's contribution to closing costs using preferred lender & title company. 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 many amenities including amphitheater, dining, shopping, ballfields, walking paths, Metro Transit station, & more! All measurements are approximate.","NST_RentalLicenseYN":"No","NST_Restrictions":"Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit","Roof":"Asphalt","RoomType":"Living Room,Kitchen,Dining Room,Mud Room,Bedroom 1,Bedroom 2,Bedroom 3,Laundry","NST_AboveGradeSqFtTotal":"1690.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"711.0000","BuildingAreaTotal":"1690","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level","AboveGradeFinishedArea":"1690","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"NW","StreetName":"Ramsey","StreetNumber":"7867","StreetNumberNumeric":"7867","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=JZv9qeaHvCZ&mls=1","NST_VirtualTourURLUnbranded2":"https://shultz-photo-design-llc.seehouseat.com/2305635?idx=1","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-04T10:05:05.802Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7795949\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Similar Home Shown\",\"ImageWidth\":1891,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1891x2048\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/6a2679d3-f761-4fb0-a21e-67997876d1cd.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.622Z\",\"MediaKey\":\"68b7aae34a04cb1516f666fb\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Alpine Photo has been virtual Staged\",\"ImageWidth\":1536,\"ImageHeight\":1152,\"ImageSizeDescription\":\"1536x1152\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/519e8118-42ee-4782-83f7-cba6300d15a6.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.614Z\",\"MediaKey\":\"68b7aae34a04cb1516f666fc\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/f4bec02b-f715-465a-87e5-701a2bcae209.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.614Z\",\"MediaKey\":\"68b7aae34a04cb1516f666fd\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Alpine Living Room 01 Photo has been virtual staged\",\"ImageWidth\":1536,\"ImageHeight\":1152,\"ImageSizeDescription\":\"1536x1152\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/ecca80cc-36bd-4779-b6c3-9f12f5ab8a37.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.64Z\",\"MediaKey\":\"68b7aae34a04cb1516f666fe\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Grand Entrance\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/8f408a17-5f59-4fe5-a93b-cad3e4ea7817.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:12:26.056Z\",\"MediaKey\":\"68b6c30a73025b492f9fc563\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Main Level 1/2 Bth\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/b5b4e3ad-ce30-4bc6-a425-a0ac91df73bb.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:12:26.055Z\",\"MediaKey\":\"68b6c30a73025b492f9fc564\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Mud Room\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/fda2a89f-aa29-4210-9442-24c5d1dad24f.jpeg\",\"MediaModificationTimestamp\":\"2025-09-02T10:12:26.058Z\",\"MediaKey\":\"68b6c30a73025b492f9fc565\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Upper Level\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/5022976b-53db-4b3a-9c77-f045aa3e52d4.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.637Z\",\"MediaKey\":\"68b7aae34a04cb1516f66700\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Alpine Bedroom 2 04 Photo has been virtual staged\",\"ImageWidth\":1536,\"ImageHeight\":1152,\"ImageSizeDescription\":\"1536x1152\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/1bb36e88-46ba-474d-ba1b-42523504a4b1.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.626Z\",\"MediaKey\":\"68b7aae34a04cb1516f66705\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Alpine Bedroom 2 05 Photo has been virtual staged\",\"ImageWidth\":1536,\"ImageHeight\":1152,\"ImageSizeDescription\":\"1536x1152\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/325d11b4-54b0-411c-b38a-9f7d5cff75a2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.616Z\",\"MediaKey\":\"68b7aae34a04cb1516f66706\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Upper Level Laundry\",\"ImageWidth\":1024,\"ImageHeight\":768,\"ImageSizeDescription\":\"1024x768\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/eb1fedde-e333-4738-b7f7-87968ef683be.jpeg\",\"MediaModificationTimestamp\":\"2025-09-03T02:41:39.616Z\",\"MediaKey\":\"68b7aae34a04cb1516f66708\"},{\"ResourceRecordKey\":\"NST7795949\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"7867 Ramsey Pkwy NW\",\"ImageWidth\":953,\"ImageHeight\":609,\"ImageSizeDescription\":\"953x609\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7795949/c469a3a4-ff80-4e52-9e99-c219c32b6949.png\",\"MediaModificationTimestamp\":\"2025-09-02T10:12:26.058Z\",\"MediaKey\":\"68b6c30a73025b492f9fc56f\"}]","PhotosChangeTimestamp":"2025-09-03T02:42:05.725Z","Rooms":"[{\"RoomKey\":\"NST115569089\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115569090\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11'10x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115569091\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11'10x9'6\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115569092\",\"RoomType\":\"Mud Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8'10x5'8\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115569093\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12'10x13'4\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115569094\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11'6x10'4\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115569095\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10'4x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115569096\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Similar Home Shown\"},{\"Order\":2,\"Remarks\":\"Alpine Photo has been virtual Staged\"},{\"Order\":3,\"Remarks\":\"Kitchen\"},{\"Order\":4,\"Remarks\":\"Alpine Living Room 01 Photo has been virtual staged\"},{\"Order\":6,\"Remarks\":\"Grand Entrance\"},{\"Order\":7,\"Remarks\":\"Main Level 1/2 Bth\"},{\"Order\":8,\"Remarks\":\"Mud Room\"},{\"Order\":9,\"Remarks\":\"Upper Level\"},{\"Order\":14,\"Remarks\":\"Alpine Bedroom 2 04 Photo has been virtual staged\"},{\"Order\":15,\"Remarks\":\"Alpine Bedroom 2 05 Photo has been virtual staged\"},{\"Order\":17,\"Remarks\":\"Upper Level Laundry\"},{\"Order\":18,\"Remarks\":\"7867 Ramsey Pkwy NW\"}]","PhotoOrder":"1,2,3,4,6,7,8,9,14,15,17,18","CustomVTourURL":""}