meta_query='key:subdist__c;value:Central Sunset|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='221396' 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, 2027 Noriega Street, San Francisco, CA, 94127
ffd_mls_id, 421599287
ffd_salesforce_id, a0E8W00000V0YcnUAF
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 2027 Noriega Street, San Francisco, CA, 94127
pba__address_pb__c, 2027 Noriega Street, San Francisco, CA, 94127
agent_only_remarks__c, Website 2027noriega.com Easy to show contact Tiffany 415.810.9474 or Meryl 415.637.7059. Seller reserves the right to reject, accept and counter any offers. Offers Dues Tuesday October 12th at 10am. https://app.disclosures.io/link/2027-Noriega-Street-yy9wjxtl
appliances__c, Dishwasher;Gas Water Heater;Built-In Gas Range;Free Standing Gas Range;Free Standing Refrigerator;Gas Cook Top
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 3
year_build_text__c, 1939
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Meryl Bennan
pba__contingentdate__c, 2021-10-12
cooling__c, None
ffd_createddate, 2021-10-01T16:47:56.000+0000
days_on_market__c, 656
dom__c, 43
ffd_description_pb, Ideal location, exquisite light and unique layout make this move-in ready Sunset home a stand out! Open floor plan living space with vintage flourishes: crown molding, high ceilings, arched windows and newly refinished hardwood floors. The kitchen has s/s appliances and bonus burners for enthusiastic entertainers. Primary bedroom in the quiet back of home overlooks neighborhood greenery with windows on 3 sides. A second bedroom and newly renovated bathroom complete this floor. Downstairs is a showstopper with sunlight pouring in from the South! Complete with wet bar and full bath. Use for extended family, guest quarters, home office or all of the above. With direct access to the landscaped yard, perfect for your indoor/outdoor entertaining needs. Further out back a large storage room awaits your imagination. Situated on a residential block of Noriega, shops, restaurants and transportation are all within a short stroll. Ocean Beach and Golden Gate Park are just down the road.
district__c, SF District 2
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
exterior_features__c, Entry Gate
external_listing__c, 1
fencing__c, Back Yard
fireplace_features__c, Living Room;Brick
pba__floortype_pb__c, Laminate;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
interior_features__c, Wet Bar
ffd_lastmodifieddate, 2022-01-25T16:03:37.000+0000
pba__latitude_pb__c, 37.753581
pba__latitude_property__c, 37.753581
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2021-08-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tiffany
pba__listing_agent_lastname__c, Pavon
listing_agent_mls_id__c, 810731
ffd_listingagentname, Tiffany Pavon
listing_agent_number__c, 1047647
listing_co_agent_mls_id__c, 811135
listing_co_agent_number__c, 1050026
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, 1195000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.485562
lower_level__c, Bedroom(s),Family Room,Garage
mls_id__c, 421599287
main_level__c, Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2021-10-01
original_price__c, 1195000
overall_days_on_market__c, 150
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, 2021-11-13
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 938.71
pba__propertytype__c, Single Family Residence
id, a0E8W00000V0YcnUAF
road_surface_type__c, Asphalt
room_type__c, Storage;Bonus Room;Sun Room;Kitchen;Living Room;Dining Room
sale_date__c, 2021-11-15
sale_price__c, 1700000
security_features__c, Smoke Detector;Security Gate;Carbon Mon Detector;Double Strapped Water Heater
selling_agent_mls_id__c, 804196
selling_agent_number__c, 166013680
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Coldwell Banker Realty
pba__status__c, Closed
pba__totalarea_pb__c, 1811
size__c, 1811
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Noriega
subdist__c, Central Sunset
ffd_name, 2027 Noriega Street, San Francisco, CA, 94127
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1939
pba__postalcode_pb__c, 94127
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530333287-1.jpg
ListingId, a0E8W00000V0YcnUAF