Tarren Newhouse

My Office Listings

1-6/64
  • Rural Address, Corman Park Rm No. 344 SK S0K 2T0 in Corman Park Rm No. 344: Commercial for sale : MLS®# SK008577

    Rural Address, Corman Park Rm No. 344 SK S0K 2T0 Corman Park Rm No. 344 S0K 2T0
    Main Photo: Rural Address, Corman Park Rm No. 344 SK S0K 2T0 in Corman Park Rm No. 344: Commercial for sale : MLS®# SK008577
    $9,685,000
    Commercial
    Status:
    Active
    MLS® Num:
    SK008577
    Incredible investment opportunity with this 149-acre parcel located between Saskatoon and Martensville. Located at the corner of Highway 12 and Township Road 381, this high exposure property has an impressive 1977' of frontage along Highway 12 and an additional 2563' along Township Road 381. This property is situated within the P4G District Boundary, and in the 'Urban Light Industrial' area in the North Concept Plan. Which means an application to rezone the parcel to Light Industrial District (DM1) is supported by the Official Community Plan. With 70 acres already developed with glacial till, a retention pond, and an additional $1,000,000 worth of gravel stockpiled on-site, this property presents a unique opportunity for a savvy investor or developer looking to capitalize on its prime location and existing infrastructure. More details
    Listed by TRCG The Realty Consultants Group and Coldwell Banker Signature
  • 19 Abbey Road in Corman Park Rm No. 344: Residential for sale : MLS®# SK017625

    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®# SK017625
    $3,450,000
    Residential
    Status:
    Active
    MLS® Num:
    SK017625
    Bedrooms:
    6
    Bathrooms:
    7
    Floor Area:
    8,340 sq. ft.
    Prestige Living at 19 Abbey Road. Experience a residence that blends modern craftsmanship, timeless design, and superior value. Set on 46 private acres just minutes from Saskatoon, this extraordinary estate offers over 8,000 sq ft of refined living space, purpose-built for those who demand excellence. Though owner-occupied, a large percentage of this home remains in new condition. The kitchen appliances, as well as the main floor and second-floor bathrooms, have never been used, offering the rare opportunity to step into a home that feels as though it has just been completed. Every detail has been carefully considered, from the architectural design and premium finishes to the expansive indoor and outdoor living spaces. The result is a home that is as functional as it is breathtaking. Property Highlights- 6 bedrooms & 7 bathrooms, including a Turkish spa-inspired primary suite with steam shower and dual walk-in closets. Chef’s kitchen with premium Miele appliance package & expansive counter tops that have never been used. Home theatre. Elegant living and dining spaces with pristine finishes throughout. Two expansive covered decks offering sweeping prairie views. Executive office wing with private boardroom, ideal for professionals or entrepreneurs. Private self-contained living area with kitchenette. 8-car garage, RV parking, and a massive shop — perfect for tradespeople, collectors, or hobbyists. Advanced construction: SIP panel design, in-floor heating, and high-velocity climate control system. Seller is offering a 100k landscaping package. 46 acres of privacy, paired with proximity to Saskatoon and the airport More details
    Listed by TRCG The Realty Consultants Group
  • 859 University Drive in Saskatoon: Nutana Residential for sale : MLS®# SK010045

    859 University Drive Nutana Saskatoon S7N 0J8
    Main Photo: 859 University Drive in Saskatoon: Nutana Residential for sale : MLS®# SK010045
    $2,399,900
    Residential
    Status:
    Active
    MLS® Num:
    SK010045
    Bedrooms:
    6
    Bathrooms:
    3
    Floor Area:
    2,800 sq. ft.
    Welcome to 859 University Drive also known as the "Ellie" which is the 5th home in a row and is part of Maison's Luxury urban development project. Show home at 853 University Drive is available to be viewed by appointment and if this plan doesn't suit your needs, we can custom build anything you need. This site along with many more on University Drive are now ready for your custom build, or one of our pre-designed floor plans. This home will be available in a 3 & 4 bedroom option. Offered with furnished basement, triple detached heated and finished garage. Exterior & infrastructure : * Modern French country exterior with EIFS stucco, stone accents and wood headers * 8' custom curved entry door * Garden door system from living room * Triple pane dual low e windows* Optional covered rear deck* Superior insulation and mechanical systems designed for comfort and performance * open web wood joists * Full 9' ceilings in basement with no bulkheads interior design features: * Maison signature design package including designer lighting & plumbing package and personalized selections for all hard surfaces * 8' doors throughout the main floor * 10' ceilings on second with tray ceiling to 9' in principal bedroom, 9' ceilings in basement * vaulted dormer ceiling in foyer* hardwood through main floor and hardwood stairs * the floors in all baths and mudroom * quartz countertops * kitchen with 10' island and galley style butler's pantry connected to dining room * appliance package features full fridge and full freezer, 36" range, and paneled dishwasher * living room with natural gas fireplace with custom mantle and builds ins on either side * oversized mudroom with built in armoire style closets and built in bench * private dining room with crown moulding * large office off foyer * primary bedroom with tray ceiling and crown moulding ( tray vaults 9')* stunning boutique style walk in closet * five piece en-suite with 11' vanity, soaker tub and 36"x72" custom tiled curdles shower. More details
    Listed by TRCG The Realty Consultants Group
  • 4415 7th Avenue East in Prince Albert: Crescent Heights Lot/Land for sale : MLS®# SK002697

    4415 7th Avenue East Crescent Heights Prince Albert S6V 7K5
    Main Photo: 4415 7th Avenue East in Prince Albert: Crescent Heights Lot/Land for sale : MLS®# SK002697
    $2,195,000
    Lot/Land
    Status:
    Conditional Sale
    MLS® Num:
    SK002697
    4 acre development parcel zoned C4 commercial with 509' highway frontage. This is thee premier parcel in the Yard. Situated on the corners of Highway 3, 44th street East, and 7th Ave E this land delivers unmatched visibility and access. Check out full feature sheet here: https://shorturl.at/3bOxP More details
    Listed by TRCG The Realty Consultants Group
  • 134 710 Brighton Boulevard in Saskatoon: Brighton Residential for sale : MLS®# SK014693

    134 710 Brighton Boulevard Brighton Saskatoon S7V 0P6
    Main Photo: 134 710 Brighton Boulevard in Saskatoon: Brighton Residential for sale : MLS®# SK014693
    $1,649,900
    Residential
    Status:
    Active
    MLS® Num:
    SK014693
    Bedrooms:
    5
    Bathrooms:
    4
    Floor Area:
    2,436 sq. ft.
    Welcome to Encore! This is a luxury walk out community in Brighton. Secure your build with Maison Design Build. Triple attached heated garage, fully developed walkout basement. Pricing is based on Maison's quality, specs and previously built homes. Floor plans available to bonafide buyers. Construction to commence upon completion of the builder's contract. Maison will also do a custom build on this lot if you desire. More details
    Listed by TRCG The Realty Consultants Group
  • Rural Address, Aberdeen Rm No. 373 SK S0K 0A0 in Aberdeen Rm No. 373: Farm for sale : MLS®# SK007663

    Rural Address, Aberdeen Rm No. 373 SK S0K 0A0 Aberdeen Rm No. 373 S0K 0A0
    Main Photo: Rural Address, Aberdeen Rm No. 373 SK S0K 0A0 in Aberdeen Rm No. 373: Farm for sale : MLS®# SK007663
    $1,400,000
    Farm
    Status:
    Active
    MLS® Num:
    SK007663
    Great spot for an acreage subdivision or golf course. Gently rolling land with some sloughs and bush. Only minutes from Saskatoon close to Mission Ridge and other acreage subdivisions. GST if ANY to be paid by purchaser. Directions from Saskatoon take highway 5 past the highway 41 intersection to Drews Road. Turn left on Drews Road 4.5k land is on right hand side. More details
    Listed by TRCG The Realty Consultants Group
1-6/64
Data was last updated September 14, 2025 at 01: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.