{"Id":538914,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7051601","MLSAGENTID":"NST502052441","MLSOFFICEID":"NST6836","ADDRESS":"7534 Upper 42nd Street N","ACRES":0.2,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Full,Unfinished","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Oakdale","CONTINGENCY":"None","COUNTY":"Washington","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Concrete,Frame","FORECLOSURE":"No","LASTPRICE":623685.0,"LASTPRICEDATE":"2026-04-08T17:49:12.057","LATITUDE":45.009994,"LENDEROWNED":"No","LISTDATE":"2026-04-08T05:00:00","LISTPRICE":623685.0,"LIVINGAREA":2480.0,"LONGITUDE":-92.953647,"LOTDESCRIPTION":"Sod Included in Price,Underground Utilities","MODIFICATIONTIMESTAMP":"2026-04-08T17:49:12.057","OFFICE_OFFICENAME":"Lennar Sales Corp","PHOTOCOUNT":20,"POSTALCODE":"55128","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Home is available for a July closing! Located in the popular Willowbrooke community, the Sinclair features 4 bedrooms, 2.5 baths, and 2,480 square feet of well-designed living space. Step inside from the covered front porch to the private office with double doors, family room with LVP flooring and cozy gas fireplace, and a stunning kitchen with large island, quartz countertops, subway tile backsplash, stainless steel appliance package with a gas range, and sleek black hardware. Upstairs, the light-filled owner’s suite features a serene bath with a freestanding soaking tub, a shower, dual vanities, and a walk-in closet. The upper level is completed by three spacious bedrooms with walk-in closets, a large laundry room, a walk-in linen closet, and a full bath. The unfinished lower level offers room for immediate storage and future expansion. Sod, landscaping, and a lawn irrigation system are also included! Set between the Rice Creek Chain of Lakes and I-35E, the community is enveloped in a gorgeous natural environment, yet offers easy access to the Twin Cities metro area for shops, restaurants, entertainment venues, and more.","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-04-08T17:49:12.057","LASTSTATUS":"Active","STREETDIRSUFFIX":"N","STREETNAME":"Upper 42nd","STREETNUMBER":"7534","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2026,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-04-08T17:49:12.057","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"(Exterior rendering, actual home's finishes will vary.)\"},{\"Order\":17,\"Remarks\":\"Sinclair main level floorplan\"},{\"Order\":18,\"Remarks\":\"Sinclair upper level floorplan\"},{\"Order\":19,\"Remarks\":\"Sinclair lower level floorplan\"},{\"Order\":20,\"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","SOURCE":"MG_NST"}
{"ListingKey":"NST7882041","NST_AboveGradeSqFtTotal":"2480","AboveGradeFinishedArea":"2480","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"French Doors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Paneled Doors,In-Ground Sprinkler,Tile Floors,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":"Yes","AssociationYN":"True","AssociationFee":"174","AssociationFeeFrequency":"Quarterly","AssociationFeeIncludes":"Professional Mgmt,Sanitation","AssociationName":"Associa","AssociationPhone":"7632256400","AvailabilityDate":"2026-07-06T05:00:00Z","Basement":"Full,Unfinished","BasementYN":"True","NST_BathDesc":"Bathroom Ensuite,Full Primary,Private Primary,Main Floor 1/2 Bath,Separate Tub & Shower,Primary Walk-Thru","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"1096","BelowGradeFinishedArea":"0","NST_BuilderAssociationID":"Builders Association of the Twin Cities","NST_BuilderLicense":"1413","BuilderName":"LENNAR","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Oakdale","NST_CommunityName":"Willowbrooke","NST_CompletionDate":"2026-07-06","ConstructionMaterials":"Concrete,Frame","NewConstructionYN":"True","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Washington","NST_DiningRoomDescription":"Eat In Kitchen,Informal 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":"1096","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"688","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.009994","LaundryFeatures":"Gas Dryer Hookup,Upper Level,Washer Hookup","NST_LenderOwned":"No","Levels":"Two","ListPrice":"623685","ListingContractDate":"2026-04-08T05:00:00Z","ListingId":"NST7051601","LivingArea":"2480","Longitude":"-92.953647","LotFeatures":"Sod Included in Price,Underground Utilities","LotSizeArea":"0.2","LotSizeDimensions":"TBD","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1096","NST_ManufacturedHome":"N","NST_ModelHours":"11-6 Daily","NST_ModelLocation":"4024 Ave N, Oakdale","OriginalEntryTimestamp":"2026-04-08T12:46:06Z","ParcelNumber":"TBD","NST_SchoolDistrictNumber":"2093","ParkingFeatures":"Attached Garage,Asphalt,Garage Door Opener","PastureArea":"0","PhotosCount":"20","PhotosChangeTimestamp":"2026-04-08T17:49:12.057Z","PostalCity":"Oakdale","PostalCode":"55128","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Home is available for a July closing! Located in the popular Willowbrooke community, the Sinclair features 4 bedrooms, 2.5 baths, and 2,480 square feet of well-designed living space. Step inside from the covered front porch to the private office with double doors, family room with LVP flooring and cozy gas fireplace, and a stunning kitchen with large island, quartz countertops, subway tile backsplash, stainless steel appliance package with a gas range, and sleek black hardware. Upstairs, the light-filled owner’s suite features a serene bath with a freestanding soaking tub, a shower, dual vanities, and a walk-in closet. The upper level is completed by three spacious bedrooms with walk-in closets, a large laundry room, a walk-in linen closet, and a full bath. The unfinished lower level offers room for immediate storage and future expansion. Sod, landscaping, and a lawn irrigation system are also included! Set between the Rice Creek Chain of Lakes and I-35E, the community is enveloped in a gorgeous natural environment, yet offers easy access to the Twin Cities metro area for shops, restaurants, entertainment venues, and more.","RoadFrontageType":"City Street,Curbs","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":"7534","StreetNumberNumeric":"7534","StreetSuffix":"Street","SubdivisionName":"Willowbrooke","TaxAnnualAmount":"0","NST_TaxWithAssessments":"0","TaxYear":"2025","BuildingAreaTotal":"3576","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-04-08T17:49:12.057Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/46eedadf-f364-4eaf-9762-ef1021258eea.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.736Z\",\"MediaKey\":\"NST121391928\"},{\"LongDescription\":\"Sinclair upper level floorplan\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/8815d779-9729-4297-9053-6c11b74d6551.jpeg\",\"ImageWidth\":702,\"ImageHeight\":581,\"ImageSizeDescription\":\"702x581\",\"MediaModificationTimestamp\":\"2026-04-08T17:47:31.36Z\",\"MediaKey\":\"NST121391939\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/d0945ad6-6450-4b5b-ae98-44ab43c3a550.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.736Z\",\"MediaKey\":\"NST121391935\"},{\"LongDescription\":\"Welcome to Willowbrooke!\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/79cba46c-6d58-46e2-9225-695109195b4d.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.709Z\",\"MediaKey\":\"NST121391941\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/6a4ce0ff-2988-47d4-9604-2ec120013524.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.742Z\",\"MediaKey\":\"NST121391927\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/7edb1c15-d716-4e6f-8392-9974ed6835c2.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.752Z\",\"MediaKey\":\"NST121391933\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/98d075e2-7118-44c5-8cbb-9ded1df8b162.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.693Z\",\"MediaKey\":\"NST121391930\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/a66ceaad-0267-4a6e-b8fa-3c02d337e003.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.701Z\",\"MediaKey\":\"NST121391922\"},{\"LongDescription\":\"(Exterior rendering, actual home's finishes will vary.)\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/fe3a7e4e-805d-42e2-9984-df966a53ecdf.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1170,\"ImageSizeDescription\":\"2080x1170\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.745Z\",\"MediaKey\":\"NST121392351\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/cfc1e304-b4a0-42fd-ac9b-6ec9ed8a6903.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.719Z\",\"MediaKey\":\"NST121391925\"},{\"LongDescription\":\"Sinclair main level floorplan\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/b29c5e7d-6b7f-49eb-aace-d421030eccbd.jpeg\",\"ImageWidth\":762,\"ImageHeight\":582,\"ImageSizeDescription\":\"762x582\",\"MediaModificationTimestamp\":\"2026-04-08T17:47:31.362Z\",\"MediaKey\":\"NST121391938\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/528ccd61-f51b-4433-962a-a919f199ae8c.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.698Z\",\"MediaKey\":\"NST121391924\"},{\"Order\":16,\"MediaObjectID\":\"NST16\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/b8e783fe-b988-41b4-afed-a00a96e40767.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.72Z\",\"MediaKey\":\"NST121391936\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/743f5c0d-ac4b-4e92-8e5f-cc97958eeb46.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.721Z\",\"MediaKey\":\"NST121391932\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/c51323eb-ff13-4a01-ae30-5f6036dcfd2b.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.82Z\",\"MediaKey\":\"NST121391926\"},{\"LongDescription\":\"Sinclair lower level floorplan\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/da287888-3644-4323-a877-5a27bdf929d7.jpeg\",\"ImageWidth\":616,\"ImageHeight\":589,\"ImageSizeDescription\":\"616x589\",\"MediaModificationTimestamp\":\"2026-04-08T17:47:31.364Z\",\"MediaKey\":\"NST121391940\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/18ff8caa-4b2f-4d81-a9a7-e302651d9f8d.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.736Z\",\"MediaKey\":\"NST121391923\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/53489f2f-6f1d-48db-8468-bfbd1209e94b.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.707Z\",\"MediaKey\":\"NST121391931\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/591aff6c-4861-474c-ab12-9d4248b04b63.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.741Z\",\"MediaKey\":\"NST121391929\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7882041\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7882041/a8777657-e9c4-450b-b633-4243175a8af4.jpeg\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-08T17:48:27.761Z\",\"MediaKey\":\"NST121391934\"}]","Media__Order":"8","Media__MediaObjectID":"NST8","Media__ResourceRecordKey":"NST7882041","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7882041/46eedadf-f364-4eaf-9762-ef1021258eea.jpeg","Media__ImageWidth":"2048","Media__ImageHeight":"1365","Media__ImageSizeDescription":"2048x1365","Media__MediaModificationTimestamp":"4/8/2026 5:48:27 PM","Media__MediaKey":"NST121391928","DocumentsChangeTimestamp":"2026-04-08T17:47:06.823Z","Rooms":"[{\"RoomDimensions\":\"10x15\",\"RoomKey\":\"NST116095776\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2},{\"RoomDimensions\":\"15x15\",\"RoomKey\":\"NST116095778\",\"RoomType\":\"Bedroom\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5},{\"RoomDimensions\":\"11x10\",\"RoomKey\":\"NST116095781\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7},{\"RoomDimensions\":\"11x15\",\"RoomKey\":\"NST116095777\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3},{\"RoomDimensions\":\"18x15\",\"RoomKey\":\"NST116095775\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1},{\"RoomDimensions\":\"11x10\",\"RoomKey\":\"NST116095782\",\"RoomType\":\"Office\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":9},{\"RoomDimensions\":\"12x11\",\"RoomKey\":\"NST116095779\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6},{\"RoomDimensions\":\"11x11\",\"RoomKey\":\"NST116095780\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7}]","Rooms__RoomDimensions":"10x15","Rooms__RoomKey":"NST116095776","Rooms__RoomType":"Dining Room","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"(Exterior rendering, actual home's finishes will vary.)\"},{\"Order\":17,\"Remarks\":\"Sinclair main level floorplan\"},{\"Order\":18,\"Remarks\":\"Sinclair upper level floorplan\"},{\"Order\":19,\"Remarks\":\"Sinclair lower level floorplan\"},{\"Order\":20,\"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","CustomVTourURL":""}