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":508087,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7005290","MLSAGENTID":"NST505005196","MLSCOAGENTID":"NST506014959","MLSOFFICEID":"NST1865","ADDRESS":"510 Elaine Avenue","ACRES":0.483,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Finished,Full,Walkout","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Shoreview","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LAKEWATERFRONT":"Lake Front","LASTPRICE":550000.0,"LASTPRICEDATE":"2026-01-06T14:44:06.18","LATITUDE":45.120557,"LENDEROWNED":"No","LISTDATE":"2026-01-06T06:00:00","LISTPRICE":550000.0,"LIVINGAREA":2212.0,"LONGITUDE":-93.12294,"LOTDESCRIPTION":"Accessible Shoreline,Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-01-07T21:35:06.285","OFFICE_OFFICENAME":"Keller Williams Classic Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":16,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Discover waterfront living in the highly sought-after Mounds View School District! This beautifully remodeled home combines modern updates with an incredible backyard beach—your own private getaway just steps from the house. Located within a unique community of connected pond waterways and just a block from Bucher Park, you will enjoy peaceful water views and easy access for kayaking, paddle-boarding, or simply relaxing by the shore.\nInside, the home shines with a fully remodeled kitchen featuring modern finishes, complemented by gorgeous hardwood floors throughout the main level. With 4 bedrooms and a walkout lower level, there’s plenty of flexible space for living, entertaining, and working from home. Step outside to the maintenance-free deck or the lower-level paver patio to take in panoramic water views year-round.\nThis home has been pre-inspected and is in excellent condition, offering peace of mind and true move-in readiness. Seller is providing a 1 year Achosa Home Warranty. Don’t miss this rare opportunity to enjoy everyday living with a vacation-like backdrop. Come see for yourself","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"2090-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-01-06T14:44:06.18","LASTSTATUS":"Active","STREETNAME":"Elaine","STREETNUMBER":"510","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":true,"WATERFRONTVIEW":"Lake Front","YEARBUILT":1986,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-01-06T17:50:06.298","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Beautifully remodeled\"},{\"Order\":2,\"Remarks\":\"Dining\"},{\"Order\":3,\"Remarks\":\"Bright and open kitchen\"},{\"Order\":4,\"Remarks\":\"Plenty of cabinet and counter space\"},{\"Order\":5,\"Remarks\":\"Your own private waterfront\"},{\"Order\":6,\"Remarks\":\"Newer maint free deck and paver patio\"},{\"Order\":8,\"Remarks\":\"Large primary bedroom\"},{\"Order\":9,\"Remarks\":\"Beautiful hard wood floors 2nd bedroom\"},{\"Order\":10,\"Remarks\":\"Upper level full bath\"},{\"Order\":11,\"Remarks\":\"Family room heated floors\"},{\"Order\":12,\"Remarks\":\"bedroom 3\"},{\"Order\":13,\"Remarks\":\"Large custom tile shower 2nd bath\"},{\"Order\":14,\"Remarks\":\"Welcome to Evergreen Ponds!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7839794","NST_AboveGradeSqFtTotal":"1212","AboveGradeFinishedArea":"1212","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Patio,Tile Floors,Vaulted Ceiling(s),Washer/Dryer Hookup","Appliances":"Dishwasher,Disposal,Dryer,Gas Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Drain Tiled,Finished,Full,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1212","BelowGradeFinishedArea":"1000","CumulativeDaysOnMarket":"13","City":"Shoreview","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Cty Road J to Mckubin's, S to Elaine.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-01-06T14:42:07.459Z","DaysOnMarket":"0","Electric":"Circuit Breakers","Fencing":"Chain Link,Full,Wood","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1212","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"528","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.120557","LaundryFeatures":"Lower Level","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"550000","ListingContractDate":"2026-01-06T06:00:00Z","ListingId":"NST7005290","LivingArea":"2212","LockBoxType":"Supra","Longitude":"-93.12294","LotFeatures":"Accessible Shoreline,Tree Coverage - Medium","LotSizeArea":"0.483","LotSizeDimensions":"660*230*206*84","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1212","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-01-06T08:39:29Z","OtherStructures":"Storage Shed","ParcelNumber":"013023220092","NST_SchoolDistrictNumber":"2090","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener,Heated Garage","NST_PatioPorchType":"Composite Decking,Deck,Patio","PhotosCount":"16","PhotosChangeTimestamp":"2026-01-06T17:50:06.298Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Discover waterfront living in the highly sought-after Mounds View School District! This beautifully remodeled home combines modern updates with an incredible backyard beach—your own private getaway just steps from the house. Located within a unique community of connected pond waterways and just a block from Bucher Park, you will enjoy peaceful water views and easy access for kayaking, paddle-boarding, or simply relaxing by the shore.\nInside, the home shines with a fully remodeled kitchen featuring modern finishes, complemented by gorgeous hardwood floors throughout the main level. With 4 bedrooms and a walkout lower level, there’s plenty of flexible space for living, entertaining, and working from home. Step outside to the maintenance-free deck or the lower-level paver patio to take in panoramic water views year-round.\nThis home has been pre-inspected and is in excellent condition, offering peace of mind and true move-in readiness. Seller is providing a 1 year Achosa Home Warranty. Don’t miss this rare opportunity to enjoy everyday living with a vacation-like backdrop. Come see for yourself","PublicSurveyRange":"23","PublicSurveySection":"01","PublicSurveyTownship":"30","NST_RoadBetweenWaterfrontAndHomeYN":"N","RoadFrontageType":"City Street,Cul De Sac,Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Elaine","StreetNumber":"510","StreetNumberNumeric":"510","StreetSuffix":"Avenue","SubdivisionName":"Evergreen Shores","TaxAnnualAmount":"5942","NST_TaxWithAssessments":"5942","TaxYear":"2025","Township":"Shoreview","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontFeatures":"Lake Front","YearBuilt":"1986","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST108923","CoListAgentMlsId":"NST506014959","CoListOfficeName":"Keller Williams Classic Realty","ListAgentKey":"NST54455","ListAgentMlsId":"NST505005196","ListOfficeMlsId":"NST1865","ListOfficeName":"Keller Williams Classic Realty","ListOfficeKey":"NST14003","ModificationTimestamp":"2026-01-07T21:35:06.285Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/02173ce4-95f6-4fee-9baa-0ac2f6aef990.jpeg\",\"LongDescription\":\"Family room heated floors\",\"ImageWidth\":2038,\"ImageHeight\":1335,\"ImageSizeDescription\":\"2038x1335\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.364Z\",\"MediaKey\":\"NST120047504\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/31ea0040-3d39-48d7-b964-8bdd4f030667.jpeg\",\"LongDescription\":\"Upper level full bath\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.319Z\",\"MediaKey\":\"NST120047503\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/5bd9f723-ba95-4793-8ed4-c2c3c442da06.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.297Z\",\"MediaKey\":\"NST120047508\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/fef100a5-3964-45e6-950a-02aa4cd59712.jpeg\",\"LongDescription\":\"Plenty of cabinet and counter space\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.321Z\",\"MediaKey\":\"NST120047497\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/40785d05-ef83-4128-86a6-4923078302c9.jpeg\",\"LongDescription\":\"Large custom tile shower 2nd bath\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.315Z\",\"MediaKey\":\"NST120047506\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/47897644-4e3f-481c-acf1-078028ff517d.jpeg\",\"LongDescription\":\"Beautiful hard wood floors 2nd bedroom\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.319Z\",\"MediaKey\":\"NST120047502\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/35f9522b-9e1b-4f04-99f9-159e96995abd.jpeg\",\"LongDescription\":\"Dining\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.298Z\",\"MediaKey\":\"NST120047495\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/792fc670-3454-42a8-99ac-ef0659df4f87.jpeg\",\"LongDescription\":\"Bright and open kitchen\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.307Z\",\"MediaKey\":\"NST120047496\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/f966bbe3-4031-40fb-9142-6fd111686e08.jpeg\",\"LongDescription\":\"Beautifully remodeled\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.315Z\",\"MediaKey\":\"NST120047494\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/225c20e2-9849-491e-ab52-a92e714237ff.jpeg\",\"LongDescription\":\"Large primary bedroom\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.311Z\",\"MediaKey\":\"NST120047501\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/944ba8c5-6918-4094-97c9-1b4466ca7a4e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.297Z\",\"MediaKey\":\"NST120047509\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/cec4d5b0-b072-4bf9-8dc5-e7cea1468d66.jpeg\",\"LongDescription\":\"Your own private waterfront\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.403Z\",\"MediaKey\":\"NST120047498\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/85f9f05c-9062-486e-8a74-01d551242b98.jpeg\",\"LongDescription\":\"Newer maint free deck and paver patio\",\"ImageWidth\":2038,\"ImageHeight\":1358,\"ImageSizeDescription\":\"2038x1358\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.375Z\",\"MediaKey\":\"NST120047499\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/892e1a23-7202-44ed-b3d4-d22a9bdd97f5.jpeg\",\"LongDescription\":\"Welcome to Evergreen Ponds!\",\"ImageWidth\":1070,\"ImageHeight\":1210,\"ImageSizeDescription\":\"1070x1210\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.369Z\",\"MediaKey\":\"NST120047507\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/9628207c-0637-4d9d-ae85-8e1647ab19f0.jpeg\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.404Z\",\"MediaKey\":\"NST120047500\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7839794\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7839794/4756fc24-4312-4d8e-9a68-5a92f43d9091.jpeg\",\"LongDescription\":\"bedroom 3\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaModificationTimestamp\":\"2026-01-06T17:49:42.398Z\",\"MediaKey\":\"NST120047505\"}]","Media__Order":"11","Media__MediaObjectID":"NST11","Media__ResourceRecordKey":"NST7839794","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7839794/02173ce4-95f6-4fee-9baa-0ac2f6aef990.jpeg","Media__LongDescription":"Family room heated floors","Media__ImageWidth":"2038","Media__ImageHeight":"1335","Media__ImageSizeDescription":"2038x1335","Media__MediaModificationTimestamp":"1/6/2026 5:49:42 PM","Media__MediaKey":"NST120047504","Rooms":"[{\"RoomKey\":\"NST115850895\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"10.1 x 13.2\",\"RoomType\":\"Dining Room\"},{\"RoomKey\":\"NST115850898\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"14.9x13.6\",\"RoomType\":\"Bedroom\"},{\"RoomKey\":\"NST115850901\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"16.5 x 12.3\",\"RoomType\":\"Bedroom 4\"},{\"RoomKey\":\"NST115850903\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"9.4 x 9.9\",\"RoomType\":\"Informal Dining Room\"},{\"RoomKey\":\"NST115850897\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"11 x 13.5\",\"RoomType\":\"Kitchen\"},{\"RoomKey\":\"NST115850894\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"11.6 x 13.2\",\"RoomType\":\"Living Room\"},{\"RoomKey\":\"NST115850902\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"20 x 10\",\"RoomType\":\"Patio\"},{\"RoomKey\":\"NST115850896\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"22.11x12.3\",\"RoomType\":\"Recreation Room\"},{\"RoomKey\":\"NST115850899\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"10.6 x 12\",\"RoomType\":\"Bedroom 2\"},{\"RoomKey\":\"NST115850900\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"13.1 x 11.8\",\"RoomType\":\"Bedroom 3\"},{\"RoomKey\":\"NST115850904\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"10.2 x 12\",\"RoomType\":\"Utility Room\"}]","Rooms__RoomKey":"NST115850895","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"10.1 x 13.2","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Beautifully remodeled\"},{\"Order\":2,\"Remarks\":\"Dining\"},{\"Order\":3,\"Remarks\":\"Bright and open kitchen\"},{\"Order\":4,\"Remarks\":\"Plenty of cabinet and counter space\"},{\"Order\":5,\"Remarks\":\"Your own private waterfront\"},{\"Order\":6,\"Remarks\":\"Newer maint free deck and paver patio\"},{\"Order\":8,\"Remarks\":\"Large primary bedroom\"},{\"Order\":9,\"Remarks\":\"Beautiful hard wood floors 2nd bedroom\"},{\"Order\":10,\"Remarks\":\"Upper level full bath\"},{\"Order\":11,\"Remarks\":\"Family room heated floors\"},{\"Order\":12,\"Remarks\":\"bedroom 3\"},{\"Order\":13,\"Remarks\":\"Large custom tile shower 2nd bath\"},{\"Order\":14,\"Remarks\":\"Welcome to Evergreen Ponds!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}