4042 Hayward Avenue N Oakdale, MN 55128

Features

Features

Property Features

Lennar Sales Corp is not a Multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Lennar Sales Corp, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc. Information Deemed Reliable But Not Guaranteed.
© 2020 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.
RMLS DMCA Notice

NorthstarMLS® data last updated at July 23, 2020 7:53 PM CT

Real Estate IDX Powered by iHomefinder

{"Id":624630,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7160412","MLSAGENTID":"NST502052441","MLSOFFICEID":"NST6836","ADDRESS":"4042 Hayward Avenue N","ACRES":0.0413,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"Oakdale","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete,Frame","FORECLOSURE":"No","LASTPRICE":366985.0,"LASTPRICEDATE":"2026-10-15T13:20:08.443","LATITUDE":45.0053952,"LENDEROWNED":"No","LISTDATE":"2026-10-15T05:00:00","LISTPRICE":366985.0,"LIVINGAREA":1714.0,"LONGITUDE":-92.9547097,"LOTDESCRIPTION":"Sod Included in Price,Underground Utilities","MODIFICATIONTIMESTAMP":"2026-10-16T10:11:07.097","OFFICE_OFFICENAME":"Lennar Sales Corp","PHOTOCOUNT":18,"POSTALCODE":"55128","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to Willowbrooke's newest collection - this brand-new two-story townhome features a spacious two-car garage and a low-maintenance yard. The main level offers a welcoming family room, a bright dining area perfect for gatherings and a well-appointed kitchen boasting stainless steel appliances and a convenient island. Enjoy the outdoors in your private living space or cozy up by the fireplace. Upstairs, discover three peaceful bedrooms, including a large owner’s suite designed as a true retreat. This home won't stay on the market long!\n\nConveniently located off of Hwy 5 and 694, this community offers access to public trails and is walking distance to Oakdale's newest city park and playground, Willowbrooke Commons!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"622-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"6517487410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-10-15T13:20:08.443","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Hayward","STREETNUMBER":"4042","STREETSUFFIX":"Avenue","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-10-15T13:18:08.602","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 4042 Hayward Ave N! (Photo is of the actual home.)\"},{\"Order\":2,\"Remarks\":\"(All the following photos are of a similar home, actual finishes may vary.) This chef-ready kitchen is designed to accommodate modern living, with a center island to add seating space, gleaming quartz countertops and abundant cabinetry room.\"},{\"Order\":3,\"Remarks\":\"A subway tile backsplash atop the 5-burner gas cooktop with an overhead microwave meets style with functionality\"},{\"Order\":4,\"Remarks\":\"This center island includes a stainless steel sink with designer faucet to remove stubborn stains\"},{\"Order\":5,\"Remarks\":\"Sharing a convenient layout with the kitchen, the dining room makes it a breeze to serve piping-hot meals straight off the stove and host delicious meals of all sizes on the dinner table.\"},{\"Order\":6,\"Remarks\":\"The dining room enjoys direct access to the patio for seamless indoor-outdoor parties\"},{\"Order\":7,\"Remarks\":\"The natural gathering space of the home, the Great Room is excellent for entertaining guests, hosting movie marathons and relaxing with loved ones, paired with the simplicity of a free-flowing design.\"},{\"Order\":8,\"Remarks\":\"Situated directly off the kitchen, this powder room optimizes the first-floor main living area for residents and guests alike.\"},{\"Order\":9,\"Remarks\":\"Nestled on the top floor, the private owner’s suite boasts a spacious bedroom to provide restful nights and a tranquil haven for relaxation, complemented by an en-suite bathroom and large walk-in closet.\"},{\"Order\":10,\"Remarks\":\"(Photo of a similar home, actual finishes may vary)\"},{\"Order\":11,\"Remarks\":\"Featuring a glass-enclosed shower with built-in shelving and glass mirrors set atop dual quartz sinks and vanity-cabinetry, the en-suite bathroom helps streamline morning routines\"},{\"Order\":12,\"Remarks\":\"The upper-level secondary bedrooms are perfectly situated away from the downstairs main living areas and are blank canvases ready to be personalized. Furnished here as a cozy nursery.\"},{\"Order\":13,\"Remarks\":\"This retreat is ideal for residents who require more personal space and privacy.\"},{\"Order\":14,\"Remarks\":\"A full-sized bathroom on the second floor comes well-equipped with a generously sized quartz-topped vanity and a combination shower and tub to maximize the interior space.\"},{\"Order\":15,\"Remarks\":\"Raleigh main level floorplan\"},{\"Order\":16,\"Remarks\":\"Raleigh upper level floorplan\"},{\"Order\":17,\"Remarks\":\"Welcome to Willowbrooke!\"},{\"Order\":18,\"Remarks\":\"Enjoy the amenities at Willowbrooke!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","SOURCE":"MG_NST"}

{"ListingKey":"NST7983577","NST_AboveGradeSqFtTotal":"1714","AboveGradeFinishedArea":"1714","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Kitchen Center Island,Primary Bedroom Walk-In Closet,Patio,Paneled Doors,Porch,In-Ground Sprinkler,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Humidifier,Microwave,Range,Refrigerator,Stainless Steel Appliances,Tankless Water Heater","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"294","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Lawn Care,Other,Maintenance Grounds,Professional Mgmt,Sanitation,Snow Removal","AssociationName":"Associa","AssociationPhone":"7632256400","AvailabilityDate":"2026-11-01T05:00:00Z","Basement":"None","BasementYN":"False","NST_BathDesc":"3/4 Primary,Double Sink,Private Primary,Main Floor 1/2 Bath,Upper Level Full Bath","BathroomsFull":"1","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"3","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"0","BelowGradeFinishedArea":"0","NST_BuilderAssociationID":"Builders Association of the Twin Cities","NST_BuilderLicense":"1413","BuilderName":"LENNAR","CumulativeDaysOnMarket":"0","City":"Oakdale","NST_CommunityName":"Willowbrooke","NST_CompletionDate":"2026-11-01","ConstructionMaterials":"Concrete,Frame","NewConstructionYN":"True","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Washington","NST_DPResource":"Yes","NST_DiningRoomDescription":"Informal Dining Room,Kitchen/Dining Room","Directions":"Follow I-494 N and I-694 E to Hadley Ave N in Oakdale. Take the CR-13/Hadley Ave exit from MN-36 W. Exit and stay on Hadley Ave N. Continue onto 50th St N. Turn right onto Hadley Ave N. Turn left onto 40th St N. Turn right onto Hayward Ave N.","DocumentsCount":"0","DaysOnMarket":"0","NST_DomIncrementTimestamp":"2026-10-15","NST_DomIncrementYN":"true","Electric":"150 Amp Service","ExteriorFeatures":"Stone,Vinyl","FireplaceFeatures":"Electric,Family Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"777","FoundationDetails":"Slab","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"428","GarageSpaces":"2","Heating":"Forced Air,Fireplace(s)","HighSchoolDistrict":"North St Paul-Maplewood","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.0053952","LaundryFeatures":"Gas Dryer Hookup,Laundry Room,Upper Level,Washer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"366985","ListingContractDate":"2026-10-15T05:00:00Z","ListingId":"NST7160412","LivingArea":"1714","Longitude":"-92.9547097","LotFeatures":"Sod Included in Price,Underground Utilities","LotSizeArea":"1800","LotSizeDimensions":"TBD","LotSizeUnits":"Square Feet","NST_MainLevelFinishedArea":"777","NST_ManufacturedHome":"N","NST_ModelHours":"Daily 11-6","NST_ModelLocation":"4004 Hayward Ave N, Oakdale, MN 55128","OriginalEntryTimestamp":"2026-10-15T08:17:11Z","ParcelNumber":"TBD","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","NST_PatioPorchType":"Front Porch,Patio","PhotosCount":"18","PhotosChangeTimestamp":"2026-10-15T13:18:08.602Z","PostalCity":"Oakdale","PostalCode":"55128","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Welcome to Willowbrooke's newest collection - this brand-new two-story townhome features a spacious two-car garage and a low-maintenance yard. The main level offers a welcoming family room, a bright dining area perfect for gatherings and a well-appointed kitchen boasting stainless steel appliances and a convenient island. Enjoy the outdoors in your private living space or cozy up by the fireplace. Upstairs, discover three peaceful bedrooms, including a large owner’s suite designed as a true retreat. This home won't stay on the market long!\n\nConveniently located off of Hwy 5 and 694, this community offers access to public trails and is walking distance to Oakdale's newest city park and playground, Willowbrooke Commons!","RoadFrontageType":"City Street,Curbs,Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictFullName":"622 - North St Paul-Maplewood","NST_SchoolDistrictNumber":"622","NST_SchoolDistrictPhone":"6517487410","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"Multi-Level","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Hayward","StreetNumber":"4042","StreetNumberNumeric":"4042","StreetSuffix":"Avenue","SubdivisionName":"Willowbrooke","TaxAnnualAmount":"0","NST_TaxWithAssessments":"0","TaxYear":"2026","NST_TotalArea":"1714","BuildingAreaTotal":"1714","Township":"Oakdale","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST505534","ListAgentMlsId":"NST502052441","ListOfficeMlsId":"NST6836","ListOfficeName":"Lennar Sales Corp","ListOfficeKey":"NST10379","ModificationTimestamp":"2026-10-16T10:11:07.097Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":15,\"MediaObjectID\":\"NST15\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/19f6e043-d7ba-4604-86f2-208c41e7da1b.jpeg\",\"LongDescription\":\"Raleigh main level floorplan\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":471,\"ImageHeight\":729,\"ImageSizeDescription\":\"471x729\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.424Z\",\"MediaKey\":\"NST125436483\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/3cb219fe-6520-4e38-b818-2df3fa471e51.jpeg\",\"LongDescription\":\"The natural gathering space of the home, the Great Room is excellent for entertaining guests, hosting movie marathons and relaxing with loved ones, paired with the simplicity of a free-flowing design.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.402Z\",\"MediaKey\":\"NST125436475\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/5a28b381-afd8-4e78-869f-0faccdd0f8d3.jpeg\",\"LongDescription\":\"Situated directly off the kitchen, this powder room optimizes the first-floor main living area for residents and guests alike.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.405Z\",\"MediaKey\":\"NST125436476\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/90f875db-d40e-4c31-9e1b-57b629efb2b2.jpeg\",\"LongDescription\":\"A full-sized bathroom on the second floor comes well-equipped with a generously sized quartz-topped vanity and a combination shower and tub to maximize the interior space.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436482\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/6e72c1ef-18aa-4670-98e5-53e5a48ed33f.jpeg\",\"LongDescription\":\"A subway tile backsplash atop the 5-burner gas cooktop with an overhead microwave meets style with functionality\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436471\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/7ec8c38e-7ee9-44d3-b3ed-50d7596c2bcf.jpeg\",\"LongDescription\":\"The dining room enjoys direct access to the patio for seamless indoor-outdoor parties\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.409Z\",\"MediaKey\":\"NST125436474\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/a693684c-1f09-41ac-9c4b-5ea45714064c.jpeg\",\"LongDescription\":\"(All the following photos are of a similar home, actual finishes may vary.) This chef-ready kitchen is designed to accommodate modern living, with a center island to add seating space, gleaming quartz countertops and abundant cabinetry room.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436470\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/a16c5c4c-1fea-4f7a-b530-60b210026178.jpeg\",\"LongDescription\":\"Raleigh upper level floorplan\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":400,\"ImageHeight\":667,\"ImageSizeDescription\":\"400x667\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436484\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/3e5bf1ec-48f1-4d88-9806-6099911f3809.jpeg\",\"LongDescription\":\"Welcome to 4042 Hayward Ave N! (Photo is of the actual home.)\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2080,\"ImageHeight\":1494,\"ImageSizeDescription\":\"2080x1494\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.43Z\",\"MediaKey\":\"NST125436469\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/62e5e6cf-9604-4b10-84ef-c46308ea9f6d.jpeg\",\"LongDescription\":\"Featuring a glass-enclosed shower with built-in shelving and glass mirrors set atop dual quartz sinks and vanity-cabinetry, the en-suite bathroom helps streamline morning routines\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436479\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/80ae0c7b-1c6a-4b4e-85f8-067ea396ff12.jpeg\",\"LongDescription\":\"Sharing a convenient layout with the kitchen, the dining room makes it a breeze to serve piping-hot meals straight off the stove and host delicious meals of all sizes on the dinner table.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436473\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/ccc61d27-f7ad-42df-b71d-8622293e0f64.jpeg\",\"LongDescription\":\"This retreat is ideal for residents who require more personal space and privacy.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.431Z\",\"MediaKey\":\"NST125436481\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/934c2c5d-e4f3-43ce-ae64-bbcc24d92828.jpeg\",\"LongDescription\":\"Nestled on the top floor, the private owner’s suite boasts a spacious bedroom to provide restful nights and a tranquil haven for relaxation, complemented by an en-suite bathroom and large walk-in closet.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436477\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/aebbe3d3-767c-47a2-a701-3d113f654e54.jpeg\",\"LongDescription\":\"The upper-level secondary bedrooms are perfectly situated away from the downstairs main living areas and are blank canvases ready to be personalized. Furnished here as a cozy nursery.\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.432Z\",\"MediaKey\":\"NST125436480\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/652bde6e-a0bc-4542-bc1d-ab26e6722a05.jpeg\",\"LongDescription\":\"(Photo of a similar home, actual finishes may vary)\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.469Z\",\"MediaKey\":\"NST125436478\"},{\"Order\":18,\"MediaObjectID\":\"NST18\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/f6728ee5-6074-49c6-8d00-e8f78f1892d3.jpeg\",\"LongDescription\":\"Enjoy the amenities at Willowbrooke!\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.442Z\",\"MediaKey\":\"NST125436486\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/cd52e164-093f-4b41-86d6-eb0f38d4a0c6.jpeg\",\"LongDescription\":\"This center island includes a stainless steel sink with designer faucet to remove stubborn stains\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.403Z\",\"MediaKey\":\"NST125436472\"},{\"Order\":17,\"MediaObjectID\":\"NST17\",\"MediaURL\":\"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/c383c406-e6d2-46d1-9253-2bf405417b1a.jpeg\",\"LongDescription\":\"Welcome to Willowbrooke!\",\"ResourceRecordKey\":\"NST7983577\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-10-15T13:18:06.426Z\",\"MediaKey\":\"NST125436485\"}]","Media__Order":"15","Media__MediaObjectID":"NST15","Media__MediaURL":"https://media.mlsgrid.com/token=nQJ_8QleH_BGmy4LeqRsD4fYpI5V60Xq6iyNRloj3Sc&expires=1792149923&id=5d6fc86794c5224544394849/images/NST7983577/19f6e043-d7ba-4604-86f2-208c41e7da1b.jpeg","Media__LongDescription":"Raleigh main level floorplan","Media__ResourceRecordKey":"NST7983577","Media__ImageWidth":"471","Media__ImageHeight":"729","Media__ImageSizeDescription":"471x729","Media__MediaModificationTimestamp":"10/15/2026 1:18:06 PM","Media__MediaKey":"NST125436483","DocumentsChangeTimestamp":"2026-10-15T13:18:08.602Z","Rooms":"[{\"RoomKey\":\"NST116761915\",\"RoomDimensions\":\"14x17\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":4},{\"RoomKey\":\"NST116761914\",\"RoomDimensions\":\"13x15\",\"RoomLevel\":\"Main\",\"RoomType\":\"Great Room\",\"NST_RoomSortOrder\":3},{\"RoomKey\":\"NST116761913\",\"RoomDimensions\":\"11x12\",\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":2},{\"RoomKey\":\"NST116761912\",\"RoomDimensions\":\"13x15\",\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1},{\"RoomKey\":\"NST116761916\",\"RoomDimensions\":\"14x10\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":5},{\"RoomKey\":\"NST116761917\",\"RoomDimensions\":\"10x11\",\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":6}]","Rooms__RoomKey":"NST116761915","Rooms__RoomDimensions":"14x17","Rooms__RoomLevel":"Upper","Rooms__RoomType":"Bedroom","Rooms__NST_RoomSortOrder":"4","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 4042 Hayward Ave N! (Photo is of the actual home.)\"},{\"Order\":2,\"Remarks\":\"(All the following photos are of a similar home, actual finishes may vary.) This chef-ready kitchen is designed to accommodate modern living, with a center island to add seating space, gleaming quartz countertops and abundant cabinetry room.\"},{\"Order\":3,\"Remarks\":\"A subway tile backsplash atop the 5-burner gas cooktop with an overhead microwave meets style with functionality\"},{\"Order\":4,\"Remarks\":\"This center island includes a stainless steel sink with designer faucet to remove stubborn stains\"},{\"Order\":5,\"Remarks\":\"Sharing a convenient layout with the kitchen, the dining room makes it a breeze to serve piping-hot meals straight off the stove and host delicious meals of all sizes on the dinner table.\"},{\"Order\":6,\"Remarks\":\"The dining room enjoys direct access to the patio for seamless indoor-outdoor parties\"},{\"Order\":7,\"Remarks\":\"The natural gathering space of the home, the Great Room is excellent for entertaining guests, hosting movie marathons and relaxing with loved ones, paired with the simplicity of a free-flowing design.\"},{\"Order\":8,\"Remarks\":\"Situated directly off the kitchen, this powder room optimizes the first-floor main living area for residents and guests alike.\"},{\"Order\":9,\"Remarks\":\"Nestled on the top floor, the private owner’s suite boasts a spacious bedroom to provide restful nights and a tranquil haven for relaxation, complemented by an en-suite bathroom and large walk-in closet.\"},{\"Order\":10,\"Remarks\":\"(Photo of a similar home, actual finishes may vary)\"},{\"Order\":11,\"Remarks\":\"Featuring a glass-enclosed shower with built-in shelving and glass mirrors set atop dual quartz sinks and vanity-cabinetry, the en-suite bathroom helps streamline morning routines\"},{\"Order\":12,\"Remarks\":\"The upper-level secondary bedrooms are perfectly situated away from the downstairs main living areas and are blank canvases ready to be personalized. Furnished here as a cozy nursery.\"},{\"Order\":13,\"Remarks\":\"This retreat is ideal for residents who require more personal space and privacy.\"},{\"Order\":14,\"Remarks\":\"A full-sized bathroom on the second floor comes well-equipped with a generously sized quartz-topped vanity and a combination shower and tub to maximize the interior space.\"},{\"Order\":15,\"Remarks\":\"Raleigh main level floorplan\"},{\"Order\":16,\"Remarks\":\"Raleigh upper level floorplan\"},{\"Order\":17,\"Remarks\":\"Welcome to Willowbrooke!\"},{\"Order\":18,\"Remarks\":\"Enjoy the amenities at Willowbrooke!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18","CustomVTourURL":""}