meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='334332' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15724
[post_author] => 4
[post_date] => 2018-11-02 19:54:44
[post_date_gmt] => 2018-11-02 19:54:44
[post_content] => The grand estates of San Francisco. Commanding views. Lavishly large lots. Neighbors that you could name drop, but that's not your style. Pacific Heights says it all, without saying a word.
[post_title] => Pacific Heights
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => pacific-heights
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-28 07:08:05
[post_modified_gmt] => 2024-03-28 14:08:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15724
[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, 2634 Broderick Street, San Francisco, CA, 94123
ffd_mls_id, 423734769
ffd_salesforce_id, a0E8W00000bc1REUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 0
address2__c, 2634 Broderick Street, San Francisco, CA, 94123
pba__address_pb__c, 2634 Broderick Street, San Francisco, CA, 94123
agent_only_remarks__c, Please contact Bruce Lyon at (415)305-3637, Laurie Nierenberg at (415)710-6900 or Molly Kucera at (415)351-9452 for all appointments. Do not use Showing Time to attempt to schedule appointments as those requests will not reach us. Property website: www.2634Broderick.com
appliances__c, Built-In Gas Range
architectural_style__c, Edwardian
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1910
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Laurie Nierenberg
pba__contingentdate__c, 2023-06-08
ffd_createddate, 2023-04-29T18:47:57.000+0000
days_on_market__c, 81
dom__c, 52
ffd_description_pb, $400K price reduction! Don't miss a golden opportunity to purchase this dramatic, exceptionally well-located Cow Hollow residence with Golden Gate Bridge views! Built circa 1910 on a 27.5' wide lot, this outstanding home has been owned by the same family for over 50 years and now awaits its next owner to bring their own personal vision to this special property. The main level features a formal entry and living room with fireplace plus a formal dining room that opens out to the enchanting, lush rear garden. The eat-in kitchen affords outstanding light throughout the day and a powder room completes the level. The second level offers three sizable bedrooms including the master bedroom which features GGB views, a fireplace, and an updated, en-suite bathroom with closet space. The second bedroom includes a walkout deck that overlooks the rear garden, and the third bedroom offers an en-suite bathroom. The third level features a fourth bedroom, a full bathroom, a family room that also offers the fantastic GGB views, and a private sun deck. The lower lever includes a one-car garage with interior access, a laundry area and abundant storage.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 2
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-07-13T18:48:23.000+0000
pba__latitude_pb__c, 37.7947224
pba__latitude_property__c, 37.7947224
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2023-03-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Bruce
pba__listing_agent_lastname__c, Lyon
listing_agent_mls_id__c, 802384
ffd_listingagentname, Bruce Lyon
listing_agent_number__c, 802384
listing_co_agent_mls_id__c, 069620
listing_co_agent_number__c, 69620
listing_co_office_mls_id__c, CBLUXURY
listing_co_office_name__c, Coldwell Banker Realty
listing_co_office_number__c, 2128
listing_office_mls_id__c, CBLUXURY
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 2128
pba__listingprice_pb__c, 4875000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.2634Broderick.com
pba__longitude_pb__c, -122.4432902
lower_level__c, Garage
mls_id__c, 423734769
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-29
original_price__c, 5275000
overall_days_on_market__c, -81567
parking_access__c, Independent
parking_features__c, Attached,Garage Facing Front
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-06-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1413.84
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bc1REUAY
sale_date__c, 2023-07-03
sale_price__c, 4800000
selling_agent_mls_id__c, 805322
selling_agent_number__c, 166015212
selling_co_agent_mls_id__c, EB290890
selling_co_agent_number__c, 981314533
selling_co_office_mls_id__c, 84291
selling_co_office_name__c, Mosaik Real Estate
selling_co_office_number__c, 981008558
selling_office_name__c, Mosaik Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 3395
size__c, 3395
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Broderick
subdist__c, Pacific Heights
ffd_name, 2634 Broderick Street, San Francisco, CA, 94123
view__c, Golden Gate Bridge
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1910
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530611184-1.jpg