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
    • Professional Development
  • Who’s Your REALTOR®?
  • Blog
  • Reviews

Agent on Call

Candice Scriber REALTOR® Sales Associate
337-257-2058


$915,000
42 MISTLETOE Drive
Covington, LA 70433
MLS# NO2548746
4 beds  |  4 baths  |  4095 sqft


Photo 1
  1 / 48  
Photo 1 Photo 2 Photo 3 Photo 4 Photo 5 Photo 6 Photo 7 Photo 8 Photo 9 Photo 10 Photo 11 Photo 12 Photo 13 Photo 14 Photo 15 Photo 16 Photo 17 Photo 18 Photo 19 Photo 20 Photo 21 Photo 22 Photo 23 Photo 24 Photo 25 Photo 26 Photo 27 Photo 28 Photo 29 Photo 30 Photo 31 Photo 32 Photo 33 Photo 34 Photo 35 Photo 36 Photo 37 Photo 38 Photo 39 Photo 40 Photo 41 Photo 42 Photo 43 Photo 44 Photo 45 Photo 46 Photo 47 Photo 48

Property Description
Nestled in the gated community of Tchefuncte Estates, this architectural 4-bedroom, 4 bath home offers an exceptional opportunity of luxury living. With 3105 square feet of living space, this home offers a desirable split floor plan and soaring ceilings. Inside, the open-concept layout is anchored by a spacious kitchen featuring rich cypress cabinetry, granite countertops, double ovens, with a living area that overlooks the pool - bringing in natural light and offering a seamless indoor-outdoor connection. Step outside to enjoy the expansive outdoor space, complete with a pool and a generously sized lot, offering possibilities for relaxation and recreation. Surrounded by the elegance and charm of one of the Northshore's most sought-after communities, this home is great for entertaining and everyday living.

Details
Documents
Listing Info
Delayed Marketing: No
List Price/SqFt: 294.69
Document Modified: 2026-04-01 11:01:22.021518
Status: Active
Listing Date: 2026-03-18
Listing Price: 915000
Current Price: $915,000
Type: Single Family Residence
Modification Timestamp: 2026-04-01T16:16:58Z
Photo Modified: 2026-04-01T15:46:18Z
Location, Tax & Legal Info
Legal Desc: LOT 282 SQ 37 TCHEFUNCTA CLUB ESTATES CB 638 309 CB 1442 349 CB 1503 866 INST NO 1529561 INST NO 1716999 INST NO 1765274
General Property Description
Lot Dimensions: 214x242x152x29
Stories: 1
SqFt - Living: 3105
SqFt - Source: Measured
SqFt - Total: 4095
Assn Fee $: 325
Assn Fee Terms: Monthly
Acreage Range: 1 - 2.99
# Bedrooms: 4
Baths - Full: 4
Total Baths: 4
Year Built: 1993
Acres: 1.02
Remarks & Misc
Remarks: Nestled in the gated community of Tchefuncte Estates, this architectural 4-bedroom, 4 bath home offers an exceptional opportunity of luxury living. With 3105 square feet of living space, this home offers a desirable split floor plan and soaring ceilings. Inside, the open-concept layout is anchored by a spacious kitchen featuring rich cypress cabinetry, granite countertops, double ovens, with a living area that overlooks the pool - bringing in natural light and offering a seamless indoor-outdoor connection. Step outside to enjoy the expansive outdoor space, complete with a pool and a generously sized lot, offering possibilities for relaxation and recreation. Surrounded by the elegance and charm of one of the Northshore's most sought-after communities, this home is great for entertaining and everyday living.
Office/Member/Contract Info
List AOR: NOMAR
Style
Traditional: 1
Siding
Stucco: 1
Parking
Carport: 1
Foundation
Slab: 1
Fireplace
Wood Burning: 1
Roof
Composition: 1
Heating
Central: 1
Interior
Cathedral Ceiling: 1
Wet Bar: 1
Cooling
2 or More Units: 1
Central Air: 1
Appliances
Dishwasher: 1
Disposal: 1
Microwave: 1
Refrigerator: 1
Countertops
Granite: 1
Rooms
Bedroom 1: 1
Bonus Room: 1
Dining Room: 1
Kitchen: 1
Laundry: 1
Living Room: 1
Primary Bedroom: 1
Office: 1
Bedroom 2: 1
Bedroom 3: 1
Bedroom 4: 1
Bedroom 5: 1
Bedroom 6: 1
Amenities
Acreage: 1
Fencing
Other: 1
Pool
Inground: 1
Originating Details
Originating System ID: ROAMM
Originating System Key: 57459035
Originating System Listing ID: 2548746
Originating System Name: ROAM Matrix
Location Tax Legal Info
Street Number: 42
Street Name: MISTLETOE Drive
Parish: St. Tammany
State: LA
Zip Code: 70433
Subdivision: Tchefuncte Club Estates
Tax Assessment Number: 5855
Directions: Hwy 190 to I-12 West to Exit 59 towards Madisonville, left one mile to Pinecrest Dr., take right on Mistletoe, property is on the left side. Bounding Streets: Pinecrest and Dogwood
Property Features
Style: Traditional
Siding: Stucco
Parking: Carport
Foundation: Slab
Roof: Composition
Interior: Cathedral Ceiling; Wet Bar
Fireplace: Wood Burning
Heating: Central
Cooling: 2 or More Units; Central Air
Appliances: Dishwasher; Disposal; Microwave; Refrigerator
Countertops: Granite
Rooms: Bedroom 1; Bonus Room; Dining Room; Kitchen; Laundry; Living Room; Office; Primary Bedroom; Bedroom 2; Bedroom 3; Bedroom 4; Bedroom 5; Bedroom 6
Fencing: Other
Amenities: Acreage
Pool: Inground
Room Information
Room Name Length Width Remarks
Primary Bedroom14.9016.50Primary Bedroom
Primary Bedroom14.7015.20Primary Bedroom
Bedroom 112.0010.00Bedroom
Bedroom 211.9014.10Bedroom
Living Room21.8018.60Living Room
Living Room18.3017.80Living Room
Office11.8010.00Office
Office11.8010.00Office
Bedroom 311.9011.90Bedroom
Kitchen11.4014.60Kitchen
Kitchen13.6015.30Kitchen
Bonus Room8.109.80Bonus Room
Dining RoomDining Room
Dining RoomDining Room
Bedroom 412.1014.00Bedroom
Bedroom 511.9011.90Bedroom
Bedroom 612.0011.80Bedroom
Laundry5.305.00Laundry
Laundry4.905.30Laundry
Listing Documents
View Document New Attachment
View Document Survey
View Document New Attachment

IDX
Listing Office: Coldwell Banker TEC

Last Updated: April - 01 - 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.


Search powered by FBS Products

Find Us

Get Directions
 

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

 

AGENT ON CALL | 337-257-2058
 

 

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®
    • Professional Development
  • Blog
  • Who’s Your REALTOR®?
  • Careers
  • About Guidry & Co. Real Estate
  • Contact Us
  • Reviews
Guidry and Company Real Estate
Thank you for visiting Guidry & Co. Real Estate, for more information please register here:

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*

 

Return To Homepage