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":504885,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7000300","MLSAGENTID":"NST496503704","MLSOFFICEID":"NST40577","ADDRESS":"414 Aurora Avenue","ACRES":0.17,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Daylight/Lookout Windows,Partially Finished,Sump Basket,Sump Pump","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":279000.0,"LASTPRICEDATE":"2025-12-15T22:52:06.107","LATITUDE":44.954218,"LENDEROWNED":"No","LISTDATE":"2025-12-15T06:00:00","LISTPRICE":279000.0,"LIVINGAREA":1442.0,"LONGITUDE":-93.117906,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2025-12-16T11:04:09.743","NEIGHBORHOOD":"101","OFFICE_OFFICENAME":"RE/MAX Results","PHOTOCOUNT":16,"POSTALCODE":"55103","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"1980 Built split level with 3 bedrooms/2 baths located on cul-de-sac. Owners suite with 3/4 bath walk-in shower. Updated kitchen with stainless appliances. Short walk to bus/light rail, dining, walking path behind home. Potential to add 2 more bedrooms and bathroom lower level. Washer/Dryer included. Screened Porch.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-15T22:52:06.107","LASTSTATUS":"Active","STREETNAME":"Aurora","STREETNUMBER":"414","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1980,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-15T22:52:06.105","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome home to 414 Aurora Ave located on cul-de-sac conveniently located close to bus , light rail and dining.\\nThis 3BR 2Bath Home built in 1980. It has potential to add two more bedrooms and another bathroom in lower level.\"},{\"Order\":2,\"Remarks\":\"Nicely updated kitchen with stainless appliances\"},{\"Order\":3,\"Remarks\":\"414 Aurora Kitchen 2.jpg\"},{\"Order\":4,\"Remarks\":\"414 Aurora Dining Living Room.jpg\"},{\"Order\":5,\"Remarks\":\"414 Aurora living room dining room.jpg\"},{\"Order\":6,\"Remarks\":\"414 Aurora Owners suite.jpg\"},{\"Order\":7,\"Remarks\":\"414 Aurora Owners suite bathroom walkin shower.jpg\"},{\"Order\":8,\"Remarks\":\"414 Aurora 2nd bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"414 Aurora 3rd bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"Main floor full bath with 2 sinks\"},{\"Order\":11,\"Remarks\":\"414 Aurora lower family room with fireplace.jpg\"},{\"Order\":12,\"Remarks\":\"414 Aurora lower family room.jpg\"},{\"Order\":13,\"Remarks\":\"414 Aurora Laundry room Washer /dryer included\"},{\"Order\":14,\"Remarks\":\"414 Aurora potential 4th bedroom.jpg\"},{\"Order\":15,\"Remarks\":\"414 Aurora potential 5th bedroom Rough in for 3rd bathroom\"},{\"Order\":16,\"Remarks\":\"414 Aurora back of home. There is a walking/bike path behind this backyard\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7835558","NST_AboveGradeSqFtTotal":"1142","AboveGradeFinishedArea":"1142","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),Deck,Hardwood Floors,Kitchen Window,Main Floor Primary Bedroom,Washer/Dryer Hookup","Appliances":"Dishwasher,Disposal,Dryer,Gas Water Heater,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Daylight/Lookout Windows,Partially Finished,Sump Basket,Sump Pump","BasementYN":"True","NST_BathDesc":"3/4 Primary,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1092","BelowGradeFinishedArea":"300","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen,Living/Dining Room","Directions":"University Ave, South on Western Ave, 1st Right on Aurora, Home on Left in Cul-de-sac.","DaysOnMarket":"0","Electric":"Circuit Breakers","Fencing":"None","FireplaceFeatures":"Family Room,Wood Burning","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1142","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"440","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.954218","LaundryFeatures":"Lower Level,Laundry Room","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListPrice":"279000","ListingContractDate":"2025-12-15T06:00:00Z","ListingId":"NST7000300","LivingArea":"1442","LockBoxType":"Combo","Longitude":"-93.117906","LotFeatures":"Public Transit (w/in 6 blks),Tree Coverage - Light","LotSizeArea":"0.17","LotSizeDimensions":"55x135","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1142","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"101","OriginalEntryTimestamp":"2025-12-15T16:23:47Z","ParcelNumber":"362923310050","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Attached Garage,Concrete,Garage Door Opener","NST_PatioPorchType":"Rear Porch,Screened","PhotosCount":"16","PhotosChangeTimestamp":"2025-12-15T22:52:06.105Z","PostalCity":"Saint Paul","PostalCode":"55103","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"1980 Built split level with 3 bedrooms/2 baths located on cul-de-sac. Owners suite with 3/4 bath walk-in shower. Updated kitchen with stainless appliances. Short walk to bus/light rail, dining, walking path behind home. Potential to add 2 more bedrooms and bathroom lower level. Washer/Dryer included. Screened Porch.","PublicSurveyRange":"23","PublicSurveySection":"36","PublicSurveyTownship":"29","RoadFrontageType":"Cul De Sac","Roof":"Age Over 8 Years","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Aurora","StreetNumber":"414","StreetNumberNumeric":"414","StreetSuffix":"Avenue","SubdivisionName":"Central Village Addition, No 3","TaxAnnualAmount":"5073","NST_TaxWithAssessments":"5073","TaxYear":"2025","Township":"Saint Paul","WaterSource":"City Water/Connected","YearBuilt":"1980","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST51944","ListAgentMlsId":"NST496503704","ListOfficeMlsId":"NST40577","ListOfficeName":"RE/MAX Results","ListOfficeKey":"NST19361","ModificationTimestamp":"2025-12-16T11:04:09.743Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"414 Aurora Owners suite bathroom walkin shower.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/4b546d59-7ffd-4c4a-a9fe-46bb58615ad5.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.874Z\",\"MediaKey\":\"NST119925166\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Welcome home to 414 Aurora Ave located on cul-de-sac conveniently located close to bus , light rail and dining.\\nThis 3BR 2Bath Home built in 1980. It has potential to add two more bedrooms and another bathroom in lower level.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/59c30f27-b90b-4771-b1a3-e0d108200ff2.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.915Z\",\"MediaKey\":\"NST119924888\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"414 Aurora lower family room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/10f1d90c-07a6-48bc-90d7-6128094eab43.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.914Z\",\"MediaKey\":\"NST119925294\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"414 Aurora Kitchen 2.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/d4109f2a-36cd-4052-a905-b26618a6c3bf.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.858Z\",\"MediaKey\":\"NST119925125\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Main floor full bath with 2 sinks\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/7a4b7f2a-80e2-43ff-8512-a3a7b8252b44.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.877Z\",\"MediaKey\":\"NST119925296\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"414 Aurora 2nd bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/62db2e50-cba6-4dd7-aaaf-8752ec6ae6f3.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.878Z\",\"MediaKey\":\"NST119925168\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"414 Aurora potential 5th bedroom Rough in for 3rd bathroom\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/5b224662-28ff-4853-a9ab-c359f930f5ed.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.874Z\",\"MediaKey\":\"NST119925267\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"414 Aurora back of home. There is a walking/bike path behind this backyard\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/b75cb3ae-d2db-43c7-8ce7-d9943abf9969.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.879Z\",\"MediaKey\":\"NST119925269\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Nicely updated kitchen with stainless appliances\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/67e468f4-77d5-43ee-9bc2-314f9b66f94b.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.876Z\",\"MediaKey\":\"NST119925123\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"414 Aurora lower family room with fireplace.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/24e0502f-7467-4944-b61d-5a938eb987b4.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.867Z\",\"MediaKey\":\"NST119925193\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"414 Aurora Owners suite.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/6aabab21-3a61-4919-9bb3-2a039469cbcf.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.857Z\",\"MediaKey\":\"NST119925164\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"414 Aurora Dining Living Room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/a7a9013e-dc93-410b-b516-2d195b8fad6e.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.864Z\",\"MediaKey\":\"NST119925160\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"414 Aurora Laundry room Washer /dryer included\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/10ac9c3b-16f7-46a2-963e-ed09f829d5b0.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.966Z\",\"MediaKey\":\"NST119925245\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"414 Aurora potential 4th bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/97648448-f9de-42fb-acfa-74761741c548.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.892Z\",\"MediaKey\":\"NST119925246\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"414 Aurora living room dining room.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/5422b651-1ed2-4c8a-989e-24cee784f553.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.892Z\",\"MediaKey\":\"NST119925163\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"414 Aurora 3rd bedroom.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7835558/87860206-91fc-4bcd-b7ac-cd9f0e6277a5.jpeg\",\"ResourceRecordKey\":\"NST7835558\",\"ImageWidth\":2016,\"ImageHeight\":1512,\"ImageSizeDescription\":\"2016x1512\",\"MediaModificationTimestamp\":\"2025-12-15T22:51:23.884Z\",\"MediaKey\":\"NST119925192\"}]","Rooms":"[{\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST115826057\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"11.5x9.5\",\"RoomLevel\":\"Upper\"},{\"RoomType\":\"Family Room\",\"RoomKey\":\"NST115826063\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"24x12\",\"RoomLevel\":\"Lower\"},{\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST115826059\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"11.5x8\",\"RoomLevel\":\"Upper\"},{\"RoomType\":\"Foyer\",\"RoomKey\":\"NST115826055\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"7x7\",\"RoomLevel\":\"Main\"},{\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST115826058\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"11x9\",\"RoomLevel\":\"Upper\"},{\"RoomType\":\"Living Room\",\"RoomKey\":\"NST115826056\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"13x13\",\"RoomLevel\":\"Upper\"},{\"RoomType\":\"Screened Porch\",\"RoomKey\":\"NST115826062\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"12x8\",\"RoomLevel\":\"Upper\"},{\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST115826060\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"11.5x11\",\"RoomLevel\":\"Upper\"},{\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST115826061\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"12.5x11\",\"RoomLevel\":\"Upper\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome home to 414 Aurora Ave located on cul-de-sac conveniently located close to bus , light rail and dining.\\nThis 3BR 2Bath Home built in 1980. It has potential to add two more bedrooms and another bathroom in lower level.\"},{\"Order\":2,\"Remarks\":\"Nicely updated kitchen with stainless appliances\"},{\"Order\":3,\"Remarks\":\"414 Aurora Kitchen 2.jpg\"},{\"Order\":4,\"Remarks\":\"414 Aurora Dining Living Room.jpg\"},{\"Order\":5,\"Remarks\":\"414 Aurora living room dining room.jpg\"},{\"Order\":6,\"Remarks\":\"414 Aurora Owners suite.jpg\"},{\"Order\":7,\"Remarks\":\"414 Aurora Owners suite bathroom walkin shower.jpg\"},{\"Order\":8,\"Remarks\":\"414 Aurora 2nd bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"414 Aurora 3rd bedroom.jpg\"},{\"Order\":10,\"Remarks\":\"Main floor full bath with 2 sinks\"},{\"Order\":11,\"Remarks\":\"414 Aurora lower family room with fireplace.jpg\"},{\"Order\":12,\"Remarks\":\"414 Aurora lower family room.jpg\"},{\"Order\":13,\"Remarks\":\"414 Aurora Laundry room Washer /dryer included\"},{\"Order\":14,\"Remarks\":\"414 Aurora potential 4th bedroom.jpg\"},{\"Order\":15,\"Remarks\":\"414 Aurora potential 5th bedroom Rough in for 3rd bathroom\"},{\"Order\":16,\"Remarks\":\"414 Aurora back of home. There is a walking/bike path behind this backyard\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}