Tarren Newhouse
306-261-4627 tarrennewhouse@gmail.com
My Listings
-
19 Abbey Road in Corman Park Rm No. 344: Residential for sale : MLS®# SK010248
19 Abbey Road Corman Park Rm No. 344 S0K 2T0 
$3,450,000Residential- 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 detailsListed by eXp Realty and TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
Complete Country Package - 120 Acres Rm of Vanscoy in Vanscoy Rm No. 345: Residential for sale : MLS®# SK006491
Complete Country Package - 120 Acres Rm of Vanscoy Vanscoy Rm No. 345 S0L 3J0
$799,900Residential- Status:
- Active
- MLS® Num:
- SK006491
- Bedrooms:
- 4
- Bathrooms:
- 2
- Floor Area:
- 1,688 sq. ft.
Just 15 minutes from Saskatoon, this picture perfect ranch offers the best of prairie living—with room to roam, space to grow, and everything set up just right. Sitting on 120 acres of gently rolling land, this property is ideal for horse folks, hobby farmers, or anyone wanting that peaceful rural lifestyle without giving up access to the city. There’s a lovely mix of healthy pasture, meadows, bush, and nearly 5km of mown trails that wind through the land—perfect for riding, hiking, skiing, or a quiet walk with a coffee in hand. The well kept 4 bed, 2 bath home was built in 1986 with 2X6 walls. At 1,700 sq ft plus a partial basement, there’s plenty of room to stretch out. The house has had all the right updates, including a brand new roof in 2024, fresh paint and baseboards, ensuite Reno (22'). You’ll also find a HE furnace, cold storage, a water softener, and manual transfer switch to 30amp generator. An outdoor wood-fired boiler connects underground to the house, garage, and barn. The 3 door garage is heated and insulated with a big mezzanine for storage and a newer metal roof (19'). The 50x80 barn is a dream with tack area and stalls in front, a roomy sand arena, and in-floor heat poured and plumbed into the boiler system. The barnyard is fully fenced with several paddocks, swinging gates, 2 automatic waterers (19'), 3 hydrants, and a well built south-facing shelter. Electric cross-fencing is in place for rotational grazing, and the fencelines have been well-maintained and mowed. Nature lovers will adore the abundant wild chokecherry and Saskatoon bushes, not to mention the woodpeckers, chickadees, and early spring mountain bluebirds that call this place home. There’s also a greenhouse, 3 sheds for storage, and a huge 60x120 garden plot with rich soil, fruit trees, and full irrigation lines included. And when the day winds down? Unwind in the outdoor wood fired sauna, then cozy up by the fire pit and watch the stars come out. Country roads, take me home! More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
722 Casper Crescent in Warman: Residential for sale : MLS®# SK000087
722 Casper Crescent Warman S0K 4S4
$622,000Residential- Status:
- Active
- MLS® Num:
- SK000087
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 1,575 sq. ft.
722 Casper Crescent is a stunning modern home currently under construction, designed with both comfort and style in mind. Featuring 3 comfortably proportioned bedrooms, including a luxurious master suite with a 5-piece ensuite, this residence offers a spacious layout that maximizes functionality and elegance. A key highlight of the property is the expansive 3-car garage, providing ample room for vehicles, storage, and even a workshop. The unfinished basement offers an exciting opportunity for buyers to customize the space to fit their needs, whether that means creating a home theater, additional living space, or a recreation area. Conveniently located in a family-friendly neighborhood with easy access to parks, schools, shopping, and major roads, 722 Casper Crescent is perfect for both families and professionals. With its blend of luxury, space, and customization potential, this home is an exceptional choice for anyone looking for a home that meets all their needs. Don’t miss out on this incredible opportunity! More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
614 Casper Cove in Warman: Residential for sale : MLS®# SK000084
614 Casper Cove Warman S0K 4S4
$613,000Residential- Status:
- Active
- MLS® Num:
- SK000084
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 1,575 sq. ft.
614 Casper Cove presents a fantastic opportunity to own a brand new home, currently under construction. This thoughtfully designed residence will feature 3 nicely sized bedrooms, including a luxurious master suite with a 5-piece ensuite bathroom, offering the perfect retreat for relaxation and privacy. In addition to the master suite, the home includes a second bedroom and a versatile third bedroom, ideal for use as a home office, guest room, or additional child's room. A second 4-piece bathroom will serve the remaining bedrooms, providing convenience and comfort. The unfinished basement offers the opportunity to customize and design the space according to your preferences, whether that means creating an entertainment area, home gym, or additional living space. Situated in a family-friendly neighborhood, 614 Casper Cove provides easy access to parks, schools, shopping, and major roads, making it a perfect location for both families and professionals. With its spacious layout, luxurious master suite, and endless potential for customization, this home is an excellent choice for those looking to create their ideal living space. Don't miss the chance to own this beautiful home! More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
Mitchener Acreage in Corman Park Rm No. 344: Residential for sale : MLS®# SK008896
Mitchener Acreage Corman Park Rm No. 344 S0K 2T0
$599,900Residential- Status:
- Active
- MLS® Num:
- SK008896
- Bedrooms:
- 3
- Bathrooms:
- 2
- Floor Area:
- 1,225 sq. ft.
Acreage Opportunity on Dalmeny Road, just Minutes from Dalmeny & Martensville. This acreage property offers a fantastic opportunity for those looking to invest in land with future potential. Located just off pavement, the parcel includes approximately 75 acres of cultivated land (currently rented until the end of the year) and a well-established, mature yard site spanning about 5 acres. The 1976 bungalow home offers 3 bedrooms on the main floor, with 2 additional dens in the basement that could be converted into bedrooms with adding egress windows. One 4-piece bathroom is located upstairs and a 3-piece bathroom downstairs. The home is heated by natural gas forced air and uses a cistern for water supply. Both the house and outbuildings require significant TLC and are being sold as-is but loaded with potential with some sweat equity. This property has subdivision potential and offers a prime location with easy access to nearby communities. A great option for someone ready to build equity or reimagine the space. Inquire for more details or to schedule a viewing. More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
RM of Canaan Acreage - 13.04 Acres in Canaan Rm No. 225: Residential for sale : MLS®# SK000089
RM of Canaan Acreage - 13.04 Acres Canaan Rm No. 225 S0L 1Z0
$479,900Residential- Status:
- Active
- MLS® Num:
- SK000089
- Bedrooms:
- 4
- Bathrooms:
- 3
- Floor Area:
- 1,938 sq. ft.
Welcome to this one-of-a-kind Eaton's character home, where classic charm meets modern living on a picturesque 13-acre estate near Lucky Lake. This meticulously restored property invites you into a world of timeless elegance, from the inviting wrap-around deck to the expansive, tree-lined yard that offers complete privacy and tranquillity. Originally relocated to its current location with a brand-new basement in 2007, this home has undergone extensive updates, including newer plumbing, wiring, and windows, ensuring that the historic beauty remains while offering today's modern conveniences. The spacious kitchen, remodelled with maple cabinetry in 2008, is a cook’s dream, perfectly designed for creating memorable meals. The main living area, with large windows and 10-foot ceilings, floods with natural light, offering breathtaking views of the countryside. Upstairs, the primary suite is a peaceful retreat, complete with a cozy loft space, ideal for quiet moments or creative pursuits. The fully renovated basement, with 9-foot ceilings, provides ample space for a home gym, family room, or guest quarters. The updates continue with a high-efficiency furnace (2015) and a 2022 on-demand hot water tank for added comfort. Step outside to experience the full beauty of this property. The covered and uncovered portions of the deck are perfect for savouring the peaceful sounds of nature or watching the sunset over the rolling hills. For those dreaming of country living with modern amenities, this acreage is fully fenced for livestock and features both a pond and a dugout. An old barn and woodworking shed add even more character, while the meticulously tended gardens offer endless potential for the green thumb. With natural gas heating, municipal water, and paved access right to the property, convenience is at your fingertips. Schedule your viewing today and experience firsthand the charm, history, and peace that await you at this extraordinary acreage home! More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
-
2B 514 Main Street in Martensville: Residential for sale : MLS®# SK009811
2B 514 Main Street Martensville S0K 0A2
$185,000Residential- Status:
- Conditional Sale
- MLS® Num:
- SK009811
- Bedrooms:
- 2
- Bathrooms:
- 1
- Floor Area:
- 480 sq. ft.
Say hello to Unit 2B at 514 Main Street in the charming little city of Martensville, just a quick 10 minute hop from Saskatoon! This sweet and simple townhome is tucked into a quiet spot with its own private entrance, fenced yard (perfect for pets or a tiny garden!), and one dedicated parking space. Bonus: loads of street parking if you’ve got a second vehicle. Inside, you’ll find a bright and comfy living area with several recent updates, a cute eat-in kitchen, and handy upstairs storage for all your extras. Head downstairs to discover two spacious bedrooms both with walk-in closets (yes, please!), a full 4-piece bath, and in-suite laundry. And the cherry on top? Condo fees are just $200/month. Low maintenance, cozy living, and an easy commute, what’s not to love? More detailsListed by TRCG The Realty Consultants Group- TARREN NEWHOUSE
- 1 (306) 2614627
- Contact by Email
Data was last updated June 22, 2025 at 09: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