We Purchase, Trade, Consult & Market Residential & Commercial Real Estate

  • About
  • Contact
  • Careers
  • 337-984-4345
Guidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real EstateGuidry and Company Real Estate
  • 337-984-4345
  • Home
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Inherited Land
  • Who’s Your REALTOR®?
  • Success Coaching
  • Blog
  • Reviews

Agent on Call

agent

Andrea Laborde, REALTOR® Sales Associate
337-277-6503


$410,000
2862 S Union Street
Opelousas, LA 70570
MLS# 2600003668
4 beds  |  3 baths


SH_01537-HDR
  1 / 45  
SH_01537-HDR DJI_20250513194639_0081_D DJI_20250513194618_0079_D SH_01542-HDR DJI_20250513194607_0078_D SH_01547-HDR SH_01552-HDR SH_01603-HDR SH_01713-HDR SH_01718-HDR SH_01585-HDR SH_01673-HDR SH_01613-HDR SH_01623-HDR SH_01608-HDR SH_01728-HDR SH_01733-HDR SH_01738-HDR SH_01683-HDR SH_01590-HDR SH_01598-HDR SH_01628-HDR SH_01638-HDR SH_01633-HDR SH_01658-HDR SH_01648-HDR SH_01643-HDR SH_01663-HDR SH_01653-HDR SH_01698-HDR SH_01703-HDR SH_01688-HDR SH_01693-HDR SH_01562-HDR SH_01557-HDR SH_01708-HDR SH_01668-HDR DJI_20250513194439_0071_D SH_01567-HDR SH_01576-HDR DJI_20250513194545_0077_D DJI_20250513194527_0076_D SH_01577-HDR DJI_20250513194346_0067_D image000000

Property Description
Your dream home awaits! Step into luxurious living with this split-level fully remodeled 4 bedroom, 3 bathroom home, sitting on approximately 2 acres where privacy and elegance meet functionality, creating the perfect haven for both relaxation and entertaining. The front entrance welcomes you into a spacious 4,255 (approx) square-foot interior adorned with high ceilings, many Anderson doors and windows leading to expansive outdoor spaces and also features an atrium in the center of the home. The kitchen is complete with all new appliances. An adjoining formal dining room adds a touch of sophistication, perfect for hosting dinner parties. Each bedroom offers comfort and style, particularly the primary bedroom suite, which features two walk-in closets, and an over sized master bathroom with double vanities, makeup station, redwood sauna, new over-sized free standing tub, and tiled shower with a 6 function shower panel and also the bathroom has direct access to the back yard. This home also boasts a second master suite with a dedicated space that serves as an office for those who work from home or a crafts room providing ample space for creativity and productivity. Both of the master suites have excessive amounts of built-in storage and all four of the bedrooms feature cedar-lined closets. The guest bathroom has a new double vanity and bathtub and a standalone shower. All of the walls and ceilings in the home have new sheet-rock backed by tongue and groove boards providing superior insulation and sound blocking. Outdoor living is redefined in the backyard with a stunning brick patio, a 100 year old live oak and swing, outdoor fireplace with pergola, all of which overlooks the swimming pool and hot tub. The property also boasts a double carport in rear and 600+ft concrete circle driveway in the front. The sunken den/game room has terracotta floors, rustic bar counter and a fireplace for hours of family fun or entertaining.

Details
Status Change Information
Status Change Timestamp: 2026-04-27
Delayed Marketing: No
Address
Parish or County: St. Landry
MLS Area Major: L2
Street Number: 2862
Street Direction Prefix: S
Street Name: Union
Street Suffix: Street
State: LA
Postal Code (Zip): 70570
Directions: From Lafayette go north on I-49. Take Exit 15 and turn left at the stop sign. Go straight and at the light turn right. The house is 2.5 miles up the road on the left. If coming from the north, go to exit 15 and at the stop sign turn right. Go straight and at the light turn right.
Parcel Number: 0104685100
Contract
Current Price: $410,000
Original List Price: 459000
Status: Active
Listing Contract Date: 2026-04-27
List Price: $410,000
Listing Agreement: Exclusive Agency
Listing Service: Limited Service
Occupant Type: Vacant
List Price/SqFt: 96.36
Interior
Bedrooms Total: 4
Bathrooms Total: 3
Bathrooms Full: 3
Living Area: 4255
Living Area Units: Square Feet
Living Area Source: Owner
Non-Living Area: 625
Fireplace YN: Yes
Fireplaces Total: 2
Parking Information
Carport YN: Yes
Carport Spaces: 2
Building
Year Built: 1960
Approximate Age: 51 - 75 Years
Home Warranty YN: No
Lot
Lot Size Acres: 2.05
Lot Size Square Feet: 89298
Lot Size Dimensions: 155Fx577.4LSx155Rx577.4RS
Pool Private YN: No
Waterfront YN: No
Sign On Property YN: Yes
Remarks
Public Remarks: Your dream home awaits! Step into luxurious living with this split-level fully remodeled 4 bedroom, 3 bathroom home, sitting on approximately 2 acres where privacy and elegance meet functionality, creating the perfect haven for both relaxation and entertaining. The front entrance welcomes you into a spacious 4,255 (approx) square-foot interior adorned with high ceilings, many Anderson doors and windows leading to expansive outdoor spaces and also features an atrium in the center of the home. The kitchen is complete with all new appliances. An adjoining formal dining room adds a touch of sophistication, perfect for hosting dinner parties. Each bedroom offers comfort and style, particularly the primary bedroom suite, which features two walk-in closets, and an over sized master bathroom with double vanities, makeup station, redwood sauna, new over-sized free standing tub, and tiled shower with a 6 function shower panel and also the bathroom has direct access to the back yard. This home also boasts a second master suite with a dedicated space that serves as an office for those who work from home or a crafts room providing ample space for creativity and productivity. Both of the master suites have excessive amounts of built-in storage and all four of the bedrooms feature cedar-lined closets. The guest bathroom has a new double vanity and bathtub and a standalone shower. All of the walls and ceilings in the home have new sheet-rock backed by tongue and groove boards providing superior insulation and sound blocking. Outdoor living is redefined in the backyard with a stunning brick patio, a 100 year old live oak and swing, outdoor fireplace with pergola, all of which overlooks the swimming pool and hot tub. The property also boasts a double carport in rear and 600+ft concrete circle driveway in the front. The sunken den/game room has terracotta floors, rustic bar counter and a fireplace for hours of family fun or entertaining.
Land Details
Mineral Rights: Reserved
Utility Providers
Electric Provider: Entergy
Gas Provider: Delta Utilities
Water Provider: City of Opelousas
Originating Details
Originating System ID: M00000300
Originating System Key: 20260427163654898900
Originating System Listing ID: 2600003668
Originating System Name: RAA Flex
Listing Information
Price Change Timestamp: 2026-07-07T18:05:09Z
Property Sub Type: Single Family Residence
Tax Legal
Subdivision Name: Not a Subdivision
Property Features
Utilities: Cable Available; Internet Available; Internet Available; Cable Available; Internet Available; Internet Available
Appliances: Dishwasher; Gas Cooktop; Gas Range; Gas Stove Connection; Plumbed For Ice Maker; Refrigerator
Architectural Style: Split Level; Traditional
Attic Features: Other
Community Features: Acres
Construction Materials: Brick; Frame; HardiPlank Type
Cooling: Attic Fan; Ceiling Fan(s); Central Air; Multi Units
Exterior Features: Lighting
Fencing: Chain Link; Split Rail; Wood
Fireplace Features: Gas; Masonry; Outside; Wood Burning
Flooring: Brick; Pavers; Tile; Wood
Foundation Details: Pillar/Post/Pier; Slab
Heating: Central; Multiple Units; Natural Gas
Interior Features: Beamed Ceilings; Built-in Features; Computer Nook; Crown Molding; Double Vanity; Dual Closets; Garden Tub; Granite Counters; High Ceilings; Pantry; Sauna; Separate Shower; Standalone Tub; Varied Ceiling Heights; Vaulted Ceiling(s); Wet Bar; Other
Laundry Features: Electric Dryer Hookup; Gas Dryer Hookup; Washer Hookup
Levels: One
Listing Terms (Financing): Cash; Conventional; FHA; USDA/Rural Development; VA Loan
Lot Features: Back Yard; Landscaped; Level; Wooded
Other Structures: Pergola; See Remarks
Parking Features: Attached Carport; Open
Patio And Porch Features: Open; Porch
Road Frontage Type: City Street
Roof: Metal
Security Features: Smoke Detector(s)
Sewer: Septic Tank
Water Source: Public
Window Features: Double Pane Windows; Tinted Windows
Showing Requirements: Appointment Only; Leave Card; Lockbox
Room Types: Bathroom; Bedroom; Kitchen; Laundry; Living Room; Other Room; Primary Bathroom; Primary Bedroom
Room Information
Room Name Dimensions
Bathroom9.36 x 12.11
Bathroom8.58 x 6.55
Bathroom3.08 x 6.55
Bedroom
Kitchen
Laundry
Living Room20.43 x 16.33
Living Room15.07 x 11.09
Primary Bathroom
Primary Bedroom
Other45.7 x 19.56
Other8.84 x 11.09
Other5.95 x 4.85

IDX
Listing Office: Reliance Real Estate Group

Office Phone: 337-277-5244

Office Email: jeremiah.gooding@gmail.com

Last Updated: November - 03 - 2026

Information deemed reliable but not guaranteed.


Broker Attribution: 337-277-5244

Search powered by FBS Products

Find Us

Get Directions
 

1232-A Camellia Blvd.
Lafayette, LA 70508
P: 337-984-4345

 

AGENT ON CALL | 337-277-6503

 

CALL US: 337-984-4345

 

GUIDRY & CO. REAL ESTATE, Lafayette, LA. All offices are independently owned and operated. The data relating to real estate for sale on this web site comes in part from the IDX Program of the Realtor® Association of Acadiana; MLS Real Estate listings held by brokerage firms other than GUIDRY & CO. REAL ESTATE are marked with the MLS approved icon for IDX. “Information Deemed Reliable But Not Guaranteed”. Copyright 2016 REALTOR® Association of Acadiana, All rights reserved.

Licensed & Regulated in the jurisdiction of the Louisiana Real Estate Commission, Members of the National Association of Realtors®, Louisiana Realtors®, Realtor® Association of Acadiana, Multiple Listing Service (MLS), Louisiana Commercial (www.lacdb.com), The Realtor® Commercial Alliance, Equal Housing Opportunity.

  • Home
  • 337-984-4345
  • Buyers
    • Looking to Buy?
    • Featured Listings
    • Homes for Sale
    • COMMERCIAL LISTINGS: Business Opportunity, Industrial, Office, Restaurant/Lounge, Shopping Center, Hotel/Motel, Medical/Dental or Retail
    • LAND LISTINGS: Commercial, Industrial, Residential, Farm or Timberland
    • Buyers Guidebook
    • Choose Your Realtor
    • Why Choose Us
  • Sellers
    • Why Choose Us
  • Services
    • Consultation Services
    • Looking to Buy?
    • Inherited Real Estate?
    • Choose Your REALTOR®
  • Blog
  • Success Coaching
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate