Aarontrompeter.com Search Results

$150,000

This is a fixer-upper. It has been vacant a couple years and there are repairs to be made. It will not be possible to purchase it with anything other than cash or conventional financing.

3 Beds ⋅ 2 Baths ⋅ 7109861 MLS

This is a fixer-upper. It has been vacant a couple years and there are repairs to be made. It will not be possible to purchase it with anything other than cash or conventional financing.

504 Riverside Drive SE, Saint Cloud

Listing courtesy of A Trompeter Realty.

$1,599,000

THIS breathtaking lakeside sanctuary awaits at 9805 Sharon Place NW in Rice, Minnesota—an extraordinary retreat offering turnkey summer living and unmatched value. Originally built in 2010, this impressive 8,827 sq ft estate has been thoughtfully expanded and upgraded to meet the highest standards of luxury and comfort. An elegant addition in 2014 increased the living space, while a significant lot expansion in 2019 added 5,000 sq ft, including spacious garages and a beautifully remodeled lower level—perfect for entertaining or relaxing in style. This sanctuary retreat sits on 1.3 acres of pristine shoreline along Little Rock Lake, with 240 feet of accessible waterfront and a private dock already in place. Move-in ready for immediate enjoyment, this property comes complete with docks, lifts—so you can start living the lake lifestyle from day one. Skip the hassle and expense of assembling these features separately; this is a rare opportunity to own a fully equipped, luxury lakeside retreat where every detail has been thoughtfully curated for comfort, convenience, and unforgettable summer memories. You need to see this home now—homes like this, with every amenity and detail already in place, are truly rare. Schedule your private tour today and step into the ultimate Minnesota lake lifestyle! Enjoy the sparkling 20×40 in-ground pool, 5.5 -foot deep, salt-chlorine generator, and a premium 27-mil Latham liner (new in 2020)—perfect for relaxing or entertaining by the water. Inside, the gourmet kitchen and open living spaces are designed for both comfort and style, while the main-floor primary suite offers a spa-like retreat. The home’s ten garage stalls and workshop provide ample space for hobbies and storage, and the flexible studio apartment—with its own garage stall—offers options for guests, multi-generational living, or rental income. Sustainability and value shine with the owned solar system—solar rights transferred to new buyers—delivering energy savings and peace of mind for years to come. With in-floor radiant heating, two fireplaces, four laundry areas, and every amenity thoughtfully included, this property is the definition of turnkey luxury. Nearby, enjoy the natural beauty of Little Rock Lake, Benton Beach Park, and the Mississippi River Park. This is lakeside living at its finest—ready for you to move in and enjoy!

5 Beds ⋅ 5 Baths ⋅ 7099448 MLS

THIS breathtaking lakeside sanctuary awaits at 9805 Sharon Place NW in Rice, Minnesota—an extraordinary retreat offering turnkey summer living and unmatched value. Originally built in 2010, this impressive 8,827 sq ft estate has been thoughtfully expanded and upgraded to meet the highest standards of luxury and comfort. An elegant addition in 2014 increased the living space, while a significant lot expansion in 2019 added 5,000 sq ft, including spacious garages and a beautifully remodeled lower level—perfect for entertaining or relaxing in style. This sanctuary retreat sits on 1.3 acres of pristine shoreline along Little Rock Lake, with 240 feet of accessible waterfront and a private dock already in place. Move-in ready for immediate enjoyment, this property comes complete with docks, lifts—so you can start living the lake lifestyle from day one. Skip the hassle and expense of assembling these features separately; this is a rare opportunity to own a fully equipped, luxury lakeside retreat where every detail has been thoughtfully curated for comfort, convenience, and unforgettable summer memories. You need to see this home now—homes like this, with every amenity and detail already in place, are truly rare. Schedule your private tour today and step into the ultimate Minnesota lake lifestyle! Enjoy the sparkling 20×40 in-ground pool, 5.5 -foot deep, salt-chlorine generator, and a premium 27-mil Latham liner (new in 2020)—perfect for relaxing or entertaining by the water. Inside, the gourmet kitchen and open living spaces are designed for both comfort and style, while the main-floor primary suite offers a spa-like retreat. The home’s ten garage stalls and workshop provide ample space for hobbies and storage, and the flexible studio apartment—with its own garage stall—offers options for guests, multi-generational living, or rental income. Sustainability and value shine with the owned solar system—solar rights transferred to new buyers—delivering energy savings and peace of mind for years to come. With in-floor radiant heating, two fireplaces, four laundry areas, and every amenity thoughtfully included, this property is the definition of turnkey luxury. Nearby, enjoy the natural beauty of Little Rock Lake, Benton Beach Park, and the Mississippi River Park. This is lakeside living at its finest—ready for you to move in and enjoy!

9805 Sharon Place NW, Rice

Listing courtesy of Epique Realty.

$560,000

Tucked away on 1.78 private and wooded acres along the majestic Mississippi River, this stunning log home offers the perfect blend of rustic charm and peaceful waterfront living. Built in 2004 with 1,845 finished square feet, this 3 bedroom, 2 bathroom home welcomes you with soaring vaulted ceilings, an impressive wall of windows overlooking the river, and a breathtaking floor-to-ceiling stone fireplace that anchors the main living space. The open-concept layout flows seamlessly through the living room, dining area, and kitchen—ideal for gathering and entertaining. The main floor features a spacious bedroom that could be used as the primary bedroom, full bathroom, convenient laundry, and in-floor heat for year-round comfort. Upstairs, the loft provides additional seating or flex space along with two more bedrooms and a full bathroom complete with double sinks, a jetted soaking tub with shower attachment, and an added bonus—a private sauna for the ultimate relaxation experience. Outside, enjoy easy access to the river from the level yard surrounded by mature trees and nature views in every direction. A rare opportunity to enjoy log home living on the river with privacy, comfort, and unforgettable scenery.

3 Beds ⋅ 2 Baths ⋅ 7078056 MLS

Tucked away on 1.78 private and wooded acres along the majestic Mississippi River, this stunning log home offers the perfect blend of rustic charm and peaceful waterfront living. Built in 2004 with 1,845 finished square feet, this 3 bedroom, 2 bathroom home welcomes you with soaring vaulted ceilings, an impressive wall of windows overlooking the river, and a breathtaking floor-to-ceiling stone fireplace that anchors the main living space. The open-concept layout flows seamlessly through the living room, dining area, and kitchen—ideal for gathering and entertaining. The main floor features a spacious bedroom that could be used as the primary bedroom, full bathroom, convenient laundry, and in-floor heat for year-round comfort. Upstairs, the loft provides additional seating or flex space along with two more bedrooms and a full bathroom complete with double sinks, a jetted soaking tub with shower attachment, and an added bonus—a private sauna for the ultimate relaxation experience. Outside, enjoy easy access to the river from the level yard surrounded by mature trees and nature views in every direction. A rare opportunity to enjoy log home living on the river with privacy, comfort, and unforgettable scenery.

6600 Canary Road NW, Royalton

Listing courtesy of Premier Real Estate Services.

$645,900

First-Time Offering – Stunning Riverfront Retreat on 2.25 Acres Welcome to this one-owner home nestled in a highly sought-after river destination community. As you meander down scenic Barley Road, you’ll immediately feel a sense of arrival as this beautifully maintained property comes into view, showcasing exceptional curb appeal. Set on 2.25 acres and surrounded by mature hardwoods and pines, this rare waterfront property offers unparalleled access to the Mississippi River, with over 14 miles of navigable water—one of the most breathtaking stretches in the region. Outdoor living is truly exceptional here. Relax or entertain on the impressive paver patio while enjoying peaceful river views and abundant wildlife. Evenings are best spent gathered around the dedicated fire pit under the stars. This thoughtfully designed four-level home is generous in size and room count and also rich in quality craftsmanship, ready for your personal touch. The main floor features a functional kitchen and designated dining area. Upstairs, you’ll find a welcoming living space, along with the primary suite boasting a spacious walk-in closet and a convenient walk-through to a full four-fixture bath. A second bedroom completes this level. The third level is a true highlight—offering panoramic backyard views and anchored by a striking all-brick, wood-burning fireplace that beautifully separates a cozy family room from a private, highly functional office. An additional bedroom and bathroom are also located on this level. The home continues to impress with a well-planned laundry and mechanical area that includes second access to the garage. The lowest level provides a versatile rec room or workout space, along with a large, well-lit workshop. Additional features include meticulously maintained grounds, lush lawns, and a convenient garden shed. Appreciate the 50 year shingles with transferable warranty, chip resistant maintenance free siding a new septic system, full owned propane tank, concrete patio, and Fiber Optic cable for high speed internet. This is a rare opportunity to own a premier riverfront property—schedule your showing soon to fully appreciate all it has to offer.

3 Beds ⋅ 2 Baths ⋅ 7072698 MLS

First-Time Offering – Stunning Riverfront Retreat on 2.25 Acres Welcome to this one-owner home nestled in a highly sought-after river destination community. As you meander down scenic Barley Road, you’ll immediately feel a sense of arrival as this beautifully maintained property comes into view, showcasing exceptional curb appeal. Set on 2.25 acres and surrounded by mature hardwoods and pines, this rare waterfront property offers unparalleled access to the Mississippi River, with over 14 miles of navigable water—one of the most breathtaking stretches in the region. Outdoor living is truly exceptional here. Relax or entertain on the impressive paver patio while enjoying peaceful river views and abundant wildlife. Evenings are best spent gathered around the dedicated fire pit under the stars. This thoughtfully designed four-level home is generous in size and room count and also rich in quality craftsmanship, ready for your personal touch. The main floor features a functional kitchen and designated dining area. Upstairs, you’ll find a welcoming living space, along with the primary suite boasting a spacious walk-in closet and a convenient walk-through to a full four-fixture bath. A second bedroom completes this level. The third level is a true highlight—offering panoramic backyard views and anchored by a striking all-brick, wood-burning fireplace that beautifully separates a cozy family room from a private, highly functional office. An additional bedroom and bathroom are also located on this level. The home continues to impress with a well-planned laundry and mechanical area that includes second access to the garage. The lowest level provides a versatile rec room or workout space, along with a large, well-lit workshop. Additional features include meticulously maintained grounds, lush lawns, and a convenient garden shed. Appreciate the 50 year shingles with transferable warranty, chip resistant maintenance free siding a new septic system, full owned propane tank, concrete patio, and Fiber Optic cable for high speed internet. This is a rare opportunity to own a premier riverfront property—schedule your showing soon to fully appreciate all it has to offer.

15675 Barley Road NW, Royalton

Listing courtesy of VoigtJohnson.

$999,000

River views from every room highlight this beautifully remodeled home in 2024, where the entire interior and exterior have been thoughtfully updated with numerous additions. Major improvements include all-new heating, cooling, plumbing, and electrical systems for modern comfort and peace of mind. Bend in the River Regional Park is walking distance. Scenic trails along the river and in the woods. The neighborhood has it's on boat landing. The home features a brand-new wood-burning fireplace with a new chimney and fan, creating a warm and inviting centerpiece. The kitchen is equipped with high-end Sub-Zero and Wolf appliances, along with elegant Cambria quartz and granite countertops. Throughout the home you’ll find new wood flooring, carpet, and tile. The main floor includes a spacious primary bedroom, with two additional bedrooms upstairs and two more bedrooms in the lower level—providing plenty of space for family and guests. Multiple living areas offer flexibility and comfort, with two living rooms, an exercise room, and dedicated office space. The walk-out basement adds convenience and easy access to the outdoors. Step outside to enjoy two decks, new landscaping, and a thoughtfully designed outdoor entertaining area. The property also includes an attached 30 x 36 heated garage and a detached 26 x 32 garage with 10-foot doors, ideal for vehicles, storage, or recreational equipment. Just a few steps down provide direct access to the river. The neighborhood also offers a convenient boat landing, and a scenic half-mile trail connects to Bend in the River Regional Park. This home combines peaceful riverfront living with quick access to city amenities. 13.4 Miles to St. Cloud Hospital 14.6 Miles to St. Cloud State University 17.3 miles to St. Cloud Regional Airport

5 Beds ⋅ 4 Baths ⋅ 7032816 MLS

River views from every room highlight this beautifully remodeled home in 2024, where the entire interior and exterior have been thoughtfully updated with numerous additions. Major improvements include all-new heating, cooling, plumbing, and electrical systems for modern comfort and peace of mind. Bend in the River Regional Park is walking distance. Scenic trails along the river and in the woods. The neighborhood has it's on boat landing. The home features a brand-new wood-burning fireplace with a new chimney and fan, creating a warm and inviting centerpiece. The kitchen is equipped with high-end Sub-Zero and Wolf appliances, along with elegant Cambria quartz and granite countertops. Throughout the home you’ll find new wood flooring, carpet, and tile. The main floor includes a spacious primary bedroom, with two additional bedrooms upstairs and two more bedrooms in the lower level—providing plenty of space for family and guests. Multiple living areas offer flexibility and comfort, with two living rooms, an exercise room, and dedicated office space. The walk-out basement adds convenience and easy access to the outdoors. Step outside to enjoy two decks, new landscaping, and a thoughtfully designed outdoor entertaining area. The property also includes an attached 30 x 36 heated garage and a detached 26 x 32 garage with 10-foot doors, ideal for vehicles, storage, or recreational equipment. Just a few steps down provide direct access to the river. The neighborhood also offers a convenient boat landing, and a scenic half-mile trail connects to Bend in the River Regional Park. This home combines peaceful riverfront living with quick access to city amenities. 13.4 Miles to St. Cloud Hospital 14.6 Miles to St. Cloud State University 17.3 miles to St. Cloud Regional Airport

10267 Ferry Point Place NW, Rice

Listing courtesy of Jack Chivers Realty.

$855,000

Discover unmatched privacy and natural beauty on this stunning 2+ acre wooded retreat, perfectly positioned along the Harris Channel—your gateway to endless days of boating on one of the most breathtaking stretches of the Mississippi River in the entire state. This unique reservoir also offers convenient access to Little Rock Lake, expanding your recreational possibilities. A private concrete driveway leads you into this custom-crafted home, designed with exceptional attention to detail and an unbelievable amount of garage and workshop space. In addition to a 24' x 36' detached 3-stall garage, the home features an incredible 42' x 28' main-level garage plus a 42' x 28' tuck-under garage, currently serving as an outstanding workshop. Garden enthusiasts will love the private greenhouse—your new haven for growing, nurturing, and getting things to bloom. A welcoming 10' x 35' covered front porch provides serene views of the wooded front yard. Step inside to a spacious foyer where vaulted ceilings greet you and invite you to step in and appreciate the window scape framing the manicured yard and waterfront scenery. Immediate from foyer, French doors open to a versatile den/office that also works beautifully as a main-floor guest room. Designed for convenience, the home offers true one-level living with zero-step front entry. The open-concept kitchen, dining, and living areas ensure that stunning water views are enjoyed from every room. The kitchen shines with abundant prep space, thoughtful appliance placement, generous storage, and a functional island—ideal for everyday cooking and more involved culinary adventures. The primary suite is a peaceful retreat with a luxurious bathroom featuring a walk-in closet, tiled shower, and spa tub. And the best part, a private deck that enjoys morning sun for sipping coffee and appreciating what the day has to offer. From the main garage entry, you'll find direct access to the in-home elevator, main-floor laundry, and an additional bathroom. The walkout lower level is loaded with possibilities—multigenerational living, guest accommodations, extended entertaining, or a hobby haven. It includes: 2 bedrooms A flex room A patio-side space perfect for exercise equipment or a future hot tub room A kitchenette An additional flex room ideal for crafts, office space, or extra sleeping quarters A cozy living room with a second fireplace and look-out windows showcasing the peaceful surroundings Step out to the shaded lower patio beneath the wrap-around deck and wander down to the designated fire pit area—your own private sanctuary for quiet evenings or hosting friends around the fire. This property offers so much to love—best appreciated through a private visit. For full appreciation of its exceptional features, please explore the professional photo collection and detailed descriptions.

4 Beds ⋅ 4 Baths ⋅ 7013524 MLS

Discover unmatched privacy and natural beauty on this stunning 2+ acre wooded retreat, perfectly positioned along the Harris Channel—your gateway to endless days of boating on one of the most breathtaking stretches of the Mississippi River in the entire state. This unique reservoir also offers convenient access to Little Rock Lake, expanding your recreational possibilities. A private concrete driveway leads you into this custom-crafted home, designed with exceptional attention to detail and an unbelievable amount of garage and workshop space. In addition to a 24' x 36' detached 3-stall garage, the home features an incredible 42' x 28' main-level garage plus a 42' x 28' tuck-under garage, currently serving as an outstanding workshop. Garden enthusiasts will love the private greenhouse—your new haven for growing, nurturing, and getting things to bloom. A welcoming 10' x 35' covered front porch provides serene views of the wooded front yard. Step inside to a spacious foyer where vaulted ceilings greet you and invite you to step in and appreciate the window scape framing the manicured yard and waterfront scenery. Immediate from foyer, French doors open to a versatile den/office that also works beautifully as a main-floor guest room. Designed for convenience, the home offers true one-level living with zero-step front entry. The open-concept kitchen, dining, and living areas ensure that stunning water views are enjoyed from every room. The kitchen shines with abundant prep space, thoughtful appliance placement, generous storage, and a functional island—ideal for everyday cooking and more involved culinary adventures. The primary suite is a peaceful retreat with a luxurious bathroom featuring a walk-in closet, tiled shower, and spa tub. And the best part, a private deck that enjoys morning sun for sipping coffee and appreciating what the day has to offer. From the main garage entry, you'll find direct access to the in-home elevator, main-floor laundry, and an additional bathroom. The walkout lower level is loaded with possibilities—multigenerational living, guest accommodations, extended entertaining, or a hobby haven. It includes: 2 bedrooms A flex room A patio-side space perfect for exercise equipment or a future hot tub room A kitchenette An additional flex room ideal for crafts, office space, or extra sleeping quarters A cozy living room with a second fireplace and look-out windows showcasing the peaceful surroundings Step out to the shaded lower patio beneath the wrap-around deck and wander down to the designated fire pit area—your own private sanctuary for quiet evenings or hosting friends around the fire. This property offers so much to love—best appreciated through a private visit. For full appreciation of its exceptional features, please explore the professional photo collection and detailed descriptions.

9025 Burton Court NW, Rice

Listing courtesy of VoigtJohnson.

$239,900

Live on the Mississippi River, Great views and Sunsets. Private boat slip, Development features 100 acres of green space, miles of walking trails, and miles of river to explore with sandbars. HOA takes care of lawn care, snow removal and dock. A MUST SEE, Maintenance-free living on the river with amenities close by.

6719778 MLS

Live on the Mississippi River, Great views and Sunsets. Private boat slip, Development features 100 acres of green space, miles of walking trails, and miles of river to explore with sandbars. HOA takes care of lawn care, snow removal and dock. A MUST SEE, Maintenance-free living on the river with amenities close by.

7411 River Bend Court, Sauk Rapids

Listing courtesy of Granite City Real Estate.