Title Page Background
HFQUERY 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 = 2845 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2845 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1; HFQUERY 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 = 2845 AND i.igate IN ('usahud','vahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'vahud', 0, 1), IF(i.igate = 'ushud', 0, 1), IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC LIMIT 0, 1;

1916 Franklin Ave
Colonial Heights, VA 23834

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $325,000
Beds: 4
Baths: 2
Status: Active
SqFt: 1741
Agency: NextHome, Inc

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 2005
Notes: Welcome to 1916 Franklin Avenue, your dream home in the hear of Colonial Heights! This captivating Cape Cod home is a true gem, boasting stunning curb appeal & a host of enticing features that will leave you breathless. This immaculate home features 4 bedrooms, 2 bathrooms, over 1,700 square feet of living space, fully fenced back yard & detached two car garage. With its prime location, this home offers the perfect blend of tranquility & urban convenience. Step inside where you’re greeted by the warm embrace of hardwood floors & fresh color palette that flows seamlessly throughout. The layout of this classic Cape creates an inviting atmosphere, perfect for both relaxation & entertainment. Downstairs you will find a large living area with Hardwood floors, NEWly upgraded kitchen with stainless steel, white cabinets & NEW LVP floors. NEW LVP floors also run throughout the two 1st floor bedrooms and full bathroom. Step outside where you’ll find an oversized lot with fully fenced, private back yard. It’s easy to imagine yourself spending evenings on the dreamy BRAND NEW back patio, where you can unwind & enjoy the tranquility of your private oasis. The off-street parking & two-car garage (or home gym) ensure that your convenience is never compromised. 2 more bedrooms & 1 bathroom round out 2nd floor. 2024 updates include: NEW interior paint, NEW LVP floors throughout, NEW fridge & NEW dishwasher, NEW concrete patio. 2017 upgrades: NEW roof, NEW furnace, NEWer vinyl siding & gutters. Absolutely PERFECT location just steps great restaurants & entertainment. You don’t want to miss this one!
MlsNumber: 2411978


Listing Provided By: NextHome, Inc, original listing
Name: NextHome, Inc
Office Name: NextHome Advantage
Office Phone: (804) 545-6400
Agent Name: Adam Carpenter
Disclaimer: Copyright © 2024 NextHome, Inc. 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