meta_query='key:subdist__c;value:Merced Manor|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='378524' posts_per_page=4 post_type=property
bool(false)
Array
(
[ID] => 70660
[post_author] => 4
[post_date] => 2018-11-30 20:30:34
[post_date_gmt] => 2018-11-30 20:30:34
[post_content] => The most notable neighborhood feature is the eponymous reservoir. It's such a small rectangle of homes -- bounded by Eucalyptus, 19th Ave./CA-1, Sloat Blvd., and 26th Ave. -- that you'd be unlikely to know it's a distinct neighborhood unless you live there. Or you're reading this.
[post_title] => Merced Manor
[post_excerpt] =>
[post_status] => publish
[comment_status] => closed
[ping_status] => closed
[post_password] =>
[post_name] => merced-manor
[to_ping] =>
[pinged] =>
[post_modified] => 2024-04-12 12:26:09
[post_modified_gmt] => 2024-04-12 19:26:09
[post_content_filtered] =>
[post_parent] => 0
[guid] => http://jacksonfuller.com/?post_type=community&p=70660
[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, 1720954523
ffd_listing_title, 3050 24th Avenue, San Francisco, CA, 94132
ffd_mls_id, 424036939
ffd_salesforce_id, a0EUd0000029u3SMAQ
num_of_fireplaces__c, 0
num_of_rooms__c, 8
of_units__c, 0
address2__c, 3050 24th Avenue, San Francisco, CA, 94132
pba__address_pb__c, 3050 24th Avenue, San Francisco, CA, 94132
agent_only_remarks__c, Please call Charlene (415-608-8585) for showings and disclosures. All offers on SFAR Purchase Agreement please. 3 D Tour https://my.matterport.com/show/?m=ba958wsEuUv&mls=1
bath_features__c, Shower Stall(s);Double Sinks
pba__fullbathrooms_pb__c, 4
pba__bedrooms_pb__c, 4
year_build_text__c, 1936
pba__city_pb__c, San Francisco
pba__contingentdate__c, 2024-07-09
ffd_createddate, 2024-05-29T18:47:22.000+0000
days_on_market__c, 46
dom__c, 46
ffd_description_pb, Modern elegance meets classic San Francisco charm! This picturesque Tudor style home showcases the perfect balance of exquisite 1930s craftsmanship and tasteful, high-end updates. Upon stepping inside you'll be swept away by breathtaking vaulted ceilings and intricate moldings, while refined finishes like sweeping quartz counters, Oak floors, and White Carrera Marble create a sophisticated touch. With peek-a-boo views of the ocean and Sutro Tower from the top level, you'll enjoy waking up to beautiful San Francisco outlooks. Being fully detached, 3050 24th Avenue offers peaceful living amidst city conveniences. Whole Foods, Trader Joes, a playground, Lowell High School and a fantastic neighborhood Farmer's Market are all within just a few blocks, and commuting is made easy with close proximity to the 19th Avenue freeway entrance and multiple MUNI lines. The downstairs bedroom includes a kitchenette, bathroom, fireplace and separate entrance, making it a versatile space for guests or a family room. A spacious 3-car garage and outdoor seating in the backyard complete this gorgeous property. Don't miss out on this opportunity to make this stunning residence into your Foreverhome!
district__c, SF District 3
driveway_sidewalks__c, Paved Sidewalk
entry_level__c, 0
external_listing__c, 1
fencing__c, Back Yard;Front Yard
pba__floortype_pb__c, Tile;Vinyl;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
has_3d_tour__c, 1
pba__heatingtype_pb__c, Central
interior_features__c, Cathedral Ceiling;Open Beam Ceiling
ffd_lastmodifieddate, 2024-07-14T10:47:02.000+0000
pba__latitude_pb__c, 37.7318141
pba__latitude_property__c, 37.7318141
laundry_features__c, Laundry Closet;Hookups Only;In Basement;Upper Floor
listed_date__c, 2024-05-29
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Charlene
pba__listing_agent_lastname__c, Attard
listing_agent_mls_id__c, 324325
ffd_listingagentname, Charlene A Attard
listing_agent_number__c, 324325
listing_co_agent_number__c, 0
listing_co_office_number__c, 0
listing_office_mls_id__c, COMP90
listing_office_name__c, Compass
listing_office_number__c, 29048
pba__listingprice_pb__c, 2550000
pba__listingtype__c, Sale
pba__listing_website__c, https://my.matterport.com/show/?m=ba958wsEuUv&mls=1
pba__longitude_pb__c, -122.4798381
lower_level__c, Bedroom(s),Full Bath(s)
mls_id__c, 424036939
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room;Street Entrance
master_bathroom_features__c, Double Sinks
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 3
on_market_date__c, 2024-05-29
original_price__c, 2450000
overall_days_on_market__c, -81963
parking_access__c, Tandem
parking_features__c, Garage Door Opener
parking_type__c, On Site (Single Family Only)
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, 985.7
pba__propertytype__c, Single Family Residence
ListingId, a0EUd0000029u3SMAQ
room_type__c, Living Room;Dining Room
sale_date__c, 1800-01-01
sale_price__c, 0
selling_agent_number__c, 0
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
pba__status__c, Contingent - Show
pba__totalarea_pb__c, 2587
size__c, 2587
pba__state_pb__c, CA
stories__c, 3
pba__street_pb__c, 24th
subdist__c, Merced Manor
ffd_name, 3050 24th Avenue, San Francisco, CA, 94132
view__c, Ocean;Sutro Tower
website_property_type__c, Single Family Home
window_features__c, Dual Pane Full
pba__yearbuilt_pb__c, 1936
pba__postalcode_pb__c, 94132
ffd_media, Array
ffd_media_tags, Array
ffd_featured_image, https://s3-us-west-2.amazonaws.com/propbmedia/JacksonFuller/530785776-1.jpg