meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='209940' 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, 2567 31st Avenue, San Francisco, CA, 94116
ffd_mls_id, 494428
ffd_salesforce_id, a0E1I00000QpSiVUAV
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 2567 31st Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2567 31st Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Rare home owning opportunity! Back on market, no fault on both parties. ADU in process. Receiving offers as they come. Seller is very motivated. Please text listing agent Daniel Liu 415-598-9888 before showing. Disclosures: https://app.disclosures.io/link/2576-31st-Avenue-dbvntjje Escrow open with Nancy Chan, Escrow#5954568. Please call with any questions. Sellers have the right to accept, reject, or counter any offers.
appliances__c, Dishwasher;Gas Range;Refrigerator;Freestanding Range;Hood Over Range;Ice Maker;Built-In Oven
architectural_style__c, Spanish/Med
bath_features__c, Tub w/Shower Over;Shower Stall(s);Split Bath;Remodeled;Marble;Tile;Skylight/Solar Tube
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 1931
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Daniel Liu
pba__contingentdate__c, 1800-01-01
cooling__c, Ceiling Fan(s)
ffd_createddate, 2020-02-02T11:45:29.000+0000
days_on_market__c, 1484
dom__c, 220
ffd_description_pb, Stunning newly remodeled 3-level home conveniently located in the Parkside. Upper level has ocean view, living room/wet bar and good size bedroom/bath. Main level is made up of a beautiful living room with a modern electric fireplace, a beautifully equipped/fully-functional kitchen with new appliances. Two Bedrooms facing west to the redesigned garden for your entertainment. Lower level has one master suite and another one bedroom one bath with common sitting area for eating and snacks. The backyard has amazing well-lit low maintenance landscaping. It is perfect for hosting parties/gatherings. Easy transportation, just blocks away to shops, schools and freeway. Don't miss out this opportunity to make it your home sweet home.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Living Room;Electric
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Wall Furnace
interior_features__c, Formal Entry;Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2022-01-12T15:27:11.000+0000
pba__latitude_pb__c, 37.73936
pba__latitude_property__c, 37.73936
laundry_features__c, In Garage;Washer/Dryer Included;In Basement
listed_date__c, 2019-06-26
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Mindy
pba__listing_agent_lastname__c, Tsoi
listing_agent_mls_id__c, 805761
ffd_listingagentname, Mindy Tsoi
listing_agent_number__c, 166015806
listing_co_agent_mls_id__c, 812796
listing_co_agent_number__c, 1058275
listing_co_office_mls_id__c, COMP12PUI
listing_co_office_name__c, Compass
listing_co_office_number__c, 27690
listing_office_mls_id__c, INTR12
listing_office_name__c, Intero Real Estate Services
listing_office_number__c, 25601
pba__listingprice_pb__c, 1799950
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.48865
pba__lotsize_pb__c, 0.07
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Master Bedroom
mls_id__c, 494428
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2019-06-26
original_price__c, 1799950
overall_days_on_market__c, 248
parking__c, Attached,Garage
parking_access__c, Independent
parking_features__c, Attached,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Enclosed Patio;Deck(s);Patio(s)
pba__pendingdate__c, 2020-02-01
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 691.24
pba__propertytype__c, Single Family Residence
id, a0E1I00000QpSiVUAV
roof__c, Tar/Gravel
room_type__c, Bonus Room;In Law Apartment
sale_date__c, 2020-02-01
sale_price__c, 1735000
security_features__c, Smoke Detector
selling_agent_mls_id__c, 810285
selling_agent_name__c, Jaime R. Watson
selling_agent_number__c, 1045440
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, BarbCo
pba__status__c, Closed
pba__totalarea_pb__c, 2510
size__c, 2510
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 31st
subdist__c, Parkside
ffd_name, 2567 31st Avenue, San Francisco, CA, 94116
transportation__c, 1 Block
view__c, Ocean;City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane;Window Screens
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/359834-1.jpg
ListingId, a0E1I00000QpSiVUAV