_yoast_indexnow_last_ping,1725677887
ffd_listing_title,4150 17th Street #24, San Francisco, CA, 94114
ffd_mls_id,424062885
ffd_salesforce_id,a0EUd0000033DYcMAM
num_of_fireplaces__c,1
num_of_rooms__c,0
of_units__c,33
address2__c,4150 17th Street #24, San Francisco, CA, 94114
pba__address_pb__c,4150 17th Street #24, San Francisco, CA, 94114
agent_only_remarks__c,Escrow open with Michael Gaffney at Fidelity. For more information please contact: Shane:415-225-5990. Julie:415-730-6387
appliances__c,Dishwasher;Disposal;Free Standing Gas Oven;Free Standing Refrigerator
bath_features__c,Double Sinks;Jetted Tub
pba__fullbathrooms_pb__c,2
pba__bedrooms_pb__c,2
year_build_text__c,1994
pba__city_pb__c,San Francisco
listing_co_agent_name__c,Julie F Rogers
pba__contingentdate__c,1800-01-01
cooling__c,Central
ffd_createddate,2024-09-06T20:48:41.000+0000
days_on_market__c,0
dom__c,0
ffd_description_pb,This modern, remodeled end unit townhome at the coveted Eureka Gardens is unequivocally compelling both in terms of style and utility. The floor plan features a distinct & separate kitchen & dining area. The kitchen has an expansive breakfast bar and new quartz counters. A large & separate (pent level) living rm with fireplace, wet bar and walkout deck is the ideal space for entertaining or a quiet evening lounging at home and looking out over the views. The 2 bedrooms are on their own levels. The primary suite has an updated full bath w/ dual sinks and walk-in shower. The 2nd bedroom is adjacent to another full bath w/ jetted tub. This home more than checks the boxes. It has been beautifully remodeled to reflect a modern & contemporary aesthetic. Eureka Gardens provides the perfect confluence of ideal walkability to everything Upper Market/Castro has to offer PLUS the privacy afforded by the set back, off-the-street positioning of the building. This is one of the few end-units that affords you even more serenity. In-unit laundry plus a separate 2-car garage is exclusive to this unit. In a city where we often crave to be in the center of it all but also yearn for those moments of peace and separation in our living space, 4150 17th Street #24 is the rare find that offers it all.
district__c,SF District 5
entry_level__c,0
external_listing__c,1
fireplace_features__c,Living Room;Wood Burning
pba__floortype_pb__c,Carpet;Wood
hoa_fee_includes__c,Common Areas,Homeowners Insurance,Maintenance Grounds,Management,Trash,Water
pba__hoafees__c,855
hoa_name__c,Eureka Garden Homeowners' Association
hoa__c,Yes
pba__halfbathrooms_pb__c,0
has_3d_tour__c,1
pba__heatingtype_pb__c,Central
ffd_lastmodifieddate,2024-09-07T02:47:47.000+0000
pba__latitude_pb__c,37.7627851
pba__latitude_property__c,37.7627851
laundry_features__c,Washer/Dryer Stacked Included;Inside Area
listed_date__c,2024-09-05
pba__listing_agent_email__c,[email protected]
pba__listing_agent_firstname__c,Shane
pba__listing_agent_lastname__c,Ray
listing_agent_mls_id__c,807674
ffd_listingagentname,Shane R Ray
listing_agent_number__c,1023667
listing_co_agent_mls_id__c,803159
listing_co_agent_number__c,803159
listing_co_office_mls_id__c,COMP90
listing_co_office_name__c,Compass
listing_co_office_number__c,29048
listing_office_mls_id__c,COMP90
listing_office_name__c,Compass
listing_office_number__c,29048
pba__listingprice_pb__c,1595000
pba__listingtype__c,Sale
pba__listing_website__c,https://my.matterport.com/show/?m=SGorC3Ditpi&mls=1
pba__longitude_pb__c,-122.4385316
lower_level__c,Bedroom(s)
mls_id__c,424062885
main_level__c,Kitchen;Dining Room
master_bathroom_features__c,Shower Stall(s);Double Sinks
master_property__c,a0O1I000001VhihUAC
monthly_parking_fees__c,0
monthlyrent__c,0
parkingspaces__c,2
on_market_date__c,2024-09-06
open_house_end__c,2024-09-07T16:00:00.000+0000
open_house_start__c,2024-09-07T14:00:00.000+0000
original_price__c,1595000
overall_days_on_market__c,-82063
parking_access__c,Independent
parking_features__c,Garage Door Opener,Guest Parking Available,Interior Access
parking_type__c,On Site - Mapped (Condo Only)
patio_and_porch_features__c,Uncovered Deck
pba__pendingdate__c,1800-01-01
possible_bedrooms__c,0
pba__pricechangedat__c,1800-01-01T00:00:00.000+0000
price_per_square_foot__c,951.1
pba__propertytype__c,Condominium
ListingId,a0EUd0000033DYcMAM
sale_date__c,1800-01-01
sale_price__c,0
selling_agent_number__c,0
selling_co_agent_number__c,0
selling_co_office_number__c,0
pba__status__c,Active
pba__totalarea_pb__c,1677
size__c,1677
pba__state_pb__c,CA
stories__c,0
pba__street_pb__c,17th
subdist__c,Corona Heights
ffd_name,4150 17th Street #24, San Francisco, CA, 94114
view__c,City;City Lights;San Francisco;Twin Peaks;Valley
website_property_type__c,Condominium
pba__yearbuilt_pb__c,1994
pba__postalcode_pb__c,94114
ffd_media,Array
ffd_media_tags,Array
ffd_featured_image,https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530838034-1.jpg