Tarren Newhouse

My Listings

1-11/11
  • 19 Abbey Road in Corman Park Rm No. 344: Residential for sale : MLS®# SK010248

    19 Abbey Road Corman Park Rm No. 344 S0K 2T0
    Main Photo: 19 Abbey Road in Corman Park Rm No. 344: Residential for sale : MLS®# SK010248
    $3,450,000
    Residential
    Status:
    Active
    MLS® Num:
    SK010248
    Bedrooms:
    6
    Bathrooms:
    7
    Floor Area:
    8,340 sq. ft.
    This exceptional 46-acre property offers the ultimate live-work opportunity for tradespeople, contractors, or entrepreneurs seeking to grow their business without sacrificing lifestyle. With over 8,000 sq ft of luxurious living space—plus additional square footage in the covered solarium and BBQ area off the kitchen and a spacious upper deck—this estate is purpose-built for comfort, function, and success. Inside, you’ll find 6 spacious bedrooms and 7 bathrooms, including a lavish primary suite featuring a Turkish spa-inspired ensuite and two custom walk-in closets. The heart of the home is a stunning chef’s kitchen with premium finishes and seamless access to the covered outdoor entertaining space. A main-floor private office, a dedicated office wing with boardroom complete with kitchenette. A fully equipped home theatre add to the property's impressive array of live-work amenities. Outdoors, the massive custom heated garage includes RV parking and in-floor heat, while the large shop with overhead door, additional garage, carport, and expansive yard provide ideal space for fleet vehicles, materials, or future expansion. Whether you're an electrician, builder, or entrepreneur, 19 Abbey Road is more than a home—it’s your headquarters for success. More details
    Listed by eXp Realty and TRCG The Realty Consultants Group
  • Complete Country Package - 120 Acres Rm of Vanscoy in Vanscoy Rm No. 345: Residential for sale : MLS®# SK006491

    Complete Country Package - 120 Acres Rm of Vanscoy Vanscoy Rm No. 345 S0L 3J0
    Main Photo: Complete Country Package - 120 Acres Rm of Vanscoy in Vanscoy Rm No. 345: Residential for sale : MLS®# SK006491
    $799,900
    Residential
    Status:
    Active
    MLS® Num:
    SK006491
    Bedrooms:
    4
    Bathrooms:
    2
    Floor Area:
    1,688 sq. ft.
    Just 15 minutes from Saskatoon, this picture perfect ranch offers the best of prairie living—with room to roam, space to grow, and everything set up just right. Sitting on 120 acres of gently rolling land, this property is ideal for horse folks, hobby farmers, or anyone wanting that peaceful rural lifestyle without giving up access to the city. There’s a lovely mix of healthy pasture, meadows, bush, and nearly 5km of mown trails that wind through the land—perfect for riding, hiking, skiing, or a quiet walk with a coffee in hand. The well kept 4 bed, 2 bath home was built in 1986 with 2X6 walls. At 1,700 sq ft plus a partial basement, there’s plenty of room to stretch out. The house has had all the right updates, including a brand new roof in 2024, fresh paint and baseboards, ensuite Reno (22'). You’ll also find a HE furnace, cold storage, a water softener, and manual transfer switch to 30amp generator. An outdoor wood-fired boiler connects underground to the house, garage, and barn. The 3 door garage is heated and insulated with a big mezzanine for storage and a newer metal roof (19'). The 50x80 barn is a dream with tack area and stalls in front, a roomy sand arena, and in-floor heat poured and plumbed into the boiler system. The barnyard is fully fenced with several paddocks, swinging gates, 2 automatic waterers (19'), 3 hydrants, and a well built south-facing shelter. Electric cross-fencing is in place for rotational grazing, and the fencelines have been well-maintained and mowed. Nature lovers will adore the abundant wild chokecherry and Saskatoon bushes, not to mention the woodpeckers, chickadees, and early spring mountain bluebirds that call this place home. There’s also a greenhouse, 3 sheds for storage, and a huge 60x120 garden plot with rich soil, fruit trees, and full irrigation lines included. And when the day winds down? Unwind in the outdoor wood fired sauna, then cozy up by the fire pit and watch the stars come out. Country roads, take me home! More details
    Listed by TRCG The Realty Consultants Group
  • 722 Casper Crescent in Warman: Residential for sale : MLS®# SK000087

    722 Casper Crescent Warman S0K 4S4
    Main Photo: 722 Casper Crescent in Warman: Residential for sale : MLS®# SK000087
    $622,000
    Residential
    Status:
    Active
    MLS® Num:
    SK000087
    Bedrooms:
    3
    Bathrooms:
    2
    Floor Area:
    1,575 sq. ft.
    722 Casper Crescent is a stunning modern home currently under construction, designed with both comfort and style in mind. Featuring 3 comfortably proportioned bedrooms, including a luxurious master suite with a 5-piece ensuite, this residence offers a spacious layout that maximizes functionality and elegance. A key highlight of the property is the expansive 3-car garage, providing ample room for vehicles, storage, and even a workshop. The unfinished basement offers an exciting opportunity for buyers to customize the space to fit their needs, whether that means creating a home theater, additional living space, or a recreation area. Conveniently located in a family-friendly neighborhood with easy access to parks, schools, shopping, and major roads, 722 Casper Crescent is perfect for both families and professionals. With its blend of luxury, space, and customization potential, this home is an exceptional choice for anyone looking for a home that meets all their needs. Don’t miss out on this incredible opportunity! More details
    Listed by TRCG The Realty Consultants Group
  • 614 Casper Cove in Warman: Residential for sale : MLS®# SK000084

    614 Casper Cove Warman S0K 4S4
    Main Photo: 614 Casper Cove in Warman: Residential for sale : MLS®# SK000084
    $613,000
    Residential
    Status:
    Active
    MLS® Num:
    SK000084
    Bedrooms:
    3
    Bathrooms:
    2
    Floor Area:
    1,575 sq. ft.
    614 Casper Cove presents a fantastic opportunity to own a brand new home, currently under construction. This thoughtfully designed residence will feature 3 nicely sized bedrooms, including a luxurious master suite with a 5-piece ensuite bathroom, offering the perfect retreat for relaxation and privacy. In addition to the master suite, the home includes a second bedroom and a versatile third bedroom, ideal for use as a home office, guest room, or additional child's room. A second 4-piece bathroom will serve the remaining bedrooms, providing convenience and comfort. The unfinished basement offers the opportunity to customize and design the space according to your preferences, whether that means creating an entertainment area, home gym, or additional living space. Situated in a family-friendly neighborhood, 614 Casper Cove provides easy access to parks, schools, shopping, and major roads, making it a perfect location for both families and professionals. With its spacious layout, luxurious master suite, and endless potential for customization, this home is an excellent choice for those looking to create their ideal living space. Don't miss the chance to own this beautiful home! More details
    Listed by TRCG The Realty Consultants Group
  • Mitchener Acreage in Corman Park Rm No. 344: Residential for sale : MLS®# SK008896

    Mitchener Acreage Corman Park Rm No. 344 S0K 2T0
    Main Photo: Mitchener Acreage in Corman Park Rm No. 344: Residential for sale : MLS®# SK008896
    $599,900
    Residential
    Status:
    Conditional Sale
    MLS® Num:
    SK008896
    Bedrooms:
    3
    Bathrooms:
    2
    Floor Area:
    1,225 sq. ft.
    Acreage Opportunity on Dalmeny Road, just Minutes from Dalmeny & Martensville. This acreage property offers a fantastic opportunity for those looking to invest in land with future potential. Located just off pavement, the parcel includes approximately 75 acres of cultivated land (currently rented until the end of the year) and a well-established, mature yard site spanning about 5 acres. The 1976 bungalow home offers 3 bedrooms on the main floor, with 2 additional dens in the basement that could be converted into bedrooms with adding egress windows. One 4-piece bathroom is located upstairs and a 3-piece bathroom downstairs. The home is heated by natural gas forced air and uses a cistern for water supply. Both the house and outbuildings require significant TLC and are being sold as-is but loaded with potential with some sweat equity. This property has subdivision potential and offers a prime location with easy access to nearby communities. A great option for someone ready to build equity or reimagine the space. Inquire for more details or to schedule a viewing. More details
    Listed by TRCG The Realty Consultants Group
  • RM of Canaan Acreage - 13.04 Acres in Canaan Rm No. 225: Residential for sale : MLS®# SK000089

    RM of Canaan Acreage - 13.04 Acres Canaan Rm No. 225 S0L 1Z0
    Main Photo: RM of Canaan Acreage - 13.04 Acres in Canaan Rm No. 225: Residential for sale : MLS®# SK000089
    $479,900
    Residential
    Status:
    Active
    MLS® Num:
    SK000089
    Bedrooms:
    4
    Bathrooms:
    3
    Floor Area:
    1,938 sq. ft.
    Welcome to this one-of-a-kind Eaton's character home, where classic charm meets modern living on a picturesque 13-acre estate near Lucky Lake. This meticulously restored property invites you into a world of timeless elegance, from the inviting wrap-around deck to the expansive, tree-lined yard that offers complete privacy and tranquillity. Originally relocated to its current location with a brand-new basement in 2007, this home has undergone extensive updates, including newer plumbing, wiring, and windows, ensuring that the historic beauty remains while offering today's modern conveniences. The spacious kitchen, remodelled with maple cabinetry in 2008, is a cook’s dream, perfectly designed for creating memorable meals. The main living area, with large windows and 10-foot ceilings, floods with natural light, offering breathtaking views of the countryside. Upstairs, the primary suite is a peaceful retreat, complete with a cozy loft space, ideal for quiet moments or creative pursuits. The fully renovated basement, with 9-foot ceilings, provides ample space for a home gym, family room, or guest quarters. The updates continue with a high-efficiency furnace (2015) and a 2022 on-demand hot water tank for added comfort. Step outside to experience the full beauty of this property. The covered and uncovered portions of the deck are perfect for savouring the peaceful sounds of nature or watching the sunset over the rolling hills. For those dreaming of country living with modern amenities, this acreage is fully fenced for livestock and features both a pond and a dugout. An old barn and woodworking shed add even more character, while the meticulously tended gardens offer endless potential for the green thumb. With natural gas heating, municipal water, and paved access right to the property, convenience is at your fingertips. Schedule your viewing today and experience firsthand the charm, history, and peace that await you at this extraordinary acreage home! More details
    Listed by TRCG The Realty Consultants Group
  • Serviced 10-Acre Treed Parcel Minutes from Dalmeny in Corman Park Rm No. 344: Lot/Land for sale : MLS®# SK003099

    Serviced 10-Acre Treed Parcel Minutes from Dalmeny Corman Park Rm No. 344 S0K 0J0
    Main Photo: Serviced 10-Acre Treed Parcel Minutes from Dalmeny in Corman Park Rm No. 344: Lot/Land for sale : MLS®# SK003099
    $370,000
    Lot/Land
    Status:
    Active
    MLS® Num:
    SK003099
    Welcome to your future dream build site — a rare 10-acre parcel ideally situated on the corner of the Warman grid and Road 3064. Just minutes from Dalmeny, and a short, easy drive to both Martensville and Saskatoon, this location offers the perfect blend of country privacy and city convenience. What sets this property apart? Power and natural gas have already been run right to the former build site on the property — a major value and head start when planning your home. The land is beautifully treed, offering excellent privacy and a serene setting for whatever vision you have in mind. Build a custom home, move on an RTM, start a hobby farm, plant a garden, or finally put up that dream shop — the possibilities are truly endless. This is a rare opportunity to own land in a highly sought-after location with significant prep work already complete. More details
    Listed by TRCG The Realty Consultants Group
  • 405 150 Pawlychenko Lane in Saskatoon: Lakewood S.C. Residential for sale : MLS®# SK010269

    405 150 Pawlychenko Lane Lakewood S.C. Saskatoon S7V 0B4
    Main Photo: 405 150 Pawlychenko Lane in Saskatoon: Lakewood S.C. Residential for sale : MLS®# SK010269
    $329,900
    Residential
    Status:
    Conditional Sale
    MLS® Num:
    SK010269
    Bedrooms:
    2
    Bathrooms:
    2
    Floor Area:
    1,109 sq. ft.
    Imagine waking up to sunlight streaming through oversized corner windows and sipping your morning coffee on a private balcony on the top floor. This 1,109 sq. ft. corner unit feels more like a quiet retreat than a typical condo, with generous space, elevated views, and an airy layout perfect for both relaxing and entertaining. The open concept design provides ample space with a beautiful kitchen featuring granite countertops, stainless steel appliances, and a raised island made for casual meals or evening chats over wine. The primary suite offers a calming escape with a walk-through closet and private ensuite, while the second bedroom and full bath add flexibility for guests, work, or hobbies. With sun filled windows throughout, two side by side underground parking stalls, in-suite laundry with extra room for a deep freeze, two additional storage lockers, central air, a gas BBQ hookup, guest parking, and access to a shared community room, comfort and convenience are built in. Nestled across from a sprawling park with walking paths and just minutes to shops, restaurants, medical clinics, and transit, this is one of those rare spaces that just feels like home the moment you step inside. More details
    Listed by TRCG The Realty Consultants Group
  • 2B 514 Main Street in Martensville: Residential for sale : MLS®# SK009811

    2B 514 Main Street Martensville S0K 0A2
    Main Photo: 2B 514 Main Street in Martensville: Residential for sale : MLS®# SK009811
    $185,000
    Residential
    Status:
    Conditional Sale
    MLS® Num:
    SK009811
    Bedrooms:
    2
    Bathrooms:
    1
    Floor Area:
    480 sq. ft.
    Say hello to Unit 2B at 514 Main Street in the charming little city of Martensville, just a quick 10 minute hop from Saskatoon! This sweet and simple townhome is tucked into a quiet spot with its own private entrance, fenced yard (perfect for pets or a tiny garden!), and one dedicated parking space. Bonus: loads of street parking if you’ve got a second vehicle. Inside, you’ll find a bright and comfy living area with several recent updates, a cute eat-in kitchen, and handy upstairs storage for all your extras. Head downstairs to discover two spacious bedrooms both with walk-in closets (yes, please!), a full 4-piece bath, and in-suite laundry. And the cherry on top? Condo fees are just $200/month. Low maintenance, cozy living, and an easy commute, what’s not to love? More details
    Listed by TRCG The Realty Consultants Group
  • 611 3rd Street in Kenaston: Commercial for sale : MLS®# SK002720

    611 3rd Street Kenaston S0G 2N0
    Main Photo: 611 3rd Street in Kenaston: Commercial for sale : MLS®# SK002720
    $134,000
    Commercial
    Status:
    Active
    MLS® Num:
    SK002720
    Major Bus.:
    Previously used as restaurant
    Floor Area:
    1,600 sq. ft.
    Discover a beautifully renovated, turn-key building for sale in Kenaston, just 45 minutes south of Saskatoon. Located at the intersection of Highways 11 and 15, this prime spot is perfect for commuters and travelers. Fully renovated in 2024, the space is certified for restaurant use but offers endless possibilities—bakery, coffee shop, event venue, lounge, or more! Inside, you'll find a cozy seating area, two wheelchair-accessible restrooms, and air conditioning for year-round comfort. The commercial kitchen features a $23,000 professionally installed hood range, a gas oven with griddle, and a large stainless steel prep station. A spacious back office and an additional room, originally approved as a tattoo studio, offer flexibility for rentals or other uses. Outside, the double corner lot includes a grassy area ideal for a summer patio. A full basement provides extra storage or expansion potential. Recent upgrades include a new furnace, water heater, updated electrical and plumbing, stucco exterior (2022), and new doors and windows. The roof was replaced in 2017. With tables, chairs, and appliances included, this property is ready for your vision—schedule a viewing today! More details
    Listed by TRCG The Realty Consultants Group
  • 160 Carwin Park Drive in Lakeland Rm No. 521: Lot/Land for sale : MLS®# SK010622

    160 Carwin Park Drive Lakeland Rm No. 521 S0J 0N0
    Main Photo: 160 Carwin Park Drive in Lakeland Rm No. 521: Lot/Land for sale : MLS®# SK010622
    $119,900
    Lot/Land
    Status:
    Active
    MLS® Num:
    SK010622
    Located in the desirable Carwin Park area, this 6,318 square foot lot presents a unique opportunity to bring your lakeside vision to life. With serene views overlooking the sparkling waters of Emma Lake and bordered by a tranquil natural reserve at the back, this property offers both beauty and privacy. A thoughtful mix of mature trees and open space provides the perfect setting for your custom build. Enjoy year-round access, stunning lake vistas, and essential services right at the road. Whether you're planning a seasonal getaway or a year-round home, this lot is ready to become your personal retreat. More details
    Listed by TRCG The Realty Consultants Group
1-11/11
Data was last updated June 30, 2025 at 07:35 PM (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.