Whether you're searching for an affordable family home or a smart investment property in one of St. John's most desirable rental locations, 240 Freshwater Road is a must-see. Ideally situated directly across from the Farmers' Market and within walking distance of Memorial University, the Health Sciences Centre, Avalon Mall, grocery stores, restaurants, and numerous amenities, this property also offers convenient access to public transit right at your doorstep. The main level features a bright and functional layout with a spacious open concept living-dining-kitchen, full bathroom, and bedroom with an additional two bedrooms on the upper level. Hardwood flooring runs throughout much of the home, adding warmth and character. The lower-level in-law suite includes its own kitchen area, bedroom, bathroom, and living space, providing excellent potential for rental income, multigenerational living, or additional flexibility for homeowners. Recent improvements include a mini-split heat pump installed in 2026 for efficient heating and cooling, a beautifully remodeled main floor bathroom featuring a new tub and vanity (2025), and roof shingles replaced in 2024. Most windows have already been upgraded to vinyl, and there is also the option to install a wood stove for an additional heat source. Outside, you'll find a large fully fenced backyard complete with a storage shed, offering plenty of space for children, pets, gardening, or entertaining. The lot also provides the opportunity to create drive-in access to the backyard, adding even more versatility for future use. Cute, functional, affordable, and packed with potential, this detached 4-bedroom, 2-bathroom home offers an exceptional opportunity for homeowners and investors alike in a highly sought-after location. As per the Sellers Directive offers will not be presented until after 12:00pm on Tues July 7th with replies given by 5pm that same day. (id:60457)