meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='336861' 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.
Connect with a Jackson Fuller real estate agent today and explore our 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] => 2023-09-21 16:41:01
[post_modified_gmt] => 2023-09-21 23:41:01
[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, 1507 Diamond Street, San Francisco, CA, 94131
ffd_mls_id, 423900035
ffd_salesforce_id, a0E8W00000cperQUAQ
num_of_fireplaces__c, 1
num_of_rooms__c, 7
of_units__c, 0
address2__c, 1507 Diamond Street, San Francisco, CA, 94131
pba__address_pb__c, 1507 Diamond Street, San Francisco, CA, 94131
agent_only_remarks__c, Showings 9am to 7pm (home is alarmed other times). Please notify Milana for showings and use Suprabox. Full Disclosure Package Available. Call/Text Milana 650.222.0706 or email [email protected]. Escrow Opened with WFG National Title Mary Ann Bunnell.
appliances__c, Dishwasher;Hood Over Range;Free Standing Refrigerator
pba__fullbathrooms_pb__c, 2
pba__bedrooms_pb__c, 4
year_build_text__c, 1912
pba__city_pb__c, San Francisco
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-08-26T02:48:56.000+0000
days_on_market__c, 20
dom__c, 20
ffd_description_pb, Rarely Available Combo of Views, Garden and Walkability. Wonderful, light-filled Noe Valley home tucked into a perfect walking location boasting both tranquil outdoor spaces and dramatic San Francisco views. Spacious 4 bedroom, 2.5 bath light and bright floorplan with great possibility for expansion. Modernized with ample windows and skylights, yet boasting period details create a lovely and vibrant atmosphere for Noe Valley living. Expansive main level with formal entry, formal living with built-ins and wood burning fireplace, formal dining with built-ins and deck, and naturally bright great room/kitchen with stainless steel appliances is ideal for entertaining and family gatherings. Ideal 3 bedrooms on upper level with Master enjoying stunning downtown views. Lower Level includes separate bedroom and bathroom ideal for home office or guest bedroom with adjacent huge basement. Easy walk to restaurants, shops, parks, public transportation and Whole Foods, this an incredible opportunity in one of San Francisco's most desirable neighborhoods and a Perfect Place to Call Home!
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Formal Entry;Skylight(s);Storage Area(s)
ffd_lastmodifieddate, 2023-09-13T01:46:31.000+0000
pba__latitude_pb__c, 37.74538
pba__latitude_property__c, 37.74538
laundry_features__c, In Basement;Washer Included;Dryer Included
listed_date__c, 2023-08-23
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Milana
pba__listing_agent_lastname__c, Ostroy
listing_agent_mls_id__c, 807049
ffd_listingagentname, Milana O Ostroy
listing_agent_number__c, 199018367
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, SRNO03
listing_office_name__c, Christie's International Real Estate Sereno
listing_office_number__c, 28805
pba__listingprice_pb__c, 2575000
pba__listingtype__c, Sale
pba__listing_website__c, http://www.diamondofnoevalley.com
pba__longitude_pb__c, -122.43542
mls_id__c, 423900035
master_bathroom_features__c, Tub;Skylight/Solar Tube
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 0
on_market_date__c, 2023-08-23
open_house_end__c, 2023-09-17T15:00:00.000+0000
open_house_start__c, 2023-09-17T13:00:00.000+0000
original_price__c, 2575000
overall_days_on_market__c, -81683
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, 1208.92
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000cperQUAQ
room_type__c, Kitchen;Living Room;Dining Room;Family Room
sale_date__c, 1800-01-01
sale_price__c, 0
security_features__c, Security System Owned
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, 2130
size__c, 2130
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, Diamond
subdist__c, Noe Valley
ffd_name, 1507 Diamond Street, San Francisco, CA, 94131
view__c, City Lights;Downtown
website_property_type__c, Single Family Home
pba__yearbuilt_pb__c, 1912
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530659955-1.jpg
