NOT LISTED FOR SALE

400 Lakeview Dr Summerville, SC 29485

Estimated Value: $829,598 - $877,000

5 Beds
3.5 Baths
4,200 Sq Ft
$203/Sq Ft Est. Value

Last Sold January 10, 2024

Last sale price $775,000 $185 Per Sq Ft

Est. 10% increase in value since last sale

Current estimated payment $4,927/month

65 Days on Market

Highlights

  • River Front
  • Two Primary Bedrooms
  • Lagoon View
  • Beech Hill Elementary School Rated A
  • Sitting Area In Primary Bedroom
  • 1.2 Acre Lot

About This Home

As of January 2024

Welcome to this captivating, fully renovated classic brick exterior home nestled along the tranquil shores of a tidal creek leading to the Ashley River. This magnificent property spans over an acre of lush, picturesque land. As you step inside, you'll be enchanted by the perfect blend of classic charm and modern elegance. The interior has undergone a remarkable transformation, featuring a brand-new kitchen layout with top-of-the-line cabinets, countertops, and appliances. Remarkably, many cherished elements of the home have been preserved, including the brick foyer floor, exquisite crown moldings, and the resplendent hardwood floors.The heart of the home is the open-concept kitchen, complete with a beautiful island, offering a seamless connection to the spacious living room adorned with an original brick fireplace and hearth. For those special occasions, the formal dining room provides ample space for your largest family gatherings.

The main level also boasts a luxurious owner's suite, featuring a cozy sitting area and abundant space. The remodeled owner's bathroom is a true sanctuary with a walk-in shower, water closet, and a double-sink vanity. But that's not all; wait until you see the size of the walk-in closet - it's a dream come true.

Upstairs, discover four additional bedrooms, including a second owner's suite with a private bathroom, offering versatility for your family's needs. Convenience meets functionality with the spacious walk-in laundry room and a mudroom designed for everyday living.

The crowning jewel of this remarkable home is the breathtaking view of the tidal creek from your private deck. Whether you're sipping your morning coffee or watching the sunset, the vistas are truly endless.

From the moment you set foot on the full front porch adorned with two-story columns, overlooking the rolling landscape leading to the marsh front, you'll fall head over heels for this Southern classic. This is a one-of-a-kind opportunity to own a piece of history seamlessly melded with modern luxury.

Don't miss your chance to make this extraordinary property your new home.

Last Agent to Sell the Property

Jay Law

The Real Estate Firm License #17153 Listed on: 09/15/2023

Last Buyer's Agent

Dawn Marquez

The Boulevard Company License #82136

The Boulevard Company

Home Details

Home Type

  • Single Family

Year Built

  • Built in 1978

Lot Details

  • 1.2 Acre Lot
  • Property fronts a marsh
  • River Front
  • Elevated Lot
  • Level Lot
  • Wooded Lot
  • Tidal Wetland on Lot

Parking

  • 2 Car Attached Garage
  • Garage Door Opener
  • Off-Street Parking

Home Design

  • Colonial Architecture
  • Traditional Architecture
  • Brick Exterior Construction
  • Brick Foundation
  • Asphalt Roof

Interior Spaces

  • 4,200 Sq Ft Home
  • 2-Story Property
  • Smooth Ceilings
  • High Ceiling
  • Ceiling Fan
  • Wood Burning Fireplace
  • Entrance Foyer
  • Family Room with Fireplace
  • Great Room with Fireplace
  • Living Room with Fireplace
  • Formal Dining Room
  • Den with Fireplace
  • Bonus Room
  • Game Room
  • Utility Room with Study Area
  • Laundry Room
  • Lagoon Views
  • Crawl Space

Kitchen

  • Eat-In Kitchen
  • Kitchen Island

Flooring

  • Wood
  • Ceramic Tile

Bedrooms and Bathrooms

  • 5 Bedrooms
  • Sitting Area In Primary Bedroom
  • Double Master Bedroom
  • Split Bedroom Floorplan
  • Dual Closets
  • Walk-In Closet

Outdoor Features

  • Balcony
  • Deck
  • Front Porch

Schools

  • Beech Hill Elementary School
  • East Edisto Middle School
  • Ashley Ridge High School

Utilities

  • Central Air
  • Heating Available
  • Cable TV Available

Community Details

Overview

  • Ashborough Subdivision

Recreation

  • Tennis Courts
  • Community Pool
  • Park
  • Trails

Home Details

Home Type

Single Family

Year Built

Built in 1978

Lot Details

1.2 Acres

Parking

2

Listing Details

  • Prop. Type: Residential
  • Architectural Style: Colonial, Traditional
  • Year Built: 1978
  • Property Sub Type: Single Family Detached
  • Lot Size Acres: 1.2
  • Subdivision Name: Ashborough
  • Directions: From Dorchester Rd. Turn Left Onto Nantucket Dr. Turn Right Onto Mayfield St. Turn Left Onto Lakeview Dr. Home Will Be On The Right.
  • Carport Y N: No
  • Garage Yn: Yes
  • Unit Levels: Two
  • New Construction: No
  • Property Attached Yn: No
  • Building Stories: 2
  • Special Features: None
  • Stories: 2

Interior Features

  • Full Bathrooms: 3
  • Half Bathrooms: 1
  • Total Bedrooms: 5
  • Entry Location: Ground Level
  • Fireplace Features: Den, Family Room, Great Room, Living Room, One, Other (Use Remarks), Wood Burning
  • Fireplaces: 1
  • Fireplace: Yes
  • Flooring: Ceramic Tile, Other, Wood
  • Interior Amenities: Ceiling - Smooth, High Ceilings, Kitchen Island, Walk-In Closet(s), Ceiling Fan(s), Bonus, Eat-in Kitchen, Family, Formal Living, Entrance Foyer, Game, Great, Office, Other (Use Remarks), Pantry, Separate Dining, Study, Utility
  • Master Bedroom Features: Ceiling Fan(s), Dual Masters, Multiple Closets, Sitting Room, Split, Walk-In Closet(s)
  • Master Bedroom Master Bedroom Level: Lower,Upper

Exterior Features

  • Roof: Asphalt
  • Lot Features: 1 - 2 Acres, High, Level, Wooded
  • Waterfront Features: Lagoon, Marshfront, River Front, Tidal Creek, Waterfront - Shallow
  • Waterfront: Yes
  • Construction Type: Brick, Brick Veneer
  • Exterior Features: Balcony
  • Foundation Details: Crawl Space
  • Other Structures: None
  • Patio And Porch Features: Deck, Front Porch, Porch - Full Front

Garage/Parking

  • Attached Garage: Yes
  • Covered Parking Spaces: 2
  • Garage Spaces: 2
  • Parking Features: 2 Car Garage, Attached, Off Street, Other (Use Remarks), Garage Door Opener
  • Total Parking Spaces: 2

Utilities

  • Cooling: Central Air
  • Laundry Features: Laundry Room
  • Cooling Y N: Yes
  • Heating: Electric
  • Heating Yn: Yes
  • Sewer: Public Sewer
  • Utilities: Dominion Energy, Dorchester Cnty Water and Sewer Dept
  • Water Source: Public

Condo/Co-op/Association

  • Community Features: Central TV Antenna, Other, Park, Pool, Tennis Court(s), Trash, Walk/Jog Trails

Schools

  • Elementary School: Beech Hill
  • High School: Ashley Ridge
  • Middle Or Junior School: East Edisto

Lot Info

  • Lot Size Sq Ft: 52272
  • ResoLotSizeUnits: Acres

Ownership History

Date Name Owned For Owner Type

Purchase Details

Closed on
Aug 6, 2025
Sold by
Bourque St-Hilaire Pierre-Luc and Bourque Megan St-Hilaire
Bought by
St-Hilaire Living Trust and St-Hilaire
Current Estimated Value
$852,900

Purchase Details

Listed on
Sep 15, 2023
Closed on
Jan 6, 2024
Sold by
Dryfuss Christine Elise
Bought by
St-Hilaire Megan and St-Hilaire Pierre-Luc Bourque
Seller's Agent
Jay Law
The Real Estate Firm
Buyer's Agent
Dawn Marquez
The Boulevard Company
List Price
$815,000
Sold Price
$775,000
Premium/Discount to List
-$40,000
-4.91%
Views
248

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
4.45%
Original Mortgage
$715,000
Interest Rate
7.22%
Mortgage Type
New Conventional

Purchase Details

Closed on
Dec 10, 2019
Sold by
Newton Frederick J and Newton Leeanne B
Bought by
Dryfuss Christine Elise

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$352,867
Interest Rate
3.7%
Mortgage Type
Construction

Purchase Details

Closed on
Aug 1, 2003
Sold by
Vanmeter Wavey and Vanmeter Dorothy
Bought by
Newton Frederick J and Newton Leeanne B
Source: Public Records

Range of Values:

--
Value Increase
--
Percent Increase
--
Adjusted for Inflation
Collateral Analytics

Collateral Analytics Collateral Analytics AVMs (Automated Valuation Model) employ a number of statistical approaches combined with neighborhood-specific comparable selection guarantees the most up-to-date and precise valuations.

Not Available

Collateral Analytics does not have data for the current month. Please view the chart for historical values.

ICE

ICE Mortgage Technology ICE Mortgage Technology’s AVM (Automated Valuation Model) is a state-of-the-art online residential property valuation tool that provides a quick and accurate estimate of the value of almost any home in the U.S.

Not Available

ICE Mortgage Technology does not have data for the current month. Please view the chart for historical values.

First American

First American First American Data & Analytics’ next-generation AVM combines unrivaled data assets with a blended ensemble of valuation models to produce highly accurate, reliable valuations you can trust.

Not Available

First American does not have data for the current month. Please view the chart for historical values.

Quantarium

Quantarium Quantarium’s valuation service, repeatedly proven the industry’s most accurate and comprehensive, is supercharged with a self-learning and auto-tuning AI engine that continually becomes smarter and more accurate as it processes daily inputs from the industry’s leading RE data lake.

Not Available

Quantarium does not have data for the current month. Please view the chart for historical values.

Average Value
Not Available
List Price
Sold Price
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Purchase History

Date Buyer Sale Price Title Company
St-Hilaire Living Trust -- None Listed On Document
St-Hilaire Living Trust -- None Listed On Document
St-Hilaire Megan $775,000 None Listed On Document
Dryfuss Christine Elise $255,000 None Available
Newton Frederick J $327,500 --
Source: Public Records

Mortgage History

Date Status Borrower Loan Amount
Previous Owner St-Hilaire Megan $715,000
Previous Owner Dryfuss Christine Elise $352,867
Source: Public Records

Property History

Date Event Price List to Sale Price per Sq Ft
01/10/2024 01/10/24 Sold $775,000 -3.0% $185 / Sq Ft
10/31/2023 10/31/23 Price Changed $799,000 -2.0% $190 / Sq Ft
09/22/2023 09/22/23 For Sale $815,000 -- $194 / Sq Ft
Source: CHS Regional MLS

Tax History

Year Tax Paid Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. Land Improvement
2025 $5,277 $30,991 $8,000 $22,991
2024 $3,694 $26,982 $8,000 $18,982
2023 $3,694 $27,957 $6,900 $21,057
2022 $10,236 $27,960 $6,900 $21,060
2021 $10,236 $27,960 $6,900 $21,060
2020 $9,956 $13,500 $3,200 $10,300
2019 $2,407 $13,500 $3,200 $10,300
2018 $2,192 $13,500 $3,200 $10,300
2017 $2,177 $13,500 $3,200 $10,300
2016 $2,164 $13,500 $3,200 $10,300
2015 $2,156 $13,500 $3,200 $10,300
2014 $2,054 $330,395 $0 $0
2013 -- $13,220 $0 $0
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
See All Agents

Map

Source: CHS Regional MLS

MLS Number: 23021237

CHS Regional MLS

APN: 161-02-06-001

Your Personal Tour Guide

Ask me questions while you tour the home.