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

973 Howard Avenue
Biloxi, MS 39530

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,900
Beds: 3
Baths: 2
Status: Active
SqFt: 2100
Agency: Expect Realty

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1948
Notes: Highly motivated sellers are inviting all offers. This New Orleans style cottage underwent a complete restoration in 2015. Three bedrooms and two baths, it's all new inside with 1940's charm and style. You will fall in love with the inside, but its grounds and location are its biggest draw. Located one block off the beach on Howard Ave. the heart of the Downtown District. You can walk, bike ride, or golf cart to countless coffee shops, boutiques, restaurants, casinos, bars, breweries, churches, and marinas. NO FLOOD INSURANCE REQUIRED HERE! The lot is 340+feet deep with a second driveway from Baltar Ln. The owner says it's the home's past history as a florist shop and music store that makes this home so welcoming. Lacy New Orleans style iron work decorates the front porch where you can sit and wave to your neighbors as they walk , bicycle, golf cart, or drive by. You might even choose to continue the legacy of hosting epic Fat Tuesday parties as the GCCA Mardi Gras Parade passes in front of the home. The living room's soaring 12 ft ceilings give nod to the home's historic nature. Huge picture windows in front frame the views of the iconic chandelier. Three arch doorways guide you from the living room to the kitchen, dining, and guest areas.The large primary suite shows off three historic brick columns. The ceilings in the sitting area of the primary suite area are 12 ft featuring another beautiful chandelier. The large windows in this area match those in the living area. Another gorgeous archway leads ;you into the room size closet where built-ins and shelving make it very easy to stay organized. The closet has a 15 glass panel door leading out to a small porch. The primary suite bath has beautiful original historic windows, clawfoot tub, and large vanity. The two bedrooms have custom closet organizers. The hall bath features a double vanity, large walk-in shower and beautiful original historic windows. You and your guests will never want to leave the charming light filled eat-in kitchen. Designed for hosting its miles of counter tops and a fantastic walk-in pantry with hardwood shelving and a Julia Childs inspired peg board wall. Built-in wall oven, 36 inch range hood, beveled subway tile and durable slate countertops create the perfect environment for creating fabulous meals. Custom built coffee bar provides additional storage and plenty of space for your morning expresso. But the best part of the kitchen and its dining area are the beautiful original windows that wrap the room.
MlsNumber: 4075708


Listing Provided By: Expect Realty, original listing
Name: Expect Realty
Phone: (228) 215-1861
Office Name: Expect Realty
Office Phone: (228) 215-1861
Agent Name: Steven Stafford
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 = 3419 AND i.igate IN ('usahud','njhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'njhud', 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 Amber Leggett
Amber Leggett
ASCIIStars and Stripes Realty
Call Today!: (228) 209-9040

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App