Tarren Newhouse

My Office Listings

19-24/66
  • 737 Gowan Road in Warman: Residential for sale : MLS®# SK012644

    737 Gowan Road Warman S0K 4S2
    Main Photo: 737 Gowan Road in Warman: Residential for sale : MLS®# SK012644
    $749,900
    Residential
    Status:
    Active
    MLS® Num:
    SK012644
    Bedrooms:
    5
    Bathrooms:
    3
    Floor Area:
    1,600 sq. ft.
    Welcome to this stunning walkout bungalow backing onto the park in Warman, where over $60,000 in recent upgrades have elevated this home into something truly special. From the moment you step inside, you’ll be impressed by the spacious layout, elegant finishes, and natural light throughout. The main floor features a grand front entrance, a high-end kitchen with an oversized island, and a warm, inviting living room with a gas fireplace. The large primary bedroom includes a luxurious five-piece ensuite, while a second bedroom, dedicated office space, main floor laundry, and a breathtaking deck overlooking the park complete the level. The walkout basement offers a spacious family room, games area with a bar, two generous bedrooms, and a full bathroom. The beautifully landscaped backyard includes a lower patio, stonework, and two storage sheds. A heated double garage with 10-foot ceilings adds practicality to the home’s charm. Upgrades include luxury vinyl plank flooring in the basement, new upgraded carpet on the main floor, solar-block tinted windows in the main floor living room,right side patio door as well as the basement family room right side, a custom front door, refreshed master bath with new taps and paint, front and lower decks, brick flowerbeds, and custom blinds in the basement. With its thoughtful design, serene park views, and turn-key updates, this home is the perfect blend of comfort and elegance — ready for you to move in and Enjoy. More details
    Listed by TRCG The Realty Consultants Group
  • 123 Katz Avenue in Saskatoon: Brighton Residential for sale : MLS®# SK010959

    123 Katz Avenue Brighton Saskatoon S7V 1S9
    Main Photo: 123 Katz Avenue in Saskatoon: Brighton Residential for sale : MLS®# SK010959
    $749,900
    Residential
    Status:
    Active
    MLS® Num:
    SK010959
    Bedrooms:
    2
    Bathrooms:
    2
    Floor Area:
    1,461 sq. ft.
    A Luxurious Bungalow with Park Views! Welcome to this stunning bungalow backing onto a beautiful park! This elegant home features two bedrooms, two bathrooms, and a versatile main-floor office/den. Step inside to a spacious living room with soaring coffered ceilings and a cozy electric fireplace, creating a warm and inviting atmosphere. The bright and airy kitchen is designed for both style and functionality, featuring a large island and a generous walk-in pantry. The master suite offers breathtaking park views, a three-piece ensuite with a tiled shower, and a walk-in closet conveniently connected to the laundry area. A well-designed mudroom leads to the oversized, insulated, and drywalled 22 x 24 garage. Additional highlights include 9-foot ceilings on both the main floor and in the basement, adding to the home's sense of space and comfort. Enjoy peaceful mornings and relaxing evenings in your northeast-facing backyard, complete with a covered deck overlooking the park. This move-in-ready home comes with all appliances and central air conditioning - just unpack and enjoy! Don't miss this rare opportunity - schedule your private viewing today! More details
    Listed by TRCG The Realty Consultants Group
  • 1405 490 2nd Avenue South in Saskatoon: Central Business District Residential for sale : MLS®# SK011635

    1405 490 2nd Avenue South Central Business District Saskatoon S7K 1M5
    Main Photo: 1405 490 2nd Avenue South in Saskatoon: Central Business District Residential for sale : MLS®# SK011635
    $739,900
    Residential
    Status:
    Conditional Sale
    MLS® Num:
    SK011635
    Bedrooms:
    2
    Bathrooms:
    2
    Floor Area:
    1,132 sq. ft.
    Wonderful 14th floor 2 bedroom corner unit with unreal panoramic views from the floor to ceiling windows. This unit comes equipped with all appliances, central air and heating, 1 underground parking spot and window coverings. This is a landmark building and location in Saskatoon and this unit offers a variety of uses. This location has it all! Outdoor activities, night life, restaurants and bars and of course direct access to the South Saskatchewan River and Meewasin Trails. The building amenities include: weight room, rec room, meeting room and secured entry system with front desk. Right out the main door are all the main attractions in Saskatoon along with restaurants, night life and so much more. More details
    Listed by TRCG The Realty Consultants Group
  • 1128 12TH Street East in Saskatoon: Varsity View Residential for sale : MLS®# SK012409

    1128 12TH Street East Varsity View Saskatoon S7H 0G2
    Main Photo: 1128 12TH Street East in Saskatoon: Varsity View Residential for sale : MLS®# SK012409
    $699,000
    Residential
    Status:
    Active
    MLS® Num:
    SK012409
    Bedrooms:
    3
    Bathrooms:
    2
    Floor Area:
    1,619 sq. ft.
    Prime Development Opportunity in Varsity View – 75’ x 140’ Lot! Exceptional potential in one of Saskatoon’s most sought-after neighbourhoods! This 75’ x 140’ lot (three 25’ parcels) offers an outstanding opportunity for future development—whether you envision three infill homes or a stylish multiplex. The lot features beautiful topography and elevation, ideal for future builds, possibly even a walkout. The existing home is well maintained and features two suites—perfect for holding as a rental until you’re ready to build. The main suite includes a bright, front-facing living room, kitchen and dining area at the rear, two spacious upstairs bedrooms, and a full 4-piece bath. The unfinished basement provides ample storage and houses the laundry. The attached 1-bedroom suite is cozy, self-contained, and located at ground level—ideal for a student or single tenant. Bright windows, a functional layout, and great views make it a charming and practical living space. Additional highlights include mature landscaping, lush lawn front and back, and an attached garage (not currently suitable for vehicle parking, but great for storage), and plenty of parking. Located just minutes from the University of Saskatchewan, downtown, 8th Street, and scenic river trails—this is a rare opportunity in a prime Varsity View location! More details
    Listed by TRCG The Realty Consultants Group
  • 186 Gillies Lane in Saskatoon: Rosewood Residential for sale : MLS®# SK012438

    186 Gillies Lane Rosewood Saskatoon S7V 0A7
    Main Photo: 186 Gillies Lane in Saskatoon: Rosewood Residential for sale : MLS®# SK012438
    $695,000
    Residential
    Status:
    Conditional Sale
    MLS® Num:
    SK012438
    Bedrooms:
    4
    Bathrooms:
    4
    Floor Area:
    1,687 sq. ft.
    Welcome to 186 Gillies Lane – a beautifully maintained 1,687 sq. ft. two-storey home situated on a desirable corner lot in the vibrant community of Rosewood. This charming property features great curb appeal with a covered front veranda and a double attached garage. Step inside to an inviting open-concept main floor, perfect for entertaining. The stunning kitchen boasts quartz countertops, a large peninsula island, stainless steel appliances, and plenty of cabinetry. The kitchen flows seamlessly into the spacious dining area and living room, which is highlighted by vaulted ceilings, an electric fireplace, and large windows that fill the space with natural light and offer a view of the backyard. A convenient mudroom and 2-piece bathroom complete the main level. Upstairs, you’ll find a generous primary bedroom with a walk-in closet and a 3-piece ensuite. Two additional bedrooms, a 4-piece bathroom, and a dedicated laundry room provide ideal function and comfort for family living. The fully finished basement offers even more space with a large family room, an additional bedroom, a 3-piece bathroom, and a utility/storage room. Enjoy your summers in your dream fully fenced backyard, complete with a spacious deck, natural gas BBQ hookup, lawn area, sandbox, trees, shrubs, and garden beds – the perfect outdoor retreat. Ideally located close to schools, parks, walking paths, and all the amenities Rosewood has to offer. Don’t miss your chance to call this exceptional home yours! More details
    Listed by TRCG The Realty Consultants Group
  • 3 3603 Kochar Avenue in Saskatoon: North Industrial SA Commercial for sale : MLS®# SK011983

    3 3603 Kochar Avenue North Industrial SA Saskatoon S7P 0B8
    Main Photo: 3 3603 Kochar Avenue in Saskatoon: North Industrial SA Commercial for sale : MLS®# SK011983
    $665,000
    Commercial
    Status:
    Conditional Sale
    MLS® Num:
    SK011983
    Build. Type:
    Low-Rise (3 floors and under)
    Floor Area:
    2,500 sq. ft.
    Condo unit is in exceptional condition and ready for possession. 2500 sf (25'x100') Interior build out of +/- 500 sf consisting of a board room, one private office and reception area. +/- 2000 sf warehouse. At the rear of the property +/- 2500 sf of secure fenced compound. More details
    Listed by TRCG The Realty Consultants Group
19-24/66
Data was last updated July 20, 2025 at 03:35 AM (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.