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":526109,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7032601","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"510 24th Street SW","ACRES":0.277,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Rochester","CONTINGENCY":"None","COUNTY":"Olmsted","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":420000.0,"LASTPRICEDATE":"2026-03-07T00:35:05.953","LATITUDE":43.98704,"LENDEROWNED":"No","LISTDATE":"2026-03-06T06:00:00","LISTPRICE":420000.0,"LIVINGAREA":2382.0,"LONGITUDE":-92.468999,"MODIFICATIONTIMESTAMP":"2026-03-07T00:46:05.39","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":16,"POSTALCODE":"55902","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to 510 24th St SW, a home that exudes warmth and charm. The centerpiece of this property is a cozy fireplace, not located in the living room, but adding a unique touch to the home's layout. The kitchen is a chef's dream, boasting an accent backsplash that adds a pop of color and style. It's also equipped with all stainless steel appliances, ensuring durability and a sleek, modern look. The home also features a deck, perfect for outdoor relaxation or entertaining. The interior has been refreshed with fresh paint, giving it a clean and bright feel. Additionally, partial flooring replacement has been done, enhancing the overall aesthetic of the home. This property is a perfect blend of comfort and style, waiting for you to make it your own. Included 100-Day Home Warranty with buyer activation","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"1929-Rochester","SCHOOLDISTRICTPHONE":"5073283000","SCHOOLELEMENTARY":"Ben Franklin","SCHOOLHIGH":"Mayo","SCHOOLMIDDLE":"Willow Creek","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-07T00:35:05.953","LASTSTATUS":"Active","STREETDIRSUFFIX":"SW","STREETNAME":"24th","STREETNUMBER":"510","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1985,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-03-07T00:35:05.952","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"024295f3-baa8-4142-80c2-3f998d62b15b.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7864972","NST_AboveGradeSqFtTotal":"1682","AboveGradeFinishedArea":"1682","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Finished","BasementYN":"True","BathroomsFull":"3","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1152","BelowGradeFinishedArea":"700","CumulativeDaysOnMarket":"18","CarportSpaces":"0","City":"Rochester","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Olmsted","Directions":"Head toward 21st St SW\nTurn left onto 23rd St SW\nTurn right at the 1st cross street onto 4th Ave SW\n4th Ave SW turns right and becomes 24th St SW","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-03-07T00:34:05.434Z","DaysOnMarket":"0","ElementarySchool":"Ben Franklin","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1176","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"440","GarageSpaces":"2","Heating":"Forced Air","HighSchool":"Mayo","HighSchoolDistrict":"Rochester","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"43.98704","NST_LenderOwned":"No","Levels":"Three Level Split","ListPrice":"420000","ListingContractDate":"2026-03-06T06:00:00Z","ListingId":"NST7032601","LivingArea":"2382","Longitude":"-92.468999","LotSizeArea":"0.277","LotSizeDimensions":"80 x 151","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1176","NST_ManufacturedHome":"N","MiddleOrJuniorSchool":"Willow Creek","OriginalEntryTimestamp":"2026-03-06T18:33:51Z","ParcelNumber":"641424012916","NST_SchoolDistrictNumber":"1929","ParkingFeatures":"Attached Garage","PhotosCount":"16","PhotosChangeTimestamp":"2026-03-07T00:35:05.952Z","PostalCity":"Rochester","PostalCode":"55902","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Welcome to 510 24th St SW, a home that exudes warmth and charm. The centerpiece of this property is a cozy fireplace, not located in the living room, but adding a unique touch to the home's layout. The kitchen is a chef's dream, boasting an accent backsplash that adds a pop of color and style. It's also equipped with all stainless steel appliances, ensuring durability and a sleek, modern look. The home also features a deck, perfect for outdoor relaxation or entertaining. The interior has been refreshed with fresh paint, giving it a clean and bright feel. Additionally, partial flooring replacement has been done, enhancing the overall aesthetic of the home. This property is a perfect blend of comfort and style, waiting for you to make it your own. Included 100-Day Home Warranty with buyer activation","PublicSurveyRange":"14","PublicSurveySection":"14","PublicSurveyTownship":"106","NST_SchoolDistrictPhone":"5073283000","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"SW","StreetName":"24th","StreetNumber":"510","StreetNumberNumeric":"510","StreetSuffix":"Street","SubdivisionName":"Meadow Hills 2nd Sub","TaxAnnualAmount":"4582","NST_TaxWithAssessments":"4582","TaxYear":"2026","BuildingAreaTotal":"2834","Township":"Rochester","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1985","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeName":"Opendoor Brokerage, LLC","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-03-07T00:46:05.39Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/835bea58-ab0c-46d4-addd-1eadbf0765ce.jpeg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.189Z\",\"MediaKey\":\"NST120820911\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/d4f07c7e-933c-4f56-8a05-6248546b4d09.jpeg\",\"LongDescription\":\"listing_13.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.18Z\",\"MediaKey\":\"NST120820901\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/f7954fa5-baaa-4892-bf0a-718e6426dea9.jpeg\",\"LongDescription\":\"listing_8.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.167Z\",\"MediaKey\":\"NST120820906\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/900a67fe-c6b2-45cc-ad90-c6ba9570a62c.jpeg\",\"LongDescription\":\"listing_2.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.189Z\",\"MediaKey\":\"NST120820912\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/13e67e43-67ca-49bc-be12-9496245da91c.jpeg\",\"LongDescription\":\"listing_6.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.192Z\",\"MediaKey\":\"NST120820908\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/b82033a5-3b49-41b3-af82-37841c93b747.jpeg\",\"LongDescription\":\"listing_12.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.171Z\",\"MediaKey\":\"NST120820902\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/7d16d5bb-8123-46fd-9506-58392ef1d704.jpeg\",\"LongDescription\":\"listing_5.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.166Z\",\"MediaKey\":\"NST120820909\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/48262e44-07c6-4544-abd2-e32247c61aae.jpeg\",\"LongDescription\":\"listing_10.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.167Z\",\"MediaKey\":\"NST120820904\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/d301fe20-a3d4-4f1e-8222-03458dc90362.jpeg\",\"LongDescription\":\"listing_14.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.218Z\",\"MediaKey\":\"NST120820900\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/80427550-cf02-450c-b2d5-987f38eeb0bc.jpeg\",\"LongDescription\":\"listing_9.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.159Z\",\"MediaKey\":\"NST120820905\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/fdc144fd-4688-485d-9861-4694a39eec12.jpeg\",\"LongDescription\":\"listing_0.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.162Z\",\"MediaKey\":\"NST120820914\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/1f992253-fff1-4066-9175-762e46e78021.jpeg\",\"LongDescription\":\"024295f3-baa8-4142-80c2-3f998d62b15b.jpeg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.184Z\",\"MediaKey\":\"NST120821054\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/382a67c1-a473-4208-84ce-4dcc74108c62.jpeg\",\"LongDescription\":\"listing_7.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.154Z\",\"MediaKey\":\"NST120820907\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/2386246c-952d-459f-92d6-52d45391c981.jpeg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.181Z\",\"MediaKey\":\"NST120820913\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/9a9fb4f2-9be4-4c74-9bb5-3a407b2843b1.jpeg\",\"LongDescription\":\"listing_11.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.194Z\",\"MediaKey\":\"NST120820903\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7864972/e8d3bd4d-f5e8-468f-b12f-fb6cf554441a.jpeg\",\"LongDescription\":\"listing_4.jpg\",\"ResourceRecordKey\":\"NST7864972\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2080,\"ImageHeight\":1553,\"ImageSizeDescription\":\"2080x1553\",\"MediaModificationTimestamp\":\"2026-03-07T00:34:08.268Z\",\"MediaKey\":\"NST120820910\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7864972/835bea58-ab0c-46d4-addd-1eadbf0765ce.jpeg","Media__ResourceRecordKey":"NST7864972","Media__Order":"4","Media__MediaObjectID":"NST4","Media__ImageWidth":"2080","Media__ImageHeight":"1553","Media__ImageSizeDescription":"2080x1553","Media__MediaModificationTimestamp":"3/7/2026 12:34:08 AM","Media__MediaKey":"NST120820911","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"024295f3-baa8-4142-80c2-3f998d62b15b.jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}