meta_query='key:subdist__c;value:Noe Valley|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='346261' 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-05-08 08:45:37
[post_modified_gmt] => 2024-05-08 15:45:37
[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, 1701346456
ffd_listing_title, 2412 Castro Street, San Francisco, CA, 94131
ffd_mls_id, 423917073
ffd_salesforce_id, a0E8W00000dwlp0UAA
num_of_fireplaces__c, 1
num_of_rooms__c, 5
of_units__c, 0
address2__c, 2412 Castro Street, San Francisco, CA, 94131
pba__address_pb__c, 2412 Castro Street, San Francisco, CA, 94131
agent_only_remarks__c, Offers are due on Wednesday, November 8th at 2 p.m. Vacant on Supra Lockbox. Go and Show anytime. Slide the lock cover to the side, insert the key into the deadbolt, and then turn to the left until the key won't turn any more. Sellers request you use the presale escrow with Joanne Kung at Chicago Title, Escrow # 36523006 415-252-2770 [email protected] Disclosures are on IO. If you have any trouble just use this link instead https://app.disclosures.io/link/2412-Castro-Street-hn10lcjo
appliances__c, Dishwasher;Microwave;Disposal;Hood Over Range;Tankless Water Heater;Free Standing Gas Range;Built-In Refrigerator
architectural_style__c, Mediterranean
bath_features__c, Shower Stall(s);Tub
pba__fullbathrooms_pb__c, 1
pba__bedrooms_pb__c, 2
year_build_text__c, 1936
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Jonathan Davis
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-10-26T18:47:54.000+0000
days_on_market__c, 35
dom__c, 13
ffd_description_pb, This Mediterranean bungalow offers the perfect blend of architectural charm, and modern function. It's located on a quiet, flat residential block that ends at Billy Goat Hill. From the living room and breakfast nook it boasts views of Bernal Hill, the city, the bay and Mt. Diablo. It features 2 ample sized bedrooms, an updated spa-quality bath, formal dining room, living room with vaulted ceiling and a gas fireplace, updated kitchen with high end, stainless steel appliances and a breakfast nook. The kitchen and bathroom have been remodeled, but the period details throughout the home have been preserved. Step out to the rear deck and terraced garden, which provide a wonderful outdoor space, especially with the west-facing orientation for enjoying the afternoon sun. The zen gardens in both the dining room and bathroom add a tranquil and serene touch to the living spaces. Imagine soaking in the deep tub while enjoying your garden just outside the window. It's a peaceful retreat in the comfort of your own home. The presence of skylights in the kitchen and hall is a thoughtful touch, providing ample natural light and further connecting the indoor spaces with the surrounding environment. Downstairs there is a cavernous garage with room for 3-4 cars and/or storage and/or workshop.
district__c, SF District 5
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Wood
fireplace_features__c, Living Room;Gas Piped
pba__floortype_pb__c, Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central;Natural Gas
interior_features__c, Skylight(s)
ffd_lastmodifieddate, 2023-11-30T11:47:42.000+0000
pba__latitude_pb__c, 37.7422132
pba__latitude_property__c, 37.7422132
laundry_features__c, In Garage;Washer Included;Dryer Included;Sink
listed_date__c, 2023-08-28
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Tim
pba__listing_agent_lastname__c, Gullicksen
listing_agent_mls_id__c, 802842
ffd_listingagentname, Tim J Gullicksen
listing_agent_number__c, 802842
listing_co_agent_mls_id__c, 803962
listing_co_agent_number__c, 166013341
listing_co_office_mls_id__c, CIP14
listing_co_office_name__c, Corcoran Icon Properties
listing_co_office_number__c, 28965
listing_office_mls_id__c, CIP14
listing_office_name__c, Corcoran Icon Properties
listing_office_number__c, 28965
pba__listingprice_pb__c, 1450000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=pKjxPLZ1mpm
pba__longitude_pb__c, -122.4334764
lower_level__c, Garage
mls_id__c, 423917073
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2023-10-26
original_price__c, 1450000
overall_days_on_market__c, -81747
parking_access__c, Tandem
parking_features__c, Garage Facing Front,Interior Access
parking_type__c, On Site (Single Family Only)
patio_and_porch_features__c, Uncovered Deck
pba__pendingdate__c, 2023-11-08
possible_bedrooms__c, 0
pba__pricechangedat__c, 2023-11-29T17:26:07.000+0000
price_per_square_foot__c, 1286.27
pba__propertytype__c, Single Family Residence
ListingId, a0E8W00000dwlp0UAA
roof__c, Tar/Gravel
room_type__c, Atrium
sale_date__c, 2023-11-29
sale_price__c, 1640000
security_features__c, Smoke Detector;Carbon Mon Detector
selling_agent_mls_id__c, 515087
selling_agent_number__c, 515087
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Corcoran Icon Properties
pba__status__c, Closed
pba__totalarea_pb__c, 1275
size__c, 1275
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, Castro
subdist__c, Noe Valley
ffd_name, 2412 Castro Street, San Francisco, CA, 94131
view__c, City Lights;Bay;Mt Diablo
website_property_type__c, Single Family Home
window_features__c, Window Screens
pba__yearbuilt_pb__c, 1936
pba__postalcode_pb__c, 94131
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530697330-1.jpg