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

521 Holland Avenue
Philadelphia, MS 39350

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $800,000
Beds: 6
Baths: Full: 5, ½: 1
Status: Active
SqFt: 5100 Square Feet
Agency: Maselle & Associates Inc
Agency Phone: (601) 720-4040

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Property Type: Residential-Single Family Residence
Year Built: 1904
Notes: Price REDUCED!!!! BEAUTIFUL OPPORTUNITY! Situated in the historical district of Philadelphia MS. This spectacular home sits stately on a half-acre lot. Upon entering the circular driveway, there is an open staircase that leads to a southern style veranda framed with white balustrade railing. The veranda has a traditional blue ceiling which is complimented with a porch swing, ceiling fans and painted wood floors. This area provides the perfect space to enjoy outdoor living. The door is original to the home with cut lead glass. The grand entrance showcases beautiful hardwood floors. Looking into the living room it is filled with warm red walls and white trim work, a crystal chandelier and fireplace accentuate this spacious room. There are 14 feet ceilings throughout the first floor of the main house. The formal dining is a very elegant room which has captivating red walls, a beautiful crystal chandelier, a fireplace, and a built-in cabinet with a glass front to showcase fine china. The staircase curves upward to a private bedroom which includes a full bathroom and window seat. Just off the foyer is the family room, richly accented with a welcoming fireplace. Near the back is an additional room, very spacious currently being used as an office. The kitchen is showcased toward the back of the home, there is a center island with a gorgeous granite slab along with granite counter tops. The cabinetry is complete with style and storage. A Viking gas cooktop oven and vent hood, a Bosch dishwasher, farm sink, black and white checkered ceramic tile and built-in sitting are perfectly positioned for family gatherings. The refrigerator is new and will remain with the home along with the washer/dryer. This magnificent home features six bedrooms, five full bathrooms and one-half bath. The master suite is luxurious, complete with a fireplace and private sitting room adored with a three paneled door that overlooks a portion of the backyard. The master bathroom has separate vanities, a walk-in shower, a jetted tub, a walk-in closet, gorgeous lead glass windows that reflects light and gives vibrate color to the room. Across the back of the estate is a gorgeous Caribbean style liner swimming pool. The pool is ironized, heated, and has a kaleidoscope of colors with changing lights inside the pool. Outside, there is plenty to enjoy. There awaits another kitchen, a screened in patio, a vinyl privacy fence with a lattice top surrounded by an English style garden, brick paved walkways, a 12x12 greenhouse and a 10x10 pool house. The Summer Cottage is breathtaking with a graceful entrance through the breezeway. This additional square footage not included with the main estate. The cottage has a large sitting area, one bedroom and full bath on the first floor. Upstairs include 3 bedrooms and and one full bath, a balcony that overlooks the backyard. The 3-car garage has exquisite mahogany doors, newly refinished. Window treatment consist of custom drapes, plantation shutters and blinds. There is a sound system, a security alarm, sprinklers, a bonus room, a cedar closet, perennial flowers and a vegetable garden already established for peace and tranquility. This home is so inviting and well preserved with lots of preservation. Call your agent today for a private tour of this magnificent estate. Showing Requirement: 24-hour notice by appointment only.
MlsNumber: --
ListingId: 4045172


Listing Provided By: Maselle & Associates Inc, original listing
Phone: (601) 853-3333
Office Phone: (601) 853-3333
Agent Name: Rosalind S Rawls
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