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

MLS# 6783025 - 2987 Frank Street Maplewood, MN 55109

Neighborhoods

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

{"Id":1434488,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6783025","MLSAGENTID":"NST506090928","MLSCOAGENTID":"NST506094289","MLSOFFICEID":"NST9995","ADDRESS":"2987 Frank Street","ACRES":0.26,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Finished,Full,Walkout","BATHSTOTAL":4.0,"BEDROOMS":4,"CITY":"Maplewood","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Stucco","FORECLOSURE":"No","LAKEACRES":84.0,"LAKECHAINNAME":"Phalen","LAKEDEPTH":"9","LAKEWATERFRONT":"Lake View","LASTPRICE":600000.0,"LASTPRICEDATE":"2025-11-24T19:38:05.313","LATITUDE":45.031386,"LENDEROWNED":"No","LISTDATE":"2025-10-23T05:00:00","LISTPRICE":600000.0,"LIVINGAREA":3274.0,"LONGITUDE":-93.053058,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Many Trees","MODIFICATIONTIMESTAMP":"2025-11-25T11:03:04.738","OFFICE_OFFICENAME":"Keller Williams Premier Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":10,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"CLOSE BEFORE CHRISTMAS! Set high on a hill with views for miles, this stately home has it all! Large room sizes, fantastic layout, many updates - all on a quiet cul-de-sac with easy breezy freeway access to 694 and 35E. Enjoy the updated kitchen with granite, ceramic tile and new appliances. Hardwood floor add warmth and character to the main level. The laundry is conveniently located on the main floor. Large living and family rooms make for generous space for the whole family - and the HUGE DECK with lake and city views will take your breath away. Upstairs you will find three large bedrooms and a luxe primary bath suite. The walkout lower level features a mother large family room, updated wet bar, 4th bedroom (office) and loads of storage space. Close to all the amenities Maplewood has to offer; shopping, restaurants, and more! Interior photos coming 11/25/25","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-24T19:38:05.313","LASTSTATUS":"Active","STREETNAME":"Frank","STREETNUMBER":"2987","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTNAME":"Kohlman","WATERFRONTNUM":"62000600","WATERFRONTPRESENT":false,"WATERFRONTVIEW":"Lake View","YEARBUILT":1988,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-24T02:33:04.237","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome HOME!\"},{\"Order\":2,\"Remarks\":\"Stately and Stunning two story.\"},{\"Order\":3,\"Remarks\":\"Brick and stucco with gorgeous architectural details.\"},{\"Order\":4,\"Remarks\":\"Walkout lower level with huge main level deck.\"},{\"Order\":5,\"Remarks\":\"Brick paver patio under the deck.\"},{\"Order\":6,\"Remarks\":\"You have to see this view in person to believe it!\"},{\"Order\":7,\"Remarks\":\"Newer pergola on the deck.\"},{\"Order\":8,\"Remarks\":\"Large yard, very private\"},{\"Order\":9,\"Remarks\":\"Fantastic yard from every view!\"},{\"Order\":10,\"Remarks\":\"Mature pines add privacy.\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7797472","LotSizeArea":"0.26","NST_AgeOfProperty":"37","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"City View,Deck,Hardwood Floors,Kitchen Center Island,Kitchen Window,Patio,Porch,Tile Floors,Walk-In Closet","Appliances":"Cooktop,Dishwasher,Dryer,Microwave,Refrigerator,Wall Oven,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Egress Window(s),Finished,Full,Walkout","BasementYN":"True","NST_BathDesc":"Full Primary,Full Basement,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"4","BedroomsTotal":"4","City":"Maplewood","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","Directions":"Highway 61 to Beam Ave West to Franke Street North to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","NST_ExpectedMarketDate":"2025-10-24","ConstructionMaterials":"Brick/Stone,Stucco","Fencing":"Partial","FireplaceFeatures":"Amusement Room,Brick,Family Room,Gas","FireplaceYN":"True","FireplacesTotal":"2","NST_ForeclosureStatus":"No","FoundationArea":"1014","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete,Heated Garage,Insulated Garage","NST_GarageDimensions":"30x20","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","NST_GarageSquareFeet":"600","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-23T15:39:37Z","NST_LakeAcres":"84","NST_LakeChain":"Y","NST_LakeChainAcreage":"632","NST_LakeChainName":"Phalen","NST_LakeDepth":"9","WaterfrontFeatures":"Lake View","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-25","Latitude":"45.031386","NST_LenderOwned":"No","ListAgentKey":"NST49856","ListAgentMlsId":"NST506090928","CoListAgentKey":"NST50721","CoListAgentMlsId":"NST506094289","ListingContractDate":"2025-10-23T05:00:00Z","ListOfficeKey":"NST16762","ListOfficeName":"Keller Williams Premier Realty","ListOfficeMlsId":"NST9995","ListPrice":"600000","LivingArea":"3274","LockBoxType":"Combo","Longitude":"-93.053058","LotFeatures":"Public Transit (w/in 6 blks),Many Trees","LotSizeDimensions":"85x135","LotSizeSquareFeet":"11456.28","LotSizeUnits":"Acres","ListingId":"NST6783025","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"042922130034","GarageSpaces":"3","NST_PatioPorchType":"Deck,Patio,Rear Porch,Screened","PhotosCount":"10","PoolFeatures":"None","PostalCity":"Maplewood","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PublicRemarks":"CLOSE BEFORE CHRISTMAS! Set high on a hill with views for miles, this stately home has it all! Large room sizes, fantastic layout, many updates - all on a quiet cul-de-sac with easy breezy freeway access to 694 and 35E. Enjoy the updated kitchen with granite, ceramic tile and new appliances. Hardwood floor add warmth and character to the main level. The laundry is conveniently located on the main floor. Large living and family rooms make for generous space for the whole family - and the HUGE DECK with lake and city views will take your breath away. Upstairs you will find three large bedrooms and a luxe primary bath suite. The walkout lower level features a mother large family room, updated wet bar, 4th bedroom (office) and loads of storage space. Close to all the amenities Maplewood has to offer; shopping, restaurants, and more! Interior photos coming 11/25/25","PublicSurveyRange":"22","PublicSurveySection":"04","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt,Pitched","RoomType":"Living Room,Office,Kitchen,Family Room,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Bar/Wet Bar Room","NST_AboveGradeSqFtTotal":"2260.0000","NST_BelowGradeSqFtTotal":"1014.0000","NST_MainLevelFinishedArea":"1014.0000","BuildingAreaTotal":"3274","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Laundry,Primary Bdr Suite","AboveGradeFinishedArea":"2260","BelowGradeFinishedArea":"1014","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Frank","StreetNumber":"2987","StreetNumberNumeric":"2987","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Kohlman Lake Overlook","NST_TaxWithAssessments":"8840.0000","TaxYear":"2025","TaxAnnualAmount":"8840","WaterSource":"City Water/Connected","WaterfrontYN":"False","WaterBodyName":"Kohlman","NST_WaterfrontNum":"62000600","View":"City Lights,West","YearBuilt":"1988","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-25T11:03:04.738Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7797472\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Welcome HOME!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/b44857c0-d02b-4280-a7f3-c8ca04a20437.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.702Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c85\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Stately and Stunning two story.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/259e0c3a-0dc8-41af-bfc2-1f41d53bec44.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.704Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c86\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Brick and stucco with gorgeous architectural details.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/5580261a-e801-4d17-acea-2f41cd34db86.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.671Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c87\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Walkout lower level with huge main level deck.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/1f449d70-40d0-40a4-a632-091dbafee45c.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.651Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c88\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Brick paver patio under the deck.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/6dba711d-f37d-4112-a0b6-d34eec089457.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.701Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c89\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"You have to see this view in person to believe it!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/247b60e6-f6c3-4078-b921-e532ba0a7484.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.687Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c8a\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Newer pergola on the deck.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/86ea7ab4-e061-44e4-898e-a270915cefb6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.702Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c8b\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Large yard, very private\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/60c54872-8d99-4052-84bd-a1653c5699a6.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.676Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c8c\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Fantastic yard from every view!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/22735f17-cd8b-4360-b9b3-643b99d374f7.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.701Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c8d\"},{\"ResourceRecordKey\":\"NST7797472\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Mature pines add privacy.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7797472/3292e9e8-2673-4222-a40f-e672bef3f47e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-24T02:32:30.875Z\",\"MediaKey\":\"68fae53e1da98f475a5a6c8e\"}]","PhotosChangeTimestamp":"2025-10-24T02:33:04.237Z","Rooms":"[{\"RoomKey\":\"NST115724984\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x12\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115724985\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115724986\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10 x 13\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115724987\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115724988\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115724989\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115724990\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115724991\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x10\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115725021\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"34x13\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115725022\",\"RoomType\":\"Bar/Wet Bar Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"10\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome HOME!\"},{\"Order\":2,\"Remarks\":\"Stately and Stunning two story.\"},{\"Order\":3,\"Remarks\":\"Brick and stucco with gorgeous architectural details.\"},{\"Order\":4,\"Remarks\":\"Walkout lower level with huge main level deck.\"},{\"Order\":5,\"Remarks\":\"Brick paver patio under the deck.\"},{\"Order\":6,\"Remarks\":\"You have to see this view in person to believe it!\"},{\"Order\":7,\"Remarks\":\"Newer pergola on the deck.\"},{\"Order\":8,\"Remarks\":\"Large yard, very private\"},{\"Order\":9,\"Remarks\":\"Fantastic yard from every view!\"},{\"Order\":10,\"Remarks\":\"Mature pines add privacy.\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}