Tarren Newhouse
306-261-4627 tarrennewhouse@gmail.com
My Office Listings
-
149 Acres Highway 12 in Corman Park Rm No. 344: Commercial for sale : MLS®# SK037956
149 Acres Highway 12 Corman Park Rm No. 344 S0K 2T0 
$9,685,000Commercial- Status:
- Active
- MLS® Num:
- SK037956
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 detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
131 Greenbryre Street in Corman Park Rm No. 344: Residential for sale : MLS®# SK043386
131 Greenbryre Street Corman Park Rm No. 344 S7V 0J6
$4,499,900Residential- Status:
- Active
- MLS® Num:
- SK043386
- Bedrooms:
- 6
- Bathrooms:
- 7
- Floor Area:
- 4,195 sq. ft.
Welcome to 131 Greenbryre Street, an extraordinary custom-built walkout bungalow overlooking Greenbryre Golf Course. Situated on a beautifully landscaped 142’ x 164’ lot, this exceptional estate offers 4,195 sq. ft. on the main floor, 3,492 sq. ft. in the fully developed walkout basement, and 7,687 sq. ft. of finished living space with 6 bedrooms, 5 full bathrooms and 2 powder rooms. A grand circular driveway with RV parking leads to the spectacular 1,700 sq. ft. Auto Box Interiors garage featuring epoxy floors. Inside, soaring ceilings, floor-to-ceiling windows, exceptional millwork, a dramatic fireplace and a stunning glass wine room create an unforgettable living space. The chef’s kitchen features premium Miele appliances, a large walk-in pantry and oversized patio doors opening to the expansive deck with golf course views. The luxurious primary suite offers deck access, a spa-inspired ensuite with steam shower, freestanding tub and an incredible 400 sq. ft. dressing room. Designed for entertaining and multigenerational living, the walkout level includes a private guest suite with garage access, two additional bedrooms with ensuites and walk-in closets, a curved bar, fitness room, sauna and spacious recreation areas. The showpiece is the spectacular 16-seat private theatre, entered through a 600-pound custom door. Featuring commercial-grade audio and projection, a custom illuminated constellation ceiling, advanced acoustics and an investment of approximately $1 million, it delivers a true cinema experience. Commercial-grade mechanical systems include dual mechanical rooms, zoned HVAC, hydronic in-floor heat. Professionally landscaped grounds feature expansive decks, a screened outdoor living room, natural gas fireplace, water features, a three-hole putting green, covered pergola and robotic lawn mower. Full home automation AV, lighting and blind controls. A truly one-of-a-kind luxury estate combining exceptional craftsmanship, engineering and lifestyle. More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
19 Abbey Road in Corman Park Rm No. 344: Residential for sale : MLS®# SK036529
19 Abbey Road Corman Park Rm No. 344 S0K 2T0
$2,950,000Residential- Status:
- Active
- MLS® Num:
- SK036529
- Bedrooms:
- 6
- Bathrooms:
- 7
- Floor Area:
- 8,340 sq. ft.
Experience a residence that seamlessly blends modern craftsmanship, timeless design, and exceptional value. Set on 46 private acres in the Rural Municipality of Corman Park No. 344 just minutes from Saskatoon, this extraordinary estate offers over 8,000 square feet of refined living space designed for those who expect more. A significant portion of the home remains in untouched condition. The chef’s kitchen appliances, along with the main and second-floor bathrooms, have never been used — presenting a rare opportunity to own a residence that still feels newly completed. Thoughtfully designed with both luxury and functionality in mind, every detail reflects elevated craftsmanship and purposeful design. Expansive indoor and outdoor living spaces create an atmosphere equally suited for grand entertaining or private retreat living. Property Highlights- 6 bedrooms and 7 bathrooms, Turkish spa-inspired primary retreat, featuring a steam shower and dual walk-in closets. Chef’s kitchen with premium Miele appliance package and expansive unused countertops. Private home theatre. Elegant living and dining spaces with pristine finishes throughout. Two expansive covered decks with panoramic prairie views. Executive office wing with private boardroom, ideal for entrepreneurs or professionals working from home, Private self-contained living quarters with kitchenette. 8-car garage, RV parking, and a massive shop — ideal for collectors, hobbyists, or tradespeople. Advanced construction featuring SIP panel design, in-floor heating, and high-velocity climate control 46 acres of exceptional privacy with convenient access to Saskatoon and the airport. 19 Abbey Road is more than a home — it is a private estate designed for legacy living, elevated entertaining, and uncompromising comfort. More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
859 University Drive in Saskatoon: Nutana Residential for sale : MLS®# SK032397
859 University Drive Saskatoon S7N 0J8
$2,690,000Residential- Status:
- Active
- MLS® Num:
- SK032397
- 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 detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
298 E 1st Street in Creighton: Commercial for sale : MLS®# SK029536
298 E 1st Street Creighton S0J 0N0
$2,600,000Commercial- Status:
- Active
- MLS® Num:
- SK029536
- Major Bus.:
- office
- Floor Area:
- 10,734 sq. ft.
The Provincial Office building in Creighton, services the northeast corner of Saskatchewan. It has housed the courthouse, social services, natural resources, plus other provincial departments since 1980. The Government of Saskatchewan recently renewed their lease, showing their commitment to the site. The McIlvenna Bay project, the new copper-zinc-gold-silver underground mine in northeastern Saskatchewan, is 65 km southwest of Creighton. It is set to begin commercial production in mid-2026. More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
106 Stirrup Close in Corman Park Rm No. 344: Residential for sale : MLS®# SK043371
106 Stirrup Close Corman Park Rm No. 344 S7K 3J9
$1,789,900Residential- Status:
- Conditional Sale
- MLS® Num:
- SK043371
- Bedrooms:
- 4
- Bathrooms:
- 4
- Floor Area:
- 1,992 sq. ft.
Welcome to 106 Stirrup Close, an exceptional 5 bedroom and 4 bathroom acreage estate that flawlessly blends luxury living, recreation, privacy, and everyday practicality, all while offering the convenience of city water, pavement to the doorstep, and quick access to Saskatoon. A true highlight is the impressive five-car attached garage stretching over 72 feet in length, complete with in-floor heat, exceptional storage capacity, a convenient two-piece bathroom, and direct access to the rear dog run. Inside, the thoughtfully designed floor plan balances family living with privacy and functionality. The kitchen serves as the heart of the home, featuring a stunning quartz waterfall island, quality cabinetry, premium finishes, and a remarkable hidden butler’s pantry offering extensive storage. The kitchen, dining area, and family room flow seamlessly together while overlooking the spectacular backyard and pool area. The primary suite offers garden doors providing direct access to the rear deck, while the luxurious ensuite features in-floor heat, dual vanities, a freestanding tub, a beautifully tiled walk-in shower, and a spacious walk-in closet. Outdoor living is where this property truly shines with a vaulted covered deck overlooking a private resort-inspired backyard featuring maintenance-free decking, a stunning fiberglass inground pool, an impressive poolside bar connected to the pool house, and a private pergola-covered hot tub area. The walkout basement offers direct access to the backyard, a large family and recreation room, two oversized bedrooms with walk-in closets, a beautifully appointed bathroom, and additional flex space for a home gym, office, den, or hobby room. From the heated 72-foot garage and hidden butler’s pantry to the resort-style backyard and beautifully treed four-acre setting, 106 Stirrup Close delivers an unparalleled lifestyle both inside and out. More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
Data was last updated July 24, 2026 at 05:35 PM (UTC)
About Me
I make myself available at all times. My web site is here to help you 24 hours a day. When you are ready to see a listing in person, or just have a simple question, please dont hesitate to contact me!
Sign up
Already a member?
Cell: 306-261-4627
440 4 St E, Saskatoon, SK, S7H 1J5, CA