meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218305' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15556
[post_author] => 4
[post_date] => 2018-11-01 21:53:52
[post_date_gmt] => 2018-11-01 21:53:52
[post_content] => Not always sunny, shameless neighborhood self-promotion aside. Within walking distance to Glen Park BART, mostly single-family homes, bisected by Monterey Ave. Above, Sunnyside on a hill with some great southern views. Below, Sunnyside flatlands bounded by I-280 and City College to the south.
[post_title] => Sunnyside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => sunnyside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 13:31:56
[post_modified_gmt] => 2024-03-19 20:31:56
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15556
[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, 278 Monterey Boulevard, San Francisco, CA, 94131
ffd_mls_id, 421539025
ffd_salesforce_id, a0E1I00000US9gIUAT
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 278 Monterey Boulevard, San Francisco, CA, 94131
pba__address_pb__c, 278 Monterey Boulevard, San Francisco, CA, 94131
agent_only_remarks__c, Send Your Glen Park Clients This Home! Schedule a showing: https://calendly.com/team-brannigan/278-280-monterey Please send the PEAD to [email protected] to confirm your appointment. No ShowingTime reservations will be considered. All in-person viewers must abide by COVID regulations. For photos and virtual tours, visit CozyCityCottage.com. Also listed as a condo, no HOA dues. Disclosures available by 4/19, please email for access.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Cottage
bath_features__c, Tub w/Shower Over;Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 2003
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Silvia Zeng
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2021-04-22T21:16:02.000+0000
days_on_market__c, 825
dom__c, 20
ffd_description_pb, One-of-a-kind Glen Park-adjacent home nestled in a pastoral location, surrounded by gardens and distanced from nearby homes with views of the Southern Hills. This completely detached 3 BD/2.5 BA cottage bathes in the southern light and breathes serenity. A private ground level primary suite w/ an adjacent flexible office or living space + kitchenette opens directly to the South-facing deck, overshadowed only by its mature lemon tree. Ascend the stairs to experience the epitome of charm on the living level featuring an open kitchen/dining area, an inviting living room with gas fireplace, and a half bath for convenience. On the third level of this exciting yet serene home are two bedrooms and one bathroom with views of the Southern Hills, Balboa Park, and swaying palm trees located nearby in Sunnyside Conservatory. Easy street parking - no permit needed! Minutes to Glen Park Village and BART as well as Safeway and 280/101 freeway access.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Laminate;Wood
pba__hoafees__c, 0
hoa_name__c, 280 Monterey Boulevard HOA
hoa__c, Yes
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:49:50.000+0000
pba__latitude_pb__c, 37.7318587
pba__latitude_property__c, 37.7318587
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-04-06
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Pete
pba__listing_agent_lastname__c, Brannigan
listing_agent_mls_id__c, 352637
ffd_listingagentname, Pete Brannigan
listing_agent_number__c, 352637
listing_co_agent_mls_id__c, 812389
listing_co_agent_number__c, 1056371
listing_co_office_mls_id__c, COMP7PAR
listing_co_office_name__c, Compass SF
listing_co_office_number__c, 27677
listing_office_mls_id__c, COMP7PAR
listing_office_name__c, Compass SF
listing_office_number__c, 27677
pba__listingprice_pb__c, 1199000
pba__listingtype__c, Sale
pba__listing_website__c, http://cozycitycottage.com
pba__longitude_pb__c, -122.4414907
lower_level__c, Master Bedroom
mls_id__c, 421539025
main_level__c, Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2021-04-15
original_price__c, 1199000
overall_days_on_market__c, 76
parking_features__c, No Garage
patio_and_porch_features__c, Uncovered Patio
pba__pendingdate__c, 2021-05-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 731.98
pba__propertytype__c, Single Family Residence
id, a0E1I00000US9gIUAT
roof__c, Shingle
sale_date__c, 2021-05-28
sale_price__c, 1300000
selling_agent_mls_id__c, 811520
selling_agent_number__c, 1051920
selling_co_agent_mls_id__c, 807863
selling_co_agent_number__c, 1027872
selling_co_office_mls_id__c, COMP3
selling_co_office_name__c, Compass
selling_co_office_number__c, 27342
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1776
size__c, 1776
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Monterey
subdist__c, Sunnyside
ffd_name, 278 Monterey Boulevard, San Francisco, CA, 94131
view__c, Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 2003
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530220405-1.jpg
ListingId, a0E1I00000US9gIUAT