meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='319675' 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] => 2018-11-30 20:30:31
[post_modified_gmt] => 2018-11-30 20:30:31
[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 2551 28th Avenue, San Francisco, CA, 94116
ffd_mls_id 422696354
ffd_salesforce_id a0E8W00000ZKVInUAP
num_of_fireplaces__c 1
num_of_rooms__c 8
of_units__c 0
address2__c 2551 28th Avenue, San Francisco, CA, 94116
pba__address_pb__c 2551 28th Avenue, San Francisco, CA, 94116
agent_only_remarks__c BOM with no default from seller. Transparent Pricing-great location and wide street. First Republic Bank has a great interest rate at 4.75% 30 years Fixed through their Eagle Community Program. With energy prices going up, this property has solar panels that are owned, updated electrical, updated furnace and water heater, and a 20 year roof warranty that is transferrable to the new buyer. Main level is vacant and separate unit downstairs provides additional rental income of $2080/month and has been a resident for the past 3 years not claiming protected status per estoppel and is currently on a month to month lease. Rear stairs lead to shared backyard and laundry area. Please do not disturb tenant below and reach out for the Matterport link for downstairs or to schedule viewing of downstairs with a 24 hour notice. With any questions, please contact listing agent Melanie Leung at 415.680.8286 or melanie@sequoia-re.com. Pre-escrow 3542200669 opened with Kim Diep with Chicago Title Company. Disclosures are available via DIO: [copy/paste] https://app.disclosures.io/link/2551-28th-Avenue-alr6vgcq
appliances__c Dishwasher;Gas Water Heater;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator;Gas Plumbed
bath_features__c Tub w/Shower Over;Shower Stall(s);Tub;Tile;Low-Flow Shower(s);Window
pba__fullbathrooms_pb__c 2
pba__bedrooms_pb__c 3
year_build_text__c 1906
pba__city_pb__c San Francisco
pba__contingentdate__c 1800-01-01
ffd_createddate 2022-09-30T00:47:50.000+0000
days_on_market__c 112
dom__c 94
ffd_description_pb A radiant and fully detached Parkside retreat, this 3 bedrooms, 2 bathrooms pair contemporary elegance with modern comfort for an elevated living experience not to be missed. Step inside the beautiful and welcoming foyer and discover an abundance of natural light complemented by an open floor plan boasting a living dining room combination perfect for relaxing and entertaining guests. The kitchen is a perfect blend of functionality for you to explore your culinary curiosities. Enjoy morning coffee or a quick bite to eat in the breakfast nook while basking in the warm southern exposure. You will enjoy a spacious rear backyard accented with a beautiful mature tree and an abundance of areas to grow a thriving garden of flowers and edibles. Ideally nestled steps from a local park , the Stern Grove recreation area and local restaurants and cafes along Taraval Street. With a variety of convenient transportation options and close proximity to freeways, this is City living at its finest.
district__c SF District 2
driveway_sidewalks__c Paved Driveway,Paved Sidewalk,Sidewalk/Curb/Gutter
electric__c Solar Chamber,Solar Plumbed
entry_level__c 0
external_listing__c 1
fencing__c Fenced
fireplace_features__c Wood Burning;Brick;Primary Bedroom
pba__floortype_pb__c Concrete;Laminate;Tile;Wood
pba__hoafees__c 0
hoa__c No
pba__halfbathrooms_pb__c 0
has_3d_tour__c 1
pba__heatingtype_pb__c Central;Wall Furnace;Gas;Fireplace(s);Natural Gas
interior_features__c Formal Entry
ffd_lastmodifieddate 2023-01-11T11:47:37.000+0000
pba__latitude_pb__c 37.739783
pba__latitude_property__c 37.739783
laundry_features__c Inside Area;Ground Floor;Washer Included;Dryer Included;Gas Hook-Up;Sink
listed_date__c 2022-09-13
pba__listing_agent_email__c melanie@sequoia-re.com
pba__listing_agent_firstname__c Melanie
pba__listing_agent_lastname__c Leung
listing_agent_mls_id__c 806887
ffd_listingagentname Melanie P Leung
listing_agent_number__c 166017801
listing_co_agent_number__c 0
listing_co_office_number__c 0
listing_office_mls_id__c SQRE
listing_office_name__c Sequoia Real Estate
listing_office_number__c 28627
pba__listingprice_pb__c 1350000
pba__listingtype__c Sale
pba__listing_website__c https://my.matterport.com/show/?m=empH43AddFG
pba__longitude_pb__c -122.485465
lower_level__c Bedroom(s),Full Bath(s),Garage,Kitchen,Living Room,Street Entrance
mls_id__c 422696354
main_level__c Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
monthly_parking_fees__c 0
monthlyrent__c 0
parkingspaces__c 2
on_market_date__c 2022-09-22
original_price__c 1295000
overall_days_on_market__c -81348
parking_access__c Independent
parking_features__c Attached,Enclosed,Garage Door Opener,Interior Access,Tandem Garage
parking_type__c On Site (Single Family Only)
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 971.22
pba__propertytype__c Single Family Residence
ListingId a0E8W00000ZKVInUAP
roof__c Shingle;Flat
room_type__c Storage;Laundry;Kitchen;In Law Apartment;Living Room;Dining Room;Family Room;Great Room
sale_date__c 1800-01-01
sale_price__c 0
security_features__c Smoke Detector;Security Gate;Secured Access;Carbon Mon Detector;Double Strapped Water Heater;Window Security Bars
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 1390
size__c 1390
pba__state_pb__c CA
stories__c 2
pba__street_pb__c 28th
subdist__c Parkside
ffd_name 2551 28th Avenue, San Francisco, CA, 94116
view__c Park
website_property_type__c Single Family Home
pba__yearbuilt_pb__c 1906
pba__postalcode_pb__c 94116
ffd_media Array
ffd_media_tags Array
ffd_featured_image https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530531814-1.jpg