218 398-4849
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
LPT 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. Heartland Real Estate | jaymiann.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate | jaymiann.com, 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. Heartland Real Estate | jaymiann.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Heartland Real Estate | jaymiann.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1350453,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6720659","MLSAGENTID":"NST506017372","MLSOFFICEID":"NST253015","ADDRESS":"476 Brainerd Avenue","ACRES":0.14,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Walkout","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Stucco","FORECLOSURE":"No","LASTPRICE":214977.0,"LASTPRICEDATE":"2025-07-11T22:24:03.42","LATITUDE":44.97869568,"LENDEROWNED":"No","LISTDATE":"2025-05-24T05:00:00","LISTPRICE":209977.0,"LIVINGAREA":940.0,"LONGITUDE":-93.08043376,"LOTDESCRIPTION":"Irregular Lot,Some Trees","MODIFICATIONTIMESTAMP":"2025-07-12T04:04:03.476","NEIGHBORHOOD":"Payne-Phalen","OFFICE_OFFICENAME":"LPT Realty, LLC","PHOTOCOUNT":12,"POSTALCODE":"55130","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Cozy stucco home with great location, close to downtown, and bus stop. There was a new roof around 2015, new furnace in 2011, new flooring, new refrigerator; eat in kitchen, 2 bedroom, 1 full bath, lower level walkout in a unfinished basement. Handyman can bring some vision to the basement, and bring it to life. Yard is big enough for a garden.\nEntrance to basement was from outside, so a stairway was added inside to go to the basement. Dryer and appliances will stay and there is a hook up for a clothes washer.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-05-24T15:38:04.103","LASTSTATUS":"Active","STREETNAME":"Brainerd","STREETNUMBER":"476","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1904,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-07-12T04:04:03.476","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front of the home - street view\"},{\"Order\":2,\"Remarks\":\"coming into the home there is a bedroom and full bathroom, new flooring\"},{\"Order\":3,\"Remarks\":\"view out to the front and east side of the home\"},{\"Order\":4,\"Remarks\":\"Full bath with privacy window\"},{\"Order\":5,\"Remarks\":\"view from kitchen into living room and dining room.\"},{\"Order\":6,\"Remarks\":\"Kitchen with gas stove and new refrigerator\"},{\"Order\":7,\"Remarks\":\"side door to outside, curved archway into living room\"},{\"Order\":8,\"Remarks\":\"Kitchen, dining room with door to 2nd bedroom and spiral staircase to lower level.\"},{\"Order\":9,\"Remarks\":\"open kitchen and dining room\"},{\"Order\":10,\"Remarks\":\"view from dining room into the backyard.\"},{\"Order\":11,\"Remarks\":\"2nd bedroom\"},{\"Order\":12,\"Remarks\":\"Main room in the basement with door to outside back yard. There also is a utility room, and 2 storage rooms. Possibilities for basement area - bring your vision!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7743126","LotSizeArea":"0.14","NST_AgeOfProperty":"121","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Washer/Dryer Hookup","Appliances":"Dryer,Range,Refrigerator","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Block,Walkout","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"None","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"48","CumulativeDaysOnMarket":"48","NST_DiningRoomDescription":"Eat In Kitchen,Kitchen/Dining Room","Directions":"Hwy 35E to Maryland, East to Arkwright, N to Brainerd, E to home on right side","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Stucco","Fencing":"Partial,Wood","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"940","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs","NST_Fuel":"Natural Gas","ParkingFeatures":"Open","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-05-24T15:35:56Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-07-11","Latitude":"44.9786956835","NST_LenderOwned":"No","ListAgentKey":"NST226871","ListAgentMlsId":"NST506017372","ListingContractDate":"2025-05-24T05:00:00Z","ListOfficeKey":"NST1001758","ListOfficeName":"LPT Realty, LLC","ListOfficeMlsId":"NST253015","ListPrice":"209977","LivingArea":"940","Longitude":"-93.0804337636","LotFeatures":"Irregular Lot,Some Trees","LotSizeDimensions":"70x67","LotSizeSquareFeet":"6098.4","LotSizeUnits":"Acres","ListingId":"NST6720659","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"Payne-Phalen","NST_OfficeBoard":"SPAAR","ParcelNumber":"202922340072","GarageSpaces":"0","PhotosCount":"12","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55130","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Cozy stucco home with great location, close to downtown, and bus stop. There was a new roof around 2015, new furnace in 2011, new flooring, new refrigerator; eat in kitchen, 2 bedroom, 1 full bath, lower level walkout in a unfinished basement. Handyman can bring some vision to the basement, and bring it to life. Yard is big enough for a garden.\nEntrance to basement was from outside, so a stairway was added inside to go to the basement. Dryer and appliances will stay and there is a hook up for a clothes washer.","NST_RentalLicenseYN":"No","Roof":"Age Over 8 Years,Asphalt","RoomType":"Living Room,Kitchen,Bedroom 1,Bedroom 2,Bathroom","NST_AboveGradeSqFtTotal":"940.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"940.0000","BuildingAreaTotal":"940","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom","AboveGradeFinishedArea":"940","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Brainerd","StreetNumber":"476","StreetNumberNumeric":"476","StreetSuffix":"Avenue","PropertySubType":"Single Family Residence","SubdivisionName":"Fischer & Clarke & Wilgu","NST_TaxWithAssessments":"3404.0000","TaxYear":"2025","TaxAnnualAmount":"3404","WaterSource":"City Water/Connected","YearBuilt":"1904","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-07-12T04:04:03.476Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7743126\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front of the home - street view\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/7aed1ce9-021a-429b-9931-6e6463813bb8.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.994Z\",\"MediaKey\":\"68326f982e1e5f39194e9e3a\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"coming into the home there is a bedroom and full bathroom, new flooring\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/89054a83-91d6-4a7b-b33e-b2fd4481f7eb.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.982Z\",\"MediaKey\":\"68326f982e1e5f39194e9e3c\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"view out to the front and east side of the home\",\"ImageWidth\":2038,\"ImageHeight\":1358,\"ImageSizeDescription\":\"2038x1358\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/d3a0a43c-03ab-4da1-ac0b-1a14e8058914.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.968Z\",\"MediaKey\":\"68326f982e1e5f39194e9e3d\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Full bath with privacy window\",\"ImageWidth\":2038,\"ImageHeight\":1360,\"ImageSizeDescription\":\"2038x1360\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/8326bf63-104d-417b-9b14-181e7e8d5811.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:12.018Z\",\"MediaKey\":\"68326f982e1e5f39194e9e3e\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"view from kitchen into living room and dining room.\",\"ImageWidth\":2038,\"ImageHeight\":1357,\"ImageSizeDescription\":\"2038x1357\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/08a966e3-a1e6-4f5b-a81b-84aa411f73e8.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:12.039Z\",\"MediaKey\":\"68326f982e1e5f39194e9e3f\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Kitchen with gas stove and new refrigerator\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/299b96b5-eaf3-49cc-8311-ea0cd3383326.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.996Z\",\"MediaKey\":\"68326f982e1e5f39194e9e40\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"side door to outside, curved archway into living room\",\"ImageWidth\":2038,\"ImageHeight\":1358,\"ImageSizeDescription\":\"2038x1358\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/651f3305-b187-4af9-b273-14fe33b3c749.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.996Z\",\"MediaKey\":\"68326f982e1e5f39194e9e41\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Kitchen, dining room with door to 2nd bedroom and spiral staircase to lower level.\",\"ImageWidth\":2038,\"ImageHeight\":1358,\"ImageSizeDescription\":\"2038x1358\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/1c6d6ad0-cd6f-4ef1-8779-3fd6da62b0dd.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:12.059Z\",\"MediaKey\":\"68326f982e1e5f39194e9e42\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"open kitchen and dining room\",\"ImageWidth\":2038,\"ImageHeight\":1358,\"ImageSizeDescription\":\"2038x1358\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/ecb43db9-a0df-48e8-90fc-fbfba78ce157.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.978Z\",\"MediaKey\":\"68326f982e1e5f39194e9e43\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"view from dining room into the backyard.\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/13cc3015-4dc7-475e-9293-a9e2e766128a.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.99Z\",\"MediaKey\":\"68326f982e1e5f39194e9e44\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"2nd bedroom\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/d75843dd-52e2-4fe9-9747-5bb95a40c4f9.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:12.122Z\",\"MediaKey\":\"68326f982e1e5f39194e9e45\"},{\"ResourceRecordKey\":\"NST7743126\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Main room in the basement with door to outside back yard. There also is a utility room, and 2 storage rooms. Possibilities for basement area - bring your vision!\",\"ImageWidth\":2038,\"ImageHeight\":1359,\"ImageSizeDescription\":\"2038x1359\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7743126/d381c5fc-59ad-461a-bf2f-3b32964b16ff.jpeg\",\"MediaModificationTimestamp\":\"2025-05-25T01:17:11.978Z\",\"MediaKey\":\"68326f982e1e5f39194e9e46\"}]","PhotosChangeTimestamp":"2025-07-12T04:04:03.476Z","Rooms":"[{\"RoomKey\":\"NST115209532\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18.7x10.2\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115209535\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"18x13\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115209536\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14.8x11.6\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115209537\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x9.6\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115209539\",\"RoomType\":\"Bathroom\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9.6x6.8\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front of the home - street view\"},{\"Order\":2,\"Remarks\":\"coming into the home there is a bedroom and full bathroom, new flooring\"},{\"Order\":3,\"Remarks\":\"view out to the front and east side of the home\"},{\"Order\":4,\"Remarks\":\"Full bath with privacy window\"},{\"Order\":5,\"Remarks\":\"view from kitchen into living room and dining room.\"},{\"Order\":6,\"Remarks\":\"Kitchen with gas stove and new refrigerator\"},{\"Order\":7,\"Remarks\":\"side door to outside, curved archway into living room\"},{\"Order\":8,\"Remarks\":\"Kitchen, dining room with door to 2nd bedroom and spiral staircase to lower level.\"},{\"Order\":9,\"Remarks\":\"open kitchen and dining room\"},{\"Order\":10,\"Remarks\":\"view from dining room into the backyard.\"},{\"Order\":11,\"Remarks\":\"2nd bedroom\"},{\"Order\":12,\"Remarks\":\"Main room in the basement with door to outside back yard. There also is a utility room, and 2 storage rooms. Possibilities for basement area - bring your vision!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12","CustomVTourURL":""}