Skip main navigation
Active
  • Price increase: $50K (7/2)
    $929,900

    5817 151st Ln NW, Ramsey, MN 55303

    4beds
    4,693sqft
    : 
    $5,700/mo
    Get pre-qualified
    Single Family
    Built in 2026
    0.44 Acres Lot
    $925,100 Zestimate®
    $198/sqft
    $-- HOA

    What's special

    Elevate marvin patio doorsLvp flooringBeautiful walk up barAccented enamel trimCustom knotty alder cabinetsDouble-hung essential marvin windowsOversized refrigerator
    Grand Opening! Model home now available for tours! Welcome to this stunning two-story home offering refined craftsmanship, modern design, and thoughtful functionality throughout. With 3,132 finished square feet —including 1,864 sq ft on the main level and 1,268 sq ft upstairs —this home blends open-concept living with custom details that elevate every space. Total potential finished square feet exceeds 4200 sq ft with the walkout basement. Design & Appeal: Built with enduring quality, this home features vinyl and metal siding with stone accents , a concrete front porch , and a fully insulated and sheet rocked 4-car garage with three openers. This one sets it apart from other designs with the Bonus room off of the garage which can have multiple usages from a sports room, entertainment room, workshop or a place for your classic or sports car. This area can also be designed for a Generational Home concept for families that want space off the main level for extended family member(s) to reside with peace and dignity. Mechanics: Enjoy premium efficiency with a Luxaire 97% two-stage furnace , Luxaire 13.4 SEER air conditioner , Honeywell setback thermostat , and Broan HRV air exchanger . The home also includes great window sizes maximizing your views over your deep lot. Upgraded windows are the double-hung Essential Marvin windows and Elevate Marvin patio doors for lasting performance and beauty. Delta faucets throughout the home. Main Level: Step inside to 9-foot ceilings , high boxed ceiling in entryway, LVP flooring and accented enamel trim. This floorplan is an inviting layout perfect for entertaining and everyday living and includes a comfortable main level office with carpet. The gourmet kitchen features beautiful custom knotty alder cabinets, granite countertops , a large pantry with more built-in custom cabinets and granite countertops, and an upright freezer for convenience and practicality. The Kitchen is customized with an oversized refrigerator and coffee bar. The great room is anchored by a 42" gas fireplace with stone surround, custom mantle, and built-in base cabinets. But the smaller and comfortable hearth room offers a secondary 36" gas fireplace —ideal for just relaxing and chilling with a morning coffee or an evening glass of wine or cold beverage in the evening with the convenience of this beautiful walk up Bar. Upper Level: Upstairs, find comfort and elegance in the master suite , featuring a high boxed ceiling , and a master bathroom with ceramic tile flooring , dual sinks , ceramic shower with glass door and a free-standing soaking tub. The laundry room includes a granite countertop for added luxury, while the upstairs landing offers openness and space as you access the upstairs bathroom and 2 bedrooms. 4 Bedroom options are available.
    83 days
    |
    249
    |
    6
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Richard W Bandimere 612-978-2989,

    Keller Williams Classic Realty

    Source: NorthstarMLS as distributed by MLS GRID,MLS#: 7058361MLS Logo

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 4
      • Bathrooms: 4
      • Full bathrooms: 2
      • 3/4 bathrooms: 1
      • 1/2 bathrooms: 1
      Bedroom
      • Level: Upper
      • Area: 224 Square Feet
      • Dimensions: 16 x 14
      Bedroom 2
      • Level: Upper
      • Area: 154 Square Feet
      • Dimensions: 14 x 11
      Bedroom 3
      • Level: Upper
      • Area: 154 Square Feet
      • Dimensions: 14 x 11
      Bedroom 4
      • Level: Lower
      Dining room
      • Level: Main
      • Area: 130 Square Feet
      • Dimensions: 13 x 10
      Great room
      • Level: Main
      • Area: 320 Square Feet
      • Dimensions: 20 x 16
      Hearth room
      • Level: Main
      • Area: 180 Square Feet
      • Dimensions: 15 x 12
      Kitchen
      • Level: Main
      • Area: 208 Square Feet
      • Dimensions: 16 x 13
      Laundry
      • Level: Upper
      • Area: 78 Square Feet
      • Dimensions: 13 x 6
      Mud room
      • Level: Main
      • Area: 90 Square Feet
      • Dimensions: 15 x 6
      Other
      • Level: Main
      • Area: 50 Square Feet
      • Dimensions: 10 x 5
      Workshop
      • Level: Main
      • Area: 300 Square Feet
      • Dimensions: 15 x 20
      Heating
      • Forced Air
      Cooling
      • Central Air
      Appliances
      • Included: Air-To-Air Exchanger, Dishwasher, Microwave, Range, Refrigerator
      • Laundry: Electric Dryer Hookup, Laundry Room, Sink, Upper Level, Washer Hookup
      Features
      • Basement: Block
      • Number of fireplaces: 2
      • Fireplace features: Electric, Gas
      Interior area
      • Total structure area: 4,756
      • Total interior livable area: 4,693 sqft
      • Finished area above ground: 3,488
      • Finished area below ground: 1,205

      Property

      Parking
      • Total spaces: 4
      • Parking features: Attached, Asphalt, Garage Door Opener, Heated Garage, Insulated Garage
      • Attached garage spaces: 4
      • Has uncovered spaces: Yes
      Accessibility
      • Accessibility features: None
      Features
      • Levels: Two
      • Stories: 2
      • Pool features: None
      • Fencing: None
      Lot
      • Size: 0.44 Acres
      • Dimensions: 95*298*44*271
      • Features: Tree Coverage - Light
      Details
      • Foundation area: 1524
      • Parcel number: TBD
      • Zoning description: Residential-Single Family

      Construction

      Type & style
      • Home type: SingleFamily
      • Property subtype: Single Family
      Materials
      • Frame
      • Roof: Age 8 Years or Less,Asphalt
      Condition
      • New construction: Yes
      • Year built: 2026
      Details
      • Builder name: BROOKSIDE CONSTRUCTION INC

      Utilities & green energy

      • Electric: Circuit Breakers
      • Gas: Natural Gas
      • Sewer: City Sewer/Connected
      • Water: City Water/Connected

      Community & HOA

      Community
      • Subdivision: Brookside Terrace
      HOA
      • Has HOA: No
      Location
      • Region: Ramsey

      Financial & listing details

      • Price per square foot: $198/sqft
      • Date on market: 5/1/2026
      • Road surface type: Paved

        Estimated market value

        $925,100

        $879,000 - $971,000

        $4,959/mo

        Price history

        DateEventPrice
        7/2/2026Price change$929,900+5.7%$198/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7058361 Report a problem
        5/1/2026Listed for sale$879,900+4.8%$187/sqft
        Source: NorthstarMLS as distributed by MLS GRID #7058361 Report a problem
        4/20/2026Listing removed$839,900$179/sqft
        Source: NorthstarMLS as distributed by MLS GRID #6803341 Report a problem
        10/15/2025Listed for sale$839,900$179/sqft
        Source: NorthstarMLS as distributed by MLS GRID #6803341 Report a problem

        Public tax history

        Tax history is unavailable.

        Monthly payment

        Est. payment

        Payment breakdown

        Explore the cost of this home by adjusting the details. Changes won't be saved.
        All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
        HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
        Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
        See how much you could borrow to make a competitive offer.

        Climate risks

        Neighborhood: 55303

        Getting around

        12 / 100
        Car-Dependent
        50 / 100
        Bikeable

        Nearby schools

        GreatSchools rating

        A local agent can set up tours, give advice and negotiate with sellers.

        Browse local experts

        Similar homes