Title Page Background
DEBUG FN args: Array ( [0] => 3245 [1] => [2] => [3] => agent ) BEFORE: Site: 3245 LocID: Region: State: agent Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3245 Igate: njhud LocID: 3245 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 = 3245 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] => 3245 [1] => [2] => [3] => lender ) BEFORE: Site: 3245 LocID: Region: State: lender Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3245 Igate: njhud LocID: 3245 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 = 3245 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] => 3245 [1] => [2] => [3] => other ) BEFORE: Site: 3245 LocID: Region: State: other Experttype: Expertnum: 1 ProcessOverride: 1 SearchNearby: DisplayCount: 1 SITE IS NUMERIC, SWAPPING IFELSE numeric IFELSE else AFTER: Site: 3245 Igate: njhud LocID: 3245 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 = 3245 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;

1603 Robertson Pl
Bronx, NY 10465

« Prev
Next »
Currently Displayed Property Photo


Property Details


List Price: $599,888
Beds: 4
Baths: Full: 3
Status: Active
SqFt: 2605 Square Feet
Agency: Re/Max Elite
Agency Phone: (718) 690-3900

Map Details Show Map | Show StreetView




Description/Comments


Lot Size: 0 acre(s)
Garage: Garage
Property Type: Residential-Single Family Residence
Year Built: 1935
Notes: Discover your dream home in the stunning Spencer Estates-Country Club neighborhood, where this gorgeous detached single-family home is perfectly situated on a tranquil, tree-lined street on a spacious corner lot measuring 100 ft x 69.75 ft. This property qualifies for FHA 203(k) financing, allowing you to customize improvements to your liking. Upon entering through the front door, you're greeted by a grand foyer leading to an expansive living room filled with natural sunlight from oversized windows, accommodating your largest furniture pieces and featuring soaring ceilings for added openness. Flowing down the hallway, you'll find two spacious bedrooms, each with ample closet and storage space for all your personal belongings, alongside a fully equipped eat-in kitchen with custom wood cabinetry, a charming breakfast nook, and a door providing separate access to the backyard. A conveniently designed bathroom off the hallway is perfect for guests. Ascend to the second floor, where two additional large bedrooms await, both featuring abundant closet space, alongside a cozy living room, an eat-in kitchen, and a bathroom, offering an ideal retreat for family members or guests. Descend to the basement, where a vast open space can be configured as a home gym, office, or recreational area, complemented by a versatile bonus room for extra utility. This level also includes a dedicated laundry room and an electrical room connected by a shared hallway, along with another bathroom for convenience. Step outside to a generously sized backyard perfect for al fresco dining, hosting summer gatherings, or lounging under the sun, with endless possibilities for creating your personal oasis. The property features a private driveway, a detached one-car garage, and an adjacent gated lot that can accommodate one to two cars, depending on size, allowing for a total of about 3 to 4 cars. Additionally, there is plenty of street parking for easy access. Don't miss this incredible opportunity to make this beautiful home yours! PLEASE READ: All showings are exclusively conducted through open houses; private viewings are NOT an option, so kindly refrain from requesting a private viewing as we are unable to accommodate such request. Open House times will be posted one week prior to the scheduled open house to allow ample planning time. We ask that all interested parties keep it saved online so you can receive notifications about upcoming open house times, and when an upcoming open house time is made available, you'll be notified. Brokers/Agents have the option to send their clients to the open house by texting or emailing buyer information ahead of time if they cannot attend together. Disclaimer: All information provided is deemed reliable, but is not guaranteed and should be independently verified.
MlsNumber: --
ListingId: 11346682


Listing Provided By: Re/Max Elite, original listing
Phone: (718) 690-3900
Office Phone: (718) 690-3900
Agent Name: Michael Rastegar
Disclaimer: Copyright © 2024 My State 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