meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214984' 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, 519 Sanchez Street, San Francisco, CA, 94114
ffd_mls_id, 506671
ffd_salesforce_id, a0E1I00000TUwbBUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 10
of_units__c, 0
address2__c, 519 Sanchez Street, San Francisco, CA, 94114
pba__address_pb__c, 519 Sanchez Street, San Francisco, CA, 94114
agent_only_remarks__c, Massive $350K reduction bring offers this seller is motivated! please contact me (Anthony) to arrange a showing 415-218-2530 [email protected] matterport https://my.matterport.com/show/?m=R5GyXsji7G4&brand=0 and video https://vimeo.com/461367417
appliances__c, Dishwasher;Microwave;Disposal;Refrigerator;Hood Over Range;Cooktop Stove;Double Oven;Built-In Oven
architectural_style__c, Victorian
bath_features__c, Shower Stall(s);Tub;Low-Flow Toilet(s);Dual Flush Toilet
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1905
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2020-10-30T16:46:15.000+0000
days_on_market__c, 1028
dom__c, 38
ffd_description_pb, All new detached 5-bed 4.5-bath Vict. view home at Sanchez and Hancock one block to Dolores Park. 3-stories, all with amazing views. 3-beds & 3-full baths plus an office on the top floor. The retractable skylight leads to a 400 sqft roof deck with downtown skyline and Twin Peaks views. An additional 2-beds & 1-full bath on the 1st floor with a kitchenette and direct access to the yard. The main level has soaring 10'+ ceilings, an open plan from the facade to the back yard with a formal living room, all Thermador center kitchen, a 5-seat peninsula, a family room, and dining room. This floor also has an 84 bottle temperature-controlled wine room and a powder room. There are three distinct outdoor spaces, the roof deck, a view deck off the master suite, and the private, landscaped backyard. There are stunning outlooks and views from every room and every level. This is a very rare must-see detached property.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-25T15:35:23.000+0000
pba__latitude_pb__c, 37.7607473
pba__latitude_property__c, 37.7607473
laundry_features__c, Laundry Closet;Washer/Dryer Included
listed_date__c, 2020-09-22
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Anthony
pba__listing_agent_lastname__c, Koutsos
listing_agent_mls_id__c, 803007
ffd_listingagentname, Anthony L Koutsos
listing_agent_number__c, 803007
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, KWRSF
listing_office_name__c, Keller Williams San Francisco
listing_office_number__c, 26158
pba__listingprice_pb__c, 4998500
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/461367417
pba__longitude_pb__c, -122.4302342
pba__lotsize_pb__c, 0.06
lower_level__c, Bedroom(s),Full Bath(s),Kitchen,Living Room
mls_id__c, 506671
main_level__c, Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-09-24
original_price__c, 5350000
overall_days_on_market__c, 463
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Deck(s)
pba__pendingdate__c, 2020-11-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E1I00000TUwbBUAT
roof__c, Bitumen
room_type__c, Den;Wine Cellar;In Law Apartment
sale_date__c, 2020-11-13
sale_price__c, 4800000
selling_agent_mls_id__c, MLSL477271
selling_agent_number__c, 981148086
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Intero Real Estate Services
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Sanchez
subdist__c, The Castro - Dolores Heights
ffd_name, 519 Sanchez Street, San Francisco, CA, 94114
transportation__c, 1 Block
view__c, Panoramic;City Lights;Downtown;Twin Peaks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1905
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/370807-1.jpg
ListingId, a0E1I00000TUwbBUAT