{"Id":498812,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6806653","MLSAGENTID":"NST506000014","MLSCOAGENTID":"NST506008553","MLSOFFICEID":"NST8113","ADDRESS":"590 Cretin Avenue S","ACRES":0.128,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Block,Full,Unfinished","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block,Concrete,Frame","FORECLOSURE":"No","LASTPRICE":340000.0,"LASTPRICEDATE":"2025-12-11T14:45:05.667","LATITUDE":44.923776,"LENDEROWNED":"No","LISTDATE":"2025-11-17T06:00:00","LISTPRICE":325000.0,"LIVINGAREA":932.0,"LONGITUDE":-93.192205,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2025-12-12T19:39:15.433","NEIGHBORHOOD":"94","OFFICE_OFFICENAME":"Edina Realty, Inc.","PHOTOCOUNT":19,"POSTALCODE":"55116","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"One level living in prime Highland Park location just blocks from Mississippi River Blvd! 2 bedrooms and updated full bath on main floor. Charm & character throughout with hardwood flooring on main level. Living room opens to formal dining room. Enjoy lazy summer afternoons in the 3 season porch off the back of the home. Modern 2 car garage. Forced air furnace w/central A/C. New range/oven & washer, 2025. Convenient location nearby shopping, parks, and transit.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age Over 8 Years,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"2102-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-21T06:02:05.607","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"S","STREETNAME":"Cretin","STREETNUMBER":"590","STREETSUFFIX":"Avenue","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1939,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-11T05:46:04.901","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"590 Cretin Avenue S. with classic brick exterior, in prime Highland Park!\"},{\"Order\":2,\"Remarks\":\"Spacious living room with oak flooring, fireplace, and abundant windows\"},{\"Order\":3,\"Remarks\":\"Living room and entry, facing West\"},{\"Order\":4,\"Remarks\":\"Formal dining room opens to 3 season porch\"},{\"Order\":5,\"Remarks\":\"Porch interior\"},{\"Order\":6,\"Remarks\":\"Kitchen facing East\"},{\"Order\":7,\"Remarks\":\"Kitchen facing the dining room and living room\"},{\"Order\":8,\"Remarks\":\"Bedroom #1, also with hardwood flooring\"},{\"Order\":9,\"Remarks\":\"Updated custom tiled bath, with glass block window\"},{\"Order\":10,\"Remarks\":\"Bedroom # 2\"},{\"Order\":11,\"Remarks\":\"Front entry opposite the closet\"},{\"Order\":12,\"Remarks\":\"Dining room close-up facing the porch\"},{\"Order\":13,\"Remarks\":\"Large clean unfinished basement with high-efficiency furnace and brand new washer\"},{\"Order\":14,\"Remarks\":\"Furnace and water heater close-up. The home has central air-conditioning\"},{\"Order\":15,\"Remarks\":\"Electric panel with circuit breakers\"},{\"Order\":16,\"Remarks\":\"Updated 2 car garage interior\"},{\"Order\":17,\"Remarks\":\"Rear view of the home\"},{\"Order\":18,\"Remarks\":\"590 Cretin Avenue S. , Saint Paul\"},{\"Order\":19,\"Remarks\":\"Front view as one approaches the entry\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","SOURCE":"MG_NST"}
{"ListingKey":"NST7817830","Appliances":"Dryer,Range,Refrigerator,Washer","AssociationYN":"False","AssociationFee":"0","Basement":"Block,Full,Unfinished","City":"Saint Paul","Contingency":"None","Directions":"Interstate 94 to S on Cretin Ave. Home on L.","Electric":"Circuit Breakers","FireplaceYN":"True","NST_Fuel":"Natural Gas","NST_GarageDimensions":"21x19","Latitude":"44.923776","ListPrice":"325000","LivingArea":"932","LockBoxType":"Supra","Longitude":"-93.192205","LotSizeDimensions":"6868","LotSizeUnits":"Acres","ParcelNumber":"082823410145","PostalCity":"Saint Paul","PostalCode":"55116","PublicRemarks":"One level living in prime Highland Park location just blocks from Mississippi River Blvd! 2 bedrooms and updated full bath on main floor. Charm & character throughout with hardwood flooring on main level. Living room opens to formal dining room. Enjoy lazy summer afternoons in the 3 season porch off the back of the home. Modern 2 car garage. Forced air furnace w/central A/C. New range/oven & washer, 2025. Convenient location nearby shopping, parks, and transit.","PublicSurveyRange":"23","PublicSurveySection":"08","PublicSurveyTownship":"28","Roof":"Age Over 8 Years,Asphalt,Pitched","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetDirSuffix":"S","StreetName":"Cretin","StreetNumber":"590","StreetNumberNumeric":"590","StreetSuffix":"Avenue","TaxYear":"2025","YearBuilt":"1939","NST_AboveGradeSqFtTotal":"993","AboveGradeFinishedArea":"932","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Window,Porch,Tile Floors,Washer/Dryer Hookup","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"932","BelowGradeFinishedArea":"0","CumulativeDaysOnMarket":"0","ConstructionMaterials":"Block,Concrete,Frame","NewConstructionYN":"False","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Separate/Formal Dining Room","DaysOnMarket":"0","NST_ExpectedMarketDate":"2025-11-21","Fencing":"None","FireplaceFeatures":"Living Room,Wood Burning","FireplacesTotal":"1","FoundationArea":"932","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"411","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","LaundryFeatures":"In Basement,Washer Hookup","NST_LenderOwned":"No","Levels":"One","ListingContractDate":"2025-11-17T06:00:00Z","ListingId":"NST6806653","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"0.128","NST_MainLevelFinishedArea":"932","NST_ManufacturedHome":"N","NST_NeighborhoodNumber":"94","OriginalEntryTimestamp":"2025-11-21T00:00:05Z","NST_SchoolDistrictNumber":"2102","ParkingFeatures":"Detached Garage,Garage Door Opener","NST_PatioPorchType":"Porch,Rear Porch","PhotosCount":"19","PhotosChangeTimestamp":"2025-12-11T05:46:04.901Z","PoolFeatures":"None","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks","RoadResponsibility":"Public Maintained Road","NST_SpecialSearch":"Main Floor Bedroom","StandardStatus":"Active","TaxAnnualAmount":"5150","NST_TaxWithAssessments":"5492","Township":"Saint Paul","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97409","CoListAgentMlsId":"NST506008553","ListAgentKey":"NST46967","ListAgentMlsId":"NST506000014","ListOfficeMlsId":"NST8113","ListOfficeName":"Edina Realty, Inc.","ListOfficeKey":"NST16445","ModificationTimestamp":"2025-12-12T19:39:15.433Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/9531e666-71a7-480d-afc7-4a33a5122ca9.jpeg\",\"LongDescription\":\"Bedroom #1, also with hardwood flooring\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.361Z\",\"MediaKey\":\"NST119731306\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/4f42d325-3d71-458a-9334-621d4d8d225f.jpeg\",\"LongDescription\":\"Kitchen facing East\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.34Z\",\"MediaKey\":\"NST119731312\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/48f10e0c-0dd4-4eb3-ba22-f0b93c69bbae.jpeg\",\"LongDescription\":\"Furnace and water heater close-up. The home has central air-conditioning\",\"ImageWidth\":930,\"ImageHeight\":1280,\"ImageSizeDescription\":\"930x1280\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.364Z\",\"MediaKey\":\"NST119732756\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/2a76a29a-4c0c-4f37-8861-9d24d4f2c9b4.jpeg\",\"LongDescription\":\"Spacious living room with oak flooring, fireplace, and abundant windows\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.379Z\",\"MediaKey\":\"NST119731308\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/3c15d058-70dc-4bd2-b3b3-54a0af33835c.jpeg\",\"LongDescription\":\"Formal dining room opens to 3 season porch\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.347Z\",\"MediaKey\":\"NST119731309\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/205e8adf-31b2-494a-8399-a5615b5c3013.jpeg\",\"LongDescription\":\"Dining room close-up facing the porch\",\"ImageWidth\":960,\"ImageHeight\":1260,\"ImageSizeDescription\":\"960x1260\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.364Z\",\"MediaKey\":\"NST119732760\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/0540146d-5dd7-4dd1-ac61-2a638e7868aa.jpeg\",\"LongDescription\":\"Kitchen facing the dining room and living room\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.361Z\",\"MediaKey\":\"NST119731311\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/bcfb069a-77f1-455a-830b-d761329d97c4.jpeg\",\"LongDescription\":\"Electric panel with circuit breakers\",\"ImageWidth\":908,\"ImageHeight\":1280,\"ImageSizeDescription\":\"908x1280\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.343Z\",\"MediaKey\":\"NST119732758\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/2972d712-aaf6-4db0-9bf1-3c01b4fc5029.jpeg\",\"LongDescription\":\"Porch interior\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.34Z\",\"MediaKey\":\"NST119731314\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/fb1d57ef-5bcc-4bfc-ba64-e54308459de4.jpeg\",\"LongDescription\":\"Living room and entry, facing West\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.34Z\",\"MediaKey\":\"NST119731310\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/d4caef35-4e25-400f-874e-637e3d848e13.jpeg\",\"LongDescription\":\"Updated 2 car garage interior\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.381Z\",\"MediaKey\":\"NST119732757\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/a7fb76b3-b780-4a70-9cdb-5ee9d2bb0fa9.jpeg\",\"LongDescription\":\"Front entry opposite the closet\",\"ImageWidth\":941,\"ImageHeight\":1280,\"ImageSizeDescription\":\"941x1280\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.34Z\",\"MediaKey\":\"NST119732761\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/0b623115-d47a-4859-9c6f-6f8ef2ffe7a9.jpeg\",\"LongDescription\":\"Large clean unfinished basement with high-efficiency furnace and brand new washer\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.34Z\",\"MediaKey\":\"NST119731313\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/d3efbd65-2e60-49fb-8d42-72f0523dca55.jpeg\",\"LongDescription\":\"Bedroom # 2\",\"ImageWidth\":1280,\"ImageHeight\":853,\"ImageSizeDescription\":\"1280x853\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.34Z\",\"MediaKey\":\"NST119731307\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/aaa266f0-4ffb-4a7f-9121-c18da84a199f.jpeg\",\"LongDescription\":\"Updated custom tiled bath, with glass block window\",\"ImageWidth\":1280,\"ImageHeight\":857,\"ImageSizeDescription\":\"1280x857\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.356Z\",\"MediaKey\":\"NST119731305\"},{\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/cbd810fd-fb5b-45ff-a57b-fe09af78cd62.jpeg\",\"LongDescription\":\"Front view as one approaches the entry\",\"ImageWidth\":1280,\"ImageHeight\":833,\"ImageSizeDescription\":\"1280x833\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.368Z\",\"MediaKey\":\"NST119732759\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/7e4862ce-d033-496b-89b7-21b850a90851.jpeg\",\"LongDescription\":\"Rear view of the home\",\"ImageWidth\":1280,\"ImageHeight\":812,\"ImageSizeDescription\":\"1280x812\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.367Z\",\"MediaKey\":\"NST119731315\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/9040f4c0-c502-4001-b6a6-68e2a4b4ff5a.jpeg\",\"LongDescription\":\"590 Cretin Avenue S. with classic brick exterior, in prime Highland Park!\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-11T05:45:09.36Z\",\"MediaKey\":\"NST119846069\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7817830\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7817830/cf77ce4f-5d14-4ba0-b5d7-9dee444f39b7.jpeg\",\"LongDescription\":\"590 Cretin Avenue S. , Saint Paul\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-06T02:23:54.499Z\",\"MediaKey\":\"NST119686242\"}]","Rooms":"[{\"RoomDimensions\":\"17.1x12\",\"RoomKey\":\"NST115783191\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"10.1x6.1\",\"RoomKey\":\"NST115783196\",\"RoomType\":\"Three Season Porch\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"13.3x10.5\",\"RoomKey\":\"NST115783194\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"12.7x9\",\"RoomKey\":\"NST115783195\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"10.7x10\",\"RoomKey\":\"NST115783192\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\"},{\"RoomDimensions\":\"10.7x8.8\",\"RoomKey\":\"NST115783193\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"590 Cretin Avenue S. with classic brick exterior, in prime Highland Park!\"},{\"Order\":2,\"Remarks\":\"Spacious living room with oak flooring, fireplace, and abundant windows\"},{\"Order\":3,\"Remarks\":\"Living room and entry, facing West\"},{\"Order\":4,\"Remarks\":\"Formal dining room opens to 3 season porch\"},{\"Order\":5,\"Remarks\":\"Porch interior\"},{\"Order\":6,\"Remarks\":\"Kitchen facing East\"},{\"Order\":7,\"Remarks\":\"Kitchen facing the dining room and living room\"},{\"Order\":8,\"Remarks\":\"Bedroom #1, also with hardwood flooring\"},{\"Order\":9,\"Remarks\":\"Updated custom tiled bath, with glass block window\"},{\"Order\":10,\"Remarks\":\"Bedroom # 2\"},{\"Order\":11,\"Remarks\":\"Front entry opposite the closet\"},{\"Order\":12,\"Remarks\":\"Dining room close-up facing the porch\"},{\"Order\":13,\"Remarks\":\"Large clean unfinished basement with high-efficiency furnace and brand new washer\"},{\"Order\":14,\"Remarks\":\"Furnace and water heater close-up. The home has central air-conditioning\"},{\"Order\":15,\"Remarks\":\"Electric panel with circuit breakers\"},{\"Order\":16,\"Remarks\":\"Updated 2 car garage interior\"},{\"Order\":17,\"Remarks\":\"Rear view of the home\"},{\"Order\":18,\"Remarks\":\"590 Cretin Avenue S. , Saint Paul\"},{\"Order\":19,\"Remarks\":\"Front view as one approaches the entry\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19","CustomVTourURL":""}