meta_query='key:subdist__c;value:Merced Manor|key:pba__status__c;value:Sold,Closed;compare:not in' post__not_in='370994' 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, 1706273837
ffd_listing_title, 3050 24th Avenue, San Francisco, CA, 94132
ffd_mls_id, 423926929
ffd_salesforce_id, a0EUd000000WDbdMAG
num_of_fireplaces__c, 2
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, Supra lock box will be installed by noon 12/17. Disclosure package can be download from MLS. Offers as it comes.
architectural_style__c, Tudor
pba__fullbathrooms_pb__c, 3
pba__bedrooms_pb__c, 3
year_build_text__c, 1936
pba__city_pb__c, San Francisco
listing_co_agent_name__c, Holly Phan
pba__contingentdate__c, 1800-01-01
ffd_createddate, 2023-12-17T11:46:41.000+0000
days_on_market__c, 40
dom__c, 3
ffd_description_pb, Prime opportunity for renovation: This elegant Tudor-style detached residence boasts formal living and dining areas, along with three generously sized bedrooms and two full baths on the main and upper levels. The garage level features a wet bar/family room and an additional full bath, complemented by two-car parking and tall ceiling. Ample vacant space adjacent to the parking area presents the potential for constructing additional rooms or utilizing it as storage space. Ideally situated near Stonestown shopping mall and Stern Grove recreation park, this property offers convenient access to public transportation and effortless entry to 19th Ave. Sell ASIS, buyers to cooperate with sellers'1031 exchange.
district__c, SF District 3
entry_level__c, 0
external_listing__c, 1
fireplace_features__c, Living Room;Wood Burning;Family Room;Stone
pba__floortype_pb__c, Tile;Wood
pba__hoafees__c, 0
hoa__c, No
pba__halfbathrooms_pb__c, 0
pba__heatingtype_pb__c, Central;Fireplace(s)
interior_features__c, Open Beam Ceiling
ffd_lastmodifieddate, 2024-01-26T12:46:50.000+0000
pba__latitude_pb__c, 37.7318141
pba__latitude_property__c, 37.7318141
laundry_features__c, Hookups Only
listed_date__c, 2023-04-08
pba__listing_agent_email__c, [email protected]
pba__listing_agent_firstname__c, Richard
pba__listing_agent_lastname__c, Woo
listing_agent_mls_id__c, 805732
ffd_listingagentname, Richard Woo
listing_agent_number__c, 166015766
listing_co_agent_mls_id__c, 397984
listing_co_agent_number__c, 397984
listing_co_office_mls_id__c, COMP3
listing_co_office_name__c, Compass
listing_co_office_number__c, 27342
listing_office_mls_id__c, COMP41
listing_office_name__c, Compass
listing_office_number__c, 27887
pba__listingprice_pb__c, 1850000
pba__listingtype__c, Sale
pba__longitude_pb__c, -122.4798381
lower_level__c, Family Room,Full Bath(s),Garage
mls_id__c, 423926929
main_level__c, Full Bath(s);Bedroom(s);Kitchen;Living Room;Dining Room
monthly_parking_fees__c, 0
monthlyrent__c, 0
parkingspaces__c, 2
on_market_date__c, 2023-12-17
original_price__c, 1850000
overall_days_on_market__c, -81799
parking_access__c, Side by Side
parking_features__c, Alley Access,Garage Door Opener,Garage Facing Rear
parking_type__c, On Site (Single Family Only)
pba__pendingdate__c, 2023-12-20
possible_bedrooms__c, 0
pba__pricechangedat__c, 2024-01-25T21:16:11.000+0000
price_per_square_foot__c, 695.79
pba__propertytype__c, Single Family Residence
ListingId, a0EUd000000WDbdMAG
room_type__c, Kitchen;Living Room;Baths Other;Dining Room;Family Room
sale_date__c, 2024-01-25
sale_price__c, 1800000
selling_agent_mls_id__c, 324325
selling_agent_number__c, 324325
selling_co_agent_number__c, 0
selling_co_office_number__c, 0
selling_office_name__c, Compass
pba__status__c, Closed
pba__totalarea_pb__c, 2587
size__c, 2587
pba__state_pb__c, CA
stories__c, 0
pba__street_pb__c, 24th
subdist__c, Merced Manor
ffd_name, 3050 24th Avenue, San Francisco, CA, 94132
website_property_type__c, Single Family Home
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/530713015-1.jpg