{"Id":526889,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7033314","MLSAGENTID":"NST506090900","MLSCOAGENTID":"NST506014227","MLSOFFICEID":"NST8237","ADDRESS":"345 Ramsey Street","ACRES":436.0,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Shared Access,Storage Space","BATHSTOTAL":1.0,"BEDROOMS":0.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":115000.0,"LASTPRICEDATE":"2026-04-16T02:12:05.657","LATITUDE":44.941726,"LENDEROWNED":"No","LISTDATE":"2026-03-10T05:00:00","LISTPRICE":105000.0,"LIVINGAREA":372.0,"LONGITUDE":-93.114398,"LOTDESCRIPTION":"Irregular Lot","MODIFICATIONTIMESTAMP":"2026-04-16T02:34:05.537","NEIGHBORHOOD":"101","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":19,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Own a piece of St. Paul history in this charming and affordable furnished studio condo! Built in 1888 during the vibrant early development of Ramsey Hill—just 30 years after Minnesota became a state. Ideally located between the historic Cathedral Hill and West 7th neighborhoods, you’ll be steps from historic Summit Ave, boutique shopping, coffee shops, restaurants, and nightlife in one of Saint Paul’s most prestigious and walkable areas. Short-Term Rentals allowed (3-month lease). This turn-key furnished studio blends character with thoughtful updates. Soaring 12-foot ceilings, oversized updated windows, hardwood floors, and a decorative fireplace create warmth and charm while filling the space with natural light. Kitchen includes updated finishes and newer appliances; convenient in-unit laundry. You'll love the freshly remodeled bathroom including new tile flooring. The monthly HOA includes heat. Pet-friendly. Basement storage, window AC. Enjoy well-lit off-street parking lot in back. Access parking lot from Irvine St. Exterior improvements include a newly replaced retaining wall, exterior stairs, railings 2025, with the ~$6,900 assessment already paid by the seller. Don't let this one get away!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Flat","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-13T05:03:23.92","LASTSTATUS":"Coming Soon","STREETNAME":"Ramsey","STREETNUMBER":"345","STREETSUFFIX":"Street","STYLE":"(CC) Low Rise (3- Levels)","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1888,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-03-12T19:06:07.002","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 345 Ramsey St Unit 345B!\"},{\"Order\":11,\"Remarks\":\"Remodeled 3/4 bath\"},{\"Order\":12,\"Remarks\":\"Sink and shower\"},{\"Order\":14,\"Remarks\":\"all_floors_345_ramsey_street_b_saint_paul_with_dim.jpg\"},{\"Order\":15,\"Remarks\":\"Back of building, stairs to parking and access to storage\"},{\"Order\":17,\"Remarks\":\"Off street parking in back\"},{\"Order\":18,\"Remarks\":\"Basement access door\"},{\"Order\":19,\"Remarks\":\"Basement storage available\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7865562","NST_AboveGradeSqFtTotal":"372","AboveGradeFinishedArea":"372","AccessibilityFeatures":"No Stairs Internal","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Ceiling Fan(s),City View,Hardwood Floors,Natural Woodwork,Tile Floors,Washer/Dryer Hookup","Appliances":"Dryer,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationAmenities":"Fire Sprinkler System,Security Building","AssociationFee":"299","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Heating,Lawn Care,Maintenance Grounds,Parking,Professional Mgmt,Sanitation,Sewer,Snow Removal,Water","AssociationName":"Reis Property Partners","AssociationPhone":"6514487470","AttributionContact":"6515003128","NST_AttributionName":"Shane M. Montoya","Basement":"Shared Access,Storage Space","BasementYN":"True","NST_BathDesc":"Main Floor 3/4 Bath","BathroomsFull":"0","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"1","BedroomsTotal":"0","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Window Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Living/Dining Room","Directions":"Summit Ave to Ramsey St, south to the condo","DocumentsCount":"15","DocumentsChangeTimestamp":"2026-03-17T19:39:07.127Z","DaysOnMarket":"0","Electric":"Circuit Breakers","NST_ExpectedMarketDate":"2026-03-13","Fencing":"None","FireplaceFeatures":"Decorative","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"372","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"0","GarageSpaces":"0","Heating":"Boiler","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.941726","LaundryFeatures":"Main Level,In Unit","NST_LenderOwned":"No","Levels":"One","ListPrice":"105000","ListingContractDate":"2026-03-10T05:00:00Z","ListingId":"NST7033314","LivingArea":"372","Longitude":"-93.114398","LotFeatures":"Irregular Lot","LotSizeArea":"436","LotSizeDimensions":"Irregular","LotSizeUnits":"Square Feet","NST_MainLevelFinishedArea":"372","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"101","OriginalEntryTimestamp":"2026-03-13T00:00:28Z","ParcelNumber":"012823130131","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Gravel,Parking Lot,Open","PhotosCount":"19","PhotosChangeTimestamp":"2026-03-12T19:06:07.002Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55102","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(CC) Low Rise (3- Levels)","PropertyType":"Residential","PublicRemarks":"Own a piece of St. Paul history in this charming and affordable furnished studio condo! Built in 1888 during the vibrant early development of Ramsey Hill—just 30 years after Minnesota became a state. Ideally located between the historic Cathedral Hill and West 7th neighborhoods, you’ll be steps from historic Summit Ave, boutique shopping, coffee shops, restaurants, and nightlife in one of Saint Paul’s most prestigious and walkable areas. Short-Term Rentals allowed (3-month lease). This turn-key furnished studio blends character with thoughtful updates. Soaring 12-foot ceilings, oversized updated windows, hardwood floors, and a decorative fireplace create warmth and charm while filling the space with natural light. Kitchen includes updated finishes and newer appliances; convenient in-unit laundry. You'll love the freshly remodeled bathroom including new tile flooring. The monthly HOA includes heat. Pet-friendly. Basement storage, window AC. Enjoy well-lit off-street parking lot in back. Access parking lot from Irvine St. Exterior improvements include a newly replaced retaining wall, exterior stairs, railings 2025, with the ~$6,900 assessment already paid by the seller. Don't let this one get away!","PublicSurveyRange":"23","PublicSurveySection":"01","PublicSurveyTownship":"28","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights","RoadResponsibility":"Public Maintained Road","Roof":"Flat","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Ramsey","StreetNumber":"345","StreetNumberNumeric":"345","StreetSuffix":"Street","SubdivisionName":"Condo 181 Ramsey Terrace Co","TaxAnnualAmount":"2010","NST_TaxWithAssessments":"2010","TaxYear":"2025","BuildingAreaTotal":"372","Township":"Saint Paul","UnitNumber":"345B","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1888","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST107336","CoListAgentMlsId":"NST506014227","CoListOfficeName":"Coldwell Banker Realty","ListAgentKey":"NST49849","ListAgentMlsId":"NST506090900","ListOfficeMlsId":"NST8237","ListOfficeName":"Coldwell Banker Realty","ListOfficeKey":"NST16731","ModificationTimestamp":"2026-04-16T02:34:05.537Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/3389911c-2f62-4b53-937f-d0944ee612d6.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.627Z\",\"MediaKey\":\"NST120853439\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/cb24b15d-7241-4ccb-9d0d-aaee0e6c7585.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.61Z\",\"MediaKey\":\"NST120853433\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/95354377-b122-4fbd-a33e-c31be347a21e.jpeg\",\"LongDescription\":\"Sink and shower\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-12T18:34:07.538Z\",\"MediaKey\":\"NST120853432\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/71da5a5d-748b-438e-8cdb-c0b4c1d2649b.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.606Z\",\"MediaKey\":\"NST120853441\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/dd2fd4c5-dccf-45bd-8fb8-1e8f28c89a69.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.607Z\",\"MediaKey\":\"NST120853442\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/623f2250-ea4c-4587-85d0-a0c25a21769c.jpeg\",\"LongDescription\":\"Remodeled 3/4 bath\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":860,\"ImageHeight\":1290,\"ImageSizeDescription\":\"860x1290\",\"MediaModificationTimestamp\":\"2026-03-12T19:05:16.919Z\",\"MediaKey\":\"NST120853434\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/656dc43d-3574-44c5-94d1-82c760ca7ab2.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.608Z\",\"MediaKey\":\"NST120853438\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/ef475a4b-b909-4bf8-85e9-bf296fe219b7.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.619Z\",\"MediaKey\":\"NST120853444\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/01dd5cb8-ae3b-4212-a9fa-cf8e6b0b7db7.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.661Z\",\"MediaKey\":\"NST120853443\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/20f8f5f4-1b6a-4257-83d8-12e086cda3ba.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.625Z\",\"MediaKey\":\"NST120853435\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/7a0a43a6-7663-41ed-bf08-7dd606397b9e.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.613Z\",\"MediaKey\":\"NST120853437\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/77f6a81f-03be-42ab-8117-8114866f030b.jpeg\",\"LongDescription\":\"Welcome to 345 Ramsey St Unit 345B!\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.615Z\",\"MediaKey\":\"NST120853431\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/cfead4a9-0afd-461e-b45c-e02b89f089c4.jpeg\",\"LongDescription\":\"Off street parking in back\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2016,\"ImageHeight\":1134,\"ImageSizeDescription\":\"2016x1134\",\"MediaModificationTimestamp\":\"2026-03-12T19:05:16.948Z\",\"MediaKey\":\"NST120882809\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/81421fc0-8aca-4a20-96ea-c69bb1fa3fc9.jpeg\",\"LongDescription\":\"all_floors_345_ramsey_street_b_saint_paul_with_dim.jpg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.63Z\",\"MediaKey\":\"NST120854039\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/49e3ae69-a3d6-4bc7-96d0-aeaa52f4b345.jpeg\",\"LongDescription\":\"Basement storage available\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2080,\"ImageHeight\":1566,\"ImageSizeDescription\":\"2080x1566\",\"MediaModificationTimestamp\":\"2026-03-12T19:05:17.025Z\",\"MediaKey\":\"NST120911772\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/07824d88-026b-461d-ba8f-e2d591f11129.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1290,\"ImageHeight\":860,\"ImageSizeDescription\":\"1290x860\",\"MediaModificationTimestamp\":\"2026-03-11T16:09:10.63Z\",\"MediaKey\":\"NST120853440\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/eb445895-24c2-4003-950c-80c2e9e586d0.jpeg\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2080,\"ImageHeight\":1169,\"ImageSizeDescription\":\"2080x1169\",\"MediaModificationTimestamp\":\"2026-03-12T19:05:17.064Z\",\"MediaKey\":\"NST120882810\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/c850f634-7d80-43b7-aaea-c6a8f0ba18a3.jpeg\",\"LongDescription\":\"Back of building, stairs to parking and access to storage\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":1566,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1566x2080\",\"MediaModificationTimestamp\":\"2026-03-12T19:05:17.017Z\",\"MediaKey\":\"NST120911774\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7865562/df11e686-68fb-4fd6-84e8-82bfec103c9f.jpeg\",\"LongDescription\":\"Basement access door\",\"ResourceRecordKey\":\"NST7865562\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1960,\"ImageSizeDescription\":\"2080x1960\",\"MediaModificationTimestamp\":\"2026-03-12T19:05:17.125Z\",\"MediaKey\":\"NST120911770\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7865562/3389911c-2f62-4b53-937f-d0944ee612d6.jpeg","Media__ResourceRecordKey":"NST7865562","Media__Order":"6","Media__MediaObjectID":"NST6","Media__ImageWidth":"1290","Media__ImageHeight":"860","Media__ImageSizeDescription":"1290x860","Media__MediaModificationTimestamp":"3/11/2026 4:09:10 PM","Media__MediaKey":"NST120853439","Rooms":"[{\"RoomType\":\"Bathroom\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116000916\",\"RoomDimensions\":\"9x6\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116000915\",\"RoomDimensions\":\"14x5\"},{\"RoomType\":\"Laundry\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116000917\",\"RoomDimensions\":\"9x8.5\"},{\"RoomType\":\"Studio\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116000914\",\"RoomDimensions\":\"12x16\"}]","Rooms__RoomType":"Bathroom","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST116000916","Rooms__RoomDimensions":"9x6","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 345 Ramsey St Unit 345B!\"},{\"Order\":11,\"Remarks\":\"Remodeled 3/4 bath\"},{\"Order\":12,\"Remarks\":\"Sink and shower\"},{\"Order\":14,\"Remarks\":\"all_floors_345_ramsey_street_b_saint_paul_with_dim.jpg\"},{\"Order\":15,\"Remarks\":\"Back of building, stairs to parking and access to storage\"},{\"Order\":17,\"Remarks\":\"Off street parking in back\"},{\"Order\":18,\"Remarks\":\"Basement access door\"},{\"Order\":19,\"Remarks\":\"Basement storage available\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}