Keller Williams Integrity Realty 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":505773,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7001762","MLSAGENTID":"NST506091324","MLSCOAGENTID":"NST506097155","MLSOFFICEID":"NST10071","ADDRESS":"1248 Farrington Street","ACRES":0.112,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":4,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Frame","FORECLOSURE":"No","LASTPRICE":150000.0,"LASTPRICEDATE":"2026-01-07T15:24:07.063","LATITUDE":44.97871,"LENDEROWNED":"No","LISTDATE":"2025-12-21T06:00:00","LISTPRICE":135000.0,"LIVINGAREA":1230.0,"LONGITUDE":-93.1132,"MODIFICATIONTIMESTAMP":"2026-01-07T15:24:07.063","NEIGHBORHOOD":"97","OFFICE_OFFICENAME":"Keller Williams Integrity Realty","PHOTOCOUNT":4,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Perfect opportunity to build equity. This home features two bedrooms on the main level and two bedrooms upstairs, with a basement that offers potential for an additional bedroom or living space. Property requires extensive repairs and is being sold as-is. Seller will consider cash or rehab loan offers only. Kitchen is currently a blank slate","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-12-27T06:02:09.63","LASTSTATUS":"Coming Soon","STREETNAME":"Farrington","STREETNUMBER":"1248","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1949,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-01-06T10:40:05.498","PHOTOORDER":"1,2,3,4","SOURCE":"MG_NST"}
{"ListingKey":"NST7836790","NST_AboveGradeSqFtTotal":"1130","AboveGradeFinishedArea":"1130","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Main Floor Primary Bedroom","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"790","BelowGradeFinishedArea":"100","CumulativeDaysOnMarket":"0","City":"Saint Paul","ConstructionMaterials":"Frame","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Maryland to Farrington N to home","DocumentsCount":"2","DocumentsChangeTimestamp":"2026-01-07T14:25:06.585Z","DaysOnMarket":"0","NST_ExpectedMarketDate":"2025-12-27","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"790","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"320","GarageSpaces":"1","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"Yes","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.97871","NST_LenderOwned":"No","Levels":"One and One Half","ListPrice":"135000","ListingContractDate":"2025-12-21T06:00:00Z","ListingId":"NST7001762","LivingArea":"1230","Longitude":"-93.1132","LotSizeArea":"0.112","LotSizeDimensions":"40x122","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"790","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"97","OriginalEntryTimestamp":"2025-12-27T00:00:15Z","ParcelNumber":"242923430119","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage","PhotosCount":"4","PhotosChangeTimestamp":"2026-01-06T10:40:05.498Z","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","PublicRemarks":"Perfect opportunity to build equity. This home features two bedrooms on the main level and two bedrooms upstairs, with a basement that offers potential for an additional bedroom or living space. Property requires extensive repairs and is being sold as-is. Seller will consider cash or rehab loan offers only. Kitchen is currently a blank slate","PublicSurveyRange":"23","PublicSurveySection":"24","PublicSurveyTownship":"29","Roof":"Asphalt","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Farrington","StreetNumber":"1248","StreetNumberNumeric":"1248","StreetSuffix":"Street","SubdivisionName":"John A Weides Subdivision, Of","TaxAnnualAmount":"3065","NST_TaxWithAssessments":"7998","TaxYear":"2025","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"1949","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST67827","CoListAgentMlsId":"NST506097155","CoListOfficeName":"Keller Williams Integrity Realty","ListAgentKey":"NST37415","ListAgentMlsId":"NST506091324","ListOfficeMlsId":"NST10071","ListOfficeName":"Keller Williams Integrity Realty","ListOfficeKey":"NST16710","ModificationTimestamp":"2026-01-07T15:24:07.063Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836790/2f30d3a3-c6cd-463f-8608-4669a4166d8e.jpeg\",\"ResourceRecordKey\":\"NST7836790\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-01-06T10:39:48.059Z\",\"MediaKey\":\"NST119962289\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836790/c025c082-0779-4072-a416-142e5ffde9c2.jpeg\",\"ResourceRecordKey\":\"NST7836790\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2026-01-06T10:39:48.023Z\",\"MediaKey\":\"NST119962288\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836790/001b56a8-c4ec-4179-9992-a2acdb497c09.jpeg\",\"ResourceRecordKey\":\"NST7836790\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1560,\"ImageHeight\":2080,\"ImageSizeDescription\":\"1560x2080\",\"MediaModificationTimestamp\":\"2025-12-21T15:58:06.386Z\",\"MediaKey\":\"NST119962283\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7836790/80456456-ee7f-48e8-b4bd-2593c89f83b7.jpeg\",\"ResourceRecordKey\":\"NST7836790\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-21T15:58:06.512Z\",\"MediaKey\":\"NST119962284\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7836790/2f30d3a3-c6cd-463f-8608-4669a4166d8e.jpeg","Media__ResourceRecordKey":"NST7836790","Media__Order":"3","Media__MediaObjectID":"NST3","Media__ImageWidth":"2080","Media__ImageHeight":"1560","Media__ImageSizeDescription":"2080x1560","Media__MediaModificationTimestamp":"1/6/2026 10:39:48 AM","Media__MediaKey":"NST119962289","Rooms":"[{\"RoomKey\":\"NST115832679\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x10\"},{\"RoomKey\":\"NST115832682\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x11\"},{\"RoomKey\":\"NST115832678\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x11\"},{\"RoomKey\":\"NST115832677\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x11\"},{\"RoomKey\":\"NST115832680\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x9\"},{\"RoomKey\":\"NST115832681\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"16x11\"}]","Rooms__RoomKey":"NST115832679","Rooms__NST_RoomSortOrder":"3","Rooms__RoomType":"Bedroom","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"12x10","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4","CustomVTourURL":""}