meta_query='key:subdist__c;value:Pacific Heights|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='332684' 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] => 2018-11-02 19:54:44
[post_modified_gmt] => 2018-11-02 19:54:44
[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, 2461 Buchanan Street, San Francisco, CA, 94115
ffd_mls_id, 423724416
ffd_salesforce_id, a0E8W00000bbxGpUAI
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 3
address2__c, 2461 Buchanan Street, San Francisco, CA, 94115
pba__address_pb__c, 2461 Buchanan Street, San Francisco, CA, 94115
agent_only_remarks__c, Contact Paul or Holly for showings. Note that 3rd bedroom is small, best for nursery or home office.
appliances__c, Disposal;Hood Over Range;Built-In Gas Range;Free Standing Refrigerator
architectural_style__c, Contemporary;Victorian
bath_features__c, Shower Stall(s);Tile;Window
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2023-04-28T10:49:37.000+0000
days_on_market__c, 42
dom__c, 40
ffd_description_pb, Perfectly situated on the corner of two flat Pacific Heights blocks, this sophisticated Queen Anne Victorian with 2BR plus den and office is an alluring and majestic beauty. Superbly renovated with designer finishes throughout, the home retains many fine Victorian details which have been thoughtfully preserved to create a harmonious balance of classic and modern. The bright, spacious, and flexible floorplan makes it easy to work from home or entertain guests, with formal and casual dining areas, an elegant living room, and a separate office. 12-foot ceilings give remarkable scale to the main living areas, and an impressive wood burning fireplace is the dramatic centerpiece. Hardwood floors run throughout, while in-unit washer/dryer and 1 car independent parking complete this exceptional home. Just steps to the best boutiques, cafes, and dining of upper Fillmore, this highly prized property embodies the essence of San Francisco living.
district__c, SF District 7
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Trash,Water
pba__hoafees__c, 559
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 2457-2461 BUCHANAN STREET HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2023-06-07T22:49:34.000+0000
pba__latitude_pb__c, 37.792728
pba__latitude_property__c, 37.792728
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-03-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Paul
pba__listing_agent_lastname__c, Warrin
listing_agent_mls_id__c, 803577
ffd_listingagentname, Paul Warrin
listing_agent_number__c, 803577
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, DECK10
listing_office_name__c, Golden Gate Sotheby's International Realty
listing_office_number__c, 28264
pba__listingprice_pb__c, 1995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4315
mls_id__c, 423724416
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tile;Jetted Tub;Window
master_property__c, a0O8W00000FqFzhUAF
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-04-27
open_house_end__c, 2023-06-11T16:00:00.000+0000
open_house_start__c, 2023-06-11T14:00:00.000+0000
original_price__c, 1995000
overall_days_on_market__c, -81565
parking_access__c, Side by Side
parking_features__c, Attached,Covered,Enclosed,Garage Door Opener,Garage Facing Side,Interior Access,Side-by-Side
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1187.5
pba__propertytype__c, Condominium
ListingId, a0E8W00000bbxGpUAI
roof__c, Tar/Gravel
room_type__c, Office;Den
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1680
size__c, 1680
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Buchanan
subdist__c, Pacific Heights
ffd_name, 2461 Buchanan Street, San Francisco, CA, 94115
website_property_type__c, Condominium
window_features__c, Window Coverings;Dual Pane Partial
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94115
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530586741-1.jpg