MLS# 7033636
687 Aurora Avenue Saint Paul, MN 55104
Keller Williams Integrity Realty 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":532243,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7033636","MLSAGENTID":"NST506021481","MLSOFFICEID":"NST10071","ADDRESS":"687 Aurora Avenue","ACRES":0.092,"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-03-24T15:14:07.377","LATITUDE":44.95504409,"LENDEROWNED":"No","LISTDATE":"2026-03-24T05:00:00","LISTPRICE":365000.0,"LIVINGAREA":2504.0,"LONGITUDE":-93.12923344,"MODIFICATIONTIMESTAMP":"2026-03-24T15:59:09.239","NEIGHBORHOOD":"101","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":20,"POSTALCODE":"55104","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Well-maintained up-and-down duplex located in St. Paul. This property features two separate units with private entrances, 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. Convenient location close to 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-03-24T15:14:07.377","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-03-24T15:46:05.952","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"687 Aurora ave\"},{\"Order\":2,\"Remarks\":\"687 Aurora ave\"},{\"Order\":3,\"Remarks\":\"687 Aurora ave\"},{\"Order\":4,\"Remarks\":\"687 Aurora ave\"},{\"Order\":5,\"Remarks\":\"687 Aurora ave\"},{\"Order\":6,\"Remarks\":\"687 Aurora ave\"},{\"Order\":7,\"Remarks\":\"687 Aurora ave\"},{\"Order\":8,\"Remarks\":\"687 Aurora ave\"},{\"Order\":9,\"Remarks\":\"687 Aurora ave\"},{\"Order\":10,\"Remarks\":\"687 Aurora ave\"},{\"Order\":11,\"Remarks\":\"687 Aurora ave\"},{\"Order\":12,\"Remarks\":\"687 Aurora ave\"},{\"Order\":13,\"Remarks\":\"687 Aurora ave\"},{\"Order\":14,\"Remarks\":\"687 Aurora ave\"},{\"Order\":15,\"Remarks\":\"687 Aurora ave\"},{\"Order\":16,\"Remarks\":\"687 Aurora ave\"},{\"Order\":17,\"Remarks\":\"687 Aurora ave\"},{\"Order\":18,\"Remarks\":\"687 Aurora ave\"},{\"Order\":19,\"Remarks\":\"687 Aurora ave\"},{\"Order\":20,\"Remarks\":\"687 Aurora ave\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7865811","NST_AboveGradeSqFtTotal":"2504","AboveGradeFinishedArea":"2504","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AssessmentPending":"Yes","Basement":"Full","BasementYN":"True","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1294","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","CountyOrParish":"Ramsey","Directions":"University Ave, South on Grotto St N, Left on Aurora Ave to home.","DocumentsCount":"3","DocumentsChangeTimestamp":"2026-03-24T15:45:07.004Z","DaysOnMarket":"0","ElectricExpense":"0","FoundationArea":"1264","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","FuelExpense":"0","NST_GarageSquareFeet":"0","GarageSpaces":"0","NST_GreenCertifiedStatus":"Pending","GrossIncome":"30600","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InsuranceExpense":"0","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9550440906","NST_LenderOwned":"No","Levels":"Two","ListPrice":"365000","ListingContractDate":"2026-03-24T05:00:00Z","ListingId":"NST7033636","LivingArea":"2504","Longitude":"-93.1292334417","LotSizeArea":"0.092","LotSizeDimensions":"40x100x40x100","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1294","MaintenanceExpense":"0","ManagerExpense":"0","NST_NeighborhoodNumber":"101","NumberOfUnitsTotal":"2","OperatingExpense":"0","OriginalEntryTimestamp":"2026-03-24T10:13:58Z","OtherExpense":"0","NST_OwnerOccupied":"No","ParcelNumber":"352923410014","NST_SchoolDistrictNumber":"2102","PhotosCount":"20","PhotosChangeTimestamp":"2026-03-24T15:46:05.952Z","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 with private entrances, 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. Convenient location close to 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":"7214","NST_TaxWithAssessments":"7646","TaxYear":"2026","BuildingAreaTotal":"3798","Township":"Saint Paul","TrashExpense":"0","VideosCount":"0","WaterSewerExpense":"0","WaterSource":"City Water/Connected","YearBuilt":"1905","ListAgentKey":"NST522276","ListAgentMlsId":"NST506021481","ListOfficeMlsId":"NST10071","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeKey":"NST16710","ModificationTimestamp":"2026-03-24T15:59:09.239Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/a81d2732-7e61-4d32-a14e-a8c8d77edbcd.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.988Z\",\"MediaKey\":\"NST120953958\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/f0fdc374-0a79-4dfd-8d84-275d2a3d0552.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953953\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/6b702b19-91c9-4711-be33-74844d44ea8b.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.977Z\",\"MediaKey\":\"NST120953951\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/a2f4a106-47a7-4e92-aa91-3989c75643c8.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953949\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/a1b29509-3d1c-4ee1-ab78-d42150155648.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:14.037Z\",\"MediaKey\":\"NST120953961\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/7926feef-e644-4796-9ced-2228e171cfdf.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.991Z\",\"MediaKey\":\"NST120953955\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/40b9b87d-6a17-4ce3-ae73-a3c7e50015fe.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953946\"},{\"Order\":20,\"MediaObjectID\":\"NST20\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/280c5247-d523-4904-83a7-f80ea2c92c83.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953964\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/eec23a9f-738f-4642-b08a-447e30717fb6.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953954\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/81a9f081-2f09-49a7-a3b4-5040d451997f.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953948\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/49f3fbaf-9ece-4537-9da8-4d79dbeba35c.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953963\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/42b131e2-6d8c-4edd-ad20-460f50e54feb.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.953Z\",\"MediaKey\":\"NST120953950\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/c9fa1a94-6b7e-4cbb-94b6-b1a6434c6ff0.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.938Z\",\"MediaKey\":\"NST120953944\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/23ca84e6-3285-4c08-ad84-d59c2f1d9053.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953947\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/af7dc95a-4c4c-4f1b-871b-b259dcffa2aa.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953952\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/b76cc77d-af0e-48e1-838b-0d3409e63b53.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.953Z\",\"MediaKey\":\"NST120953943\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/fc33879d-e99a-45eb-90bb-dc50fc793ed5.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953957\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/25f468a9-4e12-4cfe-9dce-f8433c11b7dd.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.969Z\",\"MediaKey\":\"NST120953962\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/879d0407-dedb-4fd0-b72c-75d5d22b80b6.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.977Z\",\"MediaKey\":\"NST120953959\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"687 Aurora ave\",\"ResourceRecordKey\":\"NST7865811\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865811/453c3d10-f366-4a86-a5f0-62d6156a38a2.jpeg\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-03-24T15:45:13.994Z\",\"MediaKey\":\"NST120953945\"}]","Media__Order":"15","Media__MediaObjectID":"NST15","Media__LongDescription":"687 Aurora ave","Media__ResourceRecordKey":"NST7865811","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7865811/a81d2732-7e61-4d32-a14e-a8c8d77edbcd.jpeg","Media__ImageWidth":"480","Media__ImageHeight":"640","Media__ImageSizeDescription":"480x640","Media__MediaModificationTimestamp":"3/24/2026 3:45:13 PM","Media__MediaKey":"NST120953958","UnitTypes":"[{\"NST_UnitBathFull\":1,\"NST_UnitID\":1,\"UnitTypeBedsTotal\":2,\"UnitTypeTotalRent\":0,\"NST_UnitSqFt\":934,\"NST_UnitRoomsTotal\":7,\"UnitTypeBathsTotal\":1,\"NST_UnitIsLeased\":\"N\",\"UnitTypeUnitsTotal\":1,\"UnitTypeKey\":\"NST158481\"},{\"NST_UnitBathFull\":1,\"NST_UnitID\":2,\"UnitTypeBedsTotal\":2,\"UnitTypeTotalRent\":15000,\"NST_UnitSqFt\":990,\"NST_UnitRoomsTotal\":6,\"UnitTypeBathsTotal\":1,\"NST_LeaseExpirationDt\":\"2026-11-01\",\"NST_UnitIsLeased\":\"Y\",\"UnitTypeUnitsTotal\":1,\"UnitTypeKey\":\"NST158482\"}]","UnitTypes__NST_UnitBathFull":"1","UnitTypes__NST_UnitID":"1","UnitTypes__UnitTypeBedsTotal":"2","UnitTypes__UnitTypeTotalRent":"0","UnitTypes__NST_UnitSqFt":"934","UnitTypes__NST_UnitRoomsTotal":"7","UnitTypes__UnitTypeBathsTotal":"1","UnitTypes__NST_UnitIsLeased":"N","UnitTypes__UnitTypeUnitsTotal":"1","UnitTypes__UnitTypeKey":"NST158481","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"687 Aurora ave\"},{\"Order\":2,\"Remarks\":\"687 Aurora ave\"},{\"Order\":3,\"Remarks\":\"687 Aurora ave\"},{\"Order\":4,\"Remarks\":\"687 Aurora ave\"},{\"Order\":5,\"Remarks\":\"687 Aurora ave\"},{\"Order\":6,\"Remarks\":\"687 Aurora ave\"},{\"Order\":7,\"Remarks\":\"687 Aurora ave\"},{\"Order\":8,\"Remarks\":\"687 Aurora ave\"},{\"Order\":9,\"Remarks\":\"687 Aurora ave\"},{\"Order\":10,\"Remarks\":\"687 Aurora ave\"},{\"Order\":11,\"Remarks\":\"687 Aurora ave\"},{\"Order\":12,\"Remarks\":\"687 Aurora ave\"},{\"Order\":13,\"Remarks\":\"687 Aurora ave\"},{\"Order\":14,\"Remarks\":\"687 Aurora ave\"},{\"Order\":15,\"Remarks\":\"687 Aurora ave\"},{\"Order\":16,\"Remarks\":\"687 Aurora ave\"},{\"Order\":17,\"Remarks\":\"687 Aurora ave\"},{\"Order\":18,\"Remarks\":\"687 Aurora ave\"},{\"Order\":19,\"Remarks\":\"687 Aurora ave\"},{\"Order\":20,\"Remarks\":\"687 Aurora ave\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}
