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# 7055006 - 687 Aurora Avenue Saint Paul, MN 55104

Neighborhoods

Bridge Realty, LLC 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":541815,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7055006","MLSAGENTID":"NST506021481","MLSOFFICEID":"NST10982","ADDRESS":"687 Aurora Avenue","ACRES":2504.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":365000.0,"LASTPRICEDATE":"2026-04-14T20:17:06.503","LATITUDE":44.95504409,"LENDEROWNED":"No","LISTDATE":"2026-04-14T05:00:00","LISTPRICE":365000.0,"LIVINGAREA":2504.0,"LONGITUDE":-93.12923344,"MODIFICATIONTIMESTAMP":"2026-04-15T10:04:13.811","NEIGHBORHOOD":"101","OFFICE_OFFICENAME":"Bridge Realty, LLC","PHOTOCOUNT":18,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Well-maintained up-and-down duplex located in St. Paul. This property features two separate units, offering a great opportunity for owner-occupants or investors. Live in one unit while renting the other, or add a solid rental property to your portfolio. Lower unit is currently vacant, providing immediate opportunity, while the upper unit is occupied.\n\n\n\nOwner covers water, sewer, and trash, while tenants pay electricity and gas, making for a favorable investment setup. Conveniently located near schools, shopping, restaurants, and public transportation with easy access to major highways.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-14T20:17:06.503","LASTSTATUS":"Active","STREETNAME":"Aurora","STREETNUMBER":"687","STREETSUFFIX":"Avenue","STYLE":"Duplex Up and Down","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1905,"HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-14T20:24:06.026","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_7928.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_7930 (1).jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_7932 (1).jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_7939 (1).jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_7940 (1).jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_7976 (1).jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_7949 (1).jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_7950 (1).jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_7975 (1).jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_7956 (1).jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_7966 (1).jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_7963 (1).jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_7964 (1).jpeg\"},{\"Order\":14,\"Remarks\":\"IMG_7959 (1).jpeg\"},{\"Order\":15,\"Remarks\":\"IMG_7981 (1).jpeg\"},{\"Order\":16,\"Remarks\":\"IMG_7935 (1).jpeg\"},{\"Order\":17,\"Remarks\":\"IMG_7934 (1).jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_7933 (1).jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}
{"ListingKey":"NST7885022","NST_AboveGradeSqFtTotal":"2504","AboveGradeFinishedArea":"2504","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","Basement":"Full","BasementYN":"True","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1250","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"15","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"from I-94 take dale st exit go north on dale st turn right onto aurora ave property will be on the right at aurora ave","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-04-14T20:12:07.574Z","DaysOnMarket":"0","ElectricExpense":"0","FoundationArea":"1250","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","NST_GarageSquareFeet":"0","GarageSpaces":"0","NST_GreenCertifiedStatus":"Pending","GrossIncome":"36000","Heating":"Boiler,Radiator","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InsuranceExpense":"2300","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9550440906","NST_LenderOwned":"No","Levels":"Two","ListPrice":"365000","ListingContractDate":"2026-04-14T05:00:00Z","ListingId":"NST7055006","LivingArea":"2504","LockBoxType":"Combo","Longitude":"-93.1292334417","LotSizeArea":"2504","LotSizeDimensions":"4000","LotSizeUnits":"Square Feet","NST_MainLevelFinishedArea":"1252","MaintenanceExpense":"0","ManagerExpense":"0","NST_NeighborhoodNumber":"101","NumberOfUnitsTotal":"2","OperatingExpense":"4080","OriginalEntryTimestamp":"2026-04-14T15:10:57Z","OtherExpense":"0","ParcelNumber":"352923410014","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"On-Street Parking Only","PhotosCount":"18","PhotosChangeTimestamp":"2026-04-14T20:24:06.026Z","PostalCity":"Saint Paul","PostalCode":"55104","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertySubType":"Duplex Up and Down","PropertyType":"Residential Income","PublicRemarks":"Well-maintained up-and-down duplex located in St. Paul. This property features two separate units, offering a great opportunity for owner-occupants or investors. Live in one unit while renting the other, or add a solid rental property to your portfolio. Lower unit is currently vacant, providing immediate opportunity, while the upper unit is occupied.\n\n\n\nOwner covers water, sewer, and trash, while tenants pay electricity and gas, making for a favorable investment setup. Conveniently located near schools, shopping, restaurants, and public transportation with easy access to major highways.","PublicSurveyRange":"23","PublicSurveySection":"35","PublicSurveyTownship":"29","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Aurora","StreetNumber":"687","StreetNumberNumeric":"687","StreetSuffix":"Avenue","SubdivisionName":"Chute Brothers Division, No 8","TaxAnnualAmount":"7213.5","NST_TaxWithAssessments":"7646","TaxYear":"2026","BuildingAreaTotal":"3754","Township":"Saint Paul","TrashExpense":"680","VideosCount":"0","WaterSewerExpense":"1100","WaterSource":"City Water/Connected","YearBuilt":"1905","ListAgentKey":"NST522276","ListAgentMlsId":"NST506021481","ListOfficeMlsId":"NST10982","ListOfficeName":"Bridge Realty, LLC","ListOfficeKey":"NST18899","ModificationTimestamp":"2026-04-15T10:04:13.811Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"IMG_7949 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/786d8f61-17f8-49fe-98b2-6e289ac89e59.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.482Z\",\"MediaKey\":\"NST121522416\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"IMG_7959 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/8e6690b1-b2fa-45b7-9ec6-2d0f3e486095.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:23:17.681Z\",\"MediaKey\":\"NST121522421\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"IMG_7950 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/bc67ac3b-cf0d-4b36-af0e-c341eb125512.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.504Z\",\"MediaKey\":\"NST121522415\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"IMG_7966 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/b0c51d7f-8ed0-435d-834c-558f8a8d06e3.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.537Z\",\"MediaKey\":\"NST121522424\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"IMG_7956 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/182ed4d8-cbd4-4699-a1c8-213d111dde1d.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.533Z\",\"MediaKey\":\"NST121522420\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"IMG_7963 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/9d791b66-94a1-4aec-83a1-794ff8e16151.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:23:17.679Z\",\"MediaKey\":\"NST121522422\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"IMG_7939 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/22f4d29f-5c39-48e2-8803-0a0fabc190b6.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.506Z\",\"MediaKey\":\"NST121522418\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"IMG_7940 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/f370d597-26c0-44e0-840e-fcddcf2b800f.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.484Z\",\"MediaKey\":\"NST121522417\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"IMG_7975 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/12f4afe7-9d8e-4ebc-aa20-02f89c07d8d8.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.485Z\",\"MediaKey\":\"NST121522427\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"IMG_7935 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/cca34021-acdb-4b34-9f17-4f84e287056b.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:23:17.673Z\",\"MediaKey\":\"NST121522419\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"IMG_7976 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/3921d029-4eb0-40d7-9cc1-0443c430e141.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:22:11.478Z\",\"MediaKey\":\"NST121522426\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"IMG_7964 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/8604d7eb-5202-4e0e-ae2a-aa780bd5777f.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:23:17.692Z\",\"MediaKey\":\"NST121522423\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"IMG_7932 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/9667e7c1-09b8-4c94-9b9c-c7861db3a2e6.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:20:12.24Z\",\"MediaKey\":\"NST121522412\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"IMG_7934 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/7e9cf2f1-a1bb-4c07-a092-f711caf17351.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:20:12.217Z\",\"MediaKey\":\"NST121522414\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"IMG_7930 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/47a068f9-7f14-48b8-88fb-143b4d2c7ec0.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:19:16.117Z\",\"MediaKey\":\"NST121522411\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"IMG_7933 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/05bde1d1-7d69-4ef3-ac84-cca3811075c3.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:20:12.215Z\",\"MediaKey\":\"NST121522413\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"IMG_7928.jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/fbb488f3-537c-4e72-b75f-d678b9ac8edb.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:19:16.044Z\",\"MediaKey\":\"NST121522410\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"IMG_7981 (1).jpeg\",\"ResourceRecordKey\":\"NST7885022\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7885022/9508d22c-277d-4ebd-9158-73839087bdcc.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-04-14T20:23:17.657Z\",\"MediaKey\":\"NST121522425\"}]","Media__Order":"7","Media__MediaObjectID":"NST7","Media__LongDescription":"IMG_7949 (1).jpeg","Media__ResourceRecordKey":"NST7885022","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7885022/786d8f61-17f8-49fe-98b2-6e289ac89e59.jpeg","Media__ImageWidth":"480","Media__ImageHeight":"640","Media__ImageSizeDescription":"480x640","Media__MediaModificationTimestamp":"4/14/2026 8:22:11 PM","Media__MediaKey":"NST121522416","UnitTypes":"[{\"NST_UnitIsLeased\":\"N\",\"NST_UnitID\":1,\"NST_UnitRoomsTotal\":5,\"UnitTypeBedsTotal\":2,\"NST_MonthlyExpenses\":170,\"UnitTypeUnitsTotal\":1,\"NST_UnitSqFt\":1250,\"UnitTypeTotalRent\":1500,\"UnitTypeKey\":\"NST159265\",\"UnitTypeBathsTotal\":1,\"NST_UnitBathFull\":1},{\"NST_UnitIsLeased\":\"Y\",\"NST_UnitID\":2,\"NST_UnitRoomsTotal\":5,\"UnitTypeBedsTotal\":2,\"NST_MonthlyExpenses\":170,\"UnitTypeUnitsTotal\":1,\"NST_UnitSqFt\":1250,\"NST_LeaseExpirationDt\":\"2026-11-01\",\"UnitTypeTotalRent\":1500,\"UnitTypeKey\":\"NST159266\",\"UnitTypeBathsTotal\":1,\"NST_UnitBathFull\":1}]","UnitTypes__NST_UnitIsLeased":"N","UnitTypes__NST_UnitID":"1","UnitTypes__NST_UnitRoomsTotal":"5","UnitTypes__UnitTypeBedsTotal":"2","UnitTypes__NST_MonthlyExpenses":"170","UnitTypes__UnitTypeUnitsTotal":"1","UnitTypes__NST_UnitSqFt":"1250","UnitTypes__UnitTypeTotalRent":"1500","UnitTypes__UnitTypeKey":"NST159265","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitBathFull":"1","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"IMG_7928.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_7930 (1).jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_7932 (1).jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_7939 (1).jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_7940 (1).jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_7976 (1).jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_7949 (1).jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_7950 (1).jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_7975 (1).jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_7956 (1).jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_7966 (1).jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_7963 (1).jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_7964 (1).jpeg\"},{\"Order\":14,\"Remarks\":\"IMG_7959 (1).jpeg\"},{\"Order\":15,\"Remarks\":\"IMG_7981 (1).jpeg\"},{\"Order\":16,\"Remarks\":\"IMG_7935 (1).jpeg\"},{\"Order\":17,\"Remarks\":\"IMG_7934 (1).jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_7933 (1).jpeg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}