Menu
  • Home Page
  • Featured Listings
  • Daily Hotlist
  • Map Search
  • Your Favorites
  • Quick Print
  • Contact Mark
Client Portal

MLS# 6821607
254 Idaho Avenue W Saint Paul, MN 55117

Neighborhoods

Inspire Access Realty, LLC 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. Mark Tietjen - Rusty's Up North Realty is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mark Tietjen - Rusty's Up North Realty, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":1434641,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6821607","MLSAGENTID":"NST502045774","MLSOFFICEID":"NST200128","ADDRESS":"254 Idaho Avenue W","ACRES":0.21,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Metal Siding,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":290000.0,"LASTPRICEDATE":"2025-11-25T04:25:04.587","LATITUDE":44.989778,"LENDEROWNED":"No","LISTDATE":"2025-11-24T06:00:00","LISTPRICE":290000.0,"LIVINGAREA":1864.0,"LONGITUDE":-93.110662,"LOTDESCRIPTION":"Public Transit (w/in 6 blks),Cleared,Some Trees","MODIFICATIONTIMESTAMP":"2025-11-25T11:04:05.951","NEIGHBORHOOD":"North End","OFFICE_OFFICENAME":"Inspire Access Realty, LLC","PHOTOCOUNT":7,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Updates \nFurnace 2020\nLeaf guard gutters 2020\nGranite counter tops 2018\nUpper level windows 2017\nNew Roof 2022\nProfessionally Landscaped backyard and cleared large trees up to 5k\n\nThis well maintained 1981 built home offers modern updates alongside classic charm, shopping and amenities you can enjoy.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer - In Street","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-25T04:25:04.587","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Idaho","STREETNUMBER":"254","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1981,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-25T04:50:03.77","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"PKV_1325.jpg\"},{\"Order\":2,\"Remarks\":\"PKV_1348.jpg\"},{\"Order\":3,\"Remarks\":\"PKV_1358.jpg\"},{\"Order\":4,\"Remarks\":\"PKV_1305.jpg\"},{\"Order\":5,\"Remarks\":\"PKV_1596.jpg\"},{\"Order\":6,\"Remarks\":\"PKV_1620.jpg\"},{\"Order\":7,\"Remarks\":\"PKV_1635.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7","SOURCE":"MG_NST"}
{"ListingKey":"NST7830731","LotSizeArea":"0.21","NST_AgeOfProperty":"44","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Kitchen Window","Appliances":"Gas Water Heater","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Saint Paul","PropertyType":"Residential","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"80","NST_DiningRoomDescription":"Kitchen/Dining Room,Separate/Formal Dining Room","Directions":"larpetner west to marion/south to idaho","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"100 Amp Service","ConstructionMaterials":"Metal Siding,Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"932","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street","NST_Fuel":"Electric,Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"483","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-11-25T04:23:27Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-25","Latitude":"44.989778","NST_LenderOwned":"No","ListAgentKey":"NST105325","ListAgentMlsId":"NST502045774","ListingContractDate":"2025-11-24T06:00:00Z","ListOfficeKey":"NST1000098","ListOfficeName":"Inspire Access Realty, LLC","ListOfficeMlsId":"NST200128","ListPrice":"290000","LivingArea":"1864","Longitude":"-93.110662","LotFeatures":"Public Transit (w/in 6 blks),Cleared,Some Trees","LotSizeDimensions":"100x94","LotSizeSquareFeet":"9278.28","LotSizeUnits":"Acres","ListingId":"NST6821607","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"North End","NST_OfficeBoard":"SPAAR","ParcelNumber":"242923110099","GarageSpaces":"2","NST_PatioPorchType":"Deck","PhotosCount":"7","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Updates \nFurnace 2020\nLeaf guard gutters 2020\nGranite counter tops 2018\nUpper level windows 2017\nNew Roof 2022\nProfessionally Landscaped backyard and cleared large trees up to 5k\n\nThis well maintained 1981 built home offers modern updates alongside classic charm, shopping and amenities you can enjoy.","PublicSurveyRange":"23","PublicSurveySection":"24","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Sun Room,Utility Room","NST_AboveGradeSqFtTotal":"932.0000","NST_BelowGradeSqFtTotal":"932.0000","NST_MainLevelFinishedArea":"932.0000","BuildingAreaTotal":"1864","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer - In Street","AboveGradeFinishedArea":"932","BelowGradeFinishedArea":"932","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetDirSuffix":"W","StreetName":"Idaho","StreetNumber":"254","StreetNumberNumeric":"254","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Rice Street Villas","NST_TaxWithAssessments":"0.0000","TaxYear":"2025","TaxAnnualAmount":"4352","WaterSource":"City Water - In Street","YearBuilt":"1981","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-25T11:04:05.951Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7830731\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"PKV_1325.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/863cab5c-7160-43eb-9836-b277d07306bf.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:07.496Z\",\"MediaKey\":\"69253543698aa63137d4c391\"},{\"ResourceRecordKey\":\"NST7830731\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"PKV_1348.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/82859b2d-1dde-4654-97cd-8220d216faca.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:58.591Z\",\"MediaKey\":\"69253576ed3d045c3f30cc96\"},{\"ResourceRecordKey\":\"NST7830731\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"PKV_1358.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/da444c45-9c52-4073-80cb-cd47a86a42b0.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:58.572Z\",\"MediaKey\":\"69253576ed3d045c3f30cc97\"},{\"ResourceRecordKey\":\"NST7830731\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"PKV_1305.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/e90ed1f9-e7df-4b71-80ca-4be3a5d136b5.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:58.589Z\",\"MediaKey\":\"69253576ed3d045c3f30cc98\"},{\"ResourceRecordKey\":\"NST7830731\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"PKV_1596.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/f92a7a2c-a6c1-46b2-a1fd-320ef8129ace.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:58.58Z\",\"MediaKey\":\"69253576ed3d045c3f30cc99\"},{\"ResourceRecordKey\":\"NST7830731\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"PKV_1620.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/4339fcef-aacf-4201-9794-b75e8fc7c59a.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:58.596Z\",\"MediaKey\":\"69253576ed3d045c3f30cc9a\"},{\"ResourceRecordKey\":\"NST7830731\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"PKV_1635.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7830731/2cd7ef80-8885-4f53-9b49-5dd7da6209a6.jpeg\",\"MediaModificationTimestamp\":\"2025-11-25T04:49:58.615Z\",\"MediaKey\":\"69253576ed3d045c3f30cc9b\"}]","PhotosChangeTimestamp":"2025-11-25T04:50:03.77Z","Rooms":"[{\"RoomKey\":\"NST115797074\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"16x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115797075\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115797076\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"24x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115797077\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x8\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115797078\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115797079\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115797080\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"13x13\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115797081\",\"RoomType\":\"Sun Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115797082\",\"RoomType\":\"Utility Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"20x10\",\"NST_RoomSortOrder\":\"9\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"PKV_1325.jpg\"},{\"Order\":2,\"Remarks\":\"PKV_1348.jpg\"},{\"Order\":3,\"Remarks\":\"PKV_1358.jpg\"},{\"Order\":4,\"Remarks\":\"PKV_1305.jpg\"},{\"Order\":5,\"Remarks\":\"PKV_1596.jpg\"},{\"Order\":6,\"Remarks\":\"PKV_1620.jpg\"},{\"Order\":7,\"Remarks\":\"PKV_1635.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7","CustomVTourURL":""}

Rusty's Up North Realty
Mark Tietjen - REALTORĀ®

4687 28th Ave NE
Longville, MN 56655

Phone: 218-947-3800
Toll Free: 218-536-0008
Fax: 218-363-3001
Email: mark@UpNorthRealtyMN.com

Direct Links

    Site Map

    • Home Page
    • Estimate Request
    • Featured Listings
    • Daily Hotlist
    • Map Search
    • Your Favorites
    • Contact Me
    • Notifications
    • Quick Print
    • DNR Lake Search

    Created & Designed by

    Real Estate Create


    © Copyright 2025
    All Rights Reserved