meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='349131' 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
(
)
)
_yoast_indexnow_last_ping, 1704455813
ffd_listing_title, 467 Melrose Avenue, San Francisco, CA, 94127
ffd_mls_id, 423900021
ffd_salesforce_id, a0E8W00000cpetWUAQ
num_of_fireplaces__c, 2
num_of_rooms__c, 0
of_units__c, 0
address2__c, 467 Melrose Avenue, San Francisco, CA, 94127
pba__address_pb__c, 467 Melrose Avenue, San Francisco, CA, 94127
agent_only_remarks__c, Seller Reserves the Right to Accept, Reject, or Counter any Offer. Transparent Pricing at this asking.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Built-In Gas Range;Tankless Water Heater;Double Oven;Gas Cook Top
architectural_style__c, Traditional
bath_features__c, Tub w/Shower Over;Shower Stall(s);Granite;Steam
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 4
year_build_text__c, 1941
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:53:26.000+0000
days_on_market__c, 133
dom__c, 101
ffd_description_pb, Spectacular Multi-Level WOW! Home with 4 Bedrooms, 5 Bathrooms including a fabulous Primary Suite with Private Deck. Remodeled Gorgeous, Open Kitchen. Media Room and Additional Room for Office/Exercise Space. Large Yard. Sweeping Views South from the Bay to the Ocean. Fantastic Home for Entertaining. Incredible Price Per Sq Ft! Mid point between West Portal and Glen Park and close to the Ocean Ave Commercial Disctrict allowing access to many Restaurants and Services in these desirable strips. Easy access to 280, 101 West Portal Muni and Glen Park Bart. Please Note: Floorplan Graphic Artist in 2018 showed 3374 Sq. Ft. Floorplan Graphic Artist from 2023 shows 3362 Sq. Ft. A must visit the inside of this property, This is the Home of your Dreams!
district__c, SF District 4
entry_level__c, 0
exterior_features__c, Balcony;Entry Gate;Wet Bar
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room;Dining Room
pba__floortype_pb__c, Granite;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2024-01-05T11:47:24.000+0000
pba__latitude_pb__c, 37.73356
pba__latitude_property__c, 37.73356
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2023-06-20
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Debbie
pba__listing_agent_lastname__c, Herzfeld
listing_agent_mls_id__c, 115218
ffd_listingagentname, Debbie J Herzfeld
listing_agent_number__c, 115218
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 2350000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.45242
lower_level__c, Bedroom(s),Full Bath(s),Living Room,Retreat
mls_id__c, 423900021
main_level__c, Full Bath(s);Kitchen;Garage;Dining Room
master_bathroom_features__c, Shower Stall(s);Jetted Tub;Granite;Multiple Shower Heads;Steam
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-08-25
original_price__c, 2495000
overall_days_on_market__c, -81685
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-12-04
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-01-04T13:18:06.000+0000
price_per_square_foot__c, 771.67
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cpetWUAQ
room_type__c, Office;Living Room;Dining Room;Media Room;Primary Bathroom;Primary Bedroom
sale_date__c, 2024-01-04
sale_price__c, 2315000
security_features__c, Security Gate
selling_agent_mls_id__c, 800238
selling_agent_number__c, 800238
selling_co_agent_mls_id__c, 163987
selling_co_agent_number__c, 163987
selling_co_office_mls_id__c, CIP01
selling_co_office_name__c, Corcoran Icon Properties
selling_co_office_number__c, 28939
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 3000
size__c, 3000
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Melrose
subdist__c, Sunnyside
ffd_name, 467 Melrose Avenue, San Francisco, CA, 94127
view__c, Ocean;City Lights;Bay;Hills
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1941
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530661591-1.jpg