Title Page Background
DEBUG FN args: Array ( [0] => 1839 [1] => [2] => [3] => agent ) BEFORE: Site: 1839 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1839 Igate: njhud LocID: 1839 Region: State: Experttype: agent Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1839 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'agent' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1839 [1] => [2] => [3] => lender ) BEFORE: Site: 1839 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1839 Igate: njhud LocID: 1839 Region: State: Experttype: lender Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1839 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'lender' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1; DEBUG FN args: Array ( [0] => 1839 [1] => [2] => [3] => other ) BEFORE: Site: 1839 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 1839 Igate: njhud LocID: 1839 Region: State: Experttype: other Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 QUERY: 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 = 1839 AND i.igate IN ('nyhud','ushud') AND m.expertType = 'other' ORDER BY i.igate_index DESC, IF(m.expertpos = 'P', 0, IF(m.expertpos = 'PD', 1, 2)), m.priority, m.datestamp DESC, IF(i.igate = 'nyhud', 0, 1), IF(i.igate = 'ushud', 0, 1) LIMIT 0, 1;

354 Elm Street
Malone, NY 12953

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $155,000
Beds: 3
Baths: Full: 1, ½: 1
Status: Active
SqFt: 1553 Square Feet
Agency: Home Roots Realty
Agency Phone: (518) 578-0138

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1913
Notes: Welcome to 354 Elm Street, a charming single-family home nestled in Malone, NY. With 3 bedrooms, 1.5 bathrooms, and a spacious 1553 sqft, this property offers the perfect blend of comfort, beauty and ease. As you step inside, you'll be greeted by a beautifully updated interior. The new pine walls and ceilings and refinished hardwood floors in all the bedrooms, heated mudroom with a half bath downstairs give this home a warm and inviting atmosphere. With refinished doors, new light fixtures, and new flooring throughout, every detail has been carefully selected to create a stylish and comfortable living space. The updated kitchen boasts refinished cabinets, new flooring, and modern electric appliances, making it a dream for any aspiring chef. The main floor also features a cozy dining room, wonderful for hosting family gatherings which walks right into the family room for functionality.<br /> As you walk up the newly done stairs to the second level, you will find three beautiful bedrooms with new pine walls and ceilings, refinished doors and hardwood floors, creating a warm and welcoming atmosphere. The newly renovated bathroom is tastefully designed with quality fixtures and finishes, ensuring a spa-like experience. And as you walk up to the third floor, let your imagination run wild as you create a game room, craft/hobby spot, or play room for whatever your desires maybe!<br /> Looking for an oversized garage? You'll love the heated double bay 24x36 garages with new automatic garage door openers. As well as the new he/she cave that is a true gem, heated and complete with an entertainment area and bar, making it the perfect spot for relaxation. Another desirable highlight of this property lies beyond its walls. Situated on 0.71 acres, this home offers a large side cleared lot and a private backyard with a fire pit, perfect for entertaining guests. Additional space is available with a 13x21 shed and the paved driveway with ample car space. Call today to make it yours!
MlsNumber: --
ListingId: 202197


Listing Provided By: Home Roots Realty, original listing
Phone: (315) 842-7113
Office Phone: (518) 578-0138
Agent Name: Alanna Mills
Disclaimer: Copyright © 2024 Adirondack Champlain Valley 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