$1,200,000
SOLD JUN 11, 2026
Last list price
6 Beds
6.5 Baths
7,523 Sq Ft
1.75 Acre Lot

Sale Details

Date Sold: June 11, 2026

$160 Per Sq Ft

7 Days on Market

Highlights

  • Guest House
  • Property fronts a bayou
  • 1.75 Acre Lot
  • Broadmoor Elementary School Rated A-
  • Cabana
  • Deck

About This Home

As of June 2026

Welcome to 207 Farmington, an exceptional waterfront residence located in the heart of Lafayette. This one-of-a-kind property seamlessly blends timeless character with upscale outdoor living, offering a rare opportunity to own a true retreat within city limits.Positioned with the river directly behind the home, the property captures serene water views and a sense of privacy that is hard to find. The backyard is designed for resort-style living, featuring a stunning in-ground infinity pool overlooking the water, a well-appointed gazebo, and expansive space ideal for entertaining or relaxing in a peaceful setting.Inside, the home is rich in character with beautiful antique doors that add warmth, charm, and architectural interest throughout. Generous living spaces provide both comfort and functionality, while a private mother-in-law suite offers flexibility for guests, extended family, or multi-generational living.With its unique combination of waterfront access, luxury outdoor amenities, and distinctive design elements, this property stands out as a rare offering in Lafayette. Conveniently located near shopping, dining, and everyday conveniences, it delivers both tranquility and accessibility.This exceptional home is truly a must-see for those seeking luxury, character, and a premier waterfront lifestyle.Preferred Lender offering $8,000 in CC

Last Agent to Sell the Property

Forrest Sillavan

Real Broker, LLC License #0995699512 Listed on: 04/02/2026

Real Broker, LLC

Co-Listed By

Chelsie Sillavan

Real Broker, LLC License #995710080

Last Buyer's Agent

Trish Adler

Keller Williams Realty Acadiana License #59427

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 Details

Home Type

  • Single Family

Year Built

  • Built in 1998

Lot Details

  • 1.75 Acre Lot
  • Property fronts a bayou
  • Partially Fenced Property
  • Landscaped
  • Sloped Lot

HOA Fees

  • $32 Monthly HOA Fees

Parking

  • 4 Car Garage
  • Open Parking

Home Design

  • Traditional Architecture
  • Slab Foundation
  • Frame Construction
  • Siding
  • Stucco

Interior Spaces

  • 7,523 Sq Ft Home
  • 2-Story Property
  • Wet Bar
  • Built-In Features
  • Built-In Desk
  • Bookcases
  • Crown Molding
  • Vaulted Ceiling
  • 2 Fireplaces
  • Double Sided Fireplace
  • Gas Fireplace
  • Window Treatments
  • Property Views

Kitchen

  • Gas Cooktop
  • Microwave
  • Dishwasher
  • Kitchen Island
  • Granite Countertops
  • Tile Countertops
  • Trash Compactor
  • Disposal

Flooring

  • Wood
  • Brick
  • Carpet
  • Tile

Bedrooms and Bathrooms

  • 6 Bedrooms
  • Walk-In Closet
  • In-Law or Guest Suite
  • Multiple Shower Heads

Pool

  • Cabana
  • In Ground Pool
  • Gunite Pool
  • Outdoor Shower

Outdoor Features

  • Balcony
  • Deck
  • Covered Patio or Porch
  • Gazebo
  • Outdoor Storage

Additional Homes

  • Guest House

Schools

  • Broadmoor Elementary School
  • Edgar Martin Middle School
  • Lafayette High School

Utilities

  • Multiple cooling system units
  • Central Heating and Cooling System
  • Heating System Uses Natural Gas

Listing and Financial Details

  • Tax Lot 161-162

Community Details

Overview

  • Fernewood Subdivision

Recreation

  • Community Playground
  • Park

Home Details

Home Type

Single Family

Year Built

Built in 1998

Lot Details

1.75 Acres

HOA Fees

$32 per month

Parking

4

Listing Details

  • Property Sub Type: Single Family Residence
  • Prop. Type: Residential
  • Horses: No
  • Lot Size Acres: 1.75
  • Lot Size: IRREGULAR
  • Road Frontage Type: City Street
  • Co List Office Phone: 337-534-0555
  • Subdivision Name: Fernewood
  • Directions: From Johnston Street, head south on Ambassador Caffery Parkway toward the Johnston/Ambassador intersection. Just past the intersection, turn right into the Farmington subdivision (Farmington Drive).
  • Architectural Style: Traditional
  • Carport Y N: No
  • Garage Yn: Yes
  • Building Stories: 2
  • Year Built: 1998
  • List_136: 92.06215
  • Special Features: None
  • Stories: 2

Interior Features

  • Appliances: Dishwasher, Disposal, Gas Cooktop, Microwave, Refrigerator, Trash Compactor
  • Full Bathrooms: 6
  • Half Bathrooms: 1
  • Total Bedrooms: 6
  • Fireplace Features: 2 Fireplaces, Double Sided, Gas
  • Fireplaces: 2
  • Fireplace: Yes
  • Flooring: Brick, Carpet, Tile, Wood
  • Interior Amenities: High Ceilings, Bookcases, Built-in Features, Computer Nook, Crown Molding, Guest Suite, Kitchen Island, Multi-Head Shower, Varied Ceiling Heights, Vaulted Ceiling(s), Walk-In Closet(s), Wet Bar, Granite Counters, Tile Counters
  • Living Area: 7523
  • Window Features: Window Treatments

Exterior Features

  • Fencing: Partial
  • Lot Features: 1 to 2.99 Acres, Back Yard Access, Landscaped, Sloped, Views, Waterfront
  • Pool Features: Gunite, In Ground
  • Pool Private: Yes
  • View: Yes
  • Waterfront Features: Bayou/River
  • Waterfront: Yes
  • Disclosures: Property Disclosure
  • Exclusions: Other - See Remarks
  • Home Warranty: No
  • Construction Type: Other Siding, Stucco, Frame
  • Exterior Features: Balcony, Outdoor Shower
  • Foundation Details: Slab
  • Other Structures: Cabana, Gazebo, Guest House, Storage
  • Patio And Porch Features: Covered, Deck, Porch
  • Property Condition: Resale
  • Roof: Other

Garage/Parking

  • Covered Parking Spaces: 4
  • Garage Spaces: 4
  • Open Parking: Yes
  • Parking Features: Garage Faces Side
  • Total Parking Spaces: 4

Utilities

  • Cooling: Multi Units, Central Air
  • Cooling Y N: Yes
  • Heating: Central, Natural Gas
  • Heating Yn: Yes
  • Electric: Elec: City
  • Electricity On Property: Yes
  • Sewer: Public Sewer
  • Gas Company: Gas: Atmos

Condo/Co-op/Association

  • Community Features: Acreage, Park, Playground
  • Association Fee: 389
  • Association Fee Frequency: Annually
  • Association: Yes

Schools

  • Elementary School: Broadmoor
  • Junior High Dist: Lafayette Parish
  • High School: Lafayette
  • Middle Or Junior School: Edgar Martin

Lot Info

  • Lot Size Sq Ft: 76230

Tax Info

  • Tax Lot: 161-162

Ownership History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Name Owned For Owner Type

Purchase Details

Listed on
Apr 2, 2026
Closed on
Jun 11, 2026
Sold by
Donald Lein
Bought by
Seller's Agent
Forrest Sillavan
Real Broker, LLC
Buyer's Agent
Trish Adler
Keller Williams Realty Acadiana
List Price
$1,200,000
Views
52

Home Financials for this Owner

Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-1.96%
Source: Public Records

Home Values in the Area

Source: Public Records

Average Home Value in this Area





Source: Public Records

Agents Specializing in Acadiana Wood, LA

See All Agents

Purchase History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Type Sale Price Title Company
Deed $1,200,000 None Listed On Document
Source: Public Records

Property History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

Date Event Price List to Sale Price per Sq Ft
06/11/2026 06/11/26 Sold -- -- --
04/09/2026 04/09/26 Pending -- -- --
04/02/2026 04/02/26 For Sale $1,200,000 -- $160 / Sq Ft
Source: REALTOR® Association of Acadiana

Tax History

We collect this data history from publicly available records. To have your information removed, we recommend requesting removal directly through your county’s website.

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 $12,892 $123,930 $40,942 $82,988
2024 $12,384 $123,891 $40,942 $82,949
2023 $12,384 $120,136 $40,942 $79,194
2022 $12,570 $120,136 $40,942 $79,194
2021 $12,613 $120,136 $40,942 $79,194
2020 $12,570 $120,136 $40,942 $79,194
2019 $9,283 $120,136 $40,942 $79,194
2018 $11,628 $120,136 $40,942 $79,194
2017 $11,614 $120,136 $40,942 $79,194
2015 $9,851 $115,744 $36,550 $79,194
2013 -- $102,951 $30,420 $72,531
Source: Public Records

Agents Affiliated with this Home

  • Section Image
  • Section Image
  • Section Image
See All Agents

Map

Source: REALTOR® Association of Acadiana

MLS Number: 2600002793

REALTOR® Association of Acadiana

APN: 6085335

Your Personal Tour Guide

Ask me questions while you tour the home.