meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='423616' 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-10-31 12:51:41
[post_modified_gmt] => 2024-10-31 19:51:41
[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, 1739449146
ffd_listing_title, 2450 28th Avenue, San Francisco, CA, 94116
ffd_mls_id, 425006886
ffd_salesforce_id, a0EUd000004AH27MAG
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
pba__address_pb__c, 2450 28th Avenue, San Francisco, CA, 94116
address2__c, 2450 28th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, 1) Please contact for offer details. 2) On supra lockbox, NO appointments or additional call/text notices needed. 3) For disclosures please EMAIL (not texting) listing agent Jason Chan at [email protected]. Disclosure link will be emailed to you once it's ready. 4) For questions, please text Jason at 415.215.1661. 5) For lockbox issues or showing difficulties, please contact Julie Chan via email: [email protected] or via text: 415.672.7988. Email or text preferred. 6) SF purchase agreement preferred, but CAR is okay. 7) Please INCLUDE Contingency Removal form & signing off the cover page of the disclosure packet. 8) Please tell your loan agent NOT TO CALL after your offer is submitted. I will contact them if it's necessary. 9) Pre-sale escrow opened w/ WFG National Title Insurance Company with Kathie Ng. 10) Seller reserves the right to accept, counter, or reject any offer.
appliances__c, Dishwasher;Disposal;Hood Over Range;Free Standing Gas Oven;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Craftsman
bath_features__c, Tub w/Shower Over;Shower Stall(s);Low-Flow Toilet(s);Low-Flow Shower(s);Multiple Shower Heads
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 5
year_build_text__c, 1917
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Julie Y Chan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2025-01-29T18:47:02.000+0000
days_on_market__c, 15
dom__c, 15
ffd_description_pb, A rare DETACHED Parkside gem, this beautifully remodeled home sits on a 4,080 square feet lot (per tax records) and features high-end finishes throughout. Top floor features open floor plan that seamlessly connects the living room, kitchen, and dining room stretching from front to back, two generous-sized bedrooms, full bath, powder room, and a large deck through the French doors off the dining room - perfect for indoor-outdoor living. The kitchen features huge skylights, large island, plenty of cabinets & counter space. The abundant windows on all sides floods this home with natural light. An open stairway leads to the ground floor, offering three more bedrooms, two full baths (including a primary suite), a laundry room, and parking for three cars (one in the garage, two side-by-side in the driveway). There's also a separate entrance to the ground floor from the side door. A bonus backyard shed adds extra storage or a fun kids' playhouse. With a rare approximately 34 foot wide lot comparing to most homes built on 25 feet wide lots in the area, this home provides exceptional space in and out. Conveniently located close to Taraval MUNI lines, Parkside Square, Pine Lake Park, Stern Grove, Lakeshore Plaza, Lake Merced, and the SF Zoo, this is a rare find in a prime neighborhood!
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Family Room
pba__floortype_pb__c, Tile;Simulated Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2025-02-13T11:47:58.000+0000
pba__latitude_pb__c, 37.7416594
pba__latitude_property__c, 37.7416594
laundry_features__c, Inside Room
listed_date__c, 2025-01-29
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, 2195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4850307
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Primary Bedroom,Street Entrance
mls_id__c, 425006886
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Low-Flow Toilet(s);Double Sinks;Low-Flow Shower(s)
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2025-01-29
open_house_end__c, 2025-02-16T16:00:00.000+0000
open_house_start__c, 2025-02-16T14:00:00.000+0000
original_price__c, 2195000
overall_days_on_market__c, -82208
parking_access__c, Tandem
parking_features__c, Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Back Porch
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, 1007.81
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004AH27MAG
road_surface_type__c, Paved
room_type__c, Kitchen;Dining Room;Family Room;Primary Bedroom
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector;Carbon Mon Detector
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, 2178
size__c, 2178
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 28th
subdist__c, Parkside
ffd_name, 2450 28th Avenue, San Francisco, CA, 94116
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1917
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530937579-1.jpg