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.
Active
$879,900
5817 151st Ln NW, Ramsey, MN 55303
3beds
3,132sqft
Single Family
Built in 2026
0.44 Acres Lot
$874,400 Zestimate®
$281/sqft
$-- HOA
What's special
- 33 days
- 301
- 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#: 7121894
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 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,400
- Total interior livable area: 3,132 sqft
- Finished area above ground: 3,132
- Finished area below ground: 0
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: $281/sqft
- Date on market: 8/7/2026
- Road surface type: Paved
Estimated market value
$874,400
$831,000 - $918,000
$3,971/mo
Price history
| Date | Event | Price |
|---|---|---|
| 8/7/2026 | Listed for sale | $879,900-5.4%$281/sqft |
Source: | ||
| 8/5/2026 | Listing removed | $929,900$297/sqft |
Source: | ||
| 7/2/2026 | Price change | $929,900+5.7%$297/sqft |
Source: | ||
| 5/1/2026 | Listed for sale | $879,900+4.8%$281/sqft |
Source: | ||
| 4/20/2026 | Listing removed | $839,900$268/sqft |
Source: | ||
| 10/15/2025 | Listed for sale | $839,900$268/sqft |
Source: | ||
Public tax history
Tax history is unavailable.
Monthly payment
Est. payment








