meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='376244' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 12160
[post_author] => 4
[post_date] => 2018-10-29 19:47:38
[post_date_gmt] => 2018-10-29 19:47:38
[post_content] => Proximity to parks, room to roam in the bigger-than-some-SF-neighborhoods yards, and lots of great eateries and local haunts. Downtown is a quick (and probably crowded) N-Judah ride away, and car commuters can hop on 19th Avenue to head south. Yes, there’s more fog than on the east side of town, but that keeps things cool and comfy.
[post_title] => Central Sunset
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => central-sunset
[to_ping] =>
[pinged] =>
[post_modified] => 2024-03-19 12:20:19
[post_modified_gmt] => 2024-03-19 19:20:19
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=12160
[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, 1714611618
ffd_listing_title, 1284 27th Avenue, San Francisco, CA, 94122
ffd_mls_id, 424025200
ffd_salesforce_id, a0EUd000001mjdUMAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 9
of_units__c, 0
address2__c, 1284 27th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1284 27th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Please turn off the lights and lock the main entrance gate after showing! The Escrow opened Fidelity Title, Lynn Chan is the officer. You can download the seller package via: https://app.disclosures.io/link/1284-27th-Avenue-8saf0dvc . Please call for offer instruction. Review offer as it comes.
appliances__c, Dishwasher;Gas Water Heater;Disposal;Hood Over Range;Free Standing Refrigerator;Gas Cook Top
bath_features__c, Shower Stall(s);Tile
pba__fullbathrooms_pb__c, 5
pba__bedrooms_pb__c, 6
year_build_text__c, 1932
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2024-04-19T15:47:19.000+0000
days_on_market__c, 13
dom__c, 13
ffd_description_pb, Welcome to this gorgeous and spacious 6-bedroom, 5-bath single-family home which has undergone a complete modernization. The open kitchen boasts high-end appliances, custom cabinets, and stunning quartz countertops. Upstairs, a beautiful living area with a fireplace, dining room, and 4 bedrooms, including a luxurious master suite, await. The lower level features a generous family room with a built-in wet bar, a second master suite, and a bright 6th bedroom. Additional highlights include a separate laundry room with ample storage and a beautifully landscaped garden with charming flowers. With seismic upgrades, new plumbing, electrical, floors, windows, doors, skylights, and roof, every detail exudes quality. Conveniently situated near Irving street shops, supermarkets, Golden Gate Park, and public transport, this home epitomizes comfort and elegance. Truly a sweet retreat!
district__c, SF District 2
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Fenced
fireplace_features__c, Living Room
pba__floortype_pb__c, Bamboo;Tile
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas;Fireplace(s)
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2024-05-02T00:47:19.000+0000
pba__latitude_pb__c, 37.763524
pba__latitude_property__c, 37.763524
laundry_features__c, In Garage;Laundry Closet;Ground Floor;Washer Included;Dryer Included;Gas Hook-Up
listed_date__c, 2024-04-18
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, 1988000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.485508
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Garage,Primary Bedroom,Street Entrance
mls_id__c, 424025200
master_bathroom_features__c, Shower Stall(s);Tile;Walk-In Closet
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2024-04-18
open_house_end__c, 2024-05-04T16:00:00.000+0000
open_house_start__c, 2024-05-04T14:00:00.000+0000
original_price__c, 1988000
overall_days_on_market__c, -81922
parking_access__c, Independent
parking_features__c, Attached,Garage Door Opener,Garage Facing Front
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, 878.87
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000001mjdUMAQ
road_surface_type__c, Paved
roof__c, Shingle;Other
room_type__c, Laundry;Kitchen;In Law Apartment;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;Security Gate;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, 2262
size__c, 2262
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 27th
subdist__c, Central Sunset
ffd_name, 1284 27th Avenue, San Francisco, CA, 94122
view__c, City Lights
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full;Window Screens
pba__yearbuilt_pb__c, 1932
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530763965-1.jpg
