Skip main navigation
For sale
  • C$448,500

    400 Clearview Row, Saint John, NB E2M 3Z1

    3beds
    1,795sqft
    Single Family Residence
    Built in ----
    1,812 Square Feet Lot
    $-- Zestimate®
    C$250/sqft
    C$-- HOA

    What's special

    Large back deckTall privacy fenceHardwood floorsBrick fireplaceFormal dining roomBright kitchenSolid wood cabinets
    When Viewing This Property On Realtor.ca Please Click On The Multimedia or Virtual Tour Link For More Property Info. Welcome to 400 Clearview Row, a well-maintained family home in the prestigious Island View Heights neighborhood of Saint John. Ideally located just minutes from Uptown and East Saint John, this property offers both convenience and tranquility, with Island View School nearby and breathtaking water views of the Bay and Irving Nature Park from the living room, dining room, and bedrooms. Set on a half-acre lot, the home features an attached garage, double paved driveway, mature landscaping with majestic maples, a large back deck, and a tall privacy fence. Inside, the main level boasts hardwood floors, a spacious living room with brick fireplace, a formal dining room with patio doors to the deck, and a bright kitchen with solid wood cabinets, updated hardware, pantry, and modern backsplash. Three bedrooms, including the primary, and a renovated full bath complete this level. The finished basement extends the living space with a family room, sitting area with lighted bar, office, full bath with laundry, and interior garage access. With its charm, updates, and prime location, this home is a rare find in one of Saint John’s most sought-after communities.
    274 days
    |
    15
    |
    1
    |

    Zillow last checked:

    Listing updated:

    Listed by:

    Jonathan David, Agent Manager 136425,

    PG Direct Realty Ltd. Brokerage

    Source: New Brunswick Real Estate Board,MLS®#: NB127636

      Facts & features

      Interior

      Bedrooms & bathrooms
      • Bedrooms: 3
      • Bathrooms: 2
      • Full bathrooms: 2
      Bedroom
      • Level: Main
      Bedroom
      • Level: Main
      Other
      • Level: Main
      Other
      • Level: Main
      Other
      • Level: Lower
      Dining room
      • Level: Main
      Family room
      • Level: Lower
      Foyer
      • Level: Main
      Kitchen
      • Level: Main
      Living room
      • Level: Main
      Office
      • Level: Lower
      Utility room
      • Level: Lower
      Heating
      • Baseboard, Electric, Hot Water
      Cooling
      • Electric
      Appliances
      • Included: Water Heater
      Features
      • None
      • Flooring: Ceramic Tile, Laminate
      • Has fireplace: No
      Interior area
      • Total structure area: 1,795
      • Total interior livable area: 1,795 sqft
      • Finished area above ground: 900
      Video & virtual tour

      Property

      Parking
      • Total spaces: 2
      • Parking features: Asphalt, Width - Double, Garage
      • Has garage: Yes
      • Uncovered spaces: 2
      • Details: Garage Size(Attached)
      Lot
      • Size: 1,812 Square Feet
      • Features: Landscaped, Under 0.5 Acres
      Details
      • Parcel number: 00402552

      Construction

      Type & style
      • Home type: SingleFamily
      • Architectural style: Bungalow
      • Property subtype: Single Family Residence
      Materials
      • Vinyl Siding
      • Foundation: Concrete
      • Roof: Asphalt

      Utilities & green energy

      • Sewer: Municipal
      • Water: Municipal

      Community & HOA

      Location
      • Region: Saint John

      Financial & listing details

      • Price per square foot: C$250/sqft
      • Annual tax amount: C$3,959
      • Date on market: 10/1/2025
      • Ownership: Freehold
      Jonathan David, Agent Manager

      Jonathan David, Agent Manager

      (877) 709-0027

      By pressing Contact Agent, you agree that the real estate professional identified above may call/text you about your search, which may involve use of automated means and pre-recorded/artificial voices. You don't need to consent as a condition of buying any property, goods, or services. Message/data rates may apply. You also agree to our Terms of Use. Zillow does not endorse any real estate professionals. We may share information about your recent and future site activity with your agent to help them understand what you're looking for in a home.

        Price history

        Price history is unavailable.

        Public tax history

        Tax history is unavailable.

        Climate risks

        Neighborhood: E2M

        Getting around

        22 / 100
        Car-Dependent
        36 / 100
        Somewhat Bikeable

        Nearby schools

        GreatSchools rating

        No schools nearby

        We couldn't find any schools near this home.

        Similar homes

        Skip to the end of the carouselSkip to the beginning of the carousel