meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337882' 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-04-09 11:31:42
[post_modified_gmt] => 2024-04-09 18:31:42
[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
(
)
)
ffd_listing_title, 300 Ivy Street #512, San Francisco, CA, 94102
ffd_mls_id, 423757470
ffd_salesforce_id, a0E8W00000bkwjDUAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 4
of_units__c, 63
address2__c, 300 Ivy Street #512, San Francisco, CA, 94102
pba__address_pb__c, 300 Ivy Street #512, San Francisco, CA, 94102
agent_only_remarks__c, Pre-escrow opened with Mijael Schmidt at First American Title - [email protected]. Please submit offers on 8 page SFAR contact, w/ POF/lender approval letter and signed disclosures. Please contact Michelle Balog at 415-810 7890/[email protected] / Evan Bliss at 415.816.9225/[email protected] / or William Crum at 415.260.9384/[email protected] with any questions or showing requests.
appliances__c, Dishwasher;Disposal;Built-In Gas Range;Built-In Gas Oven;Built-In Refrigerator
architectural_style__c, Contemporary
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 2
year_build_text__c, 2014
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Evan Bliss
pba__contingentdate__c, 1800-01-01
cooling__c, Central
ffd_createddate, 2023-07-21T20:48:02.000+0000
days_on_market__c, 47
dom__c, 16
ffd_description_pb, Welcome to 300 Ivy where luxury meets convenience in a LEED Platinum building in one of Hayes Valleys most sought after communities. This exceptional top floor 2 bedroom, 2 bath plus den offers an array of desirable features that will exceed your expectations. Step into a bright and spacious open-concept living space with hardwood floors, flooded with natural light. Enjoy the privacy of separated bedrooms and a lovely urban view overlooking the building's courtyard and views of Sutro Tower. The modern kitchen boasts stainless steel appliances and ample storage, while the in-unit laundry ensures convenience. Embrace the versatility of a den/office space that is flexible for remote work or personal projects. Relax and entertain on the rooftop deck with BBQ facilities and stunning city views. Additional amenities are in unit A/C, bike parking, a parking space, and a massive deeded storage cage. Close to the Symphony, Opera, SF Jazz Center and some of the city's hottest restaurants, cafes and shops. Close proximity to the freeway and tech shuttles. This is urban living at its best!
district__c, SF District 6
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
hoa_fee_includes__c, Sewer,Trash,Water
pba__hoafees__c, 703
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-09-07T00:46:49.000+0000
pba__latitude_pb__c, 37.7775043
pba__latitude_property__c, 37.7775043
laundry_features__c, Laundry Closet;Washer/Dryer Stacked Included
listed_date__c, 2023-06-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michelle
pba__listing_agent_lastname__c, Balog
listing_agent_mls_id__c, 803379
ffd_listingagentname, Michelle L Balog
listing_agent_number__c, 803379
listing_co_agent_mls_id__c, 808381
listing_co_agent_number__c, 1034267
listing_co_office_mls_id__c, BAYRE
listing_co_office_name__c, Bay Real Estate Group
listing_co_office_number__c, 28186
listing_office_mls_id__c, BAYRE
listing_office_name__c, Bay Real Estate Group
listing_office_number__c, 28186
pba__listingprice_pb__c, 1649000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.300ivy512.com
pba__longitude_pb__c, -122.423508
mls_id__c, 423757470
master_bathroom_features__c, Shower Stall(s);Tub;Double Sinks
master_property__c, a0O1I000001VhrnUAC
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-07-21
original_price__c, 1649000
overall_days_on_market__c, -81650
parking_access__c, Side by Side
parking_features__c, Assigned,Attached,Covered,Garage Door Opener,Side-by-Side,Underground Parking
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2023-08-12
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-09-06T10:16:15.000+0000
price_per_square_foot__c, 0
pba__propertytype__c, Condominium
ListingId, a0E8W00000bkwjDUAQ
sale_date__c, 2023-09-01
sale_price__c, 1500000
selling_agent_mls_id__c, 814668
selling_agent_number__c, 1067783
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
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 #512, San Francisco, CA, 94102
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/530650318-1.jpg
_edit_lock, 1711735779:1564
_edit_last, 1564
_yoast_indexnow_last_ping, 1711735777
_price_reduced__c, field_61ce1b15d3a3f
_has_3d_tour__c, field_61ce1b4cd3a40
_ListingId, field_62bf231ba1405
_pba__latitude_pb__c, field_62c436cc3ee02
_pba__longitude_pb__c, field_62c436f43ee03
_yoast_wpseo_content_score, 90
_yoast_wpseo_focuskeywords, []
_yoast_wpseo_keywordsynonyms, [""]
_yoast_wpseo_estimated-reading-time-minutes, 1
_yoast_wpseo_canonical, https://jacksonfuller.com/property/300-ivy-street-512-san-francisco-ca-94102/