meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='210250' 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-03-07 13:06:57
[post_modified_gmt] => 2024-03-07 21:06:57
[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, 831 27th Street, San Francisco, CA, 94131
ffd_mls_id, 495572
ffd_salesforce_id, a0E1I00000RqcvQUAR
num_of_fireplaces__c, 1
num_of_rooms__c, 8
of_units__c, 0
address2__c, 831 27th Street, San Francisco, CA, 94131
pba__address_pb__c, 831 27th Street, San Francisco, CA, 94131
agent_only_remarks__c, Panoramic views from Liv , master, middle bed and and Landscaped yard by PatriclkLannan Design.
appliances__c, Dishwasher;Gas Range;Refrigerator;Hood Over Range;Double Oven
architectural_style__c, Contemporary
bath_features__c, Shower Stall(s);Tub;Remodeled;Tile;Skylight/Solar Tube;Jetted Tub
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1972
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-02-28T11:46:07.000+0000
days_on_market__c, 1237
dom__c, 6
ffd_description_pb, Designed for indoor/outdoor livability yet every detail speaks of quiet elegance. The beautifully done chef's kitchen is likely to be the heart of the home with patio doors for indoor/outdoor living. The home has an inviting terraced yard with dramatic skyline views recently completed that features both upper and lower deck areas and patio space. You will enjoy the abundant counters and storage space, the large peninsula, perfect for informal bottle of wine shared with friends. The open floorplan living room/dining room, accented by sliding doors to the front balcony with panoramic city skyline views. Skylights thorough out the main floor giving warm natural light. The base of the entry stairs leads to the fourth bedroom, and access to two-car garage, unwarranted full bath, with ample bike storage & large storage areas. This cul-de-sac has only 9 houses on one side and faces beautiful Douglas Park, 1 block to Diamond Hgts Shopping Center with Safeway, Walgreens, BofA & Post office
district__c, SF District 5
driveway_sidewalks__c, Paved Driveway
entry_level__c, 0
external_listing__c, 1
fencing__c, Fenced Yard
fireplace_features__c, Gas Piped
pba__floortype_pb__c, Tile;Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Gas
ffd_lastmodifieddate, 2022-01-12T15:28:38.000+0000
pba__latitude_pb__c, 37.745993
pba__latitude_property__c, 37.745993
laundry_features__c, In Garage;In Basement
listed_date__c, 2020-02-27
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Ben
pba__listing_agent_lastname__c, Coleman
listing_agent_mls_id__c, 239899
ffd_listingagentname, Uncle Ben Coleman
listing_agent_number__c, 239899
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, CHFD
listing_office_name__c, Hartford Properties
listing_office_number__c, 826
pba__listingprice_pb__c, 2700000
pba__listingtype__c, Sale
pba__listing_website__c, https://www.831-27thst.com/unbranded
pba__longitude_pb__c, -122.438503
pba__lotsize_pb__c, 0.1
lower_level__c, Full Bath(s)
mls_id__c, 495572
main_level__c, Full Bath(s);Bedroom(s)
master_bathroom_features__c, Tub
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2020-02-28
original_price__c, 2700000
overall_days_on_market__c, 91
parking__c, Attached
parking_features__c, Attached
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-03-05
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1444.39
pba__propertytype__c, Single Family Residence
id, a0E1I00000RqcvQUAR
roof__c, Foam
sale_date__c, 2020-03-25
sale_price__c, 3000000
security_features__c, Fire Suppression System
selling_agent_mls_id__c, 355987
selling_agent_name__c, Debbie Hemingway
selling_agent_number__c, 355987
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Sotheby's International Realty
pba__status__c, Closed
pba__totalarea_pb__c, 2077
size__c, 2077
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 27th
subdist__c, Noe Valley
ffd_name, 831 27th Street, San Francisco, CA, 94131
transportation__c, 1 Block
view__c, Panoramic;City Lights;Bay;Bay Bridge;San Francisco
website_property_type__c, Single Family Home
window_features__c, Window Coverings;Dual Pane
pba__yearbuilt_pb__c, 1972
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/360869-1.jpg
ListingId, a0E1I00000RqcvQUAR