Tarren Newhouse

My Office Listings

7-12/393
  • Private Oasis Acreage in Dundurn: Residential for sale (Dundurn Rm No. 314) : MLS®# SK971551

    Private Oasis Acreage Dundurn S7C 0B3
    Main Photo: Private Oasis Acreage in Dundurn: Residential for sale (Dundurn Rm No. 314)  : MLS®# SK971551
    $1,299,900
    Residential
    Status:
    Active
    MLS® Num:
    SK971551
    Bedrooms:
    4
    Bathrooms:
    5
    Floor Area:
    4,354 sq. ft.
    Wow. Welcome to this fabulous luxury oasis in the prairies located at 7 Pelletier road-Cobble Lane Estate. As soon as you set foot into this fabulous two-storey walkout mansion, you will be impressed by the grand entrance, luxurious finishings and amazing large windows and views from almost every room of the house. The 4.95-acre lot that is 70% treed and professionally landscaped offers one grand entryway, grand living rooms, large formal dining room, stunning kitchen and smaller spicy kitchen, two large private balconies, elegant wood-burning fireplaces, and 4 1/2 bathrooms, and one large bonus room with attached 4-piece bathroom, all tiled. The walkout basement is currently in framing stage. The basement is framed featuring large windows, 2 bedrooms, a den, bathroom and access to a beautiful patio space with stunning landscaping. It also features a 3-car attached heated garage. Special features of this home include: spray foam insulation on the whole house, making it very affordable to heat, professional landscaping, trail around the property, hardwood floors throughout, 2 furnaces, 2 air conditioners, triple pane windows, sprinklers and drip line system, custom wood burning fireplace with stone and a fan to heat the house, landscaped to perfection, outdoor fireplace used for bbq and a smokehouse. Amazing private home, with amazing views!! One of a kind! More details
    Listed by TRCG The Realty Consultants Group and eXp Realty
  • B&W Ranch in Corman Park: Residential for sale (Corman Park Rm No. 344) : MLS®# SK959995

    B&W Ranch Corman Park S0K 0Y0
    Main Photo: B&W Ranch in Corman Park: Residential for sale (Corman Park Rm No. 344)  : MLS®# SK959995
    $1,278,000
    Residential
    Status:
    Pending
    MLS® Num:
    SK959995
    Bedrooms:
    4
    Bathrooms:
    2
    Floor Area:
    2,064 sq. ft.
    Welcome to your dream 80-acre kingdom, a quick 15 minute drive SE of Saskatoon. Adventure calls with acres of whispering trees, endless trails, and unrivalled privacy.  Built in 2021, the uniquely flexible house/commercial building and versatile AG Building are your canvas for imagination.  Think equestrian pursuits, creative workshops, or a quaint home-based business all nestled alongside cozy living spaces. Discover a world where your entrepreneurial spirit can roam free with limitless combos for work and home life! Picture yourself in the energy efficient work space, plotting your future castle on the ready-to-go site complete with a second separate septic system and water lines already installed. With SaskWater's robust pressurized system on the land, this means no drip tanks! Pressurized City Water! Each corner of this haven is designed for ease, animals and self sufficiency. The Barn House, boasts over 2,000 sqft, with 4 rooms, 2 baths, and a heated 24x42’ garage/shop/flex space that can be used as a family room!  An enclosed 12 x 42’ carport is perfect for bikes, quads, snowmobiles, or why not add a hot tub and soak under the stars? With luxuries like A/C, Hardie Board siding, Quartz counters, and porcelain tiles, comfort meets style effortlessly. Outside, it’s fully fenced, has a vast barnyard, exclusive stallion corral, foal pens, water stations and hydrants galore, not to mention 7 KM of trails with space for a grand arena in the middle. The 40x60’ gas heated AG Building, a haven of productivity with its multi-door shop and equestrian suites, features a tack room with WC and foaling stalls.  Or maybe you are a mechanic or car enthusiast.  Lots of inside heated space for your toys and workshop.  This isn’t just a home, it’s a launchpad for family, income ventures, and even the option of subdivision (2x5 acres or 1x10 acres). Enjoy the luxury of privacy, efficiency, and your personal sprawling park with no need to trailer your horses for a ride ever again! More details
    Listed by eXp Realty
  • 101 Hwy 2 South in Prince Albert: Commercial for sale (Prince Albert Rm No. 461) : MLS®# SK950090

    101 Hwy 2 South Prince Albert S6V 0V8
    Main Photo: 101 Hwy 2 South in Prince Albert: Commercial for sale (Prince Albert Rm No. 461)  : MLS®# SK950090
    $1,250,000
    Commercial
    Status:
    Active
    MLS® Num:
    SK950090
    Floor Area:
    2,400 sq. ft.
    Development Opportunity!! Currently set up as 6 leasable areas, with 2400sqf Shop and 5 fully serviced & fenced compounds all set up on 2.54acres with 175' of hwy frontage. The 2400sqft leased commercial shop is thoughtfully designed and equipped to meet a variety of business needs. Like new building, with dimensions of 40 feet by 60 feet, this commercial space offers ample room for your entrepreneurial aspirations. Notable features include 12'x16' garage door, 18' ceilings, radiant heat, bathroom, kitchenette area, fenced compound, Highway exposure and signage plus Option to add industrial mezzaniness for storage or office space. This remarkable property also offers 5 spacious and fully serviced fenced compounds, perfect for a wide range of business ventures. With a lot size of 100' X 150' and a double gate for easy access, you'll have all the space you need to bring your vision to life. Whether you're looking storage, set up shop, expand your business, or simply secure a prime location for your operations, KGM Commercial Centre has it all. Each property is cleared, filled with services to each compound (NG, Power & Telephone). All set up and ready for you to start building your dreams. This complete package offers a versatile canvas for various business ventures, including workshops, storage, manufacturing, or even a retail showroom. Its combination of essential amenities, highway exposure, and secure fencing makes it a standout choice for entrepreneurs looking to establish or expand their operations. Your business's future success starts here! More details
    Listed by eXp Realty
  • 18 Candle Lake Drive in Candle Lake: Residential for sale : MLS®# SK965669

    18 Candle Lake Drive Candle Lake S0J 3E0
    Main Photo: 18 Candle Lake Drive in Candle Lake: Residential for sale : MLS®# SK965669
    $1,250,000
    Residential
    Status:
    Active
    MLS® Num:
    SK965669
    Bedrooms:
    5
    Bathrooms:
    2
    Floor Area:
    2,209 sq. ft.
    LAKEFRONT!! Welcome to #18 Candle Lake Drive, located in the Clearsand Subdivision. Dream spot, with crystal clear waters, amazing views, & lake access. This gorgeous A-frame offers over 2000sqft of living space, 5 bedrooms, 2bathroom. The open concept and well thought out layout provides an abundance of natural light and a sense of balance and warmth throughout the house, all while maximizing your panoramic lake views. The main floor showcases, mudroom, 2 nice size bedrooms, 3pc bathroom with a steam room, main floor laundry with easy access to the all utilities. Updated kitchen has tons of counter and cupboard space with double corner pantry, stainless steel appliance, built-in dishwasher all while taking advantage of gorgeous views of the water. The central bar/island area serves as the ultimate hub for entertainment, offering an inviting space where guests can gather and socialize in style. Adjacent to the kitchen, a cozy tuck-in dinning area awaits. Wonderful living room with vaulted ceiling, showcasing a towering brick wood fireplace. Step through the patio doors to unveil a spectacular outdoor retreat, featuring a sprawling two-tiered deck that offers abundant space for relaxation and entertainment, complete with a rejuvenating firewater hot tub, all while being treated to serene lake vistas. The secluded back deck and firepit area provide a snug and intimate ambiance, perfect for cozy gatherings under the stars.Upstairs is bright and open, with addition 3 oversized bedrooms, family room with separate deck access and loft area for enjoying your quiet time or office space. The residence includes a spacious 24'X20' garage, complete with a delightful loft area that presents an ideal haven for the kids to retreat. Package includes Marina berth at Clearsand Subdivision, dock & lift permit (2permits), aluminum dock inc, wood/storage sheds, Cedar Siding, asphalt driveway, alarm system, lake water, & 1500gal septic. Don't miss out on this wonderful LAKEFRONT!!! More details
    Listed by eXp Realty
  • 194 Sinclair Crescent in Saskatoon: Rosewood Residential for sale : MLS®# SK970768

    194 Sinclair Crescent Rosewood Saskatoon S7V 0E7
    Main Photo: 194 Sinclair Crescent in Saskatoon: Rosewood Residential for sale : MLS®# SK970768
    $1,150,000
    Residential
    Status:
    Active
    MLS® Num:
    SK970768
    Bedrooms:
    5
    Bathrooms:
    5
    Floor Area:
    3,163 sq. ft.
    Welcome to an exquisite residence nestled in the heart of Rosewood, Saskatoon's most prestigious neighborhood. This stunning home, commanding a prime corner lot with parks on two sides, offers unparalleled views and privacy. At over 3,000 square feet, this property stands as a testament to grandeur and elegance. From the moment you approach, the majestic street presence of this home captivates. The expansive yard and deck provide an idyllic setting to enjoy the breathtaking park views. Conveniently located within walking distance to top-tier schools, this property is designed for families seeking both luxury and practicality. Step inside to a formal foyer that sets the tone for the rest of the home. A versatile large den or music room and a dedicated office nook cater to both relaxation and productivity. The attached, finished, heated garage offers direct access to a spacious mudroom, seamlessly connecting to a walk-through pantry and the chef's dream kitchen. Here, you'll find miles of exquisite countertops, high-end cabinetry, and top-of-the-line appliances, making culinary endeavors a true pleasure. The dining area, overlooking the yard and park, provides a serene backdrop for every meal. The family room, featuring piano windows flanking a natural gas fireplace, exudes warmth and sophistication. Upstairs, each of the three bedrooms boasts its own lavish ensuite bathroom, ensuring ultimate privacy and comfort. The primary bedroom is a sanctuary, complete with a cozy fireplace and a spa-like ensuite that promises relaxation and rejuvenation. A massive bonus room on this level offers versatile space perfect for a family. The convenience of second-floor laundry adds to the home's functional luxury. The fully finished basement extends the living space, featuring two additional bedrooms, a full bathroom, and a colossal family room ideal for entertaining or unwinding. This residence is a rare blend of opulence and comfort. More details
    Listed by eXp Realty
  • 103 T Avenue North in Saskatoon: Mount Royal SA Residential for sale : MLS®# SK970543

    103 T Avenue North Mount Royal SA Saskatoon S7L 3A9
    Main Photo: 103 T Avenue North in Saskatoon: Mount Royal SA Residential for sale : MLS®# SK970543
    $999,000
    Residential
    Status:
    Active
    MLS® Num:
    SK970543
    Bedrooms:
    11
    Bathrooms:
    10
    Floor Area:
    5,052 sq. ft.
    Welcome to the magnificent fourplex located at 101, 103, 105, and 107 Avenue T North. This contemporary building, constructed in 2015, offers a unique investment opportunity with distinct features that set it apart from traditional properties. Here are some key details about the units: - Total 16 bedrooms and 14 bathrooms - Unit 101 & 107: 1188 SqFt each, featuring 5 bedrooms and 4 bathrooms. These units are mirror images of each other and come with side entrances leading to the basement. - Unit 103 & 105: 1108 SqFt each, offering 3 bedrooms and 3 bathrooms. These units are also mirror images of each other. - The basement was designed by the owner to be utilized as an office space, with an 8-foot ceiling and floor heating potential. - Each unit has its own gas meter and power meter, ensuring convenience and efficiency. - A generous 230 SqFt backyard space accompanies each unit, ideal for relaxation and outdoor activities. - The property boasts designated parking spots for all four units and single attached garages for unit 101 and 107. This fourplex presents a unique opportunity for an investor to acquire all four units and potentially create a condominium complex or purchase two duplexes side by side. The original building drawings are available to provide insight into the property layout and design. Don't miss out on this exceptional investment opportunity. Contact your preferred REALTOR® today to schedule a viewing and explore the possibilities of owning this distinctive property. Act now and seize the chance to become the proud owner of this outstanding fourplex. More details
    Listed by eXp Realty
7-12/393
Data was last updated June 20, 2024 at 09:35 AM (UTC)
The Saskatchewan REALTORS® Association (SRA) IDX Reciprocity listings are displayed in accordance with SRA's MLS® Data Access Agreement and are copyright of the Saskatchewan REALTORS® Association (SRA).
The above information is from sources deemed reliable but should not be relied upon without independent verification. The information presented here is for general interest only, no guarantees apply.
Trademarks are owned and controlled by the Canadian Real Estate Association (CREA). Used under license.
MLS® System data of the Saskatchewan REALTORS® Association (SRA) displayed on this site is refreshed every 2 hours.