Luxury Custom Residence with panoramic golf course views located in desirable gated Longview Country Club. This dream home features amazing design upgrades throughout. Gourmet kitchen boasts cultured quartz counters, Sub Zero 42" refrigerator, 48" Pro Designer series Thermador gas range with steamer & griddle, and best of all hidden door leading to over sized scullery/pantry with 2nd dishwasher and refrigerator. Collapsible sliders create an open/airy family room that spills onto back covered terrace with retractable screens overlooking the spectacular pool, spa and large gas built in fire-pit and view of golf course. Luxurious master suite with vaulted ceiling, golf views and master bath adorned with marble counters & shower with barrel ceiling detail and closet washer/dryer hook up. 4 en-suite bedrooms upstairs with bonus room with built bar and laundry/craft room. Security w/keyless entry. Membership includes golf, tennis, swimming, dining, fitness center and more.
TRACT
|
Longview
|
YEAR BUILT
|
2014
|
COMMUNITY
|
Longview
|
GARAGE SPACES
|
2.0
|
COUNTY
|
Union
|
STATUS
|
Closed
|
PROPERTY TYPE(S)
|
Single Family
|
|
|
Elementary School |
Rea View |
Jr. High School |
Marvin Ridge |
High School |
Marvin Ridge |
AIR |
Central Air |
AIR CONDITIONING |
Yes |
APPLIANCES |
Bar Fridge, Dishwasher, Disposal, Double Oven, Exhaust Fan, Gas Cooktop, Plumbed For Ice Maker, Self Cleaning Oven, Tankless Water Heater, Warming Drawer, Wine Refrigerator |
BASEMENT |
Crawl Space |
EXTERIOR |
Fire pit |
FIREPLACE |
Yes |
GARAGE |
Attached Garage, Yes |
HEAT |
Heat Pump, Hot Water, Natural Gas |
HOA DUES |
5160 |
INTERIOR |
Central Vacuum, Kitchen Island, Pantry, Walk-In Closet(s) |
LOT |
0.63 acre(s) |
LOT DESCRIPTION |
On Golf Course |
MLS STATUS |
Closed |
POOL DESCRIPTION |
In Ground, Outdoor Pool |
STORIES |
2 |
STYLE |
French Provincial |
SUBDIVISION |
Longview |
UTILITIES |
Cable Available, Natural Gas Available, Cable Connected, Electricity Connected |
VIEW |
Yes |
VIEW DESCRIPTION |
Golf Course |
We respect your online privacy and will never spam you. By submitting this form with your telephone number
you are consenting for Josh
Fretz to contact you even if your name is on a Federal or State
"Do not call List".
Listed with Realty Dynamics Inc.
Date last updated: 10/14/25 7:20 AM PDT
The data relating to real estate on this website derive in part from the Internet Data Exchange program. Brokers make an effort to deliver accurate information, but buyers should independently verify any information on which they will rely in a transaction. All properties are subject to prior sale, change or withdrawal. Neither Remax Metro nor any listing broker shall be responsible for any typographical errors, misinformation, or misprints, and they shall be held totally harmless from any damages arising from reliance upon this data. This data is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Properties reported may be listed or sold by various participants in the MLS
© 2025 Carolina Multiple Listing Services, Inc.

This IDX solution is (c) Diverse Solutions 2025.
Save favorite listings, searches, and get the latest alerts
Save your favorite listings, searches, and receive the latest listing alerts