A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
Sunset Realty 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1368923,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6737817","MLSAGENTID":"NST506003487","MLSOFFICEID":"NST8492","ADDRESS":"864 Rose Avenue E","ACRES":0.11,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":199900.0,"LASTPRICEDATE":"2025-06-12T16:11:03.507","LATITUDE":44.976363,"LENDEROWNED":"No","LISTDATE":"2025-06-12T05:00:00","LISTPRICE":199900.0,"LIVINGAREA":808.0,"LONGITUDE":-93.064071,"MODIFICATIONTIMESTAMP":"2025-06-13T10:08:06.864","NEIGHBORHOOD":"Payne-Phalen","OFFICE_OFFICENAME":"Sunset Realty","OUTBUILDINGS":"Additional Garage","PHOTOCOUNT":16,"POSTALCODE":"55106","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Lovely, cozy home with 2 bedroom and 1 bath, eat-in kitchen, coved ceilings and hardwood floors under carpet. A full basement and room to expand in upper walk-up attic. Add your personal touches and make it your home!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-12T16:11:03.507","LASTSTATUS":"Active","STREETDIRSUFFIX":"E","STREETNAME":"Rose","STREETNUMBER":"864","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1968,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-13T03:13:04.488","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 864 Rose Ave!\"},{\"Order\":3,\"Remarks\":\"Living room with coved ceiling and hardwood floors under carpet\"},{\"Order\":5,\"Remarks\":\"Eat-in kitchen\"},{\"Order\":7,\"Remarks\":\"Table area in kitchen\"},{\"Order\":8,\"Remarks\":\"Bedroom 1\"},{\"Order\":9,\"Remarks\":\"Double closets in bedroom 1\"},{\"Order\":10,\"Remarks\":\"Bedroom 2\"},{\"Order\":11,\"Remarks\":\"Full bath\"},{\"Order\":12,\"Remarks\":\"Laundry in basement\"},{\"Order\":13,\"Remarks\":\"Electrical box\"},{\"Order\":14,\"Remarks\":\"Furnace\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","SOURCE":"MG_NST"}
{"ListingKey":"NST7758126","LotSizeArea":"0.11","NST_AgeOfProperty":"57","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors","Appliances":"Dryer,Range,Refrigerator,Washer","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block,Full","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Eat In Kitchen","Directions":"35E to Maryland, East to Mendota St, S to Rose, W to home","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Fuses","ConstructionMaterials":"Stucco","Fencing":"Chain Link,Partial","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"808","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Garage Door Opener","NST_GarageSquareFeet":"576","AccessibilityFeatures":"None","Heating":"Baseboard,Boiler","OriginalEntryTimestamp":"2025-06-12T16:06:54Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-13","Latitude":"44.976363","NST_LenderOwned":"No","ListAgentKey":"NST83112","ListAgentMlsId":"NST506003487","ListingContractDate":"2025-06-12T05:00:00Z","ListOfficeKey":"NST16727","ListOfficeName":"Sunset Realty","ListOfficeMlsId":"NST8492","ListPrice":"199900","LivingArea":"808","LockBoxType":"Combo","Longitude":"-93.064071","LotSizeDimensions":"40x122","LotSizeSquareFeet":"4878.72","LotSizeUnits":"Acres","ListingId":"NST6737817","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Payne-Phalen","NST_OfficeBoard":"SPAAR","OtherStructures":"Additional Garage","ParcelNumber":"282922220112","GarageSpaces":"2","PhotosCount":"16","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55106","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Lovely, cozy home with 2 bedroom and 1 bath, eat-in kitchen, coved ceilings and hardwood floors under carpet. A full basement and room to expand in upper walk-up attic. Add your personal touches and make it your home!","PublicSurveyRange":"22","PublicSurveySection":"28","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","Roof":"Age Over 8 Years","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"808.0000","NST_BelowGradeSqFtTotal":"808.0000","NST_MainLevelFinishedArea":"808.0000","BuildingAreaTotal":"1616","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"808","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetDirSuffix":"E","StreetName":"Rose","StreetNumber":"864","StreetNumberNumeric":"864","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Eastville Heights","NST_TaxWithAssessments":"2800.0000","TaxYear":"2024","TaxAnnualAmount":"2800","WaterSource":"City Water/Connected","YearBuilt":"1968","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-13T10:08:06.864Z","PhotosChangeTimestamp":"2025-06-13T03:13:04.488Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7758126\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Welcome to 864 Rose Ave!\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/ab1336fd-807b-41be-9e82-a223a60860c1.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.207Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8cd\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/e8954f09-c248-4b35-9f50-a0e41966dda0.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.249Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8ce\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Living room with coved ceiling and hardwood floors under carpet\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/e02a3905-30b7-4166-bbf0-3e167d733168.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.207Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8cf\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/a1689b29-7fcd-444e-b47e-d68cf0f19785.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.266Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d0\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Eat-in kitchen\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/ed291246-8abf-4126-b1a0-6d39597441a1.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.198Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d1\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/129a331c-280d-4e00-ad85-bbd26b4b3389.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.291Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d2\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Table area in kitchen\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/01ee173e-5da4-4337-9a56-241e4fc7aed9.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.174Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d3\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Bedroom 1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/90495508-0c3b-4347-934a-ebc942c60713.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.181Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d4\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Double closets in bedroom 1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/e865b775-1a2f-4ae0-8c39-331e67f5762c.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.183Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d5\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Bedroom 2\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/ebea2c71-1129-4023-a2f7-fc035ce31a6e.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.19Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d6\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Full bath\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/669710ef-2e43-45b3-be7d-6b94198d1aab.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.19Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d7\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Laundry in basement\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/73a67bfe-d422-4668-a955-c30908afb3d7.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.202Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d8\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Electrical box\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/1a9e735a-5d30-4f7f-8227-d831b0f2d3cc.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.174Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8d9\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Furnace\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/1fb0e87c-7cc4-440a-9511-91c2455fbc6d.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.182Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8da\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/722fa48d-3ca4-4faf-be20-4c92a1cff316.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.304Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8db\"},{\"ResourceRecordKey\":\"NST7758126\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7758126/366ace13-6c55-460f-b34b-ae66633fab6d.jpeg\",\"MediaModificationTimestamp\":\"2025-06-13T03:12:41.264Z\",\"MediaKey\":\"684b9729a1254a5f7e7ae8dc\"}]","Rooms":"[{\"RoomKey\":\"NST115314911\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115314912\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x16\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115314913\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115314914\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\",\"NST_RoomSortOrder\":\"4\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 864 Rose Ave!\"},{\"Order\":3,\"Remarks\":\"Living room with coved ceiling and hardwood floors under carpet\"},{\"Order\":5,\"Remarks\":\"Eat-in kitchen\"},{\"Order\":7,\"Remarks\":\"Table area in kitchen\"},{\"Order\":8,\"Remarks\":\"Bedroom 1\"},{\"Order\":9,\"Remarks\":\"Double closets in bedroom 1\"},{\"Order\":10,\"Remarks\":\"Bedroom 2\"},{\"Order\":11,\"Remarks\":\"Full bath\"},{\"Order\":12,\"Remarks\":\"Laundry in basement\"},{\"Order\":13,\"Remarks\":\"Electrical box\"},{\"Order\":14,\"Remarks\":\"Furnace\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16","CustomVTourURL":""}