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 = 1451 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 = 1451 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 = 1451 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;

779 S Red Banks Road
Byhalia, MS 38611
Frankie L Bryant with Dream Maker Realty, original listing - (662) 893-3232

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $725,000
Beds: 4
Baths: Full: 3, ½: 1
Status: Active
SqFt: 3910 Square Feet
Agency: Dream Maker Realty
Agency Phone: (662) 893-3232

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2020
Notes: BUILDERS PERSONAL HOUSE! ~ LEWISBURG SCHOOLS ~ This Professionally designed Farmhouse Style Home sits on 2.23 acres with 3,910 sf, 3-car garage, 4 bedrooms down, 3.5 bath, + office/craft room + bonus upstairs ~ Double wood door entry w/high ceiling opens into Dining area with vaulted shiplap ceiling, open to Kitchen & Great room & wood double French doors leading to back patio - Great room has Cedar beams, Brick fireplace w/built-ins ~ off Great room is barn doors to Office/craft room ~ Kitchen boasts a 10' custom wood design island/breakfast bar, custom cabinets to the ceiling which include some open glass cabinets, drawer stacks, utensil pull-out & double trash bin. Kitchen also has farm sink under large open window, open shelving on a brick accent wall, beautiful quartz countertops, under cabinet lighting, pot filler, 48'' gas double oven range w/6 burners & griddle ~ off Kitchen is walk-in Butler's pantry w/barn doors, wood shelving & perfect place for coffee bar - Master bedroom retreat has vaulted ceiling w/Deco wall, barn doors to master bath, soaker tub, open walk-thru shower with frameless glass, upgraded shower system, his & her separate vanities, then you walk into the extremely large closet w/wood shelving to ceiling & direct access to large laundry room with plenty of storage & folding area ~ 1/2 bath features a custom wood vanity with vessel sink & tile accent wall ~ large mud area is in hall when entering from garage ~ Split from Master bedroom is 3 additional large bedrooms ~ 2 which share a Jack & Jill bathroom & 1 bedroom with private bath - upstairs is finished bonus room ~ Outside you find a Large extended Covered porch & back patio both with tongue & groove ceilings ~ add'l features of this home include: Minimum 10' ceilings & 8' doors as well as wood plank tile flooring throughout downstairs, 1x4 trim work, Wood shelving throughout, upgraded Lighting, Tankless water heater + add'l 50 gal. water heater, Energy Efficient cellulose insulation, Tech Shield Decking, 16 Seer Dual Fuel heat pump, WiFi Thermostats, Security cameras, Surround Sound in Kitchen, Great room, Master bedroom & back patio, blinds, Metal accent roofing, garage keypad entry, Exterior soffit lighting, Stone firepit, 500 gal. buried propane tank, County only taxes & NO COVENANTS ........PLUS THERE IS AN ADDITIONAL 3.25 ACRE LOT with pond access behind the house that is available to purchase with home! YOU WILL NOT FIND ANOTHER PROPERTY LIKE THIS! THIS IS A MUST SEE! *Photos are from before house was moved in.
MlsNumber: --
ListingId: 4085067


Listing Provided By: Dream Maker Realty, original listing
Phone: (901) 283-4155
Office Phone: (662) 893-3232
Agent Name: Frankie L Bryant
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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App