Agent profile image in chat bubble
Agent profile image in chat header

Hatch Brokered by Real

| Hatch Brokered by Real | Real Brokerage LLC | PLACE

Agent profile image in message

By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from , its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
main property photo 0
main property photo 1
main property photo 2
main property photo 3
main property photo 4
main property photo 5
main property photo 6
main property photo 7
main property photo 8
main property photo 9
main property photo 10
main property photo 11
main property photo 12
main property photo 13
main property photo 14
main property photo 15
main property photo 16
main property photo 17
main property photo 18
main property photo 19
main property photo 20
main property photo 21
main property photo 22
main property photo 23
main property photo 24
main property photo 25
main property photo 26
main property photo 27
main property photo 28
main property photo 29
main property photo 30
main property photo 31
main property photo 32
main property photo 33
main property photo 34
main property photo 35
main property photo 36
main property photo 37
main property photo 38
main property photo 39
main property photo 40
main property photo 41
main property photo 42
main property photo 43
main property photo 44
main property photo 45
main property photo 46
View All (47)
property photo 1
property photo 2
property photo 3
2457 Dianna Ln , Little Canada, MN 55117
$1,500,000
Est. Payment: $3,333.33/mo
5 Bed
4 Bath
4308 Sqft
0.53 Acres
Status: active | Days on site: 9
Get Pre-Qualified
20530 - 502046527,505009886
By proceeding and clicking the sign up button, you consent to receive calls and texts (SMS/MMS) including marketing and promotional communications, from Hatch Brokered by Real, its affiliates, and agents or vendors acting on their behalf. These communications may be delivered using an automatic telephone dialing system or by using an artificial or prerecorded voice. Message and data rates may apply. To opt out of text messages, reply STOP. Your consent is not required as a condition of any purchase. By continuing, you also agree to our Terms of Use and Privacy Policy.
Agent profile image
Hatch Brokered by Real
View agent profile
Email
Call

House Description

Tucked at the end of a quiet cul-de-sac, this architecturally designed lakefront property brings a private, resort-style feel right in the heart of the metro. From the moment you walk in, you’re hit with natural light, soaring 20+ ft ceilings, and uninterrupted views of the pool and lake from nearly every room. This home was built to entertain. Open-concept layout, multiple gathering spaces, and seamless indoor-outdoor flow make it ideal for hosting or just enjoying the space year-round. The kitchen is dialed in with a massive island, breakfast bar, recycled glass countertops, custom cabinetry, high-end appliances, and heated tile and bamboo floors—everything you’d expect at this level. Upstairs, the primary suite feels like a private retreat with heated floors, a jetted tub, double vanity, and a walk-in shower. The lower level is set up perfectly with a large family room, wet bar, and a sun-filled bonus space that walks straight out to the pool—this is where summer hits different. You’ve also got a spacious mudroom, dedicated home office, and a 4-stall insulated/heated garage with floor drains and two EV chargers. Solar panels already in place for added efficiency. If you’ve been waiting for something different—this is it. Lake life, pool, privacy, and location all in one.
Show more

Highlights

Listed by Jonathan Soto , 651-592-4303 and Mark P. Abdel , 651-283-8251 RE/MAX Results , 320-251-2200. Minneapolis/St. Paul and St. Cloud - Northstar MLS

Property Type

Residential
Lot/Acreage
0.53

Year Built

1978

County

Ramsey

 Neighborhood

Gervais Shores Add

 School District

Roseville

Listing ID

7158606

Questions about this listing?

Contact Agent

Interior Features

Bedrooms and Bathrooms
  • ▪ Bedrooms:5
  • ▪ Bathrooms:4
  • ▪ Full Bathrooms:2
  • ▪ 3/4 Bathrooms:1
  • ▪ 1/2 Bathrooms:1
Appliances:Central Vacuum, Dishwasher, Disposal, Double Oven, Dryer, Freezer, Gas Water Heater, Microwave, Range, Refrigerator, Wall Oven, Washer, Wine Cooler
Air Cond:Geothermal
Fireplaces:Gas,Living Room,Stone
Above Ground Sq Ft:2855
Below Ground Sq Ft:1453
Basement:Daylight/Lookout Windows,Egress Window(s),Finished,Full,Storage Space,Walkout
Other:
  • ▪ Additional:Ceiling Fan(s), Deck, Dock, Exercise Room, Hardwood Floors, Intercom System, Kitchen Center Island, Kitchen Window, Primary Bedroom Walk-In Closet, Natural Woodwork, Patio, In-Ground Sprinkler, Sun Room, Tile Floors, Vaulted Ceiling(s), Wet Bar, Walk-In Closet, 3/4 Basement, Basement, Bathroom Ensuite, Full Primary, Private Primary, Main Floor 1/2 Bath, Separate Tub & Shower, Upper Level Full Bath, Walk-In Shower Stall, Breakfast Bar, Breakfast Area, Eat In Kitchen, Separate/Formal Dining Room, 3 BR on One Level, Main Floor Laundry
Water:City Water/Connected

Exterior Features

Lot:Dock,Lake Front,Lake View,Partial,Waterfront
Lot Dimensions:112x163
Zoning:Residential-Single Family
Roof:Age 8 Years or Less,Asphalt
Sewer:City Sewer/Connected,City Sewer - In Street
Parking Features:Attached Garage,Concrete,Electric,Floor Drain,Heated Garage,Insulated Garage,Storage,Tandem Garage

Open House

Upcoming Open Houses
Friday 4:00 pm - 6:00 pm Oct 23
Principal Interest
$3,333
Taxes
$1,745

Home Price

$1,500,000

Loan Details

30 yrs
0%

Down Payment

20%
$300,000
All calculations are estimates and provided by Blueroof360. Today’s Rates provided by Blueroof360. Information and interactive calculators are made available to you only as self-help tools for your independent use and are not intended to provide investment or tax advice. We cannot and do not guarantee their applicability or accuracy in regards to your individual circumstances. All examples are hypothetical and are for illustrative purposes. We encourage you to seek personalized advice from qualified professionals regarding all personal finance issues.
Monthly Price:
$3,333.33

Principal

Taxes

Principal Taxes HOA Total
Monthly $3,333.33 $1,745.33 $0.00 $5,078.67
Yearly $40,000.00 $20,944.00 $0.00 $60,944.00
Total $1,200,000.00 $628,320.00 $0.00 $1,828,320.00
Lender profile image
Will Provost
Loan Originator
Email
Call
Visit
GET PRE-QUALIFIED

Never Miss a Property

Be the first to know when a property hits the market.

Current Listings

Last 30 Days
N/A
Oct 2026

Average Price

All Price Ranges
N/A
Oct 2026

Average Days on Market

All Price Ranges
N/A
Oct 2026
Market insight data is pulled from the same city as the listing being viewed (Little Canada, MN).

The schools listed are within a 2-mile radius of the property; however, attendance is not guaranteed. Please contact the local school district to confirm zoning and enrollment options.

The data relating to real estate for sale on this web 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 Hatch Brokered by Real | Real Brokerage LLC | PLACE are marked with the Broker Reciprocity logo or the Broker Reciprocity thumbnail logo and detailed information about them includes the name of the listing brokers.
Digital Millennium Copyright Act (DMCA) Notice The Digital Millennium Copyright Act of 1998, 17 U.S.C. § 512 (the "DMCA"), provides recourse for copyright owners who believe that material appearing on the Internet infringes their rights under U.S. copyright law. If you believe in good faith that any content or material made available in connection with our website or services infringes your copyright, you (or your agent) may send us a notice requesting that the content or material be removed, or access to it blocked. Notices and counter-notices should be sent in writing by mail to Michael Bisping, Director, Customer Relations, Regional Multiple Listing Service of Minnesota, Inc, 2550 University Avenue West, Suite 259S Saint Paul, MN 55114 or by email to mbisping@northstarmls.com. Questions can be directed by phone to 651-251-3200.The DMCA requires that your notice of alleged copyright infringement include the following information: (1) description of the copyrighted work that is the subject of claimed infringement; (2) description of the alleged infringing content and information sufficient to permit us to locate the content; (3) contact information for you, including your address, telephone number and e-mail address; (4) a statement by you that you have a good faith belief that the content in the manner complained of is not authorized by the copyright owner, or its agent, or by the operation of any law; (5) a statement by you, signed under penalty of perjury, that the information in the notification is accurate and that you have the authority to enforce the copyrights that are claimed to be infringed; and (6) a physical or electronic signature of the copyright owner or a person authorized to act on the copyright owner's behalf. Failure to include all of the above information may result in the delay of the processing of your complaint.
Information Deemed Reliable but not guaranteed.
Copyright 2026 Regional Multiple Listing Service of Minnesota, Inc. All rights reserved.
Broker Reciprocity

IDX service by Blueroof 360

Data last updated: 2026-10-22T14:02:13.000Z

© 2026 Minneapolis/St. Paul and St. Cloud - Northstar MLS