{"Id":552580,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7068436","MLSAGENTID":"NST506069368","MLSCOAGENTID":"NST506012407","MLSOFFICEID":"NST25792","ADDRESS":"11470 Halstead Trail","ACRES":0.308,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full,Walkout","BATHSTOTAL":4.0,"BEDROOMS":4.0,"CITY":"Woodbury","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":724700.0,"LASTPRICEDATE":"2026-05-05T21:52:08.317","LATITUDE":44.906919,"LENDEROWNED":"No","LISTDATE":"2026-05-05T05:00:00","LISTPRICE":724700.0,"LIVINGAREA":3638.0,"LONGITUDE":-92.873466,"MODIFICATIONTIMESTAMP":"2026-05-06T10:04:16.82","OFFICE_OFFICENAME":"eXp Realty","PHOTOCOUNT":1,"POSTALCODE":"55129","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Nestled in the prestigious Stonemill Farms community on the very finest homesite. This exceptional custom-built residence showcases outstanding quality, impressive amenities, and an array of sought-after dream home features. Perfectly positioned on a premium homesite directly across from the community pool and amenities, the location is truly unbeatable. A charming covered front porch sets the tone for the elegance found throughout. Step inside to a thoughtfully designed open-concept floor plan that seamlessly blends grand entertaining spaces with comfortable everyday living. Gleaming real hardwood floors span the entry, dining area, and kitchen. The main level features a stylish front office—ideal for working from home or relaxing—and a versatile formal dining room currently enjoyed as a sitting room. The inviting great room is highlighted by a cozy fireplace and striking architectural details, creating a warm yet sophisticated ambiance. At the heart of the home, the gourmet kitchen impresses with quality cabinetry, a center island, tile backsplash, stainless steel appliances, and a walk-in pantry. The adjacent dining area flows effortlessly into a stunning four-season porch, offering sun-filled views and the perfect setting to enjoy beautiful Minnesota evenings year-round. Upstairs, the luxurious owner’s suite serves as a private retreat with a vaulted ceiling, spa-inspired bath, walk-in closet, and elegant finishes. Two additional spacious bedrooms plus a fabulous loft. The finished lower level provides a generous family room and flexible spaces ideal for recreation, fitness, or entertaining with a wet bar and 4th bedroom. Step outside to your own private oasis—featuring professional landscaping, a paver patio, and a deck—perfect for hosting gatherings or relaxing outdoors. Additional highlights include an oversized three-car side-turned garage and an exceptional location. Highly rated schools, including Liberty Elementary, are within easy walking distance, plus East Ridge High School. Enjoy access to premier community amenities, including a pool, fitness center, hockey rink, basketball courts, and community center—all just steps away.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less","SCHOOLDISTRICTNUMBER":"833-South Washington County","SCHOOLDISTRICTPHONE":"6514256300","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-05-05T21:52:08.317","LASTSTATUS":"Active","STREETNAME":"Halstead","STREETNUMBER":"11470","STREETSUFFIX":"Trail","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2003,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-05-05T21:52:08.315","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Front spring.png\"}]","PHOTOORDER":"1","SOURCE":"MG_NST"}
{"ListingKey":"NST7896775","NST_AboveGradeSqFtTotal":"2558","AboveGradeFinishedArea":"2558","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Deck","Appliances":"Air-To-Air Exchanger,Dishwasher,Dryer,Humidifier,Microwave,Range,Refrigerator,Washer,Water Softener Owned","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"True","AssociationFee":"190","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Professional Mgmt,Recreation Facility,Sanitation,Shared Amenities","AssociationName":"Associa","AssociationPhone":"7632256400","AttributionContact":"6515012345","NST_AttributionName":"Justyna M. Johnson","Basement":"Finished,Full,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,Bathroom Ensuite,Full Primary,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level Full Bath,Walk-In Shower Stall","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"4","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1220","BelowGradeFinishedArea":"1080","CumulativeDaysOnMarket":"20","City":"Woodbury","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Yes","NST_DiningRoomDescription":"Separate/Formal Dining Room","Directions":"94 to S on Manning to Lake Rd. Right on Settlers Ridge Pkwy. Right on Stonemill Farms Curve. Right on Rosemill Ln. Right on Halstead Trl to home.","DocumentsCount":"8","DocumentsChangeTimestamp":"2026-05-06T02:41:06.374Z","DaysOnMarket":"0","FireplaceFeatures":"Gas","FireplaceYN":"True","FireplacesTotal":"2","FoundationArea":"1220","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"672","GarageSpaces":"3","Heating":"Forced Air","HighSchoolDistrict":"South Washington County","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.906919","LaundryFeatures":"Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"724700","ListingContractDate":"2026-05-05T05:00:00Z","ListingId":"NST7068436","LivingArea":"3638","Longitude":"-92.873466","LotSizeArea":"0.308","LotSizeDimensions":"57x132x131x177","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1220","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-05-05T16:43:44Z","ParcelNumber":"1302821340044","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Deck","PhotosCount":"1","PhotosChangeTimestamp":"2026-05-05T21:52:08.315Z","PoolFeatures":"Below Ground,Heated,Indoor,Shared","PostalCity":"Saint Paul","PostalCode":"55129","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Nestled in the prestigious Stonemill Farms community on the very finest homesite. This exceptional custom-built residence showcases outstanding quality, impressive amenities, and an array of sought-after dream home features. Perfectly positioned on a premium homesite directly across from the community pool and amenities, the location is truly unbeatable. A charming covered front porch sets the tone for the elegance found throughout. Step inside to a thoughtfully designed open-concept floor plan that seamlessly blends grand entertaining spaces with comfortable everyday living. Gleaming real hardwood floors span the entry, dining area, and kitchen. The main level features a stylish front office—ideal for working from home or relaxing—and a versatile formal dining room currently enjoyed as a sitting room. The inviting great room is highlighted by a cozy fireplace and striking architectural details, creating a warm yet sophisticated ambiance. At the heart of the home, the gourmet kitchen impresses with quality cabinetry, a center island, tile backsplash, stainless steel appliances, and a walk-in pantry. The adjacent dining area flows effortlessly into a stunning four-season porch, offering sun-filled views and the perfect setting to enjoy beautiful Minnesota evenings year-round. Upstairs, the luxurious owner’s suite serves as a private retreat with a vaulted ceiling, spa-inspired bath, walk-in closet, and elegant finishes. Two additional spacious bedrooms plus a fabulous loft. The finished lower level provides a generous family room and flexible spaces ideal for recreation, fitness, or entertaining with a wet bar and 4th bedroom. Step outside to your own private oasis—featuring professional landscaping, a paver patio, and a deck—perfect for hosting gatherings or relaxing outdoors. Additional highlights include an oversized three-car side-turned garage and an exceptional location. Highly rated schools, including Liberty Elementary, are within easy walking distance, plus East Ridge High School. Enjoy access to premier community amenities, including a pool, fitness center, hockey rink, basketball courts, and community center—all just steps away.","PublicSurveyRange":"21","PublicSurveySection":"13","PublicSurveyTownship":"28","RoadFrontageType":"Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less","NST_SchoolDistrictNumber":"833","NST_SchoolDistrictPhone":"6514256300","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Halstead","StreetNumber":"11470","StreetNumberNumeric":"11470","StreetSuffix":"Trail","SubdivisionName":"Stonemill Farms 1st Add","TaxAnnualAmount":"7599","NST_TaxWithAssessments":"7654","TaxYear":"2025","BuildingAreaTotal":"3778","Township":"Woodbury","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2003","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST103487","CoListAgentMlsId":"NST506012407","CoListOfficeName":"eXp Realty","ListAgentKey":"NST47605","ListAgentMlsId":"NST506069368","ListOfficeMlsId":"NST25792","ListOfficeName":"eXp Realty","ListOfficeKey":"NST25792","ModificationTimestamp":"2026-05-06T10:04:16.82Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7896775\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7896775/473c144c-913c-4a72-b91f-ef9e9c3dab01.jpeg\",\"LongDescription\":\"Front spring.png\",\"ImageWidth\":1536,\"ImageHeight\":1024,\"ImageSizeDescription\":\"1536x1024\",\"MediaModificationTimestamp\":\"2026-05-05T21:51:12.155Z\",\"MediaKey\":\"NST122004507\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ResourceRecordKey":"NST7896775","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7896775/473c144c-913c-4a72-b91f-ef9e9c3dab01.jpeg","Media__LongDescription":"Front spring.png","Media__ImageWidth":"1536","Media__ImageHeight":"1024","Media__ImageSizeDescription":"1536x1024","Media__MediaModificationTimestamp":"5/5/2026 9:51:12 PM","Media__MediaKey":"NST122004507","Rooms":"[{\"RoomType\":\"Bar/Wet Bar Room\",\"NST_RoomSortOrder\":12,\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116200630\",\"RoomDimensions\":\"12x5\"},{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116200621\",\"RoomDimensions\":\"10x9\"},{\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":11,\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116200629\",\"RoomDimensions\":\"29x13\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116200624\",\"RoomDimensions\":\"17x13\"},{\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":9,\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116200627\",\"RoomDimensions\":\"14x9.5\"},{\"RoomType\":\"Great Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116200620\",\"RoomDimensions\":\"15x14\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116200623\",\"RoomDimensions\":\"11x10\"},{\"RoomType\":\"Loft\",\"NST_RoomSortOrder\":10,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116200628\",\"RoomDimensions\":\"11x11\"},{\"RoomType\":\"Office\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116200619\",\"RoomDimensions\":\"13x11\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116200625\",\"RoomDimensions\":\"13x11\"},{\"RoomType\":\"Sun Room\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116200622\",\"RoomDimensions\":\"12x12\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":8,\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116200626\",\"RoomDimensions\":\"11.5x11\"}]","Rooms__RoomType":"Bar/Wet Bar Room","Rooms__NST_RoomSortOrder":"12","Rooms__RoomLevel":"Lower","Rooms__RoomKey":"NST116200630","Rooms__RoomDimensions":"12x5","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Front spring.png\"}]","PhotoOrder":"1","CustomVTourURL":""}