meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423323' 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-10-31 12:51:41
[post_modified_gmt] => 2024-10-31 19:51:41
[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
(
)
)
_yoast_indexnow_last_ping, 1737548251
ffd_listing_title, 2457 19th Avenue, San Francisco, CA, 94116
ffd_mls_id, 424103794
ffd_salesforce_id, a0EUd000003vfXlMAI
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
pba__address_pb__c, 2457 19th Avenue, San Francisco, CA, 94116
address2__c, 2457 19th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Vacant home - please text or email LA prior to showing. Supra Lockbox on gate. Pre escrow open with Mia McDowell, Old Republic title. Please consider keeping escrow with ORT due to elderly seller and trust docs in place. Will update on offer date and instructions. *Update: All offers are due on Tuesday, Jan 7 by 2 pm thru Disclosures.IO. Please give the seller up to 48 hours to respond. Disclosures are ready. Seller has the right to accept, counter or reject offers. Buyer to verify square footage.
appliances__c, Dishwasher;Disposal;Hood Over Range;Electric Cook Top;Built-In Electric Oven
architectural_style__c, Mid-Century
bath_features__c, Shower Stall(s);Tub;Tile;Low-Flow Toilet(s);Low-Flow Shower(s);Window
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1953
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
cooling__c, None
ffd_createddate, 2024-12-27T17:46:32.000+0000
days_on_market__c, 26
dom__c, 13
ffd_description_pb, Discover the opportunity to create your dream home with this charming fixer located in the heart of the Parkside district. This property offers a spacious layout, original hardwood floors and a large backyard. The home is perfect for those with an eye for design and passion for renovation. Located near the Taraval Street corridor where transportation, shopping, schools, parks, restaurants, and craft cocktail bars are just a stone's throw away. Schedule a tour today and imagine the possibilities!
district__c, SF District 2
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard;Wood;Fenced
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Linoleum;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2025-01-22T11:48:44.000+0000
pba__latitude_pb__c, 37.7419825
pba__latitude_property__c, 37.7419825
laundry_features__c, In Garage;Washer Included;Dryer Included
listed_date__c, 2024-11-30
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tanya
pba__listing_agent_lastname__c, Bolshakoff
listing_agent_mls_id__c, 804712
ffd_listingagentname, Tanya Bolshakoff
listing_agent_number__c, 166014368
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, 988000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4759101
lower_level__c, Garage,Street Entrance
mls_id__c, 424103794
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Primary Bedroom
master_bathroom_features__c, Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-12-27
original_price__c, 988000
overall_days_on_market__c, -82175
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front,Workshop in Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2025-01-09
possible_bedrooms__c, 0
pba__pricechangedat__c, 2025-01-21T13:37:14.000+0000
price_per_square_foot__c, 855.89
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000003vfXlMAI
road_surface_type__c, Asphalt
room_type__c, Kitchen;Living Room;Dining Room;Workshop;Primary Bathroom
sale_date__c, 2025-01-21
sale_price__c, 1265000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Window Security Bars
selling_agent_mls_id__c, 816683
selling_agent_number__c, 1075634
selling_co_agent_mls_id__c, 803247
selling_co_agent_number__c, 803247
selling_co_office_mls_id__c, COMP90
selling_co_office_name__c, Compass
selling_co_office_number__c, 29048
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 1478
size__c, 1478
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 19th
subdist__c, Parkside
ffd_name, 2457 19th Avenue, San Francisco, CA, 94116
view__c, Twin Peaks
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1953
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530924564-1.jpg