meta_query='key:subdist__c;value:Cow Hollow|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='341064' 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] => 2023-10-31 10:56:45
[post_modified_gmt] => 2023-10-31 17:56:45
[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, 1701404652
ffd_listing_title, 2912 Steiner Street #1, San Francisco, CA, 94123
ffd_mls_id, 423915830
ffd_salesforce_id, a0E8W00000dxHe3UAE
num_of_fireplaces__c, 1
num_of_rooms__c, 0
of_units__c, 11
address2__c, 2912 Steiner Street #1, San Francisco, CA, 94123
pba__address_pb__c, 2912 Steiner Street #1, San Francisco, CA, 94123
agent_only_remarks__c, 3% to Buyer's Agent! Property site here: www.2912Steiner.com - Address on tax records also listed as 2298 Green St #2298. Fractional TIC financing available. For more information or to schedule a private tour, please contact Kevin Delmore at [email protected] or 415.203.3357
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Victorian;Traditional
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-11-01T00:47:49.000+0000
days_on_market__c, 30
dom__c, 30
ffd_description_pb, Discover the allure of Cow Hollow living in this enchanting 2-bedroom residence, ideally situated just a block from the best of Union Street. Enter a piece of San Francisco history with this 1909 gem, offering a private entrance off the central courtyard and a host of charming features including a shared, panoramic rooftop deck. Adorned with exquisite inlaid hardwood floors, a cozy fireplace, and custom built-ins, this apartment exudes timeless elegance. Two generously sized bedrooms ensure comfortable living, and you'll find yourself at home in a well-established TIC community comprising 11 homes. An outstanding location: Cow Hollow's Union Street is your backyard, offering an array of boutiques, cafes, and cultural experiences, as is the Marina waterfront and myriad trails and activities in the Presidio. This is your chance to reside in an incredibly special home, where history and modern amenities blend seamlessly, in one of San Francisco's most coveted neighborhoods. Welcome home to Cow Hollow's finest!
district__c, SF District 7
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Uncovered Courtyard
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Homeowners Insurance,Maintenance Exterior,Maintenance Grounds,Trash,Water
pba__hoafees__c, 569
pba__hoafrequency_pb__c, Monthly
hoa_name__c, Green Steiner TIC
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-12-01T03:47:36.000+0000
pba__latitude_pb__c, 37.796215
pba__latitude_property__c, 37.796215
listed_date__c, 2023-09-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Gregg
pba__listing_agent_lastname__c, Lynn
listing_agent_mls_id__c, 804728
ffd_listingagentname, Gregg Lynn
listing_agent_number__c, 166014390
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, STHB
listing_office_name__c, Sotheby's International Realty
listing_office_number__c, 2050
pba__listingprice_pb__c, 895000
pba__listingtype__c, Sale
pba__listing_website__c, https://youtu.be/FpgQjRuW7PQ
pba__longitude_pb__c, -122.436827
mls_id__c, 423915830
main_level__c, Bedroom(s);Kitchen;Living Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Low-Flow Toilet(s);Tile;Window
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-10-31
open_house_end__c, 2023-12-03T15:00:00.000+0000
open_house_start__c, 2023-12-03T14:00:00.000+0000
original_price__c, 895000
overall_days_on_market__c, -81752
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, 0
pba__propertytype__c, Tenancy In Common
ListingId, a0E8W00000dxHe3UAE
room_type__c, Kitchen;Living Room;Possible Guest;Primary Bathroom;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector
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, 0
size__c, 0
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Steiner
subdist__c, Cow Hollow
ffd_name, 2912 Steiner Street #1, San Francisco, CA, 94123
website_property_type__c, Tenancy In Common
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94123
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530699265-1.jpg
