meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='371341' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15726
[post_author] => 4
[post_date] => 2018-11-02 19:54:49
[post_date_gmt] => 2018-11-02 19:54:49
[post_content] => Once a dairy farm. Now it's where global day-traders and future financiers in training come to rest their spreadsheet-weary eyes at night. Home to Union Street shops and restaurants, as well as classic north end style, served in slightly smaller sizes than the estates of Pacific Heights.
[post_title] => Cow Hollow
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => cow-hollow
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-09 10:58:51
[post_modified_gmt] => 2024-04-09 17:58:51
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15726
[menu_order] => 0
[post_type] => community
[post_mime_type] =>
[comment_count] => 0
[filter] => raw
[ancestors] => Array
(
)
[page_template] =>
[post_category] => Array
(
)
[tags_input] => Array
(
)
)
_yoast_indexnow_last_ping, 1706788605
ffd_listing_title, 2950 Fillmore Street, San Francisco, CA, 94123
ffd_mls_id, 424001152
ffd_salesforce_id, a0EUd000000vJQxMAM
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 3
address2__c, 2950 Fillmore Street, San Francisco, CA, 94123
pba__address_pb__c, 2950 Fillmore Street, San Francisco, CA, 94123
agent_only_remarks__c, First time on the market! Easy to show by appointment. Please email [email protected]
appliances__c, Dishwasher;Microwave;Hood Over Range;Free Standing Gas Oven;Built-In Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2010
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-01-24T18:46:46.000+0000
days_on_market__c, 8
dom__c, 0
ffd_description_pb, In an ideal location, just steps from the many restaurants and shops on Union Street, this house-like 3-bedroom, 2.5-bath Golden Gate Bridge view condo in a boutique building provides modern design, convenience, and one of the best roof decks in all of the city. Built in 2010, this incredible condo hits the market for the first time and offers an open floor plan with a chef's kitchen. The bedroom level provides three bedrooms and 2 baths, including a primary suite with a walk-in closet and a large primary bathroom with a dual sink vanity. The crown jewel of the unit is the amazing roof deck with spanning Bay and Golden Gate Bridge views, an outdoor kitchen, a hot tub, and an outdoor shower. Perfect space for entertaining or just eating al fresco. Private elevator to the unit, 2-car garage parking, wide plank oak hardwood floors are only some of the many features that make this home so incredible. When you combine those with the great location, this condo cannot be beat.
district__c, SF District 7
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Log
pba__floortype_pb__c, Carpet;Wood
pba__hoafees__c, 814
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-02-01T11:47:29.000+0000
pba__latitude_pb__c, 37.796814
pba__latitude_property__c, 37.796814
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2024-01-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, David
pba__listing_agent_lastname__c, Cohen
listing_agent_mls_id__c, 804695
ffd_listingagentname, David G Cohen
listing_agent_number__c, 166014347
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CITYRE
listing_office_name__c, City Real Estate
listing_office_number__c, 27425
pba__listingprice_pb__c, 2995000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.43516
mls_id__c, 424001152
master_property__c, a0OUd000002qzZJMAY
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-01-24
original_price__c, 2995000
overall_days_on_market__c, -81837
parking_access__c, Side by Side
parking_features__c, Garage Door Opener
parking_type__c, On Site - Assigned (Condo Only)
pba__pendingdate__c, 2024-01-24
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-01-31T19:21:37.000+0000
price_per_square_foot__c, 2008.67
pba__propertytype__c, Condominium
ListingId, a0EUd000000vJQxMAM
sale_date__c, 2024-01-29
sale_price__c, 3475000
selling_agent_mls_id__c, 355993
selling_agent_number__c, 355993
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Golden Gate Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1730
size__c, 1730
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Fillmore
subdist__c, Cow Hollow
ffd_name, 2950 Fillmore Street, San Francisco, CA, 94123
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2010
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530717462-1.jpg