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

2403 W Loma Drive
Artesia, NM 88210-9406
Karen Miller with Harwell & Associates Real Estate, original listing - (575) 748-1036

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $525,000
Beds: 3
Baths: Full: 2, ½: 1
Status: Pending
SqFt: 3002 Square Feet
Agency: Harwell & Associates Real Estate
Agency Phone: (575) 748-1036

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: --
Notes: WELCOME! To this REMARKABLE, SPACIOUS, and very WELL-MAINTAINED Brick 3 Bedroom 2.5 Bath with a guest house home. This 3,022 sq. ft including the guest house, with a very large driveway in front, and Andersen Windows throughout the home. Entering the house you will see an entry way, to the right is a living room that leads to the dining room. The dining room comes off of the updated gorgeous kitchen featuring: soft-close custom cabinets, granite counter tops, built in microwave, large oven, bread warmer, pantry, refrigerator, dishwasher convey. Bedroom 1 has a walk-in closet, Bedroom 2 has a large closet, the bathroom for these 2 bedrooms is located in the hallway. This bathroom has a walk-in shower as well as tub. A bonus room currently used as a music room could be 4th bedroom as it has a closet and a window. The primary bedroom includes cozy space, a closet, and access to an awesome covered porch that overlooks the pool. The primary bathroom has double sinks, a closet, separate shower and tub. Attached includes a double car insulated 608 sq. ft garage: 220 wiring, 3 large storages, pantry, tankless gas water heater & water softener, partially floored attic with shelves, side door 1 leading to the backyard, and side door 2 leads to guest house. Backyard: water-well that only waters front and back yard, 8 1/2 block fence, 1 sliding gate, sprinkler system , pool with decking, Fenced garden area with raised flowerbeds and a producing apple tree in the middle of it. THIS IS A MUST SEE HOM!EHURRY! IT WONT LAST LONG!
MlsNumber: --
ListingId: 20251209


Listing Provided By: Harwell & Associates Real Estate, original listing
Phone: (575) 703-6121
Office Phone: (575) 748-1036
Agent Name: Karen Miller
Disclaimer: Copyright © 2025 New Mexico MLS. 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