meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='240370' 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] => Stroller paradise. Tech-bro ground zero. Sunny, sedate, central. 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.
[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] => 2023-03-09 10:14:08
[post_modified_gmt] => 2023-03-09 18:14:08
[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
(
)
)
ffd_listing_title, 542 Duncan Street #201, San Francisco, CA, 94131
ffd_mls_id, 422690907
ffd_salesforce_id, a0E8W00000YZCwjUAH
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 2
address2__c, 542 Duncan Street #201, San Francisco, CA, 94131
pba__address_pb__c, 542 Duncan Street #201, San Francisco, CA, 94131
agent_only_remarks__c, Please email [email protected] for showing requests and questions. Property website with virtual tour, photos and floor plan available here: www.542Duncan.com. 2,768 sqft per tax record. 2,575 sqft per graphic artist.
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Free Standing Gas Range;Free Standing Refrigerator
bath_features__c, Tile
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 4
year_build_text__c, 1992
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Todd Montgomery
pba__contingentdate__c, 2022-09-25
ffd_createddate, 2022-09-08T10:50:17.000+0000
days_on_market__c, 176
dom__c, 19
ffd_description_pb, Nestled at the end of a charming cul-de-sac, this exceptional bi-level view home offers 4 bedrooms, 3 bathrooms, and an integrated indoor-outdoor lifestyle with 3 skyline-view balconies in an expansive 2,575 sq. ft. floor plan. Sweeping views of the city stretch from Twin Peaks to the illuminated downtown skyline, across the SF Bay, and beyond to the East Bay, providing a stunning backdrop for the grand, open-air living/dining area, with its own terrace, and open-concept wraparound bar seating kitchen. The top floor offers 2 luxurious bedroom suites with view balconies. Also included are 2 additional bedrooms, an updated bath, and 2-car parking with additional storage. A central Noe Valley location, close to the J Church Muni line, offers easy access to the 24th st. commercial corridor, with a variety of shopping and dining, Whole Foods, and all major necessities.
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway,Paved Sidewalk,Shared Driveway
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning
pba__floortype_pb__c, Carpet;Tile;Wood
hoa_fee_includes__c, Common Areas,Insurance on Structure,Maintenance Exterior,Maintenance Grounds,Trash
pba__hoafees__c, 150
pba__hoafrequency_pb__c, Monthly
hoa__c, Yes
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-03-01T23:47:29.000+0000
pba__latitude_pb__c, 37.746015
pba__latitude_property__c, 37.746015
laundry_features__c, Washer/Dryer Stacked Included
listed_date__c, 2022-09-07
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Marcus
pba__listing_agent_lastname__c, Lee
listing_agent_mls_id__c, 804756
ffd_listingagentname, Marcus A Lee
listing_agent_number__c, 166014430
listing_co_agent_mls_id__c, 807753
listing_co_agent_number__c, 1025356
listing_co_office_mls_id__c, COMP12
listing_co_office_name__c, Compass
listing_co_office_number__c, 28739
listing_office_mls_id__c, COMP12
listing_office_name__c, Compass
listing_office_number__c, 28739
pba__listingprice_pb__c, 2375000
pba__listingtype__c, Sale
pba__listing_website__c, https://vimeo.com/744515781/bb9d954862
pba__longitude_pb__c, -122.432377
lower_level__c, Garage,Street Entrance
mls_id__c, 422690907
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
master_bathroom_features__c, Shower Stall(s);Tile;Soaking Tub;Window;Skylight/Solar Tube
master_property__c, a0O8W00000Fr7Z2UAJ
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2022-09-07
original_price__c, 2375000
overall_days_on_market__c, -81333
parking_access__c, Tandem
parking_features__c, Attached,Garage Facing Front,Tandem Garage
parking_type__c, On Site - Mapped (Condo Only)
pba__pendingdate__c, 2022-09-26
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 893.2
pba__propertytype__c, Condominium
ListingId, a0E8W00000YZCwjUAH
room_type__c, Kitchen;Living Room;Baths Other;Dining Room;Primary Bathroom;Primary Bedroom 2+
sale_date__c, 2022-10-21
sale_price__c, 2300000
selling_agent_mls_id__c, 400593
selling_agent_number__c, 1019790
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2575
size__c, 2575
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Duncan
subdist__c, Noe Valley
ffd_name, 542 Duncan Street #201, San Francisco, CA, 94131
view__c, City;City Lights;Water;Sutro Tower
website_property_type__c, Condominium
pba__yearbuilt_pb__c, 1992
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530524604-1.jpg