meta_query='key:subdist__c;value:Parkside|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378244' 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, 1721955975
ffd_listing_title, 2123 29th Avenue, San Francisco, CA, 94116
ffd_mls_id, 424035229
ffd_salesforce_id, a0EUd00000275ppMAA
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2123 29th Avenue, San Francisco, CA, 94116
pba__address_pb__c, 2123 29th Avenue, San Francisco, CA, 94116
agent_only_remarks__c, Welcome back up offer. Supra lock box is on, Please go directly. You can view the seller package via: https://app.disclosures.io/link/2123-29th-Avenue-cp8qql8o .Presale escrow opened with Lynn Chan at Fidelity Title Company. Please call agent for offer instruction.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
architectural_style__c, Traditional
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1937
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-07-20
ffd_createddate, 2024-05-23T17:46:40.000+0000
days_on_market__c, 63
dom__c, 63
ffd_description_pb, Sweeping Ocean View Oasis. Welcome to this stunning modern home in Central Sunset, where every bedroom boasts breathtaking ocean views. This stylishly renovated gem combines modern luxury with sophisticated living, offering the the perfect sanctuary for relaxation and entertainment. From the moment you step inside, you'll be enchanted by the tasteful design and natural light streaming from multiple skylights. Featuring 4BD/1 Den/4BA, this luxurious home has an open, airy floor plan with beautiful hardwood floors throughout. The main floor includes a skylight-filled living area with high ceiling that flows into a state-of-the-art kitchen with a waterfall island, custom cabinets, and top-of-the-line appliances, a formal dining area, and 2BD/1 Den/2BA. The lower level offers an additional 2BD/2BA, a spacious family room, and a second master bedroom that opens to an astounding backyard. This versatile layout is ideal for extended family or guest quarters. A rare gem, this home is perfectly located with convenient access to schools, trails near Sunset Reservoir, Ocean Beach, and the trendy shops and restaurants along vibrant Noriega Street.
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Fireplace(s);Natural Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2024-07-26T00:48:00.000+0000
pba__latitude_pb__c, 37.7477031
pba__latitude_property__c, 37.7477031
laundry_features__c, In Garage;Laundry Closet;Gas Hook-Up
listed_date__c, 2024-05-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ken
pba__listing_agent_lastname__c, Kwok
listing_agent_mls_id__c, 981462
ffd_listingagentname, Ken K Kwok
listing_agent_number__c, 981462
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, MXRE1
listing_office_name__c, MaxReal
listing_office_number__c, 25562
pba__listingprice_pb__c, 2295000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4870483
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Primary Bedroom,Street Entrance
mls_id__c, 424035229
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance;Primary Bedroom
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2024-05-23
open_house_end__c, 2024-07-28T16:00:00.000+0000
open_house_start__c, 2024-07-28T14:00:00.000+0000
original_price__c, 2295000
overall_days_on_market__c, -81957
parking_access__c, Tandem
parking_features__c, Attached,Garage Door Opener,Garage Facing Front
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered 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, 976.6
pba__propertytype__c, Single Family Residence
ListingId, a0EUd00000275ppMAA
roof__c, Shingle;Other
room_type__c, Storage;Office;Kitchen;Living Room;Dining Room;Family Room;Primary Bathroom;Primary Bedroom;Primary Bedroom 2+
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Smoke Detector
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 2350
size__c, 2350
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 29th
subdist__c, Parkside
ffd_name, 2123 29th Avenue, San Francisco, CA, 94116
view__c, Ocean
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1937
pba__postalcode_pb__c, 94116
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530783123-1.jpg