meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='212538' 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, 606 Diamond Street, San Francisco, CA, 94114
ffd_mls_id, 499080
ffd_salesforce_id, a0E1I00000SK7zQUAT
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 606 Diamond Street, San Francisco, CA, 94114
pba__address_pb__c, 606 Diamond Street, San Francisco, CA, 94114
agent_only_remarks__c, SFAR regulations- BEFORE accessing home ALL Agents MUST submit PEAD forms to listing agent Buyer to submit copy of 10% cashier's check with offer. Buyers to use CAR Probate purchase contract and per contract, sale is subject to heir approval, BUYER MUST SIGN disclosure package and addenda, provide proof of funds and pre-approval letter. Offers welcome 6/16/20 by 10:00 am. Seller reserves the right to reject any offer. Email request to listor for disclosure package. Virtual tour at www.606diamond.com
architectural_style__c, Victorian
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1908
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2020-06-04T21:46:27.000+0000
days_on_market__c, 1140
dom__c, 13
ffd_description_pb, Vintage PEAKED ROOF VICTORIAN on beautiful block in the HEART of Noe Valley. Abundant and lovely exterior CHARM over three levels of this spacious FULLY DETACHED private home on EXTRA-WIDE lot. Nice two bedroom PLUS DEN residence has so many, many ways for EXPANSION from either SIDE to SIDE or up, up with the VIEWS! Very nice light filled MOVE-IN condition home features BAYED windows in living room w/ FIREPLACE, Formal Dining Room, HARDWOOD Floors, Newer DOUBLE-Pane Windows, large PATIO, with Terraced GARDEN,and lots of California FRUIT TREES. BONUS 2 EXTRA large storage rooms + LAUNDRY ROOM and GARAGE. Super location has EASY 95 WALK SCORE to 24th St shops, transportation, schools, churches and parks too. BEST VALUE in THE VALLEY!!! Absolutely a MUST SEE! Will Not Last !! Hurry !!! Virtual tour at www.606diamond.com
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
pba__floortype_pb__c, Wood
hoa_dues__c, 0
pba__hoafees__c, 0
pba__halfbathrooms_pb__c, 0
ffd_lastmodifieddate, 2022-01-25T15:24:11.000+0000
pba__latitude_pb__c, 37.752525
pba__latitude_property__c, 37.752525
listed_date__c, 2020-06-02
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Hawko
listing_agent_mls_id__c, 378394
ffd_listingagentname, Tim Hawko
listing_agent_number__c, 378394
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, PKNO
listing_office_name__c, Park North Real Estate
listing_office_number__c, 24343
pba__listingprice_pb__c, 1128000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.436747
pba__lotsize_pb__c, 0.08
mls_id__c, 499080
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 1
on_market_date__c, 2020-06-04
original_price__c, 1128000
overall_days_on_market__c, 145
parking__c, Garage,Auto Door
parking_access__c, Independent
parking_features__c, Garage Door Opener,Garage
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Patio(s)
pba__pendingdate__c, 2020-06-17
possible_bedrooms__c, 0
pba__pricechangedat__c, 1800-01-01T00:00:00.000+0000
price_per_square_foot__c, 1707.32
pba__propertytype__c, Single Family Residence
id, a0E1I00000SK7zQUAT
sale_date__c, 2020-07-17
sale_price__c, 1750000
selling_agent_mls_id__c, 807892
selling_agent_name__c, Edward J. Mullins IV
selling_agent_number__c, 1028206
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Mullins & Co.
pba__status__c, Closed
pba__totalarea_pb__c, 1025
size__c, 1025
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Diamond
subdist__c, Noe Valley
ffd_name, 606 Diamond Street, San Francisco, CA, 94114
transportation__c, 2 Blocks
view__c, City Lights;Valley
website_property_type__c, Single Family Home
window_features__c, Bay Window(s)
pba__yearbuilt_pb__c, 1908
pba__postalcode_pb__c, 94114
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/364116-1.jpg
ListingId, a0E1I00000SK7zQUAT