« go back
    • Home
    • Our Agents
    • Our Listings
    • Testimonials
  • Estimate Request
  • Map Search
    • Daily Hotlist
    • Advanced Search
    • Featured Listings
    • Open Houses
    • Our Listings
    • Lost Lake Lodge
    • Good Ol' Days Resort
  • Contact Us
    • Client Login
    • Saved Listings

MLS# NST7135292 - 2804 Churchill Street Roseville, MN 55113

Neighborhoods

Opendoor Brokerage, LLC 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. Lakeshore Properties, LLC is not a multiple Listing Service (MLS), nor does it offer MLS access. This website is a service of Lakeshore Properties, LLC, a broker Participant of the Regional Multiple Listing Service of Minnesota, Inc.

{"Id":606186,"ORGTABLE":"RAW_Property","MLSCLASS":"RES","MLSNUMBER":"NST7135292","MLSAGENTID":"NST798549702","MLSCOAGENTID":"NST506008353","MLSOFFICEID":"NST26320","ADDRESS":"2804 Churchill Street","ACRES":0.241,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Unfinished","BATHSTOTAL":1.0,"BEDROOMS":3.0,"CITY":"Roseville","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":355000.0,"LASTPRICEDATE":"2026-08-28T20:21:51.3","LATITUDE":45.025621,"LENDEROWNED":"No","LISTDATE":"2026-08-28T05:00:00","LISTPRICE":355000.0,"LIVINGAREA":1453.0,"LONGITUDE":-93.145107,"MODIFICATIONTIMESTAMP":"2026-08-29T10:10:13.903","OFFICE_OFFICENAME":"Opendoor Brokerage, LLC","PHOTOCOUNT":20,"POSTALCODE":"55113","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","ROADBETWEENWATERFRONTANDHOMEYN":false,"SCHOOLDISTRICTNUMBER":"623-Roseville","SCHOOLDISTRICTPHONE":"6516351600","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-08-28T20:21:51.3","LASTSTATUS":"Active","STREETNAME":"Churchill","STREETNUMBER":"2804","STREETSUFFIX":"Street","STYLE":"Single Family","TRANSACTIONTYPE":"For Sale","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":1952,"ZONING":"Residential-Single Family","HASOPENHOUSE":true,"PHOTOTIMESTAMP":"2026-08-28T20:53:08.217","PHOTOREMARKS":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"listing_1.jpg\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"listing_3.jpg\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"listing_16.jpg\"},{\"Order\":18,\"Remarks\":\"listing_17.jpg\"},{\"Order\":19,\"Remarks\":\"listing_18.jpg\"},{\"Order\":20,\"Remarks\":\"listing_19.jpg\"}]","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","SOURCE":"MG_NST"}
{"ListingKey":"NST7958948","NST_AboveGradeSqFtTotal":"1053","AboveGradeFinishedArea":"1053","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","LivingAreaUnits":"Square Feet","NST_AssessmentPending":"Unknown","AssociationYN":"False","AssociationFee":"0","Basement":"Unfinished","BasementYN":"True","BathroomsFull":"1","BathroomsHalf":"0","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"0","BathroomsTotalInteger":"1","BedroomsTotal":"3","NST_BelowGradeSqFtTotal":"400","BelowGradeFinishedArea":"400","CumulativeDaysOnMarket":"0","CarportSpaces":"0","City":"Roseville","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DPResource":"Yes","Directions":"Head east on County Rd C2.\nTurn right on Churchill St.\nProperty is on the left.","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-08-28T20:36:07.349Z","DaysOnMarket":"0","ExteriorFeatures":"Brick Veneer","FireplaceYN":"False","FireplacesTotal":"0","FoundationArea":"1053","FoundationDetails":"Other","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","NST_GarageSquareFeet":"400","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"Roseville","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"45.025621","NST_LenderOwned":"No","Levels":"One","ListPrice":"355000","ListingContractDate":"2026-08-28T05:00:00Z","ListingId":"NST7135292","LivingArea":"1453","Longitude":"-93.145107","LotSizeArea":"0.241","LotSizeDimensions":"79 Feet x 133 Feet","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1053","NST_ManufacturedHome":"N","OriginalEntryTimestamp":"2026-08-28T13:33:07Z","ParcelNumber":"022923320075","ParkingFeatures":"Attached Garage","PhotosCount":"20","PhotosChangeTimestamp":"2026-08-28T20:53:08.217Z","PostalCity":"Roseville","PostalCode":"55113","NST_PotentialShortSale":"No","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential","PublicSurveyRange":"23","PublicSurveySection":"02","PublicSurveyTownship":"29","NST_SchoolDistrictFullName":"623 - Roseville","NST_SchoolDistrictNumber":"623","NST_SchoolDistrictPhone":"6516351600","Sewer":"City Sewer/Connected","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Churchill","StreetNumber":"2804","StreetNumberNumeric":"2804","StreetSuffix":"Street","SubdivisionName":"Roseville Heights","TaxAnnualAmount":"4760","NST_TaxWithAssessments":"4760","TaxYear":"2026","NST_TotalArea":"1453","BuildingAreaTotal":"1453","Township":"Roseville","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"1952","ZoningDescription":"Residential-Single Family","CoListAgentKey":"NST97067","CoListAgentMlsId":"NST506008353","CoListOfficeName":"Opendoor Brokerage, LLC","ListAgentKey":"NST225984","ListAgentMlsId":"NST798549702","ListOfficeMlsId":"NST26320","ListOfficeName":"Opendoor Brokerage, LLC","ListOfficeKey":"NST26320","ModificationTimestamp":"2026-08-29T10:10:13.903Z","OriginatingSystemName":"northstar","Media":"[{\"ResourceRecordKey\":\"NST7958948\",\"Order\":10,\"MediaObjectID\":\"NST10\",\"LongDescription\":\"listing_9.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/e8823f74-3e82-48f0-945b-30b731e300a4.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.696Z\",\"MediaKey\":\"NST124547200\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":17,\"MediaObjectID\":\"NST17\",\"LongDescription\":\"listing_16.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/7ce03be8-88df-47a1-b0d2-c0ffd0761c4d.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.7Z\",\"MediaKey\":\"NST124547193\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":11,\"MediaObjectID\":\"NST11\",\"LongDescription\":\"listing_10.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/313aff65-c879-48d7-8b07-0aa5ac2a703f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.67Z\",\"MediaKey\":\"NST124547199\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":8,\"MediaObjectID\":\"NST8\",\"LongDescription\":\"listing_7.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/a5f7d408-21fe-4250-aae2-5bc6f3310cbd.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.69Z\",\"MediaKey\":\"NST124547202\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":16,\"MediaObjectID\":\"NST16\",\"LongDescription\":\"listing_15.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/e89644f4-a367-416b-9e4a-173055ea5d63.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.653Z\",\"MediaKey\":\"NST124547194\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":4,\"MediaObjectID\":\"NST4\",\"LongDescription\":\"listing_3.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/2e3c9dbb-4bfd-488c-b16a-25826ed16cad.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.67Z\",\"MediaKey\":\"NST124547206\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":7,\"MediaObjectID\":\"NST7\",\"LongDescription\":\"listing_6.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/1dd58d53-87f4-47f9-92e5-6e79b0a10d19.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.697Z\",\"MediaKey\":\"NST124547203\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":15,\"MediaObjectID\":\"NST15\",\"LongDescription\":\"listing_14.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/a9a24775-8e5a-43d5-8542-a0efa1980e82.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.663Z\",\"MediaKey\":\"NST124547195\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":18,\"MediaObjectID\":\"NST18\",\"LongDescription\":\"listing_17.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/6876ca03-d775-46e5-acd4-e81ce693d16f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.655Z\",\"MediaKey\":\"NST124547192\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":5,\"MediaObjectID\":\"NST5\",\"LongDescription\":\"listing_4.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/b9af30c0-102f-4fb2-9b74-517e7a348486.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.681Z\",\"MediaKey\":\"NST124547205\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":9,\"MediaObjectID\":\"NST9\",\"LongDescription\":\"listing_8.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/e44f5b6a-6960-4aa2-a34a-2d1090d2afd6.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.657Z\",\"MediaKey\":\"NST124547201\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":2,\"MediaObjectID\":\"NST2\",\"LongDescription\":\"listing_1.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/97f8ca61-0a99-4800-b8bf-fde9fe6b5325.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.683Z\",\"MediaKey\":\"NST124547208\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":6,\"MediaObjectID\":\"NST6\",\"LongDescription\":\"listing_5.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/483db50b-db87-4954-9483-06ea436d156b.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.656Z\",\"MediaKey\":\"NST124547204\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":14,\"MediaObjectID\":\"NST14\",\"LongDescription\":\"listing_13.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/8ef9f2bf-104c-4d1c-a1e3-c9555f47ff34.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.652Z\",\"MediaKey\":\"NST124547196\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":12,\"MediaObjectID\":\"NST12\",\"LongDescription\":\"listing_11.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/28bba720-9546-40b5-86ff-c1c23ddf2542.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.67Z\",\"MediaKey\":\"NST124547198\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":3,\"MediaObjectID\":\"NST3\",\"LongDescription\":\"listing_2.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/b53f8428-86c9-4fb4-a7f8-c05e361a395f.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.693Z\",\"MediaKey\":\"NST124547207\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":19,\"MediaObjectID\":\"NST19\",\"LongDescription\":\"listing_18.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/0eca70cb-b544-4a55-b79e-6ffb48e0b067.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.775Z\",\"MediaKey\":\"NST124547191\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":13,\"MediaObjectID\":\"NST13\",\"LongDescription\":\"listing_12.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/f246d024-4995-4b85-aee5-720bffa962ea.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.7Z\",\"MediaKey\":\"NST124547197\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":1,\"MediaObjectID\":\"NST1\",\"LongDescription\":\"listing_0.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/82a10d4a-eb53-49df-9d49-e40944822fd5.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1559,\"ImageSizeDescription\":\"2080x1559\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.699Z\",\"MediaKey\":\"NST124547209\"},{\"ResourceRecordKey\":\"NST7958948\",\"Order\":20,\"MediaObjectID\":\"NST20\",\"LongDescription\":\"listing_19.jpg\",\"MediaURL\":\"https://s3.amazonaws.com/mlsgrid/images/NST7958948/6b6de4e1-d412-451f-a85c-c08bd2c03198.jpeg\",\"ImageWidth\":2080,\"ImageHeight\":1560,\"ImageSizeDescription\":\"2080x1560\",\"MediaModificationTimestamp\":\"2026-08-28T20:52:17.69Z\",\"MediaKey\":\"NST124547190\"}]","Media__ResourceRecordKey":"NST7958948","Media__Order":"10","Media__MediaObjectID":"NST10","Media__LongDescription":"listing_9.jpg","Media__MediaURL":"https://s3.amazonaws.com/mlsgrid/images/NST7958948/e8823f74-3e82-48f0-945b-30b731e300a4.jpeg","Media__ImageWidth":"2080","Media__ImageHeight":"1559","Media__ImageSizeDescription":"2080x1559","Media__MediaModificationTimestamp":"8/28/2026 8:52:17 PM","Media__MediaKey":"NST124547200","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"[{\"Order\":1,\"Remarks\":\"listing_0.jpg\"},{\"Order\":2,\"Remarks\":\"listing_1.jpg\"},{\"Order\":3,\"Remarks\":\"listing_2.jpg\"},{\"Order\":4,\"Remarks\":\"listing_3.jpg\"},{\"Order\":5,\"Remarks\":\"listing_4.jpg\"},{\"Order\":6,\"Remarks\":\"listing_5.jpg\"},{\"Order\":7,\"Remarks\":\"listing_6.jpg\"},{\"Order\":8,\"Remarks\":\"listing_7.jpg\"},{\"Order\":9,\"Remarks\":\"listing_8.jpg\"},{\"Order\":10,\"Remarks\":\"listing_9.jpg\"},{\"Order\":11,\"Remarks\":\"listing_10.jpg\"},{\"Order\":12,\"Remarks\":\"listing_11.jpg\"},{\"Order\":13,\"Remarks\":\"listing_12.jpg\"},{\"Order\":14,\"Remarks\":\"listing_13.jpg\"},{\"Order\":15,\"Remarks\":\"listing_14.jpg\"},{\"Order\":16,\"Remarks\":\"listing_15.jpg\"},{\"Order\":17,\"Remarks\":\"listing_16.jpg\"},{\"Order\":18,\"Remarks\":\"listing_17.jpg\"},{\"Order\":19,\"Remarks\":\"listing_18.jpg\"},{\"Order\":20,\"Remarks\":\"listing_19.jpg\"}]","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20","CustomVTourURL":""}
  • Phone
  • Email
©2026 Lakeshore Properties LLC, all rights reserved. · Privacy ·
Created with REC by Shawn Hyde.