Title Page Background
DEBUG FN args: Array ( [0] => 2889 [1] => [2] => [3] => agent ) BEFORE: Site: 2889 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2889 Igate: njhud LocID: 2889 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2889 AND i.igate IN ('vahud','usahud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2889 [1] => [2] => [3] => lender ) BEFORE: Site: 2889 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2889 Igate: njhud LocID: 2889 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2889 AND i.igate IN ('vahud','usahud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 2889 [1] => [2] => [3] => other ) BEFORE: Site: 2889 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 2889 Igate: njhud LocID: 2889 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: SELECT e.Slogan AS expert_slogan, e.expertIdNum, m.expertname AS expertname2, m.expertpos, i.igate_index, m.datestamp, s.state, REPLACE(s.county, '.', '') AS county, m.locationID, e.name AS expertname, e.company AS company, e.phonetext1 AS expert_pt1, e.phonetext2 AS expert_pt2, e.phonenum1 AS expert_ph1, e.phonenum2 AS expert_ph2, e.address AS expert_address, e.email AS expert_email, e.bannerphoto AS expert_photo, e.webpage AS webAddress, e.bannerlogo AS expert_logo FROM mimian m, igate i, states s, bannersNew e, ExpertAdminInfo eai WHERE m.igate = i.igate AND m.locationID = s.locationID AND e.ExpertID = m.expertName AND eai.username = e.expertid AND s.locationid = 2889 AND i.igate IN ('vahud','usahud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

1290 Schutt Road
Burkeville, VA 23922
David Keener with Good Life Realty LLC, original listing - (804) 513-6610

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $475,000
Beds: 4
Baths: Full: 2, ½: 1
Status: Active
SqFt: --
Agency: Good Life Realty LLC
Agency Phone: (804) 513-6610

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 8 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 2023
Notes: 8+ Acres of SECLUDED PRIVACY is what you will ENJOY with this Spacious 2408 Sqft Two-Story Home, CUSTOM BUILT by the Current Owners in 2018. Designed with FOUR (4) Bedrooms, TWO (2) FULL BATHS, and the LAUNDRY ROOM on the 2nd Level, this home is perfect for the larger or extended Family. The PRIMARY BEDROOM includes a WALK-IN CLOSET, and PRIVATE Bath with SHOWER STALL & SOAKING TUB. On the 1st Level there is an ABUNDANTCE of Room to spread out in the OPEN CONCEPT Kitchen, Dinette Area & Family Room, in addition to a LIVING ROOM & Formal DINING ROOM to either side of the Entrance FOYER with HALF BATH. The Kitchen Features GRANITE Topped CENTER ISLAND and Cabinetry, DOUBLE OVEN, DROP-IN RANGE with POTFILLER FAUCET, REFRIGERATOR, Dishwasher, WALK-IN PANTRY, and a Preparation ALCOVE adjoining the Formal Dining Room. The Dinette Area walks out to the 12x14 REAR DECK & FENCED Back Yard, and Kitchen Opens to the TWO-CAR ATTACHED GARAGE. The 6x23 COVERED FRONT PORCH provides a great space for relaxation. Also included: 22KW Automatic GENERATOR, 12x22 Detached STORAGE BUILDING with Electricity, 14x40 PRE-FAB BUILDING with Porch, & a SOLAR PANEL ARRAY to REDUCE your NET Electric Bill!
MlsNumber: --
ListingId: 57237


Listing Provided By: Good Life Realty LLC, original listing
Phone: (804) 513-6610
Office Phone: (804) 513-6610
Agent Name: David Keener
Disclaimer: Copyright © 2025 South Central Association of Realtors. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App