meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='237496' 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, 393 Melrose Avenue, San Francisco, CA, 94127
ffd_mls_id, 422678466
ffd_salesforce_id, a0E8W00000XktXkUAJ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 393 Melrose Avenue, San Francisco, CA, 94127
pba__address_pb__c, 393 Melrose Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Offers are due on Wednesday, July 27th by 10 a.m. Disclosures are posted on IO. If you have any trouble, just use this link instead: https://app.disclosures.io/link/393-Melrose-Avenue-819r5xew Please use pre-sale escrow with Michelle Patterson at DOMA, Escrow # 56604-22-01878 [email protected] 415-549-0993 Bedroom and bathroom on the first floor may have been built without permits. They were there when the Sellers purchased.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Refrigerator;Gas Cook Top;Built-In Electric Oven
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1960
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jonathan Davis
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2022-07-15T01:48:17.000+0000
days_on_market__c, 370
dom__c, 13
ffd_description_pb, The Sunnyside neighborhood is known for its eclectic architecture & quiet, residential vibe; yet it's close to BART & Highway 280. This updated 3 bed/2 bath mid-century house enjoys sweeping southern views from the bay to the ocean. Enter into a gracious foyer, with a master suite & an enormous deck just down the hall to your left. Up the stairs there's a reverse floor plan with the 2 bedrooms facing the quiet street side of the property, & the living, dining & kitchen bathed in natural light at the rear. The upstairs bathroom & kitchen have recently been refreshed. The bath boasts a separate shower stall, tub, & huge skylight. The kitchen features new quartz countertops & tile backsplash, an electric oven, gas stove top & breakfast bar. The garage has a washer & dryer, as well as 1 car parking. A 2nd car can be parked in the driveway. From the garage there is a staircase leading to a cavernous storage area. The yard has a lovely patio with built-in heater, & play area with faux grass.
district__c, SF District 4
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
exterior_features__c, Balcony
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
ffd_lastmodifieddate, 2023-07-13T17:20:39.000+0000
pba__latitude_pb__c, 37.733649
pba__latitude_property__c, 37.733649
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2022-06-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
ffd_listingagentname, Tim J Gullicksen
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, CGL
listing_co_office_name__c, Corcoran Global Living
listing_co_office_number__c, 28240
listing_office_mls_id__c, CGL
listing_office_name__c, Corcoran Global Living
listing_office_number__c, 28240
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=MhRdr5Ekxzg&mls=1
pba__longitude_pb__c, -122.4509267
lower_level__c, Full Bath(s),Garage,Primary Bedroom
mls_id__c, 422678466
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-07-14
original_price__c, 1295000
overall_days_on_market__c, -81278
parking_access__c, Tandem
parking_features__c, Attached,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
pba__pendingdate__c, 2022-07-27
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1115.02
pba__propertytype__c, Single Family Residence
record_id, a0E8W00000XktXkUAJ
room_type__c, Storage
sale_date__c, 2022-08-12
sale_price__c, 1425000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 807388
selling_agent_number__c, 1017144
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, eXp Realty of California, Inc
pba__status__c, Closed
pba__totalarea_pb__c, 1278
size__c, 1278
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Melrose
subdist__c, Sunnyside
ffd_name, 393 Melrose Avenue, San Francisco, CA, 94127
view__c, Ocean;City;Bay
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1960
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530496526-1.jpg
ListingId, a0E8W00000XktXkUAJ