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

58 Warwick Road
Mobile, AL 36608

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $2,995,000
Beds: 5
Baths: 6
Status: Active
SqFt: --
Agency: LLB&B Inc., Real Estate

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: --
Property Type: Residential
Year Built: 1965
Notes: Gorgeous Wimbledon subdivision 5/4/2 Estate home loaded with amenities and updates conveniently located in the heart of Country Club of Estates neighborhood. Built in 1965 by a family in the hardwood business, this home has so many beautiful Old-World details including quarter sawn wide plank white oak pegged hardwood floors, high ceilings, large cased openings, pecan tongue and groove paneling and mantle in the family room, and Spanish Cedar hardwood on the exterior. Currently owned and updated by a very talented interior designer, this property has been gracefully renovated with a fresh, current, modern aesthetic. Per the Sellers, they have made the following improvements: full kitchen renovation, aluminum clad/wood windows across the front, new windows in the kitchen and den, roof over the back porch, 1 new hvac system, 4 toilets, 2 hot water heaters, generator to run entire downstairs, shiplap walls in foyer, copper gutters, entire renovation of backyard with landscape, fencing, sod, peacock paver patio, grilling area with grill and flat top grill, whole house exterior painted, new office cabinetry, all cased openings raised, and new French doors to porch. Other updates include a new walk in pantry, new powder room with exquisite marbleized Geode wallpaper, new laundry room with wonderful cabinetry /storage and striated marble countertop. All drapes and light fixture remain including lighting by Visual Comfort, Urban Electric, Paul Ferranti, Brendon Ravenhill and newly installed Bevolo exterior gas lanterns. Enter to the foyer that is flanked by a very large living room with tall windows and a marble mantle and wood burning fireplace. It flows to the pecan paneled family room with wood burning fireplace, and on to the new kitchen. The kitchen is fabulous with extra thick marble counters, marble backsplash and wonderful long marble shelf above the 36”Wolf gas cooktop. Wolf Designer series handle free double ovens, Kitchen Aid dishwasher, Kohler cast iron farmhouse sink, Sub-Zero Refrigerator, new sleek white oak cabinets, new bar area with steel cabinetry and Sub-Zero wine fridge. The renovation in this area provides for the kitchen, an island, the bar, a breakfast space and a keeping room in one common area with handsome oversized limestone floors. You have egress from the kitchen to the 2-car carport as well as to the incredibly fantastic long back porch with new awning overlooking the freshly landscaped yard. The large dining room has a bay window and egress to the back porch. Down the 1st floor hall, you have a bedroom currently used as a study, the new laundry room, a large bedroom with a renovated ensuite bath with marble & subway tile. The very large primary bedroom has room for a seating area and has a travertine primary bath with separate walk in closets and vanities, and separate shower and tub. Upstairs is a large bedroom with a big closet and newly added marble and subway tile bath. A second large bedroom, a large hall bath with a shower and a giant bonus room round out the upstairs. Added amenities are tons of walk-in attic space, an irrigation system, an alarm, a workshop with a ½ bath and window unit complete with an infrared sauna. Make your appointment today to see this lovely Spring Hill gem!
MlsNumber: 7387001


Listing Provided By: LLB&B Inc., Real Estate, original listing
Name: LLB&B Inc., Real Estate
Phone: (251) 342-3200
Office Name: L L B & B, Inc.
Office Phone: (251) 342-3200
Agent Name: Melissa Morrissette
Disclaimer: Copyright © 2024 Gulf Coast MLS. 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 = 48 AND i.igate IN ('usahud','alhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'alhud', 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;
Kristen Compretta
ASCIIKeller Williams Realty
Call Today!: (505) 917-5231

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App