$1,200,000

207 Farmington Drive, Lafayette, LA 70503

6 beds |
7 baths |
7,523 sqft

Single-Family Home
Built in 1998
1.75acre lot
4 car garage
$160/sqft
Listed 2 days ago

Property Description

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

Listing Status:: Active
Data Last Updated:: April 5, 2026 at 12:07AM
Listing Office:: Real Broker, LLC : 337-534-0555
Listing Agent:: Forrest W Sillavan : 337-303-8165
MLS ID:: 2600002793

General: High CeilingsBookcasesBuilt-in FeaturesComputer NookCrown MoldingGuest SuiteKitchen IslandMulti-Head ShowerVaried Ceiling HeightsVaulted Ceiling(s)Walk-In Closet(s)Wet BarGranite CountersTile Counters
Appliances: DishwasherDisposalGas CooktopMicrowaveRefrigeratorTrash Compactor
Flooring: BrickCarpetTileWood
A/C: Multi UnitsCentral Air
Heating: CentralNatural Gas
Fireplace: 2 FireplacesDouble SidedGasFireplaceFireplaces: 2

General: BalconyOutdoor ShowerCabanaGazeboGuest HouseStorage
Style: Traditional
Other Structures: PorchDeckCovered
Pool: GuniteIn Ground
Parking: Garage Faces SideParking spaces: 4

Roofing: Other
Windows: Window Treatments
General: Other SidingStuccoFrame2Slab

Road/Access: City Street
HOA Amenities: 389.0Annually
Originating MLS: RAA
School District: Lafayette Parish
County: Lafayette

Zoning: LOT 162 AND 50FT OF LOT 161 OF FERNEWOOD6085335
View: View
Fencing: Partial

Utilities: Elec: CityElectricity on Property
Sewer: Public Sewer

Source: RAA
Exclusions: Other - See Remarks

This listing courtesy of Forrest W Sillavan , Real Broker, LLC

Monthly Payment

$Est. Payment

Principal & Interest $
Property Taxes $
Home Insurance $
VA Funding Fee $

Ready to Start a VA Loan?

Get Started

NMLS #1907 ^†

Get Prequalified »

Interest rates used in the VA mortgage calculator are shown for illustrative purposes only. Your rate may differ based on a variety of factors, including your credit score and the current market conditions. To get your personalized interest rate, start your quote online.

Location

Schools Nearby

Broadmoor Elementary School

609 Broadmoor Blvd, Lafayette, LA, 70503

Grades KG-5

0.67 miles away

Edgar Martin Middle School

401 Broadmoor Blvd, Lafayette, LA, 70503

Grades 6-8

0.94 miles away

Lafayette High School

3000 W Congress St, Lafayette, LA, 70506

Grades 9-12

3.08 miles away

Disclaimer: School and School District information courtesy of the National Center for Education Statistics (NCES). School boundaries may change. Proximity to listed schools does not guarantee enrollment eligibility. Contact the school district for more information and exact boundaries.