Tarren Newhouse

My Office Listings

1-6/56
  • 149 Acres Highway 12 in Corman Park Rm No. 344: Commercial for sale : MLS®# SK008577

    149 Acres Highway 12 Corman Park Rm No. 344 S0K 2T0
    Main Photo: 149 Acres Highway 12 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
  • 214 D Avenue South in Saskatoon: Riversdale Multi-Family for sale : MLS®# SK986612

    214 D Avenue South Riversdale Saskatoon S7M 1P9
    Main Photo: 214 D Avenue South in Saskatoon: Riversdale Multi-Family for sale : MLS®# SK986612
    $4,199,000
    Multi-Family
    Status:
    Active
    MLS® Num:
    SK986612
    Approx $300k annual gross rent. Wonderful opportunity to own A 16 townhouse complex with modern day construction. All 16 units have indoor secure parking in the garage. This complex was built to condominium spec and has the ability to be turned into individual condo units. Located in the heart of Saskatoon and walking distance to all of the downtown amenities. The demographic of the complex is a young vibrant community. Financial and expense reports available to bonafide buyers. Sellers are willing to carry a second mortgage, terms and conditions are to be negotiated. More details
    Listed by TRCG The Realty Consultants Group
  • 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
  • 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
  • 2270 Northridge Drive in Saskatoon: North Industrial SA Commercial for sale : MLS®# SK005908

    2270 Northridge Drive North Industrial SA Saskatoon S7L 1B9
    Main Photo: 2270 Northridge Drive in Saskatoon: North Industrial SA Commercial for sale : MLS®# SK005908
    $2,224,000
    Commercial
    Status:
    Conditional Sale
    MLS® Num:
    SK005908
    Floor Area:
    16,050 sq. ft.
    This +/-16050 sf building sits on 2 acres of IL1 land fronting 44th street East, and is easily accessible just off of Faithfull ave. situated on the corner of 44th street and Northridge drive the property overlooks the Idylwyld freeway creating great visibility for your signage. The large lot provides an excess land component that offers the flexibility to be used for additional development or accommodate users that require extra land for storage. 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:
    Active
    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
1-6/56
Data was last updated June 22, 2025 at 11: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.