{"Id":536928,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7048683","MLSAGENTID":"NST506018497","MLSOFFICEID":"NST1348","ADDRESS":"671 Tulare Terrace","ACRES":0.05,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"None","BATHSTOTAL":3.0,"BEDROOMS":3.0,"CITY":"West Saint Paul","CONTINGENCY":"None","COUNTY":"Dakota","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":397990.0,"LASTPRICEDATE":"2026-04-03T16:42:07.907","LATITUDE":44.89948952,"LENDEROWNED":"No","LISTDATE":"2026-04-03T05:00:00","LISTPRICE":397990.0,"LIVINGAREA":1667.0,"LONGITUDE":-93.0698023,"MODIFICATIONTIMESTAMP":"2026-04-03T16:54:06.985","OFFICE_OFFICENAME":"M/I Homes","PHOTOCOUNT":7,"POSTALCODE":"55118","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome to the Bayfield with 1,667 square feet of living space! The home features an open-concept living area that seamlessly connects the main gathering spaces. 3 bedrooms, 2.5 bathrooms and a loft create an inviting atmosphere for daily life and entertaining. The kitchen flows right into the family room—the perfect layout for entertaining and everyday routines. With 2 towering windows along the back wall, natural light streams into this cozy living area! Set up your dining table and chairs in the adjacent dining room, and easily access your back patio through the sliding glass doors. A mud room, a storage closet, and a half bath round out this thoughtfully designed first floor. Head upstairs to discover 2 secondary bedrooms on one end of the floor, a roomy loft in the middle, and a luxurious owner's suite on its own private end. If the Bayfield floorplan sounds like a fit for you, reach out to our team!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Architectural Shingle","SCHOOLDISTRICTNUMBER":"951-West St. Paul-Mendota Hts.-Eagan","SCHOOLDISTRICTPHONE":"6514037002","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-04-03T16:42:07.907","LASTSTATUS":"Active","STREETNAME":"Tulare","STREETNUMBER":"671","STREETSUFFIX":"Terrace","STYLE":"(TH) Side x Side","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2025,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-04-03T16:49:05.793","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Bayfield - Rendering\"},{\"Order\":2,\"Remarks\":\"Kitchen - Virtually Staged\"},{\"Order\":3,\"Remarks\":\"Family Room - Virtually Staged\"},{\"Order\":4,\"Remarks\":\"Loft - Virtually Staged\"},{\"Order\":5,\"Remarks\":\"Owner's Suite - Virtually Staged\"},{\"Order\":6,\"Remarks\":\"First Floor\"},{\"Order\":7,\"Remarks\":\"Second Floor\"}]","PHOTOORDER":"1,2,3,4,5,6,7","SOURCE":"MG_NST"}
{"ListingKey":"NST7879543","NST_AboveGradeSqFtTotal":"1667","AboveGradeFinishedArea":"1667","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","Appliances":"Air-To-Air Exchanger,Dishwasher,Disposal,Dryer,ENERGY STAR Qualified Appliances,Microwave,Range,Refrigerator,Washer","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"True","AssociationFee":"280","AssociationFeeFrequency":"Monthly","AssociationFeeIncludes":"Building Exterior,Hazard Insurance,Lawn Care,Sanitation,Snow Removal","AssociationName":"First Service Residential","AssociationPhone":"7632336527","Basement":"None","BasementYN":"False","NST_BathDesc":"Bathroom Ensuite,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_BuilderLicense":"701438","BuilderName":"HANS HAGEN HOMES AND M/I HOMES","CumulativeDaysOnMarket":"0","City":"West Saint Paul","NST_CommunityName":"Cherrywood","NST_CompletionDate":"2026-07-08","NewConstructionYN":"True","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Dakota","NST_DiningRoomDescription":"Informal Dining Room","Directions":"Driving on 94-E, take exit 242-D to merge onto US-52 S. Travel on this road for roughly 3.5 miles until you reach the exit at Thompson Ave to Wentworth Ave. Take a right on Thompson, then turn left onto Oakdale Ave and the community will be on your left.","DocumentsCount":"0","DaysOnMarket":"0","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"680","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"390","GarageSpaces":"2","Heating":"Forced Air,Fireplace(s)","HighSchoolDistrict":"West St. Paul-Mendota Hts.-Eagan","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.8994895228","LaundryFeatures":"Laundry Room,Upper Level","NST_LenderOwned":"No","Levels":"Two","ListPrice":"397990","ListingContractDate":"2026-04-03T05:00:00Z","ListingId":"NST7048683","LivingArea":"1667","Longitude":"-93.0698022999","LotSizeArea":"0.05","LotSizeDimensions":"29x50","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"680","NST_ManufacturedHome":"N","NST_ModelHours":"11-6pm","NST_ModelLocation":"1531 Traverse Lane","OriginalEntryTimestamp":"2026-04-03T11:37:51Z","ParcelNumber":"TBD","NST_SchoolDistrictNumber":"951","ParkingFeatures":"Attached Garage","NST_PatioPorchType":"Patio","PhotosCount":"7","PhotosChangeTimestamp":"2026-04-03T16:49:05.793Z","PostalCity":"West Saint Paul","PostalCode":"55118","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"True","PropertySubType":"(TH) Side x Side","PropertyType":"Residential","PublicRemarks":"Welcome to the Bayfield with 1,667 square feet of living space! The home features an open-concept living area that seamlessly connects the main gathering spaces. 3 bedrooms, 2.5 bathrooms and a loft create an inviting atmosphere for daily life and entertaining. The kitchen flows right into the family room—the perfect layout for entertaining and everyday routines. With 2 towering windows along the back wall, natural light streams into this cozy living area! Set up your dining table and chairs in the adjacent dining room, and easily access your back patio through the sliding glass doors. A mud room, a storage closet, and a half bath round out this thoughtfully designed first floor. Head upstairs to discover 2 secondary bedrooms on one end of the floor, a roomy loft in the middle, and a luxurious owner's suite on its own private end. If the Bayfield floorplan sounds like a fit for you, reach out to our team!","Roof":"Architectural Shingle","NST_SchoolDistrictPhone":"6514037002","Sewer":"City Sewer/Connected","NST_SingleFamilyTownhouseType":"End Unit,Multi-Level","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Tulare","StreetNumber":"671","StreetNumberNumeric":"671","StreetSuffix":"Terrace","SubdivisionName":"Cherrywood","TaxAnnualAmount":"0","NST_TaxWithAssessments":"0","TaxYear":"2026","BuildingAreaTotal":"1667","Township":"West Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","YearBuilt":"2025","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST277331","ListAgentMlsId":"NST506018497","ListOfficeMlsId":"NST1348","ListOfficeName":"M/I Homes","ListOfficeKey":"NST13437","ModificationTimestamp":"2026-04-03T16:54:06.985Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/3d8668d9-303f-4eb9-96d1-5afd2c224d3e.jpeg\",\"LongDescription\":\"First Floor\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":427,\"ImageHeight\":682,\"ImageSizeDescription\":\"427x682\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.779Z\",\"MediaKey\":\"NST121306315\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/0e575ae6-9b28-452c-beef-5385e4255cc8.jpeg\",\"LongDescription\":\"Second Floor\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":356,\"ImageHeight\":565,\"ImageSizeDescription\":\"356x565\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.778Z\",\"MediaKey\":\"NST121306316\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/c87b0c99-6997-4f01-a968-3c3a0d5437d5.jpeg\",\"LongDescription\":\"Kitchen - Virtually Staged\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.796Z\",\"MediaKey\":\"NST121306030\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/0d6337c7-797b-4cc0-910c-3adeb6a4ee20.jpeg\",\"LongDescription\":\"Loft - Virtually Staged\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.856Z\",\"MediaKey\":\"NST121306032\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/5ba8ceb5-1851-4350-b1ce-aa602985b609.jpeg\",\"LongDescription\":\"Owner's Suite - Virtually Staged\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.795Z\",\"MediaKey\":\"NST121306033\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/3532373e-8710-4fa4-ac34-59f7b41e1969.jpeg\",\"LongDescription\":\"Bayfield - Rendering\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":1200,\"ImageHeight\":900,\"ImageSizeDescription\":\"1200x900\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.784Z\",\"MediaKey\":\"NST121306405\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7879543/0d07a864-352b-4ab0-ad7f-f1e2d1b56dd4.jpeg\",\"LongDescription\":\"Family Room - Virtually Staged\",\"ResourceRecordKey\":\"NST7879543\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2048,\"ImageHeight\":1365,\"ImageSizeDescription\":\"2048x1365\",\"MediaModificationTimestamp\":\"2026-04-03T16:48:06.88Z\",\"MediaKey\":\"NST121306031\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7879543/3d8668d9-303f-4eb9-96d1-5afd2c224d3e.jpeg","Media__LongDescription":"First Floor","Media__ResourceRecordKey":"NST7879543","Media__Order":"6","Media__MediaObjectID":"NST6","Media__ImageWidth":"427","Media__ImageHeight":"682","Media__ImageSizeDescription":"427x682","Media__MediaModificationTimestamp":"4/3/2026 4:48:06 PM","Media__MediaKey":"NST121306315","DocumentsChangeTimestamp":"2026-04-03T16:38:06.551Z","Rooms":"[{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":3,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"9.3 x 10.5\",\"RoomKey\":\"NST116080067\"},{\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":2,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"14 x 11.5\",\"RoomKey\":\"NST116080066\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13.6 x 14.7\",\"RoomKey\":\"NST116080069\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":1,\"RoomLevel\":\"Main\",\"RoomDimensions\":\"11.5 x 8.5\",\"RoomKey\":\"NST116080065\"},{\"RoomType\":\"Loft\",\"NST_RoomSortOrder\":4,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"13.6 x 9.8\",\"RoomKey\":\"NST116080068\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9.6 x 10.11\",\"RoomKey\":\"NST116080070\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomLevel\":\"Upper\",\"RoomDimensions\":\"9.5 x 12.11\",\"RoomKey\":\"NST116080071\"}]","Rooms__RoomType":"Dining Room","Rooms__NST_RoomSortOrder":"3","Rooms__RoomLevel":"Main","Rooms__RoomDimensions":"9.3 x 10.5","Rooms__RoomKey":"NST116080067","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Bayfield - Rendering\"},{\"Order\":2,\"Remarks\":\"Kitchen - Virtually Staged\"},{\"Order\":3,\"Remarks\":\"Family Room - Virtually Staged\"},{\"Order\":4,\"Remarks\":\"Loft - Virtually Staged\"},{\"Order\":5,\"Remarks\":\"Owner's Suite - Virtually Staged\"},{\"Order\":6,\"Remarks\":\"First Floor\"},{\"Order\":7,\"Remarks\":\"Second Floor\"}]","PhotoOrder":"1,2,3,4,5,6,7","CustomVTourURL":""}