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

1605 Walnut Ct.
Harlingen, TX 78550

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $310,000
Beds: 3
Baths: Full: 3
Status: Active
SqFt: 2164 Square Feet
Agency: RE/MAX ELITE
Agency Phone: (956) 496-2012

Map Details Show Map | Show StreetView




House Features

Appliances: None
Architectural Style: Other
Construction Materials: Brick, Brick Veneer
Flooring: Tile
Heating: Central Furnace
Interior Features: Ceiling Fans, Security System, Other, High Ceilings, Walk-in Closet(s), Built-in Features, Crown Molding, Smoke Detectors, Video Surveillance, BONUS ROOM, Office/Study, Internet Access, Residential Service
Rooms: Office, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Bedroom 3, Bonus Room
Security Features: Security System

Window Features

Exterior Features: Fence, See Remarks, Other, Curb & Gutter, Alley
Fencing: Fenced
Parking Features: Garage
Other Features: See Remarks
Roof: Composition

Neighborhood/Schools

Elementary School/District: Austin
Middle/Junior High School/District: /Kingsville ISD
High School/District: HARLINGEN/HARLINGEN C.I.S.D.
Subvidision Name: Parkside Estates

Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1984
Notes: Beautifully remodeled 3 bedroom, 3 full bathroom home is nestled in a highly desirable and established neighborhood in Harlingen, Tx! This home boasts of 2 living rooms, 2 dining areas, a bonus room, a sunroom, separate entrances, maid's quarters and so much more. Bedroom #3 has it's own separate front entrance, fenced side yard and bathroom. It can easily be used as for a home office. The home has beautiful Saltillo tile flooring through out. The large kitchen has lots of cabinets and a pantry for storage. It also has a custom rolling island. The home has high ceilings, lots of built ins. The inviting fireplace is perfect for cold winter nights. The lot is over 10,000 square feet. It is divided into 2 large separate yards and both enclosed with a privacy fence. Paved walkways lead to several sitting areas with mature trees full of a variety of birds. The 2-car oversized garage is in the back of the home with a paved alley entrance for convenience. *Home is currently being leased.
MlsNumber: --
ListingId: 29748207


Listing Provided By: RE/MAX ELITE, original listing
Phone: (956) 789-4700
Office Phone: (956) 496-2012
Agent Name: LYNN REYNA
Disclaimer: Copyright © 2024 Rio Grande Valley 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.


USHUD.com on the Go!

Foreclosure Mobile App
Ushud Foreclosure iPhone App
Ushud Foreclosure Android App