468 Warwick Street Saint Paul, MN 55105

Features

Features

Property Features

ERA Prospera Real Estate is not a Multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of ERA Prospera Real Estate, 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":590829,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7115379","MLSAGENTID":"NST506013786","MLSCOAGENTID":"NST506010262","MLSOFFICEID":"NST253180","ADDRESS":"468 Warwick Street","ACRES":0.137,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Daylight/Lookout Windows,Drain Tiled,Drainage System,Finished,Full,Sump Pump","BATHSTOTAL":3.0,"BEDROOMS":4.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"EXTERIOR":"Block","FORECLOSURE":"No","LASTPRICE":700000.0,"LASTPRICEDATE":"2026-07-24T21:28:07.963","LATITUDE":44.92744996,"LENDEROWNED":"No","LISTDATE":"2026-07-24T05:00:00","LISTPRICE":700000.0,"LIVINGAREA":2610.0,"LONGITUDE":-93.16284112,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-07-25T10:20:11.534","NEIGHBORHOOD":"95","OFFICE_OFFICENAME":"ERA Prospera Real Estate","PHOTOCOUNT":27,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Welcome Home! The perfect blend of timeless charm & modern living. Sunlight fills beautifully curated spaces featuring white oak hardwood floors, soaring 9-foot ceilings, & a stunning Gourmet kitchen with quartz countertops, custom soft close cabinetry, and an oversized island designed for gatherings. Enjoy quiet mornings sipping coffee on the inviting 3 season front porch and cozy evenings by the gas fireplace. The versatile main-level flex room offers endless possibilities for office, den, guest room, or private retreat. Upstairs, spacious primary suite provides a peaceful escape with a walk-in closet & spa-inspired bath. Finished lower level adds valuable living space with a large family room, while framed space for a future bedroom & bath offers flexibility and potential. Outside, enjoy the inviting front porch, newly installed gutters & the fenced spacious backyard for play & pets or patio seating area. Easy access to neighborhood cafés, restaurants, parks, schools, and everyday conveniences. More than a home, it's a lifestyle. Schedule your showing today!","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Age 8 Years or Less,Asphalt,Pitched","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-07-24T21:28:07.963","LASTSTATUS":"Active","STREETNAME":"Warwick","STREETNUMBER":"468","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1922,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-07-24T21:28:07.963","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"Because one look isn't enough\"},{\"Order\":2,\"Remarks\":\"Welcome Home to your Urban Farmhouse\"},{\"Order\":3,\"Remarks\":\"Inviting 3 season covered porch\"},{\"Order\":4,\"Remarks\":\"Main Floor Bedroom, Office/Den. Many Possibilities for this main floor room.\"},{\"Order\":5,\"Remarks\":\"Cozy sitting area for morning coffee or quiet time.\"},{\"Order\":6,\"Remarks\":\"Thoughtfully designed Gourmet Kitchen is the Focal point of the main floor open-concept layout. This kitchen sure has loads of countertop space!\"},{\"Order\":7,\"Remarks\":\"Pantry cabinet provides for plenty of storage. Accent shelves, quartz countertops, and tile backsplash completes the upgraded look of this spacious kitchen\"},{\"Order\":8,\"Remarks\":\"Kitchen open to the Formal Dining Room or a Sun Room if you wish\"},{\"Order\":9,\"Remarks\":\"Open Concept Perfect for entertaining and seamless flowing floor plan\"},{\"Order\":10,\"Remarks\":\"Sunfilled Dining Nook\"},{\"Order\":11,\"Remarks\":\"Many memories will be made here\"},{\"Order\":12,\"Remarks\":\"The perfect picturesque setup for the holidays\"},{\"Order\":13,\"Remarks\":\"Absolutely dreamy Primary Bedroom with Ensuite\"},{\"Order\":14,\"Remarks\":\"Something out of a Luxury Magazine but it's actually in your very own Ensuite\"},{\"Order\":15,\"Remarks\":\"Big enough of for 2 is this 4x4 massive shower with accent tile floor & surround\"},{\"Order\":16,\"Remarks\":\"Timeless character with modern functionality\"},{\"Order\":17,\"Remarks\":\"No one has to fight over which bedroom is better because they are both mirror images of each other\"},{\"Order\":18,\"Remarks\":\"Spacious Bedrooms! No one has to fight over which bedroom is better because they are both mirror images of each other\"},{\"Order\":19,\"Remarks\":\"Double vanities with patterned tile floor and bathtub with tile surround to the ceiling\"},{\"Order\":20,\"Remarks\":\"Full Size Hall Bath with Double Vanities and Unique Patterned Tile\"},{\"Order\":21,\"Remarks\":\"It's a massive family room\"},{\"Order\":22,\"Remarks\":\"Basement Family room has multitude of uses. Kids room, man cave, family room, exercise room, etc.\"},{\"Order\":23,\"Remarks\":\"Fenced Yard. Rare to have a flat usable lot\"},{\"Order\":24,\"Remarks\":\"Over sized 2 car Garage\"},{\"Order\":25,\"Remarks\":\"Home is very conveniently located to most major services.\"},{\"Order\":26,\"Remarks\":\"468 Warwick Neighborhood Eats\"},{\"Order\":27,\"Remarks\":\"Located near a variety of outdoor activities - minnehaha park, golf course, trails etc.\"}]","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,26,27","SOURCE":"MG_NST"}

{"ListingKey":"NST7940682","NST_AboveGradeSqFtTotal":"2116","AboveGradeFinishedArea":"2116","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Cable,Hardwood Floors,Kitchen Window,Primary Bedroom Walk-In Closet,Patio,Paneled Doors,Porch,Tile Floors,Washer/Dryer Hookup,Walk-In Closet","Appliances":"Dishwasher,Disposal,Electric Water Heater,Exhaust Fan,Microwave,Range,Refrigerator","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"No","AssociationYN":"False","AssociationFee":"0","Basement":"Daylight/Lookout Windows,Drain Tiled,Drainage System,Finished,Full,Sump Pump","BasementYN":"True","NST_BathDesc":"Basement,Bathroom Ensuite,Full Primary,Main Floor 1/2 Bath,Rough In,Separate Tub & Shower,Upper Level Full Bath","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"3","BedroomsTotal":"4","NST_BelowGradeSqFtTotal":"494","BelowGradeFinishedArea":"494","CumulativeDaysOnMarket":"63","City":"Saint Paul","ConstructionMaterials":"Block","NewConstructionYN":"False","Contingency":"None","NST_ForSaleOrLease":"For Sale","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room,Separate/Formal Dining Room","Directions":"Snelling to Randolph. East to Warwick and North to Home.","DocumentsCount":"4","DocumentsChangeTimestamp":"2026-07-24T21:58:06.392Z","DaysOnMarket":"0","Electric":"Circuit Breakers","ExteriorFeatures":"Block,Stucco,Vinyl,Wood","Fencing":"Vinyl,Wood","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","FoundationArea":"1090","FoundationDetails":"Block","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"576","NST_GarageDimensions":"24x24","NST_GarageDoorHeight":"7","NST_GarageDoorWidth":"16","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"True","InternetConsumerCommentYN":"True","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.9274499627","NST_LenderOwned":"No","Levels":"Two","ListPrice":"700000","ListingContractDate":"2026-07-24T05:00:00Z","ListingId":"NST7115379","LivingArea":"2610","Longitude":"-93.1628411214","LotFeatures":"Tree Coverage - Light","LotSizeArea":"0.137","LotSizeDimensions":"47x127","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1090","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Macalester-Groveland","NST_NeighborhoodNumber":"95","OriginalEntryTimestamp":"2026-07-24T16:26:49Z","ParcelNumber":"102823230041","ParkingFeatures":"Detached Garage","PhotosCount":"27","PhotosChangeTimestamp":"2026-07-24T21:28:07.963Z","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Welcome Home! The perfect blend of timeless charm & modern living. Sunlight fills beautifully curated spaces featuring white oak hardwood floors, soaring 9-foot ceilings, & a stunning Gourmet kitchen with quartz countertops, custom soft close cabinetry, and an oversized island designed for gatherings. Enjoy quiet mornings sipping coffee on the inviting 3 season front porch and cozy evenings by the gas fireplace. The versatile main-level flex room offers endless possibilities for office, den, guest room, or private retreat. Upstairs, spacious primary suite provides a peaceful escape with a walk-in closet & spa-inspired bath. Finished lower level adds valuable living space with a large family room, while framed space for a future bedroom & bath offers flexibility and potential. Outside, enjoy the inviting front porch, newly installed gutters & the fenced spacious backyard for play & pets or patio seating area. Easy access to neighborhood cafés, restaurants, parks, schools, and everyday conveniences. More than a home, it's a lifestyle. Schedule your showing today!","PublicSurveyRange":"23","PublicSurveySection":"10","PublicSurveyTownship":"28","RoadFrontageType":"City Street","RoadResponsibility":"Public Maintained Road","Roof":"Age 8 Years or Less,Asphalt,Pitched","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","Sewer":"City Sewer/Connected","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,Main Floor Bedroom","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Warwick","StreetNumber":"468","StreetNumberNumeric":"468","StreetSuffix":"Street","SubdivisionName":"Fooshe Add","TaxAnnualAmount":"12970","NST_TaxWithAssessments":"12970","TaxYear":"2026","NST_TotalArea":"2610","BuildingAreaTotal":"2610","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1922","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST100408","CoListAgentMlsId":"NST506010262","CoListOfficeName":"ERA Prospera Real Estate","ListAgentKey":"NST106399","ListAgentMlsId":"NST506013786","ListOfficeMlsId":"NST253180","ListOfficeName":"ERA Prospera Real Estate","ListOfficeKey":"NST1001923","ModificationTimestamp":"2026-07-25T10:20:11.534Z","OriginatingSystemName":"northstar","Media":"[{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/c6556763-5cab-46a1-aa2a-c5a55c287853.jpeg\",\"LongDescription\":\"Because one look isn't enough\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"ImageWidth\":2080,\"ImageHeight\":1309,\"ImageSizeDescription\":\"2080x1309\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.08Z\",\"MediaKey\":\"NST123808466\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/a0e9fb92-6bf0-47aa-8690-bf2dd22db880.jpeg\",\"LongDescription\":\"Big enough of for 2 is this 4x4 massive shower with accent tile floor & surround\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"ImageWidth\":2080,\"ImageHeight\":1383,\"ImageSizeDescription\":\"2080x1383\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.075Z\",\"MediaKey\":\"NST123808480\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/5ffc423a-cd7b-467e-9533-ca660a3660e0.jpeg\",\"LongDescription\":\"Many memories will be made here\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"ImageWidth\":2080,\"ImageHeight\":1232,\"ImageSizeDescription\":\"2080x1232\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.08Z\",\"MediaKey\":\"NST123808476\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/aea18ee9-3689-47b5-9f15-e244677e0049.jpeg\",\"LongDescription\":\"Something out of a Luxury Magazine but it's actually in your very own Ensuite\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"ImageWidth\":2080,\"ImageHeight\":1383,\"ImageSizeDescription\":\"2080x1383\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.076Z\",\"MediaKey\":\"NST123808479\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/c73fe736-2c68-44e6-b559-f15bd8617aa1.jpeg\",\"LongDescription\":\"Thoughtfully designed Gourmet Kitchen is the Focal point of the main floor open-concept layout. This kitchen sure has loads of countertop space!\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"ImageWidth\":2080,\"ImageHeight\":1226,\"ImageSizeDescription\":\"2080x1226\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.078Z\",\"MediaKey\":\"NST123808471\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/1a39534a-347c-4604-a651-ba69437bde7e.jpeg\",\"LongDescription\":\"It's a massive family room\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":21,\"MediaObjectID\":\"NST21\",\"ImageWidth\":2080,\"ImageHeight\":1226,\"ImageSizeDescription\":\"2080x1226\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.076Z\",\"MediaKey\":\"NST123808486\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/636c3f01-66c3-488e-adf9-cc4152b2670a.jpeg\",\"LongDescription\":\"Full Size Hall Bath with Double Vanities and Unique Patterned Tile\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"ImageWidth\":2080,\"ImageHeight\":1383,\"ImageSizeDescription\":\"2080x1383\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.066Z\",\"MediaKey\":\"NST123808485\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/15c7a39e-de99-4fd4-86dd-77d8a311f045.jpeg\",\"LongDescription\":\"Basement Family room has multitude of uses. Kids room, man cave, family room, exercise room, etc.\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":22,\"MediaObjectID\":\"NST22\",\"ImageWidth\":2080,\"ImageHeight\":1226,\"ImageSizeDescription\":\"2080x1226\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.08Z\",\"MediaKey\":\"NST123808487\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/c4ec01b1-4bf1-458d-bbb9-8c56a6345017.jpeg\",\"LongDescription\":\"Cozy sitting area for morning coffee or quiet time.\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.059Z\",\"MediaKey\":\"NST123808470\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/9c7e6cb8-6106-4b91-a064-f49df7115741.jpeg\",\"LongDescription\":\"Inviting 3 season covered porch\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.061Z\",\"MediaKey\":\"NST123808468\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/88a419e6-29a0-4d17-822a-3f29de39c6bf.jpeg\",\"LongDescription\":\"No one has to fight over which bedroom is better because they are both mirror images of each other\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"ImageWidth\":2080,\"ImageHeight\":1383,\"ImageSizeDescription\":\"2080x1383\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.059Z\",\"MediaKey\":\"NST123808482\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/df78fa9c-9210-4603-8d60-fd1aaa4727ba.jpeg\",\"LongDescription\":\"Spacious Bedrooms! No one has to fight over which bedroom is better because they are both mirror images of each other\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"ImageWidth\":2080,\"ImageHeight\":1309,\"ImageSizeDescription\":\"2080x1309\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.042Z\",\"MediaKey\":\"NST123808483\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/cf25da23-c608-44a8-bf86-dd3fdaea878c.jpeg\",\"LongDescription\":\"Double vanities with patterned tile floor and bathtub with tile surround to the ceiling\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.059Z\",\"MediaKey\":\"NST123808484\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/e7ceb294-d290-4098-87ed-548a47734bc0.jpeg\",\"LongDescription\":\"Pantry cabinet provides for plenty of storage. Accent shelves, quartz countertops, and tile backsplash completes the upgraded look of this spacious kitchen\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"ImageWidth\":2080,\"ImageHeight\":1226,\"ImageSizeDescription\":\"2080x1226\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.058Z\",\"MediaKey\":\"NST123808472\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/81a921f3-087b-404c-847c-87c0b0d6f27d.jpeg\",\"LongDescription\":\"Over sized 2 car Garage\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":24,\"MediaObjectID\":\"NST24\",\"ImageWidth\":2080,\"ImageHeight\":1202,\"ImageSizeDescription\":\"2080x1202\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.059Z\",\"MediaKey\":\"NST123808489\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/493b49af-bbe8-4082-bbbc-f46861dea4c9.jpeg\",\"LongDescription\":\"Located near a variety of outdoor activities - minnehaha park, golf course, trails etc.\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":27,\"MediaObjectID\":\"NST27\",\"ImageWidth\":2080,\"ImageHeight\":1589,\"ImageSizeDescription\":\"2080x1589\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.091Z\",\"MediaKey\":\"NST123808492\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/9731e363-f4c5-40d5-a9c0-a1ae5f67f974.jpeg\",\"LongDescription\":\"Kitchen open to the Formal Dining Room or a Sun Room if you wish\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.057Z\",\"MediaKey\":\"NST123808473\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/4eb7f45a-9a35-41ad-a998-1f0f49683fa7.jpeg\",\"LongDescription\":\"The perfect picturesque setup for the holidays\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"ImageWidth\":2080,\"ImageHeight\":1383,\"ImageSizeDescription\":\"2080x1383\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.059Z\",\"MediaKey\":\"NST123808477\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/a3314736-9421-46f1-bb51-028c7abdcf0d.jpeg\",\"LongDescription\":\"Welcome Home to your Urban Farmhouse\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"ImageWidth\":2080,\"ImageHeight\":1448,\"ImageSizeDescription\":\"2080x1448\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.085Z\",\"MediaKey\":\"NST123808467\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/e6fa62ad-4c4f-4d80-a833-ecf5075d9e02.jpeg\",\"LongDescription\":\"Sunfilled Dining Nook\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"ImageWidth\":2080,\"ImageHeight\":1273,\"ImageSizeDescription\":\"2080x1273\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.042Z\",\"MediaKey\":\"NST123808475\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/b5d818a7-bf60-4bc2-8a27-bb085ad54bc9.jpeg\",\"LongDescription\":\"Open Concept Perfect for entertaining and seamless flowing floor plan\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.042Z\",\"MediaKey\":\"NST123808474\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/e676c26c-b72c-49de-8c06-18d9d4d3aef6.jpeg\",\"LongDescription\":\"Absolutely dreamy Primary Bedroom with Ensuite\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"ImageWidth\":2080,\"ImageHeight\":1309,\"ImageSizeDescription\":\"2080x1309\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.059Z\",\"MediaKey\":\"NST123808478\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/922b5956-b379-4f40-8fa8-477ea343202d.jpeg\",\"LongDescription\":\"Main Floor Bedroom, Office/Den. Many Possibilities for this main floor room.\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.042Z\",\"MediaKey\":\"NST123808469\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/1f68fe66-0826-43d0-997b-a4ddceb294ef.jpeg\",\"LongDescription\":\"Timeless character with modern functionality\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"ImageWidth\":1536,\"ImageHeight\":2048,\"ImageSizeDescription\":\"1536x2048\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.097Z\",\"MediaKey\":\"NST123808481\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/0ec2ceab-352c-4c66-b314-1988392f3850.jpeg\",\"LongDescription\":\"468 Warwick Neighborhood Eats\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":26,\"MediaObjectID\":\"NST26\",\"ImageWidth\":2080,\"ImageHeight\":1602,\"ImageSizeDescription\":\"2080x1602\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.175Z\",\"MediaKey\":\"NST123808491\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/87c0dc30-aff8-4fa3-b539-c808c8a25826.jpeg\",\"LongDescription\":\"Fenced Yard. Rare to have a flat usable lot\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":23,\"MediaObjectID\":\"NST23\",\"ImageWidth\":2080,\"ImageHeight\":1388,\"ImageSizeDescription\":\"2080x1388\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.105Z\",\"MediaKey\":\"NST123808488\"},{\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7940682/a3de9229-732b-4f44-a206-2ed4829a4abd.jpeg\",\"LongDescription\":\"Home is very conveniently located to most major services.\",\"ResourceRecordKey\":\"NST7940682\",\"Order\":25,\"MediaObjectID\":\"NST25\",\"ImageWidth\":2080,\"ImageHeight\":1602,\"ImageSizeDescription\":\"2080x1602\",\"MediaModificationTimestamp\":\"2026-07-24T21:27:08.117Z\",\"MediaKey\":\"NST123808490\"}]","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7940682/c6556763-5cab-46a1-aa2a-c5a55c287853.jpeg","Media__LongDescription":"Because one look isn't enough","Media__ResourceRecordKey":"NST7940682","Media__Order":"1","Media__MediaObjectID":"NST1","Media__ImageWidth":"2080","Media__ImageHeight":"1309","Media__ImageSizeDescription":"2080x1309","Media__MediaModificationTimestamp":"7/24/2026 9:27:08 PM","Media__MediaKey":"NST123808466","Rooms":"[{\"RoomType\":\"Three Season Porch\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"8x8\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494505\"},{\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"16x11\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494496\"},{\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"26x19\",\"RoomLevel\":\"Lower\",\"RoomKey\":\"NST116494497\"},{\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"12x11\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494499\"},{\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"12x11\",\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116494502\"},{\"RoomType\":\"Foyer\",\"NST_RoomSortOrder\":12,\"RoomDimensions\":\"12x4\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494506\"},{\"RoomType\":\"Informal Dining Room\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"13x12\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494503\"},{\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"15x13\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494498\"},{\"RoomType\":\"Laundry\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"12x11\",\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116494504\"},{\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"15x14\",\"RoomLevel\":\"Main\",\"RoomKey\":\"NST116494495\"},{\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"14x12\",\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116494500\"},{\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"13x11\",\"RoomLevel\":\"Upper\",\"RoomKey\":\"NST116494501\"}]","Rooms__RoomType":"Three Season Porch","Rooms__NST_RoomSortOrder":"11","Rooms__RoomDimensions":"8x8","Rooms__RoomLevel":"Main","Rooms__RoomKey":"NST116494505","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"Because one look isn't enough\"},{\"Order\":2,\"Remarks\":\"Welcome Home to your Urban Farmhouse\"},{\"Order\":3,\"Remarks\":\"Inviting 3 season covered porch\"},{\"Order\":4,\"Remarks\":\"Main Floor Bedroom, Office/Den. Many Possibilities for this main floor room.\"},{\"Order\":5,\"Remarks\":\"Cozy sitting area for morning coffee or quiet time.\"},{\"Order\":6,\"Remarks\":\"Thoughtfully designed Gourmet Kitchen is the Focal point of the main floor open-concept layout. This kitchen sure has loads of countertop space!\"},{\"Order\":7,\"Remarks\":\"Pantry cabinet provides for plenty of storage. Accent shelves, quartz countertops, and tile backsplash completes the upgraded look of this spacious kitchen\"},{\"Order\":8,\"Remarks\":\"Kitchen open to the Formal Dining Room or a Sun Room if you wish\"},{\"Order\":9,\"Remarks\":\"Open Concept Perfect for entertaining and seamless flowing floor plan\"},{\"Order\":10,\"Remarks\":\"Sunfilled Dining Nook\"},{\"Order\":11,\"Remarks\":\"Many memories will be made here\"},{\"Order\":12,\"Remarks\":\"The perfect picturesque setup for the holidays\"},{\"Order\":13,\"Remarks\":\"Absolutely dreamy Primary Bedroom with Ensuite\"},{\"Order\":14,\"Remarks\":\"Something out of a Luxury Magazine but it's actually in your very own Ensuite\"},{\"Order\":15,\"Remarks\":\"Big enough of for 2 is this 4x4 massive shower with accent tile floor & surround\"},{\"Order\":16,\"Remarks\":\"Timeless character with modern functionality\"},{\"Order\":17,\"Remarks\":\"No one has to fight over which bedroom is better because they are both mirror images of each other\"},{\"Order\":18,\"Remarks\":\"Spacious Bedrooms! No one has to fight over which bedroom is better because they are both mirror images of each other\"},{\"Order\":19,\"Remarks\":\"Double vanities with patterned tile floor and bathtub with tile surround to the ceiling\"},{\"Order\":20,\"Remarks\":\"Full Size Hall Bath with Double Vanities and Unique Patterned Tile\"},{\"Order\":21,\"Remarks\":\"It's a massive family room\"},{\"Order\":22,\"Remarks\":\"Basement Family room has multitude of uses. Kids room, man cave, family room, exercise room, etc.\"},{\"Order\":23,\"Remarks\":\"Fenced Yard. Rare to have a flat usable lot\"},{\"Order\":24,\"Remarks\":\"Over sized 2 car Garage\"},{\"Order\":25,\"Remarks\":\"Home is very conveniently located to most major services.\"},{\"Order\":26,\"Remarks\":\"468 Warwick Neighborhood Eats\"},{\"Order\":27,\"Remarks\":\"Located near a variety of outdoor activities - minnehaha park, golf course, trails etc.\"}]","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,26,27","CustomVTourURL":""}