meta_query='key:subdist__c;value:Hayes Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209695' 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, 210 Rose Street, San Francisco, CA, 94102
ffd_mls_id, 493355
ffd_salesforce_id, a0E1I00000PGavcUAD
num_of_fireplaces__c, 0
num_of_rooms__c, 0
of_units__c, 2
address2__c, 210 Rose Street, San Francisco, CA, 94102
pba__address_pb__c, 210 Rose Street, San Francisco, CA, 94102
agent_only_remarks__c, Supra lockbox. Please call or text co-listing agent, Kerry Vermeer at (650) 823-6390 before viewing. Buyers to verify year built. Pre-escrow opened with Kathie Ng with CTT. 14 disclosure packets out. One preemptive offer in hand.
appliances__c, Dishwasher;Gas Range;Microwave;Disposal;Refrigerator;Freestanding Range;Hood Over Range;Freezer;Self/Cont Clean Oven
architectural_style__c, Traditional
bath_features__c, Shower Stall(s)
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1900
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kerry Vermeer
pba__contingentdate__c, 2020-01-16
ffd_createddate, 2020-01-07T21:45:55.000+0000
days_on_market__c, 1289
dom__c, 21
ffd_description_pb, This gorgeous, ground level, 2 bedrooms, 1 bath condo is located in the Hayes Valley neighborhood. Slate tile floors in the open kitchen and original hardwood floors throughout. Exclusive laundry area and storage. Upgraded floor to ceiling entertainment center already prewired for audio and cable. Move right in and enjoy this condo in a 2 unit building. Amazing private patio and steps down to a shared yard. Close to shopping, restaurants and nightlife.
district__c, SF District 6
electric__c, 220 Volts in Kitchen,220 Volts in Laundry
entry_level__c, 0
external_listing__c, 1
pba__floor__c, 0
pba__floortype_pb__c, Slate;Wood
hoa_dues__c, 175
hoa_fee_includes__c, Maintenance Exterior,Trash
pba__hoafees__c, 175
pba__hoafrequency_pb__c, Monthly
hoa_name__c, 210-210 1/2 Rose Street Owners Assoc.
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Wall Furnace
ffd_lastmodifieddate, 2022-01-12T15:26:11.000+0000
pba__latitude_pb__c, 37.773458
pba__latitude_property__c, 37.773458
laundry_appliances__c, 220 Volt Wiring,Washer/Dryer
laundry_features__c, Washer/Dryer Included
listed_date__c, 2020-01-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ricky
pba__listing_agent_lastname__c, Shankar
listing_agent_mls_id__c, 808463
ffd_listingagentname, Ricky R Shankar
listing_agent_number__c, 1035467
listing_co_agent_mls_id__c, MLSL5075476
listing_co_agent_number__c, 981226425
listing_co_office_mls_id__c, PNRP-1
listing_co_office_name__c, Panorama Properties, SFBA Inc.
listing_co_office_number__c, 981053631
listing_office_mls_id__c, PANO
listing_office_name__c, Panorama Properties SFBA, Inc.
listing_office_number__c, 26340
pba__listingprice_pb__c, 995000
pba__listingtype__c, Sale
pba__listing_website__c, http://tours.beyondremarketing.com/1506260?idx=1
pba__longitude_pb__c, -122.424528
pba__lotsize_pb__c, 0
mls_id__c, 493355
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_property__c, a0O1I000004VWzMUAW
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2020-01-07
original_price__c, 995000
overall_days_on_market__c, 71
parking_type__c, None
pba__pendingdate__c, 2020-01-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1283
pba__propertytype__c, Condominium
id, a0E1I00000PGavcUAD
roof__c, Shingle
room_type__c, Storage
sale_date__c, 2020-02-06
sale_price__c, 1102101
selling_agent_mls_id__c, 803117
selling_agent_name__c, Danielle H. Lazier
selling_agent_number__c, 803117
selling_co_agent_mls_id__c, 809927
selling_co_agent_name__c, Joshua Ortiz
selling_co_agent_number__c, 1044191
selling_co_office_mls_id__c, COMP2
selling_co_office_name__c, Compass
selling_co_office_number__c, 27341
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 859
size__c, 859
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Rose
subdist__c, Hayes Valley
ffd_name, 210 Rose Street, San Francisco, CA, 94102
transportation__c, 1 Block
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1900
pba__postalcode_pb__c, 94102
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/359018-1.jpg
ListingId, a0E1I00000PGavcUAD