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

2821 W Libby Street
Phoenix, AZ 85053
Elvia Santillan with eXp Realty, original listing - (602) 525-3224

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $700,000
Beds: 5
Baths: Full: 3
Status: Active
SqFt: 2636 Square Feet
Agency: eXp Realty
Agency Phone: (602) 525-3224

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Other
Year Built: 2019
Notes: Welcome to your dream home, a one-of-a-kind custom-built masterpiece that exudes elegance and sophistication. Built in 2019, this is the newest two-story house on the block, featuring a grand entry with a stunning wood door that sets the tone for the luxury within. This exceptional residence offers unparalleled luxury and modern amenities, ensuring a lifestyle of comfort and convenience. With five generously sized bedrooms, there's ample space for family, guests, or even a home office. Each bedroom is designed to provide maximum comfort and privacy, complemented by three beautifully appointed full bathrooms with high-end fixtures and finishes, offering a spa-like retreat for your daily routine.The heart of the home features custom cabinets and top-of-the-line stainless steel appliances, perfect for the home chef. Granite countertops add a touch of elegance to the kitchen's open layout, which is ideal for entertaining and family gatherings. The living spaces are adorned with stunning wood floors, and the grand wood staircase adds warmth and charm to the interior. Vaulted ceilings create an airy and spacious ambiance, while double wide patio glass doors seamlessly connect the indoors with the outdoor living areas.<br /> <br /> For those with a passion for travel, the RV gate provides convenient storage and access for your recreational vehicles, making it easy to embark on your next adventure. The home is equipped with two high-efficiency air conditioning units, ensuring comfort throughout the year. Energy-efficient windows by Milgard and foam insulation enhance the home's sustainability and energy savings. Recessed lighting throughout the home provides a modern touch and brightens every corner. The garage features an 8-foot door with extended height, perfect for larger vehicles. Additionally, the oversized water heater ensures that you'll never run out of hot water.<br /> <br /> The extended back patio is perfect for outdoor living and entertaining, complete with electrical wiring for up to three ceiling fans. The backyard also features a full-size shed for extra storage and is enclosed by a block stucco wall for added privacy and security. The home also boasts a comprehensive salt water filtration system for clean and healthy living.<br /> <br /> The exterior of this custom-built gem boasts a stylish stucco finish, adding to its unique architectural design. Every detail of this home has been thoughtfully designed to offer the utmost in modern living. From the open-concept living spaces to the high-quality materials used throughout, this home is the epitome of luxury. This property is not just a house; it's a lifestyle. Don't miss the opportunity to own this extraordinary home that combines unique design, luxurious features, and modern amenities. Schedule a private tour today and experience the beauty and elegance of this exceptional property.
MlsNumber: --
ListingId: 6713274


Listing Provided By: eXp Realty, original listing
Phone: (602) 525-3224
Office Phone: (602) 525-3224
Agent Name: Elvia Santillan
Disclaimer: Copyright © 2024 Arizona Regional Multiple Listing Service, Inc. 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 = 3423 AND i.igate IN ('usahud','azhud','ushud') AND m.expertType = 'agent' ORDER BY 1, IF(i.igate = 'usahud', 0, 1), IF(i.igate = 'azhud', 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 Melody Holehan-Kopas and Jay Kopas
Melody Holehan-Kopas and Jay Kopas
ASCIIHome Smart Elite Group - Kopas Home Team
Melody: (623) 910-5788
Jay: (623) 680-5183

USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App