Bay Lake Realty
Bruce Johnson
Broker/Owner
Bay Lake Realty is Licensed in the State of Minnesota
15929 Wakeman Rd.
Deerwood, MN 56444
Cell Phone: 218-838-1111
E-mail: bruce@baylakerealty.com
{"Id":606008,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7135175","MLSAGENTID":"NST506019437","MLSCOAGENTID":"NST506021687","MLSOFFICEID":"NST252092","ADDRESS":"7412 171st Lane NW","ACRES":0.249,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Sump Pump,Unfinished,Walkout","BATHSTOTAL":2.0,"BEDROOMS":3.0,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":499900.0,"LASTPRICEDATE":"2026-08-28T17:02:07.287","LATITUDE":45.280166,"LENDEROWNED":"No","LISTDATE":"2026-08-28T05:00:00","LISTPRICE":499900.0,"LIVINGAREA":1672.0,"LONGITUDE":-93.45567,"MODIFICATIONTIMESTAMP":"2026-08-29T10:10:12.999","OFFICE_OFFICENAME":"New Home Star","PHOTOCOUNT":10,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"New construction Hudson rambler by Creative Homes in Trott Brook Crossing! This thoughtfully designed 3-bedroom, 2-bath home features main-level living with an open-concept kitchen, dinette and great room with gas fireplace. The private owner’s suite includes an ensuite bath and walk-in closet. Enjoy a spacious 3-car garage and an unfinished walkout basement offering plenty of room for future expansion. Upgrades include soft-close cabinetry, kitchen pantry cabinet, trash/recycling pullout, comfort-height toilets and more. Convenient Ramsey location with quality finishes throughout and room to make the lower level your own.","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"728-Elk River","SCHOOLDISTRICTPHONE":"7632413400","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-28T17:02:07.287","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"171st","STREETNUMBER":"7412","STREETSUFFIX":"Lane","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-08-28T17:06:08.941","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Exterior (Example of a previous home)\"},{\"Order\":2,\"Remarks\":\"Great Room (Example of a previous home)\"},{\"Order\":3,\"Remarks\":\"Kitchen (Example of a previous home)\"},{\"Order\":4,\"Remarks\":\"Great Room (Example of a previous home)\"},{\"Order\":5,\"Remarks\":\"Owners Suite (Example of a previous home)\"},{\"Order\":6,\"Remarks\":\"Owners Suite (Example of a previous home)\"},{\"Order\":7,\"Remarks\":\"Owners Suite Bathroom (Example of a previous home)\"},{\"Order\":8,\"Remarks\":\"Owners Suite Closet (Example of a previous home)\"},{\"Order\":9,\"Remarks\":\"Bathroom 2 (Example of a previous home)\"},{\"Order\":10,\"Remarks\":\"Bedroom 2 (Example of a previous home)\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10","SOURCE":"MG_NST"}
{"ListingKey":"NST7958848","NST_AboveGradeSqFtTotal":"1672","AboveGradeFinishedArea":"1672","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"34","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Professional Mgmt,Sanitation","AssociationName":"First Service Residential","AssociationPhone":"9522772700","AttributionContact":"sophia@creativehomes.com","NST_AttributionName":"Sophia Sturm","Basement":"Daylight/Lookout Windows,Drain Tiled,Sump Pump,Unfinished,Walkout","BasementYN":"True","BathroomsFull":"2","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"1285","BelowGradeFinishedArea":"0","NST_BuilderLicense":"667667","BuilderName":"CREATIVE HOMES INC","CumulativeDaysOnMarket":"0","City":"Ramsey","NST_CommunityName":"Trott Brook Crossing","NST_CompletionDate":"2026-10-31","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Yes","NST_ListPriceHigh":"650900","NST_LotPrice":"20000","Directions":"Take US-10 W to Ramsey Blvd. Turn left on Alpine Dr. Turn right on Variolite St NW. Turn right 170th Avenue. Turn Left and Uranimite. Continue around the curve. Home is on the right. VISIT MODEL HOME FOR MORE INFO - 17013 Traprock St NW, Ramsey, MN 55303","DocumentsCount":"0","DaysOnMarket":"0","ExteriorFeatures":"Vinyl","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1672","FoundationDetails":"Poured Concrete","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"668","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"Elk River","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.280166","NST_LenderOwned":"No","Levels":"One","ListPrice":"499900","ListingContractDate":"2026-08-28T05:00:00Z","ListingId":"NST7135175","LivingArea":"1672","Longitude":"-93.45567","LotSizeArea":"0.249","LotSizeDimensions":"80' x 136'","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1672","NST_ManufacturedHome":"N","NST_ModelHours":"Thursday-Sunday 12-5PM","NST_ModelLocation":"17013 Traprock St NW, Ramsey, MN, 55303","OriginalEntryTimestamp":"2026-08-28T11:51:28Z","ParcelNumber":"093225130021","ParkingFeatures":"Attached Garage","PhotosCount":"10","PhotosChangeTimestamp":"2026-08-28T17:06:08.941Z","PostalCity":"Ramsey","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"New construction Hudson rambler by Creative Homes in Trott Brook Crossing! This thoughtfully designed 3-bedroom, 2-bath home features main-level living with an open-concept kitchen, dinette and great room with gas fireplace. The private owner’s suite includes an ensuite bath and walk-in closet. Enjoy a spacious 3-car garage and an unfinished walkout basement offering plenty of room for future expansion. Upgrades include soft-close cabinetry, kitchen pantry cabinet, trash/recycling pullout, comfort-height toilets and more. Convenient Ramsey location with quality finishes throughout and room to make the lower level your own.","PublicSurveyRange":"25","PublicSurveySection":"09","PublicSurveyTownship":"32","NST_SchoolDistrictFullName":"728 - Elk River","NST_SchoolDistrictNumber":"728","NST_SchoolDistrictPhone":"7632413400","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"171st","StreetNumber":"7412","StreetNumberNumeric":"7412","StreetSuffix":"Lane","SubdivisionName":"Trott Brook Xing","TaxAnnualAmount":"1049","NST_TaxWithAssessments":"1049","TaxYear":"2026","NST_TotalArea":"2957","BuildingAreaTotal":"2957","Township":"Ramsey","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST523071","CoListAgentMlsId":"NST506021687","CoListOfficeName":"New Home Star","ListAgentKey":"NST507139","ListAgentMlsId":"NST506019437","ListOfficeMlsId":"NST252092","ListOfficeName":"New Home Star","ListOfficeKey":"NST1000834","ModificationTimestamp":"2026-08-29T10:10:12.999Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7958848\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"Owners Suite (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/afdcd7b9-e230-4301-b03c-53544778f8d4.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:02:23.431Z\",\"MediaKey\":\"NST124542749\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Great Room (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/d474d33a-7f1a-470b-a8dd-7b74be5c0afa.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:02:23.435Z\",\"MediaKey\":\"NST124542768\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"Kitchen (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/d1cfea8c-6a78-4b0f-8f7a-db8191e24765.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:02:23.486Z\",\"MediaKey\":\"NST124542767\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"Bathroom 2 (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/dcb6d30f-2328-4e87-b259-18948b8927d8.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:05:11.801Z\",\"MediaKey\":\"NST124542729\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"Owners Suite Closet (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/a0e006e8-ee3b-4b72-b26b-9d1258c461d2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:05:11.657Z\",\"MediaKey\":\"NST124542745\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"Owners Suite (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/8d7c64e6-fd7d-4de6-89c1-3c504203e9f2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:02:23.416Z\",\"MediaKey\":\"NST124542733\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"Owners Suite Bathroom (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/277e21d9-e683-4ad2-9e1c-0b9c59bfc848.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:02:23.436Z\",\"MediaKey\":\"NST124542744\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"Bedroom 2 (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/d686e4ae-8394-4a19-b472-a697ca6f62dc.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:05:11.679Z\",\"MediaKey\":\"NST124542730\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"Great Room (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/b118fb00-63f0-41de-9ad4-973eae0e9541.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-08-28T17:02:23.491Z\",\"MediaKey\":\"NST124542756\"},{\"ResourceRecordKey\":\"NST7958848\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"Exterior (Example of a previous home)\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958848/ba8c0dff-9c6a-4587-97c4-7b4defd36703.jpeg\",\"ImageWidth\":882,\"ImageHeight\":482,\"ImageSizeDescription\":\"882x482\",\"MediaModificationTimestamp\":\"2026-08-28T17:00:10.016Z\",\"MediaKey\":\"NST124543051\"}]","Media__ResourceRecordKey":"NST7958848","Media__Order":"6","Media__MediaObjectID":"NST6","Media__LongDescription":"Owners Suite (Example of a previous home)","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7958848/afdcd7b9-e230-4301-b03c-53544778f8d4.jpeg","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"8/28/2026 5:02:23 PM","Media__MediaKey":"NST124542749","DocumentsChangeTimestamp":"2026-08-28T16:52:06.934Z","Rooms":"[{\"RoomDimensions\":\"10'6\\\" x 11'3\\\"\",\"RoomKey\":\"NST116617233\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomType\":\"Dining Room\"},{\"RoomDimensions\":\"13'0\\\" x 14'4\\\"\",\"RoomKey\":\"NST116617234\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomType\":\"Bedroom\"},{\"RoomDimensions\":\"32'4\\\" x 22'0\\\"\",\"RoomKey\":\"NST116617239\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":8,\"RoomType\":\"Garage\"},{\"RoomDimensions\":\"15'2\\\" x 14'11\\\"\",\"RoomKey\":\"NST116617232\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomType\":\"Living Room\"},{\"RoomDimensions\":\"13'8\\\" x 12'0\\\"\",\"RoomKey\":\"NST116617235\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomType\":\"Bedroom 2\"},{\"RoomDimensions\":\"13'0\\\" x 11'8\\\"\",\"RoomKey\":\"NST116617236\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":5,\"RoomType\":\"Bedroom 3\"},{\"RoomDimensions\":\"37'8\\\" x 17'8\\\"\",\"RoomKey\":\"NST116617237\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":6,\"RoomType\":\"Unfinished\"},{\"RoomDimensions\":\"17'4\\\" x 19'2\\\"\",\"RoomKey\":\"NST116617238\",\"RoomLevel\":\"Basement\",\"NST_RoomSortOrder\":7,\"RoomType\":\"Unfinished\"}]","Rooms__RoomDimensions":"10'6\" x 11'3\"","Rooms__RoomKey":"NST116617233","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Exterior (Example of a previous home)\"},{\"Order\":2,\"Remarks\":\"Great Room (Example of a previous home)\"},{\"Order\":3,\"Remarks\":\"Kitchen (Example of a previous home)\"},{\"Order\":4,\"Remarks\":\"Great Room (Example of a previous home)\"},{\"Order\":5,\"Remarks\":\"Owners Suite (Example of a previous home)\"},{\"Order\":6,\"Remarks\":\"Owners Suite (Example of a previous home)\"},{\"Order\":7,\"Remarks\":\"Owners Suite Bathroom (Example of a previous home)\"},{\"Order\":8,\"Remarks\":\"Owners Suite Closet (Example of a previous home)\"},{\"Order\":9,\"Remarks\":\"Bathroom 2 (Example of a previous home)\"},{\"Order\":10,\"Remarks\":\"Bedroom 2 (Example of a previous home)\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10","CustomVTourURL":""}