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 = 506 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 506 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'lender' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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 = 506 AND i.igate IN ('usahud','gahud','ushud') AND m.expertType = 'other' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'gahud', 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;

Tract4 Vinson Mountain Rd
Rockmart, GA 30153
Katherine L Johns with Hometown Realty Brokerage, LLC., original listing - (770) 505-7766

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $609,900
Beds: 3
Baths: Full: 2
Status: Active
SqFt: 1500 Square Feet
Agency: Hometown Realty Brokerage, LLC.
Agency Phone: (770) 505-7766

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 7 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2024
Notes: TO BE BUILT! This beautiful NEW HOME offers Modern FARM HOUSE LIVING its BEST on a lush 7.05 ACRE tract. This modern farmhouse RANCH with FULL WRAP AROUND PORCH offers country living at its best. With over 7 ACRES of land, a barn, and a thoughtfully designed open concept makes this home ideal for those who desire both comfort, style & country living. The Gourmet kitchen showcases a CUSTOM ISLAND, FARMHOUSE SINK, STAINLESS APPLIANCES, shaker CABINETS, GRANITE COUNTERTOPS & spacious pantry. The primary suite offers a luxurious ensuite bath which features double vanities with a breathtaking TILE SHOWER & custom glass door, plus a large walk-in closet. Two generously sized secondary bedrooms, each with large closets each bedroom has direct access to a JACK & JILL bathroom. The oversized FULLY WRAP AROUND PORCH is what farm house living dreams made of from drinking your morning coffee to entertaining family & friends. Standard features include beautiful luxury LVP in the kitchen, living room, entry, and baths; plush carpeting in the bedrooms; and high-quality finishes throughout. Enjoy the freedom of a PRIVATE LOT with no HOA restrictions, combining tranquility with convenient access. Choose your interior and exterior colors to truly make this home your dream home! Not quite the right floor plan? We have other options available! Don't miss this unique opportunity to create your dream home in a tranquil setting. Be sure to inquire about our incentives using when utilizing our preferred lender Gareth Thomas of Silverton Mortgage. This modern farmhouse ranch combines functionality with beauty and is the perfect place to call home. With over 7 acres of land, a barn, and a thoughtfully designed layout, this home is ideal for those who desire both comfort and style. Don’t miss your chance to make this dream home yours!
MlsNumber: --
ListingId: 7487593


Listing Provided By: Hometown Realty Brokerage, LLC., original listing
Phone: (770) 366-0253
Office Phone: (770) 505-7766
Agent Name: Katherine L Johns
Disclaimer: Copyright © 2024 First Multiple Listing Service, 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