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

381 Parkinson Road
Flora, MS 39071
Kimberly Tyer with Hopper Properties, original listing - (601) 724-1435

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,600,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2976 Square Feet
Agency: Hopper Properties
Agency Phone: (601) 724-1435

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 15 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: Welcome to your dream estate nestled in the heart of Madison County on 15 breathtaking acres with a 1 acre stocked pond with trophy bass and brim. Words cannot adequately express the grandeur and beauty of this exquisite rare Dog Trot (Greek Revival) custom home built in 2020 on 15 pristine acres with trophy deer, bass and brim. As you enter the gate the view is serene and peaceful. A professionally landscaped patio on the left and a beautifully landscaped sidewalk leading to the front porch sets the stage for this beautiful one of kind estate. This home is truly a rare unique find featuring 3 spacious bedrooms with 3 bathrooms. As you enter the home you will notice the unique distinctive double entry doors which open to an elaborate enclosed breezeway with wood adorning the walls, beautifully appointed chandeliers and lighting adorn the 12 ft ceilings, hardwood floors milled from a tobacco barn in North Carolina and are extraordinarily rare and unique. Gourmet kitchen with custom cabinets, quartz counter tops, island with wood counter, upgraded stainless steel appliances, gas range and a farm house enamel sink. The family room and kitchen are open and allow the perfect space for entertaining or Sunday dinner. A bay window allows for the perfect sitting area with ample natural light for reading or simply relaxing with your morning coffee relishing a cozy fire in the wood burning fire place. The main suite has 10ft ceilings adorned with an elegant chandelier, a fireplace with gas logs for those cold winter nights. Walk-in closet with an abundance of room for extra storage, beautiful soaker tub with walk-in shower, two vanity areas and porcelain tile flooring. The pantry and laundry room are located off the kitchen and feature custom cabinets with vitrine glass adding to the elegance and charm. Vintage enamel sink, and an abundance of space for pantry needs.The porches front and back are on raised concrete with wood that has been kiln dried after treatment which increases the life span (kdat), a breeze way from the screened-in back porch leads to a 3-car garage and a 240 sq ft. safe/storm room.Located off the back porch and breezeway is a well-appointed upscale outdoor kitchen with ample space for entertaining or just watching the abundance of trophy deer and other wildlife; beyond that a 30 x 40 work shop with 16 ft over hangs, well equipped with electricity and a 1'' water line for spraying off equipment. A tranquil 1+/- acre stocked pond with trophy bass and brim; all surrounded by 15 pristine gated and fenced acres. Fencing marks clear boundary of the property line. The raised beds add a touch of nostalgic style and charm.No details were spared when designing and building this custom Dog Trot (Greek Revival) home. The exterior of the home is constructed of hardy plank for durability and longevity. Vinyl wood clad windows, safe/storm room, 3 car garage, home features a dual fuel heat and cooling unit with extremely low temperatures unit will increase with supplemental gas heat. Home is framed with 2x12's for increased insulation and support, hardwood flooring was milled from a tobacco barn in North Carolina. Sophisticated sound and camera system, front and back porches are on raised concrete with (kdat) wood. Whole house generator which also includes the work shop, tankless hot water heater, setup for in-ground pool (electricity hook-up), 1 +/- acre stocked pond with trophy bass and brim, 30 x 40 work shop with 16 ft over hangs, electricity, water, sink and work area. Professionally installed sprinkler system. Proof of funds are required prior to viewing, 24 hours notice required. This unique property will not last long. Call today for your private tour.
MlsNumber: --
ListingId: 4085410


Listing Provided By: Hopper Properties, original listing
Phone: (601) 941-7094
Office Phone: (601) 724-1435
Agent Name: Kimberly Tyer
Disclaimer: Copyright © 2024 MLS United. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.


Local Real Estate Expert

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 = 1449 AND i.igate IN ('usahud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 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;
Real Estate Expert Photo for Camryn Greer
Camryn Greer
ASCIIMcCool Thorpe Real Estate
Call Today!: (662) 739-7661

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App