meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='325450' 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, 515 Monterey 517 Boulevard, San Francisco, CA, 94127
ffd_mls_id, 423714923
ffd_salesforce_id, a0E8W00000a6z2UUAQ
num_of_rooms__c, 10
of_units__c, 2
address2__c, 515 Monterey 517 Boulevard, San Francisco, CA, 94127
pba__address_pb__c, 515 Monterey 517 Boulevard, San Francisco, CA, 94127
agent_only_remarks__c, Hello Agents! 1. Supra lockbox on the gate, go directly. 2. Disclosures can be viewed in Disclosures.io 3. Escrow officer is Katie Berggren ([email protected] or 650-343-6282). 4. Offer due date is 1/24 by 12pm. Please submit offers on a SFAR purchase agreement, with 24 hour offer expiration, provide pre-approval letter (if applicable) and proof of funds document. 5. This is a probate sale with NO court confirmation required. 6. Note that measurements of property tend to vary from source to source and often conflict. There is no official source or standard method of calculation. Buyer(s) and buyer agent(s) should perform their own investigation of the number of rooms.
pba__fullbathrooms_pb__c, 0
pba__bedrooms_pb__c, 4
year_build_text__c, 1945
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Sean Kelly
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-01-12T20:48:23.000+0000
days_on_market__c, 188
dom__c, 13
ffd_description_pb, Set in the attractive Sunnyside neighborhood, this charming duplex presents airy spaces and endless investment opportunities. An entry on the ground level leads past the attached garage and up to both 2BD/1BA units. Newly refinished hardwood flooring and fresh paint extend across the nearly identical floor plans as large windows give way to plenty of natural light. Each residence includes new light fixtures, cozy fireplaces, and ample storage. Appreciate eat-in kitchens with darling breakfast nooks and access out to the spacious backyard. Enjoy a lush lawn, freshly mulched flower beds, citrus trees, and a convenient storage shed. This more than desirable location sits in proximity to endless entertainment, dining, and shopping. Choose from a plethora of nearby parks to spend your afternoons, take advantage of public transportation from the bus stop right outside your front door, or HWY 280 for seamless travel to neighboring cities across the bay.
district__c, SF District 4
external_listing__c, 1
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
ffd_lastmodifieddate, 2023-02-15T11:51:50.000+0000
pba__latitude_pb__c, 37.731277
pba__latitude_property__c, 37.731277
listed_date__c, 2022-10-03
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Joseph
pba__listing_agent_lastname__c, Polyak
listing_agent_mls_id__c, 814792
ffd_listingagentname, Joe Polyak
listing_agent_number__c, 1068311
listing_co_agent_mls_id__c, 815659
listing_co_agent_number__c, 1073852
listing_co_office_mls_id__c, RISEHOME
listing_co_office_name__c, Rise Homes
listing_co_office_number__c, 28134
listing_office_mls_id__c, RISEHOME
listing_office_name__c, Rise Homes
listing_office_number__c, 28134
pba__listingprice_pb__c, 1398000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?brand=0&m=DrEDu447dX8
pba__longitude_pb__c, -122.446989
mls_id__c, 423714923
parkingspaces__c, 2
on_market_date__c, 2023-01-12
original_price__c, 1398000
overall_days_on_market__c, -81460
parking_features__c, Attached,Tandem Garage
pba__pendingdate__c, 2023-01-25
price_per_square_foot__c, 747.42
pba__propertytype__c, Duplex
ListingId, a0E8W00000a6z2UUAQ
sale_date__c, 2023-02-14
sale_price__c, 1450000
selling_agent_mls_id__c, 803778
selling_agent_number__c, 803778
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, 1940
size__c, 1940
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Monterey
subdist__c, Sunnyside
ffd_name, 515 Monterey 517 Boulevard, San Francisco, CA, 94127
website_property_type__c, Duplex
pba__yearbuilt_pb__c, 1945
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530568288-1.jpg
