Tarren Newhouse
306-261-4627 tarrennewhouse@gmail.com
My Office Listings
-
149 Acres Highway 12 in Corman Park Rm No 344: Commercial Sale for sale (Corman Park Rm No. 344) : MLS®# SK037956
149 Acres Highway 12 Corman Park Rm No 344 S0K 2T0 
$9,685,000Commercial Sale- 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 and Coldwell Banker Signature- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
131 Greenbryre Street in Corman Park Rm No 344: Residential for sale (Corman Park Rm No. 344) : 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
-
3303 Faithfull Avenue in Saskatoon: Hudson Bay Industrial Commercial Sale for sale : MLS®# SK044365
3303 Faithfull Avenue Saskatoon S7K 8H5
$3,740,000Commercial Sale- Status:
- Active
- MLS® Num:
- SK044365
- Floor Area:
- 12,000 sq. ft.
Located in the heart of Saskatoon’s Hudson Bay Industrial area, 3303 Faithfull Avenue presents an outstanding investment opportunity. This 12,000 sq. ft. industrial building sits on 1.59 acres and is zoned IL1, allowing for a wide range of industrial uses. The building features approximately 11,600 sq. ft. of warehouse space, complemented by 2 private offices and 2 bathrooms, providing a functional layout for industrial operations. With 11 oversized 14’ x 16’ grade-level overhead doors, the property offers exceptional accessibility for trucking, warehousing, fleet operations, and distribution. Outside, the property boasts a fully fenced compound, providing secure outdoor storage and ample yard space for equipment, vehicles, or materials. Adding to its appeal, the property is occupied by stable, long-term tenants, making it an excellent opportunity for investors seeking reliable income. Financial information, including current rental income, is available upon request. This is a rare opportunity to acquire a well-located, income-producing industrial asset in one of Saskatoon’s premier industrial corridors. More detailsListed by Coldwell Banker Signature and TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
3315 Faithfull Avenue in Saskatoon: Hudson Bay Industrial Commercial Sale for sale : MLS®# SK044366
3315 Faithfull Avenue Saskatoon S7K 8H5
$3,560,000Commercial Sale- Status:
- Active
- MLS® Num:
- SK044366
- Floor Area:
- 14,272 sq. ft.
Prime investment opportunity in Saskatoon’s Hudson Bay Industrial area. Located at 3315 Faithfull Avenue, this 14,272 sqft industrial building sits on 1.25 acres and offers an excellent combination of quality construction, functional warehouse space, and stable rental income. The property features approximately 12,800 sqft of warehouse space complemented by four private offices, a lunchroom and a locker room to support day-to-day operations. The warehouse is equipped with four grade-level doors, 3 phase power, a private unheated storage area with grade door and mezzanine within the building, and a highly functional layout suitable for a wide range of industrial users. The fully fenced compound provides secure outdoor storage and additional operational flexibility. Zoned IL1, the property is well positioned in one of Saskatoon’s premier industrial districts with convenient access to major transportation routes. Immediate income opportunity with an established tenant currently in place looking to secure a long term lease. Financial statements and lease details are available upon request. More detailsListed by Coldwell Banker Signature and TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
Cao Acreage in Corman Park Rm No 344: Residential for sale (Corman Park Rm No. 344) : MLS®# SK052375
Cao Acreage Corman Park Rm No 344 S7K 3J9
$2,999,900Residential- Status:
- Active
- MLS® Num:
- SK052375
- Bedrooms:
- 7
- Bathrooms:
- 10
- Floor Area:
- 6,475 sq. ft.
The Cao Acreage Estate occupies 18 exceptionally private, scenic RIVERFRONT ACRES, just minutes from the city limits. This gated estate features a 6,475 sq. ft. residence with 8 bedrooms, 11 bathrooms, an indoor pool resort, 3 fully developed levels including a walkout, elevator access and 3 outbuildings. Exceptional construction and advanced mechanical systems distinguish this rare property. Beyond the automated iron gates, a winding asphalt drive framed by mature trees leads to the home. Original exposed beams complement extensive modernization and a substantial 2020 addition. The expansive main floor overlooks the river, with a stately great room, dining area, sitting room, kitchen and a window-lined family (media) room. Also featured on main flr is 2 bathrooms/ laundry, sunroom, and mudroom access to the double attached garage; PLUS an incredible resort-style indoor pool including a sauna room, bathroom and dedicated mechanical room with professional-grade dehumidification. Upstairs, 5 very generous bedroom suites each offer a walk-in closet, private ensuite bath and large windows. The fully developed walkout level features a river-facing family room lined with large windows, and a games room, an expansive theatre room, bedroom suite with ensuite, additional bathroom and 2 utility rooms. An ELEVATOR SERVICES ALL 3 LEVELS. The sprawling grounds feature mature trees, extensive asphalt paving, a large heated shop and 2 additional garages. The property is located at the end of the access road, for exceptional privacy and no through traffic. Currently a cherished family home, the estate may also offer potential for hospitality, care accommodations or other uses, subject to approvals. A rare combination of riverfront acreage, substantial living space and exceptional infrastructure, minutes off Mcormond Dr. 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 (Corman Park Rm No. 344) : MLS®# SK036529
19 Abbey Road Corman Park Rm No 344 S0K 2T0
$2,950,000Residential- Status:
- Pending
- 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
Data was last updated November 4, 2026 at 04:35 AM (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