42 Front Avenue Saint Paul, MN 55117

Features

Features

Property Features

JPW Realty is not a Multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of JPW Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc. Information Deemed Reliable But Not Guaranteed.
© 2020 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.
RMLS DMCA Notice

NorthstarMLS® data last updated at July 23, 2020 7:53 PM CT

Real Estate IDX Powered by iHomefinder

{"Id":1392930,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6768136","MLSAGENTID":"NST502054171","MLSOFFICEID":"NST26011","ADDRESS":"42 Front Avenue","ACRES":0.09,"AGENTOWNER":true,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":2.0,"BEDROOMS":5,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":235500.0,"LASTPRICEDATE":"2025-08-07T17:15:04.283","LATITUDE":44.97006355,"LENDEROWNED":"No","LISTDATE":"2025-08-07T05:00:00","LISTPRICE":235500.0,"LIVINGAREA":1826.0,"LONGITUDE":-93.10194297,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Some Trees","MODIFICATIONTIMESTAMP":"2025-08-07T17:23:04.497","NEIGHBORHOOD":"North End","OFFICE_OFFICENAME":"JPW Realty","PHOTOCOUNT":18,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to 42 Front Avenue W - a beautifully updated home in the heart of St. Paul! This move-in ready property blends timeless charm with modern updates throughout. The spacious main floor features a sun-filled living room, formal dining area, and a fully renovated kitchen with stainless steel appliances and stylish cabinetry. Fresh paint, updated flooring, and clean, neutral tones carry throughout the home. With five total bedrooms - including one on the main level and four upstairs, there's plenty of space for family, guests, or a home office. Both bathrooms have been refreshed with tasteful finishes. The fully fenced backyard offers room to play, garden, or entertain.\n\nLocated close to Como Park and Zoo, this home offers the perfect balance of charm, space, and location - close to local shops, schools, and commuter routes. Don't miss it!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-07T17:15:04.283","LASTSTATUS":"Active","STREETNAME":"Front","STREETNUMBER":"42","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1890,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-08-07T17:22:05.317","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"1-web-or-mls-42 Front Ave W-28.jpeg\"},{\"Order\":2,\"Remarks\":\"6-web-or-mls-42-Front-Ave-W-04 - Living Room - Scandinavian - 6.jpeg\"},{\"Order\":3,\"Remarks\":\"14-web-or-mls-42 Front Ave W-08.jpeg\"},{\"Order\":4,\"Remarks\":\"11-web-or-mls-42-Front-Ave-W-07 - Dining Room - Scandinavian - 0.jpeg\"},{\"Order\":5,\"Remarks\":\"10-web-or-mls-42 Front Ave W-06.jpeg\"},{\"Order\":6,\"Remarks\":\"18-web-or-mls-42 Front Ave W-12.jpeg\"},{\"Order\":7,\"Remarks\":\"19-web-or-mls-42 Front Ave W-13.jpeg\"},{\"Order\":8,\"Remarks\":\"21-web-or-mls-42 Front Ave W-15.jpeg\"},{\"Order\":9,\"Remarks\":\"20-web-or-mls-42 Front Ave W-14.jpeg\"},{\"Order\":10,\"Remarks\":\"24-web-or-mls-42-Front-Ave-W-17 - Bedroom - Scandinavian - 15.jpeg\"},{\"Order\":11,\"Remarks\":\"26-web-or-mls-42 Front Ave W-18.jpeg\"},{\"Order\":12,\"Remarks\":\"22-web-or-mls-42 Front Ave W-16.jpeg\"},{\"Order\":13,\"Remarks\":\"27-web-or-mls-42 Front Ave W-19.jpeg\"},{\"Order\":14,\"Remarks\":\"28-web-or-mls-42 Front Ave W-20.jpeg\"},{\"Order\":15,\"Remarks\":\"30-web-or-mls-42 Front Ave W-22.jpeg\"},{\"Order\":16,\"Remarks\":\"29-web-or-mls-42 Front Ave W-21.jpeg\"},{\"Order\":17,\"Remarks\":\"34-web-or-mls-42 Front Ave W-26.jpeg\"},{\"Order\":18,\"Remarks\":\"35-web-or-mls-42 Front Ave W-27.jpeg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}