{"Id":1397755,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6775031","MLSAGENTID":"NST502044902","MLSOFFICEID":"NST251886","ADDRESS":"1870 Clarence Street N","ACRES":0.25,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Maplewood","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":319900.0,"LASTPRICEDATE":"2025-09-03T21:14:03.837","LATITUDE":44.997568,"LENDEROWNED":"No","LISTDATE":"2025-08-19T05:00:00","LISTPRICE":309900.0,"LIVINGAREA":1405.0,"LONGITUDE":-93.042746,"MODIFICATIONTIMESTAMP":"2025-09-03T21:14:03.837","OFFICE_OFFICENAME":"Inspire Realty","PHOTOCOUNT":20,"POSTALCODE":"55109","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Super cute corner lot in quiet Maplewood neighborhood. This quaint house has charm galore! On the main level there's a nicely appointed kitchen with granite counters, surprising storage and great counter space. The adjoining room can either be a dining room or living room based upon your life style. Continuing on the main level is a huge family room! Two living spaces that can flow together or remain separate. There's a huge bedroom upstairs with loads of storage. The basement already complete with second bathroom and is waiting for your ideas to make it complete! Outside there's a huge back yard with patio, love-seat swing and a storage shed. This quiet, corner lot home has it all at an extremely affordable price!","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"651-748-7410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-08-22T05:03:08.14","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"Clarence","STREETNUMBER":"1870","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1935,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-08-20T21:19:04.097","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Cute, quiet home on a huge corner lot.\"},{\"Order\":3,\"Remarks\":\"View from the front entryway. Notice the natural wood floors, working fireplace. What a cozy space.\"},{\"Order\":4,\"Remarks\":\"View from the kitchen entryway.\"},{\"Order\":5,\"Remarks\":\"View from the family room doorway.\"},{\"Order\":6,\"Remarks\":\"Clever kitchen with surprising storage and counter space!\"},{\"Order\":8,\"Remarks\":\"Newer stainless appliances.\"},{\"Order\":10,\"Remarks\":\"This massive, light-filled family/sun room off the living room is such a great space!\"},{\"Order\":11,\"Remarks\":\"Owner's bedroom.\"},{\"Order\":12,\"Remarks\":\"Nicely appointed main level bathroom.\"},{\"Order\":13,\"Remarks\":\"Bedroom 2.\"},{\"Order\":14,\"Remarks\":\"Upstairs bedroom used as an office (and a napping place from overnight shift).\"},{\"Order\":15,\"Remarks\":\"Great storage area or convert to living space!\"},{\"Order\":16,\"Remarks\":\"Lower level 3/4 bath.\"},{\"Order\":17,\"Remarks\":\"Laundry.\"},{\"Order\":18,\"Remarks\":\"HUGE back yard! Swing set is negotiable.\"},{\"Order\":19,\"Remarks\":\"Cute love seat swing.\"},{\"Order\":20,\"Remarks\":\"Huge patio - great for your bar-b-que with family and friends!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7790484","LotSizeArea":"0.25","NST_AgeOfProperty":"90","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Full","BasementYN":"True","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Maplewood","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air,Window Unit(s)","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"12","CumulativeDaysOnMarket":"12","Directions":"White Bear Ave South Of Hwy 36 to Frost Ave West to Clarence South To Home On Left","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-08-22","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","NST_FoundationDimensions":"36x24","FoundationArea":"864","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached","NST_GarageDimensions":"11x20","NST_GarageSquareFeet":"220","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-08-22T05:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-03","Latitude":"44.997568","NST_LenderOwned":"No","ListAgentKey":"NST103502","ListAgentMlsId":"NST502044902","ListingContractDate":"2025-08-19T05:00:00Z","ListOfficeKey":"NST1000544","ListOfficeName":"Inspire Realty","ListOfficeMlsId":"NST251886","ListPrice":"309900","LivingArea":"1405","Longitude":"-93.042746","LotSizeDimensions":"80x134","LotSizeSquareFeet":"10715.76","LotSizeUnits":"Acres","ListingId":"NST6775031","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"152922320033","GarageSpaces":"1","PhotosCount":"20","PostalCity":"Saint Paul","PostalCode":"55109","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Super cute corner lot in quiet Maplewood neighborhood. This quaint house has charm galore! On the main level there's a nicely appointed kitchen with granite counters, surprising storage and great counter space. The adjoining room can either be a dining room or living room based upon your life style. Continuing on the main level is a huge family room! Two living spaces that can flow together or remain separate. There's a huge bedroom upstairs with loads of storage. The basement already complete with second bathroom and is waiting for your ideas to make it complete! Outside there's a huge back yard with patio, love-seat swing and a storage shed. This quiet, corner lot home has it all at an extremely affordable price!","PublicSurveyRange":"22","PublicSurveySection":"15","PublicSurveyTownship":"29","NST_RentalLicenseYN":"No","RoomType":"Living Room,Kitchen,Family Room,Bedroom 1,Bedroom 2,Bedroom 3","NST_AboveGradeSqFtTotal":"1360.0000","NST_BelowGradeSqFtTotal":"864.0000","NST_MainLevelFinishedArea":"1144.0000","BuildingAreaTotal":"2224","HighSchoolDistrict":"North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"651-748-7410","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"1360","BelowGradeFinishedArea":"45","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One and One Half","StreetDirSuffix":"N","StreetName":"Clarence","StreetNumber":"1870","StreetNumberNumeric":"1870","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Gladstone, Ramsey Co, , Minn","NST_TaxWithAssessments":"4322.0000","TaxYear":"2025","TaxAnnualAmount":"4322","WaterSource":"City Water/Connected","YearBuilt":"1935","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-03T21:14:03.837Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7790484\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Cute, quiet home on a huge corner lot.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/e1a6fc7c-28d6-4a82-a65f-473fb5d5b191.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.64Z\",\"MediaKey\":\"68a6373271911b3a76490203\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/555cb0e1-2891-4115-8cff-4d16b4cda5f5.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.735Z\",\"MediaKey\":\"68a6373271911b3a76490204\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"View from the front entryway. Notice the natural wood floors, working fireplace. What a cozy space.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/0752ba3c-7a2a-4a5e-b485-cc2e7d753111.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.66Z\",\"MediaKey\":\"68a6373271911b3a76490205\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"View from the kitchen entryway.\",\"ImageWidth\":2048,\"ImageHeight\":1366,\"ImageSizeDescription\":\"2048x1366\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/f5b3fcab-3b18-406f-a469-7a595455b20a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.638Z\",\"MediaKey\":\"68a6373271911b3a76490206\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"View from the family room doorway.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/5afa7d10-a809-4405-a37b-d95249c6540f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.567Z\",\"MediaKey\":\"68a6373271911b3a76490207\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Clever kitchen with surprising storage and counter space!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/91f62c68-3024-47ee-a760-f26a3b7284d9.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.613Z\",\"MediaKey\":\"68a6373271911b3a76490208\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/73c97e87-79eb-4e59-858f-4bc583f0ae19.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.735Z\",\"MediaKey\":\"68a6373271911b3a76490209\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Newer stainless appliances.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/62dd3f87-b4e2-416e-9a34-72936a7f59b3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.592Z\",\"MediaKey\":\"68a6373271911b3a7649020a\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/3a2132dd-466a-4fa5-ad8a-65c30ae2600f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.643Z\",\"MediaKey\":\"68a6373271911b3a7649020d\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"This massive, light-filled family/sun room off the living room is such a great space!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/978889a0-c67f-4cb3-b8bb-69e2c532ca6a.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.596Z\",\"MediaKey\":\"68a6373271911b3a7649020b\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Owner's bedroom.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/5280781c-4ace-4815-ab7d-77bdcf103830.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.634Z\",\"MediaKey\":\"68a6373271911b3a7649020c\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Nicely appointed main level bathroom.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/ac67c85d-d9fd-4ca2-9bb3-36f18234540c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.567Z\",\"MediaKey\":\"68a6373271911b3a7649020e\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Bedroom 2.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/6834763e-c37f-4710-82ac-289b64befcfb.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.73Z\",\"MediaKey\":\"68a6373271911b3a7649020f\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Upstairs bedroom used as an office (and a napping place from overnight shift).\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/3f0c6dc9-7c04-4ae6-ba01-44e0c7f5c21c.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.564Z\",\"MediaKey\":\"68a6373271911b3a76490210\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":15,\"MediaObjectID\":\"15\",\"LongDescription\":\"Great storage area or convert to living space!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/2027152e-5570-4aa6-a79a-f52980f010b3.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.593Z\",\"MediaKey\":\"68a6373271911b3a76490211\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":16,\"MediaObjectID\":\"16\",\"LongDescription\":\"Lower level 3/4 bath.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/36dc7937-2fdd-4120-84ef-e3a53b7194da.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.629Z\",\"MediaKey\":\"68a6373271911b3a76490212\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":17,\"MediaObjectID\":\"17\",\"LongDescription\":\"Laundry.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/2933e8e3-b693-47b5-baf7-efced3a55759.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.6Z\",\"MediaKey\":\"68a6373271911b3a76490213\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":18,\"MediaObjectID\":\"18\",\"LongDescription\":\"HUGE back yard! Swing set is negotiable.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/ab15b439-a309-40fe-9e7e-756b17357466.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.659Z\",\"MediaKey\":\"68a6373271911b3a76490214\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":19,\"MediaObjectID\":\"19\",\"LongDescription\":\"Cute love seat swing.\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/79571171-c3a0-431b-91d1-fa7846051b92.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.681Z\",\"MediaKey\":\"68a6373271911b3a76490215\"},{\"ResourceRecordKey\":\"NST7790484\",\"Order\":20,\"MediaObjectID\":\"20\",\"LongDescription\":\"Huge patio - great for your bar-b-que with family and friends!\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7790484/324903a0-43a1-4d33-a63d-f13cbeab528f.jpeg\",\"MediaModificationTimestamp\":\"2025-08-20T20:59:30.606Z\",\"MediaKey\":\"68a6373271911b3a76490216\"}]","PhotosChangeTimestamp":"2025-08-20T21:19:04.097Z","Rooms":"[{\"RoomKey\":\"NST115533009\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x17\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115533010\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115533011\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x20\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115533012\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115533013\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x11\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115533014\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"18x12\",\"NST_RoomSortOrder\":\"6\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Cute, quiet home on a huge corner lot.\"},{\"Order\":3,\"Remarks\":\"View from the front entryway. Notice the natural wood floors, working fireplace. What a cozy space.\"},{\"Order\":4,\"Remarks\":\"View from the kitchen entryway.\"},{\"Order\":5,\"Remarks\":\"View from the family room doorway.\"},{\"Order\":6,\"Remarks\":\"Clever kitchen with surprising storage and counter space!\"},{\"Order\":8,\"Remarks\":\"Newer stainless appliances.\"},{\"Order\":10,\"Remarks\":\"This massive, light-filled family/sun room off the living room is such a great space!\"},{\"Order\":11,\"Remarks\":\"Owner's bedroom.\"},{\"Order\":12,\"Remarks\":\"Nicely appointed main level bathroom.\"},{\"Order\":13,\"Remarks\":\"Bedroom 2.\"},{\"Order\":14,\"Remarks\":\"Upstairs bedroom used as an office (and a napping place from overnight shift).\"},{\"Order\":15,\"Remarks\":\"Great storage area or convert to living space!\"},{\"Order\":16,\"Remarks\":\"Lower level 3/4 bath.\"},{\"Order\":17,\"Remarks\":\"Laundry.\"},{\"Order\":18,\"Remarks\":\"HUGE back yard! Swing set is negotiable.\"},{\"Order\":19,\"Remarks\":\"Cute love seat swing.\"},{\"Order\":20,\"Remarks\":\"Huge patio - great for your bar-b-que with family and friends!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}