meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='238664' 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, 70 Hartford Street, San Francisco, CA, 94114
ffd_mls_id, 422685655
ffd_salesforce_id, a0E8W00000YZ8p3UAD
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 3
address2__c, 70 Hartford Street, San Francisco, CA, 94114
pba__address_pb__c, 70 Hartford Street, San Francisco, CA, 94114
agent_only_remarks__c, Transparent pricing for a fabulous property - clean disclosures. Buyers HIGHLY Motivated. Call/Text Duncan for all showing requests. 415.279.5127 Disclosures available in DIO Escrow Pre-Opened with Old Republic Title - Sharon Chan
appliances__c, Dishwasher;Disposal;Hood Over Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Contemporary;Victorian
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1901
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Duncan C Wheeler
pba__contingentdate__c, 2022-11-04
cooling__c, Central
ffd_createddate, 2022-09-06T10:47:48.000+0000
days_on_market__c, 316
dom__c, 68
ffd_description_pb, Just reduced to the Buy it Now Price. An opportunity not to be missed to own this ultra luxurious, top floor residence in the heart of The Castro on a quiet, tree lined street. The residence includes high ceilings, 3 spacious bedrooms, 2 modern bathrooms, a private deck overlooking Eureka Valley, a beautifully landscaped garden and large enclosed parking. Features include intricate moldings, hardwood floors and custom lighting throughout, soaring ceilings, an abundance of natural light, a marble fireplace in the grand living room, a modern kitchen that opens up to a private deck, and expansive views throughout the residence. Added bonus is the large attic with possible expansion potential as well as low HOA's. Steps away from all of the excitement, conveniences and great restaurants in the Castro. A property not to be missed!
district__c, SF District 5
electric__c, 220 Volts in Laundry,220 Volts
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Water,Trash,Maintenance Grounds,Common Areas
pba__hoafees__c, 398
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 70-72-74 Hartford Street
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Storage Area(s)
ffd_lastmodifieddate, 2023-07-13T17:28:52.000+0000
pba__latitude_pb__c, 37.761337
pba__latitude_property__c, 37.761337
laundry_features__c, Laundry Closet;Washer Included;Dryer Included
listed_date__c, 2022-08-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Rochelle
pba__listing_agent_lastname__c, Vandermerwe
listing_agent_mls_id__c, 811241
ffd_listingagentname, Rochelle Vandermerwe
listing_agent_number__c, 1050646
listing_co_agent_mls_id__c, 804054
listing_co_agent_number__c, 166013489
listing_co_office_mls_id__c, ARTEMIS
listing_co_office_name__c, Artemis Real Estate
listing_co_office_number__c, 28502
listing_office_mls_id__c, ARTEMIS
listing_office_name__c, Artemis Real Estate
listing_office_number__c, 28502
pba__listingprice_pb__c, 1875000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.434251
mls_id__c, 422685655
master_property__c, a0O8W00000EWJhmUAH
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-09-06
original_price__c, 2095000
overall_days_on_market__c, -81332
parking_access__c, Side by Side
parking_features__c, Garage Facing Front,Enclosed,Attached
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2022-11-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1146.79
pba__propertytype__c, Condominium
ListingId, a0E8W00000YZ8p3UAD
room_type__c, Storage;Attic
sale_date__c, 2022-11-28
sale_price__c, 1875000
security_features__c, Smoke Detector;Fire Alarm;Carbon Mon Detector
selling_agent_mls_id__c, 810567
selling_agent_number__c, 1047041
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sage Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1635
size__c, 1635
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Hartford
subdist__c, The Castro - Dolores Heights
ffd_name, 70 Hartford Street, San Francisco, CA, 94114
view__c, City;Garden/Greenbelt
website_property_type__c, Condominium
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1901
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530510198-1.jpg