Skip main navigation
For sale
  • C$474,900

    400 Clearview Row, Saint John, NB E2M 3Z1

    3beds
    1,795sqft
    Single Family Residence
    Built in ----
    1,812 Square Feet Lot
    $-- Zestimate®
    C$265/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.
    70 days
    |
    23
    |
    0
    |

    Zillow last checked: 8 hours ago

    Listing updated: November 26, 2025 at 07:30am

    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$265/sqft
    • Annual tax amount: C$3,959
    • Date on market: 10/1/2025
    • Ownership: Freehold
    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

    Price history is unavailable.

    Public tax history

    Public tax history
    Tax history is unavailable.

    Climate risks

    Neighborhood: E2M

    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
    • Loading