{"Id":600033,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7126771","MLSAGENTID":"NST506005698","MLSOFFICEID":"NST9995","ADDRESS":"318 Front Avenue","ACRES":0.15,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Daylight/Lookout Windows,Finished","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":225000.0,"LASTPRICEDATE":"2026-08-27T14:48:07.347","LATITUDE":44.970063,"LENDEROWNED":"No","LISTDATE":"2026-08-13T05:00:00","LISTPRICE":220000.0,"LIVINGAREA":1664.0,"LONGITUDE":-93.113268,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Corner Lot,Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-08-27T14:48:07.346","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Keller Williams Premier Realty","PHOTOCOUNT":20,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to this charming rambler in the North End of St. Paul, perfectly situated on a desirable corner lot with an oversized yard offering plenty of room to relax, play, garden, or entertain. The main level features two bedrooms, along with a spacious formal dining room that offers excellent flexibility and could easily serve as a third bedroom, home office, or additional living space. The finished lower level provides even more room to spread out, including a non-conforming bedroom that could be ideal for guests, a home office, hobby space, or recreation area. With a functional layout, generous yard, and flexible living spaces, this home offers a wonderful opportunity to make it your own in a convenient North End location.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-17T05:03:12.033","LASTSTATUS":"Coming Soon","STREETNAME":"Front","STREETNUMBER":"318","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1941,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-08-26T22:47:06.943","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"318 Front Ave\"},{\"Order\":2,\"Remarks\":\"side entrance\"},{\"Order\":3,\"Remarks\":\"back entrance\"},{\"Order\":4,\"Remarks\":\"backyard\"},{\"Order\":5,\"Remarks\":\"living room\"},{\"Order\":6,\"Remarks\":\"dining room\"},{\"Order\":7,\"Remarks\":\"main level full bath with jacuzzi tub\"},{\"Order\":8,\"Remarks\":\"Main level bedroom\"},{\"Order\":9,\"Remarks\":\"main level bedroom 2\"},{\"Order\":10,\"Remarks\":\"basement family room\"},{\"Order\":11,\"Remarks\":\"basement fireplace\"},{\"Order\":12,\"Remarks\":\"basement family room\"},{\"Order\":13,\"Remarks\":\"basement non-conforming bedroom.jpeg\"},{\"Order\":14,\"Remarks\":\"basement landry room\"},{\"Order\":15,\"Remarks\":\"backyard patio area\"},{\"Order\":16,\"Remarks\":\"backyard\"},{\"Order\":17,\"Remarks\":\"garden area\"},{\"Order\":18,\"Remarks\":\"shed 10x24 for sale separately\"},{\"Order\":19,\"Remarks\":\"shed with front porch- for sale separately\"},{\"Order\":20,\"Remarks\":\"shed for sale separately - insulated\"}]","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":"NST7950587","NST_AboveGradeSqFtTotal":"1064","AboveGradeFinishedArea":"1064","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Main Floor Primary Bedroom","Appliances":"Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Yes","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Daylight/Lookout Windows,Finished","BasementYN":"True","NST_BathDesc":"1/2 Basement,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1064","BelowGradeFinishedArea":"600","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"Start on Rice St. and go West on Front Ave. to home.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-08-26T22:49:07.729Z","DaysOnMarket":"0","Electric":"Circuit Breakers","NST_ExpectedMarketDate":"2026-08-17","ExteriorFeatures":"Stucco","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1064","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"600","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.970063","LaundryFeatures":"In Basement","NST_LenderOwned":"No","Levels":"One","ListPrice":"220000","ListingContractDate":"2026-08-13T05:00:00Z","ListingId":"NST7126771","LivingArea":"1664","LockBoxType":"Supra","Longitude":"-93.113268","LotFeatures":"Public Transit (w/in 6 blks),Corner Lot,Tree Coverage - Light","LotSizeArea":"0.15","LotSizeDimensions":"98x67","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1064","NST_ManufacturedHome":"N","NST_NeighborhoodName":"North End","NST_NeighborhoodNumber":"97","OriginalEntryTimestamp":"2026-08-17T00:00:19Z","ParcelNumber":"252923420224","ParkingFeatures":"Detached Garage","PhotosCount":"20","PhotosChangeTimestamp":"2026-08-26T22:47:06.943Z","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to this charming rambler in the North End of St. Paul, perfectly situated on a desirable corner lot with an oversized yard offering plenty of room to relax, play, garden, or entertain. The main level features two bedrooms, along with a spacious formal dining room that offers excellent flexibility and could easily serve as a third bedroom, home office, or additional living space. The finished lower level provides even more room to spread out, including a non-conforming bedroom that could be ideal for guests, a home office, hobby space, or recreation area. With a functional layout, generous yard, and flexible living spaces, this home offers a wonderful opportunity to make it your own in a convenient North End location.","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"29","RoadFrontageType":"City Street,Paved Streets,Sidewalks","RoadResponsibility":"Public Maintained Road","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Front","StreetNumber":"318","StreetNumberNumeric":"318","StreetSuffix":"Avenue","SubdivisionName":"Matz Sub Of Lt 11, , Wi","TaxAnnualAmount":"3914.5","NST_TaxWithAssessments":"4416","TaxYear":"2026","NST_TotalArea":"2128","BuildingAreaTotal":"2128","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1941","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST88817","ListAgentMlsId":"NST506005698","ListOfficeMlsId":"NST9995","ListOfficeName":"Keller Williams Premier Realty","ListOfficeKey":"NST16762","ModificationTimestamp":"2026-08-27T14:48:07.346Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/6bae162c-42cc-4d97-ae6d-3ed359abdf13.jpeg\",\"LongDescription\":\"basement non-conforming bedroom.jpeg\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.176Z\",\"MediaKey\":\"NST124431221\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/3f6b715f-743c-46ed-8604-5d70db709d74.jpeg\",\"LongDescription\":\"backyard\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:00:05.491Z\",\"MediaKey\":\"NST124431225\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/ffb3f04b-fa74-4eef-8652-0fcec9a52080.jpeg\",\"LongDescription\":\"main level full bath with jacuzzi tub\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.19Z\",\"MediaKey\":\"NST124431216\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/335f4de7-f638-4d1f-92bf-3a4f5a108740.jpeg\",\"LongDescription\":\"shed for sale separately - insulated\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.19Z\",\"MediaKey\":\"NST124431209\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/bf3a0b5f-e492-4ab7-8bba-0e63402eb176.jpeg\",\"LongDescription\":\"main level bedroom 2\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.18Z\",\"MediaKey\":\"NST124431217\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/9b7211f1-2636-4aa9-8abd-23dc5b63b459.jpeg\",\"LongDescription\":\"shed 10x24 for sale separately\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:01:06.396Z\",\"MediaKey\":\"NST124431211\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/24427bd5-54bb-49f0-bc9c-33e682081ef8.jpeg\",\"LongDescription\":\"dining room\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.183Z\",\"MediaKey\":\"NST124431224\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/8889db9e-bef0-45f5-935b-954034a07f99.jpeg\",\"LongDescription\":\"garden area\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:01:06.396Z\",\"MediaKey\":\"NST124431212\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/77d5071c-dcb0-4525-ab84-389ea86cfea5.jpeg\",\"LongDescription\":\"basement family room\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.181Z\",\"MediaKey\":\"NST124431219\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/6bc3501f-d17c-4cbf-9593-71a237ad788e.jpeg\",\"LongDescription\":\"side entrance\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":640,\"ImageHeight\":566,\"ImageSizeDescription\":\"640x566\",\"MediaModificationTimestamp\":\"2026-08-26T22:47:06.72Z\",\"MediaKey\":\"NST124431227\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/7014bdca-d59d-467d-a26e-7ba727d44821.jpeg\",\"LongDescription\":\"living room\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.18Z\",\"MediaKey\":\"NST124431215\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/2ac170ed-f310-4667-be58-2b5f0fe0db64.jpeg\",\"LongDescription\":\"Main level bedroom\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.199Z\",\"MediaKey\":\"NST124431218\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/3c015e8f-ed7d-4c53-9ce3-4e5f1e56b15a.jpeg\",\"LongDescription\":\"basement family room\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.181Z\",\"MediaKey\":\"NST124431223\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/2bbba574-555d-4745-8f05-a41917b34049.jpeg\",\"LongDescription\":\"backyard patio area\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:01:06.396Z\",\"MediaKey\":\"NST124431214\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/e58ee8de-5232-470f-8531-3cfc4bab6d12.jpeg\",\"LongDescription\":\"shed with front porch- for sale separately\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:01:06.396Z\",\"MediaKey\":\"NST124431210\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/288686cb-4113-4105-ae35-c1ea2e892732.jpeg\",\"LongDescription\":\"basement landry room\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.187Z\",\"MediaKey\":\"NST124431220\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/c6c7f302-3593-432b-a7de-4b162678cbe2.jpeg\",\"LongDescription\":\"backyard\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:01:06.418Z\",\"MediaKey\":\"NST124431213\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/c4905a80-8983-49e7-8e90-db2438b488d4.jpeg\",\"LongDescription\":\"back entrance\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T18:59:06.898Z\",\"MediaKey\":\"NST124431226\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/0a57eeb1-0068-4e24-bdeb-6dfdc27888ba.jpeg\",\"LongDescription\":\"basement fireplace\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":480,\"ImageHeight\":640,\"ImageSizeDescription\":\"480x640\",\"MediaModificationTimestamp\":\"2026-08-23T19:02:08.193Z\",\"MediaKey\":\"NST124431222\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7950587/9231dd4f-2dcf-4d89-80f1-6757ad1515c2.jpeg\",\"LongDescription\":\"318 Front Ave\",\"ResourceRecordKey\":\"NST7950587\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1206,\"ImageHeight\":1011,\"ImageSizeDescription\":\"1206x1011\",\"MediaModificationTimestamp\":\"2026-08-26T22:47:06.773Z\",\"MediaKey\":\"NST124254451\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7950587/6bae162c-42cc-4d97-ae6d-3ed359abdf13.jpeg","Media__LongDescription":"basement non-conforming bedroom.jpeg","Media__ResourceRecordKey":"NST7950587","Media__Order":"13","Media__MediaObjectID":"NST13","Media__ImageWidth":"480","Media__ImageHeight":"640","Media__ImageSizeDescription":"480x640","Media__MediaModificationTimestamp":"8/23/2026 7:02:08 PM","Media__MediaKey":"NST124431221","Rooms":"[{\"RoomKey\":\"NST116565293\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\"},{\"RoomKey\":\"NST116565295\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom\"},{\"RoomKey\":\"NST116565294\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Kitchen\"},{\"RoomKey\":\"NST116565298\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Laundry\"},{\"RoomKey\":\"NST116565292\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\"},{\"RoomKey\":\"NST116565296\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 2\"},{\"RoomKey\":\"NST116565297\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomKey":"NST116565293","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"318 Front Ave\"},{\"Order\":2,\"Remarks\":\"side entrance\"},{\"Order\":3,\"Remarks\":\"back entrance\"},{\"Order\":4,\"Remarks\":\"backyard\"},{\"Order\":5,\"Remarks\":\"living room\"},{\"Order\":6,\"Remarks\":\"dining room\"},{\"Order\":7,\"Remarks\":\"main level full bath with jacuzzi tub\"},{\"Order\":8,\"Remarks\":\"Main level bedroom\"},{\"Order\":9,\"Remarks\":\"main level bedroom 2\"},{\"Order\":10,\"Remarks\":\"basement family room\"},{\"Order\":11,\"Remarks\":\"basement fireplace\"},{\"Order\":12,\"Remarks\":\"basement family room\"},{\"Order\":13,\"Remarks\":\"basement non-conforming bedroom.jpeg\"},{\"Order\":14,\"Remarks\":\"basement landry room\"},{\"Order\":15,\"Remarks\":\"backyard patio area\"},{\"Order\":16,\"Remarks\":\"backyard\"},{\"Order\":17,\"Remarks\":\"garden area\"},{\"Order\":18,\"Remarks\":\"shed 10x24 for sale separately\"},{\"Order\":19,\"Remarks\":\"shed with front porch- for sale separately\"},{\"Order\":20,\"Remarks\":\"shed for sale separately - insulated\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}