MLS# NST7038070 - 7542 Upper 42nd Street N Oakdale, MN 55128

Neighborhoods

Lennar Sales Corp is the brokerage office representing the seller for this listing.

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. Lakeshore Properties, LLC is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Lakeshore Properties, LLC, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":529602,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7038070","MLSAGENTID":"NST502052441","MLSOFFICEID":"NST6836","ADDRESS":"7542 Upper 42nd Street N","ACRES":0.2,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Storage Space,Unfinished","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Oakdale","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete,Frame","FORECLOSURE":"No","LASTPRICE":539855.0,"LASTPRICEDATE":"2026-03-17T16:54:06.027","LATITUDE":45.01003793,"LENDEROWNED":"No","LISTDATE":"2026-03-17T05:00:00","LISTPRICE":539855.0,"LIVINGAREA":2185.0,"LONGITUDE":-92.95319119,"LOTDESCRIPTION":"Sod Included in Price,Underground Utilities","MODIFICATIONTIMESTAMP":"2026-03-17T16:54:06.028","OFFICE_OFFICENAME":"Lennar Sales Corp","PHOTOCOUNT":25,"POSTALCODE":"55128","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to the Bristol in Willowbrooke! This home is complete and move in ready, this beautiful two-story home offers modern design and everyday comfort. The main level features an open-concept layout connecting the Great Room, dining area, and kitchen—perfect for entertaining and family living. A gas fireplace adds warmth and elegance to the Great Room, while a flex room provides versatility for a home office, playroom, or creative space. Upstairs, you’ll find a spacious owner’s suite with a private bath featuring a separate tub and shower, plus a large walk-in closet. Three secondary bedrooms share a full hall bath, and a convenient upper-level laundry enhances functionality. The unfinished lower level offers room for future expansion and personalization. Nestled in the sought-after Willowbrooke community, residents enjoy easy access to parks, lakes, shops, cafés, and movie theaters, along with quick connections to I-694 and Highway 36 for an easy commute throughout the Twin Cities.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt","SCHOOLDISTRICTNUMBER":"2093-North St Paul-Maplewood","SCHOOLDISTRICTPHONE":"6517487410","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-03-17T16:54:06.027","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Upper 42nd","STREETNUMBER":"7542","STREETSUFFIX":"Street","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-03-17T16:54:06.028","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Welcome to 7542 Upper 42nd St N!\"},{\"Order\":2,\"Remarks\":\"The Bristol!\"},{\"Order\":3,\"Remarks\":\"The Bristol!\"},{\"Order\":4,\"Remarks\":\"The Bristol!\"},{\"Order\":5,\"Remarks\":\"This stylish and multifunctional kitchen comes complete with brand-new stainless steel appliances, sleek quartz countertops and Shaker-style cabinetry.\"},{\"Order\":6,\"Remarks\":\"The center island extends out to an overhang with space for bar-style seating\"},{\"Order\":7,\"Remarks\":\"The center island overlooks the dining room and Great Room to promote seamless everyday living\"},{\"Order\":8,\"Remarks\":\"Situated steps away from the kitchen, residents can effortlessly serve piping-hot meals straight off the stove and onto the dining table with ease.\"},{\"Order\":9,\"Remarks\":\"The center island overlooks the dining room and Great Room to promote seamless everyday living\"},{\"Order\":10,\"Remarks\":\"The Great Room is a natural gathering space within the home, perfect for lounging on the couch, watching movies and hanging out with friends.\"},{\"Order\":11,\"Remarks\":\"The first-floor flex space can easily operate as a formal dining room, sitting room or home office.\"},{\"Order\":12,\"Remarks\":\"A first-floor powder room is easily accessible from the communal living and dining spaces.\"},{\"Order\":13,\"Remarks\":\"The owner’s suite is located on the home’s second level, complemented by a spa-like bathroom and walk-in closet.\"},{\"Order\":14,\"Remarks\":\"The owner’s suite bedroom is a restful and luxurious space\"},{\"Order\":15,\"Remarks\":\"A dual sinks, glass-enclosed shower, and separate soaking tub contribute to the bathroom’s spa-like atmosphere\"},{\"Order\":16,\"Remarks\":\"Three secondary bedrooms are situated upstairs, just down the hall from the owner’s suite.\"},{\"Order\":17,\"Remarks\":\"All the secondary bedrooms include a practical wardrobe closet and wall-to-wall carpeting for plush comfort.\"},{\"Order\":18,\"Remarks\":\"With four bedrooms in total, this home is great for households that need space.\"},{\"Order\":19,\"Remarks\":\"This full second-floor bathroom features a wide single vanity and shower-tub combination.\"},{\"Order\":20,\"Remarks\":\"The unfinished basement provides so much potential for customization.\"},{\"Order\":21,\"Remarks\":\"Bristol main level floorplan\"},{\"Order\":22,\"Remarks\":\"Bristol upper level floorplan\"},{\"Order\":23,\"Remarks\":\"Bristol lower level floorplan\"},{\"Order\":24,\"Remarks\":\"Welcome to Willowbrooke!\"},{\"Order\":25,\"Remarks\":\"Welcome to Willowbrooke!\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25","SOURCE":"MG_NST"}

{"ListingKey":"NST7869570","NST_AboveGradeSqFtTotal":"2185","AboveGradeFinishedArea":"2185","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Paneled Doors,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":"Unknown","AssociationYN":"True","AssociationFee":"174","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Other,Professional Mgmt,Sanitation","AssociationName":"Associa MN","AssociationPhone":"7637461188","AvailabilityDate":"2026-02-02T06:00:00Z","Basement":"Storage Space,Unfinished","BasementYN":"True","NST_BathDesc":"Double Sink,Full Primary,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1107","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-02-02","ConstructionMaterials":"Concrete,Frame","NewConstructionYN":"True","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Washington","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room,Living/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. Follow Hadley Ave N and 40th St N to Heath Ave N.","DocumentsCount":"0","DaysOnMarket":"0","Electric":"200+ Amp Service","FireplaceFeatures":"Family Room,Gas,Stone","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1107","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"671","GarageSpaces":"3","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.0100379255","LaundryFeatures":"Gas Dryer Hookup,Laundry Room,Upper Level,Washer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"539855","ListingContractDate":"2026-03-17T05:00:00Z","ListingId":"NST7038070","LivingArea":"2185","Longitude":"-92.9531911865","LotFeatures":"Sod Included in Price,Underground Utilities","LotSizeArea":"0.2","LotSizeDimensions":"TBD","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1107","NST_ManufacturedHome":"N","NST_ModelHours":"11-6 daily","NST_ModelLocation":"4024 Ave N, Oakdale","OriginalEntryTimestamp":"2026-03-17T11:51:45Z","ParcelNumber":"TBD","NST_SchoolDistrictNumber":"2093","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","PhotosCount":"25","PhotosChangeTimestamp":"2026-03-17T16:54:06.028Z","PostalCity":"Oakdale","PostalCode":"55128","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertyType":"Residential","PublicRemarks":"Welcome to the Bristol in Willowbrooke! This home is complete and move in ready, this beautiful two-story home offers modern design and everyday comfort. The main level features an open-concept layout connecting the Great Room, dining area, and kitchen—perfect for entertaining and family living. A gas fireplace adds warmth and elegance to the Great Room, while a flex room provides versatility for a home office, playroom, or creative space. Upstairs, you’ll find a spacious owner’s suite with a private bath featuring a separate tub and shower, plus a large walk-in closet. Three secondary bedrooms share a full hall bath, and a convenient upper-level laundry enhances functionality. The unfinished lower level offers room for future expansion and personalization. Nestled in the sought-after Willowbrooke community, residents enjoy easy access to parks, lakes, shops, cafés, and movie theaters, along with quick connections to I-694 and Highway 36 for an easy commute throughout the Twin Cities.","RoadFrontageType":"City Street,Curbs,Paved Streets","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt","NST_SchoolDistrictPhone":"6517487410","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,4 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetDirSuffix":"N","StreetName":"Upper 42nd","StreetNumber":"7542","StreetNumberNumeric":"7542","StreetSuffix":"Street","SubdivisionName":"Willowbrooke","TaxAnnualAmount":"0","NST_TaxWithAssessments":"0","TaxYear":"2026","BuildingAreaTotal":"3292","Township":"Oakdale","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2026","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST505534","ListAgentMlsId":"NST502052441","ListOfficeMlsId":"NST6836","ListOfficeName":"Lennar Sales Corp","ListOfficeKey":"NST10379","ModificationTimestamp":"2026-03-17T16:54:06.028Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/3613144c-f28d-48b0-afba-0ce0c8e1bc2d.jpeg\",\"LongDescription\":\"Bristol lower level floorplan\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":604,\"ImageHeight\":491,\"ImageSizeDescription\":\"604x491\",\"MediaModificationTimestamp\":\"2026-03-17T16:52:08.481Z\",\"MediaKey\":\"NST120977556\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/283b2f09-66d8-44b3-bf6a-64c660b992bc.jpeg\",\"LongDescription\":\"Bristol upper level floorplan\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":623,\"ImageHeight\":626,\"ImageSizeDescription\":\"623x626\",\"MediaModificationTimestamp\":\"2026-03-17T16:52:08.506Z\",\"MediaKey\":\"NST120977555\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/a7bf9db8-07e6-4ec3-a78a-2e0001e5a1b9.jpeg\",\"LongDescription\":\"Bristol main level floorplan\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":657,\"ImageHeight\":612,\"ImageSizeDescription\":\"657x612\",\"MediaModificationTimestamp\":\"2026-03-17T16:52:08.505Z\",\"MediaKey\":\"NST120977554\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/a385acb3-aad6-4707-9e55-f1805b93c4a1.jpeg\",\"LongDescription\":\"This full second-floor bathroom features a wide single vanity and shower-tub combination.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.194Z\",\"MediaKey\":\"NST120977732\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/4ef5f254-91cc-4887-9f1a-9e3772c3d133.jpeg\",\"LongDescription\":\"The Great Room is a natural gathering space within the home, perfect for lounging on the couch, watching movies and hanging out with friends.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.195Z\",\"MediaKey\":\"NST120977744\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/98ac8014-b9a0-468b-8884-c7c1298bbc26.jpeg\",\"LongDescription\":\"A dual sinks, glass-enclosed shower, and separate soaking tub contribute to the bathroom’s spa-like atmosphere\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.21Z\",\"MediaKey\":\"NST120977735\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/b71f0804-abfe-4698-b21d-4fd1342de07e.jpeg\",\"LongDescription\":\"The first-floor flex space can easily operate as a formal dining room, sitting room or home office.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.228Z\",\"MediaKey\":\"NST120977745\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/5f7628c5-2fee-4c0e-8530-f1c667b0d59f.jpeg\",\"LongDescription\":\"The center island extends out to an overhang with space for bar-style seating\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.198Z\",\"MediaKey\":\"NST120977741\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/f1bdbe39-27e4-459a-9214-d936ff7f1532.jpeg\",\"LongDescription\":\"The center island overlooks the dining room and Great Room to promote seamless everyday living\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.199Z\",\"MediaKey\":\"NST120977740\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/b542211d-b576-44e4-87a9-b87fad7b5896.jpeg\",\"LongDescription\":\"This stylish and multifunctional kitchen comes complete with brand-new stainless steel appliances, sleek quartz countertops and Shaker-style cabinetry.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.196Z\",\"MediaKey\":\"NST120977739\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/97e0b4fe-3776-40ea-b44c-4bf977982a16.jpeg\",\"LongDescription\":\"A first-floor powder room is easily accessible from the communal living and dining spaces.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.213Z\",\"MediaKey\":\"NST120977738\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/dfdd2e54-c742-4ceb-8617-a4130259177a.jpeg\",\"LongDescription\":\"The owner’s suite bedroom is a restful and luxurious space\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.185Z\",\"MediaKey\":\"NST120977736\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/46293203-76cf-4bda-84f8-c11ed25a6fc2.jpeg\",\"LongDescription\":\"The Bristol!\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":1820,\"ImageHeight\":1365,\"ImageSizeDescription\":\"1820x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.236Z\",\"MediaKey\":\"NST120977747\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/5e76cf27-d893-4fc0-9d97-407e5bb8f1de.jpeg\",\"LongDescription\":\"Welcome to Willowbrooke!\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.241Z\",\"MediaKey\":\"NST120978007\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/2b92b07a-693d-4fcb-846c-1a00a5e63838.jpeg\",\"LongDescription\":\"Three secondary bedrooms are situated upstairs, just down the hall from the owner’s suite.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.204Z\",\"MediaKey\":\"NST120977734\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/a4227249-9d7b-4204-80ed-9755b02c0078.jpeg\",\"LongDescription\":\"All the secondary bedrooms include a practical wardrobe closet and wall-to-wall carpeting for plush comfort.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.205Z\",\"MediaKey\":\"NST120977731\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/8bfc797c-ea7c-46b9-b412-c304ca4145ee.jpeg\",\"LongDescription\":\"Welcome to 7542 Upper 42nd St N!\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1820,\"ImageHeight\":1365,\"ImageSizeDescription\":\"1820x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.195Z\",\"MediaKey\":\"NST120977749\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/20918869-612a-47b7-a7b4-9ee9b40229a2.jpeg\",\"LongDescription\":\"The Bristol!\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":1820,\"ImageHeight\":1365,\"ImageSizeDescription\":\"1820x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.19Z\",\"MediaKey\":\"NST120977748\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/16b9e751-69cc-40d1-bd7a-7810e9705e75.jpeg\",\"LongDescription\":\"Welcome to Willowbrooke!\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.239Z\",\"MediaKey\":\"NST120978008\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/6d1aa8a5-f66d-403c-af1d-d0cbd9d929a1.jpeg\",\"LongDescription\":\"The center island overlooks the dining room and Great Room to promote seamless everyday living\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.186Z\",\"MediaKey\":\"NST120977743\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/7c70da35-1c18-48c2-a114-4009a85db735.jpeg\",\"LongDescription\":\"With four bedrooms in total, this home is great for households that need space.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.194Z\",\"MediaKey\":\"NST120977733\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/846d0e54-8418-407f-b247-a67dd33b450b.jpeg\",\"LongDescription\":\"The owner’s suite is located on the home’s second level, complemented by a spa-like bathroom and walk-in closet.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.241Z\",\"MediaKey\":\"NST120977737\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/771287bb-de2f-416a-b171-2018587ba0a6.jpeg\",\"LongDescription\":\"The unfinished basement provides so much potential for customization.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.243Z\",\"MediaKey\":\"NST120977730\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/c2d5e898-d990-43cb-853b-0a59397576b0.jpeg\",\"LongDescription\":\"Situated steps away from the kitchen, residents can effortlessly serve piping-hot meals straight off the stove and onto the dining table with ease.\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.22Z\",\"MediaKey\":\"NST120977742\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7869570/696f3a1c-081e-40f5-afaf-6278fd7ae5ad.jpeg\",\"LongDescription\":\"The Bristol!\",\"ResourceRecordKey\":\"NST7869570\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":1820,\"ImageHeight\":1365,\"ImageSizeDescription\":\"1820x1365\",\"MediaModificationTimestamp\":\"2026-03-17T16:53:17.243Z\",\"MediaKey\":\"NST120977746\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7869570/3613144c-f28d-48b0-afba-0ce0c8e1bc2d.jpeg","Media__LongDescription":"Bristol lower level floorplan","Media__ResourceRecordKey":"NST7869570","Media__Order":"23","Media__MediaObjectID":"NST23","Media__ImageWidth":"604","Media__ImageHeight":"491","Media__ImageSizeDescription":"604x491","Media__MediaModificationTimestamp":"3/17/2026 4:52:08 PM","Media__MediaKey":"NST120977556","DocumentsChangeTimestamp":"2026-03-17T16:52:06.374Z","Rooms":"[{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116022497\",\"RoomDimensions\":\"10x16\",\"RoomType\":\"Dining Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116022500\",\"RoomDimensions\":\"14x17\",\"RoomType\":\"Bedroom\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116022499\",\"RoomDimensions\":\"9x13\",\"RoomType\":\"Flex Room\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116022503\",\"RoomDimensions\":\"11x10\",\"RoomType\":\"Bedroom 4\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116022498\",\"RoomDimensions\":\"15x16\",\"RoomType\":\"Great Room\"},{\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116022496\",\"RoomDimensions\":\"12x16\",\"RoomType\":\"Kitchen\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116022501\",\"RoomDimensions\":\"10x11\",\"RoomType\":\"Bedroom 2\"},{\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116022502\",\"RoomDimensions\":\"11x12\",\"RoomType\":\"Bedroom 3\"}]","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomKey":"NST116022497","Rooms__RoomDimensions":"10x16","Rooms__RoomType":"Dining Room","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Welcome to 7542 Upper 42nd St N!\"},{\"Order\":2,\"Remarks\":\"The Bristol!\"},{\"Order\":3,\"Remarks\":\"The Bristol!\"},{\"Order\":4,\"Remarks\":\"The Bristol!\"},{\"Order\":5,\"Remarks\":\"This stylish and multifunctional kitchen comes complete with brand-new stainless steel appliances, sleek quartz countertops and Shaker-style cabinetry.\"},{\"Order\":6,\"Remarks\":\"The center island extends out to an overhang with space for bar-style seating\"},{\"Order\":7,\"Remarks\":\"The center island overlooks the dining room and Great Room to promote seamless everyday living\"},{\"Order\":8,\"Remarks\":\"Situated steps away from the kitchen, residents can effortlessly serve piping-hot meals straight off the stove and onto the dining table with ease.\"},{\"Order\":9,\"Remarks\":\"The center island overlooks the dining room and Great Room to promote seamless everyday living\"},{\"Order\":10,\"Remarks\":\"The Great Room is a natural gathering space within the home, perfect for lounging on the couch, watching movies and hanging out with friends.\"},{\"Order\":11,\"Remarks\":\"The first-floor flex space can easily operate as a formal dining room, sitting room or home office.\"},{\"Order\":12,\"Remarks\":\"A first-floor powder room is easily accessible from the communal living and dining spaces.\"},{\"Order\":13,\"Remarks\":\"The owner’s suite is located on the home’s second level, complemented by a spa-like bathroom and walk-in closet.\"},{\"Order\":14,\"Remarks\":\"The owner’s suite bedroom is a restful and luxurious space\"},{\"Order\":15,\"Remarks\":\"A dual sinks, glass-enclosed shower, and separate soaking tub contribute to the bathroom’s spa-like atmosphere\"},{\"Order\":16,\"Remarks\":\"Three secondary bedrooms are situated upstairs, just down the hall from the owner’s suite.\"},{\"Order\":17,\"Remarks\":\"All the secondary bedrooms include a practical wardrobe closet and wall-to-wall carpeting for plush comfort.\"},{\"Order\":18,\"Remarks\":\"With four bedrooms in total, this home is great for households that need space.\"},{\"Order\":19,\"Remarks\":\"This full second-floor bathroom features a wide single vanity and shower-tub combination.\"},{\"Order\":20,\"Remarks\":\"The unfinished basement provides so much potential for customization.\"},{\"Order\":21,\"Remarks\":\"Bristol main level floorplan\"},{\"Order\":22,\"Remarks\":\"Bristol upper level floorplan\"},{\"Order\":23,\"Remarks\":\"Bristol lower level floorplan\"},{\"Order\":24,\"Remarks\":\"Welcome to Willowbrooke!\"},{\"Order\":25,\"Remarks\":\"Welcome to Willowbrooke!\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25","CustomVTourURL":""}