{"Id":624216,"ORGTABLE":"RAW_Property","MLSCLASS":"RNT","MLSNUMBER":"NST7158528","MLSAGENTID":"NST502005176","MLSOFFICEID":"NST26401","ADDRESS":"540 Holly Avenue","ACRES":0.138,"AGENTOWNER":false,"AUCTIONYN":false,"BASEMENT":"Finished,Full","BATHSTOTAL":5.0,"BEDROOMS":5.0,"CITY":"Saint Paul","CONTINGENCY":"None","COUNTY":"Ramsey","DISTRIBUTEADDRESSTOINTERNET":true,"DISTRIBUTETOINTERNET":true,"FORECLOSURE":"No","LASTPRICE":6400.0,"LASTPRICEDATE":"2026-10-14T14:39:08.57","LATITUDE":44.943118,"LENDEROWNED":"No","LISTDATE":"2026-10-14T05:00:00","LISTPRICE":6400.0,"LIVINGAREA":3703.0,"LONGITUDE":-93.122878,"MODIFICATIONTIMESTAMP":"2026-10-14T14:39:08.57","NEIGHBORHOOD":"101","OFFICE_OFFICENAME":"Lakes Sotheby's International Realty","PHOTOCOUNT":15,"POSTALCODE":"55102","POTENTIALSHORTSALE":"No","PRESENTUSE":"Yearly","PUBLICREMARKS":"An outstanding opportunity to enjoy modern luxury living in the heart of Saint Paul's historic Cathedral Hill neighborhood. Custom built in 2022, this beautifully designed five-bedroom, five-bath residence offers over 3,700 finished square feet, combining sophisticated finishes, thoughtful design, and exceptional amenities in one of the city's most desirable neighborhoods.\nThe spacious, open main level is ideal for comfortable everyday living and entertaining. At its center is a stunning chef's kitchen featuring premium Thermador appliances, an oversized island, and a custom wine bar with storage for over 200 bottles. A distinctive three-sided fireplace adds warmth and character, while the inviting front porch provides another place to relax.\nThe upper level features four generously sized bedrooms, including a luxurious primary suite with heated bathroom floors, a soaking tub, separate shower, and private balcony. A second ensuite bedroom and two additional bedrooms offer flexibility for guests. The finished lower level provides additional living and entertaining space, including a recreation/media area, bar, fifth bedroom, and bathroom.\nOutdoor amenities include a private, fully fenced backyard, beautifully designed patio, and electronically controlled gate. Additional conveniences include whole-house electric shades, backup battery capability, and solar-ready infrastructure.\nLocated just moments from Cathedral Hill's celebrated restaurants, cafés, shopping, parks, and neighborhood attractions, this exceptional home offers a rare combination of modern construction, luxury amenities, and historic neighborhood charm. An ideal executive rental opportunity for those seeking an elevated living experience in Saint Paul.","ROADBETWEENWATERFRONTANDHOMEYN":false,"ROOF":"Asphalt","SCHOOLDISTRICTNUMBER":"625-St. Paul","SCHOOLDISTRICTPHONE":"6517678100","SEWER":"City Sewer/Connected","STATEORPROVINCE":"MN","STATUS":"Active","STATUSDATE":"2026-10-14T14:39:08.57","LASTSTATUS":"Active","STREETNAME":"Holly Avenue","STREETNUMBER":"540","STYLE":"Single Family","TRANSACTIONTYPE":"For Rent","WATER":"City Water/Connected","WATERFRONTPRESENT":false,"YEARBUILT":2021,"ZONING":"Residential-Single Family","HASOPENHOUSE":false,"PHOTOTIMESTAMP":"2026-10-14T14:39:08.57","PHOTOORDER":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","SOURCE":"MG_NST"}
{"ListingKey":"NST7981895","NST_AboveGradeSqFtTotal":"2657","AboveGradeFinishedArea":"2657","AccessibilityFeatures":"None","AdditionalParcelsYN":"False","NST_AgentOwner":"No","NST_AmenitiesUnit":"Balcony,Ceiling Fan(s),French Doors,Hardwood Floors,Kitchen Center Island,Kitchen Window,Primary Bedroom Walk-In Closet,Natural Woodwork,Patio,Paneled Doors,Tile Floors,Washer/Dryer Hookup,Wet Bar,Walk-In Closet","Appliances":"Dishwasher,Dryer,Microwave,Range,Refrigerator,Stainless Steel Appliances,Washer","NST_ApplicationFee":"75","LivingAreaUnits":"Square Feet","AssociationYN":"False","AssociationFee":"0","AvailabilityDate":"2026-11-01T05:00:00Z","NST_BackgroundCheckReq":"Y","Basement":"Finished,Full","BasementYN":"True","NST_BathDesc":"Double Sink,Full Primary,Private Primary,Separate Tub & Shower,Walk-In Shower Stall","BathroomsFull":"2","BathroomsHalf":"1","BathroomsOneQuarter":"0","BathroomsThreeQuarter":"2","BathroomsTotalInteger":"5","BedroomsTotal":"5","NST_BelowGradeSqFtTotal":"1046","BelowGradeFinishedArea":"1046","CumulativeDaysOnMarket":"0","City":"Saint Paul","NewConstructionYN":"False","Contingency":"None","Cooling":"Central Air","CountyOrParish":"Ramsey","NST_DiningRoomDescription":"Eat In Kitchen,Informal Dining Room,Kitchen/Dining Room,Separate/Formal Dining Room","Directions":"Dale Street to Holly, East to home","DocumentsCount":"1","DocumentsChangeTimestamp":"2026-10-14T14:39:08.57Z","DaysOnMarket":"0","Electric":"Circuit Breakers","ExteriorFeatures":"Cement Board","Fencing":"Full","FireplaceFeatures":"Gas,Living Room","FireplaceYN":"True","FireplacesTotal":"1","NST_ForSaleMLNumber":"7089127","FoundationArea":"1167","FoundationDetails":"Poured Concrete","NST_FractionalOwnershipYN":"No","NST_Fuel":"Natural Gas","Furnished":"Unfurnished","NST_GarageSquareFeet":"483","NST_GarageDimensions":"23 x 21","GarageSpaces":"2","Heating":"Forced Air","HighSchoolDistrict":"St. Paul","NST_ForeclosureStatus":"No","InternetAddressDisplayYN":"True","InternetAutomatedValuationDisplayYN":"False","InternetConsumerCommentYN":"False","InternetEntireListingDisplayYN":"True","LandLeaseYN":"False","Latitude":"44.943118","LaundryFeatures":"Laundry Room,Sink,Upper Level","NST_LeasePrice":"6400","NST_LenderOwned":"No","Levels":"Two","ListingContractDate":"2026-10-14T05:00:00Z","ListingId":"NST7158528","LivingArea":"3703","Longitude":"-93.122878","LotSizeArea":"0.138","LotSizeDimensions":"129 x 47","LotSizeUnits":"Acres","NST_MainLevelFinishedArea":"1100","NST_ManufacturedHome":"N","NST_NeighborhoodName":"Summit-University","NST_NeighborhoodNumber":"101","OriginalEntryTimestamp":"2026-10-14T09:38:49Z","OwnerPays":"None","ParcelNumber":"012823230257","ParkingFeatures":"Detached Garage","NST_PatioPorchType":"Front Porch,Patio,Porch","PhotosCount":"15","PhotosChangeTimestamp":"2026-10-14T14:39:08.57Z","PoolFeatures":"None","PostalCity":"Saint Paul","PostalCode":"55102","NST_PresentUse":"Yearly","PropertyAttachedYN":"False","PropertySubType":"Single Family","PropertyType":"Residential Lease","PublicRemarks":"An outstanding opportunity to enjoy modern luxury living in the heart of Saint Paul's historic Cathedral Hill neighborhood. Custom built in 2022, this beautifully designed five-bedroom, five-bath residence offers over 3,700 finished square feet, combining sophisticated finishes, thoughtful design, and exceptional amenities in one of the city's most desirable neighborhoods.\nThe spacious, open main level is ideal for comfortable everyday living and entertaining. At its center is a stunning chef's kitchen featuring premium Thermador appliances, an oversized island, and a custom wine bar with storage for over 200 bottles. A distinctive three-sided fireplace adds warmth and character, while the inviting front porch provides another place to relax.\nThe upper level features four generously sized bedrooms, including a luxurious primary suite with heated bathroom floors, a soaking tub, separate shower, and private balcony. A second ensuite bedroom and two additional bedrooms offer flexibility for guests. The finished lower level provides additional living and entertaining space, including a recreation/media area, bar, fifth bedroom, and bathroom.\nOutdoor amenities include a private, fully fenced backyard, beautifully designed patio, and electronically controlled gate. Additional conveniences include whole-house electric shades, backup battery capability, and solar-ready infrastructure.\nLocated just moments from Cathedral Hill's celebrated restaurants, cafés, shopping, parks, and neighborhood attractions, this exceptional home offers a rare combination of modern construction, luxury amenities, and historic neighborhood charm. An ideal executive rental opportunity for those seeking an elevated living experience in Saint Paul.","PublicSurveyRange":"23","PublicSurveySection":"01","PublicSurveyTownship":"28","NST_RentSpreeYN":"N","NST_RentalLicenseType":"Standard","NST_RentalLicenseYN":"Y","RoadFrontageType":"City Street,Curbs,Paved Streets,Sidewalks,Street Lights","RoadResponsibility":"Public Maintained Road","Roof":"Asphalt","NST_SchoolDistrictFullName":"625 - St. Paul","NST_SchoolDistrictNumber":"625","NST_SchoolDistrictPhone":"6517678100","NST_SecurityDeposit":"6400","Sewer":"City Sewer/Connected","NST_SmokingPermitted":"N","NST_SpecialSearch":"2nd Floor Laundry,3 BR on One Level,4 BR on One Level,Primary Bdr Suite","StandardStatus":"Active","StateOrProvince":"MN","StreetName":"Holly Avenue","StreetNumber":"540","StreetNumberNumeric":"540","SubdivisionName":"Auditors Sub 11","TenantPays":"All Utilities","NST_TotalArea":"3703","BuildingAreaTotal":"3703","Township":"Saint Paul","VideosCount":"0","WaterSource":"City Water/Connected","WaterfrontYN":"False","YearBuilt":"2021","ZoningDescription":"Residential-Single Family","ListAgentKey":"NST59537","ListAgentMlsId":"NST502005176","ListOfficeMlsId":"NST26401","ListOfficeName":"Lakes Sotheby's International Realty","ListOfficeKey":"NST26401","ModificationTimestamp":"2026-10-14T14:39:08.57Z","OriginatingSystemName":"northstar","Media":"[{\"Order\":12,\"MediaObjectID\":\"NST12\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/f023fab6-0e3d-44de-acf0-d2b063c874b3.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.545Z\",\"MediaKey\":\"NST125375045\"},{\"Order\":4,\"MediaObjectID\":\"NST4\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/b1073500-4bc0-4aab-90b6-cfa019a84916.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.563Z\",\"MediaKey\":\"NST125375034\"},{\"Order\":11,\"MediaObjectID\":\"NST11\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/68e6eb67-6351-4f8d-a693-b956293537fc.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.541Z\",\"MediaKey\":\"NST125375042\"},{\"Order\":5,\"MediaObjectID\":\"NST5\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/f0379cca-588a-4bef-869e-28411cfd4302.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.536Z\",\"MediaKey\":\"NST125375041\"},{\"Order\":8,\"MediaObjectID\":\"NST8\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/8c756273-6c2a-4986-be44-dfbf57e1a49a.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.544Z\",\"MediaKey\":\"NST125375038\"},{\"Order\":10,\"MediaObjectID\":\"NST10\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/31f27487-3754-4aec-97cc-a3ad8e8bbb40.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.543Z\",\"MediaKey\":\"NST125375043\"},{\"Order\":14,\"MediaObjectID\":\"NST14\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/b26db3fb-93a9-4f5f-bcca-006a4b2a31c4.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.558Z\",\"MediaKey\":\"NST125375047\"},{\"Order\":15,\"MediaObjectID\":\"NST15\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/8e7150e0-e50f-488b-9364-eb4dfe92103e.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.544Z\",\"MediaKey\":\"NST125375046\"},{\"Order\":1,\"MediaObjectID\":\"NST1\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/1022ae75-895a-4f3c-80b8-487eb83e12f4.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.548Z\",\"MediaKey\":\"NST125375037\"},{\"Order\":6,\"MediaObjectID\":\"NST6\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/eb5b77a6-1081-4f83-86f4-fc9f80470fba.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.545Z\",\"MediaKey\":\"NST125375040\"},{\"Order\":7,\"MediaObjectID\":\"NST7\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/9e4ee996-b955-4a46-96d2-ecb7ca87f961.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.538Z\",\"MediaKey\":\"NST125375039\"},{\"Order\":13,\"MediaObjectID\":\"NST13\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/3ce0bac0-811b-4f04-b574-521d585a7a2a.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.583Z\",\"MediaKey\":\"NST125375048\"},{\"Order\":3,\"MediaObjectID\":\"NST3\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/71d4e348-e844-4e03-acd6-ae9f66bce735.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.567Z\",\"MediaKey\":\"NST125375035\"},{\"Order\":9,\"MediaObjectID\":\"NST9\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/0e49b0e8-3f3e-488d-a173-0aa9f8ead42b.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.592Z\",\"MediaKey\":\"NST125375044\"},{\"Order\":2,\"MediaObjectID\":\"NST2\",\"ResourceRecordKey\":\"NST7981895\",\"MediaURL\":\"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/1fdc82c0-6c33-49b2-abb2-87cf811ec162.jpeg\",\"ImageWidth\":1920,\"ImageHeight\":1280,\"ImageSizeDescription\":\"1920x1280\",\"MediaModificationTimestamp\":\"2026-10-14T13:59:08.564Z\",\"MediaKey\":\"NST125375036\"}]","Media__Order":"12","Media__MediaObjectID":"NST12","Media__ResourceRecordKey":"NST7981895","Media__MediaURL":"https://media.mlsgrid.com/token=UDq8OQOnAQEz1MiJzy4YeW1wAbE_a5v8fre6FbbT7JE&expires=1791995164&id=5d6fc86794c5224544394849/images/NST7981895/f023fab6-0e3d-44de-acf0-d2b063c874b3.jpeg","Media__ImageWidth":"1920","Media__ImageHeight":"1280","Media__ImageSizeDescription":"1920x1280","Media__MediaModificationTimestamp":"10/14/2026 1:59:08 PM","Media__MediaKey":"NST125375045","Rooms":"[{\"RoomType\":\"Dining Room\",\"RoomKey\":\"NST116758217\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":2,\"RoomDimensions\":\"16x12\"},{\"RoomType\":\"Family Room\",\"RoomKey\":\"NST116758225\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":10,\"RoomDimensions\":\"20x17\"},{\"RoomType\":\"Bedroom 5\",\"RoomKey\":\"NST116758224\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":9,\"RoomDimensions\":\"12x11\"},{\"RoomType\":\"Bedroom\",\"RoomKey\":\"NST116758220\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":5,\"RoomDimensions\":\"18x15\"},{\"RoomType\":\"Bedroom 4\",\"RoomKey\":\"NST116758223\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":8,\"RoomDimensions\":\"14x13\"},{\"RoomType\":\"Kitchen\",\"RoomKey\":\"NST116758218\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":3,\"RoomDimensions\":\"20x15\"},{\"RoomType\":\"Living Room\",\"RoomKey\":\"NST116758216\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":1,\"RoomDimensions\":\"20x12\"},{\"RoomType\":\"Media Room\",\"RoomKey\":\"NST116758226\",\"RoomLevel\":\"Lower\",\"NST_RoomSortOrder\":11,\"RoomDimensions\":\"21x19\"},{\"RoomType\":\"Office\",\"RoomKey\":\"NST116758219\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":4,\"RoomDimensions\":\"16x16\"},{\"RoomType\":\"Patio\",\"RoomKey\":\"NST116758227\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":12,\"RoomDimensions\":\"20x16\"},{\"RoomType\":\"Porch\",\"RoomKey\":\"NST116758228\",\"RoomLevel\":\"Main\",\"NST_RoomSortOrder\":13,\"RoomDimensions\":\"18x07\"},{\"RoomType\":\"Bedroom 2\",\"RoomKey\":\"NST116758221\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":6,\"RoomDimensions\":\"13x12\"},{\"RoomType\":\"Bedroom 3\",\"RoomKey\":\"NST116758222\",\"RoomLevel\":\"Upper\",\"NST_RoomSortOrder\":7,\"RoomDimensions\":\"13x13\"}]","Rooms__RoomType":"Dining Room","Rooms__RoomKey":"NST116758217","Rooms__RoomLevel":"Main","Rooms__NST_RoomSortOrder":"2","Rooms__RoomDimensions":"16x12","MlgCanView":"True","MlgCanUse":"IDX","PhotoRemarks":"","PhotoOrder":"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15","CustomVTourURL":""}