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":1415168,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6797324","MLSAGENTID":"NST502052441","MLSOFFICEID":"NST6836","ADDRESS":"16810 Coquina Street NW","ACRES":0.28,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Storage Space,Unfinished,Walkout","BATHSTOTAL":1.0,"BEDROOMS":2,"CITY":"Ramsey","CONTINGENCY":"None","COUNTY":"Anoka","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":413900.0,"LASTPRICEDATE":"2025-09-30T21:02:04.04","LATITUDE":45.27682454,"LENDEROWNED":"No","LISTDATE":"2025-09-30T05:00:00","LISTPRICE":413900.0,"LIVINGAREA":986.0,"LONGITUDE":-93.43546253,"MODIFICATIONTIMESTAMP":"2025-09-30T21:02:04.041","OFFICE_OFFICENAME":"Lennar Sales Corp","PHOTOCOUNT":14,"POSTALCODE":"55303","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"This stunning Emily floorplan, available for a December closing, is designed for effortless living. Featuring two bedrooms, including a spacious primary suite with a walk-in closet and a private bath, the home also boasts a stylish kitchen with a large center island, quartz countertops, and stainless steel appliances. An unfinished walkout lower level provides room to grow, while the fully sodded yard with landscaping, an irrigation system, and a 3-car garage adds convenience. With no HOA and new home warranties included, this home in Harmony Farms offers a welcoming community close to shopping, dining, parks, and easy highway access. Ask about how to qualify for savings up to $5,000 with the use of the Seller's Preferred Lender!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"11-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"763-506-1000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-09-30T21:02:04.04","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Coquina","STREETNUMBER":"16810","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-09-30T21:02:04.041","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"(Exterior rendering, actual homes finishes will vary) Excellent curb appeal! Introducing our Emily plan with superior craftsmanship and contemporary design, this is a wonderful place to call home.\"},{\"Order\":2,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) This spacious kitchen features a large center island, LVP floors, stainless appliances and more.\"},{\"Order\":3,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Enjoy plenty of seating at the kitchen island and dining area adjacent to the kitchen. Perfect for entertaining or having a family meal together.\"},{\"Order\":4,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The expansive kitchen area transitions seamlessly into the open and spacious great room area.\"},{\"Order\":5,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Notice the stunning natural light pouring into this spacious great room.\"},{\"Order\":6,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Find your retreat in this stunning primary bedroom. Enjoy the exclusivity of a huge walk-in closet and connected bathroom.\"},{\"Order\":7,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Another view of the spacious primary bedroom.\"},{\"Order\":8,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The primary bedroom features a wonderful walk-in closet.\"},{\"Order\":9,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The main level bathroom provides plenty of space!\"},{\"Order\":10,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The secondary bedroom on the main level. There are two more bedrooms on the lower level.\"},{\"Order\":11,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The main entrance leads to the upper level and the lower level.\"},{\"Order\":12,\"Remarks\":\"Emily main level.\"},{\"Order\":13,\"Remarks\":\"Emily lower level.\"},{\"Order\":14,\"Remarks\":\"Welcome to Harmony Farms!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","SOURCE":"MG_NST"}
{"ListingKey":"NST7809727","LotSizeArea":"0.28","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Main Floor Primary Bedroom,Natural Woodwork,Paneled Doors,Porch,Vaulted Ceiling(s),Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Humidifier,Microwave,Range,Refrigerator,Stainless Steel Appliances,Tankless Water Heater","NST_AssessmentPending":"Unknown","AssociationFeeFrequency":"N/A","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","AvailabilityDate":"2025-12-28T06:00:00Z","Basement":"Storage Space,Unfinished,Walkout","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"1","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BuilderAssociationID":"Builders Association of the Twin Cities","NST_BuilderLicense":"1413","BuilderName":"LENNAR","CarportSpaces":"0","City":"Ramsey","PropertyType":"Residential","NST_CommunityName":"Harmony Farms","NST_CompletionDate":"2025-12-28","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"Take US-169 N to Nowthen Blvd NW in Ramsey. Continue onto State Hwy 47 N/N Ferry St. Use the left 2 lanes to turn left onto Nowthen Blvd NW.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"200+ Amp Service","ConstructionMaterials":"Brick/Stone,Vinyl Siding","Fencing":"None","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"986","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_GarageSquareFeet":"654","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-09-30T20:59:11Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-09-30","Latitude":"45.2768245437","NST_LenderOwned":"No","ListAgentKey":"NST505534","ListAgentMlsId":"NST502052441","ListingContractDate":"2025-09-30T05:00:00Z","ListOfficeKey":"NST10379","ListOfficeName":"Lennar Sales Corp","ListOfficeMlsId":"NST6836","ListPrice":"413900","LivingArea":"986","Longitude":"-93.4354625251","LotSizeDimensions":"TBD","LotSizeSquareFeet":"12196.8","LotSizeUnits":"Acres","ListingId":"NST6797324","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","NST_ModelHours":"Daily 11-6pm","NST_ModelLocation":"16797 Ebony Street NW, Ramsey, MN 55303","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"TBD","GarageSpaces":"3","NST_PatioPorchType":"Front Porch","PhotosCount":"14","PoolFeatures":"None","PostalCity":"Ramsey","PostalCode":"55303","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"This stunning Emily floorplan, available for a December closing, is designed for effortless living. Featuring two bedrooms, including a spacious primary suite with a walk-in closet and a private bath, the home also boasts a stylish kitchen with a large center island, quartz countertops, and stainless steel appliances. An unfinished walkout lower level provides room to grow, while the fully sodded yard with landscaping, an irrigation system, and a 3-car garage adds convenience. With no HOA and new home warranties included, this home in Harmony Farms offers a welcoming community close to shopping, dining, parks, and easy highway access. Ask about how to qualify for savings up to $5,000 with the use of the Seller's Preferred Lender!","NST_RentalLicenseYN":"No","Roof":"Age 8 Years or Less","RoomType":"Kitchen,Informal Dining Room,Great Room,Bedroom 1,Bedroom 2","NST_AboveGradeSqFtTotal":"986.0000","NST_BelowGradeSqFtTotal":"958.0000","NST_MainLevelFinishedArea":"972.0000","BuildingAreaTotal":"1944","HighSchoolDistrict":"Anoka-Hennepin","NST_SchoolDistrictNumber":"11","NST_SchoolDistrictPhone":"763-506-1000","Sewer":"City Sewer/Connected","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom","AboveGradeFinishedArea":"986","BelowGradeFinishedArea":"0","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetDirSuffix":"NW","StreetName":"Coquina","StreetNumber":"16810","StreetNumberNumeric":"16810","StreetSuffix":"Street","PropertySubType":"Single Family Residence","SubdivisionName":"Harmony Farms","NST_TaxWithAssessments":"0.0000","TaxYear":"2025","TaxAnnualAmount":"0","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-09-30T21:02:04.041Z","PhotosChangeTimestamp":"2025-09-30T21:02:04.041Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7809727\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"(Exterior rendering, actual homes finishes will vary) Excellent curb appeal! Introducing our Emily plan with superior craftsmanship and contemporary design, this is a wonderful place to call home.\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/9ec25b1c-da0f-4485-8eb9-24256b111388.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.143Z\",\"MediaKey\":\"68dc45295cf7b00b36c3745f\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) This spacious kitchen features a large center island, LVP floors, stainless appliances and more.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/77aa80ca-a39c-4bae-9db7-0d762d213633.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.154Z\",\"MediaKey\":\"68dc45295cf7b00b36c37460\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) Enjoy plenty of seating at the kitchen island and dining area adjacent to the kitchen. Perfect for entertaining or having a family meal together.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/6afa391b-73b8-4014-822c-65d74415e651.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.133Z\",\"MediaKey\":\"68dc45295cf7b00b36c37461\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The expansive kitchen area transitions seamlessly into the open and spacious great room area.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/64c1c740-6159-4850-bdd6-2cac71c816c0.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.143Z\",\"MediaKey\":\"68dc45295cf7b00b36c37462\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) Notice the stunning natural light pouring into this spacious great room.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/58696964-790f-460f-a4ef-cf09ee1927a5.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.145Z\",\"MediaKey\":\"68dc45295cf7b00b36c37463\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) Find your retreat in this stunning primary bedroom. Enjoy the exclusivity of a huge walk-in closet and connected bathroom.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/eb549d47-42a7-4f41-aac1-9f14d6dda7e9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.109Z\",\"MediaKey\":\"68dc45295cf7b00b36c37464\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) Another view of the spacious primary bedroom.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/95c75e8c-18ec-4827-975e-f3766585d4ac.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.121Z\",\"MediaKey\":\"68dc45295cf7b00b36c37465\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The primary bedroom features a wonderful walk-in closet.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/7edb51ab-8a88-4b16-8f89-e9ef4d235cd9.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.125Z\",\"MediaKey\":\"68dc45295cf7b00b36c37466\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The main level bathroom provides plenty of space!\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/e819e715-e8d0-4606-8ffe-ba6f427ab0b2.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.111Z\",\"MediaKey\":\"68dc45295cf7b00b36c37467\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The secondary bedroom on the main level. There are two more bedrooms on the lower level.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/d30d529b-36f2-4772-af70-b37862840960.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.12Z\",\"MediaKey\":\"68dc45295cf7b00b36c37468\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The main entrance leads to the upper level and the lower level.\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/bea43e53-04e8-4e35-b166-07a3cc6ea110.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.128Z\",\"MediaKey\":\"68dc45295cf7b00b36c37469\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Emily main level.\",\"ImageWidth\":764,\"ImageHeight\":683,\"ImageSizeDescription\":\"764x683\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/0cb7959a-5ebd-44d6-b0dd-b0c07b7fdfd6.png\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.12Z\",\"MediaKey\":\"68dc45295cf7b00b36c3746a\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Emily lower level.\",\"ImageWidth\":892,\"ImageHeight\":751,\"ImageSizeDescription\":\"892x751\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/d35cbfe7-31c9-4233-a553-c8a3b441431b.png\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.118Z\",\"MediaKey\":\"68dc45295cf7b00b36c3746b\"},{\"ResourceRecordKey\":\"NST7809727\",\"Order\":14,\"MediaObjectID\":\"14\",\"LongDescription\":\"Welcome to Harmony Farms!\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7809727/b9e1e6c6-dfd2-4f5e-b829-262156700deb.jpeg\",\"MediaModificationTimestamp\":\"2025-09-30T21:01:29.134Z\",\"MediaKey\":\"68dc45295cf7b00b36c3746c\"}]","Rooms":"[{\"RoomKey\":\"NST115661477\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11x10\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115661478\",\"RoomType\":\"Informal Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"7x11\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115661479\",\"RoomType\":\"Great Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115661480\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"12x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115661481\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"5\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"(Exterior rendering, actual homes finishes will vary) Excellent curb appeal! Introducing our Emily plan with superior craftsmanship and contemporary design, this is a wonderful place to call home.\"},{\"Order\":2,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) This spacious kitchen features a large center island, LVP floors, stainless appliances and more.\"},{\"Order\":3,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Enjoy plenty of seating at the kitchen island and dining area adjacent to the kitchen. Perfect for entertaining or having a family meal together.\"},{\"Order\":4,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The expansive kitchen area transitions seamlessly into the open and spacious great room area.\"},{\"Order\":5,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Notice the stunning natural light pouring into this spacious great room.\"},{\"Order\":6,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Find your retreat in this stunning primary bedroom. Enjoy the exclusivity of a huge walk-in closet and connected bathroom.\"},{\"Order\":7,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) Another view of the spacious primary bedroom.\"},{\"Order\":8,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The primary bedroom features a wonderful walk-in closet.\"},{\"Order\":9,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The main level bathroom provides plenty of space!\"},{\"Order\":10,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The secondary bedroom on the main level. There are two more bedrooms on the lower level.\"},{\"Order\":11,\"Remarks\":\"(Photo of an inventory home, actual homes finishes will vary) The main entrance leads to the upper level and the lower level.\"},{\"Order\":12,\"Remarks\":\"Emily main level.\"},{\"Order\":13,\"Remarks\":\"Emily lower level.\"},{\"Order\":14,\"Remarks\":\"Welcome to Harmony Farms!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14","CustomVTourURL":""}