MLS# 7017571 - 593 Front Avenue Saint Paul, MN 55117

Neighborhoods

Lentsch Company is the brokerage office representing the seller for this listing.

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. Bay Lake Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Bay Lake Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":516257,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7017571","MLSAGENTID":"NST506000333","MLSOFFICEID":"NST8192","ADDRESS":"593 Front Avenue","ACRES":0.137,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":2.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":194900.0,"LASTPRICEDATE":"2026-03-15T16:50:05.73","LATITUDE":44.97041,"LENDEROWNED":"No","LISTDATE":"2026-02-05T06:00:00","LISTPRICE":184900.0,"LIVINGAREA":1000.0,"LONGITUDE":-93.125176,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-03-15T16:50:05.73","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Lentsch Company","OUTBUILDINGS":"Garage(s)","PHOTOCOUNT":18,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Clean 2 bedroom 1.5-2 story home, centrally located in Saint Paul. Bright, open kitchen with serving counter & modern hood fan. Hardwood floors first floor. Good size Main level laundry. 2 BR’s up with extra walk-in closet / den / office type cubby area. Upgraded full bath room. Mostly fenced level back yard. 1+ car garage and additional 3-4 off street concrete parking pad spots on side. Basement good for storage or finish to future workshop / fitness areas. Central AC approx 2022. “Stones throw to ‘neighborhood node’ shopping, football toss to parks ie Como & playgrounds”","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-02-16T06:02:08.34","LASTSTATUS":"Coming Soon","STREETNAME":"Front","STREETNUMBER":"593","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1911,"ZONING":"Residential-Single Family","VIRTUALTOUR_URL1":"http://partnershipinvestmentgroup.com/re/2026/593front.html","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-02-06T04:45:05.26","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"IMG_1111.jpeg\"},{\"Order\":2,\"Remarks\":\"IMG_1112.jpeg\"},{\"Order\":3,\"Remarks\":\"IMG_1123.jpeg\"},{\"Order\":4,\"Remarks\":\"IMG_1122.jpeg\"},{\"Order\":5,\"Remarks\":\"IMG_1115.jpeg\"},{\"Order\":6,\"Remarks\":\"IMG_1117.jpeg\"},{\"Order\":7,\"Remarks\":\"IMG_1118.jpeg\"},{\"Order\":8,\"Remarks\":\"IMG_1119.jpeg\"},{\"Order\":9,\"Remarks\":\"IMG_1120.jpeg\"},{\"Order\":10,\"Remarks\":\"IMG_1116.jpeg\"},{\"Order\":11,\"Remarks\":\"IMG_1126.jpeg\"},{\"Order\":12,\"Remarks\":\"IMG_1128.jpeg\"},{\"Order\":13,\"Remarks\":\"IMG_1127.jpeg\"},{\"Order\":14,\"Remarks\":\"IMG_1125.jpeg\"},{\"Order\":15,\"Remarks\":\"IMG_1129.jpeg\"},{\"Order\":16,\"Remarks\":\"IMG_1130.jpeg\"},{\"Order\":17,\"Remarks\":\"IMG_1113.jpeg\"},{\"Order\":18,\"Remarks\":\"IMG_1121.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}

MLS# 7017571 - 593 Front Avenue Saint Paul, MN 55117

$BTITLE$