MLS# 7055006
687 Aurora Avenue Saint Paul, MN 55104
Bridge Realty, LLC is the brokerage office representing the seller for this listing.
Copyright 2026, 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. Jim Christensen is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Jim Christensen, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
$LABEL$
$CONTENT$
$DESC$
{"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-14T20:27:07.599","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","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-14T20:27:07.599Z","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":""}
