meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376456' 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-04-11 08:39:13
[post_modified_gmt] => 2024-04-11 15:39:13
[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, 1713869880
ffd_listing_title, 2247 24th Avenue, San Francisco, CA, 94116
ffd_mls_id, 424017508
ffd_salesforce_id, a0EUd000001W7VhMAK
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 2247 24th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2247 24th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Offers due this Thursday 3/28/2024 by 2 p.m. It's on supra lockbox, no appointments or additional call/text notices needed! For disclosures please EMAIL (NOT TEXT) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. For questions, please text Jason at 415.215.1661. For lockbox issues or showing difficulties, please contact Julie Chan via email: [email protected] or via text: 415.672.7988. Email or text preferred. Please use San Francisco purchase agreement. Please include Contingency Removal form & signing off the cover page of the disclosure packet. Please tell your loan agent NOT TO CALL after your offer is submitted. I will contact them if it's necessary. Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. Seller reserves the right to accept, counter, or reject any offer.
appliances__c, Dishwasher;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1931
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-03-21T17:46:54.000+0000
days_on_market__c, 33
dom__c, 7
ffd_description_pb, Introducing a timeless Parkside treasure with awe-inspiring panoramic ocean view from both top & bottom floors! This home offers unmatched convenience, merely 1.5 blocks from Taraval Street's MUNI lines, restaurants, boba & coffee shops, stores, playgrounds, library, police station, and Stern Grove. The top floor boasts an east-facing, sunlit living room with an original fireplace overlooking an open field with Mount Davidson in the backdrop, accompanied by a formal dining room adjacent to a patio. A modernized kitchen with a separate breakfast nook, a full bath with separate shower and tub, and two bedrooms at the rear offering stunning ocean views complete this level. Interior stairs lead to additional living space on the ground floor (unwarranted), comprising a bedroom, family room, wet bar, full bath, and a spacious backyard - perfect for summer BBQs. The garage provides ample parking for one car and a separate large storage room. This charming home has been tastefully refreshed inside and out, showcasing newly refinished original hardwood floors with mahogany inlays and newly installed hardwood floors on the ground level. The kitchen has been thoughtfully remodeled in recent years, culminating in the perfect fusion of classic charm and modern convenience.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,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, Central
ffd_lastmodifieddate, 2024-04-23T10:47:33.000+0000
pba__latitude_pb__c, 37.745633
pba__latitude_property__c, 37.745633
laundry_features__c, In Garage
listed_date__c, 2024-03-21
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jason
pba__listing_agent_lastname__c, Chan
listing_agent_mls_id__c, 802554
ffd_listingagentname, Jason C Chan
listing_agent_number__c, 802554
listing_co_agent_mls_id__c, 807828
listing_co_agent_number__c, 1027382
listing_co_office_mls_id__c, BARBCO
listing_co_office_name__c, BarbCo
listing_co_office_number__c, 28297
listing_office_mls_id__c, BARBCO
listing_office_name__c, BarbCo
listing_office_number__c, 28297
pba__listingprice_pb__c, 1095000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.481576
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage
mls_id__c, 424017508
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-03-21
original_price__c, 1095000
overall_days_on_market__c, -81894
parking_access__c, Independent
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2024-03-28
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-04-22T15:48:06.000+0000
price_per_square_foot__c, 1256
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001W7VhMAK
room_type__c, Storage;Kitchen;Living Room;Dining Room;Family Room
sale_date__c, 2024-04-22
sale_price__c, 1570000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, MLSL5092381
selling_agent_number__c, 981388702
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, KW Advisors
pba__status__c, Closed
pba__totalarea_pb__c, 1250
size__c, 1250
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, Parkside
ffd_name, 2247 24th Avenue, San Francisco, CA, 94116
view__c, Ocean
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1931
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530748415-1.jpg
