meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='382688' 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, 1725360728
ffd_listing_title, 2478 27th Avenue, San Francisco, CA, 94116
ffd_mls_id, 424051878
ffd_salesforce_id, a0EUd000002ecQPMAY
num_of_fireplaces__c, 0
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2478 27th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2478 27th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Supra is on. Please email question and request of disclosure to: [email protected]. Pre-escrow is with Linda Yee, Fidelity National Title, 2661 Ocean Ave.,SF. Seller reserves the right to accept, counter, reject any offer.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;ENERGY STAR Qualified Appliances;Built-In Refrigerator;Gas Cook Top;Built-In Freezer;Built-In Electric Oven
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1935
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-07-24T17:48:38.000+0000
days_on_market__c, 41
dom__c, 41
ffd_description_pb, Exquisite custom home perched on a prime block at serene Central Parkside! Reinvented down to the studs, this fully detached oasis offers the perfect setting for all lifestyles, work, play, and relaxation. Extra expansive open floor plan, numerous skylights, floor to ceiling front window, abundant natural light fills every corner. Bright & airy chef's kitchen is a culinary enthusiast's delight with full set of Thermador appliances, wine cellar, cabinetry, quartz counter. Two master suites looking out to landscaped backyard from the deck on main floor plus a half bath designed specially for guests. White oak flooring throughout. Glass staircase opening to below. Ground level features ceiling over 9 feet 2 inches high, two master suites, family room, wet bar, laundry and a seamless transit between indoor & outdoor living in the private backyard to complete the sense of comfort and sublime enjoyment. Cafes, restaurants, grocery markets, schools, play ground just blocks away. Minutes to Sunset hot spots.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Gas
interior_features__c, Skylight(s);Storage Area(s);Wet Bar
ffd_lastmodifieddate, 2024-09-03T10:47:52.000+0000
pba__latitude_pb__c, 37.7412313
pba__latitude_property__c, 37.7412313
laundry_features__c, Laundry Closet;Ground Floor;Washer Included;Dryer Included;Sink
listed_date__c, 2024-07-01
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ellen
pba__listing_agent_lastname__c, Wu
listing_agent_mls_id__c, 808597
ffd_listingagentname, Ellen H Wu
listing_agent_number__c, 1037173
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PATH
listing_office_name__c, Pathway Realty
listing_office_number__c, 29043
pba__listingprice_pb__c, 2188000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4839251
lower_level__c, Full Bath(s),Garage,Living Room,Primary Bedroom,Street Entrance
mls_id__c, 424051878
main_level__c, Full Bath(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Quartz;Double Sinks;Tile;Soaking Tub;Skylight/Solar Tube;Dual Flush Toilet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-07-24
open_house_end__c, 2024-09-08T16:00:00.000+0000
open_house_start__c, 2024-09-08T14:00:00.000+0000
original_price__c, 2188000
overall_days_on_market__c, -82019
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch;Enclosed Patio
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, 905.25
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000002ecQPMAY
room_type__c, Kitchen;Wine Cellar;Living Room;Dining Room;Media Room;Primary Bathroom;Primary Bedroom 2+
sale_date__c, 1800-01-01
sale_price__c, 0
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, 2417
size__c, 2417
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 27th
subdist__c, Parkside
ffd_name, 2478 27th Avenue, San Francisco, CA, 94116
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Bay Window(s)
pba__yearbuilt_pb__c, 1935
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530815660-1.jpg