$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Renters Warehouse 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. Sandy Smith | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Sandy Smith | Kurilla Real Estate, Ltd., 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. Sandy Smith | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Sandy Smith | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1372736,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6742345","MLSAGENTID":"NST496500378","MLSOFFICEID":"NST25783","ADDRESS":"1583 28th Avenue NW","ACRES":0.28,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":3.0,"BEDROOMS":4,"CITY":"New Brighton","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone","FORECLOSURE":"No","LASTPRICE":350000.0,"LASTPRICEDATE":"2025-06-20T17:35:05.93","LATITUDE":45.074721,"LENDEROWNED":"No","LISTDATE":"2025-06-19T05:00:00","LISTPRICE":350000.0,"LIVINGAREA":2228.0,"LONGITUDE":-93.222258,"MODIFICATIONTIMESTAMP":"2025-06-21T10:13:06.502","OFFICE_OFFICENAME":"Renters Warehouse","PHOTOCOUNT":15,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"RARE INVESTMENT OPPORTUNITY IN PREMIER NEIGHBORHOOD\nSolid All Brick Foundation Home with Unlimited Potential Discover your diamond in the rough in this sought-after residential neighborhood where excellent schools, low crime rate, and family-friendly amenities create the perfect backdrop for your renovation vision.\n?? LOCATION HIGHLIGHTS\n• Top-rated Mounds View school district - giving your family educational excellence. Just blocks from Totino Grace High School.\n• Multiple colleges and universities nearby - intellectual community at your doorstep\n• Two major shopping centers within easy reach\n• Public library and family resource & play center - enriching community resources\n• Peaceful neighborhood streets nestled away from main traffic\n• Low crime area - safety and security for your investment\n?? EXTRAORDINARY OUTDOOR FEATURES\nYour Private Nature Retreat Awaits\n• Expansive backyard - endless possibilities for entertainment and relaxation\n• Mature wooded portion - natural privacy screen and four seasons of beauty\n• Tranquil pond view - wake up to serene water every morning\n• Rare lot configuration - this type of natural setting is irreplaceable\n?? THE OPPORTUNITY\nThis all-brick exterior home offers incredible bones and unlimited potential for the buyer ready to create their dream space. Priced appropriately for immediate equity opportunity, this property allows you to:\n? Build instant equity while personalizing every detail\n? Enter a premium neighborhood at below-market pricing\n? Create your forever home exactly as you envision it\n? Invest in a location where property values continue to appreciate\n?? PERFECT FOR:\n• First-time buyers seeking homeownership in an excellent area\n• Investors looking for value-add opportunities\n• Families wanting to create their ideal home environment\n• Anyone tired of bidding wars on move-in ready properties\n?? DON'T WAIT\nProperties with this combination of location excellence, outdoor beauty, and investment potential rarely become available. The solid brick construction provides an excellent foundation for your renovation vision.\nSchedule your private showing today and discover why this hidden gem won't last long at this price point.\n________________________________________\nProfessional renovation guidance and contractor recommendations available. FHA 203k and renovation loan friendly.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-20T17:35:05.93","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"28th","STREETNUMBER":"1583","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1965,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-06-21T03:10:04.314","PHOTOREMARKS":"[{\"Order\":2,\"Remarks\":\"Living room\"},{\"Order\":4,\"Remarks\":\"Kitchen\"},{\"Order\":6,\"Remarks\":\"Porch off living room\"},{\"Order\":8,\"Remarks\":\"Dining room or office\"},{\"Order\":9,\"Remarks\":\"Family room\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7762014","LotSizeArea":"0.28","NST_AgeOfProperty":"60","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Hardwood Floors,Patio,Porch","Appliances":"Dishwasher,Microwave,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"3/4 Basement,Basement,Main Floor 1/2 Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","City":"New Brighton","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"2","CumulativeDaysOnMarket":"2","NST_DiningRoomDescription":"Eat In Kitchen,Separate/Formal Dining Room","Directions":"SIVER LK RD TO 16TH ST WEST TO 28TH LEFT TO HOUS","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Brick/Stone","FireplaceFeatures":"Family Room,Living Room,Other","FireplaceYN":"True","FireplacesTotal":"2","NST_ForeclosureStatus":"No","FoundationArea":"864","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Garage Door Opener","NST_GarageSquareFeet":"500","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-20T17:32:23Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-21","Latitude":"45.074721","NST_LenderOwned":"No","ListAgentKey":"NST48867","ListAgentMlsId":"NST496500378","ListingContractDate":"2025-06-19T05:00:00Z","ListOfficeKey":"NST25783","ListOfficeName":"Renters Warehouse","ListOfficeMlsId":"NST25783","ListPrice":"350000","LivingArea":"2228","Longitude":"-93.222258","NST_LotPrice":"0.000","LotSizeDimensions":"75 X 164","LotSizeSquareFeet":"12196.8","LotSizeUnits":"Acres","ListingId":"NST6742345","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"193023240018","GarageSpaces":"2","NST_ParkingOpen":"0","PastureArea":"0","PhotosCount":"15","PostalCity":"New Brighton","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"RARE INVESTMENT OPPORTUNITY IN PREMIER NEIGHBORHOOD\nSolid All Brick Foundation Home with Unlimited Potential Discover your diamond in the rough in this sought-after residential neighborhood where excellent schools, low crime rate, and family-friendly amenities create the perfect backdrop for your renovation vision.\n?? LOCATION HIGHLIGHTS\n• Top-rated Mounds View school district - giving your family educational excellence. Just blocks from Totino Grace High School.\n• Multiple colleges and universities nearby - intellectual community at your doorstep\n• Two major shopping centers within easy reach\n• Public library and family resource & play center - enriching community resources\n• Peaceful neighborhood streets nestled away from main traffic\n• Low crime area - safety and security for your investment\n?? EXTRAORDINARY OUTDOOR FEATURES\nYour Private Nature Retreat Awaits\n• Expansive backyard - endless possibilities for entertainment and relaxation\n• Mature wooded portion - natural privacy screen and four seasons of beauty\n• Tranquil pond view - wake up to serene water every morning\n• Rare lot configuration - this type of natural setting is irreplaceable\n?? THE OPPORTUNITY\nThis all-brick exterior home offers incredible bones and unlimited potential for the buyer ready to create their dream space. Priced appropriately for immediate equity opportunity, this property allows you to:\n? Build instant equity while personalizing every detail\n? Enter a premium neighborhood at below-market pricing\n? Create your forever home exactly as you envision it\n? Invest in a location where property values continue to appreciate\n?? PERFECT FOR:\n• First-time buyers seeking homeownership in an excellent area\n• Investors looking for value-add opportunities\n• Families wanting to create their ideal home environment\n• Anyone tired of bidding wars on move-in ready properties\n?? DON'T WAIT\nProperties with this combination of location excellence, outdoor beauty, and investment potential rarely become available. The solid brick construction provides an excellent foundation for your renovation vision.\nSchedule your private showing today and discover why this hidden gem won't last long at this price point.\n________________________________________\nProfessional renovation guidance and contractor recommendations available. FHA 203k and renovation loan friendly.","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Yes","Roof":"Age Over 8 Years","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Porch,Den,Family Room,Laundry","NST_AboveGradeSqFtTotal":"1728.0000","NST_BelowGradeSqFtTotal":"864.0000","NST_MainLevelFinishedArea":"864.0000","BuildingAreaTotal":"2592","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","NST_SharedRooms":"Other","NST_SpecialSearch":"4 BR on One Level","AboveGradeFinishedArea":"1728","BelowGradeFinishedArea":"500","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"NW","StreetName":"28th","StreetNumber":"1583","StreetNumberNumeric":"1583","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","NST_TaxWithAssessments":"5920.0000","TaxYear":"2024","TaxAnnualAmount":"5920","CultivatedArea":"0","WaterSource":"City Water/Connected","WoodedArea":"0","YearBuilt":"1965","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-21T10:13:06.502Z","PhotosChangeTimestamp":"2025-06-21T03:10:04.314Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7762014\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/3549b280-5af7-49bd-945b-7f58a9a06eb4.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.476Z\",\"MediaKey\":\"6856226171ebf01e975c04d6\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Living room\",\"ImageWidth\":454,\"ImageHeight\":331,\"ImageSizeDescription\":\"454x331\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/4b54b453-bfb7-4005-9e5b-6cd122477c55.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.375Z\",\"MediaKey\":\"6856226171ebf01e975c04d7\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":444,\"ImageHeight\":326,\"ImageSizeDescription\":\"444x326\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/2acf913e-7c51-4512-9835-d1afd7dafc6a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.383Z\",\"MediaKey\":\"6856226171ebf01e975c04d8\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Kitchen\",\"ImageWidth\":464,\"ImageHeight\":332,\"ImageSizeDescription\":\"464x332\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/3c205fad-c986-46d8-a7dc-a4ba4ff7d2bc.png\",\"MediaModificationTimestamp\":\"2025-06-20T17:34:56.676Z\",\"MediaKey\":\"68559bc013cd49321326a39f\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":441,\"ImageHeight\":327,\"ImageSizeDescription\":\"441x327\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/b2604f0c-2609-4aee-a41b-a2558cc41297.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.376Z\",\"MediaKey\":\"6856226171ebf01e975c04d9\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Porch off living room\",\"ImageWidth\":442,\"ImageHeight\":329,\"ImageSizeDescription\":\"442x329\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/d469329b-37b3-4296-9b61-690750d3cdd4.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.383Z\",\"MediaKey\":\"6856226171ebf01e975c04da\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":435,\"ImageHeight\":323,\"ImageSizeDescription\":\"435x323\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/ba8ddd25-e9f0-4e5f-89bb-f58fe26f3b3c.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.384Z\",\"MediaKey\":\"6856226171ebf01e975c04db\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Dining room or office\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/9a4588bd-0e72-4b98-a38b-82e22469f7c3.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.391Z\",\"MediaKey\":\"6856226171ebf01e975c04dc\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Family room\",\"ImageWidth\":432,\"ImageHeight\":318,\"ImageSizeDescription\":\"432x318\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/219c4c12-3267-47b0-90e0-61a0c3ad706b.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.383Z\",\"MediaKey\":\"6856226171ebf01e975c04dd\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/ac07f5c9-238b-4500-bd05-cad2a1093f19.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.464Z\",\"MediaKey\":\"6856226171ebf01e975c04de\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/56fb3d0e-5e14-4bf9-8db4-758176235546.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.42Z\",\"MediaKey\":\"6856226171ebf01e975c04df\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/d3882334-f69e-41d4-be54-89c06efd08f1.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.428Z\",\"MediaKey\":\"6856226171ebf01e975c04e0\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/3938d945-a3ee-41c0-a3d3-aa135f8c964a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.427Z\",\"MediaKey\":\"6856226171ebf01e975c04e1\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/0aa69ea0-0b15-4fce-9cbd-691d7c4aeecb.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.447Z\",\"MediaKey\":\"6856226171ebf01e975c04e2\"},{\"ResourceRecordKey\":\"NST7762014\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7762014/3aa3494a-b3e4-4e51-bd53-f838b0242223.jpeg\",\"MediaModificationTimestamp\":\"2025-06-21T03:09:21.509Z\",\"MediaKey\":\"6856226171ebf01e975c04e3\"}]","Rooms":"[{\"RoomKey\":\"NST115341731\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"23 x 13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115341732\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115341733\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115341734\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"17x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115341735\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115341736\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115341737\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115341738\",\"RoomType\":\"Porch\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"22x12\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115341739\",\"RoomType\":\"Den\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"17x11\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115341740\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"23x12\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115341741\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"12x12\",\"NST_RoomSortOrder\":\"11\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":2,\"Remarks\":\"Living room\"},{\"Order\":4,\"Remarks\":\"Kitchen\"},{\"Order\":6,\"Remarks\":\"Porch off living room\"},{\"Order\":8,\"Remarks\":\"Dining room or office\"},{\"Order\":9,\"Remarks\":\"Family room\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}