meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='235993' 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, 4127 20th Street, San Francisco, CA, 94114
ffd_mls_id, 422650806
ffd_salesforce_id, a0E8W00000WhlG7UAJ
num_of_fireplaces__c, 3
num_of_rooms__c, 0
of_units__c, 0
address2__c, 4127 20th Street, San Francisco, CA, 94114
pba__address_pb__c, 4127 20th Street, San Francisco, CA, 94114
agent_only_remarks__c, Photos and floorplan forthcoming. Escrow is opened with Fidelity National Title, Sam Saravia. Please use latest SFAR offer form. For disclosures, please email [email protected]. For showings, please text 415.793.3470. Please do not use ShowingTime.
appliances__c, Dishwasher;Built-In Gas Oven;Built-In Refrigerator;Gas Cook Top
architectural_style__c, Victorian
bath_features__c, Double Sinks
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1898
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-04-22T19:47:50.000+0000
days_on_market__c, 453
dom__c, 11
ffd_description_pb, Perched on the rolling hills of Dolores Heights, this extensively renovated Queen Anne Victorian intertwines period detailing with modern, designer finishes. A timeless facade draws you into the 3-level residence where bay windows capture iconic city views. From the soaring ceilings and refinished wood flooring to the custom millwork and embellished fireplace, the double parlor accentuates the home's classic design. The chef's kitchen, entirely remodeled with high-end appliances, makes indoor-outdoor living possible. French doors connect the breakfast nook to the sprawling deck and professionally landscaped, southern-facing garden. Across from the powder room, stairs lead up to the 4-beds/2-baths, and a bespoke home office. An attached 2-car garage, customized closets, and solar panels complete this distinguished retreat. Situated at the intersection of 3 coveted neighborhoods the Castro, Noe Valley, and Mission Dolores this truly is San Francisco living at its finest.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Kitchen;Primary Bedroom
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
pba__heatingtype_pb__c, Fireplace(s)
ffd_lastmodifieddate, 2022-05-18T22:47:05.000+0000
pba__latitude_pb__c, 37.757534
pba__latitude_property__c, 37.757534
laundry_features__c, In Kitchen;Washer/Dryer Stacked Included
listed_date__c, 2022-02-24
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Magdalena
pba__listing_agent_lastname__c, Visser
listing_agent_mls_id__c, 808571
ffd_listingagentname, Maggie S Visser
listing_agent_number__c, 1036951
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 4200000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=A45fdEn9Ywz
pba__longitude_pb__c, -122.433159
mls_id__c, 422650806
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Double Sinks;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-04-22
original_price__c, 4200000
overall_days_on_market__c, -81195
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2022-05-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 2022-05-18T08:45:54.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Single Family Residence
id, a0E8W00000WhlG7UAJ
sale_date__c, 2022-05-17
sale_price__c, 4750000
selling_agent_mls_id__c, 803025
selling_agent_number__c, 803025
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 20th
subdist__c, The Castro - Dolores Heights
ffd_name, 4127 20th Street, San Francisco, CA, 94114
view__c, City
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1898
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530443352-1.jpg
ListingId, a0E8W00000WhlG7UAJ