$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Elite Realty & Co 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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.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. LongvilleLakes.com is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of LongvilleLakes.com, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1420341,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6803020","MLSAGENTID":"NST502046213","MLSOFFICEID":"NST49305","ADDRESS":"397 Cottage Avenue W","ACRES":0.26,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":2.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":170000.0,"LASTPRICEDATE":"2025-10-11T02:56:05.513","LATITUDE":44.98304,"LENDEROWNED":"No","LISTDATE":"2025-10-10T05:00:00","LISTPRICE":170000.0,"LIVINGAREA":890.0,"LONGITUDE":-93.116896,"MODIFICATIONTIMESTAMP":"2025-10-11T10:37:04.135","NEIGHBORHOOD":"North End","OFFICE_OFFICENAME":"Elite Realty & Co","PHOTOCOUNT":11,"POSTALCODE":"55117","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Enjoy this lovely two-story home featuring a tuck-under garage and an open living room with a cozy fireplace. The dining area opens to a relaxing deck overlooking natural scenery. Conveniently located near shopping, dining, parks, and major highways.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"651-767-8100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-11T02:56:05.513","LASTSTATUS":"Active","STREETDIRSUFFIX":"W","STREETNAME":"Cottage","STREETNUMBER":"397","STREETSUFFIX":"Avenue","STYLE":"Townhouse Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street","WATERFRONTPRESENT":false,"YEARBUILT":1982,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-11T03:09:04.502","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"397 W Cottage Ave - Web Quality - 002 - 01 Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"397 W Cottage Ave - Web Quality - 001 - 02 Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"397 W Cottage Ave - Web Quality - 010 - 04 Dining Room.jpg\"},{\"Order\":4,\"Remarks\":\"397 W Cottage Ave - Web Quality - 004 - 06 Kitchen.jpg\"},{\"Order\":5,\"Remarks\":\"397 W Cottage Ave - Web Quality - 003 - 05 Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"397 W Cottage Ave - Web Quality - 009 - 12 2nd Floor Bedroom.jpg\"},{\"Order\":7,\"Remarks\":\"397 W Cottage Ave - Web Quality - 006 - 08 2nd Floor Primary Bedroom.jpg\"},{\"Order\":8,\"Remarks\":\"397 W Cottage Ave - Web Quality - 005 - 07 2nd Floor Primary Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"397 W Cottage Ave - Web Quality - 007 - 10 2nd Floor Primary Bathroom.jpg\"},{\"Order\":10,\"Remarks\":\"397 W Cottage Ave - Web Quality - 008 - 11 2nd Floor Primary Bathroom.jpg\"},{\"Order\":11,\"Remarks\":\"397 W Cottage Ave - Web Quality - 011 - 15 Patio.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11","SOURCE":"MG_NST"}
{"ListingKey":"NST7814636","LotSizeArea":"0.26","NST_AgeOfProperty":"43","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AssessmentPending":"No","AssociationFeeIncludes":"Other","AssociationFeeFrequency":"Monthly","AssociationYN":"True","AssociationFee":"200","AssociationName":"Condo 182 Hillcrest Twnhms","AssociationPhone":"651-000-0000","PropertyAttachedYN":"True","Basement":"None","BasementYN":"True","BathroomsOneQuarter":"1","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"2","City":"Saint Paul","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"59","Directions":"DALE TO ARLINGTON-E.TO FARRINGTON S TO COTTAGE","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"890","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Tuckunder Garage","NST_GarageSquareFeet":"240","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-10-11T02:54:40Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-10-11","Latitude":"44.98304","NST_LenderOwned":"No","ListAgentKey":"NST106155","ListAgentMlsId":"NST502046213","ListingContractDate":"2025-10-10T05:00:00Z","ListOfficeKey":"NST49305","ListOfficeName":"Elite Realty & Co","ListOfficeMlsId":"NST49305","ListPrice":"170000","LivingArea":"890","LockBoxType":"Combo","Longitude":"-93.116896","LotSizeDimensions":"121x96x182x73","LotSizeSquareFeet":"11107.8","LotSizeUnits":"Acres","ListingId":"NST6803020","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_NeighborhoodNumber":"North End","NST_OfficeBoard":"MAAR","ParcelNumber":"242923310005","GarageSpaces":"1","PhotosCount":"11","PostalCity":"Saint Paul","PostalCode":"55117","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Enjoy this lovely two-story home featuring a tuck-under garage and an open living room with a cozy fireplace. The dining area opens to a relaxing deck overlooking natural scenery. Conveniently located near shopping, dining, parks, and major highways.","PublicSurveyRange":"23","PublicSurveySection":"24","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","NST_Restrictions":"Other","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"890.0000","NST_BelowGradeSqFtTotal":"0.0000","NST_MainLevelFinishedArea":"890.0000","BuildingAreaTotal":"890","HighSchoolDistrict":"St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"651-767-8100","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"890","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetDirSuffix":"W","StreetName":"Cottage","StreetNumber":"397","StreetNumberNumeric":"397","StreetSuffix":"Avenue","PropertySubType":"Townhouse Side x Side","SubdivisionName":"Condo 182 Hillcrest Twnhms","NST_TaxWithAssessments":"2342.0000","TaxYear":"2025","TaxAnnualAmount":"2342","UnitNumber":"3","WaterSource":"City Water - In Street","YearBuilt":"1982","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-10-11T10:37:04.135Z","PhotosChangeTimestamp":"2025-10-11T03:09:04.502Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7814636\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 002 - 01 Exterior Front.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/09578ba0-ff53-426e-8698-657da0b9c630.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.694Z\",\"MediaKey\":\"68e9ca49f1aab4510292561b\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 001 - 02 Living Room.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/f9fad6ed-5953-4a5e-b11f-7f46bfa9ba44.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.689Z\",\"MediaKey\":\"68e9ca49f1aab4510292561c\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 010 - 04 Dining Room.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/8383ed20-86f7-43dc-adbc-69e2d121b29e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.675Z\",\"MediaKey\":\"68e9ca49f1aab4510292561d\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 004 - 06 Kitchen.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/69b32621-9304-4dac-88ba-84a2c38b96b7.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.74Z\",\"MediaKey\":\"68e9ca49f1aab4510292561e\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 003 - 05 Kitchen.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/4ffce45e-f18c-44fe-ab5d-41ad80968205.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.775Z\",\"MediaKey\":\"68e9ca49f1aab4510292561f\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 009 - 12 2nd Floor Bedroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1385,\"ImageSizeDescription\":\"2080x1385\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/73ada7d3-dd02-4205-a338-c0f81bcb1d2e.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.678Z\",\"MediaKey\":\"68e9ca49f1aab45102925620\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 006 - 08 2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/5f70a136-25b8-48c7-aa36-96afc80dedd3.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.756Z\",\"MediaKey\":\"68e9ca49f1aab45102925621\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 005 - 07 2nd Floor Primary Bedroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/2478e00d-8a17-4949-b2f0-93abfa2e8dd4.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.685Z\",\"MediaKey\":\"68e9ca49f1aab45102925622\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 007 - 10 2nd Floor Primary Bathroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1387,\"ImageSizeDescription\":\"2080x1387\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/c04abf87-5ce8-4b35-b6af-b7caa52844a9.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.688Z\",\"MediaKey\":\"68e9ca49f1aab45102925623\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 008 - 11 2nd Floor Primary Bathroom.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/13d9f2a1-192f-40d0-9fc8-fd3ca5fd4eff.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.686Z\",\"MediaKey\":\"68e9ca49f1aab45102925624\"},{\"ResourceRecordKey\":\"NST7814636\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"397 W Cottage Ave - Web Quality - 011 - 15 Patio.jpg\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7814636/3b4bc706-28aa-4f9d-8b11-484eb3962f18.jpeg\",\"MediaModificationTimestamp\":\"2025-10-11T03:08:57.728Z\",\"MediaKey\":\"68e9ca49f1aab45102925625\"}]","Rooms":"[{\"RoomKey\":\"NST115693489\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x10\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115693490\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115693491\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"8x8\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115693492\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"14x10\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115693493\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"11x8\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"397 W Cottage Ave - Web Quality - 002 - 01 Exterior Front.jpg\"},{\"Order\":2,\"Remarks\":\"397 W Cottage Ave - Web Quality - 001 - 02 Living Room.jpg\"},{\"Order\":3,\"Remarks\":\"397 W Cottage Ave - Web Quality - 010 - 04 Dining Room.jpg\"},{\"Order\":4,\"Remarks\":\"397 W Cottage Ave - Web Quality - 004 - 06 Kitchen.jpg\"},{\"Order\":5,\"Remarks\":\"397 W Cottage Ave - Web Quality - 003 - 05 Kitchen.jpg\"},{\"Order\":6,\"Remarks\":\"397 W Cottage Ave - Web Quality - 009 - 12 2nd Floor Bedroom.jpg\"},{\"Order\":7,\"Remarks\":\"397 W Cottage Ave - Web Quality - 006 - 08 2nd Floor Primary Bedroom.jpg\"},{\"Order\":8,\"Remarks\":\"397 W Cottage Ave - Web Quality - 005 - 07 2nd Floor Primary Bedroom.jpg\"},{\"Order\":9,\"Remarks\":\"397 W Cottage Ave - Web Quality - 007 - 10 2nd Floor Primary Bathroom.jpg\"},{\"Order\":10,\"Remarks\":\"397 W Cottage Ave - Web Quality - 008 - 11 2nd Floor Primary Bathroom.jpg\"},{\"Order\":11,\"Remarks\":\"397 W Cottage Ave - Web Quality - 011 - 15 Patio.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11","CustomVTourURL":""}