« go back
    • Home
    • Our Agents
    • Our Listings
    • Testimonials
  • Estimate Request
  • Map Search
    • Daily Hotlist
    • Advanced Search
    • Featured Listings
    • Open Houses
    • Our Listings
    • Lost Lake Lodge
    • Good Ol' Days Resort
  • Contact Us
    • Client Login
    • Saved Listings

MLS# NST6821607 - 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. Lakeshore Properties, LLC is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Lakeshore Properties, LLC, 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-25T04:50:03.77","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_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-24","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-25T04:50:03.77Z","PhotosChangeTimestamp":"2025-11-25T04:50:03.77Z","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\"}]","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":""}
  • Phone
  • Email
©2025 Lakeshore Properties LLC, all rights reserved. · Privacy ·
Created with REC by Shawn Hyde.