meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='337290' 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] => 2023-06-23 11:48:49
[post_modified_gmt] => 2023-06-23 18:48:49
[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, 1990 29th Avenue, San Francisco, CA, 94116
ffd_mls_id, 423749782
ffd_salesforce_id, a0E8W00000cJcm9UAC
num_of_fireplaces__c, 0
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1990 29th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 1990 29th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Transparent pricing, offers will be reviewed as they come. Owner has the right to accept or reject any and all offers. Property is sold AS-IS. This is a Trust sale with authorized signing POA. Buyer to investigate square footage to their own satisfaction. Bed/bath count based on how rooms are being used. Public record does not report actual count. Upper level has 2 bedrooms/1 baths and lower level has 1 bedroom/1 bath plus pantry area, with separate entrance. Has 1-car garage and driveway for parking. Prospective buyers are advised to independently verify accuracy of sq. ft. & to review any disclosure information before submitting offer. Please submit offers on 7 page SFAR contract, w/ POF/lender approval letter and signed disclosures. Please include Contingency Removal form & signing off the cover page of the disclosure packet. Please include 'EMD to be wired within 24 hours of contract ratification. Disclosures to be returned, signed in its entirety, within 48 hours of ratification' as a term in the purchase agreement. Disclosures here: https://app.disclosures.io/link/1990-29th-Avenue-lwlzdvaa Pre escrow opened with Title Forward. Escrow #CA-59247 Show and Sell. Contact Frank for more information (415) 745-0490 or [email protected]
appliances__c, Microwave;Disposal;Hood Over Range;Free Standing Refrigerator;Free Standing Electric Oven
architectural_style__c, Traditional;Mid-Century
bath_features__c, Tub w/Shower Over
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1945
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2023-08-10
ffd_createddate, 2023-06-19T17:48:05.000+0000
days_on_market__c, 73
dom__c, 48
ffd_description_pb, Parkside home conveniently located just a few blocks to Taraval Street shops and restaurants, half block to Sunset Reservoir, and Quintara & Taraval Street public transit. This home has been in the same family for many decades. Top floor features living room in the front with ocean views, kitchen with breakfast area, full bath, and two bedrooms in the back side by side. Ground floor offers additional bedroom, bath, & one car garage with plenty of storage space. Low maintenance yard!
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-08-31T10:47:22.000+0000
pba__latitude_pb__c, 37.7502596
pba__latitude_property__c, 37.7502596
laundry_features__c, In Garage;Cabinets
listed_date__c, 2023-06-19
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Frank
pba__listing_agent_lastname__c, Vettese
listing_agent_mls_id__c, 816154
ffd_listingagentname, Frank J Vettese III
listing_agent_number__c, 1075137
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, REDF
listing_office_name__c, Redfin
listing_office_number__c, 64045
pba__listingprice_pb__c, 1319000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4867603
lower_level__c, Bedroom(s),Full Bath(s),Garage,Street Entrance
mls_id__c, 423749782
master_bathroom_features__c, Tub w/Shower Over;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2023-06-19
original_price__c, 1200000
overall_days_on_market__c, -81618
parking_access__c, Independent
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-08-22
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-08-30T15:22:01.000+0000
price_per_square_foot__c, 1070.84
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cJcm9UAC
roof__c, Foam
room_type__c, Kitchen;Living Room
sale_date__c, 2023-08-30
sale_price__c, 1300000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector
selling_agent_mls_id__c, 816709
selling_agent_number__c, 1075654
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Legacy Real Estate
pba__status__c, Closed
pba__totalarea_pb__c, 1214
size__c, 1214
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 29th
subdist__c, Parkside
ffd_name, 1990 29th Avenue, San Francisco, CA, 94116
view__c, Ocean
website_property_type__c, Single Family Home
window_features__c, Window Screens
pba__yearbuilt_pb__c, 1945
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530634887-1.jpg