{"Id":1428251,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST6812926","MLSAGENTID":"NST506008648","MLSOFFICEID":"NST5116","ADDRESS":"599 Stinson Boulevard","ACRES":0.25,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Walkout","BATHSTOTAL":4.0,"BEDROOMS":4,"CITY":"New Brighton","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Brick/Stone,Vinyl Siding","FORECLOSURE":"No","LASTPRICE":769000.0,"LASTPRICEDATE":"2025-11-03T19:43:04.737","LATITUDE":45.059083,"LENDEROWNED":"No","LISTDATE":"2025-11-03T06:00:00","LISTPRICE":769000.0,"LIVINGAREA":2246.0,"LONGITUDE":-93.226684,"LOTDESCRIPTION":"Some Trees","MODIFICATIONTIMESTAMP":"2025-11-04T11:04:05.316","OFFICE_OFFICENAME":"Coldwell Banker Realty","PHOTOCOUNT":13,"POSTALCODE":"55112","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Rare new construction in a beautifully established neighborhood within the award-winning Mounds View School District. The Arlow offers a bright, open-concept layout with designer finishes throughout. Enjoy a spacious kitchen with quartz countertops, stainless steel appliances, and a large island that flows seamlessly into the great room with vaulted ceilings and a cozy gas fireplace.\nUpstairs features three bedrooms, two bathrooms, including a primary suite with ensuite bath and walk-in closet, plus convenient upper-level laundry. The fully finished walkout basement adds a large family room, spacious bedroom, and ample natural light, providing even more room to relax or entertain. A three-car garage completes this incredible home.\nExperience the craftsmanship, comfort, and quality that define every Creative Homes build—don’t miss this stunning Arlow model in one of New Brighton’s most desirable areas!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Architectural Shingle","SCHOOLDISTRICTNUMBER":"621-Mounds View","SCHOOLDISTRICTPHONE":"651-621-6001","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2025-11-03T19:43:04.737","LASTSTATUS":"Active","STREETNAME":"Stinson","STREETNUMBER":"599","STREETSUFFIX":"Boulevard","STYLE":"Single Family Residence","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2025-11-03T20:17:03.892","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":2,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":3,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":4,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":5,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":6,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":7,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":8,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":9,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":10,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":11,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":12,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":13,\"Remarks\":\"Photos are of a similar model\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13","SOURCE":"MG_NST"}
{"ListingKey":"NST7823294","LotSizeArea":"0.25","NST_AgeOfProperty":"0","NST_AgentOwner":"No","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","NST_AmenitiesUnit":"Ceiling Fan(s),Kitchen Center Island,Kitchen Window,Tile Floors","Appliances":"Cooktop,Dishwasher,Disposal,Microwave,Range,Refrigerator,Stainless Steel Appliances","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","PropertyAttachedYN":"False","NST_AttributionContact":"763-772-3256","NST_AttributionName":"Haythem Khalil","Basement":"Finished,Walkout","BasementYN":"True","NST_BathDesc":"3/4 Basement,3/4 Primary,Main Floor 1/2 Bath,Upper Level 3/4 Bath,Upper Level Full Bath","BathroomsOneQuarter":"0","BathroomsFull":"2","BathroomsHalf":"1","BathroomsThreeQuarter":"1","BathroomsTotalInteger":"4","BedroomsTotal":"4","NST_BuilderLicense":"667667","BuilderName":"CREATIVE HOMES INC","City":"New Brighton","PropertyType":"Residential","NST_CompletionDate":"2026-01-16","NST_ConstructionMaterialsDesc":"Block","NewConstructionYN":"True","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Y","DaysOnMarket":"1","CumulativeDaysOnMarket":"1","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room","Directions":"694 to Silver Lk Rd S, to 5th St W, to Stinson Blvd, N to home.","InternetAddressDisplayYN":"True","InternetEntireListingDisplayYN":"True","Electric":"Circuit Breakers","ConstructionMaterials":"Brick/Stone,Vinyl Siding","FireplaceFeatures":"Family Room,Gas","FireplaceYN":"True","FireplacesTotal":"1","NST_ForeclosureStatus":"No","FoundationArea":"961","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","ParkingFeatures":"Attached Garage","NST_GarageSquareFeet":"0","AccessibilityFeatures":"None","Heating":"Forced Air,Fireplace(s)","OriginalEntryTimestamp":"2025-11-03T19:39:44Z","LandLeaseYN":"False","NST_LastUpdateDate":"2025-11-04","Latitude":"45.059083","NST_LenderOwned":"No","ListAgentKey":"NST97718","ListAgentMlsId":"NST506008648","ListingContractDate":"2025-11-03T06:00:00Z","ListOfficeKey":"NST16638","ListOfficeName":"Coldwell Banker Realty","ListOfficeMlsId":"NST5116","ListPrice":"769000","LivingArea":"2246","Longitude":"-93.226684","LotFeatures":"Some Trees","LotSizeDimensions":"Irregular","LotSizeSquareFeet":"10846.44","LotSizeUnits":"Acres","ListingId":"NST6812926","SourceSystemName":"RMLS","NST_ManufacturedHome":"No","MapCoordinateSource":"King's Street Atlas","AdditionalParcelsYN":"False","NST_OfficeBoard":"MAAR","ParcelNumber":"303023230046","GarageSpaces":"3","PhotosCount":"13","PostalCity":"Saint Paul","PostalCode":"55112","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PublicRemarks":"Rare new construction in a beautifully established neighborhood within the award-winning Mounds View School District. The Arlow offers a bright, open-concept layout with designer finishes throughout. Enjoy a spacious kitchen with quartz countertops, stainless steel appliances, and a large island that flows seamlessly into the great room with vaulted ceilings and a cozy gas fireplace.\nUpstairs features three bedrooms, two bathrooms, including a primary suite with ensuite bath and walk-in closet, plus convenient upper-level laundry. The fully finished walkout basement adds a large family room, spacious bedroom, and ample natural light, providing even more room to relax or entertain. A three-car garage completes this incredible home.\nExperience the craftsmanship, comfort, and quality that define every Creative Homes build—don’t miss this stunning Arlow model in one of New Brighton’s most desirable areas!","PublicSurveyRange":"23","PublicSurveySection":"29","PublicSurveyTownship":"30","NST_RentalLicenseYN":"No","Roof":"Architectural Shingle","RoomType":"Living Room,Kitchen,Dining Room,Bedroom 1,Bedroom 2,Bedroom 3,Family Room,Bedroom 4","NST_AboveGradeSqFtTotal":"1622.0000","NST_BelowGradeSqFtTotal":"961.0000","NST_MainLevelFinishedArea":"931.0000","BuildingAreaTotal":"2583","HighSchoolDistrict":"Mounds View","NST_SchoolDistrictNumber":"621","NST_SchoolDistrictPhone":"651-621-6001","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,Primary Bdr Suite","AboveGradeFinishedArea":"1622","BelowGradeFinishedArea":"624","StateOrProvince":"MN","StandardStatus":"Active","Levels":"Two","StreetName":"Stinson","StreetNumber":"599","StreetNumberNumeric":"599","StreetSuffix":"Boulevard","PropertySubType":"Single Family Residence","SubdivisionName":"Seminary Estates 3rd Add","NST_TaxWithAssessments":"366.0000","TaxYear":"2025","TaxAnnualAmount":"366","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ModificationTimestamp":"2025-11-04T11:04:05.316Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7823294\",\"Order\":1,\"MediaObjectID\":\"1\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":576,\"ImageSizeDescription\":\"1024x576\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/8b47813c-9fdf-4615-bf10-8d8ab03e842e.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.461Z\",\"MediaKey\":\"69090db9b4e5003fb872fb7e\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":2,\"MediaObjectID\":\"2\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/552c7c52-b7b0-4355-b175-1e18563b09fc.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.528Z\",\"MediaKey\":\"69090db9b4e5003fb872fb7f\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":3,\"MediaObjectID\":\"3\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/28673e24-ac4b-4b4c-8f2e-08f290e94610.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.475Z\",\"MediaKey\":\"69090db9b4e5003fb872fb80\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":4,\"MediaObjectID\":\"4\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/8e689b8a-2b3e-4562-9eb6-af6df2f37ff7.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.485Z\",\"MediaKey\":\"69090db9b4e5003fb872fb81\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":5,\"MediaObjectID\":\"5\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/fbdcfbc9-9da5-4919-b80d-8e1703047c47.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.432Z\",\"MediaKey\":\"69090db9b4e5003fb872fb82\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":6,\"MediaObjectID\":\"6\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/242cea4b-db45-4fe4-8262-711e4268a2cf.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.467Z\",\"MediaKey\":\"69090db9b4e5003fb872fb83\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":7,\"MediaObjectID\":\"7\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/49b21b60-3599-4d2f-989e-e8eab3331d0b.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.469Z\",\"MediaKey\":\"69090db9b4e5003fb872fb84\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":8,\"MediaObjectID\":\"8\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/47859b40-b887-436c-8c77-399871d0d492.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.449Z\",\"MediaKey\":\"69090db9b4e5003fb872fb85\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":9,\"MediaObjectID\":\"9\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/40233319-b79d-4c60-89f3-78ad74449de6.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.44Z\",\"MediaKey\":\"69090db9b4e5003fb872fb86\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":10,\"MediaObjectID\":\"10\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/d111ebfb-eb44-47b9-9a5e-7a90db00043c.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.461Z\",\"MediaKey\":\"69090db9b4e5003fb872fb87\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":11,\"MediaObjectID\":\"11\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/6cf7e698-2442-4abd-a15a-a539d4cd15c6.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.448Z\",\"MediaKey\":\"69090db9b4e5003fb872fb88\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":12,\"MediaObjectID\":\"12\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/24371640-308b-41aa-8dd9-6d3dcc782e68.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.451Z\",\"MediaKey\":\"69090db9b4e5003fb872fb89\"},{\"ResourceRecordKey\":\"NST7823294\",\"Order\":13,\"MediaObjectID\":\"13\",\"LongDescription\":\"Photos are of a similar model\",\"ImageWidth\":1024,\"ImageHeight\":681,\"ImageSizeDescription\":\"1024x681\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7823294/7cb610b5-8211-49d4-9964-1bab6901c463.jpeg\",\"MediaModificationTimestamp\":\"2025-11-03T20:16:57.471Z\",\"MediaKey\":\"69090db9b4e5003fb872fb8a\"}]","PhotosChangeTimestamp":"2025-11-03T20:17:03.892Z","Rooms":"[{\"RoomKey\":\"NST115750657\",\"RoomType\":\"Living Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"22x15\",\"NST_RoomSortOrder\":\"1\"},{\"RoomKey\":\"NST115750658\",\"RoomType\":\"Kitchen\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x12\",\"NST_RoomSortOrder\":\"2\"},{\"RoomKey\":\"NST115750659\",\"RoomType\":\"Dining Room\",\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14x11\",\"NST_RoomSortOrder\":\"3\"},{\"RoomKey\":\"NST115750660\",\"RoomType\":\"Bedroom 1\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"12x11\",\"NST_RoomSortOrder\":\"4\"},{\"RoomKey\":\"NST115750661\",\"RoomType\":\"Bedroom 2\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"5\"},{\"RoomKey\":\"NST115750662\",\"RoomType\":\"Bedroom 3\",\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"10x10\",\"NST_RoomSortOrder\":\"6\"},{\"RoomKey\":\"NST115750663\",\"RoomType\":\"Family Room\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"27x13\",\"NST_RoomSortOrder\":\"7\"},{\"RoomKey\":\"NST115750664\",\"RoomType\":\"Bedroom 4\",\"RoomLevel\":\"Lower\",\"RoomDimensions\":\"13x12\",\"NST_RoomSortOrder\":\"8\"}]","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":2,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":3,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":4,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":5,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":6,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":7,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":8,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":9,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":10,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":11,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":12,\"Remarks\":\"Photos are of a similar model\"},{\"Order\":13,\"Remarks\":\"Photos are of a similar model\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13","CustomVTourURL":""}