mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About
- Pelican Lake
- Ossawinnamakee Lake
- Horseshoe Lake
- Advanced Search
- Daily Hotsheets
- Buyers
- Sellers
- Estimate Request
- Popular Listings
- Favorite Listings
- Pelican Lakes Association
- Conservation Club
- DNR Lake Information
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
Edina Realty, Inc. is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":557706,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7063245","MLSAGENTID":"NST506019622","MLSOFFICEID":"NST8106","ADDRESS":"342 Front Avenue","ACRES":0.186,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Partially Finished","BATHSTOTAL":1.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":235000.0,"LASTPRICEDATE":"2026-05-15T15:19:06.003","LATITUDE":44.969945,"LENDEROWNED":"No","LISTDATE":"2026-05-15T05:00:00","LISTPRICE":235000.0,"LIVINGAREA":1182.0,"LONGITUDE":-93.114603,"MODIFICATIONTIMESTAMP":"2026-05-15T16:47:07.826","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":41,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to Front Avenue! Built in 1892 this home offers solid, sound construction and classic details waiting for your vision. With 4-beds, 1-bath this home features an oversized two-car detached garage perfect for vehicles, a workshop, or extra storage. With original bones you can customize finishes, layout, and systems to make it truly yours while preserving the home’s sturdy, character-filled structure. Spacious lot and close to neighborhood amenities. Bring your ideas and transform this sturdy vintage home into a modern, personalized retreat.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-15T15:19:06.003","LASTSTATUS":"Active","STREETNAME":"Front","STREETNUMBER":"342","STREETSUFFIX":"Avenue","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1892,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-05-15T15:19:06.003","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Street view from Front Avenue\"},{\"Order\":4,\"Remarks\":\"Street view from Front Avenue; driveway access to oversized garage from the street!\"},{\"Order\":5,\"Remarks\":\"Front Entry\"},{\"Order\":6,\"Remarks\":\"Main level living space\"},{\"Order\":7,\"Remarks\":\"Main level living space\"},{\"Order\":8,\"Remarks\":\"Main level living space\"},{\"Order\":9,\"Remarks\":\"Main level living space flows into flex space that could be used for dedicated dining\"},{\"Order\":10,\"Remarks\":\"Potential dining space flows from living space to kitchen\"},{\"Order\":11,\"Remarks\":\"flex/dining space and main level full bath\"},{\"Order\":12,\"Remarks\":\"Large kitchen, great potential for customization\"},{\"Order\":13,\"Remarks\":\"Kitchen overview\"},{\"Order\":14,\"Remarks\":\"Kitchen\"},{\"Order\":15,\"Remarks\":\"Kitchen flows into addition that could be used as main floor bedroom or flex living space\"},{\"Order\":16,\"Remarks\":\"Main floor bed/living space with access right to the back patio\"},{\"Order\":20,\"Remarks\":\"Full bathroom located on the main floor\"},{\"Order\":21,\"Remarks\":\"Second Floor Bedroom 1\"},{\"Order\":24,\"Remarks\":\"Second Floor Bedroom 2\"},{\"Order\":26,\"Remarks\":\"Second Floor Flex space\"},{\"Order\":27,\"Remarks\":\"342 Front Avenue - Spacecrafting - 0028.jpg\"},{\"Order\":29,\"Remarks\":\"Second Floor Bedroom 3\"},{\"Order\":30,\"Remarks\":\"342 Front Avenue - Spacecrafting - 0030.jpg\"},{\"Order\":31,\"Remarks\":\"Basement\"},{\"Order\":32,\"Remarks\":\"Basement - Laundry\"},{\"Order\":33,\"Remarks\":\"Deck with accessible ramp attached\"},{\"Order\":36,\"Remarks\":\"Back yard\"},{\"Order\":37,\"Remarks\":\"Backyard view of detached garage/shop\"},{\"Order\":38,\"Remarks\":\"Detached garage, hidden potential\"},{\"Order\":39,\"Remarks\":\"Oversized two-car garage with workbench and storage\"},{\"Order\":40,\"Remarks\":\"Customize your garage shop\"},{\"Order\":41,\"Remarks\":\"Oversized garage from shop point of view\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41","SOURCE":"MG_NST"}
{"ListingKey":"NST7892204","NST_AboveGradeSqFtTotal":"1182","AboveGradeFinishedArea":"1182","AccessibilityFeatures":"Wheelchair Ramp(s)","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Partially Finished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"624","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","Directions":"From I-94 take Marion St Exit to Como/ Head west on Como Avenue to Western Avenue N/ Take a right on Western Avenue N and a right on Front Avenue at the stop sign","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-05-15T16:47:07.826Z","DaysOnMarket":"0","Fencing":"Chain Link","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"624","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"480","NST_GarageDoorWidth":"9","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.969945","NST_LenderOwned":"No","Levels":"Two","ListPrice":"235000","ListingContractDate":"2026-05-15T05:00:00Z","ListingId":"NST7063245","LivingArea":"1182","LockBoxType":"Supra","Longitude":"-93.114603","LotSizeArea":"0.186","LotSizeDimensions":"65x125","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"720","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"97","OriginalEntryTimestamp":"2026-05-15T09:10:32Z","ParcelNumber":"252923420040","ParkingFeatures":"Detached Garage,Asphalt","PhotosCount":"41","PhotosChangeTimestamp":"2026-05-15T15:19:06.003Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome to Front Avenue! Built in 1892 this home offers solid, sound construction and classic details waiting for your vision. With 4-beds, 1-bath this home features an oversized two-car detached garage perfect for vehicles, a workshop, or extra storage. With original bones you can customize finishes, layout, and systems to make it truly yours while preserving the home’s sturdy, character-filled structure. Spacious lot and close to neighborhood amenities. Bring your ideas and transform this sturdy vintage home into a modern, personalized retreat.","PublicSurveyRange":"23","PublicSurveySection":"25","PublicSurveyTownship":"29","RoadFrontageType":"City Street","Roof":"Age Over 8 Years","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Front","StreetNumber":"342","StreetNumberNumeric":"342","StreetSuffix":"Avenue","SubdivisionName":"Front St Second Addition, To S","TaxAnnualAmount":"2702","NST_TaxWithAssessments":"2702","TaxYear":"2025","BuildingAreaTotal":"1806","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1892","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST507869","ListAgentMlsId":"NST506019622","ListOfficeMlsId":"NST8106","ListOfficeName":"Edina Realty, Inc.","ListOfficeKey":"NST16441","ModificationTimestamp":"2026-05-15T16:47:07.826Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/97ff9e6a-62ef-4acb-a7c5-750d915ab790.jpeg\",\"Order\":28,\"MediaObjectID\":\"NST28\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.273Z\",\"MediaKey\":\"NST122224579\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Oversized garage from shop point of view\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/e5eee387-7a68-4687-822a-2c0241f0cbd2.jpeg\",\"Order\":41,\"MediaObjectID\":\"NST41\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.285Z\",\"MediaKey\":\"NST122224562\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Potential dining space flows from living space to kitchen\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/1bfeda44-e2cf-4afc-bdfe-76bc6fa9ce47.jpeg\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224593\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Kitchen\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/4a9582d5-67a0-451b-b2f3-fb75b5d388cb.jpeg\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.257Z\",\"MediaKey\":\"NST122224589\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Large kitchen, great potential for customization\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/2d2e1fa4-43db-4a64-b86a-b61295a49c68.jpeg\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.284Z\",\"MediaKey\":\"NST122224591\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Deck with accessible ramp attached\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/9a6dbbdf-2285-4f63-93a3-0b076741d355.jpeg\",\"Order\":33,\"MediaObjectID\":\"NST33\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.295Z\",\"MediaKey\":\"NST122224570\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Basement\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/747a989e-9bd5-4b74-bb17-3ec4004ecad4.jpeg\",\"Order\":31,\"MediaObjectID\":\"NST31\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224572\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Second Floor Bedroom 3\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/5123e69c-7cab-41a4-a36c-ce4905f2b26f.jpeg\",\"Order\":29,\"MediaObjectID\":\"NST29\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224574\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Full bathroom located on the main floor\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/b1d7f5a3-073a-4b0b-929d-d859fc7c9e89.jpeg\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.286Z\",\"MediaKey\":\"NST122224583\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/5cef7c7f-a31b-4c9f-a091-f4c18d3211a6.jpeg\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.273Z\",\"MediaKey\":\"NST122224581\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"342 Front Avenue - Spacecrafting - 0030.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/bfbf1031-7f3f-46b8-8b70-314de05b8f32.jpeg\",\"Order\":30,\"MediaObjectID\":\"NST30\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224573\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Second Floor Bedroom 2\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/a05d113c-33ca-4653-809d-7256eb33c4ee.jpeg\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.257Z\",\"MediaKey\":\"NST122224578\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/1b74f05b-a92b-461e-a1e2-3796184e22d4.jpeg\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.277Z\",\"MediaKey\":\"NST122224584\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Kitchen flows into addition that could be used as main floor bedroom or flex living space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/612ef031-e211-4b7e-b8c9-8714296f208b.jpeg\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.266Z\",\"MediaKey\":\"NST122224588\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/8f560736-a1fa-4271-be5e-de83f8fd4cbe.jpeg\",\"Order\":34,\"MediaObjectID\":\"NST34\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.28Z\",\"MediaKey\":\"NST122224569\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"342 Front Avenue - Spacecrafting - 0028.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/0bdfc07f-4eec-41b1-a2db-c4aa7a27313c.jpeg\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.273Z\",\"MediaKey\":\"NST122224575\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Customize your garage shop\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/d0cdd080-ecc4-4d59-81be-9532aa8b5235.jpeg\",\"Order\":40,\"MediaObjectID\":\"NST40\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.281Z\",\"MediaKey\":\"NST122224563\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Basement - Laundry\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/08a994bb-a040-45ad-bc6b-7ef0369e0e7e.jpeg\",\"Order\":32,\"MediaObjectID\":\"NST32\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.285Z\",\"MediaKey\":\"NST122224571\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Second Floor Flex space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/44ae878a-d361-4db8-92dd-3c297f7081f2.jpeg\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.261Z\",\"MediaKey\":\"NST122224576\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/b23ecf70-c9b4-46e4-9db0-008814a627be.jpeg\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.251Z\",\"MediaKey\":\"NST122224577\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/703ff587-e6b6-4f03-ab56-f2018c12a002.jpeg\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.331Z\",\"MediaKey\":\"NST122224600\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Backyard view of detached garage/shop\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/478c1023-ca7e-424e-9632-18ef7ba3bd3e.jpeg\",\"Order\":37,\"MediaObjectID\":\"NST37\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.28Z\",\"MediaKey\":\"NST122224566\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/0ef342bf-83a8-4dc8-bcc4-63948819797d.jpeg\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.261Z\",\"MediaKey\":\"NST122224585\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Main level living space flows into flex space that could be used for dedicated dining\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/03ba3a15-b9e5-4b4a-960b-45eec7d3a0e9.jpeg\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224596\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"flex/dining space and main level full bath\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/88740158-8db2-488d-8774-95477515330c.jpeg\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.266Z\",\"MediaKey\":\"NST122224592\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Detached garage, hidden potential\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/8d5b23da-4259-4e09-af15-1cd43b1cbda7.jpeg\",\"Order\":38,\"MediaObjectID\":\"NST38\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.282Z\",\"MediaKey\":\"NST122224565\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/c0f6f8a9-c9d8-4a18-ad8d-346893288250.jpeg\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.257Z\",\"MediaKey\":\"NST122224580\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Back yard\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/59fa87dc-8e90-4c55-9829-92595f9fb2e6.jpeg\",\"Order\":36,\"MediaObjectID\":\"NST36\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.28Z\",\"MediaKey\":\"NST122224567\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/0e44eb9b-1542-4213-b53a-d228788324dc.jpeg\",\"Order\":35,\"MediaObjectID\":\"NST35\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224568\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Main level living space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/d710468c-e971-4e6e-b528-993422c5de55.jpeg\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.277Z\",\"MediaKey\":\"NST122224595\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Street view from Front Avenue; driveway access to oversized garage from the street!\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/8bb6937b-e150-48b8-9699-d3581d704908.jpeg\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.281Z\",\"MediaKey\":\"NST122224599\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Oversized two-car garage with workbench and storage\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/378312bd-9231-4d56-9553-db520807d41a.jpeg\",\"Order\":39,\"MediaObjectID\":\"NST39\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.266Z\",\"MediaKey\":\"NST122224564\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Front Entry\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/f83b6652-4226-4a27-a307-501835af377a.jpeg\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.271Z\",\"MediaKey\":\"NST122224598\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Main floor bed/living space with access right to the back patio\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/594a1c3c-2286-4b50-b347-5ac706d20699.jpeg\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.266Z\",\"MediaKey\":\"NST122224587\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Second Floor Bedroom 1\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/78309d33-b34f-48b3-94e8-8a5d83f9ba7e.jpeg\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.25Z\",\"MediaKey\":\"NST122224582\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/1cbadbb9-9bfd-4751-be82-e44d8444ee34.jpeg\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.266Z\",\"MediaKey\":\"NST122224586\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Main level living space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/f14f65a4-3cbe-4e85-85ba-5728cff50393.jpeg\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.277Z\",\"MediaKey\":\"NST122224594\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Street view from Front Avenue\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/bcfdab0f-1cea-4bcd-aab5-075341d3c9cf.jpeg\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.296Z\",\"MediaKey\":\"NST122224602\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Kitchen overview\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/05cda28f-1fac-4a78-9617-a925f333327f.jpeg\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.275Z\",\"MediaKey\":\"NST122224590\"},{\"ResourceRecordKey\":\"NST7892204\",\"LongDescription\":\"Main level living space\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/7bc6b070-be69-4a2e-a999-a51634b66cc8.jpeg\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.292Z\",\"MediaKey\":\"NST122224597\"},{\"ResourceRecordKey\":\"NST7892204\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7892204/c9a616a9-03c0-4f13-b6e4-39ed2b351467.jpeg\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-05-15T14:11:24.298Z\",\"MediaKey\":\"NST122224634\"}]","Media__ResourceRecordKey":"NST7892204","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7892204/97ff9e6a-62ef-4acb-a7c5-750d915ab790.jpeg","Media__Order":"28","Media__MediaObjectID":"NST28","Media__ImageWidth":"1920","Media__ImageHeight":"1280","Media__ImageSizeDescription":"1920x1280","Media__MediaModificationTimestamp":"5/15/2026 2:11:24 PM","Media__MediaKey":"NST122224579","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Street view from Front Avenue\"},{\"Order\":4,\"Remarks\":\"Street view from Front Avenue; driveway access to oversized garage from the street!\"},{\"Order\":5,\"Remarks\":\"Front Entry\"},{\"Order\":6,\"Remarks\":\"Main level living space\"},{\"Order\":7,\"Remarks\":\"Main level living space\"},{\"Order\":8,\"Remarks\":\"Main level living space\"},{\"Order\":9,\"Remarks\":\"Main level living space flows into flex space that could be used for dedicated dining\"},{\"Order\":10,\"Remarks\":\"Potential dining space flows from living space to kitchen\"},{\"Order\":11,\"Remarks\":\"flex/dining space and main level full bath\"},{\"Order\":12,\"Remarks\":\"Large kitchen, great potential for customization\"},{\"Order\":13,\"Remarks\":\"Kitchen overview\"},{\"Order\":14,\"Remarks\":\"Kitchen\"},{\"Order\":15,\"Remarks\":\"Kitchen flows into addition that could be used as main floor bedroom or flex living space\"},{\"Order\":16,\"Remarks\":\"Main floor bed/living space with access right to the back patio\"},{\"Order\":20,\"Remarks\":\"Full bathroom located on the main floor\"},{\"Order\":21,\"Remarks\":\"Second Floor Bedroom 1\"},{\"Order\":24,\"Remarks\":\"Second Floor Bedroom 2\"},{\"Order\":26,\"Remarks\":\"Second Floor Flex space\"},{\"Order\":27,\"Remarks\":\"342 Front Avenue - Spacecrafting - 0028.jpg\"},{\"Order\":29,\"Remarks\":\"Second Floor Bedroom 3\"},{\"Order\":30,\"Remarks\":\"342 Front Avenue - Spacecrafting - 0030.jpg\"},{\"Order\":31,\"Remarks\":\"Basement\"},{\"Order\":32,\"Remarks\":\"Basement - Laundry\"},{\"Order\":33,\"Remarks\":\"Deck with accessible ramp attached\"},{\"Order\":36,\"Remarks\":\"Back yard\"},{\"Order\":37,\"Remarks\":\"Backyard view of detached garage/shop\"},{\"Order\":38,\"Remarks\":\"Detached garage, hidden potential\"},{\"Order\":39,\"Remarks\":\"Oversized two-car garage with workbench and storage\"},{\"Order\":40,\"Remarks\":\"Customize your garage shop\"},{\"Order\":41,\"Remarks\":\"Oversized garage from shop point of view\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41","CustomVTourURL":""}
$MLSDESCRIPTION$
342 Front Avenue Saint Paul, MN 55117
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
342 Front Avenue Saint Paul, MN 55117
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$