meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='218738' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70657
[post_author] => 4
[post_date] => 2018-11-30 20:30:31
[post_date_gmt] => 2018-11-30 20:30:31
[post_content] => Proximity to parks, room to roam, and the Pacific Ocean at your front door. Downtown is a quick (and probably crowded) L-Taraval ride away, and car commuters can hop on 19th Avenue to head south. Like its northern twin the Sunset, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Parkside
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => parkside
[to_ping] =>
[pinged] =>
[post_modified] => 2024-06-04 10:53:39
[post_modified_gmt] => 2024-06-04 17:53:39
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70657
[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, 2619 25th Avenue, San Francisco, CA, 94116
ffd_mls_id, 421546265
ffd_salesforce_id, a0E1I00000USdMbUAL
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 2619 25th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2619 25th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Offers accepted on Tuesday, 5/18 by 12 noon. Ways to see property: www.25thAveCharm.com or by appointment with a signed PEAD no earlier than 24 hours before the showing. Showing instructions will be provided once a signed PEAD has been received by Deborah Nguyen at [email protected] Appointments can be booked at: https://calendly.com/deborahnguyen/2619-25th-avenue If you do not see an available appointment, please call me at 415.812.7462 as Calendly may have added a conflict into the schedule that is not there. Neither Sellers nor Agent warrant legality of rooms down. Large potted plants, paint and window screens to stay with the property.
appliances__c, Dishwasher;Built-In Refrigerator;Free Standing Electric Range
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1948
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2021-05-19
ffd_createddate, 2021-05-07T14:47:31.000+0000
days_on_market__c, 803
dom__c, 27
ffd_description_pb, Charming Mid-Century home with 3BR's, 1BA + PKG on a quiet tree-lined street in super hot Parkside. Main level consists of a sunny formal LR with floor-to-ceiling windows & WB fireplace. Gracious DR opens to a recently renovated chef's kitchen w/custom cabinets, quartz counters & high-end stainless appliances (Viking & Bosch). 3 perfectly sized BR's, a renovated BA w/stall shower & tub complete this level. Expansion potential on lower level offers a multi-use room, bath & bar is perfect for today's work from home lifestyle or a really cool man/woman cave. Designer worthy garage has custom lighting, leather paneled ceilings & IPE wood trim. Additional features include: newly painted interior, double-paned windows, HW floors & a sunny west garden w/gorgeous flowers & delicious fruit trees (lemon, lime and pear). Next to Parkside Square Park and minutes to West Portal, Stern Grove/Pine Lake Park, Stonestown and SFSU. Near excellent public schools, transportation, HWYS & tech shuttles.
district__c, SF District 2
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2022-01-25T15:51:46.000+0000
pba__latitude_pb__c, 37.7386106
pba__latitude_property__c, 37.7386106
laundry_features__c, In Garage;Ground Floor
listed_date__c, 2021-04-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Deborah
pba__listing_agent_lastname__c, Nguyen
listing_agent_mls_id__c, 390430
ffd_listingagentname, Deborah Nguyen
listing_agent_number__c, 390430
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP
listing_office_name__c, Compass
listing_office_number__c, 26293
pba__listingprice_pb__c, 1295000
pba__listingtype__c, Sale
pba__listing_website__c, http://25thAveCharm.com
pba__longitude_pb__c, -122.4821028
lower_level__c, Garage
mls_id__c, 421546265
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2021-05-07
original_price__c, 1295000
overall_days_on_market__c, 91
parking_access__c, Independent
parking_features__c, Enclosed,Interior Access,Other
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2021-06-03
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1206.14
pba__propertytype__c, Single Family Residence
id, a0E1I00000USdMbUAL
room_type__c, Other
sale_date__c, 2021-06-15
sale_price__c, 1650000
security_features__c, Smoke Detector;Security Fence;Carbon Mon Detector
selling_agent_mls_id__c, 810372
selling_agent_number__c, 1045897
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1368
size__c, 1368
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 25th
subdist__c, Parkside
ffd_name, 2619 25th Avenue, San Francisco, CA, 94116
view__c, Garden/Greenbelt
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1948
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530233948-1.jpg
ListingId, a0E1I00000USdMbUAL
