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":553532,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7039597","MLSAGENTID":"NST502016428","MLSOFFICEID":"NST5116","ADDRESS":"536 Riviera Drive","ACRES":0.232,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Finished,Sump Pump","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"New Brighton","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":349900.0,"LASTPRICEDATE":"2026-05-07T15:30:06.637","LATITUDE":45.04057,"LENDEROWNED":"No","LISTDATE":"2026-04-23T05:00:00","LISTPRICE":349900.0,"LIVINGAREA":1591.0,"LONGITUDE":-93.202795,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-05-07T15:30:06.638","OFFICE_OFFICENAME":"Coldwell Banker Realty - Lakes","PHOTOCOUNT":23,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This 3-bedroom, 2-bath split-level offers an excellent floor plan with spaces that truly live well. Two bedrooms are located on the upper level along with a fully remodeled and updated kitchen, providing a comfortable and functional main living experience. Cozy up in either the living room or family room — both featuring fireplaces that add warmth and character. The lower level offers a great open area, ideal for a family room, game space, or flexible entertaining setup, enhanced by bright lookout windows that bring in natural light.\nStep outside to a fantastic lot built for entertaining, with a deck and plenty of room to host gatherings or enjoy outdoor living. A well-balanced home that combines comfort, function, and space — indoors and out.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-07T15:30:06.637","LASTSTATUS":"Active","STREETNAME":"Riviera","STREETNUMBER":"536","STREETSUFFIX":"Drive","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1965,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-23T14:20:06.226","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23","SOURCE":"MG_NST"}
{"ListingKey":"NST7870891","NST_AboveGradeSqFtTotal":"1045","AboveGradeFinishedArea":"1045","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Cooktop,Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Refrigerator,Stainless Steel Appliances,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","AttributionContact":"9522211723","NST_AttributionName":"Judith A Shields","Basement":"Daylight/Lookout Windows,Finished,Sump Pump","BasementYN":"True","NST_BathDesc":"3/4 Basement,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1045","BelowGradeFinishedArea":"546","CumulativeDaysOnMarket":"8","City":"New Brighton","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"Cty Rd D to Continental, N to 7th, East to Riviera, North to Home.","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-04-29T14:11:07.387Z","DaysOnMarket":"8","NST_ExpectedMarketDate":"2026-04-28","Fencing":"Chain Link,Partial,Wood","FireplaceFeatures":"Family Room,Living Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1056","NST_FoundationDimensions":"38x27.5","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.04057","LaundryFeatures":"Lower Level","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"349900","ListingContractDate":"2026-04-23T05:00:00Z","ListingId":"NST7039597","LivingArea":"1591","Longitude":"-93.202795","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"0.232","LotSizeDimensions":"76x149x59x159","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"0","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-04-28T00:00:20Z","ParcelNumber":"323023310068","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_PatioPorchType":"Deck","PhotosCount":"23","PhotosChangeTimestamp":"2026-04-23T14:20:06.226Z","PostalCity":"Saint Paul","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"This 3-bedroom, 2-bath split-level offers an excellent floor plan with spaces that truly live well. Two bedrooms are located on the upper level along with a fully remodeled and updated kitchen, providing a comfortable and functional main living experience. Cozy up in either the living room or family room — both featuring fireplaces that add warmth and character. The lower level offers a great open area, ideal for a family room, game space, or flexible entertaining setup, enhanced by bright lookout windows that bring in natural light.\nStep outside to a fantastic lot built for entertaining, with a deck and plenty of room to host gatherings or enjoy outdoor living. A well-balanced home that combines comfort, function, and space — indoors and out.","PublicSurveyRange":"23","PublicSurveySection":"32","PublicSurveyTownship":"30","RoadResponsibility":"Public Maintained Road","Roof":"Age Over 8 Years,Asphalt","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Riviera","StreetNumber":"536","StreetNumberNumeric":"536","StreetSuffix":"Drive","SubdivisionName":"Apache Hills, Second Add","TaxAnnualAmount":"4102","NST_TaxWithAssessments":"4102","TaxYear":"2025","BuildingAreaTotal":"2090","Township":"New Brighton","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1965","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST39465","ListAgentMlsId":"NST502016428","ListOfficeMlsId":"NST5116","ListOfficeName":"Coldwell Banker Realty - Lakes","ListOfficeKey":"NST16638","ModificationTimestamp":"2026-05-07T15:30:06.638Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/b8ccfb09-24cf-41fd-accf-cb816cd099d9.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.086Z\",\"MediaKey\":\"NST121711776\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/1e913b92-cc3f-4cdf-8d87-197c172f529c.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.963Z\",\"MediaKey\":\"NST121711771\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/339d17b6-94d5-4143-96a1-3d107dbff246.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.066Z\",\"MediaKey\":\"NST121711788\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/374b68d1-4d06-4ef0-903f-ee27ba5ec9ab.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.966Z\",\"MediaKey\":\"NST121711774\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/be1dda9c-9df1-49c4-a685-1415ee944738.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.972Z\",\"MediaKey\":\"NST121711780\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/fd1c55a7-b639-437e-8164-f3373920e48d.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.985Z\",\"MediaKey\":\"NST121711785\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/cb86fb5e-f314-4a6d-91c4-2582ce3d1732.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.959Z\",\"MediaKey\":\"NST121711781\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/2886e7e7-5648-489b-be5a-57d2fe68c444.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.963Z\",\"MediaKey\":\"NST121711769\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/9393a78e-7a3c-4444-968d-fd2757449bcc.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.135Z\",\"MediaKey\":\"NST121711778\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/6db41246-ef4a-4169-bc7e-56ea4a60e446.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.028Z\",\"MediaKey\":\"NST121711787\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/402cd4db-ce0d-4bb5-9c06-9252a5e89e11.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.969Z\",\"MediaKey\":\"NST121711786\"},{\"Order\":23,\"MediaObjectID\":\"NST23\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/582b6242-35bf-4586-8a46-1cd79e145137.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.998Z\",\"MediaKey\":\"NST121711766\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/9dec4792-0a1c-42ca-b511-ad6b4ab63d57.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.995Z\",\"MediaKey\":\"NST121711773\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/d618eb72-8b3b-4cc0-8819-a7cd277cffeb.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.949Z\",\"MediaKey\":\"NST121711783\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/32b42f36-43c6-44a2-9aa8-38f8b79a0b9a.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.96Z\",\"MediaKey\":\"NST121711782\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/5b40d9f0-efd5-4513-a9f7-f8e2f10d7697.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.994Z\",\"MediaKey\":\"NST121711777\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/0f85fbd8-93db-47b5-8c9c-3fcf46747b74.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.97Z\",\"MediaKey\":\"NST121711775\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/da92d463-5320-418d-b0a0-2365febfaee6.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.005Z\",\"MediaKey\":\"NST121711772\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/37b26748-aa36-40cc-b9e5-dc2d230a68e7.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.963Z\",\"MediaKey\":\"NST121711779\"},{\"Order\":22,\"MediaObjectID\":\"NST22\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/ca168ff5-30d7-4033-aac7-ef8ddbfa2587.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.997Z\",\"MediaKey\":\"NST121711767\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/34c5f276-26d5-4be5-8574-1e01caec5e44.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.026Z\",\"MediaKey\":\"NST121711784\"},{\"Order\":21,\"MediaObjectID\":\"NST21\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/b0106274-5fed-4aca-b630-502f1f7eaae2.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:11.963Z\",\"MediaKey\":\"NST121711768\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7870891\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7870891/38820a8d-dfab-4c9c-b39c-60a04159aee7.jpeg\",\"ImageWidth\":2038,\"ImageHeight\":1361,\"ImageSizeDescription\":\"2038x1361\",\"MediaModificationTimestamp\":\"2026-04-23T14:19:12.033Z\",\"MediaKey\":\"NST121711770\"}]","Media__Order":"13","Media__MediaObjectID":"NST13","Media__ResourceRecordKey":"NST7870891","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7870891/b8ccfb09-24cf-41fd-accf-cb816cd099d9.jpeg","Media__ImageWidth":"2038","Media__ImageHeight":"1361","Media__ImageSizeDescription":"2038x1361","Media__MediaModificationTimestamp":"4/23/2026 2:19:12 PM","Media__MediaKey":"NST121711776","Rooms":"[{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116150535\",\"RoomDimensions\":\"11x9\"},{\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116150539\",\"RoomDimensions\":\"24x18\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116150536\",\"RoomDimensions\":\"10x13\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116150534\",\"RoomDimensions\":\"10x11\"},{\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116150533\",\"RoomDimensions\":\"13x15\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116150537\",\"RoomDimensions\":\"12x9\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116150538\",\"RoomDimensions\":\"12x11\"}]","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Upper","Rooms__RoomKey":"NST116150535","Rooms__RoomDimensions":"11x9","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23","CustomVTourURL":""}