Welcome to a stunning example of California-style post & beam architecture, where timeless design meets exceptional craftsmanship. Built with durable 2x6 construction, this extraordinary home was thoughtfully designed to combine strength, beauty, and comfort in a picturesque waterfront setting. From the moment you enter, you'll notice expansive water views visible from nearly every room, creating a peaceful atmosphere that complements the home's open architectural style. Inside, the home features impeccable finishes throughout, including custom cabinetry, Brazilian cherry hardwood floors, granite countertops, and a full suite of stainless steel appliances in the gourmet kitchen. The primary suite serves as a private retreat, complete with a convenient morning kitchenette and a luxurious his-and-hers Blue Pearl granite shower illuminated by a tubular skylight. A main-level guest bedroom also enjoys spectacular water views, allowing guests to experience the same serene setting. The lower level expands the home's versatility with a second fully equipped kitchen, two additional bedrooms, and an impressive 8-seat home theater featuring a projector replaced in 2022 that conveys with the property--perfect for entertaining or relaxing. With its separate entrance, the lower level could easily function as in-law quarters or private guest accommodations. This home also includes numerous upgrades designed for comfort and peace of mind, including a generator, GE smart home wiring system, ADT security system, mesh Wi-Fi, wine cooler, and three recently replaced heat pumps. Additional improvements include a new boathouse irrigation pump in 2022, new steps to the boathouse, lawn irrigation, a refreshed stone entryway, and beautiful nighttime landscape lighting. Outdoor living is just as impressive, with ClearView railings on the deck providing unobstructed water views along with a charming screened porch ideal for relaxing evenings. The home is supported by a three-bedroom septic system, which was recently inspected and verified to be in good condition by Superior Septic. Recent updates include fresh exterior paint on the siding and trim completed in June 2021 and the addition of a fourth full bathroom, enhancing both style and functionality. As an added bonus, most furnishings are available for purchase, making this a rare turnkey opportunity. Select items, including the Gator and theater seating, are negotiable. This remarkable waterfront retreat offers a unique blend of architectural beauty, modern upgrades, and peaceful surroundings, creating the perfect balance of luxury, comfort, and lakefront living.
Welcome to a stunning California-style post & beam home, built with durable 2x6 construction for strength, beauty & comfort on a picturesque waterfront. Expansive water views fill nearly every room, complementing the open architectural style. Inside, enjoy custom cabinetry, Brazilian cherry hardwood floors, granite counters & a gourmet kitchen with stainless steel appliances. The primary suite offers a morning kitchenette & his- & -hers Blue Pearl granite shower with skylight. The lower level features a 2nd kitchen, 2 bedrooms & 8-seat home theater, ideal for guests or in-law quarters. Upgrades include generator, smart wiring, ADT, mesh Wi-Fi, wine cooler, 3 heat pumps, boathouse pump, irrigation, refreshed stone entry, landscape lighting & recent exterior paint. ClearView deck railings & screened porch maximize outdoor living. Most furnishings negotiable. A rare turnkey waterfront retreat blending luxury, modern upgrades & serene lakefront lifestyle.
MLSRV #925433
Oct 19, 2026
Price Changed
$1,725,000
$329/sq ft
Apr 27, 2026
Price Changed
$1,775,000
$339/sq ft
Mar 30, 2026
Listed
$1,795,900
$343/sq ft
+84
Welcome to a stunning example of California-style post & beam architecture, where timeless design meets exceptional craftsmanship. Built with durable 2x6 construction, this extraordinary home was thoughtfully designed to combine strength, beauty, and comfort in a picturesque waterfront setting. From the moment you enter, you'll notice expansive water views visible from nearly every room, creating a peaceful atmosphere that complements the home's open architectural style. Inside, the home features impeccable finishes throughout, including custom cabinetry, Brazilian cherry hardwood floors, granite countertops, and a full suite of stainless steel appliances in the gourmet kitchen. The primary suite serves as a private retreat, complete with a convenient morning kitchenette and a luxurious his-and-hers Blue Pearl granite shower illuminated by a tubular skylight. A main-level guest bedroom also enjoys spectacular water views, allowing guests to experience the same serene setting. The lower level expands the home's versatility with a second fully equipped kitchen, two additional bedrooms, and an impressive 8-seat home theater featuring a projector replaced in 2022 that conveys with the property--perfect for entertaining or relaxing. With its separate entrance, the lower level could easily function as in-law quarters or private guest accommodations. This home also includes numerous upgrades designed for comfort and peace of mind, including a generator, GE smart home wiring system, ADT security system, mesh Wi-Fi, wine cooler, and three recently replaced heat pumps. Additional improvements include a new boathouse irrigation pump in 2022, new steps to the boathouse, lawn irrigation, a refreshed stone entryway, and beautiful nighttime landscape lighting. Outdoor living is just as impressive, with ClearView railings on the deck providing unobstructed water views along with a charming screened porch ideal for relaxing evenings. The home is supported by a three-bedroom septic system, which was recently inspected and verified to be in good condition by Superior Septic. Recent updates include fresh exterior paint on the siding and trim completed in June 2021 and the addition of a fourth full bathroom, enhancing both style and functionality. As an added bonus, most furnishings are available for purchase, making this a rare turnkey opportunity. Select items, including the Gator and theater seating, are negotiable. This remarkable waterfront retreat offers a unique blend of architectural beauty, modern upgrades, and peaceful surroundings, creating the perfect balance of luxury, comfort, and lakefront living.
BRIGHT MLS #VAFK2000106
Oct 19, 2026
Price Changed
$1,725,000
$329/sq ft
Apr 27, 2026
Price Changed
$1,775,000
$339/sq ft
Mar 30, 2026
Listed
$1,795,900
$343/sq ft
Mar 12, 2026
Coming Soon
$1,795,900
$343/sq ft
MLSRV #904682
Dec 31, 2025
Listing Removed
—
Jan 15, 2025
Listing Removed
—
Sep 1, 2024
Price Changed
$1,795,900
$343/sq ft
Jul 22, 2024
Price Changed
$1,850,000
$353/sq ft
Jun 17, 2024
Price Changed
$1,899,900
$363/sq ft
Feb 3, 2024
Listing Removed
—
BRIGHT MLS #VAFK2000050
Jul 15, 2025
Listing Removed
—
Jan 15, 2025
Listing Removed
—
Sep 1, 2024
Price Changed
$1,795,900
$343/sq ft
Jun 26, 2024
Listed
$1,899,900
$363/sq ft
MLSRV #881262
Aug 6, 2021
Sold
$1,175,000
$224/sq ft
Jun 25, 2021
Listed
$1,175,000
$224/sq ft
MLSRV #843023
May 21, 2018
Sold
$935,000
$178/sq ft
Nov 14, 2017
Listed
$975,000
$186/sq ft
MLSRV #839870
Nov 13, 2017
Listing Removed
—
Jul 27, 2017
Listed
$975,000
$186/sq ft
MLSRV #792315
Nov 30, 2013
Listing Removed
—
May 1, 2013
Listed
$1,099,000
$210/sq ft
Public Records
Mar 2, 2007
Sold
$109,900
$21/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$4,894
$182,000 + $956,100
$1,138,100
2024
$4,894 (−13.2%)
$182,000 + $956,100
$1,138,100
2023
$5,639
$165,000 + $759,500
$924,500
2022
$5,639
$165,000 + $759,500
$924,500
2021
$5,639
$165,000 + $759,500
$924,500
2020
$5,639 (+43.0%)
$165,000 + $759,500
$924,500
2019
$3,943
$130,000 + $516,400
$646,400
2018
$3,943 (+10.9%)
$130,000 + $516,400
$646,400
2017
$3,555
$130,000 + $516,400
$646,400
2016
$3,555 (−15.5%)
$130,000 + $516,400
$646,400
2014
$4,208
$215,000 + $550,100
$765,100
Public record
Public record
Zoning
Beds
6
Baths
4.5
Stories
1
Lot width
—
Lot depth
—
Lot size
0.81 Acres
Year renovated
2017
Finished Sq. Ft.
5,230
Unfinished Sq. Ft.
—
Total Sq. Ft.
5,230
Year built
2006
Style
Single Family Residential
County
Franklin County
APN
052/08/020/00////
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 23, 2026.
A1
Agricultural District
This district includes unincorporated portions of the county that are occupied by various open uses such as farms, forests, lakes, reservoirs, streams and park lands. This district is established for the purpose of facilitating existing and future farming operations, preserving farm and forest lands, conserving water and other natural resources, reducing soil erosion, preventing water pollution, and protecting watersheds and reducing hazards from flood and fire.
Permitted uses
Include but are not limited to:
Agriculture
Greenhouse / nursery
Assembly / meeting place
Religious facility
Day care facility
Commercial & retail-Other
Housing-Single unit
Bed & breakfast
Library
Veterinary clinic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
5/10 Heat Factor
7 days above 101° expected this year, 18 days in 30 years
2/10 Wind Factor
3% chance of strong winds in next 30 years
2/10 Air Factor
1 unhealthy days expected this year, 1 days in 30 years
Provided by First Street
Historical weather
Union Hall, VA • 24176
Average low and high temperatures (°F)
43
27
49
33
67
43
73
52
74
56
85
66
87
70
80
65
79
60
68
50
61
43
48
32
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
93/ 100
Exceptional sunlight
Sunscore
There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
9.9 hrs
6.2 hrs
JuneDecember
Provided by Shadowmap
Redfin Estimate for 174 Virginia Key Trl
$1,629,116
$96K under list price of $1.73M
Nearby comparable homes
The Redfin Estimate uses 6 recent nearby sales, priced between $880K to $2.2M.