A TRADITION OF TRUST & SERVICE
$LABEL$
$CONTENT$
$LABEL$
$CONTENT$
Mortgage Calculator
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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, 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. Joy+Marci Realty Group is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Joy+Marci Realty Group, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.
Nearby Listings in 10 Miles
{"Id":561018,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7077486","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":749990.0,"LASTPRICEDATE":"2026-06-08T16:33:06.627","LATITUDE":44.92744996,"LENDEROWNED":"No","LISTDATE":"2026-05-20T05:00:00","LISTPRICE":735000.0,"LIVINGAREA":2610.0,"LONGITUDE":-93.16284112,"LOTDESCRIPTION":"Tree Coverage - Light","MODIFICATIONTIMESTAMP":"2026-06-14T22:43:07.665","NEIGHBORHOOD":"95","OFFICE_OFFICENAME":"ERA Prospera Real Estate","PHOTOCOUNT":3,"POSTALCODE":"55105","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"Tucked along one of Mac-Groveland’s most picturesque tree-lined streets, this exceptional St. Paul home captures the feeling buyers wait for; timeless charm, warmth, and elevated living from the moment you arrive. Sunlight fills beautifully curated spaces where classic character blends effortlessly with modern comfort. Imagine evenings entertaining friends and effortless walks to beloved cafes, restaurants, parks, and boutiques just steps away. The versatile main-level flex room offers endless possibilities as a guest suite, office, den or private retreat. Thoughtfully designed for both everyday living and memorable gatherings, every space feels inviting, refined, and timeless. Rarely does a home combine location, lifestyle, and emotional connection so effortlessly. This is more than a home. Now, your next chapter begins here. 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-05-22T05:05:09.48","LASTSTATUS":"Coming Soon","STREETNAME":"Warwick","STREETNUMBER":"468","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1922,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-06-14T22:43:07.665","PHOTOREMARKS":"[{\"Order\":1,\"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\":2,\"Remarks\":\"Welcome Home to your Urban Farmhouse\"},{\"Order\":12,\"Remarks\":\"Absolutely dreamy Primary Bedroom with Ensuite\"}]","PHOTOORDER":"1,2,12","SOURCE":"MG_NST"}
{"ListingKey":"NST7904678","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":"0","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-06-14T22:39:06.079Z","DaysOnMarket":"0","Electric":"Circuit Breakers","NST_ExpectedMarketDate":"2026-05-22","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":"735000","ListingContractDate":"2026-05-20T05:00:00Z","ListingId":"NST7077486","LivingArea":"2610","LockBoxType":"Combo","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-05-22T00:00:09Z","ParcelNumber":"102823230041","ParkingFeatures":"Detached Garage","PhotosCount":"3","PhotosChangeTimestamp":"2026-06-14T22:43:07.665Z","PostalCity":"Saint Paul","PostalCode":"55105","NST_PotentialShortSale":"No","NST_PowerCompanyName":"Xcel Energy","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicRemarks":"Tucked along one of Mac-Groveland’s most picturesque tree-lined streets, this exceptional St. Paul home captures the feeling buyers wait for; timeless charm, warmth, and elevated living from the moment you arrive. Sunlight fills beautifully curated spaces where classic character blends effortlessly with modern comfort. Imagine evenings entertaining friends and effortless walks to beloved cafes, restaurants, parks, and boutiques just steps away. The versatile main-level flex room offers endless possibilities as a guest suite, office, den or private retreat. Thoughtfully designed for both everyday living and memorable gatherings, every space feels inviting, refined, and timeless. Rarely does a home combine location, lifestyle, and emotional connection so effortlessly. This is more than a home. Now, your next chapter begins here. 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-06-14T22:43:07.665Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":1,\"MediaObjectID\":\"NST1\",\"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\":\"NST7904678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904678/958dde4f-d174-4fc4-a7c7-b48038d78bdb.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1226,\"ImageSizeDescription\":\"2080x1226\",\"MediaModificationTimestamp\":\"2026-06-14T22:37:04.566Z\",\"MediaKey\":\"NST122367705\"},{\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"Absolutely dreamy Primary Bedroom with Ensuite\",\"ResourceRecordKey\":\"NST7904678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904678/6999ab0b-5504-43a7-937c-3f78d2b59995.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1309,\"ImageSizeDescription\":\"2080x1309\",\"MediaModificationTimestamp\":\"2026-06-14T22:39:04.075Z\",\"MediaKey\":\"NST122354863\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"Welcome Home to your Urban Farmhouse\",\"ResourceRecordKey\":\"NST7904678\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7904678/36636f67-b839-4d08-928b-b7ef42410f1e.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1448,\"ImageSizeDescription\":\"2080x1448\",\"MediaModificationTimestamp\":\"2026-06-14T22:37:04.517Z\",\"MediaKey\":\"NST122354876\"}]","Media__Order":"1","Media__MediaObjectID":"NST1","Media__LongDescription":"Thoughtfully designed Gourmet Kitchen is the Focal point of the main floor open-concept layout. This kitchen sure has loads of countertop space!","Media__ResourceRecordKey":"NST7904678","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7904678/958dde4f-d174-4fc4-a7c7-b48038d78bdb.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1226","Media__ImageSizeDescription":"2080x1226","Media__MediaModificationTimestamp":"6/14/2026 10:37:04 PM","Media__MediaKey":"NST122367705","Rooms":"[{\"RoomLevel\":\"Main\",\"RoomType\":\"Three Season Porch\",\"NST_RoomSortOrder\":11,\"RoomKey\":\"NST116257026\",\"RoomDimensions\":\"8x8\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Dining Room\",\"NST_RoomSortOrder\":2,\"RoomKey\":\"NST116257017\",\"RoomDimensions\":\"16x11\"},{\"RoomLevel\":\"Lower\",\"RoomType\":\"Family Room\",\"NST_RoomSortOrder\":3,\"RoomKey\":\"NST116257018\",\"RoomDimensions\":\"26x19\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Bedroom\",\"NST_RoomSortOrder\":5,\"RoomKey\":\"NST116257020\",\"RoomDimensions\":\"12x11\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 4\",\"NST_RoomSortOrder\":8,\"RoomKey\":\"NST116257023\",\"RoomDimensions\":\"12x11\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Foyer\",\"NST_RoomSortOrder\":12,\"RoomKey\":\"NST116257027\",\"RoomDimensions\":\"12x4\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Informal Dining Room\",\"NST_RoomSortOrder\":9,\"RoomKey\":\"NST116257024\",\"RoomDimensions\":\"13x12\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Kitchen\",\"NST_RoomSortOrder\":4,\"RoomKey\":\"NST116257019\",\"RoomDimensions\":\"15x13\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Laundry\",\"NST_RoomSortOrder\":10,\"RoomKey\":\"NST116257025\",\"RoomDimensions\":\"12x11\"},{\"RoomLevel\":\"Main\",\"RoomType\":\"Living Room\",\"NST_RoomSortOrder\":1,\"RoomKey\":\"NST116257016\",\"RoomDimensions\":\"15x14\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 2\",\"NST_RoomSortOrder\":6,\"RoomKey\":\"NST116257021\",\"RoomDimensions\":\"14x12\"},{\"RoomLevel\":\"Upper\",\"RoomType\":\"Bedroom 3\",\"NST_RoomSortOrder\":7,\"RoomKey\":\"NST116257022\",\"RoomDimensions\":\"13x11\"}]","Rooms__RoomLevel":"Main","Rooms__RoomType":"Three Season Porch","Rooms__NST_RoomSortOrder":"11","Rooms__RoomKey":"NST116257026","Rooms__RoomDimensions":"8x8","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"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\":2,\"Remarks\":\"Welcome Home to your Urban Farmhouse\"},{\"Order\":12,\"Remarks\":\"Absolutely dreamy Primary Bedroom with Ensuite\"}]","PhotoOrder":"1,2,12","CustomVTourURL":""}