Features & Amenities

Interior

  • Other Interior Features

    Eat-in Kitchen, Granite Counters, Kitchen Island, Open Floorplan, Vaulted Ceiling(s), Walk-In Closet(s), Wired for Sound

  • Total Bedrooms

    5

  • Bathrooms

    5

  • 1/2 Bathrooms

    1

  • Basement YN

    NO

  • Cooling YN

    YES

  • Cooling

    Ceiling Fan(s), Central Air, Electric, Zoned

  • Fireplace YN

    YES

  • Heating YN

    YES

  • Heating

    Central, Natural Gas, Zoned

  • Pet friendly

    N/A

Exterior

  • Garage

    Yes

  • Garage spaces

    3

  • Construction Materials

    Brick, Stone

  • Other Exterior Features

    Rain Gutters

  • Parking

    Concrete, Driveway, Garage, Garage Door Opener, Garage Faces Side, Kitchen Level, Attached

  • Pool

    No

  • Waterfront YN

    NO

  • View

    Water

Area & Lot

  • Lot Features

    Few Trees, Interior Lot, Landscaped, Subdivided

  • Lot Size(acres)

    1.0

  • Lot Size(square feet)

    43,560

  • Property Type

    Residential

  • Property Sub Type

    Single Family Residence

  • Architectural Style

    Traditional

Price

  • Sales Price

    $2,000,000

  • Tax Amount

    $29,557

  • Financing Options

    Conventional

  • Sq. Footage

    5,449

  • Price/SqFt

    $367

HOA

  • Association

    YES

  • Association Fee

    $1,050

  • Association Fee Frequency

    Quarterly

  • Association Fee Includes

    N/A

School District

  • Elementary School

    Robert L. Puster

  • Middle School

    Sloan Creek

  • High School

    Lovejoy

Property Features

  • Foundation Details

    Slab

  • Sewer

    Septic Tank

  • Tax Lot

    23

  • Water Source

    Public

Schedule a Showing

Showing scheduled successfully.

<
>
IN PERSON
VIA CHAT

What is 3 + 4 ?


Change time

Mortgage calculator

Estimate your monthly mortgage payment, including the principal and interest, property taxes, and HOA. Adjust the values to generate a more accurate rate.

Your payment

Principal and Interest:

$

Property taxes:

$

HOA fees:

$

Total loan payment:

$

Total interest amount:

$

Location

County

Collin

Elementary School

Robert L. Puster

Middle School

Sloan Creek

High School

Lovejoy

Listing Courtesy of Pamela Lewis, Ebby Halliday, Realtors

RealHub Information is provided exclusively for consumers' personal, non-commercial use, and it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. All information deemed reliable but not guaranteed and should be independently verified. All properties are subject to prior sale, change or withdrawal. RealHub website owner shall not be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless.

Agent Joe Boston

AGENT

Joe Boston

Call Joe today to schedule a private showing.


* Listings on this website come from the FMLS IDX Compilation and may be held by brokerage firms other than the owner of this website. The listing brokerage is identified in any listing details. Information is deemed reliable but is not guaranteed. If you believe any FMLS listing contains material that infringes your copyrighted work please click here to review our DMCA policy and learn how to submit a takedown request.© 2024 FMLS.
Nestled on a picturesque lot in the highly sought-after community of estate-sized properties of Tranquility Farms in Fairview. This stunning custom home exudes timeless English cottage charm from the moment you arrive.  A graceful drive-up, greeted by dressed Ashlar stone, reclaimed antique brick, cast transom windows, and European copper chimney caps, sets the tone for the elegance found throughout. Inside, the home offers an exceptional blend of warmth and sophistication with hand-trowelled walls and a coffered dining room.  The soaring professional study with fireplace, Knotty Alder cabinetry, and splendid view of the lake adds an inviting space for entertaining. The breathtaking Great Room inspires with its massive, hand cut Ashlar stone fireplace and timber-beamed ceilings.  The gourmet kitchen is a true centerpiece, featuring professional appliances, a striking brick barrel ceiling, beautifully distressed cabinetry, exquisite countertops, and a dramatic butler's pantry.  The secluded primary suite offers a luxurious retreat with separate his-and-her baths. A private first-floor guest suite adds convenience and comfort. Upstairs, you'll find three spacious bedrooms, two baths and an extensive game and media room complex. Step outside to enjoy the covered stone patio with its own fireplace, overlooking an expansive backyard to anchor a future landmark pool and pool house.  Full-encapsulation foam insulation, a piered foundation, and a Class 4 roof are more examples of the quality of this Ron McHam home.  Located within the coveted Lovejoy ISD with quick access to Highways 121 and 75, this exceptional property combines elegance, comfort, and convenience in one remarkable home!

907 Foxglove Trail

Message successfully sent.

What would you like to know?

What is 3 + 4 ?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Next Level Realty Group via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Related Properties

Price reduced
Luxury Living in One of Fairview's Most Desirable Neighborhoods. Barely lived in highly desirable stunning Single Story custom pool home w Two Primary Bedrooms & sits on an exquisite acreage estate w exceptional curb appeal, featuring a circular drive & spectacular landscaping framed by a magnificent collection of mature trees that create a private, tranquil retreat. Over $300,000 was invested in the estate-quality landscaping, showcasing an impressive canopy of mature trees, lush gardens, and thoughtfully designed outdoor spaces that provide exceptional beauty, privacy, and year-round enjoyment. Inside, rich wood floors lead to a beautifully appointed study with designer wallpaper. The expansive living room features a striking exposed beams and flows seamlessly into the dining area & state-of-the-art kitchen, complete with professional-grade Thermador appliances, upgraded custom cabinetry & an incredible oversized walk-in pantry. The home offers Two oversized primary suites w dual vanities and premium walk-in closets featuring third-row pull-down rods. Every secondary bedroom includes an ensuite bath and walk-in closet, providing comfort and privacy for family and guests. The media room is an entertainer's dream with a wet bar w approximately $25,000 in premium equipment, including a 150-inch screen and Dolby Atmos 7.2.4 surround sound. Additional highlights include Energy Star Plus certification, an oversized laundry room, designer lighting, electric window shades, and a 2.5-car garage with epoxy flooring. Step outside to a resort-style backyard featuring a self-cleaning pool, expansive patios & a large private yard surrounded by beautiful mature trees. The covered outdoor living area includes a sink, grill, and two-burner gas cooktop, creating the perfect setting for entertaining or relaxing in the peaceful surroundings. Extra Piece of Mind, the home has a generator! Fantastic Location! Convenient to Shopping, hospital, all main roadways & the new Amphitheater!
#21197148

Fairview

658 Louise Drive

4 Beds

4 Baths

4,926 Sq.Ft.

$2,225,000

MLS#: 21197148

 - property

Send a message

Message successfully sent.

Your message

What is 3 + 4 ?

Reason for contacting?

I agree to receive email communication and understand I can unsubscribe at any time.

I agree to be contacted by Next Level Realty Group via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Sign Out

Virtual Assistant

Would you like to take the next step with this property? We can help you schedule a showing or virtual tour, or send you more details.

Yes, I would like more information.

Thank You for Your Reply, One of Our Agents will contact you as soon as possible

No, maybe later.

Thank you, you can always contact me via email, phone number or through the contact form.

Realhub AI

Lucy - Your AI-Powered Realtor

Update Your Temporary Password

Personalize your search

Enter your email and we'll notify you immediately when new listings match what you're looking for.

or enter email address

Already have an account ? Login here

Continue your home search

I agree to receive communications and understand I can unsubscribe at any time.

I agree to be contacted by Next Level Realty Group via call, email, and text for real estate services. To opt out, you can reply 'stop' at any time or reply 'help' for assistance. You can also click the unsubscribe link in the emails. Message and data rates may apply. Message frequency may vary. Privacy Policy

Already have an account ? Login here

We use cookies

We use cookies primarily for analytics to enhance your experience. By accepting, you agree to our use of these cookies. You can manage your preferences or learn more about our cookies policy.