207 Farmington Drive, Lafayette, LA 70503 (MLS# 2600002793)

207 Farmington Drive, Lafayette, LA 70503

New Listing
$1,200,000
Property Type: Residential Bedrooms: 6 Baths: 6.1 Square Footage: 10,238 Lot Size (sq. ft.): 76,230 Status: Active
Current Price: $1,200,000 List Date: 4/02/2026 Last Modified: 4/02/2026

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

Supplements: ********

More Information MLS# 2600002793

Listing Info

Delayed Marketing: No List Price/SqFt: 159.51 Property Attached: No Document Modified: 2026-04-02 17:57:53.468572 Status: Active Listing Date: 2026-04-02 Listing Price: 1200000 Current Price: $1,200,000 Type: Single Family Residence Modification Timestamp: 2026-04-02T23:58:29Z Photo Modified: 2026-04-02T22:59:27Z

Location, Tax & Legal Info

Flood Zone: X School District: Lafayette Parish Legal Desc: LOT 162 AND 50FT OF LOT 161 OF FERNEWOOD

General Property Description

Approximate Age: 21 - 30 Years Condition: Excellent Lot Dimensions: IRREGULAR Stories: 2 SqFt - Living: 7523 SqFt - Source: Owner SqFt - Total: 10238 Mineral Rights: Conveyed Assn Fee: Required Assn Fee $: 389 Assn Fee Terms: Yearly Property Condition: Resale Warranty: No Acreage Range: 1 - 2.99 Pool on Subject Property: Yes # Bedrooms: 6 Baths - Full: 6 Baths - 1/2: 1 Total Baths: 6.1 Year Built: 1998 Acres: 1.75

Remarks & Misc

Remarks: 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

Office/Member/Contract Info

REO: No

Style

Traditional: 1

Siding

Stucco: 1 Other: 1

Parking

Garage Spaces: 4 Garage Faces Side: 1

Equipment

Garage Door Opener: 1 Central Vacuum: 1 Sauna/Steam: 1 Whirlpool: 1 Ceiling Fans: 1 Cable Ready: 1

Road Frontage

City Street: 1

Construction

Frame: 1

Foundation

Slab: 1

Exterior

Balcony: 1 Outdoor Shower: 1

Patio

Deck: 1 Porch: 1 Covered: 1

Fireplace

2 Fireplaces: 1 Double Sided: 1 Gas: 1

Roof

Other: 1

Heating

Central: 1 Multi Units: 1 Natural Gas: 1

Interior

9+ Ft Ceiling: 1 Attic Access: 1 Bookcases: 1 Built-Ins: 1 Computer Nook: 1 Crown Molding: 1 Guest Suite: 1 Kitchen Island: 1 Primary Bath: 1 Multi-Head Shower: 1 Varied Ceiling Heights: 1 Vaulted Ceilings: 1 Walk-In Closet(s): 1 Wet Bar: 1 Window Treatments: 1

Cooling

2 or More Units: 1 Central Air: 1

Flooring

Brick: 1 Carpet: 1 Tile: 1 Wood: 1

Sewer

Public Sewer: 1

Water Source

Public: 1 Water Company: LUS

Appliances

Dishwasher: 1 Disposal: 1 Gas Cooktop: 1 Microwave: 1 Plumbed For Ice Maker: 1 Refrigerator: 1 Trash Compactor: 1

Utilities

Elec: City: 1 Gas: Atmos: 1

Countertops

Granite: 1 Tile: 1

Waterfront

Bayou/River: 1

Documents

Property Disclosure: 1

Amenities

Acreage: 1 Park: 1 Playground: 1

Security Features

Security System: 1 Smoke Detector(s): 1

Fencing

Partial: 1

Lot

Back Yard Access: 1 Landscaped: 1 Sloping: 1 Views: 1 Water Frontage: 1

Other Structures

Cabana: 1 Gazebo: 1 Guest House: 1 Storage: 1

Financing

Cash: 1 Conventional: 1

Reserved Item

Other - See Remarks: 1

Pool

Gunite: 1 Inground: 1

Originating Details

Originating System ID: M00000300 Originating System Key: 20260401202450584899 Originating System Listing ID: 2600002793 Originating System Name: RAA Flex

Location Tax Legal Info

Street Number: 207 Street Name: Farmington St Suffix: Drive Parish: Lafayette State: LA Zip Code: 70503 Subdivision: Fernewood Area: N Tax Assessment Number: 6085335 Elementary School: Broadmoor Middle School: Edgar Martin High School: Lafayette 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).

Property Features

Style: Traditional Siding: Stucco; Other Parking: Garage Faces Side Construction: Frame Foundation: Slab Road Frontage: City Street Roof: Other Interior: 9+ Ft Ceiling; Attic Access; Bookcases; Built-Ins; Computer Nook; Crown Molding; Guest Suite; Kitchen Island; Multi-Head Shower; Primary Bath; Varied Ceiling Heights; Vaulted Ceilings; Walk-In Closet(s); Wet Bar; Window Treatments Fireplace: 2 Fireplaces; Double Sided; Gas Flooring: Brick; Carpet; Tile; Wood Heating: Central; Multi Units; Natural Gas Cooling: 2 or More Units; Central Air Appliances: Dishwasher; Disposal; Gas Cooktop; Microwave; Plumbed For Ice Maker; Refrigerator; Trash Compactor Countertops: Granite; Tile Security Features: Security System; Smoke Detector(s) Fencing: Partial Lot: Back Yard Access; Landscaped; Sloping; Views; Water Frontage Patio: Covered; Deck; Porch Amenities: Acreage; Park; Playground Exterior: Balcony; Outdoor Shower Other Structures: Cabana; Gazebo; Guest House; Storage Waterfront: Bayou/River Sewer: Public Sewer Water Source: Public Utilities: Elec: City; Gas: Atmos Pool: Gunite; Inground Reserved Item: Other - See Remarks Financing: Cash; Conventional Documents: Property Disclosure; Property Disclosure
Listing Office: Real Broker, LLC
IDX
Last Updated: April - 02 - 2026
The data relating to real estate for sale or lease on this website comes in part from the IDX program of the REALTOR® Association of Acadiana MLS. The IDX information is provided exclusively for consumers’ personal, non-commericial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Data is deemed reliable but is not guaranteed accurate by the MLS.