meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376544' 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, 1714445805
ffd_listing_title, 2459 27th Avenue, San Francisco, CA, 94116
ffd_mls_id, 424027141
ffd_salesforce_id, a0EUd000001ppxZMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 6
of_units__c, 0
address2__c, 2459 27th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2459 27th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, 1) Offers due Wednesday 5/8/2024 by 2 p.m. 2) On supra lockbox, NO appointments or additional call/text notices needed. 3) For disclosures please EMAIL (not texting) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. 4) For questions, please text Jason at 415.215.1661. 5) For lockbox issues or showing difficulties, please contact Julie Chan via email: [email protected] or via text: 415.672.7988. Email or text preferred. 6) SF purchase agreement preferred, but CAR is okay. 7) Please INCLUDE Contingency Removal form & signing off the cover page of the disclosure packet. 8) Please tell your loan agent NOT TO CALL after your offer is submitted. I will contact them if it's necessary. 9) Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. 10) Seller reserves the right to accept, counter, or reject any offer.
appliances__c, Dishwasher;Disposal;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 3
year_build_text__c, 1908
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-25T01:47:47.000+0000
days_on_market__c, 5
dom__c, 5
ffd_description_pb, Presenting a distinctive home in Parkside, mere steps from Taraval Street MUNI lines, dining spots, shops, Parkside Square playground, Stern Grove, Pine Lake Park, Lakeshore Plaza, Lake Merced, and Ocean Beach. Enjoy the Pacific Ocean views from the top two floors, where you can enjoy sunsets from your bedrooms or both the dining room and breakfast nook. The top floor features 3 bedrooms and a full bath, including a spacious front primary bedroom and two rear bedrooms. On the main level, soak up natural light in the living and dining rooms with boxed beam ceilings & gas fireplace, accompanied by a well-appointed kitchen and breakfast nook. A large deck off the breakfast nook offers access to lower decks and a lush yard, complete with vegetable gardens and an art studio. The ground floor presents an additional unwarranted bedroom, bathroom, wet bar area, and deck via French doors, perfect for a guest suite. The garage fits 2 cars tandem and provides ample storage space with soaring ceilings for potential mezzanine use.
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, Gas Piped
pba__floortype_pb__c, Carpet;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry
ffd_lastmodifieddate, 2024-04-30T02:48:02.000+0000
pba__latitude_pb__c, 37.7415569
pba__latitude_property__c, 37.7415569
laundry_features__c, In Garage
listed_date__c, 2024-04-24
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, 1195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4844478
lower_level__c, Bedroom(s),Full Bath(s),Garage
mls_id__c, 424027141
main_level__c, Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-24
open_house_end__c, 2024-04-30T14:30:00.000+0000
open_house_start__c, 2024-04-30T13:00:00.000+0000
original_price__c, 1195000
overall_days_on_market__c, -81928
parking_access__c, Tandem
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Uncovered Deck;Front Porch
pba__pendingdate__c, 1800-01-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 956
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001ppxZMAQ
roof__c, Shingle
room_type__c, Kitchen;Living Room;Dining Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Active
pba__totalarea_pb__c, 1250
size__c, 1250
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 27th
subdist__c, Parkside
ffd_name, 2459 27th Avenue, San Francisco, CA, 94116
view__c, Ocean
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530766808-1.jpg
