mike@minnesotarealestatesales.com
Phone: 218-821-4775
- About Team
- Leech Lake Homes
- Affordable Cabins
- Leech Lake Lots
- Federal Dam
- Walker MN
- Daily Hotsheets
- Cass County
- Hubbard County
- Itasca County
- Buyers
- Sellers
- Estimate Request
- Contact
- Leech Lake, DNR Lake Information
- Leech Lake Fishing Benefits
- Best Leech Fishing Resorts
Contact me here...
$STITLE$
$SCONTENT$
$LABEL$
$SCONTENT$
ERA Prospera Real Estate is the brokerage office representing the seller for this listing.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Copyright 2019, Regional Multiple Listing Service of Minnesota, Inc. all rights reserved. Information is deemed reliable but is not guaranteed.
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. Mike Stanwood Realtor/GRI is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Mike Stanwood Realtor/GRI, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"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":""}
$MLSDESCRIPTION$
468 Warwick Street Saint Paul, MN 55105
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$
$MLSDESCRIPTION$
468 Warwick Street Saint Paul, MN 55105
$LISTPRICE$$HOTDATA$
$STATUS$ | Contingent
$MLSNUMBERSHOW$
$SUMMARY1$
$FULLDATA$