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":493616,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6811845","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,"FORECLOSURE":"No","LASTPRICE":397544.0,"LASTPRICEDATE":"2025-12-16T19:54:05.62","LATITUDE":45.27682454,"LENDEROWNED":"No","LISTDATE":"2025-10-31T05:00:00","LISTPRICE":379685.0,"LIVINGAREA":986.0,"LONGITUDE":-93.43546253,"MODIFICATIONTIMESTAMP":"2025-12-16T20:13:05.288","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 a 4.5% 7/6 ARM plus $7,500 in CC with the use of the Seller's Preferred Lender!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"663-Anoka-Hennepin","SCHOOLDISTRICTPHONE":"7635061000","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-10-31T15:30:04.8","LASTSTATUS":"Active","STREETDIRSUFFIX":"NW","STREETNAME":"Coquina","STREETNUMBER":"16810","STREETSUFFIX":"Street","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-12-16T20:13:05.288","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.\"},{\"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":"NST7822374","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Humidifier,Microwave,Range,Refrigerator,Stainless Steel Appliances,Tankless Water Heater","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2025-12-29T06:00:00Z","Basement":"Storage Space,Unfinished,Walkout","BuilderName":"LENNAR","CarportSpaces":"0","City":"Ramsey","NST_CommunityName":"Harmony Farms","Contingency":"None","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.","Electric":"200+ Amp Service","FireplaceYN":"False","NST_Fuel":"Natural Gas","Latitude":"45.2768245437","ListPrice":"379685","LivingArea":"986","Longitude":"-93.4354625251","LotSizeDimensions":"TBD","LotSizeUnits":"Acres","NST_ModelHours":"Daily 11-6pm","NST_ModelLocation":"16797 Ebony Street NW, Ramsey, MN 55303","ParcelNumber":"TBD","PostalCity":"Ramsey","PostalCode":"55303","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 a 4.5% 7/6 ARM plus $7,500 in CC with the use of the Seller's Preferred Lender!","Roof":"Age 8 Years or Less","NST_SchoolDistrictPhone":"7635061000","Sewer":"City Sewer/Connected","StateOrProvince":"MN","StreetDirSuffix":"NW","StreetName":"Coquina","StreetNumber":"16810","StreetNumberNumeric":"16810","StreetSuffix":"Street","TaxYear":"2025","YearBuilt":"2025","NST_AboveGradeSqFtTotal":"986","AboveGradeFinishedArea":"986","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","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","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationFeeFrequency":"N/A","BasementYN":"True","NST_BathDesc":"Main Floor Full Bath","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"2","NST_BelowGradeSqFtTotal":"958","BelowGradeFinishedArea":"0","NST_BuilderAssociationID":"Builders Association of the Twin Cities","NST_BuilderLicense":"1413","CumulativeDaysOnMarket":"0","NST_CompletionDate":"2025-12-29","NewConstructionYN":"True","Cooling":"Central Air","CountyOrParish":"Anoka","NST_DPResource":"Yes","NST_DiningRoomDescription":"Kitchen/Dining Room","DaysOnMarket":"0","Fencing":"None","FireplacesTotal":"0","FoundationArea":"986","NST_FractionalOwnershipYN":"No","NST_GarageSquareFeet":"654","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"Anoka-Hennepin","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","LaundryFeatures":"In Basement,Gas Dryer Hookup,Washer Hookup","NST_LenderOwned":"No","Levels":"Split Entry (Bi-Level)","ListingContractDate":"2025-10-31T05:00:00Z","ListingId":"NST6811845","LotSizeArea":"0.28","NST_MainLevelFinishedArea":"972","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-10-31T10:28:27Z","NST_SchoolDistrictNumber":"663","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_PatioPorchType":"Front Porch","PhotosCount":"14","PhotosChangeTimestamp":"2025-12-16T20:13:05.288Z","PoolFeatures":"None","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family Residence","PropertyType":"Residential","NST_SpecialSearch":"Main Floor Primary,Main Floor Bedroom","StandardStatus":"Active","SubdivisionName":"Harmony Farms","TaxAnnualAmount":"0","NST_TaxWithAssessments":"0","Township":"Ramsey","WaterSource":"City Water/Connected","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST505534","ListAgentMlsId":"NST502052441","ListOfficeMlsId":"NST6836","ListOfficeName":"Lennar Sales Corp","ListOfficeKey":"NST10379","ModificationTimestamp":"2025-12-16T20:13:05.288Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) Another view of the spacious primary bedroom.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/bb6aedc1-f47b-4acb-ba41-0b51c7697060.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.886Z\",\"MediaKey\":\"NST119467959\"},{\"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.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/d464fc59-169a-4df2-b7a7-ef1487971ee9.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.895Z\",\"MediaKey\":\"NST119467954\"},{\"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.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/74a681bc-9cd4-49d1-aadb-18f31d792fd4.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.883Z\",\"MediaKey\":\"NST119467956\"},{\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) Notice the stunning natural light pouring into this spacious great room.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/4e156723-bc7d-4531-bf45-5718ea2c6eef.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.892Z\",\"MediaKey\":\"NST119467957\"},{\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The main level bathroom provides plenty of space!\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/ede29b97-2a9a-4a92-a84f-f45f87b2cdcb.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.887Z\",\"MediaKey\":\"NST119467961\"},{\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The main entrance leads to the upper level and the lower level.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/2cc5a008-3e59-4c0f-a96a-7bd4ed3a5110.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-10-31T15:29:41.605Z\",\"MediaKey\":\"NST119467963\"},{\"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.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/2bd041e3-200c-4b5d-9eae-1874ceba91b2.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.894Z\",\"MediaKey\":\"NST119467958\"},{\"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.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/78b2e7f9-4bfb-4cbf-9dac-01f4c20ce8dc.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2025-12-16T20:12:05.936Z\",\"MediaKey\":\"NST119467953\"},{\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The secondary bedroom on the main level.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/d7d3c3a5-0db7-439d-8328-f9bd2e38f92f.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-16T20:12:05.932Z\",\"MediaKey\":\"NST119467962\"},{\"LongDescription\":\"(Photo of an inventory home, actual homes finishes will vary) The primary bedroom features a wonderful walk-in closet.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/e7bc66c5-bb9a-4ec2-929b-5423cf7f0e25.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.906Z\",\"MediaKey\":\"NST119467960\"},{\"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.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/d9f341a3-7462-4e2d-901c-83af2824801a.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":900,\"ImageHeight\":600,\"ImageSizeDescription\":\"900x600\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.913Z\",\"MediaKey\":\"NST119467955\"},{\"LongDescription\":\"Emily lower level.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/1ba4e35e-8e83-431c-a41a-849109ac5bf8.png\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":892,\"ImageHeight\":751,\"ImageSizeDescription\":\"892x751\",\"MediaModificationTimestamp\":\"2025-10-31T15:29:41.608Z\",\"MediaKey\":\"NST119467965\"},{\"LongDescription\":\"Emily main level.\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/5428a28b-fb7e-4ad2-a61e-652d1ee1a6ec.png\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":764,\"ImageHeight\":683,\"ImageSizeDescription\":\"764x683\",\"MediaModificationTimestamp\":\"2025-10-31T15:29:41.636Z\",\"MediaKey\":\"NST119467964\"},{\"LongDescription\":\"Welcome to Harmony Farms!\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7822374/645bc24e-6a09-48f8-a68f-fca24a9724c2.jpeg\",\"ResourceRecordKey\":\"NST7822374\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2025-12-10T17:23:13.956Z\",\"MediaKey\":\"NST119467966\"}]","Rooms":"[{\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST115744826\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"12x13\",\"RoomLevel\":\"Main\"},{\"RoomType\":\"Great Room\",\"RoomKey\":\"NST115744825\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"12x11\",\"RoomLevel\":\"Main\"},{\"RoomType\":\"Informal Dining Room\",\"RoomKey\":\"NST115744824\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"7x11\",\"RoomLevel\":\"Main\"},{\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST115744823\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"11x10\",\"RoomLevel\":\"Main\"},{\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST115744827\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"10x10\",\"RoomLevel\":\"Main\"}]","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.\"},{\"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":""}