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":544410,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6805661","MLSAGENTID":"NST502001775","MLSOFFICEID":"NST5418","ADDRESS":"Lot 4 New Brighton Road","ACRES":0.993,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Drain Tiled,Full,Concrete,Sump Pump,Unfinished,Walkout","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Arden Hills","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete","FORECLOSURE":"No","LASTPRICE":950000.0,"LASTPRICEDATE":"2026-04-20T17:20:05.517","LATITUDE":45.03889889,"LENDEROWNED":"No","LISTDATE":"2025-10-18T05:00:00","LISTPRICE":950000.0,"LIVINGAREA":2085.0,"LONGITUDE":-93.17945293,"LOTDESCRIPTION":"Tree Coverage - Medium","MODIFICATIONTIMESTAMP":"2026-04-20T17:20:05.516","OFFICE_OFFICENAME":"Twin Oaks Realty, Inc","PHOTOCOUNT":1,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Gorgeous custom \"to be built\" four bedroom, three bath, two story on a large 1 acre walk-out lot in prime Arden Hills location. Main level includes a large kitchen with center island, a dining area, one-half bath, mud room and open living room with gas F/P. There are four bedrooms in the upper level, plus a storage room. The spacious upper level primary bedroom has a walk-in closet and 3/4 bath. Also included in the upper level are three other spacious bedrooms, plus a full bath. The lower level has a rough-in bath and walks out to a large yard. There is a large three car garage included. Situated in the Mounds View School District. Builder has three other lots to choose from to build this wonderful home on.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"2090-Mounds View","SCHOOLDISTRICTPHONE":"6516216001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-20T17:20:05.517","LASTSTATUS":"Active","STREETNAME":"New Brighton","STREETNUMBER":"Lot 4","STREETSUFFIX":"Road","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-10-19T01:20:03.556","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Kaestner_3d_House_wLights_1_sm wayne new.png\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"NST_AboveGradeSqFtTotal":"2085","AboveGradeFinishedArea":"2085","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Hardwood Floors,Kitchen Center Island,Kitchen Window,Local Area Network,Primary Bedroom Walk-In Closet,Natural Woodwork,Porch,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Disposal,Dryer,Exhaust Fan,Gas Water Heater,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Drain Tiled,Full,Concrete,Sump Pump,Unfinished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Primary,Main Floor 1/2 Bath,Rough In,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"844","BelowGradeFinishedArea":"0","NST_BuilderLicense":"649649","BuilderName":"O MEARA CUSTOM BUILDING INC","CumulativeDaysOnMarket":"180","City":"Arden Hills","ConstructionMaterials":"Concrete","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Breakfast Area,Informal Dining Room,Kitchen/Dining Room","Directions":"35W to County Rd D, East to New Brighton Rd, North to lot","DocumentsCount":"2","DocumentsChangeTimestamp":"2025-10-27T21:49:03.53Z","DaysOnMarket":"180","Electric":"Circuit Breakers,200+ Amp Service","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"844","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"768","NST_GarageDimensions":"32 x 24","NST_GarageDoorHeight":"8","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"Mounds View","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.038898887","LaundryFeatures":"Laundry Room,Main Level,Washer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"950000","ListingContractDate":"2025-10-18T05:00:00Z","ListingId":"NST6805661","ListingKey":"NST7816953","LivingArea":"2085","Longitude":"-93.1794529339","LotFeatures":"Tree Coverage - Medium","LotSizeArea":"0.993","LotSizeDimensions":"Irregular","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"937","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2025-10-18T20:13:37Z","ParcelNumber":"333023340104","NST_SchoolDistrictNumber":"2090","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_PatioPorchType":"Front Porch","PhotosCount":"1","PhotosChangeTimestamp":"2025-10-19T01:20:03.556Z","PostalCity":"Arden Hills","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Gorgeous custom \"to be built\" four bedroom, three bath, two story on a large 1 acre walk-out lot in prime Arden Hills location. Main level includes a large kitchen with center island, a dining area, one-half bath, mud room and open living room with gas F/P. There are four bedrooms in the upper level, plus a storage room. The spacious upper level primary bedroom has a walk-in closet and 3/4 bath. Also included in the upper level are three other spacious bedrooms, plus a full bath. The lower level has a rough-in bath and walks out to a large yard. There is a large three car garage included. Situated in the Mounds View School District. Builder has three other lots to choose from to build this wonderful home on.","PublicSurveyRange":"23","PublicSurveySection":"33","PublicSurveyTownship":"30","Roof":"Age 8 Years or Less","NST_SchoolDistrictPhone":"6516216001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"4 BR on One Level,Main Floor Laundry,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"New Brighton","StreetNumber":"Lot 4","StreetNumberNumeric":"4","StreetSuffix":"Road","SubdivisionName":"Ecko Estates","TaxAnnualAmount":"1762","NST_TaxWithAssessments":"1762","TaxYear":"2025","BuildingAreaTotal":"2929","NST_TotalUnitsSold":"0","Township":"Arden Hills","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST44621","ListAgentMlsId":"NST502001775","ListOfficeMlsId":"NST5418","ListOfficeName":"Twin Oaks Realty, Inc","ListOfficeKey":"NST16194","ModificationTimestamp":"2026-04-20T17:20:05.516Z","OriginatingSystemName":"northstar","Media":"[{\"LongDescription\":\"Kaestner_3d_House_wLights_1_sm wayne new.png\",\"ResourceRecordKey\":\"NST7816953\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7816953/1d075904-c76b-4815-94e0-e820be2af5e7.png\",\"MediaModificationTimestamp\":\"2025-10-19T01:19:12.185Z\",\"MediaKey\":\"68f43c906de39e1dd0a0711e\"}]","Media__LongDescription":"Kaestner_3d_House_wLights_1_sm wayne new.png","Media__ResourceRecordKey":"NST7816953","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ImageWidth":"2080","Media__ImageHeight":"1170","Media__ImageSizeDescription":"2080x1170","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7816953/1d075904-c76b-4815-94e0-e820be2af5e7.png","Media__MediaModificationTimestamp":"10/19/2025 1:19:12 AM","Media__MediaKey":"68f43c906de39e1dd0a0711e","Rooms":"[{\"RoomKey\":\"NST115709167\",\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"15 x 10\"},{\"RoomKey\":\"NST115709169\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"16 x 14\"},{\"RoomKey\":\"NST115709206\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"16 x 14\"},{\"RoomKey\":\"NST115709168\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"15 x 10\"},{\"RoomKey\":\"NST115709208\",\"RoomLevel\":\"Main\",\"RoomType\":\"Laundry\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"9 x 5\"},{\"RoomKey\":\"NST115709166\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"17 x 16\"},{\"RoomKey\":\"NST115709209\",\"RoomLevel\":\"Main\",\"RoomType\":\"Mud Room\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"9 x 5\"},{\"RoomKey\":\"NST115709210\",\"RoomLevel\":\"Main\",\"RoomType\":\"Porch\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"26 x 6\"},{\"RoomKey\":\"NST115709204\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"12 x 11.5\"},{\"RoomKey\":\"NST115709207\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Storage\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"14 x 10\"},{\"RoomKey\":\"NST115709205\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"12 x 12\"}]","Rooms__RoomKey":"NST115709167","Rooms__RoomLevel":"Main","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"15 x 10","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Kaestner_3d_House_wLights_1_sm wayne new.png\"}]","PhotoOrder":"1","CustomVTourURL":""}