$SCONTENT$
$LABEL$
$SCONTENT$
MLS# 6732742 - 15038 Glenbrook Avenue N Hugo, MN 55038
LPT 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
{"Id":1365723,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6732742","MLSAGENTID":"NST892010239","MLSCOAGENTID":"NST506015519","MLSOFFICEID":"NST252763","ADDRESS":"15038 Glenbrook Avenue N","ACRES":0.21,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Egress Window(s),Finished,Storage Space,Walkout","BATHSTOTAL":2.0,"BEDROOMS":3,"CITY":"Hugo","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Vinyl Siding","FORECLOSURE":"No","LASTPRICE":299000.0,"LASTPRICEDATE":"2025-06-11T22:43:03.437","LATITUDE":45.167827,"LENDEROWNED":"No","LISTDATE":"2025-06-05T05:00:00","LISTPRICE":289000.0,"LIVINGAREA":1638.0,"LONGITUDE":-92.980043,"MODIFICATIONTIMESTAMP":"2025-06-12T16:45:04.268","OFFICE_OFFICENAME":"LPT Realty","PHOTOCOUNT":17,"POSTALCODE":"55038","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Affordable Twin Home with NO HOA and Prime Location!\n\nLooking for space, convenience, and freedom from HOA restrictions? This twin home offers all three! Located in a desirable area with easy access to shopping, schools, and commuting routes, this property is a fantastic opportunity for homeowners looking for ease and convenience.\n\nThe main level features 2 spacious bedrooms, a full bathroom, a large living room, and a functional kitchen with a dedicated dining area — all with brand new flooring throughout.\n\nThe walk-out basement adds even more living space with a huge family room, an additional large bedroom, and access to a partially fenced yard with peaceful pond views — perfect for relaxing or entertaining. Plus, enjoy the peace of mind of a new water heater.\n\nWith no HOA, you’ll have the freedom to make this home your own — all at an affordable price. Schedule your showing today and take advantage of this rare opportunity!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"624-White Bear Lake","SCHOOLDISTRICTPHONE":"651-407-7500","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-06-08T05:02:04.367","LASTSTATUS":"Coming Soon","STREETDIRSUFFIX":"N","STREETNAME":"Glenbrook","STREETNUMBER":"15038","STREETSUFFIX":"Avenue","STYLE":"Twin Home","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1999,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2025-06-12T16:45:04.268","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","SOURCE":"MG_NST"}
{"ListingKey":"NST7753686","LotSizeArea":"0.21","NST_AgeOfProperty":"26","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","NST_AmenitiesUnit":"Patio,Vaulted Ceiling(s),Walk-In Closet","Appliances":"Dishwasher,Dryer,Range,Refrigerator,Washer","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"True","Basement":"Egress Window(s),Finished,Storage Space,Walkout","BasementYN":"True","NST_BathDesc":"Full Basement,Main Floor Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"2","BedroomsTotal":"3","City":"Hugo","PropertyType":"Residential","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Y","DaysOnMarket":"4","CumulativeDaysOnMarket":"4","NST_DiningRoomDescription":"Kitchen/Dining Room","Directions":"HWY 61 TO 147TH, EAST TO GOODVIEW, NORTH TO 150TH, WEST TO GLENBROOK","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","NST_ExpectedMarketDate":"2025-06-08","ConstructionMaterials":"Vinyl Siding","Fencing":"Partial,Wood","FireplaceYN":"False","FireplacesTotal":"0","NST_ForeclosureStatus":"No","FoundationArea":"884","NST_FractionalOwnershipYN":"No","RoadFrontageType":"City Street,Paved Streets","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageDimensions":"21x20","NST_GarageSquareFeet":"420","AccessibilityFeatures":"None","Heating":"Forced Air","OriginalEntryTimestamp":"2025-06-08T05:00:05Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-06-12","Latitude":"45.167827","NST_LenderOwned":"No","ListAgentKey":"NST106586","ListAgentMlsId":"NST892010239","CoListAgentKey":"NST110120","CoListAgentMlsId":"NST506015519","ListingContractDate":"2025-06-05T05:00:00Z","ListOfficeKey":"NST1001505","ListOfficeName":"LPT Realty","ListOfficeMlsId":"NST252763","ListPrice":"289000","LivingArea":"1638","LockBoxType":"Combo","Longitude":"-92.980043","LotSizeDimensions":"125x40","LotSizeSquareFeet":"9191.16","LotSizeUnits":"Acres","ListingId":"NST6732742","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"WWRA","ParcelNumber":"1703121440030","GarageSpaces":"2","NST_PatioPorchType":"Patio","PhotosCount":"17","PostalCity":"Hugo","PostalCode":"55038","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Affordable Twin Home with NO HOA and Prime Location!\n\nLooking for space, convenience, and freedom from HOA restrictions? This twin home offers all three! Located in a desirable area with easy access to shopping, schools, and commuting routes, this property is a fantastic opportunity for homeowners looking for ease and convenience.\n\nThe main level features 2 spacious bedrooms, a full bathroom, a large living room, and a functional kitchen with a dedicated dining area — all with brand new flooring throughout.\n\nThe walk-out basement adds even more living space with a huge family room, an additional large bedroom, and access to a partially fenced yard with peaceful pond views — perfect for relaxing or entertaining. Plus, enjoy the peace of mind of a new water heater.\n\nWith no HOA, you’ll have the freedom to make this home your own — all at an affordable price. Schedule your showing today and take advantage of this rare opportunity!","PublicSurveyRange":"21","PublicSurveySection":"17","PublicSurveyTownship":"31","NST_RentalLicenseYN":"No","Roof":"Asphalt","RoomType":"Living Room,Dining Room,Kitchen,Bedroom 1,Bedroom 2,Family Room,Bedroom 3","NST_AboveGradeSqFtTotal":"938.0000","NST_BelowGradeSqFtTotal":"700.0000","NST_MainLevelFinishedArea":"938.0000","BuildingAreaTotal":"1638","HighSchoolDistrict":"White Bear Lake","NST_SchoolDistrictNumber":"624","NST_SchoolDistrictPhone":"651-407-7500","Sewer":"City Sewer/Connected","AboveGradeFinishedArea":"938","BelowGradeFinishedArea":"700","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Split Entry (Bi-Level)","StreetDirSuffix":"N","StreetName":"Glenbrook","StreetNumber":"15038","StreetNumberNumeric":"15038","StreetSuffix":"Avenue","PropertySubType":"Twin Home","SubdivisionName":"Oneka Lake View East","NST_TaxWithAssessments":"2986.0000","TaxYear":"2025","TaxAnnualAmount":"2986","WaterSource":"City Water/Connected","YearBuilt":"1999","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-06-12T16:45:04.268Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7753686\",\"Order\":1,\"MediaObjectID\":\"1\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/de7be90a-7db4-45aa-b407-b5710e610fb2.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:54:14.007Z\",\"MediaKey\":\"684444864ab0784ac737be1b\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":2,\"MediaObjectID\":\"2\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/8bea26d0-975e-417c-b098-2310fad4fa7f.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:54:13.988Z\",\"MediaKey\":\"684444864ab0784ac737be1a\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":3,\"MediaObjectID\":\"3\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/f2a203f7-15c5-457a-8000-86032304f62a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.85Z\",\"MediaKey\":\"684444c74ab0784ac737be87\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":4,\"MediaObjectID\":\"4\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/36fd8f8b-c3f3-4912-9f7e-3c57f4db61fb.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.811Z\",\"MediaKey\":\"684444c74ab0784ac737be85\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":5,\"MediaObjectID\":\"5\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/b21eb7b4-b1fd-4bf3-93c5-a032a2e25f82.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.796Z\",\"MediaKey\":\"684444c74ab0784ac737be86\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":6,\"MediaObjectID\":\"6\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/91b69681-7bbd-44f7-bf1b-b0f00ae3f5dd.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.801Z\",\"MediaKey\":\"684444c74ab0784ac737be91\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":7,\"MediaObjectID\":\"7\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/ad0a2a58-141a-4059-953c-d16ae33d48d5.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.801Z\",\"MediaKey\":\"684444c74ab0784ac737be93\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":8,\"MediaObjectID\":\"8\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/63622a01-1b48-4a6d-a9b5-48f3339a152f.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:58:26.201Z\",\"MediaKey\":\"6844458250a24837ab82716b\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":9,\"MediaObjectID\":\"9\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/a02632e0-2313-414b-8ce8-37565d06f7a2.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.853Z\",\"MediaKey\":\"684444c74ab0784ac737be8c\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":10,\"MediaObjectID\":\"10\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/929a8c20-3ef3-4529-a59d-be49443c74e5.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.801Z\",\"MediaKey\":\"684444c74ab0784ac737be8e\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":11,\"MediaObjectID\":\"11\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/037ee21f-d103-45c8-b389-bf1f80284c2a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.813Z\",\"MediaKey\":\"684444c74ab0784ac737be94\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":12,\"MediaObjectID\":\"12\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/8c58a444-c798-4236-a5c0-7bfb075a3c42.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.86Z\",\"MediaKey\":\"684444c74ab0784ac737be97\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":13,\"MediaObjectID\":\"13\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/e013e218-9b34-4429-8004-e94aba9b9f16.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.769Z\",\"MediaKey\":\"684444c74ab0784ac737be98\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":14,\"MediaObjectID\":\"14\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/515a68c0-7d9d-4841-aaeb-a17acdeea201.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.833Z\",\"MediaKey\":\"684444c74ab0784ac737be8f\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":15,\"MediaObjectID\":\"15\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/1973d826-f0a0-4f1a-a560-a8768bc61305.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:55:19.821Z\",\"MediaKey\":\"684444c74ab0784ac737be9a\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":16,\"MediaObjectID\":\"16\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/70757a33-dbdb-4d6a-a78c-32bef428d559.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:57:29.446Z\",\"MediaKey\":\"68444549aad5030c04fede02\"},{\"ResourceRecordKey\":\"NST7753686\",\"Order\":17,\"MediaObjectID\":\"17\",\"ImageWidth\":1800,\"ImageHeight\":1200,\"ImageSizeDescription\":\"1800x1200\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7753686/cf3723ef-34cb-454f-800f-2c0e9aaffe2a.jpeg\",\"MediaModificationTimestamp\":\"2025-06-07T13:57:29.373Z\",\"MediaKey\":\"68444549aad5030c04feddff\"}]","PhotosChangeTimestamp":"2025-06-12T16:45:04.268Z","Rooms":"[{\"RoomKey\":\"NST115289057\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"19x13\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115289058\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115289059\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9x9\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115289060\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"15x13\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115289061\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x9\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115289062\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"26x18\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115289063\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"14x13\",\"NST_RoomSortOrder\":\"7\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17","CustomVTourURL":""}