{"Id":1386180,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6759063","MLSAGENTID":"NST496503288","MLSOFFICEID":"NST26330","ADDRESS":"304 Marshall Avenue","ACRES":0.03,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":1.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone","FORECLOSURE":"No","LASTPRICE":264900.0,"LASTPRICEDATE":"2025-09-22T01:45:03.273","LATITUDE":44.94794489,"LENDEROWNED":"Yes","LISTDATE":"2025-07-22T05:00:00","LISTPRICE":259900.0,"LIVINGAREA":1245.0,"LONGITUDE":-93.11269259,"MODIFICATIONTIMESTAMP":"2025-09-22T01:45:03.273","NEIGHBORHOOD":"Summit-University","OFFICE_OFFICENAME":"Realty ONE Group Choice","PHOTOCOUNT":15,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Classic character meets city living in this oversized Cathedral Hill condo. Enjoy four versatile bedrooms, a generous living area, and a formal dining room with timeless details like box beams and built ins. The kitchen blends vintage charm with modern updates. Just steps from great dining and close to downtown St. Paul.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-07-23T13:50:03.677","LASTSTATUS":"Active","STREETNAME":"Marshall","STREETNUMBER":"304","STREETSUFFIX":"Avenue","STYLE":"Low Rise","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1913,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-24T02:58:05.332","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"01_304MarshallAveapt5_2003_Large.jpg\"},{\"Order\":2,\"Remarks\":\"03_304MarshallAveapt5_2005_Large.jpg\"},{\"Order\":3,\"Remarks\":\"04_304MarshallAveapt5_2006_Large.jpg\"},{\"Order\":4,\"Remarks\":\"05_304MarshallAveapt5_2007_Large.jpg\"},{\"Order\":5,\"Remarks\":\"06_304MarshallAveapt5_2008_Large.jpg\"},{\"Order\":6,\"Remarks\":\"07_304MarshallAveapt5_2011_Large.jpg\"},{\"Order\":7,\"Remarks\":\"08_304MarshallAveapt5_2013_Large.jpg\"},{\"Order\":8,\"Remarks\":\"09_304MarshallAveapt5_2016_Large.jpg\"},{\"Order\":9,\"Remarks\":\"10_304MarshallAveapt5_2019_Large.jpg\"},{\"Order\":10,\"Remarks\":\"11_304MarshallAveapt5_2021_Large.jpg\"},{\"Order\":11,\"Remarks\":\"12_304MarshallAveapt5_2023_Large.jpg\"},{\"Order\":12,\"Remarks\":\"14_304MarshallAveapt5_2027_Large.jpg\"},{\"Order\":13,\"Remarks\":\"15_304MarshallAveapt5_2028_Large.jpg\"},{\"Order\":14,\"Remarks\":\"02_304MarshallAveapt5_2004_Large.jpg\"},{\"Order\":15,\"Remarks\":\"13_304MarshallAveapt5_2026_Large.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7776584","LotSizeArea":"0.03","NST_AgeOfProperty":"112","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Ceiling Fan(s),Kitchen Window,Natural Woodwork","Appliances":"Dishwasher,Exhaust Fan,Range","NST_AssessmentPending":"Unknown","AssociationFeeIncludes":"Maintenance Structure,Hazard Insurance,Heating,Maintenance Grounds,Parking,Trash","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"594","AssociationName":"Self Managed-Lee","AssociationPhone":"952-452-2085","PropertyAttachedYN":"True","Basement":"None","BasementYN":"False","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"4","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"61","CumulativeDaysOnMarket":"61","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"John Ireland, W on Marshall","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1245","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Assigned","AccessibilityFeatures":"None","Heating":"Hot Water","OriginalEntryTimestamp":"2025-07-23T13:47:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-21","Latitude":"44.9479448924","NST_LenderOwned":"Yes","ListAgentKey":"NST58672","ListAgentMlsId":"NST496503288","ListingContractDate":"2025-07-22T05:00:00Z","ListOfficeKey":"NST26330","ListOfficeName":"Realty ONE Group Choice","ListOfficeMlsId":"NST26330","ListPrice":"259900","LivingArea":"1245","Longitude":"-93.1126925906","LotSizeDimensions":"Common","LotSizeSquareFeet":"1306.8","LotSizeUnits":"Acres","ListingId":"NST6759063","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Summit-University","NST_OfficeBoard":"MAAR","ParcelNumber":"012823120219","GarageSpaces":"0","NST_ParkingOpen":"1","PhotosCount":"15","PostalCity":"Saint Paul","PostalCode":"55102","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Classic character meets city living in this oversized Cathedral Hill condo. Enjoy four versatile bedrooms, a generous living area, and a formal dining room with timeless details like box beams and built ins. The kitchen blends vintage charm with modern updates. Just steps from great dining and close to downtown St. Paul.","NST_RentalLicenseYN":"No","NST_Restrictions":"Mandatory Owners Assoc,Pets - Cats Allowed,Pets - Dogs Allowed,Pets - Number Limit","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4","NST_AboveGradeSqFtTotal":"1245.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"1245.0000","BuildingAreaTotal":"1245","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","SpecialListingConditions":"Real Estate Owned","AboveGradeFinishedArea":"1245","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Marshall","StreetNumber":"304","StreetNumberNumeric":"304","StreetSuffix":"Avenue","PropertySubType":"Low Rise","NST_TaxWithAssessments":"3340.0000","TaxYear":"2025","TaxAnnualAmount":"3340","UnitNumber":"5","WaterSource":"City Water/Connected","YearBuilt":"1913","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-22T01:45:03.273Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7776584\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"01_304MarshallAveapt5_2003_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/43c6ab0b-a966-4c0e-a221-c51b5f3c5913.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.423Z\",\"MediaKey\":\"6881a13ac553820e3d385257\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"03_304MarshallAveapt5_2005_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/abbda6ba-fcd8-42a1-94fd-573102345c31.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.159Z\",\"MediaKey\":\"6881a13ac553820e3d385258\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"04_304MarshallAveapt5_2006_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/9dd8c3fc-26ad-4b83-8e53-d648f4fc99d3.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.304Z\",\"MediaKey\":\"6881a13ac553820e3d385259\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"05_304MarshallAveapt5_2007_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/1ae8b319-c1b8-43a1-bcb0-ccdc18717841.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.201Z\",\"MediaKey\":\"6881a13ac553820e3d38525a\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"06_304MarshallAveapt5_2008_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/4ab5e4bd-94cc-4bba-815c-972b4e4f46a1.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.239Z\",\"MediaKey\":\"6881a13ac553820e3d38525b\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"07_304MarshallAveapt5_2011_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/89105188-e8d0-497d-8eae-a831b5be6cb2.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.242Z\",\"MediaKey\":\"6881a13ac553820e3d38525c\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"08_304MarshallAveapt5_2013_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/3c257d4a-fdf1-487d-a4f7-96407ab6bc0d.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.165Z\",\"MediaKey\":\"6881a13ac553820e3d38525d\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"09_304MarshallAveapt5_2016_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/32062bc7-434e-4f64-acc9-33ea7b5f69f5.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.187Z\",\"MediaKey\":\"6881a13ac553820e3d38525e\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"10_304MarshallAveapt5_2019_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/f897cec9-2a4f-4c43-a99f-cc9944bbd54f.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.208Z\",\"MediaKey\":\"6881a13ac553820e3d38525f\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"11_304MarshallAveapt5_2021_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/68811aca-adbf-4f1a-9da0-2560db5f0f09.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.203Z\",\"MediaKey\":\"6881a13ac553820e3d385260\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"12_304MarshallAveapt5_2023_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/995c3e79-ed3c-4d4c-819f-b7cc639ee6c3.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.269Z\",\"MediaKey\":\"6881a13ac553820e3d385261\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"14_304MarshallAveapt5_2027_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/bb667c87-3f9c-4c4e-b5fb-25e1163412e7.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.142Z\",\"MediaKey\":\"6881a13ac553820e3d385262\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"15_304MarshallAveapt5_2028_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/fa09e542-7a20-4f95-8c78-8e2fa10df851.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.143Z\",\"MediaKey\":\"6881a13ac553820e3d385263\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"02_304MarshallAveapt5_2004_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/a94195bb-9980-4cfc-9af7-6cf94591adf8.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.157Z\",\"MediaKey\":\"6881a13ac553820e3d385264\"},{\"ResourceRecordKey\":\"NST7776584\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"13_304MarshallAveapt5_2026_Large.jpg\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7776584/9a13e508-a3b9-4ab1-8819-71f60ad33e1a.jpeg\",\"MediaModificationTimestamp\":\"2025-07-24T02:58:02.165Z\",\"MediaKey\":\"6881a13ac553820e3d385265\"}]","PhotosChangeTimestamp":"2025-07-24T02:58:05.332Z","Rooms":"[{\"RoomKey\":\"NST115441095\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115441096\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115441098\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8x12\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115441099\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x9\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115441100\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8x12.5\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115441101\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x14\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115441102\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9x10\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"01_304MarshallAveapt5_2003_Large.jpg\"},{\"Order\":2,\"Remarks\":\"03_304MarshallAveapt5_2005_Large.jpg\"},{\"Order\":3,\"Remarks\":\"04_304MarshallAveapt5_2006_Large.jpg\"},{\"Order\":4,\"Remarks\":\"05_304MarshallAveapt5_2007_Large.jpg\"},{\"Order\":5,\"Remarks\":\"06_304MarshallAveapt5_2008_Large.jpg\"},{\"Order\":6,\"Remarks\":\"07_304MarshallAveapt5_2011_Large.jpg\"},{\"Order\":7,\"Remarks\":\"08_304MarshallAveapt5_2013_Large.jpg\"},{\"Order\":8,\"Remarks\":\"09_304MarshallAveapt5_2016_Large.jpg\"},{\"Order\":9,\"Remarks\":\"10_304MarshallAveapt5_2019_Large.jpg\"},{\"Order\":10,\"Remarks\":\"11_304MarshallAveapt5_2021_Large.jpg\"},{\"Order\":11,\"Remarks\":\"12_304MarshallAveapt5_2023_Large.jpg\"},{\"Order\":12,\"Remarks\":\"14_304MarshallAveapt5_2027_Large.jpg\"},{\"Order\":13,\"Remarks\":\"15_304MarshallAveapt5_2028_Large.jpg\"},{\"Order\":14,\"Remarks\":\"02_304MarshallAveapt5_2004_Large.jpg\"},{\"Order\":15,\"Remarks\":\"13_304MarshallAveapt5_2026_Large.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}