$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Coldwell Banker Realty 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. Sandy Smith | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Sandy Smith | Kurilla Real Estate, Ltd., 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. Sandy Smith | Kurilla Real Estate, Ltd. is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Sandy Smith | Kurilla Real Estate, Ltd., a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":1376108,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6726542","MLSAGENTID":"NST506097318","MLSOFFICEID":"NST8237","ADDRESS":"4900 Hodgson Connection","ACRES":0.34,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Walkout","BATHSTOTAL":3.0,"BEDROOMS":5,"CITY":"Shoreview","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":475000.0,"LASTPRICEDATE":"2025-06-28T18:00:04.18","LATITUDE":45.089435,"LENDEROWNED":"No","LISTDATE":"2025-06-28T05:00:00","LISTPRICE":475000.0,"LIVINGAREA":2557.0,"LONGITUDE":-93.126524,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-06-28T18:32:03.659","OFFICE_OFFICENAME":"Coldwell Banker Realty","OUTBUILDINGS":"Storage Shed","PHOTOCOUNT":20,"POSTALCODE":"55126","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-28T18:00:04.18","LASTSTATUS":"Active","STREETNAME":"Hodgson Connection","STREETNUMBER":"4900","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1988,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-06-28T18:00:04.179","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":"NST7748260","LotSizeArea":"0.34","NST_AgeOfProperty":"37","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Deck,Main Floor Primary Bedroom","Appliances":"Dishwasher,Dryer,Range,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","NST_AttributionContact":"612-247-5106","NST_AttributionName":"Krista J. Wolter","Basement":"Daylight/Lookout Windows,Egress Window(s),Finished,Full,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Private Primary,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"3","BedroomsTotal":"5","City":"Shoreview","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Breakfast Bar,Eat In Kitchen,Separate/Formal Dining Room","Directions":"From Tanglewood Drive, go north on Hodgson Road Connection to home on right.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","ConstructionMaterials":"Vinyl Siding","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"1350","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Curbs,Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Concrete","NST_GarageSquareFeet":"834","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-28T17:57:22Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-28","Latitude":"45.089435","NST_LenderOwned":"No","ListAgentKey":"NST68568","ListAgentMlsId":"NST506097318","ListingContractDate":"2025-06-28T05:00:00Z","ListOfficeKey":"NST16731","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST8237","ListPrice":"475000","LivingArea":"2557","NST_LockBoxSource":"SPAAR","LockBoxType":"Supra","Longitude":"-93.126524","LotFeatures":"Some Trees","LotSizeDimensions":"80x185","LotSizeSquareFeet":"14810.4","LotSizeUnits":"Acres","ListingId":"NST6726542","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"SPAAR","OtherStructures":"Storage Shed","ParcelNumber":"133023230069","GarageSpaces":"3","NST_PatioPorchType":"Deck","PhotosCount":"20","PostalCity":"Saint Paul","PostalCode":"55126","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicSurveyRange":"23","PublicSurveySection":"13","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt,Pitched","RoomType":"Living Room,Dining Room,Family Room,Kitchen,Bedroom 1,Bedroom 2,Bedroom 3,Bedroom 4,Bedroom 5,Kitchen- 2nd,Deck","NST_AboveGradeSqFtTotal":"1350.0000","NST_BelowGradeSqFtTotal":"1350.0000","NST_MainLevelFinishedArea":"1331.0000","BuildingAreaTotal":"2700","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"3 BR on One Level,Main Floor Primary,Main Floor Bedroom,Primary Bdr Suite","AboveGradeFinishedArea":"1350","BelowGradeFinishedArea":"1207","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetName":"Hodgson Connection","StreetNumber":"4900","StreetNumberNumeric":"4900","PropertySubType":"Single Family Residence","SubdivisionName":"Roberts Turtle Lake Heights","NST_TaxWithAssessments":"105.0000","TaxYear":"2025","TaxAnnualAmount":"105","WaterSource":"City Water/Connected","YearBuilt":"1988","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-28T18:32:03.659Z","PhotosChangeTimestamp":"2025-06-28T18:00:04.179Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7748260\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1357,\"ImageHeight\":902,\"ImageSizeDescription\":\"1357x902\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/14643032-2bad-41a5-92ea-23ecc467d62f.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.86Z\",\"MediaKey\":\"68602d798970963ab172111a\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/bc90d491-4591-44bb-815d-8dacb8c356c9.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.859Z\",\"MediaKey\":\"68602d798970963ab172111b\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1361,\"ImageHeight\":901,\"ImageSizeDescription\":\"1361x901\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/0d254e6f-08e2-4f11-8348-a4cd01ae6798.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.847Z\",\"MediaKey\":\"68602d798970963ab172111c\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1289,\"ImageHeight\":849,\"ImageSizeDescription\":\"1289x849\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/577b00db-be10-4d17-b84c-d85b4c4ad218.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.869Z\",\"MediaKey\":\"68602d798970963ab172111d\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1469,\"ImageHeight\":975,\"ImageSizeDescription\":\"1469x975\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/d0ea3e33-bc5c-4431-afb5-3b2057056154.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.862Z\",\"MediaKey\":\"68602d798970963ab172111e\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/ab407e06-1544-454a-9bb2-112b3f1f947d.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.86Z\",\"MediaKey\":\"68602d798970963ab172111f\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1401,\"ImageHeight\":935,\"ImageSizeDescription\":\"1401x935\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/72ca07eb-7a4d-46de-90fe-6793e30ef0e6.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.833Z\",\"MediaKey\":\"68602d798970963ab1721120\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1393,\"ImageHeight\":926,\"ImageSizeDescription\":\"1393x926\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/b3d965e4-3b60-4aaa-abb7-e981cbe67e4d.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.841Z\",\"MediaKey\":\"68602d798970963ab1721121\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1445,\"ImageHeight\":959,\"ImageSizeDescription\":\"1445x959\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/1a56b158-d0b4-4507-961f-e53b9daea0d3.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.837Z\",\"MediaKey\":\"68602d798970963ab1721122\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1463,\"ImageHeight\":975,\"ImageSizeDescription\":\"1463x975\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/4c8dba01-4113-4dcb-a1c4-4753a62d574a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.832Z\",\"MediaKey\":\"68602d798970963ab1721123\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/75fa9a9f-4d0d-4be9-9dcb-869c63f4f95b.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.895Z\",\"MediaKey\":\"68602d798970963ab1721124\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1472,\"ImageHeight\":981,\"ImageSizeDescription\":\"1472x981\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/e18dd171-9962-4c7b-9ae4-96880fff35aa.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.827Z\",\"MediaKey\":\"68602d798970963ab1721125\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1600,\"ImageHeight\":1067,\"ImageSizeDescription\":\"1600x1067\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/43596d51-86b0-436c-8c84-f06252cf4bb2.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.845Z\",\"MediaKey\":\"68602d798970963ab1721126\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/438d3575-178c-418e-b400-72a8de918119.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.877Z\",\"MediaKey\":\"68602d798970963ab1721127\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1486,\"ImageHeight\":990,\"ImageSizeDescription\":\"1486x990\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/9e0858bc-adb4-4d16-b977-d748c54a4a39.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.878Z\",\"MediaKey\":\"68602d798970963ab1721128\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/c19c53df-d01c-4c6d-b380-f3ee31d5b885.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.847Z\",\"MediaKey\":\"68602d798970963ab1721129\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/f655845e-fb37-4f2d-829d-90846d26d9b9.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.844Z\",\"MediaKey\":\"68602d798970963ab172112a\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":18,\"MediaObjectID\":\"18\",\"ImageWidth\":1498,\"ImageHeight\":992,\"ImageSizeDescription\":\"1498x992\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/5b434cce-62d6-4253-b97b-df8b2def9cb9.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.843Z\",\"MediaKey\":\"68602d798970963ab172112b\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":19,\"MediaObjectID\":\"19\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/c658f4e7-3f00-441a-acb4-10adee6291c4.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.873Z\",\"MediaKey\":\"68602d798970963ab172112c\"},{\"ResourceRecordKey\":\"NST7748260\",\"Order\":20,\"MediaObjectID\":\"20\",\"ImageWidth\":1600,\"ImageHeight\":1066,\"ImageSizeDescription\":\"1600x1066\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7748260/68440ffc-ced2-471a-b742-77216dbff469.jpeg\",\"MediaModificationTimestamp\":\"2025-06-28T17:59:21.917Z\",\"MediaKey\":\"68602d798970963ab172112d\"}]","Rooms":"[{\"RoomKey\":\"NST115356812\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"15x16\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115356813\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115356814\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"13x20\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115356815\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x12\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115356816\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x17\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115356817\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x12\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115356818\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x11\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115356819\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"13x15\",\"NST_RoomSortOrder\":\"8\"},{\"RoomKey\":\"NST115356820\",\"RoomType\":\"Bedroom 5\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11x13\",\"NST_RoomSortOrder\":\"9\"},{\"RoomKey\":\"NST115356821\",\"RoomType\":\"Kitchen- 2nd\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"11x13\",\"NST_RoomSortOrder\":\"10\"},{\"RoomKey\":\"NST115356822\",\"RoomType\":\"Deck\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x12\",\"NST_RoomSortOrder\":\"11\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}