meta_query='key:subdist__c;value:The Castro - Dolores Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='214818' 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, 25 Hartford Street, San Francisco, CA, 94114
ffd_mls_id, 504737
ffd_salesforce_id, a0E1I00000THmj3UAD
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 0
address2__c, 25 Hartford Street, San Francisco, CA, 94114
pba__address_pb__c, 25 Hartford Street, San Francisco, CA, 94114
agent_only_remarks__c, Feels incredibly large and indoor/outdoor. Perfect flow. All showings are by appointment only and carried out according to state and local COVID protocols.Virtual media is here: https://www.hartfordstreetbeauty.com. Please call Jessica 415-341-7177 with any questions and schedule showings here: https://calendly.com/jessicabranson/25-hartford-private-appointment
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1901
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2020-09-28
ffd_createddate, 2020-09-22T19:45:49.000+0000
days_on_market__c, 1030
dom__c, 7
ffd_description_pb, Nestled on a quiet, tree-lined, Victorian-era block in the heart of the Castro, this gorgeous 2lvl, 3BDR/2.5BA Queen Anne home on an extra deep, 3125 ft lot is the one! Soaring ceilings, rich wood flrs, original int wood staircase, and crown molding. LR w bay wndws, marble tiled gas fireplace. Sleek powder rm. Huge FDR w custom French drs opens spacious deck perfect for entertaining. Renovated pro KIT w ample work and storage space, top of the line stainless applncs, and sun filled brkfst rm opens to deck and garden. Skylit upper lvl w 3 spacious BDRs, and 2 b'ful renovated BAs. Main BDR w en suite full tiled BA and walk-in closet. Expansive, pro designed, lush, lvl garden and stone patio. Enormous 3 car garage w electric car outlet + work room. Expansion pot'l previously approved rear yard expansion plans by John Lum Architecture. New foundation 1999. Walk to Frances, Le Marais, Dolores Park, Bi-Rite, and more world class destinations - 99 WalkScore! You can have it all!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Gas Piped
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 1
has_3d_tour__c, 1
ffd_lastmodifieddate, 2022-01-25T15:34:46.000+0000
pba__latitude_pb__c, 37.7621107
pba__latitude_property__c, 37.7621107
listed_date__c, 2020-07-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jessica
pba__listing_agent_lastname__c, Branson
listing_agent_mls_id__c, 805610
ffd_listingagentname, Jessica Branson
listing_agent_number__c, 166015601
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 2595000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=Gntpz6bdZYc&mls=1
pba__longitude_pb__c, -122.4337241
pba__lotsize_pb__c, 0.07
mls_id__c, 504737
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2020-09-22
original_price__c, 2595000
overall_days_on_market__c, 88
parking__c, Attached,Garage,Auto Door
parking_features__c, Attached,Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-09-29
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1444.44
pba__propertytype__c, Single Family Residence
id, a0E1I00000THmj3UAD
room_type__c, Sun Room
sale_date__c, 2020-10-23
sale_price__c, 2795000
selling_agent_mls_id__c, 804005
selling_agent_name__c, Julie E. Peisner
selling_agent_number__c, 166013400
selling_co_agent_mls_id__c, 802084
selling_co_agent_name__c, Jesse E. Fowler
selling_co_agent_number__c, 802084
selling_co_office_mls_id__c, STHB
selling_co_office_name__c, Sotheby's International Realty
selling_co_office_number__c, 2050
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1935
size__c, 1935
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, Hartford
subdist__c, The Castro - Dolores Heights
ffd_name, 25 Hartford Street, San Francisco, CA, 94114
transportation__c, 1 Block
website_property_type__c, Single Family Home
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/370423-1.jpg
ListingId, a0E1I00000THmj3UAD