meta_query='key:subdist__c;value:Sunnyside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336209' 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, 458 Mangels Avenue, San Francisco, CA, 94127
ffd_mls_id, 423737706
ffd_salesforce_id, a0E8W00000bbyMEUAY
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 458 Mangels Avenue, San Francisco, CA, 94127
pba__address_pb__c, 458 Mangels Avenue, San Francisco, CA, 94127
agent_only_remarks__c, This is a trustee sale with no court confirmation required. Escrow has been opened with Ashley Chuang at Fidelity National Title. Please see instructions in disclosure package.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Free Standing Gas Oven
architectural_style__c, Edwardian
bath_features__c, Jack & Jill
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1909
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-04-28T15:48:33.000+0000
days_on_market__c, 96
dom__c, 42
ffd_description_pb, Welcome to 458 Mangels Avenue, a charming Edwardian, nestled on a tranquil street in the Sunnyside Neighborhood! The home is detached on three and a half sides and has a bright interior that includes a spacious kitchen, and formal dining room, two bedrooms, a Jack-and-Jill bathroom and a comfortable living room. There are large doors from the kitchen that lead to a deck and patio area in the serene garden---making it a wonderful indoor/outdoor home. It has a basement with ample storage space and garage for one vehicle, as well as a driveway space for another vehicle. Features of note include: original period details, hardwood floors, a box-beam ceiling in the dining room, dual-paned windows, a claw foot tub, a bonus sleeping loft in the rear bedroom, original built-in bookshelves and China cabinet, 10 foot ceilings, tasteful lighting fixtures, a landscaped front and rear garden, located adjacent to Sunnyside park and playground, the home is also close to transportation, dining and shopping on Monterey Blvd. Ocean Ave. and Glen Park Village.
district__c, SF District 4
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2023-08-02T19:47:48.000+0000
pba__latitude_pb__c, 37.733306
pba__latitude_property__c, 37.733306
laundry_features__c, In Basement
listed_date__c, 2023-04-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Geoffrey
pba__listing_agent_lastname__c, Williams
listing_agent_mls_id__c, 802282
ffd_listingagentname, Geoffrey J Williams
listing_agent_number__c, 802282
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP7
listing_office_name__c, Compass
listing_office_number__c, 28751
pba__listingprice_pb__c, 999000
pba__listingtype__c, Sale
pba__listing_website__c, http://my.matterport.com/show/?m=J9JVRZ7ujNL&mls=1
pba__longitude_pb__c, -122.447951
lower_level__c, Garage
mls_id__c, 423737706
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-04-28
original_price__c, 1299000
overall_days_on_market__c, -81566
parking_access__c, Tandem
parking_features__c, Garage Door Opener,Garage Facing Front,Uncovered Parking Space
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-07-07
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-08-02T05:50:19.000+0000
price_per_square_foot__c, 1240.76
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000bbyMEUAY
roof__c, Shingle
room_type__c, Kitchen;Living Room;Dining Room;Attic
sale_date__c, 2023-07-31
sale_price__c, 1175000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 809608
selling_agent_number__c, 1042058
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Outpost Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 947
size__c, 947
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Mangels
subdist__c, Sunnyside
ffd_name, 458 Mangels Avenue, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1909
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530610456-1.jpg