{"Id":1404430,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6781468","MLSAGENTID":"NST502035539","MLSOFFICEID":"NST252079","ADDRESS":"475 Tanglewood Drive","ACRES":1.47,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Finished,Single Tenant Access","BATHSTOTAL":4.0,"BEDROOMS":5,"CITY":"Shoreview","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Wood Siding","FORECLOSURE":"No","LASTPRICE":550000.0,"LASTPRICEDATE":"2025-09-05T01:57:04.347","LATITUDE":45.086935,"LENDEROWNED":"No","LISTDATE":"2025-09-04T05:00:00","LISTPRICE":550000.0,"LIVINGAREA":2750.0,"LONGITUDE":-93.12058,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-09-05T10:06:14.074","OFFICE_OFFICENAME":"Meta Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":1,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome Home to a Truly Unique Property!\n\nThis one-of-a-kind property offers an up-north retreat feel without ever leaving town. Set on a spacious lot with a huge yard, garden areas (including raspberries!), and a large barn/shed, it’s a dream for anyone who loves space and the outdoors.\n\nInside, you’ll find:\n\nMain Level Living: 3 bedrooms, 2 bathrooms (including a full primary suite), and open living spaces that are filled with natural light. The kitchen, dining, and family areas flow seamlessly with a walk-out to the oversized deck—perfect for entertaining or relaxing.\n\nMother-in-Law Suite: A private studio apartment featuring its own kitchen, 3/4 bath, and washer/dryer.\n\nAdditional Living Options: With three kitchens and two separate apartments with private access, this property has incredible flexibility—live in one, rent the others, or create a multi-generational haven.\n\nOther highlights include:\n\nDetached 2-car garage\n\nHuge barn/shed for storage, hobbies, or workspace\n\nAbundant potential for updates to customize to your style\n\nThis home is full of opportunity—whether you’re looking for rental income, space for extended family, or a property with room to grow. Bring your vision and make it your own!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-05T05:07:11.45","LASTSTATUS":"Coming Soon","STREETNAME":"Tanglewood","STREETNUMBER":"475","STREETSUFFIX":"Drive","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water - In Street,Well","WATERFRONTPRESENT":false,"YEARBUILT":1948,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-05T01:57:04.347","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7796120","LotSizeArea":"1.47","NST_AgeOfProperty":"77","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Deck,Ethernet Wired,Primary Bedroom Walk-In Closet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","Basement":"Egress Window(s),Finished,Single Tenant Access","BasementYN":"True","NST_BathDesc":"3/4 Basement,Bathroom Ensuite,Full Primary,Private Primary,Main Floor 3/4 Bath,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"3","BathroomsTotalInteger":"4","BedroomsTotal":"5","City":"Shoreview","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"0","CumulativeDaysOnMarket":"0","NST_DiningRoomDescription":"Informal Dining Room","Directions":"North of Highway 96 on Hodgson Road, then east on Tanglewood Drive to the second driveway on the left","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-09-05","ConstructionMaterials":"Wood Siding","Fencing":"None","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1132","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Detached,Asphalt","NST_GarageDimensions":"22x22","NST_GarageSquareFeet":"484","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-05T05:00:05Z","NST_InternetOptions":"Cable,Fiber Optic","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-05","Latitude":"45.086935","NST_LenderOwned":"No","ListAgentKey":"NST84908","ListAgentMlsId":"NST502035539","ListingContractDate":"2025-09-04T05:00:00Z","ListOfficeKey":"NST1000822","ListOfficeName":"Meta Realty","ListOfficeMlsId":"NST252079","ListPrice":"550000","LivingArea":"2750","Longitude":"-93.12058","LotFeatures":"Some Trees","LotSizeDimensions":"Approx. 220 ft × 277 ft","LotSizeSquareFeet":"64207.44","LotSizeUnits":"Acres","ListingId":"NST6781468","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","OtherStructures":"Storage Shed","ParcelNumber":"133023240069","GarageSpaces":"2","NST_PatioPorchType":"Deck","PhotosCount":"1","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Welcome Home to a Truly Unique Property!\n\nThis one-of-a-kind property offers an up-north retreat feel without ever leaving town. Set on a spacious lot with a huge yard, garden areas (including raspberries!), and a large barn/shed, it’s a dream for anyone who loves space and the outdoors.\n\nInside, you’ll find:\n\nMain Level Living: 3 bedrooms, 2 bathrooms (including a full primary suite), and open living spaces that are filled with natural light. The kitchen, dining, and family areas flow seamlessly with a walk-out to the oversized deck—perfect for entertaining or relaxing.\n\nMother-in-Law Suite: A private studio apartment featuring its own kitchen, 3/4 bath, and washer/dryer.\n\nAdditional Living Options: With three kitchens and two separate apartments with private access, this property has incredible flexibility—live in one, rent the others, or create a multi-generational haven.\n\nOther highlights include:\n\nDetached 2-car garage\n\nHuge barn/shed for storage, hobbies, or workspace\n\nAbundant potential for updates to customize to your style\n\nThis home is full of opportunity—whether you’re looking for rental income, space for extended family, or a property with room to grow. Bring your vision and make it your own!","PublicSurveyRange":"23","PublicSurveySection":"13","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","Roof":"Asphalt","RoomType":"Kitchen,Living Room,Dining Room,Family Room,Laundry,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Bedroom 5","NST_AboveGradeSqFtTotal":"1600.0000","NST_BelowGradeSqFtTotal":"1375.0000","NST_MainLevelFinishedArea":"1600.0000","BuildingAreaTotal":"2975","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","NST_SecondUnit":"Easily Divided,Existing In-Law w/Kitchen","Sewer":"City Sewer/Connected","NST_SpecialSearch":"All Living Facilities on One Level,Main Floor Laundry","AboveGradeFinishedArea":"1375","BelowGradeFinishedArea":"1375","StateOrProvince":"MN","StandardStatus":"Active","Levels":"One","StreetName":"Tanglewood","StreetNumber":"475","StreetNumberNumeric":"475","StreetSuffix":"Drive","PropertySubType":"Single Family Residence","SubdivisionName":"Old Farm Village","NST_TaxWithAssessments":"5710.0000","TaxYear":"2025","TaxAnnualAmount":"5710","WaterSource":"City Water - In Street,Well","YearBuilt":"1948","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-05T10:06:14.074Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7796120\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Front\",\"ImageWidth\":2080,\"ImageHeight\":1386,\"ImageSizeDescription\":\"2080x1386\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7796120/20dc54da-3e9d-4c96-a7ec-577b81743ff2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-05T01:56:52.012Z\",\"MediaKey\":\"68ba4364938eff3ec3df54de\"}]","PhotosChangeTimestamp":"2025-09-05T01:57:04.347Z","Rooms":"[{\"RoomKey\":\"NST115583729\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x14\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115583730\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x15\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115583731\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x10\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115583732\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"19x11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115583733\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115583734\",\"RoomType\":\"Laundry\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115583735\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x14\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115583736\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115583737\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115583738\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"22x9\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115583739\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"18x14\",\"NST_RoomSortOrder\":\"11\"},{\"RoomKey\":\"NST115583740\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"26x13\",\"NST_RoomSortOrder\":\"12\"},{\"RoomKey\":\"NST115583741\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"13\"},{\"RoomKey\":\"NST115583742\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"16x15\",\"NST_RoomSortOrder\":\"14\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front\"}]","PhotoOrder":"1","CustomVTourURL":""}