meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='427050' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15729
[post_author] => 4
[post_date] => 2018-11-02 19:54:53
[post_date_gmt] => 2018-11-02 19:54:53
[post_content] => From freeway-bisected loser to urban renaissance pedestrian paradise winner. Sunny. Central. Flat. Where Victorians make friends with modern condos. Great shops, boutiques, and restaurants served by great transit. A San Francisco success story.
[post_title] => Hayes Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => hayes-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-11-25 11:19:58
[post_modified_gmt] => 2024-11-25 19:19:58
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15729
[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, 1744680235
ffd_listing_title, 300 Ivy Street #401, San Francisco, CA, 94102
ffd_mls_id, 425024399
ffd_salesforce_id, a0EUd000004k35UMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 3
of_units__c, 71
pba__address_pb__c, 300 Ivy Street #401, San Francisco, CA, 94102
address2__c, 300 Ivy Street #401, San Francisco, CA, 94102
agent_only_remarks__c, Photos coming 1st week of April. Freshly painted, staged, and ready to sell! North-facing windows with views of the St Mary's Cathedral, City Hall, and the top of the SalesForce tower. Come show it! For showings contact Nancy Yeh at 415-812-4303
appliances__c, Built-In Gas Oven
architectural_style__c, Modern/High Tech
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 1
year_build_text__c, 2014
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2025-04-11T10:49:29.000+0000
days_on_market__c, 3
dom__c, 3
ffd_description_pb, Tucked away on a quaint, one-way street, this stunning 1-bedroom, 1-bath home is a masterpiece of modern design, crafted by the acclaimed David Baker Architect firm celebrated for creating dynamic urban spaces that seamlessly blend form and function. Building is Platinum Certified LEED construction. Step inside the Air-Conditioned unit to discover a thoughtfully designed layout featuring custom closet storage, hidden blinds throughout, and an effortless flow that maximizes space and natural light. The open-concept living area is perfect for entertaining, while the bedroom offers a serene retreat with smart, built-in storage solutions. This residence doesn't just impress indoors step outside and take full advantage of the rooftop deck, complete with a BBQ area, stunning city views, and a dedicated dog-friendly space. Other amenities include secure bike parking, a gated entrance, front desk attendance, and a secure package area everything you need for modern city living. With Trader Joe's just around the corner and Hayes Valley's vibrant boutiques, cafes, and nightlife at your doorstep, you're in the heart of one of the most sought-after neighborhoods. Pet-friendly, beautifully designed, and packed with top-tier amenities this is city living at its finest
district__c, SF District 6
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_fee_includes__c, Common Areas,Door Person,Elevator,Maintenance Exterior,Management,Roof
pba__hoafees__c, 636
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 300 Ivy Owners Association
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2025-04-15T00:47:08.000+0000
pba__latitude_pb__c, 37.7775203
pba__latitude_property__c, 37.7775203
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2025-01-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Shawn
pba__listing_agent_lastname__c, Kunkler
listing_agent_mls_id__c, 811632
ffd_listingagentname, Shawn Kunkler
listing_agent_number__c, 1052818
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 799000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/1070628035?share=copy
pba__longitude_pb__c, -122.423566
mls_id__c, 425024399
master_property__c, a0O1I000001VhrnUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2025-04-11
open_house_end__c, 2025-04-15T13:00:00.000+0000
open_house_start__c, 2025-04-15T11:00:00.000+0000
original_price__c, 799000
overall_days_on_market__c, -82280
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 2025-04-09T11:08:57.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
ListingId, a0EUd000004k35UMAQ
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Fire Suppression System
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, Ivy
subdist__c, Hayes Valley
ffd_name, 300 Ivy Street #401, San Francisco, CA, 94102
view__c, City;City Lights;San Francisco;Other
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 2014
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530968937-1.jpg