Cummings Janzen Real Estate

Jeff Schlagel

Jeff Schlagel

Operating Broker / Appraiser

Jessica Janzen

Jessica Janzen

Associate Broker

Jeremy Janzen

Jeremy Janzen

Associate Broker / Auctioneer

Robert Janzen

Robert Janzen

Associate Broker / Auctioneer

Our full time staff has 100+ years of real estate experience. We also offer a Full Service Auction Company.

  • Home
  • Hotsheet
  • Contact
  • Map Search
    • Our Listings
    • Featured Listings
    • Open Houses
    • Saved Listings
  • Estimate Request
    • Client Login
    • My Saved Listings
    • Cedarbrook Appraisals
    • Janzen Auction Service
    • MN DNR Lake Finder
  • Arrow Down Icon

MLS# 7045172 - 587 Lake Ridge Drive Shoreview, MN 55126

Neighborhoods

Coldwell Banker Realty 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. Cummings Janzen Realty, Inc. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Cummings Janzen Realty, Inc., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":543077,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7045172","MLSAGENTID":"NST506097318","MLSOFFICEID":"NST8237","ADDRESS":"587 Lake Ridge Drive","ACRES":0.35,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Egress Window(s),Finished,Full","BATHSTOTAL":5.0,"BEDROOMS":6.0,"CITY":"Shoreview","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":1075000.0,"LASTPRICEDATE":"2026-04-16T22:45:06.397","LATITUDE":45.064238,"LENDEROWNED":"No","LISTDATE":"2026-04-16T05:00:00","LISTPRICE":1075000.0,"LIVINGAREA":4429.0,"LONGITUDE":-93.125768,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-04-17T05:05:11.65","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":6,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Custom built two story by Zawadski Homes, located in the Mounds View School District with fabulous curb appeal, high end finishes and walnut wood floors. Gourmet kitchen with SubZero & Wolf appliances opens to the spacious family room with stone fireplace and built-in cabinetry. Luxurious, generous sized master suite includes a spa-like bath. Four bedrooms upstairs + laundry room for every day convenience. Head downstairs to the lower level to find a finished family room, additional bedroom, exercise room, bath and play space. Snail Lake Landing is close to both downtowns, restaurants & shopping, and is a block from Snail Lake Beach, playground and trails. Ready to move right in and enjoy!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"2090-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-17T05:05:11.65","LASTSTATUS":"Coming Soon","STREETNAME":"Lake Ridge","STREETNUMBER":"587","STREETSUFFIX":"Drive","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2006,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-16T22:44:05.859","PHOTOORDER":"1,2,3,4,5,6","SOURCE":"MG_NST"}
{"ListingKey":"NST7875591","NST_AboveGradeSqFtTotal":"3249","AboveGradeFinishedArea":"3249","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Exercise Room,Hardwood Floors,Kitchen Center Island,Natural Woodwork,Patio,Paneled Doors,Porch,In-Ground Sprinkler,Tile Floors,Vaulted Ceiling(s),Wet Bar,Walk-In Closet","Appliances":"Cooktop,Dishwasher,Dryer,Exhaust Fan,Humidifier,Microwave,Refrigerator,Stainless Steel Appliances,Wall Oven,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationFee":"120","AssociationFeeFrequency":"Annually","AssociationFeeIncludes":"Other","AssociationName":"Snail Lake Landing Association","AssociationPhone":"6512718768","AttributionContact":"6122475106","NST_AttributionName":"Krista J. Wolter","Basement":"Daylight/Lookout Windows,Egress Window(s),Finished,Full","BasementYN":"True","NST_BathDesc":"Double Sink,Full Primary,Full Basement,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level 3/4 Bath,Upper Level Full Bath","BathroomsFull":"3","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"5","BedroomsTotal":"6","NST_BelowGradeSqFtTotal":"1340","BelowGradeFinishedArea":"1180","CumulativeDaysOnMarket":"0","City":"Shoreview","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Breakfast Area,Eat In Kitchen,Informal Dining Room,Separate/Formal Dining Room","Directions":"From Snail Lake Boulevard, go south on Lake Ridge Drive to home on left.","DocumentsCount":"0","DaysOnMarket":"0","NST_ExpectedMarketDate":"2026-04-17","Fencing":"None","FireplaceFeatures":"Gas,Living Room,Stone","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1304","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"748","GarageSpaces":"3","Heating":"Forced Air,In-Floor Heating","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.064238","LaundryFeatures":"Laundry Room,Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"1075000","ListingContractDate":"2026-04-16T05:00:00Z","ListingId":"NST7045172","LivingArea":"4429","Longitude":"-93.125768","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.35","LotSizeDimensions":"140x215","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1304","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-17T00:00:31Z","ParcelNumber":"253023220070","NST_SchoolDistrictNumber":"2090","ParkingFeatures":"Attached Garage,Concrete,Garage Door Opener,Insulated Garage","NST_PatioPorchType":"Deck,Patio,Porch","PhotosCount":"6","PhotosChangeTimestamp":"2026-04-16T22:44:05.859Z","PostalCity":"Shoreview","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Custom built two story by Zawadski Homes, located in the Mounds View School District with fabulous curb appeal, high end finishes and walnut wood floors. Gourmet kitchen with SubZero & Wolf appliances opens to the spacious family room with stone fireplace and built-in cabinetry. Luxurious, generous sized master suite includes a spa-like bath. Four bedrooms upstairs + laundry room for every day convenience. Head downstairs to the lower level to find a finished family room, additional bedroom, exercise room, bath and play space. Snail Lake Landing is close to both downtowns, restaurants & shopping, and is a block from Snail Lake Beach, playground and trails. Ready to move right in and enjoy!","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"30","RoadFrontageType":"City Street,Curbs,Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt,Pitched","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,4 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Lake Ridge","StreetNumber":"587","StreetNumberNumeric":"587","StreetSuffix":"Drive","SubdivisionName":"Snail Lake Landing","TaxAnnualAmount":"15078","NST_TaxWithAssessments":"15188","TaxYear":"2026","BuildingAreaTotal":"4589","Township":"Shoreview","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2006","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST68568","ListAgentMlsId":"NST506097318","ListOfficeMlsId":"NST8237","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16731","ModificationTimestamp":"2026-04-17T05:05:11.65Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7875591/5976fe6e-ba9d-43de-85ad-9a60da7916f1.jpeg\",\"ResourceRecordKey\":\"NST7875591\",\"ImageWidth\":1024,\"ImageHeight\":645,\"ImageSizeDescription\":\"1024x645\",\"MediaModificationTimestamp\":\"2026-04-16T22:43:10.369Z\",\"MediaKey\":\"NST121513669\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7875591/ade164b8-8224-427c-9e18-bccdfc9c0a6a.jpeg\",\"ResourceRecordKey\":\"NST7875591\",\"ImageWidth\":1024,\"ImageHeight\":623,\"ImageSizeDescription\":\"1024x623\",\"MediaModificationTimestamp\":\"2026-04-16T22:43:10.365Z\",\"MediaKey\":\"NST121513670\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7875591/7f33db99-05c1-47f8-89bf-0cc2df10b83a.jpeg\",\"ResourceRecordKey\":\"NST7875591\",\"ImageWidth\":1005,\"ImageHeight\":647,\"ImageSizeDescription\":\"1005x647\",\"MediaModificationTimestamp\":\"2026-04-16T22:43:10.367Z\",\"MediaKey\":\"NST121513672\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7875591/8a346cc5-83c1-4e50-84d3-ce4b7d690fb1.jpeg\",\"ResourceRecordKey\":\"NST7875591\",\"ImageWidth\":1024,\"ImageHeight\":645,\"ImageSizeDescription\":\"1024x645\",\"MediaModificationTimestamp\":\"2026-04-16T22:43:10.388Z\",\"MediaKey\":\"NST121513673\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7875591/f926c460-aaca-4023-8a34-c7961f8cf9c5.jpeg\",\"ResourceRecordKey\":\"NST7875591\",\"ImageWidth\":1024,\"ImageHeight\":669,\"ImageSizeDescription\":\"1024x669\",\"MediaModificationTimestamp\":\"2026-04-16T22:43:10.377Z\",\"MediaKey\":\"NST121513674\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7875591/547064b6-e11f-4839-873a-fa8da3160724.jpeg\",\"ResourceRecordKey\":\"NST7875591\",\"ImageWidth\":1024,\"ImageHeight\":630,\"ImageSizeDescription\":\"1024x630\",\"MediaModificationTimestamp\":\"2026-04-16T22:43:10.384Z\",\"MediaKey\":\"NST121513671\"}]","Media__Order":"5","Media__MediaObjectID":"NST5","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7875591/5976fe6e-ba9d-43de-85ad-9a60da7916f1.jpeg","Media__ResourceRecordKey":"NST7875591","Media__ImageWidth":"1024","Media__ImageHeight":"645","Media__ImageSizeDescription":"1024x645","Media__MediaModificationTimestamp":"4/16/2026 10:43:10 PM","Media__MediaKey":"NST121513669","DocumentsChangeTimestamp":"2026-04-16T22:43:06.607Z","Rooms":"[{\"RoomKey\":\"NST116061268\",\"RoomLevel\":\"Main\",\"RoomType\":\"Three Season Porch\",\"NST_RoomSortOrder\":12,\"RoomDimensions\":\"13x15\"},{\"RoomKey\":\"NST116061269\",\"RoomLevel\":\"Main\",\"RoomType\":\"Deck\",\"NST_RoomSortOrder\":13,\"RoomDimensions\":\"10x12\"},{\"RoomKey\":\"NST116061266\",\"RoomLevel\":\"Main\",\"RoomType\":\"Den\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"11x12\"},{\"RoomKey\":\"NST116061258\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"12x12\"},{\"RoomKey\":\"NST116061271\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Exercise Room\",\"NST_RoomSortOrder\":15,\"RoomDimensions\":\"12x14\"},{\"RoomKey\":\"NST116061259\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"12x16\"},{\"RoomKey\":\"NST116061265\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Bedroom 5\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"14x15\"},{\"RoomKey\":\"NST116061261\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"18x26\"},{\"RoomKey\":\"NST116061264\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"16x24\"},{\"RoomKey\":\"NST116061267\",\"RoomLevel\":\"Main\",\"RoomType\":\"Informal Dining Room\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"9x13\"},{\"RoomKey\":\"NST116061260\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"10x16\"},{\"RoomKey\":\"NST116061257\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"17x19\"},{\"RoomKey\":\"NST116124550\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Patio\",\"NST_RoomSortOrder\":16,\"RoomDimensions\":\"12x14\"},{\"RoomKey\":\"NST116061270\",\"RoomLevel\":\"Lower\",\"RoomType\":\"Recreation Room\",\"NST_RoomSortOrder\":14,\"RoomDimensions\":\"12x18\"},{\"RoomKey\":\"NST116061262\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"12x12\"},{\"RoomKey\":\"NST116061263\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"11x12\"}]","Rooms__RoomKey":"NST116061268","Rooms__RoomLevel":"Main","Rooms__RoomType":"Three Season Porch","Rooms__NST_RoomSortOrder":"12","Rooms__RoomDimensions":"13x15","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6","CustomVTourURL":""}

CUMMINGS JANZEN REALTY, INC.

14 - 1st St NW
Aitkin, MN 56431

Phone: 218-927-6258
Toll Free: 800-450-6258
Fax: 218-927-1818

AN EQUAL OPPORTUNITY COMPANY. EQUAL HOUSING OPPORTUNITY.

© Cummings Janzen Realty, INC. All rights reserved.
Created with Real Estate Create.