Tarren Newhouse

306-261-4627

My Office Listings

1-6/59

  • 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

    Rural Address, Corman Park Rm No. 344 SK S0K 2T0 Corman Park Rm No. 344 S0K 2T0

    $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
    LISTING DETAILS

  • 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

    859 University Drive Saskatoon S7N 0J8 Nutana

    $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
    LISTING DETAILS

  • 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

    4415 7th Avenue East Prince Albert S6V 7K5 Crescent Heights

    $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
    LISTING DETAILS

  • 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

    134 710 Brighton Boulevard Saskatoon S7V 0P6 Brighton

    $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
    LISTING DETAILS

  • 408 Edgemont Cove in Corman Park Rm No. 344: Residential for sale : MLS®# SK008524

    408 Edgemont Cove Corman Park Rm No. 344 S7T 0Z7
    Main Photo: 408 Edgemont Cove in Corman Park Rm No. 344: Residential for sale : MLS®# SK008524

    408 Edgemont Cove Corman Park Rm No. 344 S7T 0Z7

    $1,495,000
    Residential
    Status:
    Conditional Sale
    MLS® Num:
    SK008524
    Bedrooms:
    6
    Bathrooms:
    5
    Floor Area:
    2,660 sq. ft.
    Welcome to 408 Edgemont Cove - for the discerning buyer that wishes to seamlessly combine peaceful rural living with urban convenience. This stunning custom-built bungalow by Casa Rio Developments has been thoughtfully designed for family living and offers over 5400 sq.ft. of developed space including 6 bedrooms, 5 bathrooms, and a wealth of high-end features that perfectly blend style and comfort. The 0.63 acre lot (114x253) is ideally located on a quiet cove with no rear neighbours and provides lovely westward views, stunning sunsets, and abundant natural light. Main floor features include a stunning great-room with 12 foot ceilings and tiled fireplace; a chef’s kitchen built for hosting with custom cabinetry, 10' quartz island with waterfall edges, professional grade stainless appliances, a butlers pantry with sink, wine fridge, and generous storage for effortless entertaining; the dining area seats up to 10 guests; the primary bedroom provides a luxurious 5-pc ensuite bath with standalone soaker tub, walk-in tiled shower, floating vanity, and spacious walk-in closet with custom built-ins; in the “kids wing” are 2 additional main floor bedrooms and a 4-pc bath, along with patio doors to the deck and yard. The fully finished basement is a family dream with its large family room, theatre room, workout area, 3 additional bedrooms, a den, and 2 more gorgeous bathrooms. Further features include 3 gas fireplaces and central air for year round comfort; a private backyard patio with multiple composite decks and lounge areas. The massive 60x26 four car heated garage provides room for vehicles, toys, tools, and additional storage. Just 5 minutes from the city and paved to your door, Edgemont Estates is a family oriented development with amenities that include a recreational park, playground, outdoor hockey rink, basketball, pickleball and tennis courts, walking trails and more. This is the lifestyle and opportunity your family is seeking, book your private showing today! More details
    Listed by TRCG The Realty Consultants Group
    LISTING DETAILS

  • 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

    Rural Address, Aberdeen Rm No. 373 SK S0K 0A0 Aberdeen Rm No. 373 S0K 0A0

    $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
    LISTING DETAILS
1-6/59
 <  123...10  > 
Data was last updated August 30, 2025 at 11:35 PM (UTC)
The Saskatchewan REALTORS® Association IDX Reciprocity listings are displayed in accordance with SRA's MLS® Data Access Agreement and are copyright of the Saskatchewan REALTORS® Association.
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 displayed on this site is refreshed every 2 hours.

Superior MLS® Search

Start Searching!

Buying A Home

Start buying Now!

Selling Your Home

Start Selling Now!
Powered by myRealPage.com
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.