meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='320332' 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
(
)
)
ffd_listing_title, 1687 27th Avenue, San Francisco, CA, 94122
ffd_mls_id, 422699939
ffd_salesforce_id, a0E8W00000ZLloaUAD
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 1687 27th Avenue, San Francisco, CA, 94122
pba__address_pb__c, 1687 27th Avenue, San Francisco, CA, 94122
agent_only_remarks__c, Updated 11/09/22: Hurry, Seller will take off market, prior to Thanksgiving. Don't miss the opportunity for your clients on this great home. Property qualifies for First Republic Bank's Eagle Community Program. The program offers a 30yr fixed @ 3.75%, no points, no prepayment penalty and up to $4000 closing credit. For loans greater than $1M, then 4.5%, 30yr fixed with 20% down payment. For more information, see attached or please contact Tony Dinh at First Republic, [email protected]. Suprabox on at front door. Include this one on your tour list! Clean and beautifully maintained with period trim and gleaming hardwood floors. PreEscrow opened with Connie Choy at DOMA Title Co. #56606-22-06278 Lower level is built without benefit of permits. Buyer to investigate all bed and bath count along with square foot for living and lot to satisfaction. Successor Trustee sale, no death on property. Disclosures are available by request to [email protected] or text 415.867.7869. Thank you for showing!
appliances__c, Dishwasher;Gas Cook Top;Free Standing Electric Oven
architectural_style__c, Marina
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1929
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2022-11-17
ffd_createddate, 2022-10-21T18:47:16.000+0000
days_on_market__c, 271
dom__c, 31
ffd_description_pb, Beautifully maintained Classic Marina Style Central Sunset Home. Elegant period charm with spacious living room and formal dining room. Generously sized kitchen complete with granite counter tops and stainless steel appliances. Abundance of natural light and landmark views to enjoy. Main level features 2BD/1.5BA and bonus 2BD/1BA at lower level. Garage with plenty of room for storage. Try your green thumb with the low maintenance garden. Just blocks away from Sunset Playground, Shopping Districts, Reservoir Greenbelt, and Schools. Ask about special financing options. Open Sat & Sun 2-4pm.
district__c, SF District 2
entry_level__c, 0
external_listing__c, 1
fencing__c, Wood
fireplace_features__c, Living Room;See Remarks
pba__floortype_pb__c, Laminate;Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2023-07-13T17:54:02.000+0000
pba__latitude_pb__c, 37.7560011
pba__latitude_property__c, 37.7560011
laundry_features__c, Hookups Only
listed_date__c, 2022-10-05
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Michael
pba__listing_agent_lastname__c, Soon
listing_agent_mls_id__c, 805940
ffd_listingagentname, Michael B Soon
listing_agent_number__c, 166016039
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP3
listing_office_name__c, Compass
listing_office_number__c, 27342
pba__listingprice_pb__c, 1280000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.1687-27thAve.com
pba__longitude_pb__c, -122.4854713
lower_level__c, Bedroom(s),Family Room,Full Bath(s)
mls_id__c, 422699939
main_level__c, Full Bath(s);Partial Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Tub w/Shower Over
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2022-10-21
original_price__c, 1280000
overall_days_on_market__c, -81377
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, 2022-11-21
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1038.78
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000ZLloaUAD
roof__c, Tar/Gravel
sale_date__c, 2022-12-08
sale_price__c, 1500000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 516371
selling_agent_number__c, 516371
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Vanguard Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1444
size__c, 1444
pba__state_pb__c, CA
stories__c, 2
pba__street_pb__c, 27th
subdist__c, Central Sunset
ffd_name, 1687 27th Avenue, San Francisco, CA, 94122
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1929
pba__postalcode_pb__c, 94122
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530538119_8c17cb71-a7c8-4015-892e-507fc2a0a214.jpg