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

415 Jennie Lane
Flowood, MS 39232
Tye Densford with Trifecta Real Estate, LLC, original listing - (601) 741-3559

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $1,380,000
Beds: 5
Baths: Full: 5
Status: Active
SqFt: 4400 Square Feet
Agency: Trifecta Real Estate, LLC
Agency Phone: (601) 741-3559

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 2 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 2025
Notes: This brand-new, custom-built 4,400 sq. ft. estate offers a blend of luxury, privacy, and convenience in one of Flowood's newest gated subdivisions. Sitting on an extremely private 2.2-acre lot at the end of a quiet cul-de-sac, this 5-bedroom, 5-bathroom home was thoughtfully designed with every detail in mind. The sellers, who have recently made an exciting change in education for their children, now need to move closer to their new school--creating a unique opportunity for someone else to enjoy this dream home. Step inside and you are welcomed by stunning oak flooring, custom handrails, handmade chandeliers, and tons of natural light that add warmth throughout the house. The gourmet kitchen is a true showstopper, featuring a waterfall oversized island, top-of-the-line built-in appliances, and custom-picked tile. A massive walk-in pantry with a built-in fridge offers ample storage and convenience for any culinary enthusiast. The main level includes a luxurious primary suite with a custom-designed en suite, as well as an additional bedroom perfect for guests or multi-generational living. A thoughtfully designed visitor restroom provides direct access to the backyard, making it perfect for outdoor gatherings and future poolside convenience. Upstairs, three generously sized bedrooms and a versatile office/flex room provide endless possibilities for work or play. This home offers an abundance of storage inside and out, along with practical features such as impact-resistant, top-of-the-line shingles, a 400-amp electrical service that is car charger ready, and underground drainage with two catch basins to ensure seamless exterior water management. The outdoor living area is equally impressive, featuring a 56'' 300,000 BTU Crossfire H-Burner outdoor fireplace, a peaceful natural area behind the home for added privacy, and plenty of room for a future pool. Situated in a highly sought-after location, this property offers the perfect combination of tranquility and convenience, with easy access to the best of Flowood's shopping, dining, and amenities. Don't miss this rare opportunity to own an exquisite home in a prime setting, ready to welcome its next owners.
MlsNumber: --
ListingId: 4101732


Listing Provided By: Trifecta Real Estate, LLC, original listing
Phone: (601) 454-9373
Office Phone: (601) 741-3559
Agent Name: Tye Densford
Disclaimer: Copyright © 2025 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 = 1465 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;
Robin Harrigill
ASCIIHarrigill Real Estate
Call Today!: (601) 672-4101

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App