meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='424850' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 15733
[post_author] => 4
[post_date] => 2018-11-02 19:54:58
[post_date_gmt] => 2018-11-02 19:54:58
[post_content] => Sunny, sedate, central, strollers, and tech-centric. Once upon a time home searches began in Pacific Heights and settled for Noe Valley. Now home searches begin here and settle for Pacific Heights.
Connect with a Jackson Fuller Real Estate agent today and explore the diverse range of homes for sale in Noe Valley.
[post_title] => Noe Valley
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => noe-valley
[to_ping] =>
[pinged] =>
[post_modified] => 2024-10-31 12:21:05
[post_modified_gmt] => 2024-10-31 19:21:05
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=15733
[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, 1742520067
ffd_listing_title, 1559 Church 1559A Street, San Francisco, CA, 94131
ffd_mls_id, 425004409
ffd_salesforce_id, a0EUd000004P30PMAS
num_of_fireplaces__c, 0
num_of_rooms__c, 16
of_units__c, 0
pba__address_pb__c, 1559 Church 1559A Street, San Francisco, CA, 94131
address2__c, 1559 Church 1559A Street, San Francisco, CA, 94131
agent_only_remarks__c, www.1559Church.com For Showings or disclosures call or text Luke (415-734-0423) and Kirk (415-203-8638). Published sqft is per tax records. Buyer to independently verify sqft. This Property is permitted as a duplex. Vanguard Properties has not and will not investigate the deviations existing between the permitted plans and as-build conditions at the Property. Vanguard Properties does not make any representations or warranties regarding the ability to use the Property as a single-family home and has not and will not verify same. Buyer is advised to investigate the ability to use the Property in the manner Buyer intends.
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tile;Double Sinks;Radiant Heat
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 5
year_build_text__c, 2017
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Kirk M Dahle
pba__contingentdate__c, 1800-01-01
cooling__c, MultiUnits,MultiZone,Wall Unit(s)
ffd_createddate, 2025-02-28T02:47:45.000+0000
days_on_market__c, 21
dom__c, 21
ffd_description_pb, Stunning contemporary property in the heart of Noe Valley! Highlighting architecturally bold design, this gorgeous property offers 4 levels of spacious living, featuring 5 beds and 4.5 baths. Flanked by floor to ceiling windows on two sides, the main level begins with an inviting foyer with powder room and flows seamlessly into the exquisite living room with a striking marble fireplace. This level continues with an exceptionally stylish kitchen boasting sleek, modern cabinets and chef quality appliances, a spacious dining area and a family room with direct access to a large outdoor patio. The 2 upper levels enjoy a large primary suite featuring a magazine worthy primary bath, plus 3 spacious bedrooms, 2 equally bold and stylish baths, and a spectacular top floor family room with a full wet bar and access to yet another generous outdoor patio and an amazing roof-top deck with a gas fire pit. The lower level features a spacious legal one bedroom in-law apartment with a modern kitchen, bath and laundry, and direct access to the large, level backyard with a tall palm tree and a fire feature. A 2 car garage completes this level. All of this, plus multi-zone A/C, radiant heat, full building water filtration, built-in speakers and easy access the best of Noe Valley!
district__c, SF District 5
driveway_sidewalks__c, Paved Sidewalk,Sidewalk/Curb/Gutter
entry_level__c, 0
exterior_features__c, Balcony;Uncovered Courtyard;Entry Gate;Fire Pit
external_listing__c, 1
fencing__c, Back Yard;Fenced
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Radiant;MultiUnits;MultiZone
interior_features__c, Formal Entry;Skylight(s)
ffd_lastmodifieddate, 2025-03-21T00:47:35.000+0000
pba__latitude_pb__c, 37.7401042
pba__latitude_property__c, 37.7401042
laundry_features__c, Laundry Closet;In Basement;Upper Floor
listed_date__c, 2024-10-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Luke
pba__listing_agent_lastname__c, Schemmel
listing_agent_mls_id__c, 809156
ffd_listingagentname, Luke W Schemmel
listing_agent_number__c, 1040848
listing_co_agent_mls_id__c, 806092
listing_co_agent_number__c, 166016263
listing_co_office_mls_id__c, VANG03
listing_co_office_name__c, Vanguard Properties
listing_co_office_number__c, 1228
listing_office_mls_id__c, VANG03
listing_office_name__c, Vanguard Properties
listing_office_number__c, 1228
pba__listingprice_pb__c, 5695000
pba__listingtype__c, Sale
pba__listing_website__c, https://mls.ricoh360.com/aded0244-6f08-48fb-8630-55129bac72d5/589ed385-2504-43ba-814b-c285bea8345f
pba__longitude_pb__c, -122.4382307
lower_level__c, Bedroom(s),Family Room,Full Bath(s),Kitchen
mls_id__c, 425004409
main_level__c, Partial Bath(s);Kitchen;Living Room;Dining Room;Family Room
master_bathroom_features__c, Shower Stall(s);Double Sinks;Tile;Radiant Heat
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2025-02-27
open_house_end__c, 2025-03-22T15:00:00.000+0000
open_house_start__c, 2025-03-22T13:00:00.000+0000
original_price__c, 5695000
overall_days_on_market__c, -82237
parking_access__c, Side by Side
parking_features__c, Covered,Garage Door Opener,Garage Facing Front,Side-by-Side
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Roof Deck;Uncovered Deck;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, 1465.52
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000004P30PMAS
road_surface_type__c, Asphalt
room_type__c, Office;Kitchen;In Law Apartment;Living Room;Dining Room;Family Room;Media 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;Fire Suppression System;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, 3886
size__c, 3886
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Church
subdist__c, Noe Valley
ffd_name, 1559 Church 1559A Street, San Francisco, CA, 94131
view__c, City;City Lights;Downtown;Bay Bridge;San Francisco;Hills;Sutro Tower
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 2017
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530950254-1.jpg