meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382595' 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
(
)
)
_yoast_indexnow_last_ping, 1725591338
ffd_listing_title, 2337 Taraval Street #2337A, San Francisco, CA, 94116
ffd_mls_id, 424048272
ffd_salesforce_id, a0EUd000002duveMAA
num_of_fireplaces__c, 0
num_of_rooms__c, 12
of_units__c, 2
address2__c, 2337 Taraval Street #2337A, San Francisco, CA, 94116
pba__address_pb__c, 2337 Taraval Street #2337A, San Francisco, CA, 94116
agent_only_remarks__c, NO HOA fees. This for-sale condo building is located behind a new construction building, making it less noisy and further away from street and cable car noise. Please contact Jay Jie Zhu 415-730-1822 for disclosures and further offer questions, Pre-escrow opened with Old Republic Title #0216039430, I highly recommend to us them, escrow officer: Janette Marcelo (415)239-6165. Buyer to satisfy themselves regarding home square footage, and legal ADU on the first level, school enrollment.
appliances__c, Dishwasher;Disposal;Tankless Water Heater;Gas Cook Top
architectural_style__c, Craftsman
bath_features__c, Tub w/Shower Over;Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 6
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-09-05
cooling__c, None
ffd_createddate, 2024-07-23T18:48:34.000+0000
days_on_market__c, 44
dom__c, 44
ffd_description_pb, Newly remodeled, over 2,800 square feet of condominium living space with excellent ownership and investment/income opportunities. This 3-level, newly converted condo is conveniently located in the Sunset/Parkside area. The legalized ADU (#2337A) features two bedrooms, one full bath, a legal kitchen, and a private washer/dryer on the first level. The second, main level includes a spacious, open floor plan combining the living and dining rooms, a master bedroom, one and a half bathrooms, new hardwood floors throughout, a newly renovated kitchen with new appliances and cabinets, quartz countertops, and a laundry room with a new washer and dryer. The third level offers hardwood floors and period details throughout, with three bedrooms and two full bathrooms. Restaurants, parks, Ocean Beach, and Stonestown Mall are conveniently located nearby, and the L Muni line is just a few steps away. This is a great opportunity to own a condo with two units and no HOA fees.
district__c, SF District 2
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Partial
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
ffd_lastmodifieddate, 2024-09-06T02:46:50.000+0000
pba__latitude_pb__c, 37.7420461
pba__latitude_property__c, 37.7420461
laundry_features__c, Inside Room;Laundry Closet;Washer/Dryer Stacked Included;Inside Area;Washer Included;Dryer Included
listed_date__c, 2024-07-11
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Jie
pba__listing_agent_lastname__c, Zhu
listing_agent_mls_id__c, 807707
ffd_listingagentname, Jay J Zhu
listing_agent_number__c, 1024223
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COLD02
listing_office_name__c, Coldwell Banker Realty
listing_office_number__c, 874
pba__listingprice_pb__c, 1298000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4914047
lower_level__c, Bedroom(s),Full Bath(s),Kitchen,Living Room
mls_id__c, 424048272
main_level__c, Full Bath(s);Partial Bath(s);Kitchen;Living Room;Primary Bedroom
master_bathroom_features__c, Tub w/Shower Over;Tile
master_property__c, a0OUd000009uaLNMAY
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2024-07-23
original_price__c, 1298000
overall_days_on_market__c, -82018
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, 453.05
pba__propertytype__c, Condominium
ListingId, a0EUd000002duveMAA
roof__c, Composition;Shingle
room_type__c, Kitchen;In Law Apartment;Attic
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Secured Access;Carbon Mon Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 2865
size__c, 2865
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Taraval
subdist__c, Parkside
ffd_name, 2337 Taraval Street #2337A, San Francisco, CA, 94116
view__c, City;City Lights
website_property_type__c, Condominium
window_features__c, Dual Pane Full;Window Screens
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530815162-1.jpg