meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210465' 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
(
)
)
ffd_listing_title, 2279 29th Avenue, San Francisco, CA, 94116
ffd_mls_id, 496830
ffd_salesforce_id, a0E1I00000SPDEtUAP
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2279 29th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2279 29th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Virtual tour link: https://my.matterport.com/show/?m=NU53AToxuBH Please follow guidelines by NAR to show during this pandemic. It's on supra lockbox. For questions on offer date & details or disclosures, please contact listing agents Jason Chan via email: [email protected] or via text/cell: 415.215.1661 or Julie Chan via email: [email protected] or via text/cell: 415.672.7988. Please use San Francisco purchase agreement. Seller reserves right to accept, counter, & reject any offer. Pre-sale escrow opened w/ Fidelity National Title @ 1900 Noriega St. Buyer to cooperate with seller's 1031 deferred exchange at no cost of liabilities to Buyers. Thank you!
appliances__c, Dishwasher;Microwave;Freestanding Range
architectural_style__c, Marina
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1926
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-04-10T18:45:58.000+0000
days_on_market__c, 1195
dom__c, 3
ffd_description_pb, Newly renovated designer home featuring gorgeous ocean views! This tastefully remodeled home offers open floor plan, views from all levels, state of art finishes including custom-built cabinets, Marvin windows, Venetian plaster walls, brand new gas fireplace, Paperstone counter tops, engineered hardwood floors, custom light fixtures, and more! Top floor offer master suite in the back with gorgeous ocean views from both bedroom & master bath, 2nd generous-sized bedroom with partial views, office with skylight or possible 3rd bedroom, full bath, and open kitchen to dining & living room. Lower level offers two bedrooms with views, full bath, large family room, two exits to the yard, laundry room, one car parking in the garage, one car parking on the driveway, separate side entry, and spacious deck with views - perfect for entertaining! Located just a block to Taraval St MUNI lines, Taraval St eateries & shop, Pine Lake, & Sterngrove! https://my.matterport.com/show/?m=NU53AToxuBH
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Gas Piped
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2022-01-12T15:30:03.000+0000
pba__latitude_pb__c, 37.74485
pba__latitude_property__c, 37.74485
laundry_features__c, Inside Room
listed_date__c, 2020-04-10
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, 1795000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=NU53AToxuBH
pba__longitude_pb__c, -122.48689
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 496830
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, 2020-04-10
original_price__c, 1795000
overall_days_on_market__c, 81
parking__c, Garage,Auto Door,Interior Access
parking_access__c, Independent
parking_features__c, Garage Door Opener,Interior Access,Garage
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2020-04-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 968.63
pba__propertytype__c, Single Family Residence
id, a0E1I00000SPDEtUAP
room_type__c, Office
sale_date__c, 2020-05-26
sale_price__c, 2100000
selling_agent_mls_id__c, 804421
selling_agent_name__c, Edmond D. O'Sullivan
selling_agent_number__c, 166013970
selling_co_agent_mls_id__c, 811741
selling_co_agent_name__c, Hayley Kerstein
selling_co_agent_number__c, 1053391
selling_co_office_mls_id__c, ELEVATE
selling_co_office_name__c, Elevation Real Estate
selling_co_office_number__c, 27424
selling_office_name__c, Elevation Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 2168
size__c, 2168
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 29th
subdist__c, Parkside
ffd_name, 2279 29th Avenue, San Francisco, CA, 94116
transportation__c, 1 Block
view__c, Ocean
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1926
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/361963-1.jpg
ListingId, a0E1I00000SPDEtUAP