meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='215149' posts_per_page=4 post_type=property
int(1)
Array
(
[ID] => 15603
[post_author] => 4
[post_date] => 2018-11-02 02:29:53
[post_date_gmt] => 2018-11-02 02:29:53
[post_content] => Liberty Hill. The sweet, sweet homes surrounding Dolores Park. Gaze at the downtown skyline after a walk through Dolores Park with the pooch. Not quite Noe Valley or the Castro and rising above Mission Dolores, Dolores Heights is home to some of central San Francisco's most expensive real estate.
[post_title] => Dolores Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => dolores-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:49:28
[post_modified_gmt] => 2024-03-19 20:49:28
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15603
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
ffd_listing_title, 4618 19th Street, San Francisco, CA, 94114
ffd_mls_id, 507033
ffd_salesforce_id, a0E1I00000TTN3mUAH
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 4618 19th Street, San Francisco, CA, 94114
pba__address_pb__c, 4618 19th Street, San Francisco, CA, 94114
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freezer
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1923
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Amanda Z Mulholland
pba__contingentdate__c, 2020-10-19
cooling__c, Room Air
ffd_createddate, 2020-10-20T10:45:59.000+0000
days_on_market__c, 1003
dom__c, 18
ffd_description_pb, Dramatic views, custom build and exquisite design came together to create this incredible oasis at the top of prestigious Eureka Heights. The home sits proud and handsome on a tree-lined street punctuated with other architecturally significant residences, away from the hustle and bustle of San Francisco's urban core yet near enough to enjoy its perks. The list of custom, modern features in this home is long and littered with the best name brands in design, manufacturing and tech: Vola and Watermark in bathrooms, Western Windows, Leight and Aurora Cabinets, Louis Poulsen and Foscarini light fixtures controlled by Lutron smart system, Monarch plan floors and much more. The comfort of radiant heat flooring during the colder months is matched by a multi-zone air conditioning system for the warm days of summer. Copious built-in storage, custom window treatments, two car side by side garage, built-in outdoor kitchen and a level green yard all add to this home's timeless appeal.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant
ffd_lastmodifieddate, 2022-01-25T15:36:03.000+0000
pba__latitude_pb__c, 37.759196
pba__latitude_property__c, 37.759196
laundry_features__c, Inside Room;Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Helena
pba__listing_agent_lastname__c, Zaludova
listing_agent_mls_id__c, 804652
ffd_listingagentname, Helena Zaludova
listing_agent_number__c, 166014293
listing_co_agent_mls_id__c, 808802
listing_co_agent_number__c, 1037619
listing_co_office_mls_id__c, COMP7PAR
listing_co_office_name__c, Compass SF
listing_co_office_number__c, 27677
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 5495000
pba__listingtype__c, Sale
pba__listing_website__c, http://player.vimeo.com/video/463888914
pba__longitude_pb__c, -122.441184
pba__lotsize_pb__c, 0.05
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 507033
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-10-19
original_price__c, 5495000
overall_days_on_market__c, 73
parking__c, Detached,Garage
parking_features__c, Detached,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s);Patio(s)
pba__pendingdate__c, 2020-11-06
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1599.71
pba__propertytype__c, Single Family Residence
id, a0E1I00000TTN3mUAH
room_type__c, Laundry
sale_date__c, 2020-11-17
sale_price__c, 5495000
security_features__c, Smoke Detector;Fire Suppression System
selling_agent_mls_id__c, 400612
selling_agent_name__c, Daniel J. Risman-Jones
selling_agent_number__c, 1023994
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Ascend Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 3435
size__c, 3435
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 19th
subdist__c, The Castro - Dolores Heights
ffd_name, 4618 19th Street, San Francisco, CA, 94114
view__c, San Francisco
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1923
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/371167-1.jpg
ListingId, a0E1I00000TTN3mUAH