Saint John, New Brunswick

Welcome to 55-57 Broadway Avenue! Situated east, this 4-family is on the bus route, is close to many amenities and has easy access to the highway. This 4-unit has plenty of off street parking is on a 1/4 acre lot. With good sized units, electric heat and some long-term tenants, this is a solid investment building that is well worth a look. Rents are $907.53, $995, $1025 and $1220. Total rental income: $49,770. Laundry Income: $840. Approx. expenses are: Snow: $840, Electricity: $2908 Water/Sewer: 1404, Insurance: $2233 and Taxes: $5627. Approx. total expenses - $13,012. Approx. Net Income: $37,598 (id:41243)

St George, New Brunswick

This beautifully updated home delivers the perfect blend of modern design, clean lines, and functional living. From the moment you enter, youre welcomed by a bright, open-concept main level designed for both everyday comfort and effortless entertaining. The spacious kitchen comes fully equipped with appliances and flows seamlessly into a light-filled living room, creating an inviting, cohesive space. Three bedrooms are located on the main level, including a standout primary suite featuring generous proportions and a striking tiled ensuite. Two additional bedrooms and a well-appointed 3-piece bath with the laundry discreetly tucked away in the mud room complete this level. The fully finished walk-out lower level offers exceptional versatility with a large family room, dedicated storage space ideal for pantry or seasonal closet space and a spacious utility room offers potential for a third bathroom. A flexible bonus area provides options ..currently used as an incredible home gym this fourth bedroom could be easily converted back if required or would make an amazing office space as well. With its separate access and smart layout, the lower level presents excellent potential for an in-law suite or income opportunity . Stylish, modern, and move-in ready this home stands out. Book your private showing TODAY! *Please Note: Vacant lots on both sides of this home are available to purchase should additional space be required* (id:41243)

Quispamsis, New Brunswick

Welcome to Cedar Ridge Park, one of the area's most sought-after neighbourhoods! This spacious split-entry home features a bright eat-in kitchen, inviting living room, three bedrooms, and a full bathroom. Step through the patio doors onto your private deck overlooking a huge, completely secluded backyard! An ideal space for relaxing and entertaining. The lower level provides incredible flexibility with an additional room for an office/guest space, a large family room, laundry area, storage, half bath, and a convenient walk-out access to the attached double car garage. Located within walking distance to shops, restaurants, and everyday amenities, with quick highway access for an easy commute, this home offers the lifestyle you've been looking for. (id:41243)

Saint John, New Brunswick

Welcome to 117 Downsview Drive, a place where comfort, community and nature come together to create the perfect forever home. Nestled in one of West Saint John's most sought-after family neighbourhoods, this beautifully maintained 4-level side-split bungalow offers a lifestyle that is becoming increasingly rare. With no overhead electrical wires, peaceful streets, nearby walking trails, excellent schools & convenient access to amenities, this is a community where neighbours know each other, children play safely & pets are welcomed with open arms. Step inside to a warm & inviting living room that flows seamlessly into a spacious dining area & kitchen, creating the perfect setting for family gatherings & everyday living. Lovingly cared for by its current owners, this home reflects pride of ownership throughout, with numerous upgrades designed for comfort & efficiency. The second level features three generous bedrooms & a full bathroom highlighted by a skylight that fills the space with natural light. The primary bedroom offers a peaceful retreat at the end of the day & comes with a private ensuite. On the third level, you'll find an additional bedroom, a cozy family room with a fireplace (WETT Certified) for relaxing winter evenings, plus a powder room & convenient laundry area. The fourth level provides endless possibilitieswhether you envision a recreation room, home gym, hobby space or play area. Outside, the private enclosed deck is ideal for summer barbecues, entertaining friends, or simply enjoying quiet moments surrounded by nature. Energy-efficient heat pumps, newer appliances, architectural shingles & an energy audit that helped reduce utility costs by nearly half add tremendous value & peace of mind. Come experience the warmth, tranquility & sense of belonging that make 117 Downsview Drive so special. Total Sq Footage is 2357 sq ft. Vendor is related to listing agent who is a Licensed REALTOR® in New Brunswick. Some Photos have been Virtually Staged. (id:41243)

Grand Bay-Westfield, New Brunswick

Welcome to Grand Bay-Westfield, where river views, outdoor living, and exceptional workshop space come together in one standout property. The showpiece is the newly built 28' x 36' detached garage, designed for serious hobbyists and professionals. With 13-foot ceilings, HOIST-ready construction, R-20 insulation, a 100-amp panel, and 2x6 exterior walls, this garage offers unmatched strength, efficiency, and versatility a rare premium feature that sets this property apart. Set on just over half an acre, the home enjoys beautiful views of the Saint John River and sits directly across from beach access, making it easy to enjoy the shoreline. Youre also just minutes from the Brundage Point River Centre, offering public river access and a boat launch, and a one minute drive to the Westfield Golf & Country Club. Inside, the home features a bright, functional kitchen with a newer fridge and dishwasher, plus a lovely view from the sink. The main level includes two comfortable bedrooms and a full bath. Downstairs, the primary bedroom with its own plumbed ensuite provides an excellent opportunity to finish the space to your taste, along with a large bonus area ideal for a family room, office, gym, or guest suite. This property offers the rare combination of a premium garage, water-view lifestyle, and room to grow, all in a peaceful, scenic setting close to everything Grand Bay-Westfield has to offer. (id:41243)

Saint John, New Brunswick

Welcome to 91 Westgate Drive, located in the highly sought after Westgate Park neighbourhood, one of the West Sides most desirable areas for young families. This beautifully maintained home offers an inviting layout, excellent living space, and a warm, airy feel throughout. The home features a double paved driveway leading to an attached single garage, along with a spacious mudroom entry that provides excellent everyday functionality. Adjacent to the mudroom is a versatile bonus room that could serve as a home office, playroom, guest space, separate TV room, or potential fourth bedroom for extended family living. The large eat in kitchen offers an abundance of cupboard and counter space, a pantry, and a beautiful subway tile backsplash. The dining area opens directly onto the rear deck overlooking the partially fenced backyard, where you can enjoy excellent privacy, evening sun, and a large storage shed. A spacious formal living room with a bay window creates a bright and welcoming atmosphere, while quality vinyl flooring flows throughout much of the home. The main level also includes convenient laundry, additional storage space, and a large rec room or family TV room complete with a cozy wood stove. Upstairs, youll find three bedrooms including a generous primary bedroom with walkout access to a private elevated deck. The recently renovated bathroom adds a fresh and modern touch to the upper level. With its open stairwell, airy feel, flexible layout, and evident pride of ownership throughout, this is a truly beautiful home in an exceptional family friendly location. (id:41243)

Saint John, New Brunswick

Looking for a low-maintenance new construction home in Saint John NB? 53 Rockingstone Drive offers modern garden home living on the west side of Saint John, located in the growing Fallsview subdivision close to shopping, restaurants, walking trails, and everyday amenities. This brand-new corner unit offers added privacy along with a bright open-concept layout designed for comfortable everyday living. The kitchen, dining, and living areas are filled with natural light, creating a warm and functional space perfect for entertaining or relaxing at home. The main level features 2 bedrooms and a full bathroom, providing convenient one-level living, while the partially finished basement adds valuable bonus space for a rec room, home office, gym, or additional storage. Step directly from the living room onto the back deck and enjoy outdoor space that feels like a natural extension of the home. An attached single-car garage adds extra convenience and storage. Move-in ready and thoughtfully designed, this property is a great option for downsizers, first-time buyers, or anyone looking for modern, low-maintenance living in a desirable west Saint John neighbourhood. (id:41243)

St George, New Brunswick

Welcome to this warm and inviting four-bedroom, one-and-a-half bath character home located in the heart of St. George, New Brunswick. A property that blends timeless charm with everyday functionality. From the moment you arrive, the homes classic exterior, bay windows, and welcoming presence set the tone for whats inside. Step through the door to discover spacious living areas filled with natural light, original details, and the character that only a historic home can offer. The main level features a bright kitchen, comfortable living and dining spaces, and flexible rooms perfect for family life, entertaining, or working from home. Upstairs, youll find four generously sized bedrooms, a large landing area, and a beautifully sized bathroom featuring a relaxing clawfoot tub that enhances the homes charm. Outside, the property continues to impress with a large yard ideal for kids, pets, and gardening, along with a beautiful deck perfect for summer gatherings, morning coffee, or evening relaxation. Additional outbuilding provides extra storage. Situated in a convenient location close to amenities, schools, and the coastal beauty that makes St. George so desirable, this home offers space, character, and lifestyle in one package. Whether youre searching for a family home, a property with personality, or a place to put down roots, this charming residence is ready to welcome its next owners. (id:41243)

Welsford, New Brunswick

Set on 2.75 acres in Welsford, this beautifully renovated property offers space, flexibility, and the peaceful lifestyle many buyers are searching for. The main level features three comfortable bedrooms, a full bathroom, and bright, welcoming living spaces designed for everyday living. Just off the dining area, a spacious deck provides the perfect spot to enjoy your morning coffee, host summer barbecues, or take in the surrounding views. Downstairs, you'll find a separate one-bedroom, one-bathroom living area complete with its own entrance and walkout, creating excellent potential for rental income, multigenerational living, or a private guest suite. The oversized garage is a standout feature, offering plenty of room for a workshop, vehicle storage, hobbies, or anyone who enjoys working on cars. With ample outdoor space to explore, garden, entertain, or simply relax and enjoy the surroundings, this property offers endless possibilities. Whether you're looking for a family home with added income potential or extra space to pursue your passions, this versatile property is ready to welcome its next owners. (id:41243)

Quispamsis, New Brunswick

Situated on a well kept mature, private lot, this 3 level home with attached double garage has much to offer. A large foyer from front door to back walkout to yard is spacious, with loads of Coat hanging space and also a 1/2 bath. up to the eat in kitchen leads to an upgraded kitchen with patio doors to the outside deck area, and upper deck to the above ground pool. Living room is also on this level .The upper level has 3 bedrooms and a main bath. Newer windows thoughout. the third lev, just steps down from the kitchen el offers presents a family room, 4th bedroom , and laundry room area. under the first level is plenty of accessible storage space. With newer light fixtures, refinished flooring and fresh paint, you can make this home your own. 2 heat pumps, and an oversized garage (28x32) insulated and dry walled-just suited for cars and storage. Newer front deck offers great outdoor area to enjoy a coffee and watch over the quiet neighbourhood. (id:41243)

Bocabec, New Brunswick

Here is a rare waterfront opportunity on Kerrs Ridge Road in beautiful Bocabec, NB. Set on 2.69 acres in a quiet, peaceful location just 15 minutes from St. Andrews By the Sea, this turn key property offers exceptional privacy, stunning sunset views, and direct access to the Bocabec River. The property features two newly built, identical one bedroom cottages, each thoughtfully designed for comfort and efficiency. Both cottages include a bright kitchen, dining area, living room, full bathroom, and a well proportioned bedroom. Quality craftsmanship is evident throughout, and both cottages come fully furnished with all new appliancesfridge, stove, washer, and dryermaking this a seamless move in or rental ready opportunity. The metal roof and wood siding should make these cottages maintenance free for years to come. Whether youre seeking a serene retreat, a multi unit investment with the option and room to add more cottages, a family getaway or looking to downsize with passive income, this property delivers unmatched versatility. Enjoy the expansive acreage, the natural beauty of the riverfront, and the peaceful surroundings that define life here. With incredible water views, modern accommodations, and true turn key convenience, this waterfront gem is ready to be enjoyed from day one. Call today for additional information or to schedule a private viewing of this incredible waterfront opportunity. (id:41243)

Bocabec, New Brunswick

Here is a rare waterfront opportunity on Kerrs Ridge Road in beautiful Bocabec, NB. Set on 2.69 acres in a quiet, peaceful location just 15 minutes from St. Andrews By the Sea, this turn key property offers exceptional privacy, stunning sunset views, and direct access to the Bocabec River. The property features two newly built, identical one bedroom cottages, each thoughtfully designed for comfort and efficiency. Both cottages include a bright kitchen, dining area, living room, full bathroom, and a well proportioned bedroom. Quality craftsmanship is evident throughout, and both cottages come fully furnished with all new appliancesfridge, stove, washer, and dryermaking this a seamless move in or rental ready opportunity. The metal roof and wood siding should make these cottages maintenance free for years to come. Whether youre seeking a serene retreat, a multi unit investment with the option and room to add more cottages, a family getaway or looking to downsize with passive income, this property delivers unmatched versatility. Enjoy the expansive acreage, the natural beauty of the riverfront, and the peaceful surroundings that define life here. With incredible water views, modern accommodations, and true turn key convenience, this waterfront gem is ready to be enjoyed from day one. Call today for additional information or to schedule a private viewing of this incredible waterfront opportunity. (id:41243)

Quispamsis, New Brunswick

Well-Maintained Family Home on a Large Corner Lot Located just off Vincent Road, this well-cared-for one-owner home sits on a spacious corner lot surrounded by mature trees and a beautifully manicured lawn. Offering 3 bedrooms and 2 bathrooms, the property has benefited from numerous upgrades over the years, including updated windows, roof improvements, vinyl siding and the addition of an energy-efficient heat pumps. The main level features a bright eat-in kitchen and comfortable living spaces designed for everyday family living. Downstairs, you'll find a large entertainment area complete with a pool table, a dedicated man cave, a laundry room/ full bathroomproviding excellent flexibility for recreation and guests. Outdoor living is equally impressive, with a wrap-around deck that's perfect for relaxing or entertaining. A storage shed offers additional space for tools and seasonal equipment. Proudly maintained by its original owner, this property combines space, comfort, and pride of ownership in a desirable location. (id:41243)

Grand Manan, New Brunswick

When Viewing This Property On Realtor.ca Please Click On The Multimedia or Virtual Tour Link For More Property Info. This unique property on Grand Manan Island offers a thriving business and a cozy home in one location. It features one of the islands busiest convenience stores, a community staple with a wide range of products, from hot and cold food to everyday essentials. With a fully equipped commercial kitchen, theres great potential to expand food offerings or create your own specialties. The store enjoys strong community rapport and a loyal customer base. Next door, the spacious detached home includes three bedrooms, one bath, a large living room with high ceilings, a family room, and plenty of utility and storage space. It provides privacy and convenience, just steps away from the business. You can buy the whole package, including both the store and the house, or just the convenience store. Ample parking is available for customers and your family. (id:41243)

Chamcook, New Brunswick

Located only minutes from downtown St. Andrews By The Sea, in a quiet peaceful rural setting on the Harkness Road, is this 33 acre property with a completely refurbished home, on a newly developed lot with a new drilled well and a new septic system. The home, which shows exceptionally well, provides one level living in a very comfortable and private setting so close to town. On the main level is a large convenient mudroom/laundry room, an open concept kitchen with built in appliances, a spacious living room, two bedrooms and a full bath. Multiple decks provide different locations for one to enjoy the shade or the sun. The home, sitting on a proper concrete frost wall with a crawl space below, shows as new and needs nothing. What truly sets this property apart is the expansive 33 acresan incredible opportunity rarely found this close to town. This package consists of six individual lots with the following PID#s 15217219, 15059587, 15217227, 15215205, 15215213, 15207616. Whether you envision a hobby farm, future investment, subdivision potential, or simply room to roam, the possibilities are endless. With the property already cleared around the home and the remaining acreage offering space, privacy, and flexibility, this property delivers unmatched value in a highly desirable location. Moments from St. Andrews, yet private and serene, this is a unique chance to secure land, lifestyle, and long-term potential all in one. This is an excellent opportunity to live in a very desirable location with huge potential only moments from St. Andrews. Call today for additional information or to schedule a private viewing. (id:41243)

St. Stephen, New Brunswick

Situated on a peaceful, quiet street, this charming two-storey home offers the perfect blend of space, comfort, and convenience for family living. Featuring four spacious bedrooms, two full bathrooms, a generous living room, and a formal dining room, theres plenty of room for everyone to gather and grow. Set on a double lot totaling approximately one-third of an acre, the property provides exceptional outdoor space. The expansive side yard creates an ideal recreation area for family activities, complete with mature shade trees that offer both beauty and comfort throughout the warmer months. Conveniently located within walking distance to the local elementary and middle schools, as well as the Garcelon Civic Center, this home combines tranquility with accessibility. Move-in ready and waiting for its next family, this wonderful property is a must-see. Contact your favorite REALTOR® today to schedule a private viewing. (id:41243)

Rothesay, New Brunswick

This 12 year old home is located at the end of Paige street, on an attractive corner lot, adjacent to a neighbouring cul-de-sac . The .33 acre property is nicely landscaped and offers treed privacy and shade at the rear of the lot. Yard area has a firepit, storage shed and room for a small garden! Relax or entertain on the large back deck. Patio door, as well as front door, provide entry to the home. Step into an open concept living space, where you can rest, cook or dine with ease and comfort. Front foyer, with closet for outerwear, is located in the living room. Dining area looks out onto the deck and yard. Kitchen has ample cupboards, with additional counter top space and storage provided by the two seat island. Hallway leads to the primary bedroom and a second bedroom. A full bath completes the living space on the main floor. Enclosed ""L' shaped staircase leads to the lower level of the home. Large family room provides opportunity for play room, movie room, rec room or office space. Three other bedrooms provide extra room needed by a large family! More storage space can be found in an extra room and a contained area under the stairs. Washer and dryer are conveniently located in the utility room. All kitchen and laundry appliances are remaining with the house. This is the home you have been searching for....a newer home in a desirable location, with lots of space inside and out to allow your family to thrive! Lovely neighbourhood, close to schools and amenities. Put the finishing touches on this home to make it your own! Don't miss this opportunity! Contact your favourite realtor today to schedule an appointment to see for yourself the possibilities that await at 26 Paige Street in Rothesay! (id:41243)

Saint John, New Brunswick

Looking for a low-maintenance new construction home in Saint John NB? 47 Rockingstone Drive offers modern garden home living in the growing Fallsview subdivision on the west side of Saint John, conveniently located close to shopping, restaurants, and everyday amenities. Designed with comfort and functionality in mind, this brand-new home features a bright open-concept kitchen, dining, and living area that creates an inviting space for both entertaining and everyday living. Large windows bring in plenty of natural light, adding to the warm and modern feel throughout the home. The main level offers 2 comfortable bedrooms and a well-finished bathroom, providing easy one-level living ideal for downsizers or buyers looking for convenience. The partially finished basement adds valuable extra space with potential for a rec room, home office, gym, or additional storage. Step directly from the living room onto the back deck and enjoy easy indoor-outdoor living during the warmer months. An attached single-car garage adds practicality and extra storage space. Move-in ready and thoughtfully designed, this property is a great option for first-time buyers, downsizers, or anyone looking for modern, low-maintenance living in west Saint John. (id:41243)

Grand Bay-Westfield, New Brunswick

Nestled just 10 minutes from Grand Bay-Westfield, this fully renovated home offers a rare opportunity to live in a serene and picturesque setting, with direct views of the Saint John River. Situated across from a sandy beach, enjoy endless recreation with a wharf ideal for swimming, fishing, and skating during the winter months. With the added bonus of a potential mooring right in front of your home, the possibilities for waterfront enjoyment are limitless. The home has been meticulously renovated from top to bottom, offering the perfect blend of modern convenience and charm. Every detail has been attended to, including brand-new plumbing, electrical, septic system, and siding. The windows and doors have been upgraded, ensuring energy efficiency and comfort. The exterior and interior lighting, trim, kitchen cupboards, countertop and flooring have all been thoughtfully selected to complement the homes stylish design. The property is just 7 minutes from easy highway access, and within walking distance to a convenience store and gas station for your convenience. Whether youre relaxing on the deck, enjoying the panoramic views, or taking advantage of the nearby outdoor activities, this home offers a lifestyle thats truly one-of-a-kind. Dont miss out on this rare waterfront gem! (id:41243)

Grand Bay-Westfield, New Brunswick

Please click on Virtual tour! Thousands of dollars in recent renovation's!!Very attractive raised 3 bedroom,3 bathroom bungalow which is situated on a rare triple wide beautifully landscaped lot reflecting 3 separate PID#s. Enter through the main floor entrance to a tiled foyer. Perfectly designed and used as a single family home with an in-law suite for out of town family visits or a potential income producer, or the gathering spot for the teenagers offering a large familyroom on this level with built in TV cabinet,generious size bedroom, beautifully updated 3/4 bathroom plus a full kitchen, all updated flooring, Easy access to the oversized heated double car garage with workshop/wired generator panel & 2nd man door in the garage leads to fenced garden area. The second level has a lovely bright open concept updated kitchen/dining/familyroom area over looking a relaxing park like setting side yard or through the patio doors to a very private sundeck perfect for those family gatherings and summertime BBQ. Another large bedroom and an updated full bathroom off the familyroom but lets complete this level with a large living room with hardwood floors and your Primary bedroom offering His and Her double closets with an upgraded full ensuite. All three pid# are adjacent to one another making it the size of three building lots which is rare in this locatiion.lovely fenced in area for a veggie garden or dogs. DEEDED Waterfront Beach rights just minutes away! Many updates and all appliances will remain. Accepting offers as they come!Please contact Jim or your favorite REALTOR® to view this home before its gone! (id:41243)

St. Stephen, New Brunswick

Welcome to easy, worry-free living in this beautifully maintained 3-bedroom, 2-bathroom townhouse-style condo located in one of the most desirable areas of St. Stephen. Enjoy peaceful water views and direct access to the scenic walking trail along the picturesque St. Croix River, which separates the charming border communities of St. Stephen and Calais. This bright and welcoming home offers the perfect blend of comfort, style, and low-maintenance living in a quiet residential setting. The kitchen features classic oak cabinetry, vinyl flooring, and a built-in dishwasher, providing both function and timeless appeal. The dining room, living room, and two main-floor bedrooms showcase beautiful oak hardwood flooring, all in excellent condition. The main living area is designed for relaxation, featuring a cozy gas fireplace and a charming bay window, creating the perfect atmosphere for comfortable evenings at home. The fully finished lower level adds exceptional living space with a large family room, additional bedroom, spacious walk-in closets, and a well-appointed bathroom complete with a whirlpool tub and corner showerideal for guests or extended family. Additional highlights include: Attached heated garage with laundry facilities Abundant closet space throughout Large basement storage room Direct access to walking trails and riverfront views. This immaculate condo offers a rare opportunity to enjoy convenience, comfort, and scenic surroundings all in one property. (id:41243)

Chance Harbour, New Brunswick

Wake up to breathtaking ocean views from this spacious 4-bedroom oceanfront home situated on a rare double lot. The main floor offers a large entryway and mudroom with convenient main-floor laundry. The bright eat-in kitchen features patio doors leading to an expansive deck overlooking the waterperfect for morning coffee, outdoor dining, or simply enjoying the ever-changing coastal scenery. A sun-filled, spacious living room with separated family room area provides a great space for the whole family to enjoy - would make a great space for the kids to play or game and still be close by. The separate formal dining room offers plenty of room for family gatherings and entertaining. The upper level features four generously sized bedrooms, including a stunning primary suite with a private ensuite and panoramic views of the ocean. Storage is abundant throughout the home, with closets everywhere to keep everything organized. Additional features include an oversized garage, two new owned heat pumps, and a durable metal roof for peace of mind. A beautifully landscaped property featuring mature lilacs and lupins, and a wonderful opportunity to enjoy oceanfront living with space, comfort, and spectacular views. Taxes and assessed value are inclusive for both parcels. (id:41243)

Saint John, New Brunswick

Welcome to a charming family home nestled in one of Saint John's most sought-after coastal communities. Perfectly positioned near Irving Nature Park, local beaches, and scenic walking trails, this property offers an exceptional blend of nature, convenience, and everyday comfort. Step inside to discover a bright and inviting main level featuring hardwood and ceramic flooring, a spacious living room, and a large eat-in kitchen complete with a center island and direct access to the rear deck ideal for family gatherings and summer entertaining. The main floor also offers three generously sized bedrooms, including a primary bedroom with double closets, as well as convenient main-floor laundry and a full bathroom. The fully finished lower level offers exceptional additional living space, featuring a large family room perfect for movie nights, a children's play area, or relaxing with family and friends. A spacious bonus room provides excellent flexibility as a home office, fitness room, hobby space, or guest accommodation. Completing the lower level is a full bathroom and ample storage space, adding both convenience and functionality to the home. Outside, enjoy beautiful mature landscaping with flowering shrubs and a peaceful setting just minutes from schools, daycare facilities, shopping, and recreation. Nature lovers will appreciate the nearby shoreline access, with multiple beaches within walking distance, walking trails, and opportunities for outdoor adventure right in the neighborhood. Whether you're looking for a family-friendly home or a peaceful retreat close to the city, this property offers the perfect balance of comfort, convenience, and space to enjoy for years to come. **Open House: June 28, at 2:30-4:00 PM** (id:41243)

St. Stephen, New Brunswick

3 Bedroom 2 bathroom bungalow with full basement only 7 years old (id:41243)